names

14 rows where case_id = 2307391

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4836497 2307391 2307391 plaintiff Erithe John gent 809041 809041 Erithe, John, of Woolwich, Kent, gent 0
4836498 2307391 2307391 defendant Ricard John     Ricard, John 0
4836499 2307391 2307391 defendant Rand Robert   591868 591868 Rand, Robert, of Eltham 1
4836500 2307391 2307391 defendant Langley Ralph     Langley, Ralph 2
4836501 2307391 2307391 defendant Wolcy William     Wolcy, William 3
4836502 2307391 2307391 defendant Shotte Henry     Shotte, Henry 4
4836503 2307391 2307391 defendant atte Nasshe John   587649 587649 atte Nasshe, John, of Wykham 5
4836504 2307391 2307391 defendant Cook William     Cook, William 6
4836505 2307391 2307391 defendant Wodeman John   638690 638690 Wodeman, John, of Beckenham 7
4836506 2307391 2307391 defendant Holestyr William     Holestyr, William 8
4836507 2307391 2307391 defendant atte Lake Thomas     atte Lake, Thomas 9
4836508 2307391 2307391 defendant Merfyn Robert gent 591868 591868 Merfyn, Robert, of Eltham, gent 10
4836509 2307391 2307391 defendant Wodecok John yeoman 591868 591868 Wodecok, John, of Eltham, yeoman 11
4836510 2307391 2307391 defendant atte Ree Richard yeoman 591868 591868 atte Ree, Richard, of Eltham, yeoman 12

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