names

12 rows where place_id = 821806

✎ 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
4547555 2215169 2215169 defendant Austyn Henry   821806 821806 Austyn, Henry, of Colham, Middx 0
4917936 2332125 2332125 defendant le Straunge Richard   821806 821806 le Straunge, Richard, of Colham, Middx, knight 0
4918439 2332284 2332284 defendant Came Robert (legal representative) 821806 821806 Came, Robert, of Colham, Middx, executrix of 2
4955270 2343535 2343535 defendant Straunge Richard   821806 821806 Straunge, Richard, of Colham, Middx, knight 0
4998609 2356471 2356471 defendant Straunge Richard   821806 821806 Straunge, Richard, of Colham, Middx, knight 0
5034965 2367085 2367085 defendant le Staunge Richard   821806 821806 le Staunge, Richard, of Colham, Middx, knight 3
5071682 2378020 2378020 defendant Lynaston Roger esq 821806 821806 (Lynaston, Roger, of Colham, Middx, esq 1
5071687 2378021 2378021 defendant Knaston or Knafton Roger esq 821806 821806 (Knaston or Knafton, Roger, of Colham, Middx, esq 1
5251266 2430499 2430499 defendant Straunge John   821806 821806 Straunge, John, of Colham, Middx, knight 0
5251270 2430500 2430500 defendant Straunge John   821806 821806 Straunge, John, of Colham, Middx, knight 0
5310871 2448285 2448285 defendant Gray Richard husbandman 821806 821806 Gray, Richard, of Colham, Middx, husbandman 10
5572713 2526563 2526563 defendant Stanley Joan   821806 821806 Stanley, Joan, of Colham, Middx, widow, Lady Straunge 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);