names

21 rows where case_id = 2525051

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5567418 2525051 2525051 plaintiff Diconson John     Diconson, John 0
5567419 2525051 2525051 defendant Savage Edward   699110 699110 Savage, Edward, of Thorne, Yorks, knight 0
5567420 2525051 2525051 defendant Parkyn Thomas yeoman 878561 878561 Parkyn, Thomas, of Fysshlake, Yorks, yeoman 1
5567421 2525051 2525051 defendant Alette John yeoman 602031 602031 Alette, John, of Fysshlake, yeoman 2
5567422 2525051 2525051 defendant Rychard Thomas yeoman 602031 602031 Rychard, Thomas, of Fysshlake, yeoman 3
5567423 2525051 2525051 defendant Dole William yeoman 602031 602031 Dole, William, of Fysshlake, yeoman 4
5567424 2525051 2525051 defendant Wode Robert yeoman 602031 602031 Wode, Robert, of Fysshlake, yeoman 5
5567425 2525051 2525051 defendant Walker Thomas yeoman 602031 602031 Walker, Thomas, of Fysshlake, yeoman 6
5567426 2525051 2525051 defendant Saunders William yeoman 602031 602031 Saunders, William, of Fysshlake, yeoman 7
5567427 2525051 2525051 defendant Preston John yeoman 602031 602031 Preston, John, of Fysshlake, yeoman 8
5567428 2525051 2525051 defendant Wylson John yeoman 602031 602031 Wylson, John, of Fysshlake, yeoman 9
5567429 2525051 2525051 defendant Hall Robert barker 602031 602031 Hall, Robert, of Fysshlake, barker 10
5567430 2525051 2525051 defendant Hughson John butcher 900909 900909 Hughson, John, of Ernelathe, Yorks, butcher 11
5567431 2525051 2525051 defendant Womewell John yeoman 900910 900910 Womewell, John, of Armethorp, Yorks, yeoman 12
5567432 2525051 2525051 defendant Sklatter John yeoman 816655 816655 Sklatter, John, of Armethorp, yeoman 13
5567433 2525051 2525051 defendant Moldeston John yeoman 900911 900911 Moldeston, John, of Kylholme, Yorks, yeoman 14
5567434 2525051 2525051 defendant Hurst William yeoman 900912 900912 Hurst, William, of Gittehall, yeoman 15
5567435 2525051 2525051 defendant Moldeston Thomas yeoman 900913 900913 Moldeston, Thomas, of Brantton, Yorks, yeoman 16
5567436 2525051 2525051 defendant Moldeston William yeoman 900914 900914 Moldeston, William, of Brantton, yeoman 17
5567437 2525051 2525051 defendant Lowe John yeoman 900914 900914 Lowe, John, of Brantton, yeoman 18
5567438 2525051 2525051 defendant Willowesey Golbert yeoman 900914 900914 Willowesey, Golbert, of Brantton, yeoman 19

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