Educator detail (view)

Data source: chimpy-lake reading_lists_match gold

cover_isbn

Cover

title

Title

author

Author

status_label

At CHPL?

format

Format

call_number

Call number (shelf location)

award_class

Medal or Honor

award_year

Award year

pub_year

Published (the edition we own)

list_name

List

70 rows where list_name = "Newbery Honor"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: call_number

cover_isbn	title	author	status_label	format	call_number	award_class	award_year	pub_year	list_name	catalog_url
	Iveliz Explains It All		Available at CHPL ✓	Book	Fiction	honor	2023	2022	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3751774
	A Snake Falls to Earth	Darcie Little Badger	Available at CHPL ✓	Book	Fiction	honor	2022	2021	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3683659
	Too Bright to See	Kyle Lukoff	Available at CHPL ✓	Book	Fiction	honor	2022	2021	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3577113
	Watercress	Andrea Wang	Available at CHPL ✓	Book	Easy	honor	2022	2021	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3573971
	All Thirteen: The Incredible Cave Rescue of the Thai Boys' Soccer Team	Christina Soontornvat	Available at CHPL ✓	Book	796.525095 qS711 2020	honor	2021	2020	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3550294
	Fighting Words	Kimberly Brubaker Bradley	Available at CHPL ✓	Book	Fiction	honor	2021	2020	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3538126
	Other Words for Home	Jasmine Warga	Available at CHPL ✓	Book	Fiction	honor	2020	2019	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3428918
	Scary Stories for Young Foxes	Christian McKay Heidicker	Available at CHPL ✓	Book	Fiction	honor	2020	2019	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3459006
	Piecing Me Together	Renée Watson	Available at CHPL ✓	Book	Fiction	honor	2018	2017	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3236219
	The Inquisitor's Tale	Adam Gidwitz	Available at CHPL ✓	Book	Fiction	honor	2017	2016	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3199742
	The War That Saved My Life	Kimberly Brubaker Bradley	Available at CHPL ✓	Book	Fiction	honor	2016	2015	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3005142
	Brown Girl Dreaming	Jacqueline Woodson	Available at CHPL ✓	Book	811.54 W898Zw 2014	honor	2015	2014	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2972252
	El Deafo	Cece Bell	Available at CHPL ✓	Book	741.5 B4331Zb 2014	honor	2015	2014	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2985569
	Doll Bones	Holly Black	Available at CHPL ✓	Book	Fiction	honor	2014	2013	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2841721
	One Came Home	Amy Timberlake	Available at CHPL ✓	Book	Fiction	honor	2014	2013	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2820337
	Paperboy	Vince Vawter	Available at CHPL ✓	Book	Fiction	honor	2014	2013	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2831070
	The Year of Billy Miller	Kevin Henkes	Available at CHPL ✓	Book	Fiction	honor	2014	2013	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2876781
	Bomb: The Race to Build -and Steal- the World's Most Dangerous Weapon	Steve Sheinkin	Available at CHPL ✓	Book	623.45119 S543 2012	honor	2013	2012	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2794735
	Splendors and Glooms	Laura Amy Schlitz	Available at CHPL ✓	Book	Fiction	honor	2013	2012	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2789682
	Three Times Lucky	Sheila Turnage	Available at CHPL ✓	Book	Fiction	honor	2013	2012	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2661315
	Breaking Stalin's Nose	Eugene Yelchin	Available at CHPL ✓	Book	Fiction	honor	2012	2011	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2773550
	Inside Out & Back Again	Thanhha Lai	Available at CHPL ✓	Book	Fiction	honor	2012	2011	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2670871
	Dark Emperor & Other Poems of the Night	Joyce Sidman	Available at CHPL ✓	Book	811.54 qS568d 2010	honor	2011	2010	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2571011
	Heart of a Samurai	Margi Preus	Available at CHPL ✓	Book	Fiction	honor	2011	2010	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2545990
	One Crazy Summer	Rita Williams-Garcia	Available at CHPL ✓	Audiobook CD	CD-Spoken Fiction Williams-Garcia	honor	2011	2010	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2563046
	Turtle in Paradise	Jennifer L. Holm	Available at CHPL ✓	Book	Fiction	honor	2011	2010	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2500427
	The Evolution of Calpurnia Tate	Jacqueline Kelly	Available at CHPL ✓	Book	Fiction	honor	2010	2009	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2597573
	The Mostly True Adventures of Homer P. Figg	Rodman Philbrick	Available at CHPL ✓	Book	Fiction	honor	2010	2009	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2528656
	Where the Mountain Meets the Moon	Grace Lin	Available at CHPL ✓	Book	Fiction	honor	2010	2009	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2623089
	After Tupac and D Foster	Jacqueline Woodson	Available at CHPL ✓	Book	Fiction	honor	2009	2008	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2569737
	Savvy	Ingrid Law	Available at CHPL ✓	Book	Fiction	honor	2009	2008	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2617721
	The Surrender Tree: Poems of Cuba's Struggle for Freedom	Margarita Engle	Available at CHPL ✓	Book	811.54 E584s 2008	honor	2009	2008	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2609553
	The Underneath	Kathi Appelt	Available at CHPL ✓	Book	Fiction	honor	2009	2008	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2619816
	Elijah of Buxton	Christopher Paul Curtis	Available at CHPL ✓	Book	Fiction	honor	2008	2007	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2503306
	Feathers	Jacqueline Woodson	Available at CHPL ✓	Book	Fiction	honor	2008	2007	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2698499
	The Wednesday Wars	Gary D. Schmidt	Available at CHPL ✓	Book	Fiction	honor	2008	2007	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2753926
	Hattie Big Sky	Kirby Larson	Available at CHPL ✓	Book	Fiction	honor	2007	2006	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2606321
	Penny from Heaven	Jennifer L. Holm	Available at CHPL ✓	Book	Fiction	honor	2007	2006	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2580624
	Rules	Cynthia Lord	Available at CHPL ✓	Book	Fiction	honor	2007	2006	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2507328
	Whittington	Alan Armstrong	Available at CHPL ✓	Book	Fiction	honor	2006	2005	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2728745
	Olive's Ocean	Kevin Henkes	Available at CHPL ✓	Book	Fiction	honor	2004	2003	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2119280
	26 Fairmount Avenue	Tomie dePaola	Available at CHPL ✓	Book	813.54 D419Zde 1999	honor	2000	1999	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1938653
	A Girl Named Disaster	Nancy Farmer	Available at CHPL ✓	Book	Fiction	honor	1997	1996	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1721055
	The Great Gilly Hopkins	Katherine Paterson	Available at CHPL ✓	Book	Fiction	honor	1979	1978	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2023326
	Dragonwings	Laurence Yep	Available at CHPL ✓	Large Print	Fiction	honor	1976	1990	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1239486
	The Perilous Gard	Elizabeth Marie Pope	Available at CHPL ✓	Book	Fiction	honor	1975	1974	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1184385
	Annie and the Old One	Miska Miles	Available at CHPL ✓	Book	Fiction	honor	1972	1971	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2142824
	The Tombs of Atuan	Ursula K. Le Guin	Available at CHPL ✓	Large Print	Fiction	honor	1972	1988	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1057155
	Sing Down the Moon	Scott O'Dell	Available at CHPL ✓	Book	Fiction	honor	1971	1970	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2133668
	My Side of the Mountain	Jean Craighead George	Available at CHPL ✓	Book	Fiction	honor	1960	1959	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2199480
	Indian Captive	Lois Lenski	Available at CHPL ✓	Book	974.788004 J49ZL, 1996	honor	1942	1996	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1934373
	Mr. Popper's Penguins	Florence Atwater; Richard Atwater	Available at CHPL ✓	Book	PZ7.A892 Mr 1988	honor	1939	1988	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2432254
	Audubon	Constance Rourke	Available at CHPL ✓	Large Print	598.2092 qA916Zr, 1964	honor	1937	1964	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1030724
	Phebe Fairchild: Her Book	Lois Lenski	Available at CHPL ✓	Book	Fiction	honor	1937	2020	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3554044
	Young Walter Scott	Elizabeth Gray Vining	Available at CHPL ✓	Book	828.709 S431Zv, 1957	honor	1936	1957	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2408044
	Floating Island	Anne Parrish	Available at CHPL ✓	Book	Fiction	honor	1931	1930	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2376595
	Meggy MacIntosh	Elizabeth Gray Vining	Available at CHPL ✓	Book	Fiction	honor	1931	1930	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1009403
	Spice and the Devil's Cave	Agnes Hewes	Available at CHPL ✓	Book	Fiction	honor	1931	1950	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2375284
	Millions of Cats	Wanda Gág	Available at CHPL ✓	Book	Easy	honor	1929	1977	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1017267
	The Pigtail of Ah Lee Ben Loo	John Bennett	Available at CHPL ✓	Book	818 B47	honor	1929	1928	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2363062
	The Runaway Papoose	Grace Moon	Available at CHPL ✓	Book	Fiction	honor	1929	1929	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2362069
	Nicholas; A Manhattan Christmas Story	Anne Carroll Moore	Available at CHPL ✓	Book	Fiction	honor	1925	1924	Newbery Honor	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2344999
	The Fairy Circus	Dorothy P. Lathrop	Not owned.			honor	1932		Newbery Honor
	Garram the Hunter, A Boy of the Hill Tribes	Herbert Best	Not owned.			honor	1931		Newbery Honor
	Mountains Are Free	Julia Davis Adams	Not owned.			honor	1931		Newbery Honor
	Ood-le-uk the Wanderer	Alice Alison Lide; Margaret Alison Johansen	Not owned.			honor	1931		Newbery Honor
	Queer Person	Ralph Hubbard	Not owned.			honor	1931		Newbery Honor
	Little Blacknose	Hildegarde Hoyt Swift	Not owned.			honor	1930		Newbery Honor
	Pran of Albania	Elizabeth Cleveland Miller	Not owned.			honor	1930		Newbery Honor
	The Dark Star of Itza, The Story of A Pagan Princess	Alida Malkus	Not owned.			honor	1930		Newbery Honor

CREATE VIEW educator_detail as select cover_isbn, title, author, status_label, format, call_number, award_class, award_year, pub_year, list_name, catalog_url from list_entry_display order by case when status_label like 'Available%' then 0 else 1 end, award_year desc nulls last, title;