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

80 rows where award_class = "medal", list_name = "Newbery Medal" and status = "adjudicated" sorted by rank descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: n_bibs_review

status 1

  • adjudicated · 80 ✖

list_name 1

  • Newbery Medal · 80 ✖

award_class 1

  • medal · 80 ✖
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
4 4 2b62c6b6385607b5b35cef13952ee121 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1931 The Cat Who Went to Heaven Elizabeth Coatsworth   0 1 1 adjudicated 0 0
5 5 9330f82a0367afe2a9945e17389cad95 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1945 Rabbit Hill Robert Lawson   0 1 1 adjudicated 0 0
6 6 863a37ee26875f68bd5b23ff2ad99040 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1946 Strawberry Girl Lois Lenski   0 1 4 adjudicated 0 0
7 7 b9283fb22a5a03506b7ea6121e2a07ba b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1924 The Dark Frigate Charles Hawes   0 1 0 adjudicated 0 0
9 9 d1f3334ad46508e3dcaa1df15fd3fe81 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1930 Hitty, Her First Hundred Years Rachel Field   0 1 0 adjudicated 0 0
13 13 23788c2fd8a719b1750de8681d97d5ef b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2015 The Crossover Kwame Alexander   0 1 4 adjudicated 0 0
14 14 1c082649ffb1820e1364a2e8f1ab026a b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2022 The Last Cuentista Donna Barba Higuera   0 1 4 adjudicated 0 0
15 15 dcd9eee98275ccb1327a079060d18caa b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1923 The Voyages of Doctor Dolittle Hugh Lofting   0 1 3 adjudicated 0 0
16 16 4e7fc4a68478d5a3742194731b280d1b b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1964 It's Like This, Cat Emily Cheney Neville   0 1 1 adjudicated 0 0
17 17 bcb2fd20d68e06c4f1c7bac7da4ed366 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1977 Roll of Thunder, Hear My Cry Mildred D. Taylor   0 1 3 adjudicated 0 0
18 18 87070a18e42740d6550f142090ad5d03 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1970 Sounder William H. Armstrong   0 1 5 adjudicated 0 0
19 19 b45d2e2ceb1f39f7d4648638d365ebfa b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1976 The Grey King Susan Cooper   0 1 2 adjudicated 0 0
20 20 faf83c736d6787c4e592ad3cc762b53a b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1985 The Hero and the Crown Robin McKinley   0 1 3 adjudicated 0 0
21 21 90f6c8de639cccfe99df85ca67e44c9f b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1982 A Visit to William Blake's Inn Nancy Willard   0 1 5 adjudicated 0 0
22 22 7785c6795a0009ccfed896974d285ee7 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1941 Call It Courage Armstrong Sperry   0 1 1 adjudicated 0 0
26 26 0eaa2699daa9cc1b5f595c9f97962991 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1960 Onion John Joseph Krumgold   0 1 0 adjudicated 0 0
27 27 d327eb76eed9a8ee12a622feabb023c7 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1986 Sarah, Plain and Tall Patricia MacLachlan   0 1 4 adjudicated 0 0
29 29 1e6800b10c3c8359a982eb4fc57da228 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1932 Waterless Mountain Laura Adams Armer   0 1 0 adjudicated 0 0
30 30 5401a04eaab69d6340a71eb7a1662097 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2014 Flora & Ulysses Kate DiCamillo   0 1 1 adjudicated 0 0
32 32 30d8846617f4216788a49be61f5abaf0 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2023 Freewater Amina Luqman-Dawson   0 1 0 adjudicated 0 0
35 35 c7df65ead6b2952e911b345556e8de9c b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1939 Thimble Summer Elizabeth Enright   0 1 0 adjudicated 0 0
39 39 a141df0269b4fde47ee16555e53748c4 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1949 King of the Wind Marguerite Henry   0 1 1 adjudicated 0 0
40 40 6bfddc6b6339cc7421a2b86960462a00 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1971 Summer of the Swans Betsy Byars   0 1 1 adjudicated 0 0
41 41 54fba35e99e2dc22c0103a958d465c60 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1936 Caddie Woodlawn Carol Ryrie Brink   0 1 2 adjudicated 0 0
42 42 603ac4c1e63d8bafcaad06311fc5f149 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1961 Island of the Blue Dolphins Scott O'Dell   0 1 5 adjudicated 0 0
43 43 7b5d43501ce61e8335628db1b7aa9b7e b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1954 ...And Now Miguel Joseph Krumgold   0 1 0 adjudicated 0 0
44 44 3521a6e671fb26cd39fdbf4bfe1ef08b b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1956 Carry On, Mr. Bowditch Jean Lee Latham   0 1 1 adjudicated 0 0
46 46 7fcb121370c395a955c4b94f5f1ec143 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1947 Miss Hickory Carolyn Sherwin Bailey   0 1 1 adjudicated 0 0
47 47 9cb5227bed4258264a2e2881eb61c74c b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1990 Number the Stars Lois Lowry   0 1 4 adjudicated 0 0
49 49 be16adde656b9e6049b9db27503441a1 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1926 Shen of the Sea Arthur Bowie Chrisman   0 1 1 adjudicated 0 0
50 50 712f3db7cce2bfe35ac7800814d39c98 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1969 The High King Lloyd Alexander   0 1 0 adjudicated 0 0
52 52 0607f0ab64d39a539b03816bea84edfc b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1948 The Twenty-One Balloons William Pène du Bois   0 1 0 adjudicated 0 0
54 54 04d2959a64e7b923cdd3907290a8018a b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1996 The Midwife's Apprentice Karen Cushman   0 1 0 adjudicated 0 0
57 57 c3924871a20d041a4b256546a246a1a1 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2019 Merci Suárez Changes Gears Meg Medina   0 1 1 adjudicated 0 0
58 58 258a87a7620745e62b458b5e0aa35c34 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2020 New Kid Jerry Craft   0 1 2 adjudicated 0 0
59 59 1c26826b06aa1c222ef2c869d8cc42c8 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1933 Young Fu of the Upper Yangtze Elizabeth Foreman Lewis   0 1 0 adjudicated 0 0
60 60 993605885a9ac80a606a81d0834b843b b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2010 When You Reach Me Rebecca Stead   0 1 2 adjudicated 0 0
62 62 61eaa3cace85a7338010330f7fdef206 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1952 Ginger Pye Eleanor Estes   0 1 5 adjudicated 0 0
63 63 7d13075eff970b3cfeb4efd647a1546e b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1981 Jacob Have I Loved Katherine Paterson   0 1 1 adjudicated 0 0
67 67 1cbbebe1f022edc3f9b0a33cd476c5be b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1951 Amos Fortune, Free Man Elizabeth Yates   0 1 0 adjudicated 0 0
69 69 8cdd8dfcf555371e8393f8d738cf7525 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1999 Holes Louis Sachar   0 1 2 adjudicated 0 0
71 71 e879edcf5c65d00d80d74ac2137733d2 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1975 M. C. Higgins, the Great Virginia Hamilton   0 1 8 adjudicated 0 0
72 72 de06f039cd863b5ed1397d6e12f6bf5d b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1958 Rifles for Watie Harold Keith   0 1 0 adjudicated 0 0
76 76 86172247e7e385085ffc2cadd8c4f9e2 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1993 Missing May Cynthia Rylant   0 1 3 adjudicated 0 0
78 78 f8436b9542f10d7508f9fd7894c87ea7 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2018 Hello, Universe Erin Entrada Kelly   0 1 4 adjudicated 0 0
80 80 e245c279d71ab53f4ed8a713de8dd783 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2024 The Eyes and the Impossible Dave Eggers   0 1 6 adjudicated 0 0
89 89 6c65d2a6bd57a477c94a6491161f02c9 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1994 The Giver Lois Lowry   0 1 4 adjudicated 0 0
90 90 6878f1fc4da309260daacd7e81532897 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1968 From the Mixed-Up Files of Mrs. Basil E. Frankweiler E. L. Konigsburg   0 1 4 adjudicated 0 0
92 92 7e7b00170e2c2f4a8f03924f082184e9 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1966 I, Juan de Pareja Elizabeth Borton de Treviño   0 1 0 adjudicated 0 0
93 93 a46419c329903e16f28418e3234191ae b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2006 Criss Cross Lynne Rae Perkins   0 1 0 adjudicated 0 0
94 94 ba66b26eb1017217379bf7921317c07b b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1935 Dobry Monica Shannon   0 1 0 adjudicated 0 0
98 98 74104cfc4d7b2bf68ba758c385e6cc94 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1953 Secret of the Andes Ann Nolan Clark   0 1 0 adjudicated 0 0
99 99 5c7b1ec88b37f9d1e283bdc0d7129a36 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1950 The Door in the Wall Marguerite de Angeli   0 1 0 adjudicated 0 0
103 103 a0a54dd69411ff4ddf94c72f25f401e6 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2017 The Girl Who Drank the Moon Kelly Barnhill   0 1 4 adjudicated 0 0
105 105 5cb7678f78f8a2b2bdc058ddcd8e0aa6 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2021 When You Trap a Tiger Tae Keller   0 1 1 adjudicated 0 0
109 109 308dc7f2a5cf18d1975f3a7a74361edd b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1965 Shadow of a Bull Maia Wojciechowska   0 1 0 adjudicated 0 0
110 110 a6db4c049ee18e5340fc4569972f79d8 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1942 The Matchlock Gun Walter D. Edmonds   0 1 0 adjudicated 0 0
113 113 44d5488389cb23f1106ada76a0221b73 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1979 The Westing Game Ellen Raskin   0 1 2 adjudicated 0 0
114 114 430048a5172c50f4005ca247343571ad b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1943 Adam of the Road Elizabeth Gray Vining   0 1 0 adjudicated 0 0
116 116 f41c87d1c58c8bd88df33595bc187794 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2003 Crispin: The Cross of Lead Avi   0 1 1 adjudicated 0 0
118 118 63fc3f0b5f117c30ef0625e7502bb1ca b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1998 Out of the Dust Karen Hesse   0 1 2 adjudicated 0 0
119 119 9f70a1e53671abaea83785370cb7fbfd b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1927 Smoky, the Cowhorse Will James   0 1 1 adjudicated 0 0
120 120 cc396d51e2eefb936343e960f82f9dcd b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2013 The One and Only Ivan Katherine Applegate   0 1 5 adjudicated 0 0
121 121 78fa459cb314308791dc01c42ab26ff7 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1922 The Story of Mankind Hendrik Willem van Loon   0 1 7 adjudicated 0 0
122 122 eb668e2221f25ac0dfe0d534d46abc17 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1925 Tales from Silver Lands Charles J. Finger   0 1 1 adjudicated 0 0
123 123 d6c6ec310ac1e52a6a66d6bda97f9cfd b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1934 Invincible Louisa: the Story of the Author of Little Women Cornelia Meigs   0 1 5 adjudicated 0 0
129 129 83dabce1c1a993fd4c3c8042cf1fef76 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1929 The Trumpeter of Krakow Eric P. Kelly   0 1 0 adjudicated 0 0
134 134 d0ada91d0ff3358629d6fc5d1b60df57 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1957 Miracles on Maple Hill Virginia Sorensen   0 1 3 adjudicated 0 0
138 138 16dd05f4e57fef2d4f9ab89991308733 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1963 A Wrinkle in Time Madeleine L'Engle   0 1 4 adjudicated 0 0
140 140 2521bcc7881f6d728d03145089d0a58d b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1940 Daniel Boone James Daugherty   0 1 0 adjudicated 0 0
141 141 f580929575e0ce0c4a08688b2619213c b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1928 Gay-Neck, the Story of a Pigeon Dhan Gopal Mukerji   0 1 0 adjudicated 0 0
144 144 f57c9d0e5429b18c0beed1f15c88b9a7 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1991 Maniac Magee Jerry Spinelli   0 1 0 adjudicated 0 0
145 145 fdad1bf745c5e517d80b36624d6e7f09 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1967 Up a Road Slowly Irene Hunt   0 1 0 adjudicated 0 0
148 148 488d5898265c8c05d20a418aea459d1e b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1988 Lincoln: A Photobiography Russell Freedman   0 1 0 adjudicated 0 0
151 151 f015e6dd0d61eb02493155555c579569 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2025 The First State of Being Erin Entrada Kelly   0 1 1 adjudicated 0 0
153 153 6cb5acc7f4f40d4a64dc79aea359fae3 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2001 A Year Down Yonder Richard Peck   0 1 1 adjudicated 0 0
157 157 3db1d55a49cb1a11781a770a1e714b02 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 2004 The Tale of Despereaux Kate DiCamillo   0 1 3 adjudicated 0 0
158 158 109783423fefed7c7e43a3a0e1078514 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1944 Johnny Tremain Esther Forbes   0 1 2 adjudicated 0 0
162 162 f3110e1cbe232621641f1d7e57d9de87 b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1959 The Witch of Blackbird Pond Elizabeth George Speare   0 1 4 adjudicated 0 0
166 166 5f5978bac22e3ff3fd1b547e5419c31f b2ac76f948602b239df4ce08ca6429b0   newbery Newbery Medal         medal 1972 Mrs. Frisby and the Rats of NIMH Robert C. O'Brien   0 1 2 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);