names

13 rows where case_id = 2265868

✎ 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
4701504 2265868 2265868 plaintiff Gerard Richard   787226 787226 Gerard, Richard, of Stritford 0
4701505 2265868 2265868 defendant Shirwynd John yeoman 620832 620832 Shirwynd, John, of Bolton on Swale, yeoman 0
4701506 2265868 2265868 defendant Cote Robert de laborer 764659 764659 Cote, Robert de, of Hippeswell, laborer 1
4701507 2265868 2265868 defendant Huntyngdale Robert husbandman 764659 764659 Huntyngdale, Robert, of Hippeswell, husbandman 2
4701508 2265868 2265868 defendant Tomson John husbandman 764659 764659 Tomson, John, of Hippeswell, husbandman 3
4701509 2265868 2265868 defendant Woller William yeoman 764659 764659 Woller, William, of Hippeswell, yeoman 4
4701510 2265868 2265868 defendant Smyth John husbandman 787226 787226 Smyth, John, of Stritford, husbandman 5
4701511 2265868 2265868 defendant Skelton Robert de husbandman 616585 616585 Skelton, Robert de, of Stretford, husbandman 6
4701512 2265868 2265868 defendant Talkan John husbandman 787226 787226 Talkan, John, of Stritford, husbandman 7
4701513 2265868 2265868 defendant Chery John husbandman 787226 787226 Chery, John, of Stritford, husbandman 8
4701514 2265868 2265868 defendant Oaker John husbandman 787227 787227 Oaker, John, of Bolron, husbandman 9
4701515 2265868 2265868 defendant Williamson John husbandman 787227 787227 Williamson, John, of Bolron, husbandman 10
4701516 2265868 2265868 defendant Youson John husbandman 787228 787228 Youson, John, of Barnard Castle, county Durham, husbandman 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);