names

23 rows where place_id = 606607

✎ 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
3665868 1915258 1915258 defendant Borell Stephen yeoman 606607 606607 Borell, Stephen, of Wyndham, Norf, yeoman 1
3888226 1986318 1986318 defendant Burwell Stephen yeoman 606607 606607 Burwell, Stephen, of Wyndham, Norf, yeoman 0
3938979 2003369 2003369 defendant Haste Thomas gent 606607 606607 Haste, Thomas, of Wyndham, Norf, gent 1
3945108 2005383 2005383 defendant Gedney Francis chapman 606607 606607 Gedney, Francis, of Wyndham, Norf, chapman 1
3965238 2012454 2012454 defendant Mychell William innholder 606607 606607 Mychell, William, of Wyndham, Norf, innholder 1
3983603 2018905 2018905 defendant Applyarde John esq 606607 606607 Applyarde, John, of Wyndham, Norf, esq 0
3983615 2018909 2018909 defendant Applyard John esq 606607 606607 Applyard, John, of Wyndham, Norf, esq 0
3992449 2022064 2022064 defendant Gedney John chapman 606607 606607 Gedney, John, of Wyndham, Norf, chapman 3
4004962 2026556 2026556 defendant Gedney John chapman 606607 606607 Gedney, John, of Wyndham, Norf, chapman 1
4057808 2045177 2045177 defendant Kett Elias husbandman 606607 606607 Kett, Elias, of Wyndham, Norf, husbandman 0
4082778 2054143 2054143 defendant Haste Thomas gent 606607 606607 Haste, Thomas, of Wyndham, Norf, gent 3
4090806 2057001 2057001 defendant Dyxson Ralph gent 606607 606607 Dyxson, Ralph, of Wyndham, Norf, gent 0
4190266 2092101 2092101 defendant Haste Thomas gent 606607 606607 Haste, Thomas, of Wyndham, Norf, gent 2
4765585 2285226 2285226 defendant Hopton John yeoman 606607 606607 Hopton, John, of Wyndham, Norf, yeoman 0
4871303 2317992 2317992 defendant Roye John husbandman 606607 606607 Roye, John, of Wyndham, Norf, husbandman 0
4890783 2323865 2323865 defendant Dey John gent 606607 606607 Dey, John, of Wyndham, Norf, gent 4
4901936 2327211 2327211 defendant Dey John gent 606607 606607 Dey, John, of Wyndham, Norf, gent 4
4968357 2347501 2347501 defendant But William yeoman 606607 606607 But, William, of Wyndham, Norf, yeoman 1
5002120 2357522 2357522 defendant Wyndham John esq 606607 606607 Wyndham, John, of Wyndham, Norf, esq 0
5069652 2377421 2377421 defendant Wyndham John esq 606607 606607 Wyndham, John, of Wyndham, Norf, esq 0
5460093 2492949 2492949 defendant Harre William tinker 606607 606607 Harre, William, of Wyndham, Norf, tinker 3
5470523 2496103 2496103 defendant Sygar Thomas clerk 606607 606607 Sygar, Thomas, of Wyndham, Norf, clerk 3
5481926 2499525 2499525 defendant Sygar Thomas clerk 606607 606607 Sygar, Thomas, of Wyndham, Norf, clerk 3

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