names

21 rows where place_id = 590266

✎ 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
3600437 1867784 1867784 plaintiff Wykes John merchant 590266 590266 Wykes, John, of Lynn, merchant 0
3668130 1915979 1915979 defendant Amfles Richard (legal representative) 590266 590266 Amfles, Richard, of Lynn, merchant, executor of 0
3668133 1915980 1915980 defendant Amfles Richard (legal representative) 590266 590266 Amfles, Richard, of Lynn, merchant, executor of 0
3693981 1924320 1924320 plaintiff Miller Thomas merchant 590266 590266 Miller, Thomas, of Lynn, merchant 0
3789141 1954413 1954413 defendant Rede John vintner 590266 590266 Rede, John, of Lynn, vintner 3
3824749 1965615 1965615 plaintiff Whyte William (legal representative) 590266 590266 Whyte, William, of Lynn, merchant, executors of 0
3902230 1990982 1990982 defendant Byllyngbroke Thomas, senior (legal representative) 590266 590266 Byllyngbroke, Thomas, senior, of Lynn, merchant, executor of 0
3906935 1992608 1992608 plaintiff Myller Thomas merchant 590266 590266 Myller, Thomas, of Lynn, merchant 0
3909610 1993520 1993520 plaintiff Some Robert merchant 590266 590266 Some, Robert, of Lynn, merchant 0
3909612 1993521 1993521 plaintiff Some Robert merchant 590266 590266 Some, Robert, of Lynn, merchant 0
3911397 1994126 1994126 defendant Harryson John yeoman 590266 590266 Harryson, John, of Lynn, yeoman 0
4000409 2024915 2024915 plaintiff Grave Thomas merchant 590266 590266 Grave, Thomas, of Lynn, merchant 0
4000412 2024916 2024916 plaintiff Grave Thomas merchant 590266 590266 Grave, Thomas, of Lynn, merchant 0
4355579 2149174 2149174 defendant Boston Thomas (legal representative) 590266 590266 Boston, Thomas, of Lynn, administrator of 0
4379691 2157833 2157833 defendant Boston Thomas (legal representative) 590266 590266 Boston, Thomas, of Lynn, administrator of 0
5072668 2378309 2378309 plaintiff Thorsby John, junior merchant 590266 590266 Thorsby, John, junior, of Lynn, merchant 0
5558425 2522413 2522413 plaintiff Pepyr Robert fishmonger 590266 590266 Pepyr, Robert, of Lynn, fishmonger 0
5587012 2530965 2530965 defendant Wettyllsey John (legal representative) 590266 590266 Wettyllsey, John, of Lynn, merchant, executor of 0
5587015 2530966 2530966 defendant Wettyllsey John (legal representative) 590266 590266 Wettyllsey, John, of Lynn, merchant, executor of 0
5591588 2532350 2532350 plaintiff Thursby Thomas merchant 590266 590266 Thursby, Thomas, of Lynn, merchant 0
5591592 2532351 2532351 plaintiff Thursby Thomas merchant 590266 590266 Thursby, Thomas, of Lynn, merchant 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);