names

127 rows where place_id = 623930

✎ 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
3755184 1943573 1943573 defendant Lucas Richard gent 623930 623930 Lucas, Richard, of Newarke on Trent, gent 0
3783970 1952766 1952766 defendant Lucas Richard gent 623930 623930 Lucas, Richard, of Newarke on Trent, gent 0
3890774 1987181 1987181 defendant Lemyng Robert pewterer 623930 623930 Lemyng, Robert, of Newarke on Trent, pewterer 2
3891824 1987517 1987517 plaintiff Lucas Richard esq 623930 623930 Lucas, Richard, of Newarke on Trent, esq 0
3905012 1991940 1991940 defendant Croxton Thomas upholsterer 623930 623930 Croxton, Thomas, of Newarke on Trent, upholsterer 0
3905013 1991940 1991940 defendant Lemynge Robert pewterer 623930 623930 Lemynge, Robert, of Newarke on Trent, pewterer 1
3921168 1997431 1997431 defendant Staples Robert   623930 623930 Staples, Robert, of Newarke on Trent, horse courser 0
3921169 1997431 1997431 defendant Worseley William yeoman 623930 623930 Worseley, William, of Newarke on Trent, yeoman 1
3944612 2005212 2005212 defendant Buckshawe Nicholas roper 623930 623930 Buckshawe, Nicholas, of Newarke on Trent, roper 0
3946948 2005996 2005996 plaintiff Chambers David tailor 623930 623930 Chambers, David, of Newarke on Trent, tailor 0
3949788 2007002 2007002 plaintiff Fayrefaxe Ellen widow of Henry Sutton 623930 623930 Ellen his wife, widow of Henry Sutton, of Newarke on Trent 1
3954648 2008692 2008692 defendant Foster Giles gent 623930 623930 Foster, Giles, of Newarke on Trent, gent 0
3962273 2011384 2011384 defendant Cowton Thomas mercer 623930 623930 Cowton, Thomas, of Newarke on Trent, mercer 1
3965201 2012440 2012440 defendant Leverton John mercer 623930 623930 Leverton, John, of Newarke on Trent, gent, mercer 0
3968118 2013473 2013473 defendant Leverton John mercer 623930 623930 Leverton, John, of Newarke on Trent, mercer 0
3968683 2013684 2013684 defendant Spurre William baker 623930 623930 Spurre, William, of Newarke on Trent, baker 4
3971781 2014694 2014694 defendant Forster Giles esq 623930 623930 Forster, Giles, of Newarke on Trent, esq 0
3972031 2014774 2014774 defendant Chapman Mathew baker 623930 623930 Chapman, Mathew, of Newarke on Trent, baker 0
3977381 2016659 2016659 defendant Forster Giles esq 623930 623930 Forster, Giles, of Newarke on Trent, esq 1
3978398 2017030 2017030 defendant Foster Thomas gent 623930 623930 Foster, Thomas, of Newarke on Trent, gent 0
3982779 2018612 2018612 defendant Forster Thomas gent 623930 623930 Forster, Thomas, of Newarke on Trent, gent 0
3983735 2018955 2018955 defendant Forster Giles gent 623930 623930 Forster, Giles, of Newarke on Trent, gent 0
3987741 2020363 2020363 defendant Stowe Peter yeoman 623930 623930 Stowe, Peter, of Newarke on Trent, yeoman 0
3991223 2021622 2021622 defendant Garnet Miles butcher 623930 623930 Garnet, Miles, of Newarke on Trent, butcher 0
3991256 2021635 2021635 defendant Johnson Richard yeoman 623930 623930 Johnson, Richard, of Newarke on Trent, yeoman 0
3991258 2021636 2021636 defendant Forster Giles esq 623930 623930 Forster, Giles, of Newarke on Trent, esq 0
3993550 2022437 2022437 defendant Forster John yeoman 623930 623930 Forster, John, of Newarke on Trent, yeoman 0
3993555 2022439 2022439 defendant Roselinge John cordwainer 623930 623930 Roselinge, John, of Newarke on Trent, cordwainer 1
3995863 2023269 2023269 defendant Parke William gent 623930 623930 Parke, William, of Newarke on Trent, gent 0
4001716 2025390 2025390 plaintiff Harrison William   623930 623930 Harrison, William, of Newarke on Trent 0
4001718 2025391 2025391 plaintiff Harrison William gent 623930 623930 Harrison, William, of Newarke on Trent, gent 0
4001854 2025437 2025437 plaintiff Harryson William gent 623930 623930 Harryson, William, of Newarke on Trent, gent 0
4012659 2029250 2029250 defendant Parkyne Thomas yeoman 623930 623930 Parkyne, Thomas, of Newarke on Trent, yeoman 2
4015484 2030235 2030235 defendant Leverton John yeoman 623930 623930 Leverton, John, of Newarke on Trent, yeoman 0
4015486 2030236 2030236 defendant Leverton John yeoman 623930 623930 Leverton, John, of Newarke on Trent, yeoman 0
4015487 2030236 2030236 defendant Brignoll John tanner 623930 623930 Brignoll, John, of Newarke on Trent, tanner 1
4033283 2036558 2036558 defendant Browne Edward fishmonger 623930 623930 Browne, Edward, of Newarke on Trent, fishmonger 2
4037420 2038043 2038043 plaintiff Kelsterne Edward draper 623930 623930 Kelsterne, Edward, of Newarke on Trent, draper 0
4037421 2038043 2038043 defendant Chambers David tailor 623930 623930 Chambers, David, of Newarke on Trent, tailor 0
4044608 2040523 2040523 defendant Bradshawe Bartholomew yeoman 623930 623930 Bradshawe, Bartholomew, of Newarke on Trent, yeoman 1
4049153 2042144 2042144 defendant Parke William gent 623930 623930 Parke, William, of Newarke on Trent, gent 0
4050469 2042595 2042595 defendant Fulwoode John yeoman 623930 623930 Fulwoode, John, of Newarke on Trent, yeoman 0
4056269 2044627 2044627 defendant Leverton John yeoman 623930 623930 Leverton, John, of Newarke on Trent, yeoman 0
4058410 2045393 2045393 defendant Bennett Robert butcher 623930 623930 Bennett, Robert, of Newarke on Trent, butcher 1
4065752 2048044 2048044 plaintiff Herreson William vintner 623930 623930 Herreson, William, of Newarke on Trent, vintner 0
4066395 2048275 2048275 defendant Maples John butcher 623930 623930 Maples, John, of Newarke on Trent, butcher 0
4083993 2054552 2054552 defendant Parke William (legal representative) 623930 623930 Parke, William, of Newarke on Trent, yeoman, executors of 0
4083994 2054552 2054552 defendant Bradshawe Bartholomew yeoman 623930 623930 (Bradshawe, Bartholomew, of Newarke on Trent, yeoman 1
4083995 2054552 2054552 defendant Parke Robert yeoman 623930 623930 Parke, Robert, of Newarke on Trent, yeoman 2
4083996 2054552 2054552 defendant Parke Mary spinster 623930 623930 Parke, Mary, of Newarke on Trent, spinster 3
4084547 2054750 2054750 defendant Maples John butcher 623930 623930 Maples, John, of Newarke on Trent, butcher 0
4084548 2054750 2054750 defendant Key John yeoman 623930 623930 Key, John, of Newarke on Trent, yeoman 1
4084549 2054750 2054750 defendant Harryson Roger   623930 623930 Harryson, Roger, of Newarke on Trent, rope maker 2
4092962 2057793 2057793 defendant Lyming Gawin yeoman 623930 623930 Lyming, Gawin, of Newarke on Trent, yeoman 0
4100919 2060644 2060644 defendant Sparowe William husbandman 623930 623930 Sparowe, William, of Newarke on Trent, husbandman 0
4102939 2061342 2061342 defendant Leake John gent 623930 623930 Leake, John, of Newarke on Trent, gent 0
4133022 2072139 2072139 defendant Burton John gent 623930 623930 Burton, John, of Newarke on Trent, gent 1
4156903 2080493 2080493 defendant Hapton Reginald yeoman 623930 623930 Hapton, Reginald, of Newarke on Trent, yeoman 0
4156904 2080493 2080493 defendant Burton John gent 623930 623930 Burton, John, of Newarke on Trent, gent 1
4157433 2080672 2080672 defendant Benytt Robert butcher 623930 623930 Benytt, Robert, of Newarke on Trent, butcher 1
4157436 2080673 2080673 defendant Bunytt or Benit Robert butcher 623930 623930 Bunytt or Benit, Robert, of Newarke on Trent, yeoman, butcher 1
4157766 2080788 2080788 defendant Wylson James chapman 623930 623930 Wylson, James, of Newarke on Trent, chapman 0
4164718 2083168 2083168 defendant Whaley William gent 623930 623930 Whaley, William, of Newarke on Trent, gent 0
4192288 2092863 2092863 defendant Crosse Michael yeoman 623930 623930 Crosse, Michael, of Newarke on Trent, yeoman 3
4196076 2094178 2094178 defendant Leverton John, junior mercer 623930 623930 Leverton, John, junior, of Newarke on Trent, mercer 1
4216276 2101186 2101186 defendant Baxter John yeoman 623930 623930 Baxter, John, of Newarke on Trent, yeoman 1
4216277 2101186 2101186 defendant Hunton Robert yeoman 623930 623930 Hunton, Robert, of Newarke on Trent, yeoman 2
4216755 2101354 2101354 defendant Hicke Thomas tanner 623930 623930 Hicke, Thomas, of Newarke on Trent, tanner 0
4216757 2101355 2101355 defendant Hicke Thomas tanner 623930 623930 Hicke, Thomas, of Newarke on Trent, tanner 0
4217265 2101535 2101535 defendant Wilson James mercer 623930 623930 Wilson, James, of Newarke on Trent, mercer 0
4217769 2101706 2101706 defendant Cockytt William yeoman 623930 623930 Cockytt, William, of Newarke on Trent, yeoman 0
4219212 2102216 2102216 defendant Hopton Reginald yeoman 623930 623930 Hopton, Reginald, of Newarke on Trent, yeoman 0
4219835 2102441 2102441 defendant Hatchett Andrew yeoman 623930 623930 Hatchett, Andrew, of Newarke on Trent, yeoman 2
4225616 2104425 2104425 defendant Hunton Robert yeoman 623930 623930 Hunton, Robert, of Newarke on Trent, yeoman 2
4225619 2104426 2104426 defendant Baxter John yeoman 623930 623930 Baxter, John, of Newarke on Trent, yeoman 1
4225620 2104426 2104426 defendant Hunton Robert yeoman 623930 623930 Hunton, Robert, of Newarke on Trent, yeoman 2
4228803 2105556 2105556 defendant Hatchett Andrew yeoman 623930 623930 Hatchett, Andrew, of Newarke on Trent, yeoman 2
4234535 2107623 2107623 defendant Greysbroke Ralph butcher 623930 623930 Greysbroke, Ralph, of Newarke on Trent, butcher 1
4236733 2108421 2108421 defendant Hopton Reginald yeoman 623930 623930 Hopton, Reginald, of Newarke on Trent, yeoman 1
4244389 2111098 2111098 defendant Bratherycke or Braderycke Edward yeoman 623930 623930 Bratherycke or Braderycke, Edward, of Newarke on Trent, yeoman 2
4279892 2122879 2122879 defendant Haslam Anthony mercer 623930 623930 Haslam, Anthony, of Newarke on Trent, mercer 0
4281002 2123256 2123256 defendant Holland John vintner 623930 623930 Holland, John, of Newarke on Trent, vintner 1
4283426 2124108 2124108 defendant Bradwall William gent 623930 623930 (Bradwall, William, of Newarke on Trent, gent 1
4283436 2124111 2124111 defendant Bradwell William gent 623930 623930 (Bradwell, William, of Newarke on Trent, gent 1
4300831 2130396 2130396 defendant Paryshe William baker 623930 623930 Paryshe, William, of Newarke on Trent, baker 0
4300832 2130396 2130396 defendant Hunston Henry gent 623930 623930 Hunston, Henry, of Newarke on Trent, gent 1
4300833 2130396 2130396 defendant Tayler William dyer 623930 623930 Tayler, William, of Newarke on Trent, dyer 2
4300835 2130397 2130397 defendant Redyatt Richard yeoman 623930 623930 Redyatt, Richard, of Newarke on Trent, yeoman 0
4300836 2130397 2130397 defendant Newcombe Augustone yeoman 623930 623930 Newcombe, Augustone, of Newarke on Trent, yeoman 1
4300837 2130397 2130397 defendant Edyall Henry gent 623930 623930 Edyall, Henry, of Newarke on Trent, gent 2
4329133 2140056 2140056 defendant Slynehed Henry sherman 623930 623930 Slynehed, Henry, of Newarke on Trent, sherman 0
4352380 2148070 2148070 defendant Marshe Henry vintner 623930 623930 Marshe, Henry, of Newarke on Trent, vintner 0
4359425 2150531 2150531 defendant Wilson James yeoman 623930 623930 Wilson, James, of Newarke on Trent, yeoman 0
4359426 2150531 2150531 defendant Clarke Edward yeoman 623930 623930 Clarke, Edward, of Newarke on Trent, yeoman 1
4364155 2152235 2152235 defendant Sutton John gent 623930 623930 Sutton, John, of Newarke on Trent, gent 0
4364159 2152237 2152237 defendant Forster Giles esq 623930 623930 Forster, Giles, of Newarke on Trent, or of Balderton,esq 0
4366467 2153051 2153051 defendant Nedeham Richard yeoman 623930 623930 Nedeham, Richard, of Newarke on Trent, or of Brent Broughton, Lincs, yeoman 0
4367963 2153591 2153591 defendant Emerson Robert slater 623930 623930 Emerson, Robert, of Newarke on Trent, slater 0
4367964 2153591 2153591 defendant Emerson Thomas slater 623930 623930 Emerson, Thomas, of Newarke on Trent, slater 1
4369167 2154038 2154038 defendant Otes Luke carrier 623930 623930 Otes, Luke, of Newarke on Trent, carrier 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);