names

17 rows where case_id = 2317083

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4868371 2317083 2317083 plaintiff (not given)   prioress of Irford Priory   Irford Priory, prioress of 0
4868372 2317083 2317083 defendant Warde John husbandman 590819 590819 Warde, John, of Bynbroke, husbandman 0
4868373 2317083 2317083 defendant Smyth John husbandman 590819 590819 Smyth, John, of Bynbroke, husbandman 1
4868374 2317083 2317083 defendant Frankyssh John husbandman 590819 590819 Frankyssh, John, of Bynbroke, husbandman 2
4868375 2317083 2317083 defendant Sibill John, senior husbandman 590819 590819 Sibill, John, senior, of Bynbroke, husbandman 3
4868376 2317083 2317083 defendant Misden William husbandman 590819 590819 Misden, William, of Bynbroke, husbandman 4
4868377 2317083 2317083 defendant Davy John tailor 590819 590819 Davy, John, of Bynbroke, tailor 5
4868378 2317083 2317083 defendant Fermour William chapman 590819 590819 Fermour, William, of Bynbroke, chapman 6
4868379 2317083 2317083 defendant Hede Thomas laborer 590819 590819 Hede, Thomas, of Bynbroke, laborer 7
4868380 2317083 2317083 defendant Boket Thomas husbandman 590819 590819 Boket, Thomas, of Bynbroke, husbandman 8
4868381 2317083 2317083 defendant Camage Robert husbandman 590819 590819 Camage, Robert, of Bynbroke, husbandman 9
4868382 2317083 2317083 defendant Sotherby William husbandman 590819 590819 Sotherby, William, of Bynbroke, husbandman 10
4868383 2317083 2317083 defendant Smyth William husbandman 590819 590819 Smyth, William, of Bynbroke, husbandman 11
4868384 2317083 2317083 defendant Fox William husbandman 590819 590819 Fox, William, of Bynbroke, husbandman 12
4868385 2317083 2317083 defendant Bekke John husbandman 590819 590819 Bekke, John, of Bynbroke, husbandman 13
4868386 2317083 2317083 defendant Ivre John husbandman 590819 590819 Ivre, John, of Bynbroke, husbandman 14
4868387 2317083 2317083 defendant Beche Robert flesshewer or butcher 590819 590819 Beche, Robert, of Bynbroke, flesshewer or butcher 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);