collection-2021-01-04
Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/
bib
bib_record_num, creation_date, record_last_updated, isbn, best_author, best_title, publisher, publish_year, bib_level_callnumber, indexed_subjects
1,985,376 rows
bib_record_item_record_link
id, bib_record_id, item_record_id, items_display_order, bibs_display_order
5,511,670 rows
branch
id, address, email_source, email_reply_to, address_latitude, address_longitude, code_num
52 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
5,515,381 rows
itype_property_myuser
code, display_order, itype_property_category_id, physical_format_id, target_audience_id, name
115 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,088 rows
Download SQLite DB: collection-2021-01-04.db 6.0 GB