names

26 rows where place_id = 603173

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647959 1909760 1909760 defendant Grace John butcher 603173 603173 Grace, John, of Barkhamsted St Peter, butcher 0
3653709 1911423 1911423 defendant Newall William clerk 603173 603173 Newall, William, of Barkhamsted, clerk 0
3653710 1911423 1911423 defendant Legge Thomas collier 603173 603173 Legge, Thomas, of Barkhamsted, collier 1
3653711 1911423 1911423 defendant West John husbandman 603173 603173 West, John, of Barkhamsted, husbandman 2
3701065 1926581 1926581 defendant Smyth John hosier 603173 603173 Smyth, John, of Barkhamsted, hosier 3
3749322 1941713 1941713 defendant Hylle John shoemaker 603173 603173 Hylle, John, of Barkhamsted, shoemaker 4
3749707 1941820 1941820 defendant Jurdayn Richard husbandman 603173 603173 Jurdayn, Richard, of Barkhamsted, husbandman 1
3751972 1942536 1942536 plaintiff Pegge William   603173 603173 Pegge, William, of Barkhamsted St Peter 0
3768412 1947767 1947767 plaintiff Pegge William   603173 603173 Pegge, William, of Barkhamsted St Peter 0
3768414 1947768 1947768 plaintiff Pegge William gent 603173 603173 Pegge, William, of Barkhamsted St Peter, gent 0
3768591 1947823 1947823 defendant Alen John laborer 603173 603173 Alen, John, of Barkhamsted St Peter, laborer 2
3768593 1947823 1947823 defendant Jakes Roger gent 603173 603173 Jakes, Roger, of Barkhamsted St Peter, gent 4
3770972 1948607 1948607 defendant Blocke John collier 603173 603173 Blocke, John, of Barkhamsted, collier 0
3781705 1952021 1952021 defendant Kyte alias Clerke Roger husbandman 603173 603173 Kyte alias Clerke, Roger, of Barkhamsted, husbandman 0
3784201 1952845 1952845 defendant Hykman Thomas smith 603173 603173 Hykman, Thomas, of Barkhamsted St Peter, smith 0
3784202 1952845 1952845 defendant Podyfate Thomas weaver 603173 603173 Podyfate, Thomas, of Barkhamsted St Peter, weaver 1
3784203 1952845 1952845 defendant Cok Richard tanner 603173 603173 Cok, Richard, of Barkhamsted St Peter, tanner 2
3796426 1956751 1956751 defendant Axstell John husbandman 603173 603173 Axstell, John, of Barkhamsted, husbandman 0
3799389 1957729 1957729 defendant Jurden Richard husbandman 603173 603173 Jurden, Richard, of Barkhamsted, husbandman 2
3799390 1957729 1957729 defendant Borne John smith 603173 603173 Borne, John, of Barkhamsted, smith 3
3883409 1984720 1984720 defendant Smyth John hosier 603173 603173 Smyth, John, of Barkhamsted, hosier 0
3883410 1984720 1984720 defendant Blakwall George baker 603173 603173 Blakwall, George, of Barkhamsted, baker 1
3902353 1991019 1991019 defendant Penne John butcher 603173 603173 Penne, John, of Barkhamsted, butcher 0
3905022 1991944 1991944 defendant Grubbe Robert yeoman 603173 603173 Grubbe, Robert, of Barkhamsted, yeoman 0
4168306 2084397 2084397 defendant Blunte John chandler 603173 603173 Blunte, John, of Barkhamsted St Peter, chandler 0
4328532 2139858 2139858 defendant Clarcke Freman butcher 603173 603173 Clarcke, Freman, of Barkhamsted, butcher 1

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