names

13 rows where place_id = 595294

✎ 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
3619900 1873800 1873800 defendant Kynaston Thomas esq 595294 595294 Kynaston, Thomas, of Oswester, March of Wales, esq 0
3619905 1873801 1873801 defendant Kynaston Thomas esq 595294 595294 Kynaston, Thomas, of Oswester, March of Wales, esq 0
3619911 1873802 1873802 defendant Kynaston Thomas esq 595294 595294 Kynaston, Thomas, of Oswester, March of Wales, esq 0
3619917 1873803 1873803 defendant Kynaston Thomas esq 595294 595294 Kynaston, Thomas, of Oswester, March of Wales, esq 0
3700105 1926265 1926265 defendant Kyffyn Maurice chapman 595294 595294 Kyffyn, Maurice, of Oswester, March of Wales, chapman 3
3728250 1935094 1935094 defendant Edwardes Thomas clerk 595294 595294 Edwardes, Thomas, of Oswester, March of Wales, clerk 9
3729033 1935328 1935328 defendant Grace Adam yeoman 595294 595294 Grace, Adam, of Oswester, March of Wales, yeoman 0
3729035 1935329 1935329 defendant Grace Adam yeoman 595294 595294 Grace, Adam, of Oswester, March of Wales, yeoman 0
3729037 1935330 1935330 defendant Grace Adam yeoman 595294 595294 Grace, Adam, of Oswester, March of Wales, yeoman 0
3823820 1965338 1965338 defendant Lloid John gent 595294 595294 Lloid, John, of Oswester, March of Wales, gent 0
3823833 1965339 1965339 defendant Lloid John gent 595294 595294 Lloid, John, of Oswester, March of Wales, gent 0
3823845 1965340 1965340 defendant ap Mered Jenin Lloid gent 595294 595294 ap Mered, Jenin Lloid, of Oswester, March of Wales, gent 0
3823871 1965342 1965342 defendant Trevour Edward gent 595294 595294 Trevour, Edward, of Oswester, March of Wales, 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);