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

3 rows where award_class = "honor" and format = "Large Print"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: call_number

status_label 1

list_name 1

format 1

  • Large Print · 3 ✖

award_class 1

  • honor · 3 ✖
cover_isbn title author status_label format call_number award_class award_year pub_year list_name catalog_url
cover Dragonwings Laurence Yep Available at CHPL ✓ Large Print Fiction honor 1976 1990 Newbery Honor https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1239486
cover The Tombs of Atuan Ursula K. Le Guin Available at CHPL ✓ Large Print Fiction honor 1972 1988 Newbery Honor https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1057155
  Audubon Constance Rourke Available at CHPL ✓ Large Print 598.2092 qA916Zr, 1964 honor 1937 1964 Newbery Honor https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1030724

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;