names

247 rows where place_id = 586346

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588492 1864045 1864045 defendant Adam Thomas, senior merchant 586346 586346 Adam, Thomas, senior, of Langham, merchant 0
3591398 1864936 1864936 defendant Hurlston William butcher 586346 586346 Hurlston, William, of Langham, butcher 0
3591402 1864936 1864936 defendant Garlond John butcher 586346 586346 Garlond, John, of Langham, butcher 4
3596120 1866415 1866415 defendant Kelson William husbandman 586346 586346 Kelson, William, of Langham, husbandman 0
3600433 1867782 1867782 defendant Garlond John husbandman 586346 586346 Garlond, John, of Langham, husbandman 0
3600520 1867810 1867810 defendant Wymbyll John husbandman 586346 586346 Wymbyll, John, of Langham, husbandman 1
3602601 1868473 1868473 defendant Wymbyll John husbandman 586346 586346 Wymbyll, John, of Langham, husbandman 3
3622857 1874675 1874675 defendant Wymbyll John yeoman 586346 586346 Wymbyll, John, of Langham, yeoman 4
3623565 1874899 1874899 defendant Herman Richard laborer 586346 586346 Herman, Richard, of Langham, laborer 0
3673944 1917888 1917888 defendant Marchall John husbandman 586346 586346 Marchall, John, of Langham, husbandman 0
3690024 1923038 1923038 defendant Marshall John husbandman 586346 586346 Marshall, John, of Langham, husbandman 0
3701928 1926854 1926854 defendant Longfote Henry husbandman 586346 586346 Longfote, Henry, of Langham, husbandman 3
3703551 1927386 1927386 defendant Walker John husbandman 586346 586346 Walker, John, of Langham, husbandman 1
3719890 1932491 1932491 defendant Longfote Henry husbandman 586346 586346 Longfote, Henry, of Langham, husbandman 1
3757936 1944465 1944465 defendant Welle Richard chaplain 586346 586346 Welle, Richard, of Langham, chaplain 0
3757937 1944465 1944465 defendant Welle John husbandman 586346 586346 Welle, John, of Langham, husbandman 1
3757938 1944465 1944465 defendant Welle Robert husbandman 586346 586346 Welle, Robert, of Langham, husbandman 2
3764735 1946634 1946634 defendant Kyppyng John husbandman 586346 586346 Kyppyng, John, of Langham, husbandman 0
3765491 1946872 1946872 defendant Willesford Thomas husbandman 586346 586346 Willesford, Thomas, of Langham, husbandman 1
3765492 1946872 1946872 defendant Browne William husbandman 586346 586346 Browne, William, of Langham, husbandman 2
3765493 1946872 1946872 defendant Longfote Henry husbandman 586346 586346 Longfote, Henry, of Langham, husbandman 3
3811798 1961592 1961592 plaintiff Clerk William yeoman 586346 586346 Clerk, William, of Langham, yeoman 0
3811800 1961593 1961593 plaintiff Clerk William yeoman 586346 586346 Clerk, William, of Langham, yeoman 0
3811843 1961607 1961607 defendant Bury Robert butcher 586346 586346 Bury, Robert, of Langham, butcher 0
3811844 1961607 1961607 defendant Bury William butcher 586346 586346 Bury, William, of Langham, butcher 1
3811849 1961610 1961610 plaintiff Clerke William yeoman 586346 586346 Clerke, William, of Langham, yeoman 0
3875459 1982037 1982037 defendant Clark William yeoman 586346 586346 Clark, William, of Langham, yeoman 0
3882867 1984535 1984535 defendant Mannyng Richard (legal representative) 586346 586346 Mannyng, Richard, of Langham, husbandman, executor of 0
3882868 1984535 1984535 defendant Mannyng Anthony yeoman 586346 586346 Mannyng, Anthony, of Langham, yeoman 1
3888303 1986351 1986351 defendant Clerke John   586346 586346 Clerke, John, of Langham, wool winder 0
3896735 1989119 1989119 defendant Harryson Nicholas yeoman 586346 586346 Harryson, Nicholas, of Langham, yeoman 0
3896736 1989119 1989119 defendant Grycke John, senior husbandman 586346 586346 Grycke, John, senior, of Langham, husbandman 1
3896737 1989119 1989119 defendant Grycke John, junior yeoman 586346 586346 Grycke, John, junior, of Langham, yeoman 2
3898008 1989539 1989539 defendant Hunte John husbandman 586346 586346 Hunte, John, of Langham, husbandman 2
3914869 1995322 1995322 defendant Dygby Simon gent 586346 586346 Dygby, Simon, of Langham, gent 0
3929087 2000069 2000069 defendant Skye Thomas yeoman 586346 586346 Skye, Thomas, of Langham, yeoman 0
3931725 2000912 2000912 defendant Dykman William yeoman 586346 586346 Dykman, William, of Langham, yeoman 1
3941210 2004063 2004063 defendant Skye Thomas yeoman 586346 586346 Skye, Thomas, of Langham, yeoman 0
3943367 2004798 2004798 defendant Harrison William yeoman 586346 586346 Harrison, William, of Langham, yeoman 0
3946917 2005990 2005990 defendant Locksmyth Thomas husbandman 586346 586346 Locksmyth, Thomas, of Langham, husbandman 0
3948993 2006713 2006713 defendant Skye Thomas yeoman 586346 586346 Skye, Thomas, of Langham, yeoman 0
3948994 2006713 2006713 defendant Skye Nicholas yeoman or singleman 586346 586346 Skye, Nicholas, of Langham, yeoman or singleman 1
3948996 2006714 2006714 defendant Towtyng John husbandman 586346 586346 Towtyng, John, of Langham, husbandman 0
3952873 2008079 2008079 defendant Skye Thomas yeoman 586346 586346 Skye, Thomas, of Langham, yeoman 0
3952874 2008079 2008079 defendant Skye Nicholas yeoman or singleman 586346 586346 Skye, Nicholas, of Langham, yeoman or singleman 1
3954788 2008743 2008743 plaintiff Loksmyth Thomas husbandman 586346 586346 Loksmyth, Thomas, of Langham, husbandman 0
3956218 2009242 2009242 defendant Markham Elizas yeoman 586346 586346 Markham, Elizas, of Langham, yeoman 2
3959492 2010411 2010411 defendant Grekys Nicholas husbandman 586346 586346 Grekys, Nicholas, of Langham, husbandman 0
3962100 2011325 2011325 defendant Seman William   586346 586346 Seman, William, of Langham husbandman 0
3962101 2011325 2011325 defendant Seman Maud widow 586346 586346 Seman, Maud, of Langham, widow 1
3970924 2014390 2014390 defendant Hyller John husbandman 586346 586346 Hyller, John, of Langham, husbandman 0
3970929 2014392 2014392 defendant Hyller John husbandman 586346 586346 Hyller, John, of Langham, husbandman 0
3985656 2019634 2019634 plaintiff Waller Henry yeoman 586346 586346 Waller, Henry, of Langham, yeoman 0
4000827 2025065 2025065 defendant Howsygoo Richard husbandman 586346 586346 Howsygoo, Richard, of Langham, husbandman 0
4027339 2034425 2034425 defendant Harryson John yeoman 586346 586346 Harryson, John, of Langham, yeoman 4
4027345 2034426 2034426 defendant Grixe Nicholas yeoman 586346 586346 Grixe, Nicholas, of Langham, yeoman 0
4027347 2034427 2034427 defendant Grixe Nicholas yeoman 586346 586346 Grixe, Nicholas, of Langham, yeoman 0
4029124 2035059 2035059 defendant Gryxe John, junior husbandman 586346 586346 Gryxe, John, junior, of Langham, husbandman 1
4030100 2035412 2035412 defendant Walker Richard yeoman 586346 586346 Walker, Richard, of Langham, yeoman 2
4032020 2036120 2036120 defendant Gryxe or Eryxe Nicholas husbandman 586346 586346 Gryxe or Eryxe, Nicholas, of Langham, husbandman 0
4033540 2036648 2036648 defendant Walker Henry, junior yeoman 586346 586346 Walker, Henry, junior, of Langham, yeoman 0
4051215 2042874 2042874 plaintiff Whytfeld John gent 586346 586346 Whytfeld, John, of Langham, gent 0
4051839 2043077 2043077 defendant Grix John yeoman 586346 586346 Grix, John, of Langham, yeoman 0
4056509 2044712 2044712 defendant Harryson John yeoman 586346 586346 Harryson, John, of Langham, yeoman 0
4056552 2044728 2044728 defendant Cage Thomas yeoman 586346 586346 Cage, Thomas, of Langham, or of Bardwell, yeoman 0
4062612 2046923 2046923 defendant Clarke Bartholomew yeoman 586346 586346 Clarke, Bartholomew, of Langham, yeoman 0
4063247 2047149 2047149 defendant Grix Nicholas yeoman 586346 586346 Grix, Nicholas, of Langham, yeoman 0
4065818 2048071 2048071 defendant Harryson John husbandman 586346 586346 Harryson, John, of Langham, husbandman 1
4065821 2048072 2048072 defendant Harryson John husbandman 586346 586346 Harryson, John, of Langham, husbandman 1
4070882 2049885 2049885 defendant Lockesmythe Thomas husbandman 586346 586346 Lockesmythe, Thomas, of Langham, husbandman 0
4096888 2059221 2059221 defendant Waller Robert weaver 586346 586346 Waller, Robert, of Langham, weaver 0
4096889 2059221 2059221 defendant Ollie Henry weaver 586346 586346 Ollie, Henry, of Langham, weaver 1
4103587 2061567 2061567 defendant Grixe John husbandman 586346 586346 Grixe, John, of Langham, husbandman 0
4103590 2061568 2061568 defendant Gryxe or Eryxe John yeoman 586346 586346 Gryxe or Eryxe, John, of Langham, yeoman 0
4103591 2061568 2061568 defendant Gryxe or Eryxe Nicholas yeoman 586346 586346 Gryxe or Eryxe, Nicholas, of Langham, yeoman 1
4103594 2061569 2061569 defendant Gryxe John yeoman 586346 586346 Gryxe, John, of Langham, yeoman 0
4103595 2061569 2061569 defendant Gryxe Nicholas yeoman 586346 586346 Gryxe, Nicholas, of Langham, yeoman 1
4120077 2067468 2067468 defendant Harryson John yeoman 586346 586346 Harryson, John, of Langham, yeoman 2
4126608 2069802 2069802 defendant Gryxe Nicholas yeoman 586346 586346 Gryxe, Nicholas, of Langham, yeoman 0
4126609 2069802 2069802 defendant Harryson John husbandman 586346 586346 Harryson, John, of Langham, husbandman 1
4143283 2075818 2075818 defendant Cage Thomas (legal representative) 586346 586346 Cage, Thomas, of Langham, yeoman, executrix of 0
4147270 2077184 2077184 defendant Walker William shoemaker 586346 586346 Walker, William, of Langham, shoemaker 0
4153932 2079472 2079472 defendant Walker William cordwainer 586346 586346 Walker, William, of Langham, cordwainer 0
4167258 2084051 2084051 defendant Gryxe John yeoman 586346 586346 Gryxe, John, of Langham, yeoman 1
4171683 2085561 2085561 defendant Neale Thomas yeoman 586346 586346 Neale, Thomas, of Langham, yeoman 0
4194813 2093746 2093746 defendant Neale Thomas yeoman 586346 586346 Neale, Thomas, of Langham, yeoman 0
4194814 2093746 2093746 defendant Neale William yeoman 586346 586346 Neale, William, of Langham, yeoman 1
4203936 2096928 2096928 defendant Grixe Nicholas husbandman 586346 586346 Grixe, Nicholas, of Langham, husbandman 0
4210762 2099321 2099321 defendant Harryson John yeoman 586346 586346 Harryson, John, of Langham, yeoman 0
4210764 2099322 2099322 defendant Locksmyth John yeoman 586346 586346 Locksmyth, John, of Langham, yeoman 0
4214648 2100628 2100628 defendant Presgrave Henry husbandman 586346 586346 Presgrave, Henry, of Langham, husbandman 1
4217783 2101711 2101711 defendant Feltwell John   586346 586346 Feltwell, John, of Langham, shepherd 1
4219886 2102455 2102455 defendant Presgrave Henry yeoman 586346 586346 Presgrave, Henry, of Langham, yeoman 0
4219888 2102456 2102456 defendant Presgrave Henry yeoman 586346 586346 Presgrave, Henry, of Langham, yeoman 0
4226269 2104659 2104659 defendant Presgrave Henry yeoman 586346 586346 Presgrave, Henry, of Langham, yeoman 0
4228180 2105338 2105338 defendant Grixe John, junior husbandman 586346 586346 Grixe, John, junior, of Langham, husbandman 0
4242556 2110507 2110507 defendant Harrison John yeoman 586346 586346 Harrison, John, of Langham, yeoman 0
4242561 2110508 2110508 defendant Harrison John yeoman 586346 586346 Harrison, John, of Langham, yeoman 0
4281744 2123519 2123519 defendant Warry Thomas husbandman 586346 586346 Warry, Thomas, of Langham, husbandman 0
4318010 2136410 2136410 defendant Cooke John   586346 586346 Cooke, John, of Langham, mason 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);