reading_lists

Data source: chimpy-lake reading_lists_match gold

Custom SQL query

Queries

Tables

dim_list

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

3 rows

fct_match

match_id, list_entry_id, bib_id, match_scheme, matched_via, adjudication, confidence, bm25_rank, title_score, author_score, fuzzy_score, author_missing

487 rows

list_entry_display

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

177 rows

list_entry_summary

list_entry_id, list_key, list_id, list_source, list_name, curator, source_kind, source_detail, attributes, award_class, award_year, title, author, rank, n_bibs_confident, n_bibs_adjudicated, n_bibs_review, status, confirmed_absent, is_gap

177 rows

review_bucket

list_entry_id, list_key, entry_key, list_title, list_author, award_class, bib_id, bib_title, bib_author, isbn, oclc_number, matched_via, bm25_rank, title_score, author_score, fuzzy_score, author_missing, n_candidates, triage_rank

0 rows

Views

Download SQLite DB: reading_lists.db 260.0 KB