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

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: author

cover_isbn	title	author	status_label	format	call_number	award_class	award_year	pub_year	list_name	catalog_url
	Flora & Ulysses	Kate DiCamillo	Available at CHPL ✓	Audiobook CD	CD-Spoken Fiction DiCamillo	medal	2014	2013	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2890230
	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
	The Tale of Despereaux	Kate DiCamillo	Available at CHPL ✓	Audiobook CD	PZ8.D525 Tal 2003ab	medal	2004	2003	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2545298
	Maniac Magee	Jerry Spinelli	Available at CHPL ✓	Audiobook CD	CD-Spoken Fiction Spinelli	medal	1991	2001	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1927441
	Mrs. Frisby and the Rats of NIMH	Robert C. O'Brien	Available at CHPL ✓	Audiobook CD	CDW 00801	medal	1972	1993	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1769934
	A Wrinkle in Time	Madeleine L'Engle	Available at CHPL ✓	Audiobook CD	CDW 00540	medal	1963	1994	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1821767
	Island of the Blue Dolphins	Scott O'Dell	Available at CHPL ✓	Audiobook CD	CDW 799	medal	1961	1992	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1758344
	Rabbit Hill	Robert Lawson	Available at CHPL ✓	Audiobook CD	CDW 01074	medal	1945	1995	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1764530
	Bridge to Terabithia	Katherine Paterson	Available at CHPL ✓	Audiobook CD	CD-Spoken Fiction Paterson			1996	Sample Newbery Starter	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1753737

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;