names

14 rows where case_id = 2307390

✎ 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
4836483 2307390 2307390 plaintiff Erithe John gent 732516 732516 Erithe, John, of Wolwich, Kent, gent 0
4836484 2307390 2307390 defendant Ricard John     Ricard, John 0
4836485 2307390 2307390 defendant Rand Robert   591868 591868 Rand, Robert, of Eltham 1
4836486 2307390 2307390 defendant Langley Ralph     Langley, Ralph 2
4836487 2307390 2307390 defendant Wolcy William     Wolcy, William 3
4836488 2307390 2307390 defendant Shotte Henry     Shotte, Henry 4
4836489 2307390 2307390 defendant atte John Nasshe   587649 587649 atte John, Nasshe, of Wykham 5
4836490 2307390 2307390 defendant Cook William     Cook, William 6
4836491 2307390 2307390 defendant Wodeman John   609888 609888 Wodeman, John, of Bokenham 7
4836492 2307390 2307390 defendant Holestyr William     Holestyr, William 8
4836493 2307390 2307390 defendant atte Lake Thomas     atte Lake, Thomas 9
4836494 2307390 2307390 defendant Merfyn Robert gent 591868 591868 Merfyn, Robert, of Eltham, gent 10
4836495 2307390 2307390 defendant Wodecok John yeoman 591868 591868 Wodecok, John, of Eltham, yeoman 11
4836496 2307390 2307390 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);