reading_lists: educator_detail: 8 rows where award_class = "honor" and status

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

8 rows where award_class = "honor" and status_label = "Not owned."

descending

✎ View and edit SQL

This data as json, CSV (advanced)

title	author	status_label	award_class	award_year	list_name
The Fairy Circus	Dorothy P. Lathrop	Not owned.	honor	1932	Newbery Honor
Garram the Hunter, A Boy of the Hill Tribes	Herbert Best	Not owned.	honor	1931	Newbery Honor
Mountains Are Free	Julia Davis Adams	Not owned.	honor	1931	Newbery Honor
Ood-le-uk the Wanderer	Alice Alison Lide; Margaret Alison Johansen	Not owned.	honor	1931	Newbery Honor
Queer Person	Ralph Hubbard	Not owned.	honor	1931	Newbery Honor
Little Blacknose	Hildegarde Hoyt Swift	Not owned.	honor	1930	Newbery Honor
Pran of Albania	Elizabeth Cleveland Miller	Not owned.	honor	1930	Newbery Honor
The Dark Star of Itza, The Story of A Pagan Princess	Alida Malkus	Not owned.	honor	1930	Newbery Honor

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;

Educator detail (view)

8 rows where award_class = "honor" and status_label = "Not owned."

Advanced export