names

19 rows where place_id = 680426

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4040491 2039091 2039091 defendant Lestrange Roger gent 680426 680426 (Lestrange, Roger, of Wyveton, Norf, gent 1
4040494 2039092 2039092 defendant Lestraunge Roger gent 680426 680426 (Lestraunge, Roger, of Wyveton, Norf, gent 1
4157385 2080653 2080653 defendant Brigge George gent 680426 680426 Brigge, George, of Wyveton, Norf, gent 0
4181444 2088988 2088988 defendant Lestraunge Margaret widow 680426 680426 Lestraunge, Margaret, of Wyveton, Norf, widow 1
4711186 2268850 2268850 defendant Derham Simon shipman 680426 680426 Derham, Simon, of Wyveton, Norf, shipman 0
4919229 2332524 2332524 defendant Dalle Alan butcher 680426 680426 Dalle, Alan, of Wyveton, Norf, butcher 0
4981451 2351368 2351368 defendant Parker John yeoman 680426 680426 Parker, John, of Wyveton, Norf, yeoman 1
5097680 2385748 2385748 defendant Andrewe John mariner 680426 680426 Andrewe, John, of Wyveton, Norf, mariner 0
5124859 2393744 2393744 plaintiff Andrewe Edmund yeoman 680426 680426 Andrewe, Edmund, of Wyveton, Norf, yeoman 0
5124886 2393753 2393753 plaintiff Andrewes Thomas yeoman 680426 680426 Andrewes, Thomas, of Wyveton, Norf, yeoman 0
5141104 2398523 2398523 defendant Dalle John yeoman 680426 680426 Dalle, John, of Wyveton, Norf, yeoman 3
5184723 2411282 2411282 defendant Hakoun Simon merchant 680426 680426 Hakoun, Simon, of Wyveton, Norf, merchant 1
5184825 2411311 2411311 defendant Hakoun Simon merchant 680426 680426 Hakoun, Simon, of Wyveton, Norf, merchant 1
5204552 2417081 2417081 defendant Hakoun Simon merchant 680426 680426 Hakoun, Simon, of Wyveton, Norf, merchant 1
5273923 2437453 2437453 defendant Clyderowe Henry gent 680426 680426 Clyderowe, Henry, of Wyveton, Norf, gent 1
5280662 2439418 2439418 defendant Clyderoo Henry yeoman 680426 680426 Clyderoo, Henry, of Wyveton, Norf, yeoman 0
5301098 2445282 2445282 defendant Andrewe John merchant 680426 680426 Andrewe, John, of Wyveton, Norf, merchant 0
5423682 2482047 2482047 defendant Gygges Robert gent 680426 680426 Gygges, Robert, of Wyveton, Norf, gent 4
5442838 2487770 2487770 defendant Gyggis Robert gent 680426 680426 Gyggis, Robert, of Wyveton, Norf, gent 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);