names

161 rows where place_id = 601657

✎ 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
3646384 1909263 1909263 defendant Rawson William chapman 601657 601657 Rawson, William, of Doncaster, Yorks, chapman 0
3667481 1915771 1915771 defendant Coke Edith widow 601657 601657 Coke, Edith, of Doncaster, Yorks, widow 1
3693307 1924119 1924119 plaintiff Lynsey Robert mercer 601657 601657 Lynsey, Robert, of Doncaster, Yorks, mercer 0
3701206 1926622 1926622 defendant Lewes Ralph draper 601657 601657 Lewes, Ralph, of Doncaster, Yorks, draper 3
3701213 1926623 1926623 defendant Lewes Ralph draper 601657 601657 Lewes, Ralph, of Doncaster, Yorks, draper 3
3792369 1955474 1955474 defendant Haldenby Robert esq 601657 601657 Haldenby, Robert, of Doncaster, Yorks, esq 0
3875673 1982110 1982110 plaintiff Frobiser Francis esq 601657 601657 Frobiser, Francis, of Doncaster, Yorks, esq 0
3897241 1989293 1989293 defendant Elles Thomas merchant 601657 601657 (Elles, Thomas, of Doncaster, Yorks, merchant 1
3904647 1991810 1991810 defendant Dey John merchant 601657 601657 Dey, John, of Doncaster, Yorks, merchant 0
3913988 1995023 1995023 plaintiff Browne John merchant 601657 601657 Browne, John, of Doncaster, Yorks, merchant 0
3930025 2000386 2000386 defendant Smythe Paul yeoman 601657 601657 Smythe, Paul, of Doncaster, Yorks, yeoman 0
3934498 2001834 2001834 defendant Smyth William chapman 601657 601657 Smyth, William, of Doncaster, Yorks, chapman 0
3938062 2003063 2003063 defendant Witmore Richard chapman 601657 601657 Witmore, Richard, of Doncaster, Yorks, chapman 0
3941099 2004025 2004025 defendant Whytmore Richard gent 601657 601657 Whytmore, Richard, of Doncaster, Yorks, gent 3
3942023 2004345 2004345 plaintiff Webster Thomas   601657 601657 Webster, Thomas, of Doncaster, Yorks 0
3957905 2009827 2009827 defendant Palmer Robert yeoman 601657 601657 Palmer, Robert, of Doncaster, Yorks, yeoman 0
3972575 2014987 2014987 defendant Fulwood Nicholas alderman 601657 601657 Fulwood, Nicholas, of Doncaster, Yorks, alderman 0
3972589 2014990 2014990 defendant Warcoppe Robert gent 601657 601657 Warcoppe, Robert, of Doncaster, Yorks, gent 0
4012815 2029305 2029305 defendant Wryght Michael innholder 601657 601657 Wryght, Michael, of Doncaster, Yorks, innholder 0
4026416 2034092 2034092 defendant Fyssher Leonard laborer 601657 601657 Fyssher, Leonard, of Doncaster, Yorks, laborer 0
4057241 2044978 2044978 defendant Smyth William yeoman 601657 601657 Smyth, William, of Doncaster, Yorks, yeoman 0
4068138 2048911 2048911 defendant Snell or Suell John chapman 601657 601657 Snell or Suell, John, of Doncaster, Yorks, chapman 2
4070354 2049693 2049693 defendant Hudson William chapman 601657 601657 Hudson, William, of Doncaster, Yorks, chapman 0
4073293 2050737 2050737 defendant Hurst William yeoman 601657 601657 Hurst, William, of Doncaster, Yorks, yeoman 3
4074551 2051201 2051201 defendant Hudson William mercer 601657 601657 Hudson, William, of Doncaster, Yorks, mercer 0
4076521 2051899 2051899 defendant Snell or Suell John mercer 601657 601657 Snell or Suell, John, of Doncaster, Yorks, mercer 0
4077219 2052137 2052137 defendant Snell or Suell John chapman 601657 601657 Snell or Suell, John, of Doncaster, Yorks, chapman 0
4097538 2059448 2059448 defendant Snell or Suell John chapman 601657 601657 Snell or Suell, John, of Doncaster, Yorks, chapman 1
4098518 2059800 2059800 defendant Snell John chapman 601657 601657 Snell, John, of Doncaster, Yorks, chapman 1
4100728 2060581 2060581 defendant Snell or Suell John chapman 601657 601657 Snell or Suell, John, of Doncaster, Yorks, chapman 0
4105691 2062323 2062323 defendant Huston William chapman 601657 601657 Huston, William, of Doncaster, Yorks, chapman 2
4121290 2067910 2067910 defendant Skargell Nicholas alderman 601657 601657 Skargell, Nicholas, of Doncaster, Yorks, alderman 0
4122590 2068376 2068376 defendant Trewsedall John chapman 601657 601657 Trewsedall, John, of Doncaster, Yorks, chapman 0
4126857 2069898 2069898 defendant Pygbourne Wilfred yeoman 601657 601657 Pygbourne, Wilfred, of Doncaster, Yorks, yeoman 0
4127904 2070270 2070270 defendant Stanyforthe Thomas chapman 601657 601657 Stanyforthe, Thomas, of Doncaster, Yorks, chapman 0
4130376 2071177 2071177 defendant Skargell Nicholas chapman 601657 601657 Skargell, Nicholas, of Doncaster, Yorks, chapman 0
4135736 2073109 2073109 defendant Palmer Robert alderman 601657 601657 Palmer, Robert, of Doncaster, Yorks, gent, alderman 0
4140610 2074882 2074882 defendant Scargell Nicholas mercer 601657 601657 Scargell, Nicholas, of Doncaster, Yorks, mercer 2
4141264 2075105 2075105 defendant Skargell Nicholas chapman 601657 601657 Skargell, Nicholas, of Doncaster, Yorks, chapman 0
4142835 2075669 2075669 defendant Skargell Nicholas haberdasher 601657 601657 Skargell, Nicholas, of Doncaster, Yorks, haberdasher 0
4146248 2076837 2076837 defendant Stannyford Thomas chapman 601657 601657 Stannyford, Thomas, of Doncaster, Yorks, chapman 2
4147990 2077428 2077428 defendant Snell or Suell John mercer 601657 601657 Snell or Suell, John, of Doncaster, Yorks, mercer 0
4150215 2078208 2078208 defendant Pygbourne Wilfred yeoman 601657 601657 Pygbourne, Wilfred, of Doncaster, Yorks, yeoman 0
4153864 2079448 2079448 defendant Syndall William chapman 601657 601657 Syndall, William, of Doncaster, Yorks, chapman 0
4162398 2082408 2082408 defendant Snydell William chapman 601657 601657 Snydell, William, of Doncaster, Yorks, chapman 1
4166897 2083918 2083918 defendant Fulwood Nicholas gent 601657 601657 Fulwood, Nicholas, of Doncaster, Yorks, gent 0
4178430 2087930 2087930 defendant Vessey Edward yeoman 601657 601657 Vessey, Edward, of Doncaster, Yorks, yeoman 0
4185826 2090536 2090536 defendant Snell or Suell John merchant 601657 601657 Snell or Suell, John, of Doncaster, Yorks, merchant 0
4185828 2090537 2090537 defendant Snell or Suell John merchant 601657 601657 Snell or Suell, John, of Doncaster, Yorks, merchant 0
4190365 2092158 2092158 defendant Clayton Thomas currier 601657 601657 Clayton, Thomas, of Doncaster, Yorks, currier 0
4199830 2095492 2095492 defendant Tempest Francis gent 601657 601657 Tempest, Francis, of Doncaster, Yorks, gent 1
4205017 2097299 2097299 defendant Hackney Robert vintner 601657 601657 Hackney, Robert, of Doncaster, Yorks, innholder, vintner 0
4223908 2103848 2103848 defendant Morehowse James chapman 601657 601657 Morehowse, James, of Doncaster, Yorks, chapman 0
4224519 2104056 2104056 defendant Worlyche William gent 601657 601657 Worlyche, William, of Doncaster, Yorks, gent 1
4231010 2106344 2106344 defendant Copley William gent 601657 601657 Copley, William, of Doncaster, Yorks, gent 0
4242100 2110353 2110353 defendant Myddleton John draper 601657 601657 Myddleton, John, of Doncaster, Yorks, draper 0
4247883 2112275 2112275 defendant Swifte Leonard gent 601657 601657 Swifte, Leonard, of Doncaster, Yorks, gent 0
4249449 2112800 2112800 defendant Morehowse James chapman 601657 601657 Morehowse, James, of Doncaster, Yorks, chapman 0
4251796 2113591 2113591 defendant Middleton John draper 601657 601657 Middleton, John, of Doncaster, Yorks, draper 1
4252037 2113671 2113671 defendant Dobson Simon mercer 601657 601657 Dobson, Simon, of Doncaster, Yorks, or of Gaynsburghe, Lincs, mercer 0
4253843 2114283 2114283 defendant Ellys Francis gent 601657 601657 Ellys, Francis, of Doncaster, Yorks, gent 0
4253846 2114284 2114284 defendant Ellys Francis gent 601657 601657 Ellys, Francis, of Doncaster, Yorks, gent 0
4279666 2122806 2122806 defendant Pearson Michael innholder 601657 601657 Pearson, Michael, of Doncaster, Yorks, innholder 0
4304446 2131695 2131695 defendant Pearson Michael mercer 601657 601657 Pearson, Michael, of Doncaster, Yorks, chapman, or of Wakefield, mercer 0
4312515 2134510 2134510 defendant Cowlynge William draper 601657 601657 Cowlynge, William, of Doncaster, Yorks, draper 0
4328382 2139808 2139808 defendant Daubney Marmaduke chapman 601657 601657 Daubney, Marmaduke, of Doncaster, Yorks, chapman 1
4330221 2140411 2140411 defendant Danburye Marmaduke chapman 601657 601657 Danburye, Marmaduke, of Doncaster, Yorks, chapman 0
4331366 2140789 2140789 defendant Pearson Michael yeoman 601657 601657 Pearson, Michael, of Doncaster, Yorks, yeoman 0
4332680 2141214 2141214 defendant Pierse Michael innholder 601657 601657 Pierse, Michael, of Doncaster, Yorks, innholder 0
4334151 2141701 2141701 defendant Pierson Michael innholder 601657 601657 Pierson, Michael, of Doncaster, Yorks, innholder 0
4343713 2145081 2145081 defendant Storthes Thomas gent 601657 601657 Storthes, Thomas, of Doncaster, Yorks, gent 0
4357016 2149685 2149685 defendant Tayler John yeoman 601657 601657 Tayler, John, of Doncaster, Yorks, yeoman 0
4382023 2158672 2158672 defendant Short Hugh yeoman 601657 601657 Short, Hugh, of Doncaster, Yorks, yeoman 3
4412445 2168753 2168753 defendant Cawood Mathew chapman 601657 601657 Cawood, Mathew, of Doncaster, Yorks, chapman 3
4729529 2274446 2274446 defendant Eland John gent 601657 601657 Eland, John, of Doncaster, Yorks, gent 0
4745445 2279173 2279173 defendant Gernon Richard chapman 601657 601657 Gernon, Richard, of Doncaster, Yorks, chapman 4
4758903 2283134 2283134 defendant Canteley Alice widow 601657 601657 Canteley, Alice, of Doncaster, Yorks, widow 0
4765851 2285316 2285316 defendant Brynyng John   601657 601657 Brynyng, John, of Doncaster, Yorks, spice seller 4
4768465 2286112 2286112 defendant Gatt Alan chaplain 601657 601657 Gatt, Alan, of Doncaster, Yorks, chaplain 0
4809309 2299085 2299085 defendant Milngate Alexander draper 601657 601657 Milngate, Alexander, of Doncaster, Yorks, draper 4
4811125 2299590 2299590 defendant Wheteley William gent 601657 601657 Wheteley, William, of Doncaster, Yorks, gent 0
4830436 2305553 2305553 defendant Glover Reginald   601657 601657 Glover, Reginald, of Doncaster, Yorks, glove maker 0
4839607 2308305 2308305 defendant Banastre Roger gent 601657 601657 Banastre, Roger, of Doncaster, Yorks, gent 0
4844662 2309848 2309848 defendant Wheteley William gent 601657 601657 Wheteley, William, of Doncaster, Yorks, gent 0
4849955 2311458 2311458 defendant Misne Thomas gent 601657 601657 Misne, Thomas, of Doncaster, Yorks, gent 1
4849963 2311459 2311459 defendant Misne Thomas gent 601657 601657 Misne, Thomas, of Doncaster, Yorks, gent 1
4894154 2324868 2324868 defendant Grene John gent 601657 601657 Grene, John, of Doncaster, Yorks, gent 0
4980139 2351012 2351012 defendant Shether John, junior chapman 601657 601657 Shether, John, junior, of Doncaster, Yorks, chapman 0
4980145 2351013 2351013 defendant Shether John, junior chapman 601657 601657 Shether, John, junior, of Doncaster, Yorks, chapman 0
4985505 2352582 2352582 defendant Chaumberlane John bower 601657 601657 Chaumberlane, John, of Doncaster, Yorks, bower 1
4985507 2352583 2352583 defendant Barneburgh John vintner 601657 601657 Barneburgh, John, of Doncaster, Yorks, vintner 0
4999464 2356711 2356711 defendant Meysen Thomas   601657 601657 Meysen, Thomas, of Doncaster, Yorks, franklin 0
4999466 2356712 2356712 defendant Meyson Thomas   601657 601657 Meyson, Thomas, of Doncaster, Yorks, franklin 0
5012022 2360367 2360367 defendant Batheius William baker 601657 601657 Batheius, William, of Doncaster, Yorks, baker 1
5012023 2360367 2360367 defendant Dale John shoemaker 601657 601657 Dale, John, of Doncaster, Yorks, shoemaker 2
5012025 2360367 2360367 defendant Burnley John smith 601657 601657 Burnley, John, of Doncaster, Yorks, smith 4
5014885 2361232 2361232 defendant Bladsmyth William cutler 601657 601657 Bladsmyth, William, of Doncaster, Yorks, cutler 0
5029272 2365438 2365438 defendant Bladsmyth William curler 601657 601657 Bladsmyth, William, of Doncaster, Yorks, curler 3
5034886 2367060 2367060 defendant Busby Richard   601657 601657 Busby, Richard, of Doncaster, Yorks, freemason 0
5039075 2368335 2368335 defendant Fethyan John   601657 601657 Fethyan, John, of Doncaster, Yorks, vicar 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);