List entries — all columns (raw)

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

2 rows where format = "Book" and list_name = "Sample Newbery Starter" sorted by title

✎ View and edit SQL

This data as json, CSV (advanced)

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
108	108	946278514ee05e9592bfe3d506c7ceac	sample-newbery-starter	Sample Newbery Starter		Holes	Louis Sachar			Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1805781	1998	Book	Fiction	1805781
87	87	8f0eddd14e1477438c5cf5222f33a767	sample-newbery-starter	Sample Newbery Starter		The Giver	Lois Lowry			Available at CHPL ✓	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1481826	1993	Book	Fiction	1481826

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