Current Collection Data Set

The "current_collection" dataset reprsents the current collection state for the Cincinnati & Hamilton County Public Library as of 2022-03-08

Documentation, Static Queries, and Reports can be found in the "data source"

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

_memory

0 tables

current_collection

49,024,446 rows in 22 tables, 4,324,100 rows in 5 hidden tables

record_metadata, phrase_entry, holds_shelf, bib_record_item_record_link, item, ...

collection_prev

49,113,117 rows in 22 tables, 4,324,688 rows in 5 hidden tables

record_metadata, phrase_entry, holds_shelf, bib_record_item_record_link, item, ...

collection-2022-01-03

48,767,439 rows in 22 tables, 4,314,767 rows in 5 hidden tables

record_metadata, phrase_entry, holds_shelf, bib_record_item_record_link, item, ...

collection-2021-01-04

27,699,640 rows in 11 tables

record_metadata, phrase_entry, item, bib_record_item_record_link, bib, ...

collection-2020-01-06

28,410,299 rows in 11 tables

record_metadata, phrase_entry, item, bib_record_item_record_link, bib, ...