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

8 rows where award_class = "honor", list_name = "Newbery Honor" and status_label = "Not owned."

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: award_year

status_label 1

  • Not owned. · 8 ✖

list_name 1

  • Newbery Honor · 8 ✖

award_class 1

  • honor · 8 ✖

format 0

cover_isbn title author status_label format call_number award_class award_year pub_year list_name catalog_url
  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

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;