names

149 rows where place_id = 587301

✎ 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
3591024 1864818 1864818 defendant More alias Parker William yeoman or sherman 587301 587301 More alias Parker, William, of Dunstable, Beds, yeoman or sherman 0
3602562 1868462 1868462 defendant Cowntas Edmund yeoman 587301 587301 Cowntas, Edmund, of Dunstable, Beds, yeoman 1
3620231 1873905 1873905 defendant Fauconer alias Frankelen Henry   587301 587301 Fauconer alias Frankelen, Henry, of Dunstable, Beds, collar maker or fisher 0
3650467 1910512 1910512 defendant Bowstrete Edward maltman 587301 587301 Bowstrete, Edward, of Dunstable, Beds, maltman 0
3655460 1911969 1911969 defendant Symondys William yeoman 587301 587301 Symondys, William, of Dunstable, Beds, yeoman 0
3670647 1916782 1916782 defendant Toly Robert   587301 587301 Toly, Robert, of Dunstable, Beds, tile maker 1
3708582 1928984 1928984 defendant Bentlowe Thomas innholder 587301 587301 Bentlowe, Thomas, of Dunstable, Beds, innholder 0
3737031 1937825 1937825 defendant Cavendysshe George gent 587301 587301 Cavendysshe, George, of Dunstable, Beds, gent 0
3737044 1937826 1937826 defendant Cavendysshe George gent 587301 587301 Cavendysshe, George, of Dunstable, Beds, gent 0
3746276 1940745 1940745 defendant Myller Thomas baker 587301 587301 Myller, Thomas, of Dunstable, Beds, baker 0
3754773 1943449 1943449 defendant Bowne William maltman 587301 587301 Bowne, William, of Dunstable, Beds, maltman 0
3789763 1954629 1954629 defendant Aulaby Eleanor widow 587301 587301 Aulaby, Eleanor, of Dunstable, Beds, widow 0
3829112 1966986 1966986 defendant Bodyngton Hugh yeoman 587301 587301 Bodyngton, Hugh, of Dunstable, Beds, yeoman 1
3838995 1970124 1970124 defendant Ploughwryght Thomas maltman 587301 587301 Ploughwryght, Thomas, of Dunstable, Beds, maltman 0
3849453 1973428 1973428 defendant Grene Henry baker 587301 587301 (Grene, Henry, of Dunstable, Beds, baker 1
3853123 1974596 1974596 defendant Brandeley Richard gent 587301 587301 Brandeley, Richard, of Dunstable, Beds, gent 0
3867359 1979315 1979315 defendant Bur John chapman 587301 587301 Bur, John, of Dunstable , Beds, chapman 4
3867365 1979316 1979316 defendant Bur John chapman 587301 587301 Bur, John, of Dunstable, Beds, chapman 4
3867622 1979406 1979406 defendant Brandeley Richard gent 587301 587301 Brandeley, Richard, of Dunstable, Beds, gent 0
3875161 1981930 1981930 defendant (not given) John rector of Barns 587301 587301 Barns, John, of Dunstable, Beds, clerk, rector of Wormeley 0
3879341 1983342 1983342 defendant Knyghtley John butcher 587301 587301 Knyghtley, John, of Dunstable, Beds, butcher 0
3881083 1983944 1983944 defendant Butteler Ewan laborer 587301 587301 Butteler, Ewan, of Dunstable, Beds, laborer 0
3898971 1989860 1989860 defendant Rustlyng John yeoman 587301 587301 Rustlyng, John, of Dunstable, Beds, yeoman 1
3907222 1992706 1992706 defendant Aleyn Thomas cordwainer 587301 587301 Aleyn, Thomas, of Dunstable, Beds, cordwainer 0
3914218 1995101 1995101 defendant Alen Thomas shoemaker 587301 587301 Alen, Thomas, of Dunstable, Beds, shoemaker 0
3924735 1998589 1998589 defendant Bentley Thomas yeoman 587301 587301 Bentley, Thomas, of Dunstable, Beds, yeoman 0
3935665 2002240 2002240 defendant Savage Margaret widow 587301 587301 Savage, Margaret, of Dunstable, Beds, widow 2
3943275 2004771 2004771 defendant Beton Roger mercer 587301 587301 Beton, Roger, of Dunstable, Beds, mercer 1
3946293 2005779 2005779 defendant Rayshe John   587301 587301 Rayshe, John, of Dunstable, Beds, tile maker 0
3951634 2007626 2007626 defendant Thorpe William yeoman 587301 587301 Thorpe, William, of Dunstable, Beds, yeoman 0
3962241 2011375 2011375 defendant Owen Lawrence shoemaker 587301 587301 Owen, Lawrence, of Dunstable, Beds, shoemaker 0
3976736 2016430 2016430 defendant Shelton John   587301 587301 Shelton, John, of Dunstable, Beds, surgeon 0
3979192 2017307 2017307 defendant Bowstred or Bowestret Richard husbandman 587301 587301 Bowstred or Bowestret, Richard, of Dunstable, Beds, husbandman 0
3986682 2019977 2019977 defendant Langstowe Thomas smith 587301 587301 Langstowe, Thomas, of Dunstable, Beds, smith 0
3988165 2020513 2020513 defendant Lessam Thomas butcher 587301 587301 Lessam, Thomas, of Dunstable, Beds, butcher 0
3996610 2023547 2023547 defendant West Mathew yeoman 587301 587301 West, Mathew, of Dunstable, Beds, yeoman 1
4014098 2029770 2029770 defendant Stybbyng Anthony gent 587301 587301 Stybbyng, Anthony, of Dunstable, Beds, gent 1
4016320 2030532 2030532 defendant Weste Mathew yeoman 587301 587301 Weste, Mathew, of Dunstable, Beds, yeoman 0
4016622 2030651 2030651 defendant Bankes Thomas tailor 587301 587301 Bankes, Thomas, of Dunstable, Beds, tailor 0
4022547 2032789 2032789 plaintiff Arnold John baker 587301 587301 Arnold, John, of Dunstable, Beds, baker 0
4030417 2035535 2035535 defendant Annas Richard gent 587301 587301 Annas, Richard, of Dunstable, Beds, gent 0
4032071 2036138 2036138 defendant Harbersone Thomas cutler 587301 587301 Harbersone, Thomas, of Dunstable, Beds, cutler 1
4045548 2040858 2040858 defendant Myller Mathew yeoman 587301 587301 Myller, Mathew, of Dunstable, Beds, yeoman 1
4048691 2041977 2041977 plaintiff Thorpe William yeoman 587301 587301 Thorpe, William, of Dunstable, Beds, yeoman 0
4060528 2046167 2046167 plaintiff Davye John, senior (legal representative) 587301 587301 Davye, John, senior, of Dunstable, Beds, yeoman, executors of 0
4070776 2049844 2049844 defendant Thorpe William innholder 587301 587301 Thorpe, William, of Dunstable, Beds, innholder 0
4086155 2055322 2055322 defendant Davye John yeoman 587301 587301 Davye, John, of Dunstable, Beds, yeoman 0
4121071 2067826 2067826 defendant Bennell William yeoman 587301 587301 Bennell, William, of Dunstable, Beds, yeoman 0
4121073 2067827 2067827 defendant Bennell William yeoman 587301 587301 Bennell, William, of Dunstable, Beds, yeoman 0
4132546 2071957 2071957 defendant Typladye Anthony chapman 587301 587301 Typladye, Anthony, of Dunstable, Beds, chapman 0
4133897 2072459 2072459 defendant Thorpe James yeoman 587301 587301 Thorpe, James, of Dunstable, Beds, yeoman 0
4137125 2073627 2073627 defendant Bennett Roland innholder 587301 587301 Bennett, Roland, of Dunstable, Beds, innholder 0
4143460 2075872 2075872 defendant Typlade Anthony chapman 587301 587301 Typlade, Anthony, of Dunstable, Beds, chapman 2
4146442 2076905 2076905 defendant Tiplady Anthony mercer 587301 587301 Tiplady, Anthony, of Dunstable, Beds, mercer 0
4146444 2076906 2076906 defendant Tipladye John, senior mercer 587301 587301 Tipladye, John, senior, of Dunstable, Beds, mercer 0
4147011 2077100 2077100 defendant Bennett Roland yeoman 587301 587301 Bennett, Roland, of Dunstable, Beds, innholder, or of Windsor, Berks, yeoman 0
4167018 2083967 2083967 defendant Dennam Thomas tailor 587301 587301 Dennam, Thomas, of Dunstable, Beds, tailor 1
4168149 2084347 2084347 defendant Bennell William yeoman 587301 587301 Bennell, William, of Dunstable, Beds, yeoman 0
4170492 2085173 2085173 defendant Typladye Anthony chapman 587301 587301 Typladye, Anthony, of Dunstable, Beds, chapman 0
4191731 2092665 2092665 defendant Bennell William yeoman 587301 587301 Bennell, William, of Dunstable, Beds, yeoman 0
4193380 2093252 2093252 defendant Typlady John chapman 587301 587301 Typlady, John, of Dunstable, Beds, chapman 0
4194244 2093536 2093536 defendant Browne William chapman 587301 587301 Browne, William, of Dunstable, Beds, chapman 3
4194638 2093681 2093681 defendant Typladye Richard yeoman 587301 587301 Typladye, Richard, of Dunstable, Beds, yeoman 0
4202187 2096309 2096309 defendant Langto John smith 587301 587301 Langto, John, of Dunstable, Beds, smith 0
4208810 2098626 2098626 defendant Bennett Roland innholder 587301 587301 Bennett, Roland, of Dunstable, Beds, innholder 1
4259637 2116198 2116198 defendant Clarke Richard   587301 587301 Clarke, Richard, of Dunstable, Beds, yeoman, or of Burpitt, Dorset, sailor 0
4259700 2116215 2116215 defendant Clarke Richard   587301 587301 Clarke, Richard, of Dunstable, Beds, yeoman, or of Burpitt , Dorset, sailor 0
4286342 2125160 2125160 defendant Langtoe Thomas gent 587301 587301 Langtoe, Thomas, of Dunstable, Beds, gent 0
4288404 2125901 2125901 defendant Bennell or Bennett William innholder 587301 587301 Bennell or Bennett, William, of Dunstable, Beds, innholder 2
4294246 2128018 2128018 defendant Bennett Roland yeoman 587301 587301 Bennett, Roland, of Dunstable, Beds, innholder, or of Windsor, Berks, yeoman 0
4325810 2139006 2139006 defendant Pryor Robert chapman 587301 587301 Pryor, Robert, of Dunstable, Beds, chapman 1
4331788 2140925 2140925 defendant Coulsonsack alias Sadler Robert yeoman 587301 587301 Coulsonsack alias Sadler, Robert, of Dunstable, Beds, yeoman 0
4335591 2142181 2142181 defendant Bennell William yeoman 587301 587301 Bennell, William, of Dunstable, Beds, yeoman 1
4336488 2142496 2142496 defendant Temple Thomas chapman 587301 587301 Temple, Thomas, of Dunstable, Beds, chapman 3
4336991 2142665 2142665 defendant Yardley John baker 587301 587301 Yardley, John, of Dunstable, Beds, or of Brackley, Nhants, baker 0
4340359 2143889 2143889 defendant Jones Richard tailor 587301 587301 Jones, Richard, of Dunstable, Beds, tailor 1
4354766 2148887 2148887 defendant Colsonsake alias Sadler Robert gent 587301 587301 Colsonsake alias Sadler, Robert, of Dunstable, Beds, gent 0
4375496 2156290 2156290 defendant Coulsonsack alias Sadler Robert yeoman 587301 587301 Coulsonsack alias Sadler, Robert, of Dunstable, Beds, yeoman 0
4389210 2161020 2161020 defendant Bennett Roland yeoman 587301 587301 Bennett, Roland, of Dunstable, Beds, innholder, or of Windsor, Berks, yeoman 0
4395927 2163216 2163216 defendant Typladye William chapman 587301 587301 Typladye, William, of Dunstable, Beds, chapman 0
4396692 2163459 2163459 defendant Typladye William mercer 587301 587301 Typladye, William, of Dunstable, Beds, mercer 1
4399342 2164367 2164367 defendant Parr John gent 587301 587301 Parr, John, of Dunstable, Beds, gent 2
4697744 2264788 2264788 defendant Blount Walter husbandman 587301 587301 Blount, Walter, of Dunstable, Beds, husbandman 1
4701490 2265865 2265865 defendant Hele Thomas yeoman 587301 587301 Hele, Thomas, of Dunstable, Beds, yeoman 0
4708550 2268043 2268043 defendant Davy Hugh   587301 587301 Davy, Hugh, of Dunstable, Beds, parson of St Peter's church 2
4720309 2271695 2271695 defendant Cook Richard chapman 587301 587301 Cook, Richard, of Dunstable, Beds, chapman 0
4761093 2283821 2283821 defendant Bakere Thomas   587301 587301 Bakere, Thomas, of Dunstable, Beds, baker, formerly of Cambridge 0
4834389 2306762 2306762 defendant Jakes John mercer 587301 587301 Jakes, John, of Dunstable, Beds, mercer 1
4841519 2308877 2308877 defendant Jakes John chapman 587301 587301 Jakes, John, of Dunstable, Beds, chapman 3
4841983 2309032 2309032 defendant Frances Thomas smith 587301 587301 Frances, Thomas, of Dunstable, Beds, smith 0
4841989 2309033 2309033 defendant Frances Thomas smith 587301 587301 Frances, Thomas, of Dunstable, Beds, smith 0
4842650 2309237 2309237 plaintiff London Thomas maltman 587301 587301 London, Thomas, of Dunstable, Beds, maltman 0
4997977 2356255 2356255 defendant Pyebaker John chaplain 587301 587301 Pyebaker, John, of Dunstable, Beds, chaplain 0
5079489 2380358 2380358 defendant Hamond Richard yeoman 587301 587301 Hamond, Richard, of Dunstable, Beds, yeoman 0
5082377 2381226 2381226 defendant Anable Richard gent 587301 587301 Anable, Richard, of Dunstable, Beds, gent 0
5117847 2391647 2391647 defendant Fy- William husbandman 587301 587301 Fy-, William, of Dunstable, Beds, husbandman 1
5122755 2393090 2393090 defendant Playse Thomas   587301 587301 Playse, Thomas, of Dunstable, Beds, cook 1
5133500 2396290 2396290 defendant Blunt Robert butcher & hosteler 587301 587301 Blunt, Robert, of Dunstable, Beds, butcher & hosteler 0
5133502 2396291 2396291 defendant Blunt Robert butcher & hosteler 587301 587301 Blunt, Robert, of Dunstable, Beds, butcher & hosteler 0
5138202 2397686 2397686 defendant Carter Thomas chapman 587301 587301 Carter, Thomas, of Dunstable, Beds, chapman 3

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