names

26 rows where place_id = 598953

✎ 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
3634664 1905640 1905640 defendant Thresher John chaplain 598953 598953 Thresher, John, of Weston, Herts, chaplain 0
3759247 1944882 1944882 defendant Yardley Richard yeoman 598953 598953 Yardley, Richard, of Weston, Herts, yeoman 0
3842055 1971068 1971068 defendant Feld John butcher 598953 598953 Feld, John, of Weston, Herts, butcher 4
4011419 2028862 2028862 defendant Yardeley Richard husbandman 598953 598953 Yardeley, Richard, of Weston, Herts, husbandman 1
4072585 2050499 2050499 defendant Lawman Edward smith 598953 598953 Lawman, Edward, of Weston, Herts, smith 0
4076369 2051847 2051847 plaintiff Shipman John gent 598953 598953 Shipman, John, of Weston, Herts, gent 0
4105934 2062415 2062415 defendant Shipman John gent 598953 598953 Shipman, John, of Weston, Herts, gent 1
4292201 2127282 2127282 defendant Kympton George gent 598953 598953 Kympton, George, of Weston, Herts, gent 0
4314058 2135025 2135025 defendant Wylson George yeoman 598953 598953 Wylson, George, of Weston, Herts, yeoman 1
4342235 2144566 2144566 defendant Flecher Nicholas butcher 598953 598953 Flecher, Nicholas, of Weston, Herts, butcher 1
4357956 2150024 2150024 defendant Yardeley George gent 598953 598953 Yardeley, George, of Weston, Herts, gent 0
4371966 2155035 2155035 defendant Feilde Thomas Master of Arts 598953 598953 Feilde, Thomas, of Weston, Herts, clerk, Master of Arts 1
4788334 2292421 2292421 defendant Bailly John husbandman 598953 598953 Bailly, John, of Weston, Herts, husbandman 3
4814188 2300542 2300542 defendant Helder William husbandman 598953 598953 Helder, William, of Weston, Herts, husbandman 2
4826412 2304297 2304297 defendant Tryndey Sara widow 598953 598953 Tryndey, Sara, of Weston, Herts, widow 1
4839339 2308224 2308224 defendant Heldere William husbandman 598953 598953 Heldere, William, of Weston, Herts, husbandman 4
4921926 2333263 2333263 defendant Coly Walter husbandman 598953 598953 Coly, Walter, of Weston, Herts, husbandman 0
4959849 2344909 2344909 defendant Clyfton Walter yeoman 598953 598953 Clyfton, Walter, of Weston, Herts, yeoman 1
4995604 2355524 2355524 defendant Bole John   598953 598953 Bole, John, of Weston, Herts, shepherd 1
5013216 2360699 2360699 defendant Clyfton Walter husbandman 598953 598953 Clyfton, Walter, of Weston, Herts, husbandman 0
5023540 2363794 2363794 defendant Cayston Walter husbandman 598953 598953 Cayston, Walter, of Weston, Herts, husbandman 0
5130636 2395450 2395450 defendant Wodelond Edmund husbandman 598953 598953 Wodelond, Edmund, of Weston, Herts, husbandman 0
5150075 2401159 2401159 defendant Wodelond Edmund husbandman 598953 598953 Wodelond, Edmund, of Weston, Herts, husbandman 0
5150077 2401160 2401160 defendant Wodelond Edmund husbandman 598953 598953 Wodelond, Edmund, of Weston, Herts, husbandman 0
5168762 2406593 2406593 defendant Wodelond Edmund husbandman 598953 598953 Wodelond, Edmund, of Weston, Herts, husbandman 0
5584114 2530105 2530105 defendant Underwod Thomas husbandman 598953 598953 Underwod, Thomas, of Weston, Herts, husbandman 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);