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

7 rows where format = "Audiobook CD" and list_name = "Newbery Medal"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: author

status_label 1

list_name 1

  • Newbery Medal · 7 ✖

format 1

  • Audiobook CD · 7 ✖

award_class 1

cover_isbn title author status_label format call_number award_class award_year pub_year list_name catalog_url
cover Flora & Ulysses Kate DiCamillo Available at CHPL ✓ Audiobook CD CD-Spoken Fiction DiCamillo medal 2014 2013 Newbery Medal https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2890230
cover The Tale of Despereaux Kate DiCamillo Available at CHPL ✓ Audiobook CD PZ8.D525 Tal 2003ab medal 2004 2003 Newbery Medal https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2545298
cover Maniac Magee Jerry Spinelli Available at CHPL ✓ Audiobook CD CD-Spoken Fiction Spinelli medal 1991 2001 Newbery Medal https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1927441
cover Mrs. Frisby and the Rats of NIMH Robert C. O'Brien Available at CHPL ✓ Audiobook CD CDW 00801 medal 1972 1993 Newbery Medal https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1769934
cover A Wrinkle in Time Madeleine L'Engle Available at CHPL ✓ Audiobook CD CDW 00540 medal 1963 1994 Newbery Medal https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1821767
cover Island of the Blue Dolphins Scott O'Dell Available at CHPL ✓ Audiobook CD CDW 799 medal 1961 1992 Newbery Medal https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1758344
cover Rabbit Hill Robert Lawson Available at CHPL ✓ Audiobook CD CDW 01074 medal 1945 1995 Newbery Medal https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1764530

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;