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
70 rows where award_class = "honor" and list_name = "Newbery Honor"
This data as json, CSV (advanced)
Suggested facets: status_label
Advanced export
JSON shape: default, array, newline-delimited
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;




















































