names

20 rows where case_id = 2183231

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4444387 2183231 2183231 plaintiff Cok John     Cok, John 0
4444388 2183231 2183231 defendant Wyght John     Wyght, John 0
4444389 2183231 2183231 defendant Wele William     Wele, William 1
4444390 2183231 2183231 defendant Richeman William   757245 757245 Richeman, William, of Mersshton 2
4444391 2183231 2183231 defendant Basket Walter     Basket, Walter 3
4444392 2183231 2183231 defendant Homere Morris     Homere, Morris 4
4444393 2183231 2183231 defendant Palmere Thomas   757245 757245 Palmere, Thomas, of Mersshton 5
4444394 2183231 2183231 defendant Taillour Henry   757245 757245 Taillour, Henry, of Mersshton 6
4444395 2183231 2183231 defendant Burcy John   757246 757246 Burcy, John, of Yvele 7
4444396 2183231 2183231 defendant Bagge Henry clerk   Bagge, Henry, clerk 8
4444397 2183231 2183231 defendant Adam John   757245 757245 Adam, John, of Mersshton 9
4444398 2183231 2183231 defendant Cobbe John   757247 757247 Cobbe, John, of Attebarre 10
4444399 2183231 2183231 defendant Mauncevyle Richard     Mauncevyle, Richard 11
4444400 2183231 2183231 defendant Carpenter Robert   757244 757244 Carpenter, Robert, of Modeford 12
4444401 2183231 2183231 defendant Dollyng William     Dollyng, William 13
4444402 2183231 2183231 defendant Beaufitz Lawrence     Beaufitz, Lawrence 14
4444403 2183231 2183231 defendant Marchal John Heyward   Marchal, John, Heyward 15
4444404 2183231 2183231 defendant Danyel Robert     Danyel, Robert 16
4444405 2183231 2183231 defendant White John   757244 757244 White, John, of Modeford 17
4444406 2183231 2183231 defendant atte Hethe William   736091 736091 atte Hethe, William, of Branford 18

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