names

13 rows where place_id = 631793

✎ 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
3802746 1958757 1958757 defendant Sake John husbandman 631793 631793 Sake, John, of Woodford, Essex, husbandman 0
3840825 1970700 1970700 defendant Lynnett John yeoman 631793 631793 Lynnett, John, of Woodford, Essex, yeoman 1
3840828 1970701 1970701 defendant Lynnett John yeoman 631793 631793 Lynnett, John, of Woodford, Essex, yeoman 1
3986099 2019800 2019800 defendant Parker Henry gent 631793 631793 Parker, Henry, of Woodford, Essex, gent 1
3994347 2022730 2022730 defendant Parker Henry gent 631793 631793 Parker, Henry, of Woodford, Essex, gent 0
4007932 2027602 2027602 defendant Whytestone Barnard gent 631793 631793 Whytestone, Barnard, of Woodford, Essex, gent 0
4030159 2035432 2035432 defendant Whyteston Barnard esq 631793 631793 Whyteston, Barnard, of Woodford, Essex, esq 0
4030161 2035433 2035433 defendant Whyteston Bernard esq 631793 631793 Whyteston, Bernard, of Woodford, Essex, esq 0
4036406 2037705 2037705 defendant Whetstons Barnard gent 631793 631793 Whetstons, Barnard, of Woodford, Essex, gent 0
4067304 2048608 2048608 defendant Whetstone Barnard gent 631793 631793 Whetstone, Barnard, of Woodford, Essex, gent 0
4069710 2049452 2049452 defendant Perker Henry gent 631793 631793 Perker, Henry, of Woodford, Essex, gent 0
4208333 2098462 2098462 defendant Guyver Andrew yeoman 631793 631793 Guyver, Andrew, of Woodford, Essex, yeoman 1
4380775 2158237 2158237 defendant Poope Christopher yeoman 631793 631793 (Poope, Christopher, of Woodford, Essex, yeoman 1

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