names

8 rows where case_id = 2196519

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4486587 2196519 2196519 plaintiff Satepath John     Satepath, John 0
4486588 2196519 2196519 defendant Hopere Richard     Hopere, Richard 0
4486589 2196519 2196519 defendant Hunte atte Slade William     Hunte atte Slade, William 1
4486590 2196519 2196519 defendant Rugge Henry   588317 588317 Rugge, Henry, of Colyford 2
4486591 2196519 2196519 defendant Houchyns John     Houchyns, John 3
4486592 2196519 2196519 defendant Valans John     Valans, John 4
4486593 2196519 2196519 defendant Taverner John   613865 613865 Taverner, John, of Seton 5
4486594 2196519 2196519 defendant atte More John of Axmynstre     atte More, John of Axmynstre 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);