names

14 rows where place_id = 659005

✎ 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
3721958 1933132 1933132 defendant Gawen John (legal representative) 659005 659005 Gawen, John, of Northyngton, esq, executrix of, 1
3950669 2007307 2007307 plaintiff Gawen Alice widow of Walter Gawen 659005 659005 Gawen, Alice, of Northyngton, widow of Walter Gawen 0
4477209 2193541 2193541 plaintiff Gowayn John   659005 659005 Gowayn, John, of Northyngton 0
4554172 2217230 2217230 plaintiff Gowayn John   659005 659005 Gowayn, John, of Northyngton 0
4641680 2243670 2243670 plaintiff Gawayn John   659005 659005 Gawayn, John, of Northyngton 0
4663653 2250111 2250111 plaintiff Gowayn John   659005 659005 Gowayn, John, of Northyngton 0
4741474 2278003 2278003 defendant Gawen Lawrence gent 659005 659005 Gawen, Lawrence, of Northyngton, gent 1
4795034 2294588 2294588 defendant Gowayne Lawrence gent 659005 659005 Gowayne, Lawrence, of Northyngton, gent 0
4946065 2340756 2340756 defendant Gowayn Lawrence esq 659005 659005 Gowayn, Lawrence, of Northyngton, esq 0
5003734 2357983 2357983 defendant Gowayn Thomas gent 659005 659005 Gowayn, Thomas, of Northyngton, gent 0
5187122 2411961 2411961 defendant Gowayn Thomas esq 659005 659005 Gowayn, Thomas, of Northyngton, esq 0
5195713 2414488 2414488 defendant Goweyn Thomas esq 659005 659005 Goweyn, Thomas, of Northyngton, esq 0
5205504 2417358 2417358 defendant Gowayn Thomas esq 659005 659005 Gowayn, Thomas, of Northyngton, esq 0
5276497 2438199 2438199 defendant Gowayn Thomas esq 659005 659005 Gowayn, Thomas, of Northyngton, esq 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);