names

231 rows where place_id = 587227

✎ 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
3590827 1864769 1864769 defendant Emneth Nicholas husbandman 587227 587227 Emneth, Nicholas, of Upwell, husbandman 0
3590828 1864769 1864769 defendant Davy Thomas husbandman 587227 587227 Davy, Thomas, of Upwell, husbandman 1
3590829 1864769 1864769 defendant Kendall Thomas husbandman 587227 587227 Kendall, Thomas, of Upwell, husbandman 2
3590830 1864769 1864769 defendant Burdon Robert husbandman 587227 587227 Burdon, Robert, of Upwell, husbandman 3
3598400 1867129 1867129 defendant Wryght alias Goldewell William brewer or yeoman 587227 587227 Wryght alias Goldewell, William, of Upwell, brewer or yeoman 1
3608668 1870371 1870371 defendant Upgate John tailor 587227 587227 Upgate, John, of Upwell, tailor 1
3615727 1872560 1872560 defendant Ducedale Richard husbandman 587227 587227 Ducedale, Richard, of Upwell, husbandman 0
3615728 1872560 1872560 defendant Wryght William husbandman 587227 587227 Wryght, William, of Upwell, husbandman 1
3619667 1873721 1873721 defendant Anwycke Walter plumber 587227 587227 Anwycke, Walter, of Upwell, plumber 0
3619668 1873721 1873721 defendant Bately John husbandman 587227 587227 Bately, John, of Upwell, husbandman 1
3619669 1873721 1873721 defendant Clarke Peter tailor 587227 587227 Clarke, Peter, of Upwell, tailor 2
3622348 1874525 1874525 defendant Bosse John husbandman 587227 587227 Bosse, John, of Upwell, husbandman 2
3624668 1875251 1875251 defendant Burdon Robert husbandman 587227 587227 Burdon, Robert, of Upwell, husbandman 2
3626287 1903078 1903078 defendant Davy Richard butcher 587227 587227 Davy, Richard, of Upwell, butcher 0
3626881 1903260 1903260 defendant Walker John laborer 587227 587227 Walker, John, of Upwell, laborer 0
3626882 1903260 1903260 defendant Wodcoke Thomas husbandman 587227 587227 Wodcoke, Thomas, of Upwell, husbandman 1
3626883 1903260 1903260 defendant Hansby or Hausby William husbandman 587227 587227 Hansby or Hausby, William, of Upwell, husbandman 2
3634411 1905561 1905561 defendant Broune Henry husbandman 587227 587227 Broune, Henry, of Upwell, husbandman 0
3647129 1909494 1909494 defendant Woodcok Thomas husbandman 587227 587227 Woodcok, Thomas, of Upwell, husbandman 1
3657568 1912628 1912628 defendant Mane Christopher laborer 587227 587227 Mane, Christopher, of Upwell, laborer 3
3657570 1912628 1912628 defendant Barret Thomas laborer 587227 587227 Barret, Thomas, of Upwell, laborer 5
3657571 1912628 1912628 defendant Stanfeld Richard laborer 587227 587227 Stanfeld, Richard, of Upwell, laborer 6
3657574 1912629 1912629 defendant Walsyngham Andrew husbandman 587227 587227 Walsyngham, Andrew, of Upwell, husbandman 0
3659749 1913302 1913302 defendant Borough Thomas husbandman 587227 587227 Borough, Thomas, of Upwell, husbandman 1
3661349 1913823 1913823 defendant Middelton William brewer 587227 587227 Middelton, William, of Upwell, brewer 0
3666191 1915373 1915373 defendant Taylour Simon laborer 587227 587227 Taylour, Simon, of Upwell, laborer 0
3666192 1915373 1915373 defendant woll William laborer 587227 587227 woll, William, of Upwell, laborer 1
3676617 1918724 1918724 defendant Boteler Thomas laborer 587227 587227 Boteler, Thomas, of Upwell, laborer 0
3676618 1918724 1918724 defendant Man Christopher laborer 587227 587227 Man, Christopher, of Upwell, laborer 1
3676619 1918724 1918724 defendant Wolle William laborer 587227 587227 Wolle, William, of Upwell, laborer 2
3683358 1920919 1920919 defendant Gladwyn John laborer 587227 587227 Gladwyn, John, of Upwell, laborer 1
3688480 1922552 1922552 defendant Jelowe William husbandman 587227 587227 Jelowe, William, of Upwell, husbandman 0
3703308 1927308 1927308 defendant Walton Richard barber 587227 587227 Walton, Richard, of Upwell, barber 0
3762133 1945798 1945798 defendant Power William laborer 587227 587227 Power, William, of Upwell, laborer 0
3784738 1953017 1953017 defendant Rutter John husbandman 587227 587227 Rutter, John, of Upwell, husbandman 0
3799097 1957627 1957627 defendant Aborough Thomas husbandman 587227 587227 Aborough, Thomas, of Upwell, husbandman 2
3801714 1958431 1958431 defendant Wulle William husbandman 587227 587227 Wulle, William, of Upwell, husbandman 0
3806400 1959914 1959914 defendant Wolle William husbandman 587227 587227 Wolle, William, of Upwell, husbandman 0
3807108 1960114 1960114 defendant Bateman William mercer 587227 587227 Bateman, William, of Upwell, mercer 0
3822756 1965018 1965018 defendant Bateman Richard chapman 587227 587227 Bateman, Richard, of Upwell, chapman 0
3826309 1966077 1966077 defendant Chadwell William husbandman 587227 587227 Chadwell, William, of Upwell, husbandman 0
3830741 1967498 1967498 defendant Goldwell alias Wryght William husbandman 587227 587227 Goldwell alias Wryght, William, of Upwell, husbandman 0
3830742 1967498 1967498 defendant Reynam Richard husbandman 587227 587227 Reynam, Richard, of Upwell, husbandman 1
3833182 1968309 1968309 defendant Middelton William brewer 587227 587227 Middelton, William, of Upwell, brewer 0
3836062 1969191 1969191 defendant Bateman William mercer 587227 587227 Bateman, William, of Upwell, mercer 0
3837444 1969618 1969618 defendant Anderson alias Gilbert Richard mercer 587227 587227 Anderson alias Gilbert, Richard, of Upwell, mercer 1
3837447 1969619 1969619 defendant Anderson alias Gilbert Richard mercer 587227 587227 Anderson alias Gilbert, Richard, of Upwell, mercer 1
3849026 1973290 1973290 defendant Middelton William brewer 587227 587227 Middelton, William, of Upwell, brewer 0
3849249 1973358 1973358 defendant Bateman William mercer 587227 587227 Bateman, William, of Upwell, mercer 0
3850598 1973774 1973774 defendant Mydelton William brewer 587227 587227 Mydelton, William, of Upwell, brewer 0
3869464 1980028 1980028 defendant Garnet Robert husbandman 587227 587227 Garnet, Robert, of Upwell, husbandman 0
3869466 1980028 1980028 defendant Makerell Martin husbandman 587227 587227 Makerell, Martin, of Upwell, husbandman 2
3917144 1996095 1996095 defendant Woll Henry husbandman 587227 587227 Woll, Henry, of Upwell, husbandman 1
3917146 1996096 1996096 defendant Batewell William mercer 587227 587227 Batewell, William, of Upwell, mercer 0
3917147 1996096 1996096 defendant Wall Henry husbandman 587227 587227 Wall, Henry, of Upwell, husbandman 1
3917160 1996101 1996101 defendant Bateman William mercer 587227 587227 Bateman, William, of Upwell, mercer 0
3917161 1996101 1996101 defendant Wull Henry husbandman 587227 587227 Wull, Henry, of Upwell, husbandman 1
3917167 1996103 1996103 defendant Cowper Richard husbandman 587227 587227 Cowper, Richard, of Upwell, husbandman 0
3928049 1999716 1999716 defendant Strete Henry beer brewer 587227 587227 Strete, Henry, of Upwell, beer brewer 0
3928050 1999716 1999716 defendant Bosse William laborer 587227 587227 Bosse, William, of Upwell, laborer 1
3928051 1999716 1999716 defendant Taylour Thomas laborer 587227 587227 Taylour, Thomas, of Upwell, laborer 2
3930694 2000616 2000616 defendant Browne Adam fisher 587227 587227 Browne, Adam, of Upwell, fisher 0
3930902 2000674 2000674 defendant Badcok John clerk 587227 587227 Badcok, John, of Upwell, clerk 0
3933087 2001359 2001359 defendant Ferrer Henry husbandman 587227 587227 Ferrer, Henry, of Upwell, husbandman 0
3933249 2001414 2001414 defendant Wyett Robert husbandman 587227 587227 Wyett, Robert, of Upwell, husbandman 1
3941759 2004257 2004257 defendant Fetche Martin husbandman 587227 587227 Fetche, Martin, of Upwell, husbandman 0
3972185 2014833 2014833 plaintiff Franke William (legal representative) 587227 587227 Franke, William, of Upwell, fisher, executor of 0
3972194 2014835 2014835 defendant Holland Robert yeoman 587227 587227 Holland, Robert, of Upwell, yeoman 3
3974211 2015546 2015546 defendant Barton Richard clerk 587227 587227 Barton, Richard, of Upwell, clerk 0
4029365 2035142 2035142 defendant Tydde Anthony husbandman 587227 587227 Tydde, Anthony, of Upwell, husbandman 2
4054285 2043922 2043922 defendant Man John husbandman 587227 587227 Man, John, of Upwell, husbandman 1
4054286 2043922 2043922 defendant Adamson John husbandman 587227 587227 Adamson, John, of Upwell, husbandman 2
4089657 2056594 2056594 defendant Thompson William butcher 587227 587227 Thompson, William, of Upwell, butcher 0
4120634 2067657 2067657 defendant Garnett William waterman 587227 587227 Garnett, William, of Upwell, waterman 0
4120635 2067657 2067657 defendant Jackson Thomas husbandman 587227 587227 Jackson, Thomas, of Upwell, husbandman 1
4127564 2070149 2070149 defendant Tompson William butcher 587227 587227 Tompson, William, of Upwell, butcher 0
4137785 2073874 2073874 defendant Dymond Brian upholsterer 587227 587227 Dymond, Brian, of Upwell, upholsterer 0
4137787 2073875 2073875 defendant Dymond Brian upholsterer 587227 587227 Dymond, Brian, of Upwell, upholsterer 0
4152653 2079041 2079041 defendant Dymond Brian upholsterer 587227 587227 Dymond, Brian, of Upwell, upholsterer 0
4152654 2079041 2079041 defendant Bateman William husbandman 587227 587227 Bateman, William, of Upwell, husbandman 1
4152655 2079041 2079041 defendant Hall John husbandman 587227 587227 Hall, John, of Upwell, husbandman 2
4196498 2094318 2094318 defendant Asheton Robert yeoman 587227 587227 Asheton, Robert, of Upwell, yeoman 0
4208249 2098435 2098435 defendant Dickman Thomas husbandman 587227 587227 Dickman, Thomas, of Upwell, husbandman 0
4274588 2121056 2121056 defendant Hasell Ellen widow 587227 587227 Hasell, Ellen, of Upwell, widow 0
4277141 2121938 2121938 defendant Lawe Richard yeoman 587227 587227 Lawe, Richard, of Upwell, yeoman 0
4277336 2121997 2121997 defendant Smyth Edmund yeoman 587227 587227 Smyth, Edmund, of Upwell, yeoman 0
4314018 2135012 2135012 defendant Smyth Edmund yeoman 587227 587227 Smyth, Edmund, of Upwell, yeoman 0
4330329 2140448 2140448 defendant Scott Richard husbandman 587227 587227 Scott, Richard, of Upwell, husbandman 0
4330330 2140448 2140448 defendant Browne Ralph tailor 587227 587227 Browne, Ralph, of Upwell, tailor 1
4330332 2140448 2140448 defendant Brades Edward husbandman 587227 587227 Brades, Edward, of Upwell, husbandman 3
4336968 2142656 2142656 defendant Bellamy Adam laborer 587227 587227 Bellamy, Adam, of Upwell, laborer 1
4402550 2165439 2165439 defendant Hurton John waterman 587227 587227 Hurton, John, of Upwell, waterman 0
4481714 2194982 2194982 defendant Dudde John   587227 587227 Dudde, John, of Upwell 1
4481715 2194982 2194982 defendant Carsey Robert   587227 587227 Carsey, Robert, of Upwell 2
4514934 2205080 2205080 plaintiff Catesson John   587227 587227 Catesson, John, of Upwell 0
4552710 2216799 2216799 defendant Bakere Simon   587227 587227 Bakere, Simon, of Upwell 1
4591111 2228577 2228577 defendant Palmere John   587227 587227 Palmere, John, of Upwell 2
4613796 2235333 2235333 defendant Aylyssham John   587227 587227 Aylyssham, John, of Upwell 0
4613797 2235333 2235333 defendant Walpol John   587227 587227 Walpol, John, of Upwell 1
4716007 2270315 2270315 plaintiff Bateman John   587227 587227 Bateman, John, of Upwell 2

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