List entries — all columns (raw)

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

11 rows where award_class = "medal", format = "Large Print" and list_name = "Newbery Medal" sorted by title

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pub_year

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
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
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
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
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
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
80	80	6bfddc6b6339cc7421a2b86960462a00	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal		Summer of the Swans	Betsy Byars	medal	1971	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1107042	1988	Large Print	Fiction	1107042
64	64	6c65d2a6bd57a477c94a6491161f02c9	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal		The Giver	Lois Lowry	medal	1994	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1422981	2004	Large Print	Fiction	1422981
102	102	b45d2e2ceb1f39f7d4648638d365ebfa	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal		The Grey King	Susan Cooper	medal	1976	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1148378	1988	Large Print	Fiction	1148378
86	86	faf83c736d6787c4e592ad3cc762b53a	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal		The Hero and the Crown	Robin McKinley	medal	1985	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1135368	1988	Large Print	Fiction	1135368
36	36	44d5488389cb23f1106ada76a0221b73	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal		The Westing Game	Ellen Raskin	medal	1979	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1071925	1988	Large Print	Fiction	1071925
156	156	f3110e1cbe232621641f1d7e57d9de87	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal		The Witch of Blackbird Pond	Elizabeth George Speare	medal	1959	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1220052	1989	Large Print	Fiction	1220052

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