names

188 rows where place_id = 588103

✎ 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
3593371 1865559 1865559 defendant Steward Henry yeoman 588103 588103 Steward, Henry, of Bentley, yeoman 0
3594771 1865990 1865990 defendant Marchall Thomas clerk 588103 588103 Marchall, Thomas, of Bentley, clerk 0
3617236 1873016 1873016 defendant Roberd Richard husbandman 588103 588103 Roberd, Richard, of Bentley, husbandman 0
3617237 1873016 1873016 defendant Roberd Robert laborer 588103 588103 Roberd, Robert, of Bentley, laborer 1
3617238 1873016 1873016 defendant Loute or Lonte John tailor 588103 588103 Loute or Lonte, John, of Bentley, tailor 2
3617239 1873016 1873016 defendant Sturdy Thomas husbandman 588103 588103 Sturdy, Thomas, of Bentley, husbandman 3
3617240 1873016 1873016 defendant Roberd Roger husbandman 588103 588103 Roberd, Roger, of Bentley, husbandman 4
3617241 1873016 1873016 defendant Modowecroft John husbandman 588103 588103 Modowecroft, John, of Bentley, husbandman 5
3617242 1873016 1873016 defendant Wryght Robert husbandman 588103 588103 Wryght, Robert, of Bentley, husbandman 6
3617284 1873030 1873030 plaintiff FitzWilliam Nicholas   588103 588103 FitzWilliam, Nicholas, of Bentley 0
3623995 1875037 1875037 defendant Clerk John husbandman 588103 588103 Clerk, John, of Bentley, husbandman 0
3634917 1905722 1905722 defendant Wallop Stephen gent 588103 588103 Wallop, Stephen, of Bentley, gent 1
3646666 1909360 1909360 defendant Bradford Richard husbandman 588103 588103 Bradford, Richard, of Bentley, husbandman 1
3654861 1911779 1911779 defendant Burges John yeoman 588103 588103 Burges, John, of Bentley by Doncaster, yeoman 0
3657486 1912602 1912602 defendant Burges John   588103 588103 Burges, John, of Bentley by Doncaster 0
3658340 1912859 1912859 defendant Maskeld John husbandman 588103 588103 Maskeld, John, of Bentley, husbandman 8
3665323 1915109 1915109 defendant Parmasay John miller 588103 588103 Parmasay, John, of Bentley, miller 2
3666461 1915462 1915462 defendant Roose Robert yeoman 588103 588103 Roose, Robert, of Bentley, yeoman 1
3666462 1915462 1915462 defendant Harygold John yeoman 588103 588103 Harygold, John, of Bentley, yeoman 2
3666465 1915462 1915462 defendant Herygold Edward yeoman 588103 588103 Herygold, Edward, of Bentley, yeoman 5
3666471 1915462 1915462 defendant Henmarse Thomas yeoman 588103 588103 Henmarse, Thomas, of Bentley, yeoman 11
3689326 1922825 1922825 defendant Stokkes Thomas yeoman 588103 588103 Stokkes, Thomas, of Bentley, yeoman 3
3700935 1926538 1926538 defendant Shertwent Ralph husbandman 588103 588103 Shertwent, Ralph, of Bentley, husbandman 1
3700938 1926539 1926539 defendant Shertwent Ralph husbandman 588103 588103 Shertwent, Ralph, of Bentley, husbandman 1
3714495 1930830 1930830 defendant Sherwent Ralph husbandman 588103 588103 Sherwent, Ralph, of Bentley, husbandman 2
3720472 1932686 1932686 defendant Hethe William husbandman 588103 588103 Hethe, William, of Bentley, husbandman 1
3730470 1935762 1935762 defendant Bradford Peter, junior husbandman 588103 588103 Bradford, Peter, junior, of Bentley, husbandman 0
3739082 1938433 1938433 defendant Hay Edward yeoman 588103 588103 Hay, Edward, of Bentley, yeoman 1
3746200 1940720 1940720 plaintiff Clarke Thomas   588103 588103 Clarke, Thomas, of Bentley 0
3748961 1941607 1941607 defendant Shirclyff Thomas yeoman 588103 588103 Shirclyff, Thomas, of Bentley, yeoman 0
3755423 1943650 1943650 defendant Gadburn George   588103 588103 Gadburn, George, of Bentley, mason 0
3764104 1946419 1946419 defendant Barbour William husbandman 588103 588103 Barbour, William, of Bentley, husbandman 3
3782836 1952382 1952382 defendant Peke Robert yeoman 588103 588103 Peke, Robert, of Bentley, yeoman 0
3782837 1952382 1952382 defendant Bradford Peter, senior husbandman 588103 588103 Bradford, Peter, senior, of Bentley, husbandman 1
3782838 1952382 1952382 defendant Bradford Peter, junior husbandman 588103 588103 Bradford, Peter, junior, of Bentley, husbandman 2
3783731 1952675 1952675 defendant Bynne Stephen chaplain 588103 588103 Bynne, Stephen, of Bentley, chaplain 1
3784519 1952943 1952943 defendant Peke Ednetta widow 588103 588103 Peke, Ednetta, of Bentley, widow 1
3788547 1954214 1954214 defendant Harman Thomas husbandman 588103 588103 Harman, Thomas, of Bentley, husbandman 0
3792455 1955503 1955503 defendant Peke Robert yeoman 588103 588103 Peke, Robert, of Bentley, yeoman 0
3804807 1959447 1959447 defendant Harman Thomas husbandman 588103 588103 Harman, Thomas, of Bentley, husbandman 0
3818783 1963780 1963780 defendant Gregory Henry husbandman 588103 588103 Gregory, Henry, of Bentley, husbandman 0
3851113 1973936 1973936 defendant Alen Thomas husbandman 588103 588103 Alen, Thomas, of Bentley, husbandman 3
3860376 1976966 1976966 defendant Haye John yeoman 588103 588103 Haye, John, of Bentley, yeoman 0
3861356 1977266 1977266 plaintiff Fletcher Richard gent 588103 588103 Fletcher, Richard, of Bentley, gent 0
3921411 1997502 1997502 defendant Snydall Thomas husbandman 588103 588103 Snydall, Thomas, of Bentley, husbandman 0
3925168 1998728 1998728 defendant Wadeson William yeoman 588103 588103 Wadeson, William, of Bentley, yeoman 0
3945596 2005536 2005536 plaintiff Brayton Richard   588103 588103 Brayton, Richard, of Bentley 0
3962534 2011487 2011487 defendant FitzWilliam Nicholas gent 588103 588103 FitzWilliam, Nicholas, of Bentley, gent 2
3966093 2012763 2012763 defendant Brayton William gent 588103 588103 Brayton, William, of Bentley, gent 0
3970311 2014212 2014212 defendant Steward William husbandman 588103 588103 Steward, William, of Bentley, husbandman 3
3982822 2018628 2018628 defendant Steward William husbandman 588103 588103 Steward, William, of Bentley, husbandman 3
4025565 2033800 2033800 defendant Wilbore Thomas (legal representative) 588103 588103 Wilbore, Thomas, of Bentley, gent, executrix of 0
4049291 2042193 2042193 defendant Wilbore Thomas (legal representative) 588103 588103 Wilbore, Thomas, of Bentley, gent, executrix of 1
4049296 2042195 2042195 defendant Wilbore Thomas (legal representative) 588103 588103 Wilbore, Thomas, of Bentley, gent, executrix of 0
4052817 2043443 2043443 defendant Brayton or Breton William yeoman 588103 588103 Brayton or Breton, William, of Bentley, yeoman 0
4069824 2049490 2049490 defendant Heath William yeoman 588103 588103 Heath, William, of Bentley, yeoman 1
4081525 2053703 2053703 plaintiff Wilbore Thomas (legal representative) 588103 588103 Wilbore, Thomas, of Bentley, gent, executors of 0
4102568 2061217 2061217 defendant Shelley John esq 588103 588103 Shelley, John, of Bentley, esq 3
4114386 2065428 2065428 defendant FitzWilliams John gent 588103 588103 FitzWilliams, John, of Bentley, gent 0
4114393 2065431 2065431 defendant Fitzwilliams John gent 588103 588103 Fitzwilliams, John, of Bentley, gent 0
4121266 2067901 2067901 defendant Brooke Richard yeoman 588103 588103 Brooke, Richard, of Bentley, yeoman 0
4123707 2068781 2068781 defendant Semecroft William   588103 588103 Semecroft, William, of Bentley, brick maker 1
4140993 2075009 2075009 defendant Sparke William yeoman 588103 588103 Sparke, William, of Bentley, yeoman 0
4152170 2078869 2078869 defendant Sadler Thomas husbandman 588103 588103 Sadler, Thomas, of Bentley, husbandman 1
4161853 2082213 2082213 defendant Fitzwilliam John gent 588103 588103 Fitzwilliam, John, of Bentley, gent 0
4165631 2083480 2083480 defendant Semycroft William   588103 588103 Semycroft, William, of Bentley, "brickstroker" 0
4181471 2088997 2088997 defendant Farrey or Farrer Ralph husbandman 588103 588103 Farrey or Farrer, Ralph, of Bentley, husbandman 0
4185063 2090283 2090283 defendant Nedham Robert clerk 588103 588103 Nedham, Robert, of Bentley, clerk 1
4188341 2091427 2091427 defendant Sparke William yeoman 588103 588103 Sparke, William, of Bentley, yeoman 0
4188343 2091428 2091428 defendant Sparke William yeoman 588103 588103 Sparke, William, of Bentley, yeoman 0
4196005 2094155 2094155 defendant Mawger John husbandman 588103 588103 Mawger, John, of Bentley, husbandman 4
4203785 2096881 2096881 defendant Wyles John husbandman 588103 588103 Wyles, John, of Bentley, husbandman 0
4208003 2098359 2098359 defendant Martyn Richard husbandman 588103 588103 Martyn, Richard, of Bentley, husbandman 0
4229964 2105965 2105965 defendant Sparke William yeoman 588103 588103 Sparke, William, of Bentley, yeoman 0
4236515 2108345 2108345 defendant Jefferis or Jeffreys Edward gent 588103 588103 Jefferis or Jeffreys, Edward, of Bentley, or of Cardebige, gent 0
4236516 2108345 2108345 defendant Mascald Thomas yeoman 588103 588103 Mascald, Thomas, of Bentley, yeoman 1
4245055 2111331 2111331 defendant Jefferis or Jeffreys Edward gent 588103 588103 Jefferis or Jeffreys, Edward, of Bentley, or of Tardebridge, gent 0
4245056 2111331 2111331 defendant Mascold Thomas yeoman 588103 588103 Mascold, Thomas, of Bentley, yeoman 1
4277738 2122138 2122138 defendant Harris Thomas yeoman 588103 588103 Harris, Thomas, of Bentley, yeoman 0
4303215 2131250 2131250 defendant Nuthall Thomas gent 588103 588103 Nuthall, Thomas, of Bentley, gent 0
4314182 2135068 2135068 defendant Blackburne Peter husbandman 588103 588103 Blackburne, Peter, of Bentley, husbandman 0
4314183 2135068 2135068 defendant Ewrie or Eure John gent 588103 588103 Ewrie or Eure, John, of Bentley, gent 1
4320663 2137318 2137318 defendant Harrison Ralph hammer man 588103 588103 Harrison, Ralph, of Bentley, hammer man 1
4326294 2139159 2139159 defendant Mascolde Humphrey yeoman 588103 588103 Mascolde, Humphrey, of Bentley, yeoman 2
4341968 2144471 2144471 defendant Davies Thomas husbandman 588103 588103 Davies, Thomas, of Bentley, husbandman 0
4343806 2145112 2145112 defendant Shepperd Robert husbandman 588103 588103 Shepperd, Robert, of Bentley, husbandman 1
4347100 2146243 2146243 defendant Wilkes Thomas yeoman 588103 588103 Wilkes, Thomas, of Bentley, yeoman 0
4371666 2154922 2154922 defendant Smythe William husbandman 588103 588103 Smythe, William, of Bentley, husbandman 3
4388478 2160784 2160784 defendant Fitzwilliam Gervase gent 588103 588103 Fitzwilliam, Gervase, of Bentley, gent 3
4395043 2162927 2162927 defendant Shepperd Robert husbandman 588103 588103 Shepperd, Robert, of Bentley, husbandman 1
4401019 2164932 2164932 defendant Davyes Thomas husbandman 588103 588103 Davyes, Thomas, of Bentley, husbandman 1
4405378 2166377 2166377 defendant Browne alias Thornton Christopher yeoman 588103 588103 Browne alias Thornton, Christopher, of Bentley, yeoman 0
4410390 2168075 2168075 defendant Fitzwilliams Charles gent 588103 588103 Fitzwilliams, Charles, of Bentley, gent 0
4410391 2168075 2168075 defendant Fitzwilliam Lionel gent 588103 588103 Fitzwilliam, Lionel, of Bentley, gent 1
4412021 2168612 2168612 defendant Martyn Richard gent 588103 588103 Martyn, Richard, of Bentley, gent 0
4534179 2210953 2210953 defendant Dyrcheley Thomas   588103 588103 Dyrcheley, Thomas, of Bentley 0
4676328 2258207 2258207 defendant Dylk John husbandman 588103 588103 Dylk, John, of Bentley, husbandman 3
4703753 2266554 2266554 defendant Grayse Geoffrey husbandman 588103 588103 Grayse, Geoffrey, of Bentley, husbandman 0
4720685 2271803 2271803 defendant More Henry yeoman 588103 588103 More, Henry, of Bentley, yeoman 5
4722018 2272215 2272215 defendant Stynt John husbandman 588103 588103 Stynt, John, of Bentley, husbandman 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);