List entries (one row per title)

Each curated-list title with its match status and bib counts. Filter by list_name to see one list's titles.

Data source: chimpy-lake reading_lists_match gold

list_name
Which list this title belongs to
status
confident (ISBN/OCLC match) / adjudicated (librarian-confirmed) / review (awaiting verdict) / gap (no match in catalog)
n_bibs_confident
distinct catalog bibs matched by ISBN/OCLC
n_bibs_review
distinct bibs matched only by fuzzy title/author

3 rows where list_name = "Sample Newbery Starter" sorted by rank descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: n_bibs_confident, n_bibs_adjudicated

status 2

list_name 1

  • Sample Newbery Starter · 3 ✖

award_class 0

Link rowid list_entry_id list_key list_id list_source list_name curator source_kind source_detail attributes award_class award_year title author rank ▲ n_bibs_confident n_bibs_adjudicated n_bibs_review status confirmed_absent is_gap
167 167 946278514ee05e9592bfe3d506c7ceac sample-newbery-starter sample-newbery-starter manual Sample Newbery Starter reading-lists demo manual hand-authored sample shipped with the tenant {"age_band": "grades 4-6", "purpose": "demo"}     Holes Louis Sachar   0 1 2 adjudicated 0 0
168 168 126590e01ac0bc6ececda395c613e6f6 sample-newbery-starter sample-newbery-starter manual Sample Newbery Starter reading-lists demo manual hand-authored sample shipped with the tenant {"age_band": "grades 4-6", "purpose": "demo"}     Bridge to Terabithia Katherine Paterson   0 1 7 adjudicated 0 0
169 169 8f0eddd14e1477438c5cf5222f33a767 sample-newbery-starter sample-newbery-starter manual Sample Newbery Starter reading-lists demo manual hand-authored sample shipped with the tenant {"age_band": "grades 4-6", "purpose": "demo"}     The Giver Lois Lowry   1 0 4 confident 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE list_entry_summary(list_entry_id VARCHAR, list_key VARCHAR, list_id VARCHAR, list_source VARCHAR, list_name VARCHAR, curator VARCHAR, source_kind VARCHAR, source_detail VARCHAR, attributes VARCHAR, award_class VARCHAR, award_year BIGINT, title VARCHAR, author VARCHAR, rank BIGINT, n_bibs_confident BIGINT, n_bibs_adjudicated BIGINT, n_bibs_review BIGINT, status VARCHAR, confirmed_absent BIGINT, is_gap BIGINT);
CREATE INDEX idx_list_entry_summary_status on list_entry_summary(status);
CREATE INDEX idx_list_entry_summary_list_name_award_class on list_entry_summary(list_name, award_class);
CREATE INDEX idx_list_entry_summary_list_key on list_entry_summary(list_key);