Educator detail (view)

The full browse, owned titles first and newest awards on top — cover and title/author, then availability (own it, format, call number), then provenance (Medal/Honor, award year, the edition we own). Click a cover or the "Available ✓" status to open it in the catalog. Filter by availability, award, list, or format.

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

1 row where format = "LP" and list_name = "Newbery Medal"

✎ View and edit SQL

This data as json, CSV (advanced)

status_label 1

list_name 1

  • Newbery Medal · 1 ✖

format 1

award_class 1

cover_isbn title author status_label format call_number award_class award_year pub_year list_name catalog_url
cover Caddie Woodlawn Carol Ryrie Brink Available at CHPL ✓ LP   medal 1936   Newbery Medal https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1015793

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;