names

66 rows where place_id = 610397

✎ 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
3683346 1920915 1920915 defendant Deyndryng Richard clerk 610397 610397 Deyndryng, Richard, of Myldenhall, clerk 0
3702731 1927127 1927127 defendant Brownyng Robert husbandman 610397 610397 Brownyng, Robert, of Myldenhall, husbandman 0
3709681 1929339 1929339 defendant Deny Robert yeoman 610397 610397 Deny, Robert, of Myldenhall, yeoman 0
3723859 1933742 1933742 plaintiff Pope Henry gent 610397 610397 Pope, Henry, of Myldenhall, gent 0
3786479 1953562 1953562 defendant Morley Henry husbandman 610397 610397 Morley, Henry, of Myldenhall, husbandman 2
3850668 1973797 1973797 defendant Lark Thomas yeoman 610397 610397 Lark, Thomas, of Myldenhall, yeoman 0
3868940 1979854 1979854 defendant Rede Richard laborer 610397 610397 Rede, Richard, of Myldenhall, laborer 0
3868941 1979854 1979854 defendant Weste Robert husbandman 610397 610397 Weste, Robert, of Myldenhall, husbandman 1
3880399 1983700 1983700 defendant Dobson Thomas dyer 610397 610397 Dobson, Thomas, of Myldenhall, dyer 1
3880401 1983700 1983700 defendant Aldred Robert tailor 610397 610397 Aldred, Robert, of Myldenhall, tailor 3
3906350 1992409 1992409 defendant Blome Robert husbandman 610397 610397 Blome, Robert, of Myldenhall, husbandman 0
3906352 1992409 1992409 defendant Lumkyn Thomas husbandman 610397 610397 Lumkyn, Thomas, of Myldenhall, husbandman 2
3909935 1993629 1993629 defendant Fuller Robert, senior husbandman 610397 610397 Fuller, Robert, senior, of Myldenhall, husbandman 0
3909937 1993629 1993629 defendant Ogyll Thomas, senior husbandman 610397 610397 Ogyll, Thomas, senior, of Myldenhall, husbandman 2
3909938 1993629 1993629 defendant Wynge Thomas, senior husbandman 610397 610397 Wynge, Thomas, senior, of Myldenhall, husbandman 3
3915947 1995713 1995713 plaintiff Duffyld Humphrey (legal representative) 610397 610397 Duffyld, Humphrey, of Myldenhall, executor of 0
3915948 1995713 1995713 plaintiff Duffeld Paul   610397 610397 Duffeld, Paul, of Myldenhall 1
3916710 1995958 1995958 defendant Mey Nicholas warrener 610397 610397 Mey, Nicholas, of Myldenhall, warrener 0
3916711 1995958 1995958 defendant Gage William tailor 610397 610397 Gage, William, of Myldenhall, tailor 1
3916712 1995958 1995958 defendant Costen Robert   610397 610397 Costen, Robert, of Myldenhall, lime burner 2
3919844 1996972 1996972 defendant Fuller John laborer 610397 610397 Fuller, John, of Myldenhall, laborer 1
3919845 1996972 1996972 defendant Rydd John laborer 610397 610397 Rydd, John, of Myldenhall, laborer 2
3943211 2004747 2004747 defendant Busshe Thomas merchant 610397 610397 Busshe, Thomas, of Myldenhall, merchant 0
3944504 2005177 2005177 defendant Wylleys Nicholas, junior tailor 610397 610397 Wylleys, Nicholas, junior, of Myldenhall, tailor 2
3950021 2007089 2007089 defendant Pykerell Thomas butcher 610397 610397 Pykerell, Thomas, of Myldenhall, butcher 1
3957493 2009686 2009686 defendant Pyckerell Thomas butcher 610397 610397 Pyckerell, Thomas, of Myldenhall, butcher 0
3971224 2014493 2014493 defendant Bassett George clerk 610397 610397 Bassett, George, of Myldenhall, clerk 0
3971741 2014678 2014678 defendant Wallet Robert butcher 610397 610397 Wallet, Robert, of Myldenhall, butcher 0
3976232 2016253 2016253 defendant Heynes alias Baker John, senior smith 610397 610397 Heynes alias Baker, John, senior, of Myldenhall, smith 0
3976866 2016480 2016480 defendant Busshe Thomas merchant 610397 610397 Busshe, Thomas, of Myldenhall, merchant 0
3977490 2016698 2016698 defendant Costen Robert yeoman 610397 610397 Costen, Robert, of Myldenhall, yeoman 1
3979545 2017442 2017442 defendant Bassett George clerk 610397 610397 Bassett, George, of Myldenhall, clerk 0
3979547 2017443 2017443 defendant Bassett George clerk 610397 610397 Bassett, George, of Myldenhall, clerk 0
3982694 2018580 2018580 defendant Love William barber 610397 610397 Love, William, of Myldenhall, barber 0
3982696 2018581 2018581 defendant Love William berber 610397 610397 Love, William, of Myldenhall, berber 0
3994911 2022931 2022931 defendant Suckerman William maltster 610397 610397 Suckerman, William, of Myldenhall, yeoman, maltster 0
4005920 2026890 2026890 plaintiff Lane Thomas yeoman 610397 610397 Lane, Thomas, of Myldenhall, yeoman 0
4005921 2026890 2026890 defendant Kynnerden John butcher 610397 610397 Kynnerden, John, of Myldenhall, or of Frecname, butcher 0
4010076 2028369 2028369 defendant Gathercold George husbandman 610397 610397 Gathercold, George, of Myldenhall, husbandman 1
4025769 2033870 2033870 defendant Lunes William smith 610397 610397 Lunes, William, of Myldenhall, smith 2
4036267 2037653 2037653 defendant Bassett George clerk 610397 610397 Bassett, George, of Myldenhall, clerk 0
4042042 2039642 2039642 defendant Bakett Thomas draper 610397 610397 Bakett, Thomas, of Myldenhall, draper 0
4042049 2039643 2039643 defendant Bakett Thomas draper 610397 610397 Bakett, Thomas, of Myldenhall, draper 0
4059810 2045902 2045902 defendant Tyrell William yeoman 610397 610397 Tyrell, William, of Myldenhall, yeoman 0
4063528 2047243 2047243 defendant Jervys William husbandman or gent 610397 610397 Jervys, William, of Myldenhall, husbandman or gent 0
4076191 2051772 2051772 defendant Geson Anthony husbandman 610397 610397 Geson, Anthony, of Myldenhall, husbandman 2
4076192 2051772 2051772 defendant Feltwell Richard husbandman 610397 610397 Feltwell, Richard, of Myldenhall, husbandman 3
4092534 2057639 2057639 defendant Cole John   610397 610397 Cole, John, of Myldenhall, draper, administrators of 0
4131952 2071741 2071741 defendant Gybbes William husbandman 610397 610397 Gybbes, William, of Myldenhall, husbandman 0
4168144 2084346 2084346 defendant Suckerman Simon, junior gent 610397 610397 Suckerman, Simon, junior, of Myldenhall, gent 0
4168169 2084352 2084352 defendant Mosse Robert yeoman 610397 610397 Mosse, Robert, of Myldenhall, yeoman 1
4168181 2084356 2084356 defendant Veisey Henry gent 610397 610397 Veisey, Henry, of Myldenhall, gent 0
4179868 2088434 2088434 defendant Gybbes William husbandman 610397 610397 Gybbes, William, of Myldenhall, husbandman 0
4197870 2094805 2094805 defendant Harte Robert yeoman 610397 610397 Harte, Robert, of Myldenhall, yeoman 0
4206123 2097690 2097690 defendant Cotes Thomas yeoman 610397 610397 Cotes, Thomas, of Myldenhall, yeoman 0
4221701 2103080 2103080 defendant Thurston Robert yeoman 610397 610397 Thurston, Robert, of Myldenhall, yeoman 0
4243682 2110876 2110876 defendant Suckerman Simon gent 610397 610397 Suckerman, Simon, of Myldenhall, gent 1
4274612 2121063 2121063 defendant Suckerman Simon, junior gent 610397 610397 Suckerman, Simon, junior, of Myldenhall, gent 0
4283560 2124158 2124158 defendant Lawrence John tailor 610397 610397 Lawrence, John, of Myldenhall, tailor 0
4283561 2124158 2124158 defendant Seaman William glover 610397 610397 Seaman, William, of Myldenhall, glover 1
4325120 2138785 2138785 defendant Clarke Henry yeoman 610397 610397 Clarke, Henry, of Myldenhall, yeoman 2
4329548 2140184 2140184 defendant Geson Martin yeoman 610397 610397 Geson, Martin, of Myldenhall, yeoman 0
4333557 2141503 2141503 defendant Stevenson Alexander baker 610397 610397 Stevenson, Alexander, of Myldenhall, baker 0
4336222 2142400 2142400 defendant Cheston Thomas esq 610397 610397 Cheston, Thomas, of Myldenhall, esq 0
5385962 2471058 2471058 defendant Mayre Robert husbandman 610397 610397 Mayre, Robert, of Myldenhall, husbandman 1
5385967 2471059 2471059 defendant Mayre Robert husbandman 610397 610397 Mayre, Robert, of Myldenhall, 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);