names

17 rows where place_id = 607215

✎ 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
3668225 1916008 1916008 defendant Carter Thomas husbandman 607215 607215 Carter, Thomas, of Blunston, husbandman 0
3754582 1943391 1943391 defendant Thurmode John husbandman 607215 607215 Thurmode, John, of Blunston, husbandman 0
3788110 1954074 1954074 defendant Smyth James husbandman 607215 607215 Smyth, James, of Blunston, husbandman 0
3804328 1959289 1959289 defendant Smyth James husbandman 607215 607215 Smyth, James, of Blunston, husbandman 0
4675318 2257890 2257890 defendant Seman John yeoman 607215 607215 Seman, John, of Blunston, yeoman 2
4677800 2258675 2258675 defendant Tad--- William ploughman 607215 607215 Tad---, William, of Blunston, ploughman 4
4683077 2260324 2260324 defendant Yernemuth Anne de   607215 607215 Yernemuth, Anne de, of Blunston, gentle woman 0
4683078 2260324 2260324 defendant Yernemuth Henry de gent 607215 607215 Yernemuth, Henry de, of Blunston, gent 1
4699119 2265189 2265189 defendant Seman John shipman 607215 607215 Seman, John, of Blunston, shipman 0
4700022 2265429 2265429 defendant Yernemuth Henry gent 607215 607215 Yernemuth, Henry, of Blunston, gent 1
4724215 2272867 2272867 defendant Yernemuth Anne   607215 607215 Yernemuth, Anne, of Blunston, gentle woman, formerly wife of John 0
4724216 2272867 2272867 defendant Yernemuth Henry gent 607215 607215 Yernemuth, Henry, of Blunston, gent 1
5061422 2375005 2375005 defendant Starys Adam husbandman 607215 607215 Starys, Adam, of Blunston, husbandman 0
5074479 2378870 2378870 defendant Yermouth John gent 607215 607215 Yermouth, John, of Blunston, gent 1
5099575 2386314 2386314 defendant Yernemouth Henry gent 607215 607215 Yernemouth, Henry, of Blunston, gent 0
5149279 2400919 2400919 defendant Yermouth Henry gent 607215 607215 Yermouth, Henry, of Blunston, gent 4
5351371 2460527 2460527 defendant Crakenell Robert yeoman 607215 607215 Crakenell, Robert, of Blunston, or of Winston, yeoman 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);