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
104 rows where award_class = "medal" and list_name = "Newbery Medal"
This data as json, CSV (advanced)
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;




















































































