names

17 rows where place_id = 601381

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645106 1908877 1908877 defendant Lightfot Walter weaver 601381 601381 Lightfot, Walter, of Huton, weaver 0
3645107 1908877 1908877 defendant Lethom John weaver 601381 601381 Lethom, John, of Huton, weaver 1
3645108 1908877 1908877 defendant Dighton Richard weaver 601381 601381 Dighton, Richard, of Huton, weaver 2
3645109 1908877 1908877 defendant Clay John weaver 601381 601381 Clay, John, of Huton, weaver 3
3894997 1988535 1988535 defendant Barker John gent 601381 601381 Barker, John, of Huton, gent 0
4152934 2079132 2079132 defendant Franke Henry yeoman 601381 601381 Franke, Henry, of Huton, yeoman 0
4217287 2101543 2101543 defendant Vyttye Thomas miller 601381 601381 Vyttye, Thomas, of Huton, miller 0
4217288 2101543 2101543 defendant Cooke Thomas husbandman 601381 601381 Cooke, Thomas, of Huton, husbandman 1
4217289 2101543 2101543 defendant Whitlocke Christopher husbandman 601381 601381 Whitlocke, Christopher, of Huton, husbandman 2
4253926 2114310 2114310 defendant Whitlock Christopher husbandman 601381 601381 Whitlock, Christopher, of Huton, husbandman 2
4260413 2116449 2116449 defendant Francke John tanner 601381 601381 Francke, John, of Huton, tanner 1
4264983 2117924 2117924 defendant Slinger Thomas yeoman 601381 601381 Slinger, Thomas, of Huton, yeoman 0
4264986 2117925 2117925 defendant Slinger Thomas yeoman 601381 601381 Slinger, Thomas, of Huton, yeoman 0
4271704 2120117 2120117 defendant Francke John tanner 601381 601381 Francke, John, of Huton, tanner 1
4544479 2214185 2214185 defendant Payn John   601381 601381 Payn, John, of Huton 0
4965861 2346719 2346719 defendant Francis Robert husbandman 601381 601381 Francis, Robert, of Huton, husbandman 3
5593908 2533083 2533083 defendant Bateman James (legal representative) 601381 601381 Bateman, James, of Huton, clothman, executor of 3

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);