names

40 rows where place_id = 609597

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3679277 1919579 1919579 defendant Kyllyngmarsshe Thomas gent 609597 609597 Kyllyngmarsshe, Thomas, of Dunmowe, Essex, gent 1
3750093 1941943 1941943 defendant Goldham Richard husbandman 609597 609597 Goldham, Richard, of Dunmowe, Essex, husbandman 2
3805633 1959705 1959705 defendant Prentyce Richard (legal representative) 609597 609597 Prentyce, Richard, of Dunmowe, Essex, yeoman, executrix of 0
3877343 1982669 1982669 defendant Gager William yeoman 609597 609597 Gager, William, of Dunmowe, Essex, yeoman 4
3882997 1984578 1984578 defendant Waskett Robert chapman 609597 609597 Waskett, Robert, of Dunmowe, Essex, chapman 2
3950887 2007376 2007376 defendant Hawkyns John smith 609597 609597 Hawkyns, John, of Dunmowe, Essex, smith 3
3953036 2008127 2008127 defendant Cramys Robert chapman 609597 609597 Cramys, Robert, of Dunmowe, Essex, chapman 4
3975161 2015877 2015877 defendant Walden Silvester merchant 609597 609597 Walden, Silvester, of Dunmowe, Essex, merchant 0
4003674 2026080 2026080 defendant Cranwys Robert   609597 609597 Cranwys, Robert, of Dunmowe, essex, surgeon 3
4108834 2063411 2063411 defendant Dawes Robert yeoman 609597 609597 (Dawes, Robert, of Dunmowe, Essex, yeoman 1
4188046 2091321 2091321 defendant Weate alias Turner William yeoman 609597 609597 Weate alias Turner, William, of Dunmowe, Essex, yeoman 0
4214895 2100710 2100710 defendant Heade Edward yeoman 609597 609597 Heade, Edward, of Dunmowe, Essex, yeoman 2
4240403 2109768 2109768 defendant Danet Thomas esq 609597 609597 Danet, Thomas, of Dunmowe, Essex, esq 0
4241270 2110064 2110064 defendant Heade Edward yeoman 609597 609597 Heade, Edward, of Dunmowe, Essex, yeoman 2
4264807 2117867 2117867 defendant Thorne Thomas chapman 609597 609597 Thorne, Thomas, of Dunmowe, Essex, chapman 0
4349487 2147084 2147084 defendant Aylett Ambrose chapman 609597 609597 Aylett, Ambrose, of Dunmowe, Essex, chapman 1
4354725 2148880 2148880 defendant Edwicke John chapman 609597 609597 Edwicke, John, of Dunmowe, Essex, chapman 0
4354731 2148881 2148881 defendant Averell Anthony gent 609597 609597 Averell, Anthony, of Dunmowe, Essex, gent 0
4400065 2164610 2164610 defendant Biston Denise widow 609597 609597 (Biston, Denise, of Dunmowe, Essex, widow 1
4406198 2166638 2166638 defendant Aylet Ambrose chapman 609597 609597 Aylet, Ambrose, of Dunmowe, Essex, chapman 0
4685677 2261110 2261110 defendant Pulter John pulter 609597 609597 Pulter, John, of Dunmowe, Essex, pulter 3
4700116 2265457 2265457 defendant Connysby Thomas husbandman 609597 609597 Connysby, Thomas, of Dunmowe, Essex, husbandman 1
4904687 2328075 2328075 defendant Medelyng John gent 609597 609597 Medelyng, John, of Dunmowe, Essex, gent 0
5054831 2373011 2373011 defendant Freman Thomas yeoman 609597 609597 Freman, Thomas, of Dunmowe, Essex, yeoman 3
5058244 2374022 2374022 defendant Fuller John yeoman 609597 609597 Fuller, John, of Dunmowe, Essex, yeoman 6
5061427 2375007 2375007 defendant Pond John butcher 609597 609597 Pond, John, of Dunmowe, Essex, butcher 1
5061430 2375008 2375008 defendant Pond John butcher 609597 609597 Pond, John, of Dunmowe, Essex, butcher 1
5066517 2376514 2376514 defendant Pond John butcher 609597 609597 Pond, John, of Dunmowe, Essex, butcher 0
5066523 2376515 2376515 defendant Pond John butcher 609597 609597 Pond, John, of Dunmowe, Essex, butcher 0
5067698 2376834 2376834 defendant Joye Richard husbandman 609597 609597 Joye, Richard, of Dunmowe, Essex, husbandman 0
5077830 2379861 2379861 plaintiff Boteler John yeoman 609597 609597 Boteler, John, of Dunmowe, Essex, yeoman 0
5077923 2379878 2379878 defendant Freman Thomas yeoman 609597 609597 Freman, Thomas, of Dunmowe, Essex, yeoman 2
5127826 2394615 2394615 defendant Pykman Henry gent 609597 609597 Pykman, Henry, of Dunmowe, Essex, gent 1
5133295 2396226 2396226 defendant Joy Richard chapman 609597 609597 Joy, Richard, of Dunmowe, Essex,chapman 0
5149033 2400846 2400846 defendant Freman Thomas yeoman 609597 609597 Freman, Thomas, of Dunmowe, Essex, yeoman 0
5153109 2402051 2402051 defendant Joy Richard chapman 609597 609597 Joy, Richard, of Dunmowe, Essex, chapman 0
5183918 2411033 2411033 defendant Freman Thomas   609597 609597 Freman, Thomas, of Dunmowe, Essex 0
5188087 2412229 2412229 defendant (not given) William de prior of Hely 609597 609597 Hely, William de, of Dunmowe, Essex, prior of the priory 0
5205870 2417453 2417453 defendant (not given) William de prior of Hely 609597 609597 Hely, William de, of Dunmowe, Essex, prior of the priory 0
5455396 2491527 2491527 defendant Kyng John esq 609597 609597 Kyng, John, of Dunmowe, Essex, yeoman & servant of John Wrytyll, esq 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);