names

5 rows where place_id = 817587

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4746623 2279503 2279503 plaintiff Hewelotte Thomas   817587 817587 Hewelotte, Thomas, of Kildewyk, vicar 0
4887605 2322959 2322959 defendant Cote Robert laborer 817587 817587 Cote, Robert, of Kildewyk, laborer 16
4887607 2322959 2322959 defendant Cote John husbandman 817587 817587 Cote, John, of Kildewyk, husbandman 18
4999441 2356703 2356703 defendant Somerscales Richard husbandman 817587 817587 Somerscales, Richard, of Kildewyk, husbandman 1
5046306 2370527 2370527 defendant de Clayton Robert   817587 817587 de Clayton, Robert, of Kildewyk, vicar 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);