List entries — all columns (raw)

The full underlying row behind the Showcase and Educator-detail views, with internal keys. Most people want Showcase or Educator detail instead.

Data source: chimpy-lake reading_lists_match gold

cover_isbn
Cover
title
Title
author
Author
status_label
At CHPL?
catalog_url
Find it
award_class
Medal or Honor
award_year
Award year
pub_year
Published (the edition we own)
format
Format
call_number
Call number (shelf location)
list_name
List

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: award_year

status_label 1

  • Not owned. · 8 ✖

list_name 1

award_class 1

  • honor · 8 ✖

format 0

Link rowid list_entry_id list_key list_name cover_isbn title ▼ author award_class award_year status_label catalog_url pub_year format call_number bib_id
176 176 15a4810b8857523ae1696855ba80acac a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Garram the Hunter, A Boy of the Hill Tribes Herbert Best honor 1931 Not owned.          
172 172 acdddd0c91f17bf2fe2a4cf0a90c3f99 a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Little Blacknose Hildegarde Hoyt Swift honor 1930 Not owned.          
173 173 268903c68cf2577ffbf62fd30835ed89 a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Mountains Are Free Julia Davis Adams honor 1931 Not owned.          
177 177 977fbf09ef281fbe846aba68652740d6 a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Ood-le-uk the Wanderer Alice Alison Lide; Margaret Alison Johansen honor 1931 Not owned.          
170 170 a4e7c37e4c5ddc2110078a08b3f6f2dc a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Pran of Albania Elizabeth Cleveland Miller honor 1930 Not owned.          
175 175 68a63b95be47c235a78df5981936932e a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Queer Person Ralph Hubbard honor 1931 Not owned.          
174 174 947ce59113214b4ff0d73cc41e7398d7 a224c8bac08ac225b33db69c12a5f899 Newbery Honor   The Dark Star of Itza, The Story of A Pagan Princess Alida Malkus honor 1930 Not owned.          
171 171 a3de1d913e0a144b232cd96ce4b77d8e a224c8bac08ac225b33db69c12a5f899 Newbery Honor   The Fairy Circus Dorothy P. Lathrop honor 1932 Not owned.          

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE list_entry_display(list_entry_id VARCHAR, list_key VARCHAR, list_name VARCHAR, cover_isbn VARCHAR, title VARCHAR, author VARCHAR, award_class VARCHAR, award_year BIGINT, status_label VARCHAR, catalog_url VARCHAR, pub_year BIGINT, format VARCHAR, call_number VARCHAR, bib_id BIGINT);
CREATE INDEX idx_list_entry_display_list_key on list_entry_display(list_key);
CREATE INDEX idx_list_entry_display_status_label on list_entry_display(status_label);