names

9 rows where place_id = 603237

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3653924 1911493 1911493 defendant Grame William yeoman 603237 603237 Grame, William, of Astenby, yeoman 1
4523695 2207742 2207742 defendant Garne Thomas   603237 603237 Garne, Thomas, of Astenby 0
4624388 2238608 2238608 defendant Smyth John   603237 603237 Smyth, John, of Astenby 0
4701416 2265846 2265846 defendant Seddon William tailor 603237 603237 Seddon, William, of Astenby, tailor 2
4949120 2341715 2341715 defendant Lambe Richard yeoman 603237 603237 Lambe, Richard, of Astenby, yeoman 0
4975532 2349645 2349645 defendant Lamblee John yeoman 603237 603237 Lamblee, John, of Astenby, yeoman 11
4975533 2349645 2349645 defendant Lamblee Richard yeoman 603237 603237 Lamblee, Richard, of Astenby, yeoman 12
4975534 2349645 2349645 defendant Rayleton William yeoman 603237 603237 Rayleton, William, of Astenby, yeoman 13
4975535 2349645 2349645 defendant Neweton Thomas yeoman 603237 603237 Neweton, Thomas, of Astenby, yeoman 14

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);