names

11 rows where place_id = 593197

✎ 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
3610883 1871076 1871076 defendant Thwaytys Henry gent 593197 593197 Thwaytys, Henry, of Parva Smeton, gent 0
3677367 1918970 1918970 defendant Pynder William yeoman 593197 593197 Pynder, William, of Parva Smeton, yeoman 0
4873372 2318627 2318627 defendant Whytby William yeoman 593197 593197 Whytby, William, of Parva Smeton, yeoman 0
4895843 2325373 2325373 defendant Quyxlay William husbandman 593197 593197 Quyxlay, William, of Parva Smeton, husbandman 5
5315817 2449801 2449801 defendant Taillour John husbandman 593197 593197 Taillour, John, of Parva Smeton, husbandman 10
5315839 2449810 2449810 defendant Pynder Thomas husbandman 593197 593197 Pynder, Thomas, of Parva Smeton, husbandman 0
5333117 2454974 2454974 defendant Taillour John husbandman 593197 593197 Taillour, John, of Parva Smeton, husbandman 8
5493992 2503111 2503111 defendant Oxenell John laborer 593197 593197 Oxenell, John, of Parva Smeton, laborer 0
5493994 2503112 2503112 defendant Oxenell John laborer 593197 593197 Oxenell, John, of Parva Smeton, laborer 0
5493996 2503113 2503113 defendant Oxenell John laborer 593197 593197 Oxenell, John, of Parva Smeton, laborer 0
5572449 2526486 2526486 defendant Thwaytes Henry gent 593197 593197 Thwaytes, Henry, of Parva Smeton, gent 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);