names

27 rows where place_id = 631254

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3774236 1949661 1949661 defendant Boyvyle Richard merchant 631254 631254 Boyvyle, Richard, of Burton, Nhants, merchant 0
3792054 1955368 1955368 defendant Boyvyle Richard merchant 631254 631254 Boyvyle, Richard, of Burton, Nhants, merchant 0
3799460 1957749 1957749 defendant Gage Henry gent 631254 631254 Gage, Henry, of Burton Latymer, Nhants, gent 0
3799462 1957750 1957750 defendant Gage Henry gent 631254 631254 Gage, Henry, of Burton Latymer, Nhants, gent 0
3957274 2009608 2009608 defendant Reve Robert husbandman 631254 631254 Reve, Robert, of Burton Latymer, Nhants, husbandman 1
4048894 2042047 2042047 defendant Plowrighte George yeoman 631254 631254 Plowrighte, George, of Burton Latymer, Nhants, yeoman 0
4063534 2047246 2047246 plaintiff Glover John yeoman 631254 631254 Glover, John, of Burton Latymer, Nhants, yeoman 0
4681645 2259871 2259871 defendant Rothewell John gent 631254 631254 Rothewell, John, of Burton, Nhants, gent 0
5066393 2376476 2376476 defendant Gold Thomas merchant 631254 631254 Gold, Thomas, of Burton, Nhants, merchant 0
5066396 2376477 2376477 defendant Gold Thomas merchant 631254 631254 Gold, Thomas, of Burton, Nhants, merchant 0
5131052 2395568 2395568 defendant Tanfeld John clerk 631254 631254 Tanfeld, John, of Burton Latimer, Nhants, clerk 1
5146051 2399969 2399969 defendant Tayllour Thomas yeoman 631254 631254 Tayllour, Thomas, of Burton, Nhants, yeoman 2
5150552 2401302 2401302 defendant Tanfeld Thomas   631254 631254 Tanfeld, Thomas, of Burton Latymer, Nhants, clerk, also of Beverley, Yorks 0
5150555 2401303 2401303 defendant Tanfeld Thomas   631254 631254 Tanfeld, Thomas, of Burton Latymer, Nhants, clerk, also of Beverley, Yorks 0
5196777 2414807 2414807 defendant Tailour Thomas drover 631254 631254 Tailour, Thomas, of Burton Latimer, Nhants, drover 0
5204785 2417146 2417146 defendant Tanfeld Thomas clerk 631254 631254 Tanfeld, Thomas, of Burton Latymer, Nhants, clerk 0
5209812 2418604 2418604 defendant Taylour Thomas drover 631254 631254 Taylour, Thomas, of Burton Latymer, Nhants, drover 0
5263349 2434284 2434284 defendant Alcote William gent 631254 631254 Alcote, William, of Burton Latymer, Nhants, gent 0
5264436 2434633 2434633 defendant Taillour Thomas husbandman 631254 631254 Taillour, Thomas, of Burton Latymer, Nhants, husbandman 2
5306253 2446853 2446853 defendant El_ John husbandman 631254 631254 El_, John, of Burton Latimer, Nhants, husbandman 1
5344090 2458330 2458330 defendant Alcot William gent 631254 631254 Alcot, William, of Burton Latymer, Nhants, gent 1
5346567 2459076 2459076 defendant Good Richard woolman 631254 631254 Good, Richard, of Burton Latymer, Nhants, woolman 0
5346570 2459077 2459077 defendant Goold Richard woolman 631254 631254 Goold, Richard, of Burton Latymer, Nhants, woolman 0
5346573 2459078 2459078 defendant Goolde Richard woolman 631254 631254 Goolde, Richard, of Burton Latymer, Nhants, woolman 0
5353984 2461309 2461309 defendant Goold Richard woolman 631254 631254 Goold, Richard, of Burton Latymer, Nhants, woolman 0
5353990 2461310 2461310 defendant Goold Richard woolman 631254 631254 Goold, Richard, of Burton Latymer, Nhants, woolman 1
5566394 2524761 2524761 defendant Boyvyll George gent 631254 631254 Boyvyll, George, of Burton Latymer, Nhants, gent 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);