names

38 rows where place_id = 606861

✎ 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
3666787 1915555 1915555 defendant Twe John husbandman 606861 606861 Twe, John, of Eydon, husbandman 1
3683410 1920933 1920933 defendant Twe John husbandman 606861 606861 Twe, John, of Eydon, husbandman 1
3744394 1940147 1940147 defendant Wakelyn Nicholas gent 606861 606861 Wakelyn, Nicholas, of Eydon, gent 0
3744395 1940147 1940147 defendant Roper Margaret widow 606861 606861 Roper, Margaret, of Eydon, widow 1
3751161 1942289 1942289 defendant Olyver William husbandman 606861 606861 Olyver, William, of Eydon, husbandman 1
3756727 1944075 1944075 defendant Wakelyn Nicholas gent 606861 606861 Wakelyn, Nicholas, of Eydon, gent 0
3756728 1944075 1944075 defendant Roper Margaret widow 606861 606861 Roper, Margaret, of Eydon, widow 1
3786971 1953726 1953726 defendant Staunton Edmund   606861 606861 Staunton, Edmund, of Eydon, wool winder 0
3795172 1956356 1956356 plaintiff Coope John gent 606861 606861 Coope, John, of Eydon, gent 0
3800369 1958032 1958032 defendant Wakelyn Nicholas gent 606861 606861 Wakelyn, Nicholas, of Eydon, gent 0
3829033 1966961 1966961 defendant Hurst Thomas tailor 606861 606861 Hurst, Thomas, of Eydon, tailor 0
4296663 2128905 2128905 defendant Wakelyn Alban   606861 606861 Wakelyn, Alban, of Eydon, gent, his son 1
4332112 2141040 2141040 defendant Handes William yeoman 606861 606861 Handes, William, of Eydon, yeoman 1
4448570 2184480 2184480 defendant Smyth Henry   606861 606861 Smyth, Henry, of Eydon 0
4460724 2188413 2188413 plaintiff Smalbon Hugh   606861 606861 Smalbon, Hugh, of Eydon 0
4460731 2188414 2188414 plaintiff Smalbon Hugh   606861 606861 Smalbon, Hugh, of Eydon, on his own account 0
4460738 2188415 2188415 plaintiff Smalbon John, junior   606861 606861 Smalbon, John, junior, of Eydon, on his own account 0
4464050 2189427 2189427 plaintiff Wale John   606861 606861 Wale, John, of Eydon 0
4573226 2223160 2223160 defendant Smalbon Hugh   606861 606861 Smalbon, Hugh, of Eydon 3
4578418 2224736 2224736 defendant Hay John   606861 606861 Hay, John, of Eydon 2
4609119 2233958 2233958 defendant Trafford William   606861 606861 Trafford, William, of Eydon 0
4753108 2281357 2281357 defendant Robson William yeoman 606861 606861 Robson, William, of Eydon, yeoman 2
4956191 2343816 2343816 defendant Kymbell Thomas husbandman 606861 606861 Kymbell, Thomas, of Eydon, husbandman 0
4956192 2343816 2343816 defendant Mayhewe John husbandman 606861 606861 Mayhewe, John, of Eydon, husbandman 1
5004177 2358113 2358113 defendant Norton John husbandman 606861 606861 Norton, John, of Eydon, husbandman 0
5004178 2358113 2358113 defendant Colles William husbandman 606861 606861 Colles, William, of Eydon, husbandman 1
5129003 2394966 2394966 defendant Kynbell Thomas yeoman 606861 606861 Kynbell, Thomas, of Eydon, yeoman 0
5138869 2397871 2397871 defendant Kembell Thomas husbandman 606861 606861 Kembell, Thomas, of Eydon, husbandman 0
5147830 2400508 2400508 defendant Kynbell Thomas yeoman 606861 606861 Kynbell, Thomas, of Eydon, yeoman 0
5148182 2400614 2400614 defendant Kynbell Thomas yeoman 606861 606861 Kynbell, Thomas, of Eydon, yeoman 0
5167357 2406189 2406189 defendant Kynbell Thomas yeoman 606861 606861 Kynbell, Thomas, of Eydon, yeoman 0
5182816 2410727 2410727 defendant Kymbell Thomas yeoman 606861 606861 Kymbell, Thomas, of Eydon, yeoman 0
5198926 2415439 2415439 defendant Mayowe John husbandman 606861 606861 Mayowe, John, of Eydon, husbandman 0
5268528 2435916 2435916 defendant Mayowe John, senior husbandman 606861 606861 Mayowe, John, senior, of Eydon, husbandman 0
5268529 2435916 2435916 defendant Mayowe John, junior husbandman 606861 606861 Mayowe, John, junior, of Eydon, husbandman 1
5542341 2517727 2517727 defendant Assheton John clerk 606861 606861 Assheton, John, of Eydon, clerk 0
5607329 2537184 2537184 defendant Smyth George grasier 606861 606861 Smyth, George, of Eydon, grasier 0
5607331 2537185 2537185 defendant Smyth George grasier 606861 606861 Smyth, George, of Eydon, grasier 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);