names

14 rows where case_id = 2290988

✎ 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
4783935 2290988 2290988 plaintiff de Restwald Richard     de Restwald, Richard 0
4783936 2290988 2290988 plaintiff de Wherton Henry     de Wherton, Henry 1
4783937 2290988 2290988 defendant de Fourneys Adam yeoman 801871 801871 de Fourneys, Adam, of Tybbay, yeoman 0
4783938 2290988 2290988 defendant de Fournays John son of Adam, of Tibbay, laborer   de Fournays, John, son of Adam, of Tibbay, laborer 1
4783939 2290988 2290988 defendant del Water Robert husbandman 801872 801872 del Water, Robert, of Rondethwayt, husbandman 2
4783940 2290988 2290988 defendant de Tibbay John husbandman 775038 775038 de Tibbay, John, of Tibbay, husbandman 3
4783941 2290988 2290988 defendant Hudson Richard husbandman 801872 801872 Hudson, Richard, of Rondethwayt, husbandman 4
4783942 2290988 2290988 defendant Whiteheved John husbvandman 801872 801872 Whiteheved, John, of Rondethwayt, husbvandman 5
4783943 2290988 2290988 defendant de Fauxside William   628360 628360 de Fauxside, William, of Sedbergh, wright 6
4783944 2290988 2290988 defendant de Bland John yeoman 775038 775038 de Bland, John, of Tibbay, yeoman 7
4783945 2290988 2290988 defendant de Goekethorp Adam husbandman 775038 775038 de Goekethorp, Adam, of Tibbay, husbandman 8
4783946 2290988 2290988 defendant de Overton Robert husbandman 801874 801874 de Overton, Robert, of Raysegylhall, husbandman 9
4783947 2290988 2290988 defendant Lefechild Robert husbandman 775038 775038 Lefechild, Robert, of Tibbay, husbandman 10
4783948 2290988 2290988 defendant Robert son ot de Crosseby Thomas laborer 775038 775038 Robert son ot de Crosseby, Thomas, of Tibbay, 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);