names

2,752 rows where place_id = 586435

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588718 1864114 1864114 defendant Tremyll John yeoman 586435 586435 Tremyll, John, of Leicester, yeoman 0
3588723 1864115 1864115 defendant Tremyll John yeoman 586435 586435 Tremyll, John, of Leicester, yeoman 2
3589171 1864257 1864257 defendant Peny Thomas yeoman 586435 586435 Peny, Thomas, of Leicester, yeoman 1
3589187 1864262 1864262 defendant Eynesworth Henry vintner 586435 586435 Eynesworth, Henry, of Leicester, vintner 0
3589931 1864492 1864492 defendant Broun Robert grocer 586435 586435 Broun, Robert, of Leicester, grocer 0
3589935 1864492 1864492 defendant George Thomas hosteler 586435 586435 George, Thomas, of Leicester, hosteler 4
3589937 1864493 1864493 defendant Broun Robert grocer 586435 586435 Broun, Robert, of Leicester, grocer 0
3590427 1864649 1864649 defendant Chiltorne Thomas yeoman 586435 586435 Chiltorne, Thomas, of Leicester, yeoman 0
3591594 1864994 1864994 defendant Lonerede or Loverede Hugh clerk 586435 586435 Lonerede or Loverede, Hugh, of Leicester, clerk 3
3592054 1865131 1865131 defendant Lyon Bartholomew chapman 586435 586435 Lyon, Bartholomew, of Leicester, chapman 1
3592056 1865131 1865131 defendant Bekyngham Richard chapman 586435 586435 Bekyngham, Richard, of Leicester, chapman 3
3592318 1865212 1865212 defendant Johnson Richard sherman 586435 586435 Johnson, Richard, of Leicester, sherman 0
3592320 1865212 1865212 defendant Mores John miller 586435 586435 Mores, John, of Leicester, miller 2
3592613 1865305 1865305 defendant Selby John vintner 586435 586435 Selby, John, of Leicester, vintner 1
3593225 1865514 1865514 defendant George Thomas yeoman 586435 586435 George, Thomas, of Leicester, yeoman 2
3594007 1865764 1865764 defendant Lyon Bartholomew ironmonger 586435 586435 Lyon, Bartholomew, of Leicester, ironmonger 0
3594008 1865764 1865764 defendant Mychell William fishmonger 586435 586435 Mychell, William, of Leicester, fishmonger 1
3594244 1865842 1865842 defendant Pynder Henry butcher 586435 586435 Pynder, Henry, of Leicester, butcher 0
3594345 1865864 1865864 defendant Barford Agnes spinster 586435 586435 Barford, Agnes, of Leicester, spinster 1
3594349 1865865 1865865 defendant Barford Agnes spinster 586435 586435 Barford, Agnes, of Leicester, spinster 1
3595462 1866214 1866214 defendant Lyle Walter gent 586435 586435 Lyle, Walter, of Leicester, gent 0
3595465 1866215 1866215 defendant Lyle Walter gent 586435 586435 Lyle, Walter, of Leicester, gent 0
3595513 1866231 1866231 defendant Wygston William merchant 586435 586435 Wygston, William, of Leicester, merchant 0
3595524 1866236 1866236 defendant Parkhyll Roger clerk 586435 586435 Parkhyll, Roger, of Leicester, or of Fledburgh, clerk 0
3596277 1866465 1866465 defendant Wode Alice widow 586435 586435 Wode, Alice, of Leicester, widow 0
3596855 1866652 1866652 defendant Selby John taverner 586435 586435 Selby, John, of Leicester, taverner 2
3598589 1867183 1867183 defendant Lambe John broker 586435 586435 Lambe, John, of Leicester, broker 0
3598591 1867184 1867184 defendant Lambe John broker 586435 586435 Lambe, John, of Leicester, broker 0
3598875 1867272 1867272 defendant George Thomas innholder 586435 586435 George, Thomas, of Leicester, innholder 0
3599978 1867648 1867648 defendant May John innholder 586435 586435 May, John, of Leicester, innholder 2
3599983 1867649 1867649 defendant George Thomas innholder 586435 586435 George, Thomas, of Leicester, innholder 2
3600085 1867676 1867676 defendant Thomson Nicholas dyer 586435 586435 Thomson, Nicholas, of Leicester, dyer 0
3601295 1868070 1868070 defendant Whitewell John broker 586435 586435 Whitewell, John, of Leicester, broker 2
3601526 1868134 1868134 defendant Jekkys William gent 586435 586435 Jekkys, William, of Leicester, gent 3
3601532 1868135 1868135 defendant Jekkes William gent 586435 586435 Jekkes, William, of Leicester, gent 4
3601971 1868273 1868273 defendant Wattys Thomas husbandman 586435 586435 Wattys, Thomas, of Leicester, husbandman 0
3602172 1868346 1868346 defendant Stokes John vintner 586435 586435 Stokes, John, of Leicester, vintner 0
3602180 1868348 1868348 defendant Stokes John vintner 586435 586435 Stokes, John, of Leicester, vintner 0
3602260 1868372 1868372 defendant May Walter chapman 586435 586435 May, Walter, of Leicester, chapman 0
3602636 1868487 1868487 plaintiff Hampton Thomas   586435 586435 Hampton, Thomas, of Leicester 1
3602637 1868487 1868487 defendant George Thomas yeoman 586435 586435 George, Thomas, of Leicester, yeoman 0
3602638 1868487 1868487 defendant Esterton John sherman 586435 586435 Esterton, John, of Leicester, sherman 1
3604254 1868994 1868994 plaintiff George Thomas   586435 586435 George, Thomas, of Leicester 0
3604264 1868996 1868996 defendant Hulse Richard pewterer 586435 586435 Hulse, Richard, of Leicester, pewterer 1
3604401 1869043 1869043 plaintiff Gouleson John yeoman 586435 586435 Gouleson, John, of Leicester, yeoman 0
3604402 1869043 1869043 defendant Roberdys John esq 586435 586435 Roberdys, John, of Leicester, esq 0
3604403 1869044 1869044 plaintiff Gouleson John yeoman 586435 586435 Gouleson, John, of Leicester, yeoman 0
3604404 1869044 1869044 defendant Roberdys John esq 586435 586435 Roberdys, John, of Leicester, esq 0
3604405 1869045 1869045 plaintiff Gouleson John yeoman 586435 586435 Gouleson, John, of Leicester, yeoman 0
3604406 1869045 1869045 defendant Roberdys John esq 586435 586435 Roberdys, John, of Leicester, esq 0
3606281 1869633 1869633 plaintiff Mome Robert clerk 586435 586435 Mome, Robert, of Leicester, clerk 0
3606282 1869633 1869633 plaintiff Barbour alias Dyotson Walter clerk 586435 586435 Barbour alias Dyotson, Walter, of Leicester, clerk 1
3606283 1869633 1869633 defendant Robertes John, senior draper 586435 586435 Robertes, John, senior, of Leicester, draper 0
3607032 1869865 1869865 defendant Tomson Hugh barker 586435 586435 Tomson, Hugh, of Leicester, barker 0
3607033 1869865 1869865 defendant Stacy Richard yeoman 586435 586435 Stacy, Richard, of Leicester, yeoman 1
3607035 1869866 1869866 defendant Tomson Hugh barker 586435 586435 Tomson, Hugh, of Leicester, barker 0
3607036 1869866 1869866 defendant Stacy Richard yeoman 586435 586435 Stacy, Richard, of Leicester, yeoman 1
3607604 1870036 1870036 defendant Hayward William shoemaker 586435 586435 Hayward, William, of Leicester, shoemaker 0
3607997 1870154 1870154 defendant May John innholder 586435 586435 May, John, of Leicester, innholder 0
3607999 1870155 1870155 defendant May John innholder 586435 586435 May, John, of Leicester, innholder 0
3608752 1870401 1870401 defendant Gunson or Emison John yeoman 586435 586435 Gunson or Emison, John, of Leicester, yeoman 0
3609109 1870507 1870507 defendant Thompson Nicholas dyer 586435 586435 Thompson, Nicholas, of Leicester, dyer 0
3609408 1870604 1870604 defendant Lemyngton John merchant of the staple 586435 586435 Lemyngton, John, of Leicester, merchant of the staple 0
3614035 1872049 1872049 defendant Stephynson Robert shoemaker 586435 586435 Stephynson, Robert, of Leicester, shoemaker 1
3614377 1872146 1872146 defendant Mole William shoemaker 586435 586435 Mole, William, of Leicester, shoemaker 2
3614385 1872147 1872147 defendant Mole William shoemaker 586435 586435 Mole, William, of Leicester, shoemaker 3
3614386 1872147 1872147 defendant Bell Robert hatter 586435 586435 Bell, Robert, of Leicester, hatter 4
3615106 1872370 1872370 defendant George Thomas yeoman 586435 586435 George, Thomas, of Leicester, yeoman 0
3615107 1872370 1872370 defendant Esterton John sherman 586435 586435 Esterton, John, of Leicester, sherman 1
3615108 1872370 1872370 defendant Davy Thomas mercer 586435 586435 Davy, Thomas, of Leicester, mercer 2
3615109 1872370 1872370 defendant Caswell Thomas mercer 586435 586435 Caswell, Thomas, of Leicester, mercer 3
3615110 1872370 1872370 defendant Lyon Bartholomew ironmonger 586435 586435 Lyon, Bartholomew, of Leicester, ironmonger 4
3617862 1873210 1873210 plaintiff George Thomas   586435 586435 George, Thomas, of Leicester 0
3618775 1873488 1873488 defendant Hugh Charles tailor 586435 586435 Hugh, Charles, of Leicester, tailor 1
3619612 1873703 1873703 defendant Selby John yeoman 586435 586435 Selby, John, of Leicester, yeoman 2
3619695 1873730 1873730 defendant Blount Charles vintner 586435 586435 Blount, Charles, of Leicester, vintner 1
3619700 1873731 1873731 defendant Blount Charles vintner 586435 586435 Blount, Charles, of Leicester, vintner 2
3622235 1874489 1874489 defendant Couper William laborer 586435 586435 Couper, William, of Leicester, laborer 0
3622609 1874602 1874602 defendant Lisle Walter gent 586435 586435 Lisle, Walter, of Leicester, gent 0
3622610 1874602 1874602 defendant Peny John (legal representative) 586435 586435 Peny, John, of Leicester, card maker, executors of 1
3622611 1874602 1874602 defendant Gillotte Richard merchant 586435 586435 (Gillotte, Richard, of Leicester, merchant 2
3622612 1874602 1874602 defendant Michell William fishmonger 586435 586435 Michell, William, of Leicester, fishmonger 3
3622613 1874602 1874602 defendant Lyon Bartholomew ironmonger 586435 586435 Lyon, Bartholomew, of Leicester, ironmonger 4
3622614 1874602 1874602 defendant Keyle Robert (legal representative) 586435 586435 Keyle, Robert, of Leicester, fishmonger, executors of 5
3622615 1874602 1874602 defendant Nores John barker 586435 586435 (Nores, John, of Leicester, barker 6
3622616 1874602 1874602 defendant Keyle John fishmonger 586435 586435 Keyle, John, of Leicester, fishmonger 7
3623507 1874881 1874881 defendant george Thomas yeoman 586435 586435 george, Thomas, of Leicester, yeoman 5
3624864 1875310 1875310 defendant Barton John yeoman 586435 586435 Barton, John, of Leicester, yeoman 3
3625346 1875467 1875467 plaintiff Whitwell John (legal representative) 586435 586435 Whitwell, John, of Leicester, executor of 0
3628129 1903654 1903654 plaintiff Burton Thomas mercer 586435 586435 Burton, Thomas, of Leicester, mercer 0
3628577 1903810 1903810 defendant Power William butcher 586435 586435 Power, William, of Leicester, butcher 2
3630490 1904368 1904368 plaintiff Eyre Richard gent 586435 586435 Eyre, Richard, of Leicester, gent 0
3635281 1905826 1905826 defendant Gybson William tailor 586435 586435 Gybson, William, of Leicester, tailor 0
3635824 1906005 1906005 plaintiff Plant William   586435 586435 Plant, William, of Leicester 0
3640191 1907374 1907374 defendant Orton Robert gent 586435 586435 Orton, Robert, of Leicester, gent 2
3640259 1907388 1907388 defendant Gillot William chapman 586435 586435 Gillot, William, of Leicester, chapman 1
3642767 1908187 1908187 defendant Whatton alias Lokyer John ironmonger 586435 586435 Whatton alias Lokyer, John, of Leicester, ironmonger 0
3643972 1908546 1908546 defendant Marshall Robert clerk 586435 586435 Marshall, Robert, of Leicester, clerk 0
3643974 1908547 1908547 defendant Marshall Robert clerk 586435 586435 Marshall, Robert, of Leicester, clerk 0
3644336 1908648 1908648 defendant Beaumond Thomas gent 586435 586435 Beaumond, Thomas, of Leicester, gent 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);