Showcase (view)

Data source: chimpy-lake reading_lists_match gold

cover_isbn

Cover

title

Title

author

Author

status_label

At CHPL?

award_class

Medal or Honor

award_year

Award year

list_name

List

3 rows where list_name = "Sample Newbery Starter"

✎ View and edit SQL

This data as json, CSV (advanced)

cover_isbn	title	author	status_label	award_class	award_year	list_name	catalog_url
	Bridge to Terabithia	Katherine Paterson	Available at CHPL ✓			Sample Newbery Starter	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1753737
	Holes	Louis Sachar	Available at CHPL ✓			Sample Newbery Starter	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1805781
	The Giver	Lois Lowry	Available at CHPL ✓			Sample Newbery Starter	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1481826

CREATE VIEW showcase as select cover_isbn, title, author, status_label, award_class, award_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;