names

11 rows where place_id = 597500

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603931 1868900 1868900 defendant Nelson Robert (legal representative) 597500 597500 Nelson, Robert, of Wheldale, executors of 0
3628826 1903890 1903890 defendant Gascoign Ralph gent 597500 597500 Gascoign, Ralph, of Wheldale, gent 0
3647837 1909719 1909719 defendant Gascoigne Ralph gent 597500 597500 Gascoigne, Ralph, of Wheldale, gent 0
3732154 1936292 1936292 defendant Gascoign Ralph (legal representative) 597500 597500 Gascoign, Ralph, of Wheldale, gent, executrix of 1
4927944 2335172 2335172 plaintiff Seriant William   597500 597500 Seriant, William, of Wheldale 0
4954383 2343278 2343278 defendant Sergeant alias Sergeantson William yeoman 597500 597500 Sergeant alias Sergeantson, William, of Wheldale, yeoman 0
4961776 2345486 2345486 defendant Sergeantson William or of Pountfret, yeoman 597500 597500 Sergeantson William, of Wheldale, or of Pountfret, yeoman 0
5358778 2462805 2462805 defendant Nelson Robert husbandman 597500 597500 Nelson, Robert, of Wheldale, husbandman 0
5528355 2513414 2513414 defendant Meryng Thomas esq 597500 597500 Meryng, Thomas, of Wheldale, esq 21
5582098 2529471 2529471 defendant Gaskewayn Ralph gent 597500 597500 Gaskewayn, Ralph, of Wheldale, gent 0
5582101 2529472 2529472 defendant Gaskowayn Ralph gent 597500 597500 Gaskowayn, Ralph, of Wheldale, 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);