reading_lists: list_entry_display: 169 rows where status_label = "Available at CHPL ✓" sorted by title

The full underlying row behind the Showcase and Educator-detail views, with internal keys. Most people want Showcase or Educator detail instead.

Data source: chimpy-lake reading_lists_match gold

cover_isbn: Cover
title: Title
author: Author
status_label: At CHPL?
catalog_url: Find it
award_class: Medal or Honor
award_year: Award year
pub_year: Published (the edition we own)
format: Format
call_number: Call number (shelf location)
list_name: List

169 rows where status_label = "Available at CHPL ✓" sorted by title

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	list_entry_id	list_key	list_name	title ▼	author	award_class	award_year	status_label	catalog_url	pub_year	format	call_number	bib_id
58	58	7b5d43501ce61e8335628db1b7aa9b7e	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	...And Now Miguel	Joseph Krumgold	medal	1954	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2100381	1953	Book	Fiction	2100381
78	78	499a725fc02b8acb68a4f34755db7c34	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	26 Fairmount Avenue	Tomie dePaola	honor	2000	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1938653	1999	Book	813.54 D419Zde 1999	1938653
104	104	831324122bf4dc6f131fcac5d7796f0b	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	A Gathering of Days	Joan Blos	medal	1980	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2168245	1979	Book	PZ7.B6237 Gat	2168245
145	145	b70f91b799102ad2906dd67f3d8964e3	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	A Girl Named Disaster	Nancy Farmer	honor	1997	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1721055	1996	Book	Fiction	1721055
138	138	406f52aa5fa6c48f08e49cfa2a03ef35	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	A Single Shard	Linda Sue Park	medal	2002	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1773618	2001	Book	Fiction	1773618
107	107	a3c41eaae84ce19ef1ec5ad4cc8e3a7b	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	A Snake Falls to Earth	Darcie Little Badger	honor	2022	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3683659	2021	Book	Fiction	3683659
77	77	90f6c8de639cccfe99df85ca67e44c9f	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	A Visit to William Blake's Inn	Nancy Willard	medal	1982	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2253746	1981	Book	811.54 qW694v	2253746
101	101	16dd05f4e57fef2d4f9ab89991308733	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	A Wrinkle in Time	Madeleine L'Engle	medal	1963	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1821767	1994	Audiobook CD	CDW 00540	1821767
137	137	6cb5acc7f4f40d4a64dc79aea359fae3	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	A Year Down Yonder	Richard Peck	medal	2001	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1859226	2000	Book	Fiction	1859226
43	43	430048a5172c50f4005ca247343571ad	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Adam of the Road	Elizabeth Gray Vining	medal	1943	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2002526	1942	Book	Fiction	2002526
117	117	5bb53e40c7063ebc28d7149d31ab6013	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	After Tupac and D Foster	Jacqueline Woodson	honor	2009	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2569737	2008	Book	Fiction	2569737
129	129	cd9e843da53135db121d366d5dc6333a	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	All Thirteen: The Incredible Cave Rescue of the Thai Boys' Soccer Team	Christina Soontornvat	honor	2021	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3550294	2020	Book	796.525095 qS711 2020	3550294
152	152	1cbbebe1f022edc3f9b0a33cd476c5be	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Amos Fortune, Free Man	Elizabeth Yates	medal	1951	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2060408	1950	Book	326.092 F745Zy, 1950	2060408
88	88	c81dae90cef9001a506967853bbdf853	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Annie and the Old One	Miska Miles	honor	1972	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2142824	1971	Book	Fiction	2142824
159	159	0ca21f15049e3b01ceb00c77c26fb7b2	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Audubon	Constance Rourke	honor	1937	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1030724	1964	Large Print	598.2092 qA916Zr, 1964	1030724
25	25	270ae28d9fb389bf98064369278c2a74	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Bomb: The Race to Build -and Steal- the World's Most Dangerous Weapon	Steve Sheinkin	honor	2013	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2794735	2012	Book	623.45119 S543 2012	2794735
54	54	50a02e661405dd59bcee0d904318a49d	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Breaking Stalin's Nose	Eugene Yelchin	honor	2012	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2773550	2011	Book	Fiction	2773550
32	32	471ebc8b928378ebc322429ded60b75a	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Bridge to Terabithia	Katherine Paterson	medal	1978	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2538132	1977	Book	Fiction	2538132
165	165	126590e01ac0bc6ececda395c613e6f6	sample-newbery-starter	Sample Newbery Starter	Bridge to Terabithia	Katherine Paterson			Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1753737	1996	Audiobook CD	CD-Spoken Fiction Paterson	1753737
56	56	34b67bd5c3b99de01f14c99a27aa31e7	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Brown Girl Dreaming	Jacqueline Woodson	honor	2015	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2972252	2014	Book	811.54 W898Zw 2014	2972252
3	3	83bcae289522a92e979bfb03def84960	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Bud, Not Buddy	Christopher Paul Curtis	medal	2000	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1946139	1999	Book	Fiction	1946139
63	63	54fba35e99e2dc22c0103a958d465c60	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Caddie Woodlawn	Carol Ryrie Brink	medal	1936	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1015793		LP		1015793
6	6	7785c6795a0009ccfed896974d285ee7	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Call It Courage	Armstrong Sperry	medal	1941	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1001068	1989	Large Print	Fiction	1001068
113	113	3521a6e671fb26cd39fdbf4bfe1ef08b	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Carry On, Mr. Bowditch	Jean Lee Latham	medal	1956	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2124312	1955	Book	527.092 B785ZL, 1955	2124312
18	18	f41c87d1c58c8bd88df33595bc187794	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Crispin: The Cross of Lead	Avi	medal	2003	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1819030	2002	Book	Fiction	1819030
136	136	a46419c329903e16f28418e3234191ae	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Criss Cross	Lynne Rae Perkins	medal	2006	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2679648	2005	Book	Fiction	2679648
127	127	2521bcc7881f6d728d03145089d0a58d	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Daniel Boone	James Daugherty	medal	1940	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2435037	1939	Book	976.902092 qB724Zda, 1939	2435037
131	131	1f4cbbf0e7c471c1301d0e7d00f5a3ec	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Dark Emperor & Other Poems of the Night	Joyce Sidman	honor	2011	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2571011	2010	Book	811.54 qS568d 2010	2571011
147	147	76c30ecfd7cf23ebeceb36604b05c831	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Dead End in Norvelt	Jack Gantos	medal	2012	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2757319	2011	Book	Fiction	2757319
85	85	4dafe396d12cd72b4c56498d0f133b45	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Dear Mr. Henshaw	Beverly Cleary	medal	1984	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2449285	1983	Book	Fiction	2449285
106	106	698491cd018996b6b55b985f5046cb55	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Dicey's Song	Cynthia Voigt	medal	1983	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1041424	1982	Book	Fiction	1041424
98	98	ba66b26eb1017217379bf7921317c07b	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Dobry	Monica Shannon	medal	1935	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2403237	1962	Book	Fiction	2403237
62	62	2eab0c55a3c7b95dd8c415bc623bf55b	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Doll Bones	Holly Black	honor	2014	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2841721	2013	Book	Fiction	2841721
133	133	bf29ea464c53b4894a8e50c7e7e16c68	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Dragonwings	Laurence Yep	honor	1976	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1239486	1990	Large Print	Fiction	1239486
44	44	0331fbe71aeaab8b1b4546c79598103a	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	El Deafo	Cece Bell	honor	2015	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2985569	2014	Book	741.5 B4331Zb 2014	2985569
59	59	2659c59591db4c7e048901d38c3b275d	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Elijah of Buxton	Christopher Paul Curtis	honor	2008	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2503306	2007	Book	Fiction	2503306
149	149	d7afb073eef3d12278b2569fdb515ce2	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Feathers	Jacqueline Woodson	honor	2008	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2698499	2007	Book	Fiction	2698499
130	130	e040e70524228f371d83d8027852daf4	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Fighting Words	Kimberly Brubaker Bradley	honor	2021	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3538126	2020	Book	Fiction	3538126
97	97	bd55550287f832c84d80ef67c5351ec1	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Floating Island	Anne Parrish	honor	1931	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2376595	1930	Book	Fiction	2376595
69	69	5401a04eaab69d6340a71eb7a1662097	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Flora & Ulysses	Kate DiCamillo	medal	2014	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2890230	2013	Audiobook CD	CD-Spoken Fiction DiCamillo	2890230
71	71	30d8846617f4216788a49be61f5abaf0	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Freewater	Amina Luqman-Dawson	medal	2023	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3719634	2022	Book	Fiction	3719634
31	31	6878f1fc4da309260daacd7e81532897	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	From the Mixed-Up Files of Mrs. Basil E. Frankweiler	E. L. Konigsburg	medal	1968	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1072614	1988	Large Print	Fiction	1072614
46	46	f580929575e0ce0c4a08688b2619213c	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Gay-Neck, the Story of a Pigeon	Dhan Gopal Mukerji	medal	1928	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1035794	1927	Book	QL795.B57 M8	1035794
84	84	61eaa3cace85a7338010330f7fdef206	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Ginger Pye	Eleanor Estes	medal	1952	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1048098	1987	Large Print	Fiction	1048098
81	81	52ca6dc3efbbf859a979fa40950be473	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Good Masters! Sweet Ladies! Voices from a Medieval Village	Laura Amy Schlitz	medal	2008	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2775823	2007	Book	812.6 qS344 2007	2775823
70	70	a3f8ec7f523f767cf7e99017ec89b447	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Hattie Big Sky	Kirby Larson	honor	2007	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2606321	2006	Book	Fiction	2606321
13	13	8bb69c81cea75c8f0f0bdd6dced515de	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Heart of a Samurai	Margi Preus	honor	2011	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2545990	2010	Book	Fiction	2545990
49	49	f8436b9542f10d7508f9fd7894c87ea7	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Hello, Universe	Erin Entrada Kelly	medal	2018	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3242044	2017	Book	Fiction	3242044
94	94	d1f3334ad46508e3dcaa1df15fd3fe81	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Hitty, Her First Hundred Years	Rachel Field	medal	1930	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1017652	1929	Book	Fiction	1017652
108	108	946278514ee05e9592bfe3d506c7ceac	sample-newbery-starter	Sample Newbery Starter	Holes	Louis Sachar			Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1805781	1998	Book	Fiction	1805781
109	109	8cdd8dfcf555371e8393f8d738cf7525	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Holes	Louis Sachar	medal	1999	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1805781	1998	Book	Fiction	1805781
125	125	7e7b00170e2c2f4a8f03924f082184e9	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	I, Juan de Pareja	Elizabeth Borton de Treviño	medal	1966	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2376027	1965	Book	Fiction	2376027
140	140	23ae0aee7a7374a627267108479d02b9	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Indian Captive	Lois Lenski	honor	1942	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1934373	1996	Book	974.788004 J49ZL, 1996	1934373
5	5	caea1f4d4ef8942218ae405b29a11f86	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Inside Out & Back Again	Thanhha Lai	honor	2012	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2670871	2011	Book	Fiction	2670871
48	48	d6c6ec310ac1e52a6a66d6bda97f9cfd	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Invincible Louisa: the Story of the Author of Little Women	Cornelia Meigs	medal	1934	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1530172	1933	Book	813.4 A355Zm2, 1933a	1530172
143	143	603ac4c1e63d8bafcaad06311fc5f149	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Island of the Blue Dolphins	Scott O'Dell	medal	1961	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1758344	1992	Audiobook CD	CDW 799	1758344
139	139	4e7fc4a68478d5a3742194731b280d1b	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	It's Like This, Cat	Emily Cheney Neville	medal	1964	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2289193	1963	Book	PZ7	2289193
51	51	47a61b31906296754e458636601dfd06	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Iveliz Explains It All		honor	2023	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3751774	2022	Book	Fiction	3751774
155	155	7d13075eff970b3cfeb4efd647a1546e	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Jacob Have I Loved	Katherine Paterson	medal	1981	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1104783	1990	Large Print	Fiction	1104783
99	99	109783423fefed7c7e43a3a0e1078514	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Johnny Tremain	Esther Forbes	medal	1944	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1671366	1971	Book	Fiction	1671366
4	4	548c3a624ee7d8ae14ef653450c9257c	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Joyful Noise: Poems for Two Voices	Paul Fleischman	medal	1989	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1130999	1988	Book	811.54 F596j, 1988	1130999
150	150	52fc5b310a956468bd093482193f06bd	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Julie of the Wolves	Jean Craighead George	medal	1973	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2467942	1972	Book	PZ7.G2933 Ju	2467942
110	110	a141df0269b4fde47ee16555e53748c4	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	King of the Wind	Marguerite Henry	medal	1949	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2044613	1976	Book	Fiction	2044613
8	8	47ec609a38709550674a367bada10fd2	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Kira-Kira	Cynthia Kadohata	medal	2005	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2184116	2004	Book	Fiction	2184116
45	45	4d012bf5132dd1139417762f7b13f366	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Last Stop on Market Street	Matt de la Peña	medal	2016	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3006128	2015	Book	Easy	3006128
153	153	488d5898265c8c05d20a418aea459d1e	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Lincoln: A Photobiography	Russell Freedman	medal	1988	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1046118	1987	Book	973.7 L736Zfr	1046118
23	23	e879edcf5c65d00d80d74ac2137733d2	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	M. C. Higgins, the Great	Virginia Hamilton	medal	1975	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2464057	1999	Book	Fiction	2464057
169	169	f57c9d0e5429b18c0beed1f15c88b9a7	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Maniac Magee	Jerry Spinelli	medal	1991	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1927441	2001	Audiobook CD	CD-Spoken Fiction Spinelli	1927441
157	157	58d6b6d4039f6f5a41082b54a9e63b7b	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Meggy MacIntosh	Elizabeth Gray Vining	honor	1931	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1009403	1930	Book	Fiction	1009403
52	52	c3924871a20d041a4b256546a246a1a1	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Merci Suárez Changes Gears	Meg Medina	medal	2019	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3367269	2018	Book	Fiction	3367269
79	79	bffd31bcac05e5f1da6d2c5a261c204b	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Millions of Cats	Wanda Gág	honor	1929	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1017267	1977	Book	Easy	1017267
1	1	d0ada91d0ff3358629d6fc5d1b60df57	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Miracles on Maple Hill	Virginia Sorensen	medal	1957	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2147059	1956	Book	Fiction	2147059
15	15	7fcb121370c395a955c4b94f5f1ec143	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Miss Hickory	Carolyn Sherwin Bailey	medal	1947	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1064594		Book		1064594
74	74	86172247e7e385085ffc2cadd8c4f9e2	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Missing May	Cynthia Rylant	medal	1993	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1419517	1992	Book	Fiction	1419517
39	39	8326714cf3eabd27162676b0d28c0c7a	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Moon Over Manifest	Clare Vanderpool	medal	2011	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2592024	2010	Book	Fiction	2592024
105	105	a7b113e73069a3ce14c8a925a9009526	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Mr. Popper's Penguins	Florence Atwater; Richard Atwater	honor	1939	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2432254	1988	Book	PZ7.A892 Mr 1988	2432254
38	38	5f5978bac22e3ff3fd1b547e5419c31f	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Mrs. Frisby and the Rats of NIMH	Robert C. O'Brien	medal	1972	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1769934	1993	Audiobook CD	CDW 00801	1769934
118	118	81cbdcd6384584ca674438d133416285	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	My Side of the Mountain	Jean Craighead George	honor	1960	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2199480	1959	Book	Fiction	2199480
10	10	258a87a7620745e62b458b5e0aa35c34	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	New Kid	Jerry Craft	medal	2020	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3408946	2019	Book	741.5 C885n 2019	3408946
93	93	51210f4c2cd23e06eb44b10511fac2f0	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Nicholas; A Manhattan Christmas Story	Anne Carroll Moore	honor	1925	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2344999	1924	Book	Fiction	2344999
27	27	9cb5227bed4258264a2e2881eb61c74c	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Number the Stars	Lois Lowry	medal	1990	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1248309	1989	Book	Fiction	1248309
160	160	041e9430ea47fdeaa86cc45997a3f396	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Olive's Ocean	Kevin Henkes	honor	2004	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2119280	2003	Book	Fiction	2119280
55	55	d9ce6ee47822747869ba0ef6f616b416	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	One Came Home	Amy Timberlake	honor	2014	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2820337	2013	Book	Fiction	2820337
60	60	c4f960b74f655b068e2c68292e332f9b	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	One Crazy Summer	Rita Williams-Garcia	honor	2011	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2563046	2010	Audiobook CD	CD-Spoken Fiction Williams-Garcia	2563046
20	20	0eaa2699daa9cc1b5f595c9f97962991	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Onion John	Joseph Krumgold	medal	1960	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2204950	1959	Book	Fiction	2204950
128	128	3c312f0a019d79f90ae41d6fb6fc33bc	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Other Words for Home	Jasmine Warga	honor	2020	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3428918	2019	Book	Fiction	3428918
67	67	63fc3f0b5f117c30ef0625e7502bb1ca	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Out of the Dust	Karen Hesse	medal	1998	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1730633	1997	Book	Fiction	1730633
21	21	1e2a1ebf69fd6f7a193e94a25444184c	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Paperboy	Vince Vawter	honor	2014	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2831070	2013	Book	Fiction	2831070
47	47	b26e16bc918d6b651a9fe56f7d9fea59	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Penny from Heaven	Jennifer L. Holm	honor	2007	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2580624	2006	Book	Fiction	2580624
50	50	c728826463e31976fd267128f9e60006	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Phebe Fairchild: Her Book	Lois Lenski	honor	1937	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3554044	2020	Book	Fiction	3554044
89	89	cecfbc1f27a1cf8df08ed04f991dc263	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Piecing Me Together	Renée Watson	honor	2018	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3236219	2017	Book	Fiction	3236219
57	57	9330f82a0367afe2a9945e17389cad95	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Rabbit Hill	Robert Lawson	medal	1945	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1764530	1995	Audiobook CD	CDW 01074	1764530
92	92	de06f039cd863b5ed1397d6e12f6bf5d	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Rifles for Watie	Harold Keith	medal	1958	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2166716	1957	Book	Fiction	2166716
151	151	bcb2fd20d68e06c4f1c7bac7da4ed366	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Roll of Thunder, Hear My Cry	Mildred D. Taylor	medal	1977	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2492579	1976	Book	Fiction	2492579
124	124	7a89cb5ad61e56fe35284851e3cf642b	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Roller Skates	Ruth Sawyer	medal	1937	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2628514	1986	Book	Fiction	2628514
41	41	ed72a98881361ad5d9735c590e718ab0	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Rules	Cynthia Lord	honor	2007	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2507328	2006	Book	Fiction	2507328
95	95	d327eb76eed9a8ee12a622feabb023c7	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Sarah, Plain and Tall	Patricia MacLachlan	medal	1986	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1075208	1988	Large Print	Fiction	1075208
122	122	eb6b51bc61cf5ba733e2c6d462357826	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Savvy	Ingrid Law	honor	2009	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2617721	2008	Book	Fiction	2617721
90	90	dbf96c8fa8238e065e90cbde05243997	a224c8bac08ac225b33db69c12a5f899	Newbery Honor	Scary Stories for Young Foxes	Christian McKay Heidicker	honor	2020	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3459006	2019	Book	Fiction	3459006
162	162	74104cfc4d7b2bf68ba758c385e6cc94	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal	Secret of the Andes	Ann Nolan Clark	medal	1953	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2085265	1952	Book	Fiction	2085265

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE list_entry_display(list_entry_id VARCHAR, list_key VARCHAR, list_name VARCHAR, cover_isbn VARCHAR, title VARCHAR, author VARCHAR, award_class VARCHAR, award_year BIGINT, status_label VARCHAR, catalog_url VARCHAR, pub_year BIGINT, format VARCHAR, call_number VARCHAR, bib_id BIGINT);
CREATE INDEX idx_list_entry_display_list_key on list_entry_display(list_key);
CREATE INDEX idx_list_entry_display_status_label on list_entry_display(status_label);

List entries — all columns (raw)

169 rows where status_label = "Available at CHPL ✓" sorted by title

Advanced export