Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/

Custom SQL query

bib

bib_record_num, creation_date, record_last_updated, isbn, best_author, best_title, publisher, publish_year, bib_level_callnumber, indexed_subjects

2,192,490 rows

bib_record_item_record_link

id, bib_record_id, item_record_id, items_display_order, bibs_display_order

5,511,682 rows

branch

id, address, email_source, email_reply_to, address_latitude, address_longitude, code_num

52 rows

branch_name

branch_id, name, iii_language_id

52 rows

country_property_myuser

code, display_order, name

333 rows

item

item_record_num, bib_record_num, creation_date, record_last_updated, barcode, agency_code_num, location_code, checkout_statistic_group_code_num, checkin_statistics_group_code_num, checkout_date, due_date, patron_branch_code, last_checkout_date, last_checkin_date, checkout_total, renewal_total, isbn, item_format, item_status_code, price_cents, item_callnumber

6,018,901 rows

itype_property_myuser

code, display_order, itype_property_category_id, physical_format_id, target_audience_id, name

115 rows

location

id, code, branch_code_num, parent_location_code, is_public, is_requestable

2,976 rows

location_name

location_id, name, iii_language_id

2,976 rows

phrase_entry

id, record_id, index_tag, varfield_type_code, occurrence, is_permuted, type2, type3, index_entry, insert_title, phrase_rule_rule_num, phrase_rule_operation, phrase_rule_subfield_list, original_content, parent_record_id, insert_title_tag, insert_title_occ

6,830,621 rows

record_metadata

id, record_type_code, record_num, creation_date_gmt, campus_code, agency_code_num, record_last_updated_gmt

7,850,101 rows

Download SQLite DB: collection-2020-01-06.db 6.2 GB