names

9 rows where place_id = 619415

✎ 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
3729843 1935590 1935590 defendant Holwey John husbandman 619415 619415 Holwey, John, of Waterton, husbandman 0
3744886 1940301 1940301 defendant Holwey John husbandman 619415 619415 Holwey, John, of Waterton, husbandman 0
3893610 1988089 1988089 defendant Olyver Robert yeoman 619415 619415 Olyver, Robert, of Waterton, yeoman 0
4120602 2067644 2067644 defendant ap Jevan Edmund yeoman 619415 619415 ap Jevan, Edmund, of Waterton, yeoman 4
4176526 2087269 2087269 defendant Hore William yeoman 619415 619415 Hore, William, of Waterton, yeoman 4
5066181 2376409 2376409 defendant B--nt William laborer 619415 619415 B--nt, William, of Waterton, laborer 2
5082949 2381403 2381403 defendant Holy Nicholas husbandman 619415 619415 Holy, Nicholas, of Waterton, husbandman 0
5525619 2512603 2512603 plaintiff Hastyngyus Robert esq 619415 619415 Hastyngyus, Robert, of Waterton, esq 0
5531671 2514439 2514439 defendant Taillour John tailor 619415 619415 Taillour, John, of Waterton, tailor 4

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);