names

18 rows where place_id = 646802

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3892924 1987881 1987881 defendant Bollys Thomas gent 646802 646802 Bollys, Thomas, of Gosberkyrke, Lincs, gent 0
3892927 1987882 1987882 defendant Bollis Thomas gent 646802 646802 Bollis, Thomas, of Gosberkyrke, Lincs, gent 0
3940993 2003994 2003994 defendant Dethe Henry yeoman 646802 646802 Dethe, Henry, of Gosberkyrke, Lincs, yeoman 0
4896380 2325533 2325533 defendant de la Launde Richard esq 646802 646802 de la Launde, Richard, of Gosberkyrke, Lincs, esq 0
4909377 2329473 2329473 defendant de la Launde Richard   646802 646802 de la Launde, Richard, of Gosberkyrke, Lincs, esq, son & heir of Thomas de la Launde 0
5029974 2365642 2365642 defendant Sybert William yeoman 646802 646802 Sybert, William, of Gosberkyrke, Lincs, yeoman 0
5239970 2427266 2427266 defendant Thomson Robert chapman 646802 646802 Thomson, Robert, of Gosberkyrke, Lincs, chapman 2
5239974 2427267 2427267 defendant Thomson Robert chapman 646802 646802 Thomson, Robert, of Gosberkyrke, Lincs, chapman 0
5244706 2428629 2428629 defendant Sprotte William husbandman 646802 646802 Sprotte, William, of Gosberkyrke, Lincs, husbandman 0
5250215 2430180 2430180 defendant Bolles John gent 646802 646802 Bolles, John, of Gosberkyrke, Lincs, gent 0
5250219 2430181 2430181 defendant Bolles John gent 646802 646802 Bolles, John, of Gosberkyrke, Lincs, gent 0
5250223 2430182 2430182 defendant Bolles John gent 646802 646802 Bolles, John, of Gosberkyrke, Lincs, gent 0
5250227 2430183 2430183 defendant Bolles John gent 646802 646802 Bolles, John, of Gosberkyrke, Lincs, gent 0
5250242 2430186 2430186 defendant Bolles John gent 646802 646802 Bolles, John, of Gosberkyrke, Lincs, gent 0
5250247 2430187 2430187 defendant Bolles John gent 646802 646802 Bolles, John, of Gosberkyrke, Lincs, gent 0
5250252 2430188 2430188 defendant Bolles John gent 646802 646802 Bolles, John, of Gosberkyrke, Lincs, gent 0
5250257 2430189 2430189 defendant Bolles John gent 646802 646802 Bolles, John, of Gosberkyrke, Lincs, gent 0
5314120 2449239 2449239 defendant Flouter John yeoman 646802 646802 Flouter, John, of Gosberkyrke, Lincs, yeoman 0

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