names

18 rows where case_id = 2362635

✎ 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
5019645 2362635 2362635 plaintiff de Sudeley Ralph knight   de Sudeley, Ralph, knight 0
5019646 2362635 2362635 plaintiff Beauchamp John knight   Beauchamp, John, knight 1
5019647 2362635 2362635 plaintiff Mountford William knight   Mountford, William, knight 2
5019648 2362635 2362635 plaintiff Nanfan John     Nanfan, John 3
5019649 2362635 2362635 plaintiff Norys John     Norys, John 4
5019650 2362635 2362635 plaintiff Menston   William   Menston, ,William 5
5019651 2362635 2362635 defendant Goold John husbandman 619533 619533 Goold, John, of Maysmore, husbandman 0
5019652 2362635 2362635 defendant Nevue Thomas husbandman 800620 800620 Nevue, Thomas, of Hardepery, husbandman 1
5019653 2362635 2362635 defendant Hill Walter husbandman 800620 800620 Hill, Walter, of Hardepery, husbandman 2
5019654 2362635 2362635 defendant Jolif Thomas husbandman 800620 800620 Jolif, Thomas, of Hardepery, husbandman 3
5019655 2362635 2362635 defendant Hill Thomas husbandman 800620 800620 Hill, Thomas, of Hardepery, husbandman 4
5019656 2362635 2362635 defendant Hayward Richard husbandman 800620 800620 Hayward, Richard, of Hardepery, husbandman 5
5019657 2362635 2362635 defendant Pauncefote Hugh esq 595797 595797 together with Pauncefote, Hugh, of Hasfeld, esq 6
5019658 2362635 2362635 defendant Elyot Richard husbandman 595797 595797 Elyot, Richard, of Hasfeld, husbandman 7
5019659 2362635 2362635 defendant Gryme Richard laborer 595797 595797 Gryme, Richard, of Hasfeld, laborer 8
5019660 2362635 2362635 defendant York John husbandman 595797 595797 York, John, of Hasfeld, husbandman 9
5019661 2362635 2362635 defendant Ferley Thomas yeoman 595797 595797 Ferley, Thomas, of Hasfeld, yeoman 10
5019662 2362635 2362635 defendant Birche Thomas yeoman 595797 595797 Birche, Thomas, of Hasfeld, yeoman 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);