names

184 rows where place_id = 586409

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588648 1864091 1864091 defendant Countas Edmund yeoman 586409 586409 Countas, Edmund, of Dunstable, yeoman 0
3588649 1864091 1864091 defendant Halsey William yeoman 586409 586409 Halsey, William, of Dunstable, yeoman 1
3628043 1903623 1903623 defendant Sawell Thomas yeoman 586409 586409 Sawell, Thomas, of Dunstable, yeoman 2
3635970 1906045 1906045 defendant Bowstrod Edward maltman 586409 586409 Bowstrod, Edward, of Dunstable, maltman 0
3635972 1906046 1906046 defendant Bowstrode Edward maltman 586409 586409 Bowstrode, Edward, of Dunstable, maltman 0
3659829 1913328 1913328 defendant Brygge John husbandman 586409 586409 Brygge, John, of Dunstable, husbandman 2
3659830 1913328 1913328 defendant Colman John husbandman 586409 586409 Colman, John, of Dunstable, husbandman 3
3676874 1918806 1918806 defendant Bell Alexander glover 586409 586409 Bell, Alexander, of Dunstable, glover 0
3676875 1918806 1918806 defendant Bonell or Bovell John fisher 586409 586409 Bonell or Bovell, John, of Dunstable, fisher 1
3714955 1930974 1930974 plaintiff Bradman Ambrose gent 586409 586409 Bradman, Ambrose, of Dunstable, gent 0
3714956 1930974 1930974 defendant Kent John yeoman 586409 586409 Kent, John, of Dunstable, yeoman 0
3746277 1940745 1940745 defendant Seyman William sherman 586409 586409 Seyman, William, of Dunstable, sherman 1
3747631 1941177 1941177 defendant Bentley Thomas innholder 586409 586409 Bentley, Thomas, of Dunstable, innholder 0
3757533 1944332 1944332 defendant A Kent John maltman 586409 586409 A Kent, John, of Dunstable, maltman 0
3763130 1946099 1946099 defendant Burton alias Clerk Thomas laborer 586409 586409 Burton alias Clerk, Thomas, of Dunstable, laborer 1
3772102 1948966 1948966 defendant Folentyne William laborer 586409 586409 Folentyne, William, of Dunstable, laborer 0
3772103 1948966 1948966 defendant Rayner Henry maltman 586409 586409 Rayner, Henry, of Dunstable, maltman 1
3780022 1951477 1951477 defendant Grantham Edward   586409 586409 Grantham, Edward, of Dunstable, mason 0
3789764 1954629 1954629 defendant Aulaby Edmund chaplain 586409 586409 Aulaby, Edmund, of Dunstable, chaplain 1
3796938 1956922 1956922 defendant Grantham Edward   586409 586409 Grantham, Edward, of Dunstable, mason 0
3816241 1962989 1962989 plaintiff Holdern John (legal representative) 586409 586409 Holdern, John, of Dunstable, yeoman, executors of 0
3816245 1962990 1962990 plaintiff Holdern John (legal representative) 586409 586409 Holdern, John, of Dunstable, yeoman, executors of 0
3825477 1965817 1965817 defendant Knyghtley John butcher 586409 586409 Knyghtley, John, of Dunstable, butcher 0
3825726 1965898 1965898 defendant Bowstrett Richard husbandman 586409 586409 Bowstrett, Richard, of Dunstable, husbandman 0
3825728 1965899 1965899 defendant Bowstrett Richard husbandman 586409 586409 Bowstrett, Richard, of Dunstable, husbandman 0
3843240 1971418 1971418 defendant Boustred or Bonstred Richard laborer 586409 586409 Boustred or Bonstred, Richard, of Dunstable, laborer 1
3845385 1972118 1972118 defendant Hardyng Henry husbandman 586409 586409 Hardyng, Henry, of Dunstable, husbandman 0
3848836 1973226 1973226 defendant Butler Owen maltman 586409 586409 Butler, Owen, of Dunstable, maltman 0
3848838 1973227 1973227 defendant Butler Owen maltman 586409 586409 Butler, Owen, of Dunstable, maltman 0
3857182 1975877 1975877 defendant Bateman Edward weaver 586409 586409 Bateman, Edward, of Dunstable, weaver 0
3860333 1976957 1976957 defendant Gregory Edward maltman 586409 586409 Gregory, Edward, of Dunstable, maltman 0
3864566 1978346 1978346 defendant Grene Henry baker 586409 586409 (Grene, Henry, of Dunstable, baker 1
3865758 1978774 1978774 defendant Parott William maltman 586409 586409 Parott, William, of Dunstable, maltman 1
3888672 1986466 1986466 defendant Hylton Adam yeoman 586409 586409 Hylton, Adam, of Dunstable, yeoman 0
3888673 1986466 1986466 defendant Aleyn Thomas shoemaker 586409 586409 Aleyn, Thomas, of Dunstable, shoemaker 1
3888736 1986486 1986486 defendant Thorpe William yeoman 586409 586409 Thorpe, William, of Dunstable, yeoman 0
3894551 1988388 1988388 defendant Rustelyng Elizabeth spinster 586409 586409 Rustelyng, Elizabeth, of Dunstable, spinster 2
3895746 1988786 1988786 defendant Wynche John butcher 586409 586409 Wynche, John, of Dunstable, butcher 0
3898321 1989648 1989648 defendant Aleyn Thomas shoemaker 586409 586409 Aleyn, Thomas, of Dunstable, shoemaker 1
3898324 1989649 1989649 defendant Thorpe William husbandman 586409 586409 Thorpe, William, of Dunstable, husbandman 0
3900335 1990347 1990347 plaintiff Burre John innholder 586409 586409 Burre, John, of Dunstable, innholder 0
3900336 1990347 1990347 defendant Rychardson Henry   586409 586409 Rychardson, Henry, of Dunstable, "spyttelman" 0
3910962 1993991 1993991 defendant Bentley Thomas yeoman 586409 586409 Bentley, Thomas, of Dunstable, yeoman 1
3912388 1994474 1994474 defendant Long Thomas maltman 586409 586409 Long, Thomas, of Dunstable, maltman 0
3924077 1998363 1998363 plaintiff Symondes William   586409 586409 Symondes, William, of Dunstable 0
3925117 1998712 1998712 defendant Bentley Thomas yeoman 586409 586409 Bentley, Thomas, of Dunstable, yeoman 3
3928278 1999793 1999793 defendant Leper Edward butcher 586409 586409 Leper, Edward, of Dunstable, butcher 0
3940987 2003992 2003992 defendant Hoyne Richard wheeler 586409 586409 Hoyne, Richard, of Dunstable, wheeler 0
3948110 2006403 2006403 defendant Poynton John butcher 586409 586409 Poynton, John, of Dunstable, butcher 0
3951635 2007626 2007626 defendant Thorpe Adam yeoman 586409 586409 Thorpe, Adam, of Dunstable, yeoman 1
3959455 2010395 2010395 defendant Thorpe William innholder or yeoman 586409 586409 Thorpe, William, of Dunstable, innholder or yeoman 0
3964171 2012077 2012077 plaintiff ap Rice Thomas innholder 586409 586409 ap Rice, Thomas, of Dunstable, innholder 0
3979193 2017307 2017307 defendant Bowstred or Bowestret James husbandman 586409 586409 Bowstred or Bowestret, James, of Dunstable, husbandman 1
3986683 2019977 2019977 defendant Langstowe Elizabeth widow 586409 586409 Elizabeth his wife, alias Elizabeth Freman, of Dunstable, widow 1
4000385 2024906 2024906 defendant Browne William   586409 586409 Browne, William, of Dunstable, linen draper 0
4016623 2030651 2030651 defendant Temple Thomas husbandman 586409 586409 Temple, Thomas, of Dunstable, husbandman 1
4016624 2030651 2030651 defendant Hebbes Thomas laborer 586409 586409 Hebbes, Thomas, of Dunstable, laborer 2
4016625 2030651 2030651 defendant More William laborer 586409 586409 More, William, of Dunstable, laborer 3
4026845 2034250 2034250 defendant Lepar Edward butcher 586409 586409 Lepar, Edward, of Dunstable, butcher 2
4048492 2041912 2041912 plaintiff Tharpe William yeoman 586409 586409 Tharpe, William, of Dunstable, yeoman 0
4048493 2041912 2041912 defendant Davy Richard yeoman 586409 586409 Davy, Richard, of Dunstable, yeoman 0
4048495 2041913 2041913 defendant Bentley Richard   586409 586409 Bentley, Richard, of Dunstable, yeoma or maltman 0
4048697 2041979 2041979 defendant Bentley Richard maltman 586409 586409 Bentley, Richard, of Dunstable, maltman 0
4086157 2055322 2055322 defendant Lanckto John smith 586409 586409 Lanckto, John, of Dunstable, smith 2
4109519 2063666 2063666 defendant Dynes John baker 586409 586409 Dynes, John, of Dunstable, baker 3
4123313 2068640 2068640 defendant Typladye Richard yeoman 586409 586409 Typladye, Richard, of Dunstable, yeoman 0
4123314 2068640 2068640 defendant Typladye John, junior yeoman 586409 586409 Typladye, John, junior, of Dunstable, yeoman 1
4132547 2071957 2071957 defendant Typladye John chapman 586409 586409 Typladye, John, of Dunstable, chapman 1
4181138 2088879 2088879 defendant Bennell Thomas yeoman 586409 586409 Bennell, Thomas, of Dunstable, yeoman 0
4181140 2088880 2088880 defendant Bennell Thomas yeoman 586409 586409 Bennell, Thomas, of Dunstable, yeoman 0
4186474 2090754 2090754 defendant Dennam Thomas tailor 586409 586409 Dennam, Thomas, of Dunstable, tailor 0
4202188 2096309 2096309 defendant Langto Thomas gent 586409 586409 Langto, Thomas, of Dunstable, gent 1
4209786 2098981 2098981 defendant Thorpe James innholder 586409 586409 Thorpe, James, of Dunstable, innholder 0
4210390 2099192 2099192 defendant Cowper William, senior   586409 586409 Cowper, William, senior, of Dunstable 3
4229626 2105847 2105847 defendant Typlady William mercer 586409 586409 Typlady, William, of Dunstable, mercer 1
4231808 2106622 2106622 defendant Whitwell Edward shoemaker 586409 586409 Whitwell, Edward, of Dunstable, shoemaker 0
4237842 2108839 2108839 defendant Cooper William, senior yeoman 586409 586409 Cooper, William, senior, of Dunstable, yeoman 0
4302475 2130985 2130985 defendant Pettye Richard shoemaker 586409 586409 Pettye, Richard, of Dunstable, shoemaker 0
4303849 2131478 2131478 defendant Davye John yeoman 586409 586409 Davye, John, of Dunstable, yeoman 1
4304327 2131652 2131652 defendant Bull William maltster 586409 586409 Bull, William, of Dunstable, maltster 2
4304654 2131758 2131758 defendant Fyssher Richard tailor 586409 586409 Fyssher, Richard, of Dunstable, tailor 0
4305821 2132173 2132173 defendant Wayne Adam yeoman 586409 586409 Wayne, Adam, of Dunstable, yeoman 0
4306410 2132383 2132383 defendant Pudsey Richard gent 586409 586409 Pudsey, Richard, of Dunstable, gent 1
4308946 2133282 2133282 defendant Bennell William yeoman 586409 586409 Bennell, William, of Dunstable, yeoman 0
4308948 2133283 2133283 defendant Pratt John yeoman 586409 586409 Pratt, John, of Dunstable, yeoman 0
4308949 2133283 2133283 defendant Collins John yeoman 586409 586409 Collins, John, of Dunstable, yeoman 1
4335592 2142181 2142181 defendant Langto Thomas yeoman 586409 586409 Langto, Thomas, of Dunstable, yeoman 2
4341781 2144401 2144401 defendant Langto Thomas yeoman 586409 586409 Langto, Thomas, of Dunstable, yeoman 0
4373774 2155686 2155686 defendant Ames William yeoman 586409 586409 Ames, William, of Dunstable, yeoman, son of Richard Ames, of Dunstable,yeoman 0
4394581 2162777 2162777 defendant Wayne Adam husbandman 586409 586409 Wayne, Adam, of Dunstable, husbandman 0
4404315 2166014 2166014 defendant Bennett William innholder 586409 586409 Bennett, William, of Dunstable, innholder 0
4409718 2167852 2167852 defendant Bennett Thomas tailor 586409 586409 Bennett, Thomas, of Dunstable, tailor 0
4409719 2167852 2167852 defendant Davye William maltman 586409 586409 Davye, William, of Dunstable, maltman 1
4409720 2167852 2167852 defendant Bennett Richard victualer 586409 586409 Bennett, Richard, of Dunstable, victualer 2
4415246 2169662 2169662 defendant Pessoner John le   586409 586409 Pessoner, John le, of Dunstable, son of John 1
4418059 2170529 2170529 defendant Pesshour John   586409 586409 Pesshour, John, of Dunstable 0
4553456 2217009 2217009 defendant (illegible) John   586409 586409 _, John, of Dunstable 0
4568505 2221722 2221722 defendant Greg John   586409 586409 Greg, John, of Dunstable 3
4603026 2232159 2232159 plaintiff Whyte John (legal representative) 586409 586409 Whyte, John, of Dunstable, executrix of 0
4603027 2232159 2232159 plaintiff Whyte Joan   586409 586409 Whyte, Joan, of Dunstable 1

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