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

8 rows where award_class = "honor", list_name = "Newbery Honor" and status = "gap" sorted by rank descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: award_year, n_bibs_review, confirmed_absent

status 1

list_name 1

  • Newbery Honor · 8 ✖

award_class 1

  • honor · 8 ✖
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
170 170 a4e7c37e4c5ddc2110078a08b3f6f2dc a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1930 Pran of Albania Elizabeth Cleveland Miller   0 0 1 gap 1 1
171 171 a3de1d913e0a144b232cd96ce4b77d8e a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1932 The Fairy Circus Dorothy P. Lathrop   0 0 8 gap 1 1
172 172 acdddd0c91f17bf2fe2a4cf0a90c3f99 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1930 Little Blacknose Hildegarde Hoyt Swift   0 0 1 gap 1 1
173 173 268903c68cf2577ffbf62fd30835ed89 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1931 Mountains Are Free Julia Davis Adams   0 0 1 gap 1 1
174 174 947ce59113214b4ff0d73cc41e7398d7 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1930 The Dark Star of Itza, The Story of A Pagan Princess Alida Malkus   0 0 3 gap 1 1
175 175 68a63b95be47c235a78df5981936932e a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1931 Queer Person Ralph Hubbard   0 0 2 gap 1 1
176 176 15a4810b8857523ae1696855ba80acac a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1931 Garram the Hunter, A Boy of the Hill Tribes Herbert Best   0 0 0 gap 0 1
177 177 977fbf09ef281fbe846aba68652740d6 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1931 Ood-le-uk the Wanderer Alice Alison Lide; Margaret Alison Johansen   0 0 0 gap 0 1

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);