List entries — all columns (raw)

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

58 rows where award_class = "honor", format = "Book" and status_label = "Available at CHPL ✓" sorted by title

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: call_number

status_label 1

  • Available at CHPL ✓ · 58 ✖

list_name 1

format 1

  • Book · 58 ✖

award_class 1

  • honor · 58 ✖
Link rowid list_entry_id list_key list_name cover_isbn title ▼ author award_class award_year status_label catalog_url pub_year format call_number bib_id
78 78 499a725fc02b8acb68a4f34755db7c34 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 26 Fairmount Avenue Tomie dePaola honor 2000 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1938653 1999 Book 813.54 D419Zde 1999 1938653
145 145 b70f91b799102ad2906dd67f3d8964e3 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover A Girl Named Disaster Nancy Farmer honor 1997 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1721055 1996 Book Fiction 1721055
107 107 a3c41eaae84ce19ef1ec5ad4cc8e3a7b a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover A Snake Falls to Earth Darcie Little Badger honor 2022 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3683659 2021 Book Fiction 3683659
117 117 5bb53e40c7063ebc28d7149d31ab6013 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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 cover 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
88 88 c81dae90cef9001a506967853bbdf853 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Annie and the Old One Miska Miles honor 1972 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2142824 1971 Book Fiction 2142824
25 25 270ae28d9fb389bf98064369278c2a74 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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 cover Breaking Stalin's Nose Eugene Yelchin honor 2012 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2773550 2011 Book Fiction 2773550
56 56 34b67bd5c3b99de01f14c99a27aa31e7 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Brown Girl Dreaming Jacqueline Woodson honor 2015 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2972252 2014 Book 811.54 W898Zw 2014 2972252
131 131 1f4cbbf0e7c471c1301d0e7d00f5a3ec a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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
62 62 2eab0c55a3c7b95dd8c415bc623bf55b a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Doll Bones Holly Black honor 2014 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2841721 2013 Book Fiction 2841721
44 44 0331fbe71aeaab8b1b4546c79598103a a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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 cover 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 cover 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 cover 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
70 70 a3f8ec7f523f767cf7e99017ec89b447 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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 cover Heart of a Samurai Margi Preus honor 2011 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2545990 2010 Book Fiction 2545990
140 140 23ae0aee7a7374a627267108479d02b9 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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 cover Inside Out & Back Again Thanhha Lai honor 2012 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2670871 2011 Book Fiction 2670871
51 51 47a61b31906296754e458636601dfd06 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Iveliz Explains It All   honor 2023 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3751774 2022 Book Fiction 3751774
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
79 79 bffd31bcac05e5f1da6d2c5a261c204b a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Millions of Cats Wanda Gág honor 1929 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1017267 1977 Book Easy 1017267
105 105 a7b113e73069a3ce14c8a925a9009526 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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
118 118 81cbdcd6384584ca674438d133416285 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover My Side of the Mountain Jean Craighead George honor 1960 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2199480 1959 Book Fiction 2199480
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
160 160 041e9430ea47fdeaa86cc45997a3f396 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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 cover One Came Home Amy Timberlake honor 2014 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2820337 2013 Book Fiction 2820337
128 128 3c312f0a019d79f90ae41d6fb6fc33bc a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Other Words for Home Jasmine Warga honor 2020 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3428918 2019 Book Fiction 3428918
21 21 1e2a1ebf69fd6f7a193e94a25444184c a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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 cover 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 cover 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 cover Piecing Me Together Renée Watson honor 2018 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3236219 2017 Book Fiction 3236219
41 41 ed72a98881361ad5d9735c590e718ab0 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Rules Cynthia Lord honor 2007 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2507328 2006 Book Fiction 2507328
122 122 eb6b51bc61cf5ba733e2c6d462357826 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover 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 cover Scary Stories for Young Foxes Christian McKay Heidicker honor 2020 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3459006 2019 Book Fiction 3459006
29 29 5f336f4ca9f88ba92a4dd66886d9c59e a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Sing Down the Moon Scott O'Dell honor 1971 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2133668 1970 Book Fiction 2133668
114 114 0dcfda8374778f0b66941e6eeb7a54e7 a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Spice and the Devil's Cave Agnes Hewes honor 1931 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2375284 1950 Book Fiction 2375284
28 28 db1dcbbb89fc98c684709ae11d7c73e0 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Splendors and Glooms Laura Amy Schlitz honor 2013 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2789682 2012 Book Fiction 2789682
33 33 5c0b783687fce2eb80eb98f9722a4d69 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Evolution of Calpurnia Tate Jacqueline Kelly honor 2010 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2597573 2009 Book Fiction 2597573
100 100 50dab61529757d64d57f98131fc20b23 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Great Gilly Hopkins Katherine Paterson honor 1979 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2023326 1978 Book Fiction 2023326
111 111 a90da0dc6a575ff669a9e95f97a0d812 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Inquisitor's Tale Adam Gidwitz honor 2017 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3199742 2016 Book Fiction 3199742
135 135 fe7d8fede14c9f1c492a7f23d82f34b4 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Mostly True Adventures of Homer P. Figg Rodman Philbrick honor 2010 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2528656 2009 Book Fiction 2528656
16 16 efa3941f371dc3a22640f0595b99d57e a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Perilous Gard Elizabeth Marie Pope honor 1975 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1184385 1974 Book Fiction 1184385
167 167 6ebc356878bed1b50cc43549edaf7102 a224c8bac08ac225b33db69c12a5f899 Newbery Honor   The Pigtail of Ah Lee Ben Loo John Bennett honor 1929 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2363062 1928 Book 818 B47 2363062
12 12 ed66ebd59912a18072caedbfd2a65f96 a224c8bac08ac225b33db69c12a5f899 Newbery Honor   The Runaway Papoose Grace Moon honor 1929 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2362069 1929 Book Fiction 2362069
61 61 034e89e9b2615868d3b36f5a38fc26d9 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Surrender Tree: Poems of Cuba's Struggle for Freedom Margarita Engle honor 2009 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2609553 2008 Book 811.54 E584s 2008 2609553
53 53 ab4b53f49fe95d25f09518b83f5d61de a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Underneath Kathi Appelt honor 2009 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2619816 2008 Book Fiction 2619816
22 22 fda08d33b4a818a61587c25aff16de51 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The War That Saved My Life Kimberly Brubaker Bradley honor 2016 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3005142 2015 Book Fiction 3005142
144 144 00f5562649ef08dd1a2ef44bb43ed623 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Wednesday Wars Gary D. Schmidt honor 2008 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2753926 2007 Book Fiction 2753926
168 168 06599b2f84abbd3dc0320843258142fb a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Year of Billy Miller Kevin Henkes honor 2014 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2876781 2013 Book Fiction 2876781
37 37 413c678d2c2aad62ed16b4852addbbf9 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Three Times Lucky Sheila Turnage honor 2013 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2661315 2012 Book Fiction 2661315
96 96 fd4351994ff12a03a09532aa8675b827 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Too Bright to See Kyle Lukoff honor 2022 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3577113 2021 Book Fiction 3577113
40 40 0fb7dae416378ce67960110bd4c12795 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Turtle in Paradise Jennifer L. Holm honor 2011 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2500427 2010 Book Fiction 2500427
91 91 8f58a791070048faf4243d5d05189635 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Watercress Andrea Wang honor 2022 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3573971 2021 Book Easy 3573971
132 132 9c6e469ffd110db90dc529102a1529b8 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Where the Mountain Meets the Moon Grace Lin honor 2010 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2623089 2009 Book Fiction 2623089
9 9 332207e68bb8285655f2eb738cb50f59 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Whittington Alan Armstrong honor 2006 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2728745 2005 Book Fiction 2728745
163 163 5520535b0b5860868723e8d287fc4a1f a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Young Walter Scott Elizabeth Gray Vining honor 1936 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2408044 1957 Book 828.709 S431Zv, 1957 2408044

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);