names

17 rows where case_id = 2263755

✎ 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
4694429 2263755 2263755 plaintiff Bohun John knight   Bohun, John, knight 0
4694430 2263755 2263755 defendant White Henry husbandman 785815 785815 White, Henry, of Mid Lovent, husbandman 0
4694431 2263755 2263755 defendant Apsele William yeoman 588918 588918 Apsele, William, of Petworth, yeoman 1
4694432 2263755 2263755 defendant Shettemelle Robert husbandman 589013 589013 together with Shettemelle, Robert, of Bury, husbandman 2
4694433 2263755 2263755 defendant Warnecamp William fisher man 587191 587191 Warnecamp, William, of Arundell, fisher man 3
4694434 2263755 2263755 defendant Seriaunt Robert husbandman 589013 589013 Seriaunt, Robert, of Bury, husbandman 4
4694435 2263755 2263755 defendant Abbynge Thomas husbandman 589013 589013 Abbynge, Thomas, of Bury, husbandman 5
4694436 2263755 2263755 defendant Curtays John   589013 589013 Curtays, John, of Bury, husb 6
4694437 2263755 2263755 defendant Brygges Robert   589013 589013 Brygges, Robert, of Bury, husb 7
4694438 2263755 2263755 defendant Bounde James   589013 589013 Bounde, James, of Bury, husb 8
4694439 2263755 2263755 defendant Belesone John tailor   Belesone, John, tailor 9
4694440 2263755 2263755 defendant Danvere John fisherman 587191 587191 Danvere, John, of Arundell, fisherman 10
4694441 2263755 2263755 defendant Lavor John   864809 864809 Lavor, John, of Bynderton, husb 11
4694442 2263755 2263755 defendant Coppedene Robert   864809 864809 Coppedene, Robert, of Bynderton, husb 12
4694443 2263755 2263755 defendant Picot John baker 785818 785818 Picot, John, of Storghden, baker 13
4694444 2263755 2263755 defendant Gelion Robert   785819 785819 Gelion, Robert, of Angemeryng, husb 14
4694445 2263755 2263755 defendant Wade Robert husbandman 785820 785820 Wade, Robert, of Cokkynge, husbandman 15

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