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 = "Audiobook CD", list_name = "Sample Newbery Starter" 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

  • Sample Newbery Starter · 1 ✖

format 1

  • Audiobook CD · 1 ✖

award_class 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
165 165 126590e01ac0bc6ececda395c613e6f6 sample-newbery-starter Sample Newbery Starter cover Bridge to Terabithia Katherine Paterson     Available at CHPL ✓ https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1753737 1996 Audiobook CD CD-Spoken Fiction Paterson 1753737

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