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

53 rows where list_name = "Newbery Honor" and status = "adjudicated" sorted by rank descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: award_year, n_bibs_review

status 1

  • adjudicated · 53 ✖

list_name 1

  • Newbery Honor · 53 ✖

award_class 1

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
8 8 efa3941f371dc3a22640f0595b99d57e a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1975 The Perilous Gard Elizabeth Marie Pope   0 1 0 adjudicated 0 0
10 10 2eab0c55a3c7b95dd8c415bc623bf55b a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2014 Doll Bones Holly Black   0 1 1 adjudicated 0 0
11 11 1e2a1ebf69fd6f7a193e94a25444184c a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2014 Paperboy Vince Vawter   0 1 0 adjudicated 0 0
12 12 8bb69c81cea75c8f0f0bdd6dced515de a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2011 Heart of a Samurai Margi Preus   0 1 1 adjudicated 0 0
24 24 b70f91b799102ad2906dd67f3d8964e3 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1997 A Girl Named Disaster Nancy Farmer   0 1 0 adjudicated 0 0
25 25 a3f8ec7f523f767cf7e99017ec89b447 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2007 Hattie Big Sky Kirby Larson   0 1 0 adjudicated 0 0
28 28 6ebc356878bed1b50cc43549edaf7102 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1929 The Pigtail of Ah Lee Ben Loo John Bennett   0 1 0 adjudicated 0 0
31 31 fda08d33b4a818a61587c25aff16de51 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2016 The War That Saved My Life Kimberly Brubaker Bradley   0 1 1 adjudicated 0 0
36 36 0fb7dae416378ce67960110bd4c12795 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2011 Turtle in Paradise Jennifer L. Holm   0 1 1 adjudicated 0 0
37 37 332207e68bb8285655f2eb738cb50f59 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2006 Whittington Alan Armstrong   0 1 3 adjudicated 0 0
45 45 bd55550287f832c84d80ef67c5351ec1 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1931 Floating Island Anne Parrish   0 1 0 adjudicated 0 0
48 48 c728826463e31976fd267128f9e60006 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1937 Phebe Fairchild: Her Book Lois Lenski   0 1 0 adjudicated 0 0
51 51 fe7d8fede14c9f1c492a7f23d82f34b4 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2010 The Mostly True Adventures of Homer P. Figg Rodman Philbrick   0 1 2 adjudicated 0 0
53 53 00f5562649ef08dd1a2ef44bb43ed623 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2008 The Wednesday Wars Gary D. Schmidt   0 1 2 adjudicated 0 0
55 55 1f4cbbf0e7c471c1301d0e7d00f5a3ec a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2011 Dark Emperor & Other Poems of the Night Joyce Sidman   0 1 2 adjudicated 0 0
56 56 c4f960b74f655b068e2c68292e332f9b a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2011 One Crazy Summer Rita Williams-Garcia   0 1 5 adjudicated 0 0
65 65 e040e70524228f371d83d8027852daf4 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2021 Fighting Words Kimberly Brubaker Bradley   0 1 2 adjudicated 0 0
70 70 0ca21f15049e3b01ceb00c77c26fb7b2 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1937 Audubon Constance Rourke   0 1 1 adjudicated 0 0
73 73 5520535b0b5860868723e8d287fc4a1f a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1936 Young Walter Scott Elizabeth Gray Vining   0 1 0 adjudicated 0 0
74 74 51210f4c2cd23e06eb44b10511fac2f0 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1925 Nicholas; A Manhattan Christmas Story Anne Carroll Moore   0 1 0 adjudicated 0 0
75 75 ab4b53f49fe95d25f09518b83f5d61de a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2009 The Underneath Kathi Appelt   0 1 1 adjudicated 0 0
77 77 06599b2f84abbd3dc0320843258142fb a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2014 The Year of Billy Miller Kevin Henkes   0 1 2 adjudicated 0 0
79 79 3c312f0a019d79f90ae41d6fb6fc33bc a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2020 Other Words for Home Jasmine Warga   0 1 5 adjudicated 0 0
83 83 5bb53e40c7063ebc28d7149d31ab6013 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2009 After Tupac and D Foster Jacqueline Woodson   0 1 6 adjudicated 0 0
84 84 c81dae90cef9001a506967853bbdf853 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1972 Annie and the Old One Miska Miles   0 1 0 adjudicated 0 0
95 95 23ae0aee7a7374a627267108479d02b9 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1942 Indian Captive Lois Lenski   0 1 4 adjudicated 0 0
96 96 58d6b6d4039f6f5a41082b54a9e63b7b a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1931 Meggy MacIntosh Elizabeth Gray Vining   0 1 0 adjudicated 0 0
97 97 041e9430ea47fdeaa86cc45997a3f396 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2004 Olive's Ocean Kevin Henkes   0 1 2 adjudicated 0 0
100 100 5f336f4ca9f88ba92a4dd66886d9c59e a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1971 Sing Down the Moon Scott O'Dell   0 1 1 adjudicated 0 0
101 101 50a02e661405dd59bcee0d904318a49d a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2012 Breaking Stalin's Nose Eugene Yelchin   0 1 1 adjudicated 0 0
102 102 d9ce6ee47822747869ba0ef6f616b416 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2014 One Came Home Amy Timberlake   0 1 1 adjudicated 0 0
104 104 dbf96c8fa8238e065e90cbde05243997 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2020 Scary Stories for Young Foxes Christian McKay Heidicker   0 1 0 adjudicated 0 0
106 106 fd4351994ff12a03a09532aa8675b827 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2022 Too Bright to See Kyle Lukoff   0 1 1 adjudicated 0 0
107 107 a90da0dc6a575ff669a9e95f97a0d812 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2017 The Inquisitor's Tale Adam Gidwitz   0 1 9 adjudicated 0 0
108 108 eb6b51bc61cf5ba733e2c6d462357826 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2009 Savvy Ingrid Law   0 1 0 adjudicated 0 0
111 111 47a61b31906296754e458636601dfd06 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2023 Iveliz Explains It All     0 1 0 adjudicated 0 0
117 117 bf29ea464c53b4894a8e50c7e7e16c68 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1976 Dragonwings Laurence Yep   0 1 1 adjudicated 0 0
124 124 270ae28d9fb389bf98064369278c2a74 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2013 Bomb: The Race to Build -and Steal- the World's Most Dangerous Weapon Steve Sheinkin   0 1 1 adjudicated 0 0
126 126 034e89e9b2615868d3b36f5a38fc26d9 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2009 The Surrender Tree: Poems of Cuba's Struggle for Freedom Margarita Engle   0 1 0 adjudicated 0 0
127 127 cd9e843da53135db121d366d5dc6333a a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2021 All Thirteen: The Incredible Cave Rescue of the Thai Boys' Soccer Team Christina Soontornvat   0 1 1 adjudicated 0 0
128 128 8f58a791070048faf4243d5d05189635 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2022 Watercress Andrea Wang   0 1 1 adjudicated 0 0
133 133 bffd31bcac05e5f1da6d2c5a261c204b a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1929 Millions of Cats Wanda Gág   0 1 1 adjudicated 0 0
135 135 5c0b783687fce2eb80eb98f9722a4d69 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2010 The Evolution of Calpurnia Tate Jacqueline Kelly   0 1 1 adjudicated 0 0
137 137 d99a5545e2ad163bb2f3cbfe6af0c62b a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1972 The Tombs of Atuan Ursula K. Le Guin   0 1 3 adjudicated 0 0
142 142 0dcfda8374778f0b66941e6eeb7a54e7 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1931 Spice and the Devil's Cave Agnes Hewes   0 1 0 adjudicated 0 0
143 143 9c6e469ffd110db90dc529102a1529b8 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2010 Where the Mountain Meets the Moon Grace Lin   0 1 2 adjudicated 0 0
146 146 413c678d2c2aad62ed16b4852addbbf9 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2013 Three Times Lucky Sheila Turnage   0 1 1 adjudicated 0 0
154 154 b26e16bc918d6b651a9fe56f7d9fea59 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2007 Penny from Heaven Jennifer L. Holm   0 1 1 adjudicated 0 0
155 155 ed66ebd59912a18072caedbfd2a65f96 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 1929 The Runaway Papoose Grace Moon   0 1 0 adjudicated 0 0
156 156 2659c59591db4c7e048901d38c3b275d a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2008 Elijah of Buxton Christopher Paul Curtis   0 1 3 adjudicated 0 0
159 159 db1dcbbb89fc98c684709ae11d7c73e0 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2013 Splendors and Glooms Laura Amy Schlitz   0 1 1 adjudicated 0 0
160 160 34b67bd5c3b99de01f14c99a27aa31e7 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2015 Brown Girl Dreaming Jacqueline Woodson   0 1 2 adjudicated 0 0
161 161 cecfbc1f27a1cf8df08ed04f991dc263 a224c8bac08ac225b33db69c12a5f899   newbery Newbery Honor         honor 2018 Piecing Me Together Renée Watson   0 1 0 adjudicated 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);