names

12 rows where case_id = 2170624

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4418364 2170624 2170624 plaintiff Wendevere Richard de chaplain   Wendevere, Richard de, chaplain 0
4418365 2170624 2170624 defendant Baron John   754177 754177 Baron, John, of Langeleye 0
4418366 2170624 2170624 defendant Baron Maud     Maud, his wife 1
4418367 2170624 2170624 defendant Hadresham John   754177 754177 Hadresham, John, of Langeleye, son of William 2
4418368 2170624 2170624 defendant Skynnere Richard le   754179 754179 Skynnere, Richard le, of Lange 3
4418369 2170624 2170624 defendant Osbarn Richard     Osbarn, Richard 4
4418370 2170624 2170624 defendant atte Hurne Peter     atte Hurne, Peter 5
4418371 2170624 2170624 defendant Fisshere Richard le     Fisshere, Richard le 6
4418372 2170624 2170624 defendant Whayte Henry le     Whayte, Henry le 7
4418373 2170624 2170624 defendant Repere Robert le dyer 754180 754180 Repere, Robert le, of South Farnham, dyer 8
4418374 2170624 2170624 defendant Muleward Michael le     Muleward, Michael le 9
4418375 2170624 2170624 defendant Chapman Robert     Chapman, Robert 10

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