collection

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

active_items

bib_record_num, item_record_num, volume_record_num, volume_statement, items_display_order

3,409,438 rows

bib

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

2,106,110 rows

id, record_id, language_code, bcode1, bcode2, bcode3, country_code, index_change_count, is_on_course_reserve, is_right_result_exact, allocation_rule_code, skip_num, cataloging_date_gmt, marc_type_code, is_suppressed

2,106,354 rows

bib_record_item_record_link

id, bib_record_id, bib_record_num, item_record_id, item_record_num, items_display_order, bibs_display_order

6,222,503 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

hold

hold_id, bib_record_num, campus_code, record_type_on_hold, item_record_num, volume_record_num, placed_gmt, is_frozen, delay_days, location_code, expires_gmt, hold_status, is_ir, is_ill, pickup_location_code, ir_pickup_location_code, ir_print_name, ir_delivery_stop_name, is_ir_converted_request, patron_is_active, patron_ptype_code, patron_home_library_code, patron_mblock_code, patron_has_over_10usd_owed

155,155 rows

holds_shelf

hold_id, local_hold_id, hash_row, placed_epoch, patron_record_hash, record_id, record_type_code, record_num, item_location_code, agency_code_num, checkin_statistics_group_code_num, checkin_statistics_group_name, s_location_code, expires_epoch, status, pickup_location_code, is_deleted, deleted_epoch, modified_epoch

7,174,297 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,703,117 rows

item_status_property_myuser

code, display_order, name

31 rows

itype_property_myuser

code, display_order, itype_property_category_id, physical_format_id, target_audience_id, name

117 rows

language_property

id, code, display_order, name

485 rows

location

id, code, branch_code_num, parent_location_code, is_public, is_requestable

3,009 rows

location_name

location_id, name, iii_language_id

3,009 rows

material_property_myuser

code, display_order, is_public, material_property_category_id, physical_format_id, name

28 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

7,454,081 rows

... and 5 hidden tables

Download SQLite DB: collection_prev.db 10.4 GB

collection_prev

Custom SQL query

active_holds