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
177 rows
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited
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;



































































































