names

117 rows where place_id = 586241

✎ 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
3588241 1863978 1863978 defendant Pye John yeoman 586241 586241 Pye, John, of Wrentham, yeoman 0
3588243 1863979 1863979 plaintiff Baxster Alexander   586241 586241 Baxster, Alexander, of Wrentham 0
3599011 1867324 1867324 defendant Edmondson John, junior   586241 586241 Edmondson, John, junior, of Wrentham, wheelwright 2
3599017 1867325 1867325 defendant Edmundson John, junior   586241 586241 Edmundson, John, junior, of Wrentham, wheelwright 2
3622704 1874629 1874629 defendant Lee John yeoman 586241 586241 Lee, John, of Wrentham, yeoman 3
3635843 1906009 1906009 defendant Multon John yeoman 586241 586241 Multon, John, of Wrentham, yeoman 4
3636903 1906333 1906333 defendant Rykwade Walter laborer 586241 586241 Rykwade, Walter, of Wrentham, laborer 3
3645480 1908989 1908989 defendant Rykeward Walter husbandman 586241 586241 Rykeward, Walter, of Wrentham, husbandman 2
3656422 1912253 1912253 defendant Manbey Thomas yeoman 586241 586241 Manbey, Thomas, of Wrentham, yeoman 0
3656424 1912253 1912253 defendant Edmondys John yeoman 586241 586241 Edmondys, John, of Wrentham, yeoman 2
3664136 1914733 1914733 defendant Burman John yeoman 586241 586241 Burman, John, of Wrentham, yeoman 0
3664341 1914795 1914795 defendant Dysar William butcher 586241 586241 Dysar, William, of Wrentham, butcher 1
3664531 1914859 1914859 defendant Barfote John, senior husbandman 586241 586241 Barfote, John, senior, of Wrentham, husbandman 0
3671145 1916945 1916945 defendant Botwryght Robert husbandman 586241 586241 Botwryght, Robert, of Wrentham, husbandman 0
3681571 1920325 1920325 defendant Manby Thomas husbandman 586241 586241 Manby, Thomas, of Wrentham, husbandman 0
3695769 1924907 1924907 defendant Edmondys John, senior husbandman 586241 586241 Edmondys, John, senior, of Wrentham, husbandman 0
3731458 1936065 1936065 defendant Barbour Margaret widow 586241 586241 (Barbour, Margaret, of Wrentham, widow 3
3731459 1936065 1936065 defendant Mosse John husbandman 586241 586241 Mosse, John, of Wrentham, husbandman 4
3753684 1943092 1943092 defendant Hause John husbandman 586241 586241 Hause, John, of Wrentham, husbandman 2
3758993 1944801 1944801 defendant Thewys John husbandman 586241 586241 Thewys, John, of Wrentham, husbandman 0
3769331 1948065 1948065 defendant Barfold John carpenter 586241 586241 Barfold, John, of Wrentham, carpenter 1
3770851 1948571 1948571 defendant Hawse John husbandman 586241 586241 Hawse, John, of Wrentham, husbandman 2
3794401 1956125 1956125 defendant Graunte John husbandman 586241 586241 (Graunte, John, of Wrentham, husbandman 5
3811238 1961409 1961409 defendant Calffe William husbandman 586241 586241 Calffe, William, of Wrentham, husbandman 1
3819267 1963916 1963916 defendant Franky William   586241 586241 Franky, William,of Wrentham, parish clerk 0
3832835 1968194 1968194 defendant Sprunt John husbandman 586241 586241 Sprunt, John, of Wrentham, husbandman 2
3845698 1972201 1972201 defendant Smyth Henry yeoman 586241 586241 Smyth, Henry, of Wrentham, yeoman 1
3867448 1979347 1979347 defendant Smyth Henry yeoman 586241 586241 Smyth, Henry, of Wrentham, yeoman 1
3868311 1979643 1979643 defendant Calfe William husbandman 586241 586241 Calfe, William, of Wrentham, husbandman 1
3868312 1979643 1979643 defendant Truste alias Trus William husbandman 586241 586241 Truste alias Trus, William, of Wrentham, husbandman 2
3871603 1980742 1980742 defendant Chowt Anthony gent 586241 586241 Chowt, Anthony, of Wrentham, gent 2
3881891 1984197 1984197 defendant Sprunt William yeoman 586241 586241 Sprunt, William, of Wrentham, yeoman 1
3890174 1986952 1986952 defendant Bolyaunt Edward husbandman 586241 586241 Bolyaunt, Edward, of Wrentham, husbandman 2
3893329 1988002 1988002 defendant Browne Christopher husbandman 586241 586241 Browne, Christopher, of Wrentham, husbandman 0
3895277 1988628 1988628 defendant Franklyn Edward yeoman 586241 586241 Franklyn, Edward, of Wrentham, yeoman 2
3904324 1991694 1991694 defendant Bollyaunt Edward husbandman 586241 586241 Bollyaunt, Edward, of Wrentham, husbandman 0
3907662 1992852 1992852 defendant Bolyaunt Edward husbandman 586241 586241 Bolyaunt, Edward, of Wrentham, husbandman 0
3915551 1995569 1995569 defendant Franklyn Edmund husbandman 586241 586241 Franklyn, Edmund, of Wrentham, husbandman 0
3921362 1997488 1997488 defendant Bolyaunt Edward yeoman 586241 586241 Bolyaunt, Edward, of Wrentham, yeoman 0
3921363 1997488 1997488 defendant Tebold Thomas yeoman 586241 586241 Tebold, Thomas, of Wrentham, yeoman 1
3921364 1997488 1997488 defendant Broune Christopher husbandman 586241 586241 Broune, Christopher, of Wrentham, husbandman 2
3921365 1997488 1997488 defendant Humfrey Thomas clerk 586241 586241 Humfrey, Thomas, of Wrentham, clerk 3
3924407 1998475 1998475 defendant Harman George husbandman 586241 586241 Harman, George, of Wrentham, husbandman 0
3932758 2001258 2001258 defendant Spachett John yeoman 586241 586241 Spachett, John, of Wrentham, yeoman 0
3939983 2003671 2003671 defendant Browne Christopher husbandman 586241 586241 Browne, Christopher, of Wrentham, husbandman 0
3945905 2005645 2005645 defendant Smyth Henry yeoman 586241 586241 Smyth, Henry, of Wrentham, yeoman 0
3946169 2005738 2005738 plaintiff Bullyaunt Edward   586241 586241 Bullyaunt, Edward, of Wrentham 0
3959146 2010284 2010284 defendant Bolyant Edward husbandman 586241 586241 Bolyant, Edward, of Wrentham, husbandman 4
3965743 2012636 2012636 defendant Fayrechyld William husbandman 586241 586241 Fayrechyld, William, of Wrentham, husbandman 0
3966567 2012940 2012940 defendant Toumbes Thomas husbandman 586241 586241 Toumbes, Thomas, of Wrentham, husbandman 1
3967295 2013194 2013194 defendant Milles William tailor 586241 586241 Milles, William, of Wrentham, tailor 0
3967404 2013230 2013230 defendant Harman Henry weaver 586241 586241 Harman, Henry, of Wrentham, weaver 0
3967405 2013230 2013230 defendant Elmye John husbandman 586241 586241 Elmye, John, of Wrentham, husbandman 1
3967826 2013379 2013379 defendant Collyn alias Hachett Richard husbandman 586241 586241 Collyn alias Hachett, Richard, of Wrentham, husbandman 0
3967827 2013379 2013379 defendant Hedgeman William husbandman 586241 586241 Hedgeman, William, of Wrentham, husbandman 1
3967828 2013379 2013379 defendant Milles William husbandman 586241 586241 Milles, William, of Wrentham, husbandman 2
3984575 2019241 2019241 plaintiff Tebolde Thomas yeoman 586241 586241 Tebolde, Thomas, of Wrentham, yeoman 0
3992959 2022239 2022239 defendant Molling George husbandman 586241 586241 Molling, George, of Wrentham, husbandman 0
4063576 2047262 2047262 defendant Clarke Philip husbandman 586241 586241 Clarke, Philip, of Wrentham, husbandman 0
4063579 2047263 2047263 defendant Clarke Philip husbandman 586241 586241 Clarke, Philip, of Wrentham, husbandman 0
4072955 2050624 2050624 defendant Tayler Ralph husbandman 586241 586241 Tayler, Ralph, of Wrentham, husbandman 0
4079689 2053035 2053035 defendant Clarke Philip husbandman 586241 586241 Clarke, Philip, of Wrentham, husbandman 0
4079690 2053035 2053035 defendant Clarke William   586241 586241 Clarke, William, of Wrentham, husbandman, his father 1
4129259 2070763 2070763 defendant Gardyner Robert gent 586241 586241 Gardyner, Robert, of Wrentham, gent 2
4132052 2071776 2071776 defendant Gardener Timothy   586241 586241 Gardener, Timothy, of Wrentham, gent, his son 1
4132056 2071777 2071777 defendant Gardener Timothy   586241 586241 Gardener, Timothy, of Wrentham, gent, his son 1
4138862 2074272 2074272 defendant Goslyn John (legal representative) 586241 586241 Goslyn, John, of Wrentham, weaver, executor of 0
4138863 2074272 2074272 defendant Butt Robert yeoman 586241 586241 Butt, Robert, of Wrentham, yeoman 1
4138864 2074272 2074272 defendant Fayrecholde William husbandman 586241 586241 Fayrecholde, William, of Wrentham, husbandman 2
4138865 2074272 2074272 defendant Cannon alias Irysshe Thomas husbandman 586241 586241 Cannon alias Irysshe, Thomas, of Wrentham, husbandman 3
4186032 2090603 2090603 defendant Gardyner Robert gent 586241 586241 Gardyner, Robert, of Wrentham, gent 0
4192911 2093085 2093085 defendant Wylde Thomas cordwainer 586241 586241 Wylde, Thomas, of Wrentham, cordwainer 1
4201011 2095911 2095911 defendant Mosse Thomas yeoman 586241 586241 Mosse, Thomas, of Wrentham, yeoman 0
4205559 2097497 2097497 defendant Butt Thomas yeoman 586241 586241 Butt, Thomas, of Wrentham, yeoman 0
4242712 2110552 2110552 defendant Fayerchild William husbandman 586241 586241 Fayerchild, William, of Wrentham, husbandman 0
4242713 2110552 2110552 defendant Farrar Christopher husbandman 586241 586241 Farrar, Christopher, of Wrentham, husbandman 1
4254502 2114495 2114495 defendant Londe Edmund tailor 586241 586241 Londe, Edmund, of Wrentham, tailor 1
4275246 2121280 2121280 defendant Cowlinge alias Hatchett Robert husbandman 586241 586241 Cowlinge alias Hatchett, Robert, of Wrentham, husbandman 0
4275251 2121281 2121281 defendant Ellys William husbandman 586241 586241 Ellys, William, of Wrentham, husbandman 0
4325177 2138800 2138800 defendant Bennett William tanner 586241 586241 Bennett, William, of Wrentham, tanner 2
4344375 2145313 2145313 defendant Smyth Simon yeoman 586241 586241 Smyth, Simon, of Wrentham, yeoman 0
4367536 2153444 2153444 defendant Harvy William (legal representative) 586241 586241 Harvy, William, of Wrentham, yeoman, executrix of 0
4367540 2153445 2153445 defendant Haylocke John husbandman 586241 586241 Haylocke, John, of Wrentham, husbandman 0
4397552 2163760 2163760 defendant Savile Robert gent 586241 586241 Savile, Robert, of Wrentham, gent 0
4400019 2164595 2164595 defendant Tebbold Thomas yeoman 586241 586241 Tebbold, Thomas, of Wrentham, yeoman 2
4606209 2233049 2233049 defendant Wytton Robert   586241 586241 Wytton, Robert, of Wrentham 2
4673739 2257410 2257410 defendant Bowet William   586241 586241 Bowet, William, of Wrentham, knight 3
4739236 2277363 2277363 plaintiff Wynfeld John   586241 586241 Wynfeld, John, of Wrentham, parson 5
4794210 2294326 2294326 plaintiff Pye John   586241 586241 Pye, John, of Wrentham 5
4801480 2296644 2296644 defendant Grene Henry miller 586241 586241 Grene, Henry, of Wrentham, miller 0
4842938 2309334 2309334 defendant Burgham John   586241 586241 Burgham, John, of Wrentham, parson 0
4849781 2311402 2311402 defendant Chowenys John miller 586241 586241 Chowenys, John, of Wrentham, miller 0
4856968 2313559 2313559 defendant Heyward John tailor 586241 586241 Heyward, John, of Wrentham, tailor 0
4864321 2315818 2315818 defendant West John husbandman 586241 586241 West, John, of Wrentham, husbandman 0
4874244 2318889 2318889 defendant Austyn William   586241 586241 Austyn, William, of Wrentham, franklin 0
4884109 2321939 2321939 defendant Cley Agnes widow 586241 586241 Cley, Agnes, of Wrentham, widow 5
4886682 2322698 2322698 defendant Foulere William husbandman 586241 586241 Foulere, William, of Wrentham, husbandman 2
4886687 2322699 2322699 defendant Austyn William yeoman 586241 586241 Austyn, William, of Wrentham, yeoman 1
4893681 2324719 2324719 defendant Heyward John husbandman 586241 586241 Heyward, John, of Wrentham, husbandman 0
4979922 2350952 2350952 defendant Austyn William gent 586241 586241 Austyn, William, of Wrentham, gent 0

Next page

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