In [1]:
from __future__ import print_function
import couchdb
s=couchdb.Server('https://127.0.0.1/couchdb')
db=s['ucldc']
In [2]:
def histogram_field_value(field_path):
viewname = 'qa_reports/{0}_value'.format(field_path)
view=db.view(viewname, group_level=2)
reduced_list = [r for r in view]
reduced_list.sort(key=lambda row: -int(row['value']))
return reduced_list
In [3]:
hist_list = histogram_field_value('sourceResource.subject.name')
for row in hist_list:
if row['value'] > 1000:
print(row)
<Row key=[None, u'26094'], value=523318>
<Row key=[u'Dorothea Lange Collection', u'12378'], value=20820>
<Row key=[u"EASTMAN'S ORIGINALS COLLECTION", u'8'], value=13218>
<Row key=[u'Around the World (1958-1963)', u'12378'], value=6578>
<Row key=[u'Photographic Essays (1953-1959)', u'12378'], value=6569>
<Row key=[u'Maynard L. Parker negatives, photographs, and other material', u'14167'], value=6497>
<Row key=[u'Native Americans', u'14202'], value=5668>
<Row key=[u'Rock art series', u'14202'], value=5258>
<Row key=[u'Pomona Public Library - The Frasher Foto Postcard Collection', u'7781'], value=4964>
<Row key=[u'Daniel McCarthy Collection, 1970-1991', u'14202'], value=4809>
<Row key=[u'Early Years (1918-) Portraits & Lange Personal Photos', u'12378'], value=4777>
<Row key=[u'Herman Baca Papers', u'1412'], value=4343>
<Row key=[u'Dorothea Lange.s Personal Photographs', u'12378'], value=4250>
<Row key=[u'Trees', u'8'], value=3568>
<Row key=[u'People', u'8'], value=3542>
<Row key=[u'California Ethnographic Field Photographs', u'3453'], value=3305>
<Row key=[u'Mountains', u'8'], value=3250>
<Row key=[u'Automobiles', u'8'], value=2729>
<Row key=[u'Forests', u'8'], value=2526>
<Row key=[u'Ireland', u'12378'], value=2404>
<Row key=[u'California', u'14202'], value=2351>
<Row key=[u'Robert B. Honeyman, Jr. Collection of Early Californian and Western American Pictorial Material', u'141'], value=2270>
<Row key=[u'Egypt', u'12378'], value=2077>
<Row key=[u'Oliver family photograph collections', u'16189'], value=2046>
<Row key=[u'Museums and the Online Archive of California', u'16189'], value=2045>
<Row key=[u'Chinese in California', u'143'], value=2022>
<Row key=[u'Egypt - Untitled', u'12378'], value=1905>
<Row key=[u'Rosalie Ritz courtroom drawings', u'18427'], value=1831>
<Row key=[u'Trials--Pictorial works', u'18427'], value=1831>
<Row key=[u'Arnold Del Carlo Photograph Collection', u'5840'], value=1788>
<Row key=[u'Lone Mountain College Collection of Stereographs by Eadweard Muybridge', u'15426'], value=1727>
<Row key=[u'California Heritage Collection', u'15426'], value=1726>
<Row key=[u'Stores & shops', u'8'], value=1678>
<Row key=[u'Oxnard Heritage Digitization Project', u'16436'], value=1657>
<Row key=[u'Oxnard Public Library Photograph Collection', u'16436'], value=1657>
<Row key=[u'Photograph', u'16436'], value=1657>
<Row key=[u'Oxnard (Calif.)', u'16436'], value=1617>
<Row key=[u'Lakes & ponds', u'8'], value=1616>
<Row key=[u'Men', u'8'], value=1561>
<Row key=[u'Streets', u'8'], value=1540>
<Row key=[u'Johan Hagemeyer Photograph Collection', u'9181'], value=1500>
<Row key=[u'Museums and the Online Archive of California', u'9181'], value=1499>
<Row key=[u'Signs', u'8'], value=1451>
<Row key=[u'C. Hart Merriam Collection of Native American Photographs', u'14532'], value=1441>
<Row key=[u'Snow', u'8'], value=1402>
<Row key=[u'Riverside County (Calif.)', u'14202'], value=1376>
<Row key=[u'Clothing & dress', u'8'], value=1358>
<Row key=[u'Miscellaneous Bay Area', u'12378'], value=1335>
<Row key=[u'James D. Phelan Photograph Albums', u'17070'], value=1329>
<Row key=[u'Korea', u'12378'], value=1289>
<Row key=[u'Roads', u'8'], value=1279>
<Row key=[u'Roy D. Graves Pictorial Collection', u'8848'], value=1209>
<Row key=[u'SERIES 1: SAN FRANCISCO VIEWS', u'8848'], value=1209>
<Row key=[u'Sports & recreation facilities', u'8'], value=1198>
<Row key=[u'Series groupings', u'141'], value=1171>
<Row key=[u'Construction Photographs of the San Francisco-Oakland Bay Bridge', u'4991'], value=1161>
<Row key=[u'Three Mormon Towns', u'12378'], value=1130>
<Row key=[u'Resorts', u'8'], value=1070>
<Row key=[u'The Bancroft Library', u'143'], value=1069>
<Row key=[u'Stereographs of the West from The Bancroft Library Pictorial Collection', u'21830'], value=1018>
In [ ]:
Content source: mredar/ucldc_api_data_quality
Similar notebooks: