names

225 rows where place_id = 593073

✎ 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
3610325 1870886 1870886 defendant Ingby John yeoman 593073 593073 Ingby, John, of Burnham, yeoman 1
3614561 1872203 1872203 defendant Hill John butcher 593073 593073 Hill, John, of Burnham, butcher 0
3617410 1873064 1873064 defendant Laurens John husbandman 593073 593073 Laurens, John, of Burnham, husbandman 0
3620003 1873828 1873828 defendant Hill John butcher 593073 593073 Hill, John, of Burnham, butcher 0
3621782 1874350 1874350 defendant Hill John butcher 593073 593073 Hill, John, of Burnham, butcher 0
3627504 1903460 1903460 defendant Hill John butcher 593073 593073 Hill, John, of Burnham, butcher 0
3627505 1903460 1903460 defendant Hill Thomas butcher 593073 593073 Hill, Thomas, of Burnham, butcher 1
3635182 1905799 1905799 defendant Jenyson Thomas yeoman 593073 593073 Jenyson, Thomas, of Burnham, yeoman 3
3645708 1909061 1909061 defendant Hill Thomas butcher 593073 593073 Hill, Thomas, of Burnham, butcher 0
3650674 1910576 1910576 defendant Hoker John husbandman 593073 593073 Hoker, John, of Burnham, husbandman 0
3652851 1911215 1911215 defendant More Richard husbandman 593073 593073 More, Richard, of Burnham, husbandman 1
3701355 1926667 1926667 defendant Wyxston Richard   593073 593073 Wyxston, Richard, of Burnham, tile maker 1
3704556 1927719 1927719 defendant Churchehouse Robert husbandman 593073 593073 Churchehouse, Robert, of Burnham, husbandman 4
3719732 1932438 1932438 defendant Grene Richard husbandman 593073 593073 Grene, Richard, of Burnham, husbandman 0
3719915 1932499 1932499 defendant Shethe Thomas yeoman 593073 593073 Shethe, Thomas, of Burnham, yeoman 0
3777468 1950704 1950704 defendant Medley John husbandman 593073 593073 Medley, John, of Burnham, husbandman 0
3780993 1951787 1951787 defendant Boston Richard mercer 593073 593073 Boston, Richard, of Burnham, mercer 0
3793689 1955891 1955891 defendant Boston Richard mercer 593073 593073 Boston, Richard, of Burnham, mercer 0
3794956 1956287 1956287 defendant Bonor John, junior yeoman 593073 593073 Bonor, John, junior, of Burnham, yeoman 0
3798969 1957590 1957590 defendant Fynne William   593073 593073 Fynne, William, of Burnham, shepherd 0
3816895 1963189 1963189 defendant Coyden Thomas merchant 593073 593073 Coyden, Thomas, of Burnham, merchant 0
3829930 1967254 1967254 defendant Bek William (legal representative) 593073 593073 Bek, William, of Burnham, executor of 0
3829931 1967254 1967254 defendant Bek Richard husbandman 593073 593073 Bek, Richard, of Burnham, husbandman 1
3853224 1974626 1974626 plaintiff Sheth Thomas (legal representative) 593073 593073 Sheth, Thomas, of Burnham, executors of 0
3856583 1975685 1975685 defendant Capull Thomas laborer 593073 593073 Capull, Thomas, of Burnham, laborer 0
3864809 1978426 1978426 defendant Wodford Thomas gent 593073 593073 Wodford, Thomas, of Burnham, gent 0
3867736 1979441 1979441 plaintiff Shethe Thomas (legal representative) 593073 593073 Shethe, Thomas, of Burnham, executor of 0
3875140 1981921 1981921 defendant Woodford Thomas gent 593073 593073 Woodford, Thomas, of Burnham, gent 0
3875142 1981922 1981922 defendant Woodford Thomas gent 593073 593073 Woodford, Thomas, of Burnham, gent 0
3879070 1983251 1983251 defendant Clerk William mercer 593073 593073 Clerk, William, of Burnham, mercer 0
3894153 1988260 1988260 defendant Smyth Gilbert (legal representative) 593073 593073 Smyth, Gilbert, of Burnham, husbandman, administratrix of 3
3899275 1989969 1989969 defendant Peryn John husbandman 593073 593073 Peryn, John, of Burnham, husbandman 0
3900378 1990361 1990361 defendant Baker Thomas husbandman 593073 593073 Baker, Thomas, of Burnham, husbandman 0
3900379 1990361 1990361 defendant Peryman Roger laborer 593073 593073 Peryman, Roger, of Burnham, laborer 1
3900380 1990361 1990361 defendant Empton William laborer 593073 593073 Empton, William, of Burnham, laborer 2
3940304 2003777 2003777 defendant Scherys John gent 593073 593073 Scherys, John, of Burnham, gent 1
3969075 2013799 2013799 defendant Tonnet Robert clerk 593073 593073 Tonnet, Robert, of Burnham, clerk 3
3972376 2014911 2014911 defendant Foster Robert husbandman 593073 593073 Foster, Robert, of Burnham, husbandman 1
3972377 2014911 2014911 defendant Ive Thomas yeoman 593073 593073 Ive, Thomas, of Burnham, yeoman 2
3990993 2021541 2021541 defendant Farrowe Roger laborer 593073 593073 Farrowe, Roger, of Burnham, laborer 0
4013664 2029624 2029624 plaintiff Russell Edward gent 593073 593073 Russell, Edward, of Burnham, gent 0
4013666 2029625 2029625 plaintiff Russell Edward gent 593073 593073 Russell, Edward, of Burnham, gent 0
4013668 2029626 2029626 plaintiff Russell Edward gent 593073 593073 Russell, Edward, of Burnham, gent 0
4015435 2030216 2030216 defendant Beales Henry yeoman 593073 593073 Beales, Henry, of Burnham, yeoman 0
4028113 2034707 2034707 plaintiff Colman Walter merchant 593073 593073 Colman, Walter, of Burnham, merchant 0
4033744 2036720 2036720 plaintiff Gunthorp Henry yeoman 593073 593073 Gunthorp, Henry, of Burnham, yeoman 0
4033746 2036721 2036721 plaintiff Gunthorpe Henry yeoman 593073 593073 Gunthorpe, Henry, of Burnham, yeoman 0
4054932 2044157 2044157 defendant Crase William tailor 593073 593073 Crase, William, of Burnham, tailor 0
4074248 2051088 2051088 defendant Wentworth Paul esq 593073 593073 Wentworth, Paul, of Burnham, esq 0
4124158 2068930 2068930 defendant Ive Joan widow 593073 593073 Ive, Joan, of Burnham, widow 0
4190119 2092049 2092049 defendant Moore Thomas yeoman 593073 593073 Moore, Thomas, of Burnham, yeoman 0
4205556 2097496 2097496 defendant Boston Richard gent 593073 593073 Boston, Richard, of Burnham, gent 1
4208270 2098442 2098442 defendant Phillipson William   593073 593073 Phillipson, William, of Burnham Ulpe, sailor 1
4213808 2100347 2100347 defendant Brytyffe or Brytus Roger yeoman 593073 593073 Brytyffe or Brytus, Roger, of Burnham, yeoman 1
4217233 2101524 2101524 defendant Gade Edward husbandman 593073 593073 Gade, Edward, of Burnham, husbandman 0
4217234 2101524 2101524 defendant Pepis Richard husbandman 593073 593073 Pepis, Richard, of Burnham, husbandman 1
4222143 2103235 2103235 defendant Fowle Robert yeoman 593073 593073 Fowle, Robert, of Burnham,, yeoman 3
4224091 2103913 2103913 defendant Torr George husbandman 593073 593073 Torr, George, of Burnham, husbandman 1
4226996 2104915 2104915 defendant Mason Peter yeoman 593073 593073 Mason, Peter, of Burnham, yeoman 0
4235398 2107949 2107949 defendant Mason Peter yeoman 593073 593073 Mason, Peter, of Burnham, yeoman 0
4235399 2107949 2107949 defendant Mason Nicholas (legal representative) 593073 593073 Mason, Nicholas, of Burnham, yeoman, executor of 1
4235400 2107949 2107949 defendant Mason Zachary yeoman 593073 593073 Mason, Zachary, of Burnham, yeoman 2
4242548 2110505 2110505 defendant Claye Henry yeoman 593073 593073 Claye, Henry, of Burnham, yeoman 1
4242553 2110506 2110506 defendant Cleye Henry yeoman 593073 593073 Cleye, Henry, of Burnham, yeoman 2
4247495 2112148 2112148 defendant Meyers George gent 593073 593073 Meyers, George, of Burnham, gent 0
4247497 2112149 2112149 defendant Meyrs or Meyers George gent 593073 593073 Meyrs or Meyers, George, of Burnham, gent 0
4251189 2113375 2113375 defendant Smythe James yeoman 593073 593073 Smythe, James, of Burnham, yeoman 1
4261195 2116712 2116712 defendant Grymes John gent 593073 593073 Grymes, John, of Burnham, gent 3
4278078 2122267 2122267 defendant Saffold Richard   593073 593073 Saffold, Richard, of Burnham, yeoman, sailor 0
4278079 2122267 2122267 defendant Leez John, senior   593073 593073 Leez, John, senior, of Burnham, yeoman, sailor 1
4278080 2122267 2122267 defendant Philpott Thomas   593073 593073 Philpott, Thomas, of Burnham, yeoman, salt boiler 2
4278082 2122268 2122268 defendant Saffold Richard yeoman 593073 593073 Saffold, Richard, of Burnham, yeoman 0
4278083 2122268 2122268 defendant Leer or Leez John, senior yeoman 593073 593073 Leer or Leez, John, senior, of Burnham, yeoman 1
4278084 2122268 2122268 defendant Filpott Thomas   593073 593073 Filpott, Thomas, of Burnham, yeoman, salt boiler 2
4287130 2125454 2125454 defendant Shipman Richard yeoman 593073 593073 Shipman, Richard, of Burnham, yeoman 0
4291434 2127012 2127012 defendant Waterlande Robert yeoman 593073 593073 Waterlande, Robert, of Burnham, yeoman 0
4301896 2130786 2130786 defendant Dood John husbandman 593073 593073 Dood, John, of Burnham, husbandman 0
4302950 2131154 2131154 defendant Edes Hugh weaver 593073 593073 Edes, Hugh, of Burnham, weaver 0
4310866 2133948 2133948 defendant Hurwood Nicholas husbandman 593073 593073 Hurwood, Nicholas, of Burnham, husbandman 1
4321801 2137713 2137713 defendant Waterlande Robert yeoman 593073 593073 Waterlande, Robert, of Burnham, yeoman 0
4332303 2141096 2141096 defendant Jenyson Thomas gent 593073 593073 Jenyson, Thomas, of Burnham, gent 0
4359324 2150495 2150495 defendant Goulde Robert tailor 593073 593073 Goulde, Robert, of Burnham, tailor 0
4388290 2160714 2160714 defendant Comer Richard yeoman 593073 593073 Comer, Richard, of Burnham, yeoman 0
4398306 2164014 2164014 defendant Boston Giles yeoman 593073 593073 Boston, Giles, of Burnham, yeoman 1
4399770 2164511 2164511 defendant Tyll John mariner 593073 593073 Tyll, John, of Burnham, mariner 0
4399771 2164511 2164511 defendant Haydon John yeoman 593073 593073 Haydon, John, of Burnham, yeoman 1
4401565 2165120 2165120 defendant Tanner Thomas husbandman 593073 593073 Tanner, Thomas, of Burnham, husbandman 0
4408963 2167599 2167599 defendant Bissiter John rippier or pedder 593073 593073 Bissiter, John, of Burnham, rippier or pedder 1
4438082 2181209 2181209 defendant Person John   593073 593073 Person, John, of Burnham 0
4438218 2181252 2181252 defendant Person John   593073 593073 Person, John, of Burnham 0
4445956 2183678 2183678 defendant Gelham William   593073 593073 Gelham, William, of Burnham 3
4459539 2188037 2188037 defendant Gildon John   593073 593073 Gildon, John, of Burnham 1
4459573 2188047 2188047 defendant Gyldon John   593073 593073 Gyldon, John, of burnham 1
4481253 2194820 2194820 defendant Palfreyman John   593073 593073 Palfreyman, John, of Burnham 0
4488858 2197231 2197231 defendant West William   593073 593073 West, William, of burnham 5
4493019 2198515 2198515 defendant Pryll Richard   593073 593073 Pryll, Richard, of Burnham 0
4493156 2198563 2198563 defendant Coke William   593073 593073 Coke, William, of Burnham 0
4496396 2199550 2199550 plaintiff Copyn John   593073 593073 Copyn, John, of Burnham 0
4509526 2203449 2203449 defendant Coke William   593073 593073 Coke, William, of Burnham 0
4522471 2207368 2207368 plaintiff Grenehode Nicholas   593073 593073 Grenehode, Nicholas, of Burnham 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);