names

3 rows where case_id = 2031770

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4019683 2031770 2031770 plaintiff Well John bachelor of theology, prebendary of Yatton in Wells Cathedral, of Pembroke Hall, Cambridge   Well, John, bachelor of theology, prebendary of Yatton in Wells Cathedral, of Pembroke Hall, Cambridge, administrator of 0
4019684 2031770 2031770 plaintiff Well Richard his brother   Well, Richard, his brother 1
4019685 2031770 2031770 defendant Harrys Thomas husbandman 611753 611753 Harrys, Thomas, of Yatton, Soms, husbandman 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);