names

14 rows where place_id = 623579

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3753271 1942963 1942963 defendant Hurste Robert fishmonger 623579 623579 Hurste, Robert, of Longborowe, fishmonger 0
3753274 1942963 1942963 defendant Devenshyre Thomas yeoman 623579 623579 Devenshyre, Thomas, of Longborowe, yeoman 3
3825370 1965785 1965785 defendant Smyth Thomas yeoman 623579 623579 Smyth, Thomas, of Longborowe, yeoman 1
4099606 2060187 2060187 defendant Freman John husbandman 623579 623579 Freman, John, of Longborowe, husbandman 0
4099610 2060188 2060188 defendant Freman John tailor 623579 623579 Freman, John, of Longborowe, tailor 0
4105918 2062409 2062409 defendant Freman alias Twigwell John tailor 623579 623579 Freman alias Twigwell, John, of Longborowe, tailor 0
4122788 2068441 2068441 defendant Hambedge William husbandman 623579 623579 Hambedge, William, of Longborowe, husbandman 1
4122789 2068441 2068441 defendant Hall Thomas husbandman 623579 623579 Hall, Thomas, of Longborowe, husbandman 2
4148831 2077711 2077711 defendant Lygh Roland esq 623579 623579 Lygh, Roland, of Longborowe, esq 0
4194217 2093528 2093528 defendant Smythe Robert husbandman 623579 623579 Smythe, Robert, of Longborowe, husbandman 0
4194218 2093528 2093528 defendant Hambedge William husbandman 623579 623579 Hambedge, William, of Longborowe, husbandman 1
4194219 2093528 2093528 defendant Hall Thomas husbandman 623579 623579 Hall, Thomas, of Longborowe, husbandman 2
4218989 2102136 2102136 defendant Averyes Thomas yeoman 623579 623579 Averyes, Thomas, of Longborowe, yeoman 0
4399140 2164296 2164296 defendant Averye Thomas husbandman 623579 623579 Averye, Thomas, of Longborowe, husbandman 2

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