Lists
Data source: chimpy-lake reading_lists_match gold
- list_name
- List name (from the list's own header for hand-authored lists)
- list_source
- How the list was created — newbery (pulled) or manual (hand-authored)
- curator
- Who curated the list (blank for the Newbery pull)
- source_kind
- Header-declared source type (blank for the Newbery pull)
- source_detail
- Free-form provenance note
- n_entries
- Number of titles on the list
- n_confident
- Titles we own with a confident ISBN/OCLC match
- n_adjudicated
- Titles a librarian reviewed and confirmed (also counts as owned)
- n_review
- Titles with a candidate still awaiting a human verdict
- n_gap
- Titles with no catalog match
- pct_owned
- Share of list titles we own — confident or librarian-confirmed ((n_confident + n_adjudicated) ÷ n_entries)
- item_count
- Title count from the list header (may differ from n_entries while the list is being re-ingested)
- attributes
- Free-form list attributes (age band, grade, theme, ...) as JSON
3 rows sorted by pct_owned descending
This data as json, CSV (advanced)
Suggested facets: n_gap, pct_owned
| Link | rowid | list_key | list_id | list_name | list_source | curator | source_kind | source_detail | attributes | item_count | n_entries | n_confident | n_adjudicated | n_review | n_gap | pct_owned ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | b2ac76f948602b239df4ce08ca6429b0 | Newbery Medal | newbery | 104 | 24 | 80 | 0 | 0 | 1.0 | ||||||
| 2 | 2 | sample-newbery-starter | sample-newbery-starter | Sample Newbery Starter | manual | reading-lists demo | manual | hand-authored sample shipped with the tenant | {"age_band": "grades 4-6", "purpose": "demo"} | 3 | 3 | 1 | 2 | 0 | 0 | 1.0 |
| 3 | 3 | a224c8bac08ac225b33db69c12a5f899 | Newbery Honor | newbery | 70 | 9 | 53 | 0 | 8 | 0.8857142857142857 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE dim_list(list_key VARCHAR, list_id VARCHAR, list_name VARCHAR, list_source VARCHAR, curator VARCHAR, source_kind VARCHAR, source_detail VARCHAR, attributes VARCHAR, item_count BIGINT, n_entries BIGINT, n_confident BIGINT, n_adjudicated BIGINT, n_review BIGINT, n_gap BIGINT, pct_owned DOUBLE); CREATE INDEX idx_dim_list_list_key on dim_list(list_key);