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

2 rows where format = "Book" and list_name = "Sample Newbery Starter"

✎ View and edit SQL

This data as json, CSV (advanced)

status_label 1

list_name 1

  • Sample Newbery Starter · 2 ✖

format 1

  • Book · 2 ✖

award_class 0

cover_isbn title author status_label format call_number award_class award_year pub_year list_name catalog_url
cover Holes Louis Sachar Available at CHPL ✓ Book Fiction     1998 Sample Newbery Starter https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1805781
cover The Giver Lois Lowry Available at CHPL ✓ Book Fiction     1993 Sample Newbery Starter https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1481826

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;