names

14 rows where case_id = 1963643

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3818356 1963643 1963643 plaintiff Markaunt William     Markaunt, William 0
3818357 1963643 1963643 defendant Wyseman John   618735 618735 Wyseman, John, of Thornham, Suff, knight 0
3818358 1963643 1963643 defendant Wolverton Richard gent 634346 634346 Wolverton, Richard, of Wloverton, Suff, gent 1
3818359 1963643 1963643 defendant Higham William gent 605716 605716 Higham, William, of Wykham Broke, Suff, gent 2
3818360 1963643 1963643 defendant Yaxley Thomas clerk 604558 604558 Yaxley, Thomas, of Shotley, Suff, clerk 3
3818361 1963643 1963643 defendant Tyrell Robert clerk 588022 588022 Tyrell, Robert, of Gyslyngham, Suff, clerk 4
3818362 1963643 1963643 defendant Smyth Thomas clothman 592327 592327 Smyth, Thomas, of Melford, Suff, clothman 5
3818363 1963643 1963643 defendant Barker John yeoman 586912 586912 Barker, John, of Melford, yeoman 6
3818364 1963643 1963643 defendant Cooke John yeoman 586180 586180 Cooke, John, of Bury St Edmunds, yeoman 7
3818365 1963643 1963643 defendant Mersshe William yeoman 634347 634347 Mersshe, William, of Elmyswell, Suff, yeoman 8
3818366 1963643 1963643 defendant Lowthe Thomas esq 613330 613330 Lowthe, Thomas, of Sawtre, Hunts, esq 9
3818367 1963643 1963643 defendant Parmenter John sherman 585869 585869 Parmenter, John, of London, sherman 10
3818368 1963643 1963643 defendant Page William yeoman 634348 634348 Page, William, of Wrotham, Suff, yeoman 11
3818369 1963643 1963643 defendant Abell Edmund yeoman 595716 595716 Abell, Edmund, of Neylond, Suff, 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);