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 award_class = "honor" and format = "Audiobook CD" sorted by title

✎ View and edit SQL

This data as json, CSV (advanced)

status_label 1

list_name 1

format 1

  • Audiobook CD · 1 ✖

award_class 1

  • honor · 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
60 60 c4f960b74f655b068e2c68292e332f9b a224c8bac08ac225b33db69c12a5f899 Newbery Honor cover One Crazy Summer Rita Williams-Garcia honor 2011 Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2563046 2010 Audiobook CD CD-Spoken Fiction Williams-Garcia 2563046

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