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

1 row where format = "LP" and status_label = "Available at CHPL ✓" sorted by title

✎ View and edit SQL

This data as json, CSV (advanced)

status_label 1

  • Available at CHPL ✓ · 1 ✖

list_name 1

format 1

award_class 1

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
63 63 54fba35e99e2dc22c0103a958d465c60 b2ac76f948602b239df4ce08ca6429b0 Newbery Medal cover Caddie Woodlawn Carol Ryrie Brink medal 1936 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1015793   LP   1015793

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