names

21 rows where place_id = 612199

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692072 1923690 1923690 defendant Burdon John clerk 612199 612199 Burdon, John, of Cheshunt, clerk 1
3704713 1927761 1927761 defendant Haryson Thomas husbandman 612199 612199 Haryson, Thomas, of Cheshunt, husbandman 0
3717812 1931874 1931874 defendant Kent Edmund husbandman 612199 612199 Kent, Edmund, of Cheshunt, husbandman 2
3753382 1942996 1942996 defendant Thressher Henry husbandman 612199 612199 Thressher, Henry, of Cheshunt, husbandman 0
3753384 1942996 1942996 defendant Palle Thomas husbandman 612199 612199 (Palle, Thomas, of Cheshunt, husbandman 2
3753385 1942996 1942996 defendant Penley Margaret widow 612199 612199 Penley, Margaret, of Cheshunt, widow 3
3832672 1968144 1968144 plaintiff Hyll Robert (legal representative) 612199 612199 Hyll, Robert, of Cheshunt, executors of 0
3832675 1968144 1968144 defendant Empson John tailor 612199 612199 Empson, John, of Cheshunt, tailor 0
3843892 1971629 1971629 defendant Awmond Robert butcher 612199 612199 Awmond, Robert, of Cheshunt, butcher 1
3858942 1976481 1976481 defendant Feld John maltman 612199 612199 Feld, John, of Cheshunt, maltman 2
3907477 1992794 1992794 defendant Lucas John collier 612199 612199 Lucas, John, of Cheshunt, collier 0
3907478 1992794 1992794 defendant Stanes William carpenter 612199 612199 Stanes, William, of Cheshunt, carpenter 1
3920375 1997157 1997157 defendant Cokerell Robert maltman 612199 612199 Cokerell, Robert, of Cheshunt, maltman 0
4194753 2093723 2093723 defendant Cordell Edmund   612199 612199 Cordell, Edmund, of Cheshunt, Herts husbandman 1
4372018 2155054 2155054 defendant Cockerell Ralph maltman 612199 612199 Cockerell, Ralph, of Cheshunt, maltman 1
4695021 2263937 2263937 defendant Gervays William   612199 612199 Gervays, William, of Cheshunt, wood monger 2
5231991 2424925 2424925 defendant Derlyng William yeoman 612199 612199 Derlyng, William, of Cheshunt, yeoman 3
5329049 2453767 2453767 defendant Mercer William   612199 612199 Mercer, William, of Cheshunt, coal carter 0
5330076 2454074 2454074 defendant Howe John collier 612199 612199 Howe, John, of Cheshunt, collier 3
5449116 2489630 2489630 defendant Adam Edmund husbandman 612199 612199 Adam, Edmund, of Cheshunt, husbandman 1
5556027 2521758 2521758 defendant Kent John yeoman 612199 612199 Kent, John, of Cheshunt, 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);