names

18 rows where case_id = 2189710

✎ 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
4464954 2189710 2189710 plaintiff White John     White, John 0
4464955 2189710 2189710 defendant Qyntteney Robert   587448 587448 Qyntteney, Robert, of Brandeston 0
4464956 2189710 2189710 defendant Brayd Adam     Brayd, Adam 1
4464957 2189710 2189710 defendant Wodehous Henry     Wodehous, Henry 2
4464958 2189710 2189710 defendant atte Herre Robert   698653 698653 atte Herre, Robert, of Hoveton 3
4464959 2189710 2189710 defendant Sturmy Alan   595471 595471 Sturmy, Alan, of Whitwell 4
4464960 2189710 2189710 defendant Shorte John   595471 595471 Shorte, John, of Whitwell 5
4464961 2189710 2189710 defendant Berchere John     Berchere, John 6
4464962 2189710 2189710 defendant Grene Thomas   591466 591466 Grene, Thomas, of Hakford 7
4464963 2189710 2189710 defendant Aleyn Richard     Aleyn, Richard 8
4464964 2189710 2189710 defendant (not given) Roger his son   Roger, his son 9
4464965 2189710 2189710 defendant Haywier John     Haywier, John 10
4464966 2189710 2189710 defendant thrkild Robert     thrkild, Robert 11
4464967 2189710 2189710 defendant Cok Richard     Cok, Richard 12
4464968 2189710 2189710 defendant Gynger Robert     Gynger, Robert 13
4464969 2189710 2189710 defendant Rose Thomas   587387 587387 Rose, Thomas, of Boton 14
4464970 2189710 2189710 defendant Waleys Thomas     Waleys, Thomas 15
4464971 2189710 2189710 defendant Cok John   759864 759864 Cok, John, of Lammesse or Lammas 16

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