names

14 rows where place_id = 671617

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4002267 2025593 2025593 defendant Hasyll George gent 671617 671617 Hasyll, George, of Marche, Isle of Ely, Cams, gent 0
4027690 2034551 2034551 defendant Fage Thomas fisher 671617 671617 Fage, Thomas, of Marche, Isle of Ely, Cams, fisher 0
4049157 2042146 2042146 defendant Fage John yeoman 671617 671617 Fage, John, of Marche, Isle of Ely, Cams, yeoman 0
4067564 2048716 2048716 defendant Humfrey Edmund husbandman 671617 671617 Humfrey, Edmund, of Marche, Isle of Ely, Cams, husbandman 1
4083554 2054392 2054392 defendant Sheppard John fisherman 671617 671617 Sheppard, John, of Marche, Isle of Ely, Cams, fisherman 0
4139167 2074373 2074373 defendant Taylour Robert husbandman 671617 671617 Taylour, Robert, of Marche, Isle of Ely, Cams, husbandman 0
4139169 2074374 2074374 defendant Taylour Robert husbandman 671617 671617 Taylour, Robert, of Marche, Isle of Ely, Cams, husbandman 0
4172560 2085862 2085862 defendant Dawson Thomas yeoman 671617 671617 Dawson, Thomas, of Marche, Isle of Ely, Cams, yeoman 2
4195755 2094069 2094069 defendant Dawson Thomas miller 671617 671617 Dawson, Thomas, of Marche, Isle of Ely, Cams, miller 2
4216007 2101092 2101092 defendant Shepperde John fishmonger 671617 671617 Shepperde, John, of Marche, Isle of Ely, Cams, fishmonger 0
4242151 2110368 2110368 defendant Shepperde John fishmonger 671617 671617 Shepperde, John, of Marche, Isle of Ely, Cams, fishmonger 0
4293852 2127870 2127870 defendant Atkinson Robert husbandman 671617 671617 Atkinson, Robert, of Marche, Isle of Ely, Cams, husbandman 0
4341925 2144455 2144455 defendant Ingram Richard yeoman 671617 671617 Ingram, Richard, of Marche, Isle of Ely, Cams, yeoman 0
4396900 2163532 2163532 defendant Sheppard John, senior fisher 671617 671617 Sheppard, John, senior, of Marche, Isle of Ely, Cams, fisher 0

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