names

16 rows where case_id = 2195809

✎ 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
4484360 2195809 2195809 plaintiff Percy Thomas knight   Percy, Thomas, knight, on his own account 0
4484361 2195809 2195809 defendant Grancourt John, senior     Grancourt, John, senior 0
4484362 2195809 2195809 defendant Smyth John   646998 646998 Smyth, John, of Aldermaston 1
4484363 2195809 2195809 defendant Dootes Edmund     Dootes, Edmund 2
4484364 2195809 2195809 defendant Bukke John     Bukke, John 3
4484365 2195809 2195809 defendant atte More John     atte More, John 4
4484366 2195809 2195809 defendant Mulleward John clerk   Mulleward, John, clerk 5
4484367 2195809 2195809 defendant atte More Ingelram     atte More, Ingelram 6
4484368 2195809 2195809 defendant Basyng (illegible)     Basyng, --- 7
4484369 2195809 2195809 defendant Umfray Nicholas     Umfray, Nicholas 8
4484370 2195809 2195809 defendant Mayhewe Robert   759872 759872 Mayhewe, Robert, of Padeworth 9
4484371 2195809 2195809 defendant atte Rook William     atte Rook, William 10
4484372 2195809 2195809 defendant Haune-- Richard     Haune--, Richard 11
4484373 2195809 2195809 defendant Warner Walter     Warner, Walter 12
4484374 2195809 2195809 defendant Theyhey John son of Thomas   Theyhey, John, son of Thomas 13
4484375 2195809 2195809 defendant Burgeys Jhn     Burgeys, Jhn 14

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