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

11 rows where format = "Large Print" and list_name = "Newbery Medal"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pub_year

cover_isbn	title	author	status_label	format	call_number	award_class	award_year	pub_year	list_name	catalog_url
	The Giver	Lois Lowry	Available at CHPL ✓	Large Print	Fiction	medal	1994	2004	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1422981
	Sarah, Plain and Tall	Patricia MacLachlan	Available at CHPL ✓	Large Print	Fiction	medal	1986	1988	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1075208
	The Hero and the Crown	Robin McKinley	Available at CHPL ✓	Large Print	Fiction	medal	1985	1988	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1135368
	Jacob Have I Loved	Katherine Paterson	Available at CHPL ✓	Large Print	Fiction	medal	1981	1990	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1104783
	The Westing Game	Ellen Raskin	Available at CHPL ✓	Large Print	Fiction	medal	1979	1988	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1071925
	The Grey King	Susan Cooper	Available at CHPL ✓	Large Print	Fiction	medal	1976	1988	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1148378
	Summer of the Swans	Betsy Byars	Available at CHPL ✓	Large Print	Fiction	medal	1971	1988	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1107042
	From the Mixed-Up Files of Mrs. Basil E. Frankweiler	E. L. Konigsburg	Available at CHPL ✓	Large Print	Fiction	medal	1968	1988	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1072614
	The Witch of Blackbird Pond	Elizabeth George Speare	Available at CHPL ✓	Large Print	Fiction	medal	1959	1989	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1220052
	Ginger Pye	Eleanor Estes	Available at CHPL ✓	Large Print	Fiction	medal	1952	1987	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1048098
	Call It Courage	Armstrong Sperry	Available at CHPL ✓	Large Print	Fiction	medal	1941	1989	Newbery Medal	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1001068

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;