cases

side

Membrane face — f (front) or d (dorse), when known.

image

Membrane / frame number from the index (not a URL). Use with rolls.aalt_roll_url to find the scan on AALT.

roll_label

Roll identifier copied from the source index.

roll_number

Numeric roll id when present on the row.

county

Court venue for the case (not necessarily the person’s place county).

source_downloaded_at

ISO date (YYYY-MM-DD) from the filesystem mtime of the saved index file — proxy for when that WAALT/AALT page was downloaded (not the SQLite import time).

2,290 rows where roll_id = 69

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: roll_number, source_downloaded_at (date)

Next page

CREATE TABLE cases (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    roll_id INTEGER NOT NULL REFERENCES rolls(id) ON DELETE CASCADE,
    side TEXT,
    roll_number TEXT,
    image TEXT,
    county TEXT,
    case_type TEXT,
    plaintiff TEXT,
    defendant TEXT,
    source_row INTEGER, source_file TEXT, roll_label TEXT, term TEXT, year INTEGER, monarch TEXT, source_downloaded_at TEXT,
    UNIQUE(roll_id, source_row)
);
CREATE INDEX idx_cases_roll_id ON cases(roll_id);
CREATE INDEX idx_cases_plaintiff ON cases(plaintiff);
CREATE INDEX idx_cases_defendant ON cases(defendant);
CREATE INDEX idx_cases_county ON cases(county);
CREATE INDEX idx_cases_year ON cases(year);
CREATE INDEX idx_cases_source_file ON cases(source_file);