names

11 rows where case_id = 2200722

✎ 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
4500305 2200722 2200722 plaintiff Hunt William (legal representative) 598879 598879 Hunt, William, of Gotham, parson, executors of 0
4500306 2200722 2200722 plaintiff Rodyngton William de clerk   (Rodyngton, William de, clerk 1
4500307 2200722 2200722 plaintiff Hunte Thomas     Hunte, Thomas 2
4500308 2200722 2200722 plaintiff Pare Ralph de     Pare, Ralph de 3
4500309 2200722 2200722 defendant Mylner John   587136 587136 Mylner, John, of Derby 0
4500310 2200722 2200722 defendant Tunley Adam   587136 587136 Tunley, Adam, of Derby 1
4500311 2200722 2200722 defendant atte Halle Richard   607314 607314 atte Halle, Richard, of Wylne 2
4500312 2200722 2200722 defendant atte Halle John   763768 763768 atte Halle, John, of Wilne, son of Richard 3
4500313 2200722 2200722 defendant Shepherd William   761132 761132 Shepherd, William, of Shardelowe 4
4500314 2200722 2200722 defendant Tebbe Alan     Tebbe, Alan 5
4500315 2200722 2200722 defendant Smyth John   593783 593783 Smyth, John, of Matlok 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);