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

3 rows where award_class = "honor", format = "Large Print" and status_label = "Available at CHPL ✓" sorted by title

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: call_number

status_label 1

  • Available at CHPL ✓ · 3 ✖

list_name 1

format 1

  • Large Print · 3 ✖

award_class 1

  • honor · 3 ✖
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
159 159 0ca21f15049e3b01ceb00c77c26fb7b2 a224c8bac08ac225b33db69c12a5f899 Newbery Honor   Audubon Constance Rourke honor 1937 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1030724 1964 Large Print 598.2092 qA916Zr, 1964 1030724
133 133 bf29ea464c53b4894a8e50c7e7e16c68 a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover Dragonwings Laurence Yep honor 1976 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1239486 1990 Large Print Fiction 1239486
154 154 d99a5545e2ad163bb2f3cbfe6af0c62b a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover The Tombs of Atuan Ursula K. Le Guin honor 1972 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1057155 1988 Large Print Fiction 1057155

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);