names

26 rows where place_id = 804440

✎ 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
4803471 2297273 2297273 defendant Hylton Godfrey   804440 804440 Hylton, Godfrey, of Irenham, Lincs, knight 0
4821029 2302656 2302656 defendant Hylton Godfrey   804440 804440 Hylton, Godfrey, of Irenham, Lincs, knight formerly esquire 0
4844738 2309874 2309874 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
4851205 2311825 2311825 defendant Hylton Geoffrey   804440 804440 Hylton, Geoffrey, of Irenham, Lincs, knight 0
4851210 2311826 2311826 defendant Hylton Geoffrey   804440 804440 Hylton, Geoffrey, of Irenham, Lincs, knight 0
4867468 2316792 2316792 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
4869604 2317454 2317454 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
4869606 2317455 2317455 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
4872311 2318301 2318301 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
4874811 2319065 2319065 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
4903437 2327682 2327682 defendant Hylton Godfrey   804440 804440 Hylton, Godfrey, of Irenham, Lincs, knight 0
4907309 2328851 2328851 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
4920016 2332771 2332771 defendant Hylton Godfrey   804440 804440 Hylton, Godfrey, of Irenham, Lincs, knight 0
4941723 2339433 2339433 defendant Hilton Geoffrey   804440 804440 Hilton, Geoffrey,of Irenham, Lincs, knight 2
4941840 2339447 2339447 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 1
4984286 2352225 2352225 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
5009927 2359778 2359778 defendant Hylton Godfrey esq 804440 804440 Hylton, Godfrey, of Irenham, Lincs, esq 0
5021037 2363049 2363049 defendant Hylton Godfrey   804440 804440 Hylton, Godfrey, of Irenham, Lincs, knight 1
5021057 2363052 2363052 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
5037417 2367814 2367814 defendant Hylton Godfrey   804440 804440 Hylton, Godfrey, of Irenham, Lincs, knight 0
5046569 2370613 2370613 defendant Hylton Geoffrey   804440 804440 Hylton, Geoffrey, of Irenham, Lincs, knight 0
5046595 2370616 2370616 defendant Hilton Godfrey   804440 804440 Hilton, Godfrey, of Irenham, Lincs, knight 0
5194920 2414263 2414263 defendant Hulton Godefrey gent 804440 804440 Hulton, Godefrey, of Irenham, Lincs, gent 0
5194922 2414264 2414264 defendant Hylton Godfrey gent 804440 804440 Hylton, Godfrey, of Irenham, Lincs, gent 0
5224940 2422967 2422967 defendant Hylton Godfrey gent 804440 804440 Hylton, Godfrey, of Irenham, Lincs, gent 0
5245748 2428920 2428920 defendant Hilton Godfrey gent 804440 804440 Hilton, Godfrey, of Irenham, Lincs, 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);