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

34 rows where status = "confident" sorted by rank descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: list_key, list_source, award_year, n_bibs_review

list_name 3

award_class 2

status 1

  • confident · 34 ✖
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
1 1 471ebc8b928378ebc322429ded60b75a b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1978 Bridge to Terabithia Katherine Paterson   1 0 7 confident 0 0
2 2 a7b113e73069a3ce14c8a925a9009526 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1939 Mr. Popper's Penguins Florence Atwater; Richard Atwater   1 0 4 confident 0 0
3 3 b74cc166d0136a6d85925523ceee9a42 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2009 The Graveyard Book Neil Gaiman   1 0 5 confident 0 0
23 23 76c30ecfd7cf23ebeceb36604b05c831 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2012 Dead End in Norvelt Jack Gantos   1 0 0 confident 0 0
33 33 7bfe5a18b52c9b497fac10b85ccf367e b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1955 The Wheel on the School Meindert DeJong   1 0 0 confident 0 0
34 34 b94cb60a27c0948cd5ab155569dc4810 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1987 The Whipping Boy Sid Fleischman   1 0 2 confident 0 0
38 38 4d012bf5132dd1139417762f7b13f366 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2016 Last Stop on Market Street Matt de la Peña   1 0 1 confident 0 0
61 61 698491cd018996b6b55b985f5046cb55 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1983 Dicey's Song Cynthia Voigt   1 0 1 confident 0 0
64 64 7a89cb5ad61e56fe35284851e3cf642b b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1937 Roller Skates Ruth Sawyer   1 0 1 confident 0 0
66 66 499a725fc02b8acb68a4f34755db7c34 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2000 26 Fairmount Avenue Tomie dePaola   1 0 0 confident 0 0
68 68 4dafe396d12cd72b4c56498d0f133b45 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1984 Dear Mr. Henshaw Beverly Cleary   1 0 3 confident 0 0
81 81 3dea0cd36fc5242b2120699e0d23956d b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1974 The Slave Dancer Paula Fox   1 0 1 confident 0 0
82 82 cc73eb8503c2a51d5eca04447bafc058 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1997 The View from Saturday E. L. Konigsburg   1 0 1 confident 0 0
85 85 caea1f4d4ef8942218ae405b29a11f86 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2012 Inside Out & Back Again Thanhha Lai   1 0 5 confident 0 0
86 86 548c3a624ee7d8ae14ef653450c9257c b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1989 Joyful Noise: Poems for Two Voices Paul Fleischman   1 0 0 confident 0 0
87 87 ed72a98881361ad5d9735c590e718ab0 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2007 Rules Cynthia Lord   1 0 3 confident 0 0
88 88 283746be0443bb209e3f3ccffb17441d b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1992 Shiloh Phyllis Reynolds Naylor   1 0 2 confident 0 0
91 91 406f52aa5fa6c48f08e49cfa2a03ef35 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2002 A Single Shard Linda Sue Park   1 0 2 confident 0 0
112 112 81cbdcd6384584ca674438d133416285 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1960 My Side of the Mountain Jean Craighead George   1 0 1 confident 0 0
115 115 83bcae289522a92e979bfb03def84960 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2000 Bud, Not Buddy Christopher Paul Curtis   1 0 2 confident 0 0
125 125 0331fbe71aeaab8b1b4546c79598103a a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2015 El Deafo Cece Bell   1 0 1 confident 0 0
130 130 096841efad0fbfa4e50555f1bc9c4add b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1938 The White Stag Kate Seredy   1 0 1 confident 0 0
131 131 019fa729f878c514984a33a2553d4253 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1995 Walk Two Moons Sharon Creech   1 0 5 confident 0 0
132 132 47ec609a38709550674a367bada10fd2 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2005 Kira-Kira Cynthia Kadohata   1 0 2 confident 0 0
136 136 50dab61529757d64d57f98131fc20b23 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1979 The Great Gilly Hopkins Katherine Paterson   1 0 2 confident 0 0
139 139 831324122bf4dc6f131fcac5d7796f0b b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1980 A Gathering of Days Joan Blos   1 0 1 confident 0 0
147 147 52ca6dc3efbbf859a979fa40950be473 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2008 Good Masters! Sweet Ladies! Voices from a Medieval Village Laura Amy Schlitz   1 0 0 confident 0 0
149 149 f024d20500c751680ba242f12692c376 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1962 The Bronze Bow Elizabeth George Speare   1 0 2 confident 0 0
150 150 42c135424fe5d0b584882003e33c4df4 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2007 The Higher Power of Lucky Susan Patron   1 0 1 confident 0 0
152 152 52fc5b310a956468bd093482193f06bd b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1973 Julie of the Wolves Jean Craighead George   1 0 5 confident 0 0
163 163 a3c41eaae84ce19ef1ec5ad4cc8e3a7b a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2022 A Snake Falls to Earth Darcie Little Badger   1 0 3 confident 0 0
164 164 d7afb073eef3d12278b2569fdb515ce2 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2008 Feathers Jacqueline Woodson   1 0 1 confident 0 0
165 165 8326714cf3eabd27162676b0d28c0c7a b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2011 Moon Over Manifest Clare Vanderpool   1 0 2 confident 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);