names

19 rows where place_id = 602391

✎ 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
3649912 1910337 1910337 defendant Suffolk John yeoman 602391 602391 Suffolk, John, of Helgey, Norf, yeoman 1
3664178 1914745 1914745 defendant Robynson William   602391 602391 Robynson, William, of Helgey, Norf 1
3756176 1943891 1943891 defendant Suttylby Thomas waterman 602391 602391 Suttylby, Thomas, of Helgey, Norf, waterman 0
4157738 2080777 2080777 defendant Hawes Henry gent 602391 602391 Hawes, Henry, of Helgey, Norf, gent 0
4658790 2248621 2248621 defendant Cateson Nicholas drover 602391 602391 Cateson, Nicholas, of Helgey, Norf, drover 0
4909467 2329500 2329500 defendant Ampulford William chapman 602391 602391 Ampulford, William, of Helgey, Norf, chapman 0
5067356 2376744 2376744 defendant Bryd or Byrd Robert yeoman 602391 602391 Bryd or Byrd, Robert, of Helgey, Norf, yeoman 0
5164344 2405306 2405306 defendant Sambrook Roger esq 602391 602391 Sambrook, Roger, of Helgey, Norf, esq 4
5173591 2407976 2407976 defendant Byrd Geoffrey husbandman 602391 602391 Byrd, Geoffrey, of Helgey, Norf, husbandman 2
5177608 2409144 2409144 defendant Sambrok Roger esq 602391 602391 Sambrok, Roger, of Helgey, Norf, esq 4
5200813 2415996 2415996 defendant Sambrok Roger esq 602391 602391 Sambrok, Roger, of Helgey, Norf, esq 4
5254274 2431464 2431464 defendant Smere John husbandman 602391 602391 Smere, John, of Helgey, Norf, husbandman 1
5266132 2435158 2435158 defendant Engulbright Thomas yeoman 602391 602391 Engulbright, Thomas, of Helgey, Norf, yeoman 2
5269302 2436122 2436122 defendant Frenssh Edmund yeoman 602391 602391 Frenssh, Edmund, of Helgey, Norf, yeoman 0
5277308 2438443 2438443 defendant Sambroke Roger gent 602391 602391 Sambroke, Roger, of Helgey, Norf, gent 0
5277323 2438445 2438445 defendant Sambroke Roger gent 602391 602391 Sambroke, Roger, of Helgey, Norf, gent 0
5278974 2438962 2438962 defendant Gent John husbandman 602391 602391 Gent, John, of Helgey, Norf, husbandman 2
5287709 2441429 2441429 defendant Drewe John yeoman 602391 602391 Drewe, John, of Helgey, Norf, yeoman 1
5548379 2519560 2519560 defendant Massyngham Thomas gent 602391 602391 Massyngham, Thomas, of Helgey, Norf, 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);