names

8 rows where case_id = 2264027

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4695348 2264027 2264027 plaintiff Bristowe wm     Bristowe, wm 0
4695349 2264027 2264027 defendant Clerk Thomas   587956 587956 Clerk, Thomas, of Byrton 0
4695350 2264027 2264027 defendant Baker Walter     Baker, Walter 1
4695351 2264027 2264027 defendant Wilby John fisherman 786016 786016 Wilby, John, of Lanceton, fisherman 2
4695352 2264027 2264027 defendant Smert John   592519 592519 Smert, John, of Wyke 3
4695353 2264027 2264027 defendant atte Richard Water   592519 592519 atte Richard, Water, of Wyke 4
4695354 2264027 2264027 defendant Merlyng Walter   593484 593484 Merlyng, Walter, of Bere 5
4695355 2264027 2264027 defendant Fisssher John   626200 626200 Fisssher, John, of Poole 6

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