names

11 rows where case_id = 2183468

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4445187 2183468 2183468 plaintiff Courtenay Margaret de formerly wife of Hugh de Courtenay, formerly Earl of Devon   Courtenay, Margaret de, formerly wife of Hugh de Courtenay, formerly Earl of Devon 0
4445188 2183468 2183468 defendant Bykesbury William     Bykesbury, William 0
4445189 2183468 2183468 defendant Kena Walter     Kena, Walter 1
4445190 2183468 2183468 defendant Hyndeston Emma daughter of John   Hyndeston, Emma, daughter of John 2
4445191 2183468 2183468 defendant Golde Michael     Golde, Michael 3
4445192 2183468 2183468 defendant Saundre John     Saundre, John 4
4445193 2183468 2183468 defendant Saundre Henry     Saundre, Henry 5
4445194 2183468 2183468 defendant Hyndeston John     Hyndeston, John 6
4445195 2183468 2183468 defendant Taillour Richard     Taillour, Richard 7
4445196 2183468 2183468 defendant Smyth William     Smyth, William 8
4445197 2183468 2183468 defendant Vela John   600402 600402 Vela, John, of Kyngesbrigge, son of Henry 9

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