names

13 rows where case_id = 2304943

✎ 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
4828451 2304943 2304943 plaintiff ap Harry Richard     ap Harry, Richard 0
4828452 2304943 2304943 defendant Hergest Hugh esq 588114 588114 Hergest, Hugh, of Walterston, esq 0
4828453 2304943 2304943 defendant Podmore William husbandman 599944 599944 Podmore, William, of Lulham, husbandman 1
4828454 2304943 2304943 defendant Carpenter John yeoman 592031 592031 Carpenter, John, of Madley, yeoman 2
4828455 2304943 2304943 defendant Cheser David husbandman 808841 808841 Cheser, David, of Over Preston, husbandman 3
4828456 2304943 2304943 defendant Orchard John laboroer 757174 757174 Orchard, John, of Welynton, laboroer 4
4828457 2304943 2304943 defendant Croyne Thomas yeoman 808842 808842 Croyne, Thomas, of Neder Brompton, yeoman 5
4828458 2304943 2304943 defendant Hugyns William husbandman 594989 594989 Hugyns, William, of Tyberton, husbandman 6
4828459 2304943 2304943 defendant Duke Walter yeoman 594989 594989 Duke, Walter, of Tyberton, yeoman 7
4828460 2304943 2304943 defendant Coly Philip laborer 588114 588114 Coly, Philip, of Walterston, laborer 8
4828461 2304943 2304943 defendant Goghyeyr Geoffrey laborer 588114 588114 Goghyeyr, Geoffrey, of Walterston, laborer 9
4828462 2304943 2304943 defendant Eva Jenan laborer 588114 588114 Eva, Jenan, of Walterston, laborer 10
4828463 2304943 2304943 defendant ap Jenan ap Howell Howell laborer 588114 588114 ap Jenan ap Howell, Howell, of Walterston, 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);