names

7 rows where case_id = 1869414

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605586 1869414 1869414 plaintiff Kylvyngton John bailiff, liberty of Bishop of Ely in Norf and Suff   Kylvyngton, John, bailiff, liberty of Bishop of Ely in Norf and Suff, executors of 0
3605587 1869414 1869414 plaintiff Goos John clerk   (Goos, John, clerk 1
3605588 1869414 1869414 plaintiff Toke Richard     Toke, Richard 2
3605589 1869414 1869414 plaintiff Leveryche Richard     Leveryche, Richard 3
3605590 1869414 1869414 defendant Norbery Hamon yeoman 591793 591793 Norbery, Hamon, of Wysebech, Cams, yeoman 0
3605591 1869414 1869414 defendant Symond Thomas yeoman 588580 588580 Symond, Thomas, of West Walton, yeoman 1
3605592 1869414 1869414 defendant Norbery George yeoman 588580 588580 Norbery, George, of West Walton, yeoman 2

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