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

3 rows where award_class = "honor" and format = "Large Print" sorted by title

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: call_number

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

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