names

4 rows where case_id = 2322133

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4884753 2322133 2322133 plaintiff Wysbeche John canon of Brugnorth collegiate church, Salop, prebendary of Alveley, parson of Patryngton   Wysbeche, John, canon of Brugnorth collegiate church, Salop, prebendary of Alveley, parson of Patryngton, executors of 0
4884754 2322133 2322133 plaintiff Daye John chaplain   (Daye, John, chaplain 1
4884755 2322133 2322133 plaintiff More Robert chaplain   More, Robert, chaplain 2
4884756 2322133 2322133 defendant Mullyng Ralph chapman 610982 610982 Mullyng, Ralph, of Alcestre, Warks, chapman 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);