names

13 rows where case_id = 2174301

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4430452 2174301 2174301 plaintiff York   in   York, abbot of St Mary's, in 0
4430453 2174301 2174301 defendant Maunesegh William de son of Roger   Maunesegh, William de, son of Roger 0
4430454 2174301 2174301 defendant Smyth William le son of Adam   Smyth, William le, son of Adam 1
4430455 2174301 2174301 defendant Lupton William de son of Julia Lupton   Lupton, William de, son of Julia Lupton 2
4430456 2174301 2174301 defendant Sweynesone William     Sweynesone, William 3
4430457 2174301 2174301 defendant Icorneshawe Richard de     Icorneshawe, Richard de 4
4430458 2174301 2174301 defendant Haybergh John de son of William   Haybergh, John de, son of William 5
4430459 2174301 2174301 defendant del Yate Adam   746603 746603 del Yate, Adam, of Midelton 6
4430460 2174301 2174301 defendant Smyth William le son of Adam   Smyth, William le son of Adam 7
4430461 2174301 2174301 defendant Todde Nicholas son of William   Todde, Nicholas, son of William 8
4430462 2174301 2174301 defendant atte Yate Thomas   755686 755686 atte Yate, Thomas, of Kesthwayt 9
4430463 2174301 2174301 defendant Sturnell Richard (legal representative)   Sturnell, Richard, executrix of 10
4430464 2174301 2174301 defendant Sturnell Celia formerly wife of Richard   Sturnell, Celia, formerly wife of Richard 11

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