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

9 rows where format = "Audiobook CD" and status_label = "Available at CHPL ✓" sorted by title

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: list_key, author

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
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
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
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
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
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
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
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
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
166	166	3db1d55a49cb1a11781a770a1e714b02	b2ac76f948602b239df4ce08ca6429b0	Newbery Medal		The Tale of Despereaux	Kate DiCamillo	medal	2004	Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2545298	2003	Audiobook CD	PZ8.D525 Tal 2003ab	2545298

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