rolls

aalt_roll_url

AALT roll landing page when extracted from the source index; blank if unknown. Opens the whole roll folder — not a deep per-image link.

source_file

Basename of the imported index file.

roll_label

Canonical roll label (e.g. CP40no618).

source_downloaded_at

ISO date from the saved index file’s mtime (same meaning as cases.source_downloaded_at).

138 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: term, indexed_by, alphabet_slice, monarch, source_downloaded_at, imported_at (date), source_downloaded_at (date)

Next page

CREATE TABLE rolls (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    source_file TEXT NOT NULL UNIQUE,
    roll_label TEXT,
    term TEXT,
    year INTEGER,
    indexed_by TEXT,
    alphabet_slice TEXT,
    row_count INTEGER DEFAULT 0,
    imported_at TEXT NOT NULL DEFAULT (datetime('now'))
, monarch TEXT, aalt_roll_url TEXT, source_downloaded_at TEXT);