names

17 rows where case_id = 2379865

✎ 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
5077850 2379865 2379865 plaintiff Boteler Ralph   623650 623650 Boteler, Ralph, of Sudeley, knight 0
5077851 2379865 2379865 plaintiff Gargrave John esq   Gargrave, John, esq 1
5077852 2379865 2379865 plaintiff Levelord Adam gent   Levelord, Adam, gent 2
5077853 2379865 2379865 plaintiff Amyas John clerk   Amyas, John, clerk 3
5077854 2379865 2379865 plaintiff Knyght William     Knyght, William 4
5077855 2379865 2379865 defendant Burton Richard gent 585869 585869 Burton, Richard, of London, gent 0
5077856 2379865 2379865 defendant Haynes John yeoman 593655 593655 together with Haynes, John, of Eton, Bucks, yeoman 1
5077857 2379865 2379865 defendant Park John yeoman 788546 788546 Park, John, of Langley Mareys, Bucks, yeoman 2
5077858 2379865 2379865 defendant Park Robert husbandman 610823 610823 Park, Robert, of Langley Mareys, husbandman 3
5077859 2379865 2379865 defendant Park William husbandman 610823 610823 Park, William, of Langley Mareys, husbandman 4
5077860 2379865 2379865 defendant Fyssher Thomas husbandman 610823 610823 Fyssher, Thomas, of Langley Mareys, husbandman 5
5077861 2379865 2379865 defendant Sellam John husbandman 610823 610823 Sellam, John, of Langley Mareys, husbandman 6
5077862 2379865 2379865 defendant Waren John husbandman 610823 610823 Waren, John, of Langley Mareys, husbandman 7
5077863 2379865 2379865 defendant Squyer Giles husbandman 610823 610823 Squyer, Giles, of Langley Mareys, husbandman 8
5077864 2379865 2379865 defendant Maundevyle Richard husbandman 610823 610823 Maundevyle, Richard, of Langley Mareys, husbandman 9
5077865 2379865 2379865 defendant Westhorp John laborer 610823 610823 Westhorp, John, of Langley Mareys, laborer 10
5077866 2379865 2379865 defendant Rendal Richard laborer 610823 610823 Rendal, Richard, of Langley Mareys, laborer 11

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