names

451 rows where place_id = 588037

✎ 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
3593162 1865491 1865491 defendant Hill Thomas cordwainer 588037 588037 Hill, Thomas, of Lichefeld, cordwainer 0
3593163 1865491 1865491 defendant Goldsmyth John goldsmith 588037 588037 Goldsmyth, John, of Lichefeld, goldsmith 1
3601287 1868068 1868068 defendant Kirkeby Henry walker 588037 588037 Kirkeby, Henry, of Lichefeld, walker 0
3602196 1868353 1868353 plaintiff Broun Robert merchant 588037 588037 Broun, Robert, of Lichefeld, merchant 0
3607447 1869987 1869987 defendant Wherret Alice widow 588037 588037 Wherret, Alice, of Lichefeld, widow 0
3608011 1870159 1870159 defendant Mogge William butcher 588037 588037 Mogge, William, of Lichefeld, butcher 0
3610879 1871074 1871074 defendant Hethe John weaver 588037 588037 Hethe, John, of Lichefeld, weaver 0
3618987 1873551 1873551 plaintiff Hill Richard hewster 588037 588037 Hill, Richard, of Lichefeld, hewster 0
3623936 1875016 1875016 defendant Syrell William laborer 588037 588037 Syrell, William, of Lichefeld, laborer 0
3629317 1904028 1904028 plaintiff Cowper Richard cutler 588037 588037 Cowper, Richard, of Lichefeld, Saddeler Strete, cutler 0
3629949 1904223 1904223 defendant Gerard Henry gent 588037 588037 Gerard, Henry, of Lichefeld, gent 1
3629950 1904223 1904223 defendant Wirall John butcher 588037 588037 Wirall, John, of Lichefeld, butcher 2
3629951 1904223 1904223 defendant Luter Walter tailor 588037 588037 Luter, Walter, of Lichefeld, tailor 3
3629952 1904223 1904223 defendant Pryket Hugh courser 588037 588037 Pryket, Hugh, of Lichefeld, courser 4
3629953 1904223 1904223 defendant Clerk William vintner 588037 588037 Clerk, William, of Lichefeld, vintner 5
3629954 1904223 1904223 defendant Wicam Thomas miller 588037 588037 Wicam, Thomas, of Lichefeld, miller 6
3629955 1904223 1904223 defendant Tatton Ralph yeoman 588037 588037 Tatton, Ralph, of Lichefeld, yeoman 7
3631827 1904761 1904761 defendant Clerk William yeoman 588037 588037 Clerk, William, of Lichefeld, yeoman 0
3632909 1905109 1905109 defendant Wodward Robert tailor 588037 588037 Wodward, Robert, of Lichefeld, tailor 0
3632910 1905109 1905109 defendant Byrde Thomas baker 588037 588037 Byrde, Thomas, of Lichefeld, baker 1
3633473 1905282 1905282 defendant Kyrke William mercer 588037 588037 Kyrke, William, of Lichefeld, mercer 1
3633474 1905282 1905282 defendant Turner Richard mercer 588037 588037 Turner, Richard, of Lichefeld, mercer 2
3635030 1905755 1905755 defendant Wycam Thomas sherman 588037 588037 Wycam, Thomas, of Lichefeld, sherman 0
3643266 1908318 1908318 defendant Clerke William chapman 588037 588037 Clerke, William, of Lichefeld, chapman 0
3647676 1909663 1909663 defendant Turner John husbandman 588037 588037 Turner, John, of Lichefeld, husbandman 1
3652301 1911059 1911059 defendant Watson Thomas draper 588037 588037 Watson, Thomas, of Lichefeld, draper 0
3671383 1917027 1917027 defendant Towres John cordwainer 588037 588037 Towres, John, of Lichefeld, cordwainer 0
3673492 1917735 1917735 plaintiff Fauxe Thomas (legal representative) 588037 588037 Fauxe, Thomas, of Lichefeld, administrator of 0
3673494 1917735 1917735 defendant Bowode Hugh dyer 588037 588037 Bowode, Hugh, of Lichefeld, dyer 0
3673495 1917735 1917735 defendant Knyght Joan widow 588037 588037 Knyght, Joan, of Lichefeld, widow 1
3675186 1918271 1918271 defendant Astley John capper 588037 588037 Astley, John, of Lichefeld, capper 1
3675950 1918515 1918515 defendant Ley Roger draper 588037 588037 Ley, Roger, of Lichefeld, draper 0
3677062 1918865 1918865 defendant Asteley John capper 588037 588037 Asteley, John, of Lichefeld, capper 0
3678895 1919468 1919468 defendant Craples Robert innholder 588037 588037 Craples, Robert, of Lichefeld, innholder 0
3678897 1919468 1919468 defendant Gybson Alice widow 588037 588037 Gybson, Alice, of Lichefeld, widow 2
3683226 1920873 1920873 defendant Puylson William cordwainer 588037 588037 Puylson, William, of Lichefeld, cordwainer 0
3683295 1920898 1920898 defendant Hychecok Richard husbandman 588037 588037 Hychecok, Richard, of Lichefeld, husbandman 0
3685664 1921673 1921673 defendant Cantrell Richard clerk 588037 588037 Cantrell, Richard, of Lichefeld, clerk 0
3689261 1922802 1922802 defendant Wycam Thomas yeoman 588037 588037 Wycam, Thomas, of Lichefeld, yeoman 1
3689827 1922976 1922976 defendant Turnor William   588037 588037 Turnor, William, of Lichefeld, surgeon 1
3691843 1923609 1923609 defendant Swynscoo William   588037 588037 Swynscoo, William, of Lichefeld, mason 0
3710700 1929667 1929667 defendant Shelley William yeoman 588037 588037 Shelley, William, of Lichefeld, yeoman 0
3730406 1935742 1935742 defendant Asteley John capper 588037 588037 Asteley, John, of Lichefeld, capper 0
3730407 1935742 1935742 defendant Asteley Thomas capper 588037 588037 Asteley, Thomas, of Lichefeld, capper 1
3744319 1940121 1940121 defendant Grene William innholder 588037 588037 Grene, William, of Lichefeld, innholder 0
3747899 1941265 1941265 defendant Walkelate Richard butcher 588037 588037 Walkelate, Richard, of Lichefeld, butcher 4
3775754 1950168 1950168 defendant Deyne Thomas capper 588037 588037 Deyne, Thomas, of Lichefeld, capper 0
3776518 1950409 1950409 plaintiff Burton Robert   588037 588037 Burton, Robert, of Lichefeld, notary 0
3807233 1960159 1960159 defendant Jurdan Robert capper 588037 588037 Jurdan, Robert, of Lichefeld, capper 1
3839380 1970240 1970240 plaintiff Weston John   588037 588037 Weston, John, of Lichefeld 3
3852143 1974268 1974268 defendant Stonynoughe William draper 588037 588037 Stonynoughe, William, of Lichefeld, draper 0
3877603 1982748 1982748 defendant Clerke William mercer 588037 588037 Clerke, William, of Lichefeld, mercer 0
3901078 1990586 1990586 defendant Alkyns Thomas mercer 588037 588037 Alkyns, Thomas, of Lichefeld, mercer 0
3908182 1993034 1993034 defendant Chapman William baker 588037 588037 Chapman, William, of Lichefeld, baker 0
3919536 1996866 1996866 defendant Gladwyn John carpenter 588037 588037 Gladwyn, John,of Lichefeld, carpenter 0
3925994 1999014 1999014 defendant Byrde Henry baker 588037 588037 Byrde, Henry, of Lichefeld, baker 0
3947712 2006262 2006262 plaintiff Colyns George goldsmith 588037 588037 Colyns, George, of Lichefeld, goldsmith 0
3954396 2008607 2008607 defendant Fecknam alias Fulke alias Whealer John innholder 588037 588037 Fecknam alias Fulke alias Whealer, John, of Lichefeld, innholder 0
3954397 2008607 2008607 defendant Hancocke Edward innholder 588037 588037 Hancocke, Edward, of Lichefeld, innholder 1
3954398 2008607 2008607 defendant Crycheley James innholder 588037 588037 Crycheley, James, of Lichefeld, innholder 2
3954399 2008607 2008607 defendant Hamersley William innholder 588037 588037 Hamersley, William, of Lichefeld, innholder 3
3998381 2024161 2024161 plaintiff Fecknam John innholder 588037 588037 Fecknam, John, of Lichefeld, innholder 0
4025894 2033912 2033912 plaintiff Buckfeld Richard   588037 588037 Buckfeld, Richard, of Lichefeld 0
4042393 2039760 2039760 plaintiff Parkyns or Parken Roger tanner 588037 588037 Parkyns or Parken, Roger, of Lichefeld, tanner 0
4065015 2047770 2047770 defendant Bickley Thomas   588037 588037 Bickley, Thomas, of Lichefeld, clerk, prebendary of Alderwas in Lichefeld Cathedral 0
4415005 2169589 2169589 defendant Saundersone Henry   588037 588037 Saundersone, Henry, of Lichefeld 0
4416746 2170105 2170105 plaintiff Oundele Roger   588037 588037 Oundele, Roger, of Lichefeld 0
4416748 2170105 2170105 defendant Blechebury Henry de   588037 588037 Blechebury, Henry de, of Lichefeld 0
4420558 2171331 2171331 plaintiff Burton Robert de   588037 588037 Burton, Robert de, of Lichefeld 0
4422965 2172039 2172039 plaintiff Foy John   588037 588037 Foy, John, of Lichefeld 0
4422966 2172039 2172039 defendant Norton Henry de tailor 588037 588037 Norton, Henry de, of Lichefeld, tailor 0
4426429 2173076 2173076 defendant Blythebury Henry de   588037 588037 Blythebury, Henry de, of Lichefeld 0
4438494 2181327 2181327 plaintiff Assheburn John de   588037 588037 Assheburn, John de, of Lichefeld 0
4438498 2181328 2181328 plaintiff Assheburn John de   588037 588037 Assheburn, John de, of Lichefeld 0
4440369 2181901 2181901 plaintiff Bellyetere Roger le   588037 588037 Bellyetere, Roger le, of Lichefeld 0
4447190 2184027 2184027 plaintiff Dunham John de   588037 588037 Dunham, John de, of Lichefeld 0
4453774 2186188 2186188 defendant Ferrour William le   588037 588037 Ferrour, William le, of Lichefeld 0
4453805 2186199 2186199 defendant Botoun John   588037 588037 Botoun, John, of Lichefeld 0
4453809 2186200 2186200 defendant Boton John   588037 588037 Boton, John, of Lichefeld 0
4455764 2186819 2186819 defendant Ferrour John le   588037 588037 Ferrour, John le, of Lichefeld, son of William 0
4461100 2188550 2188550 plaintiff Spicer Adam le   588037 588037 Spicer, Adam le, of Lichefeld 0
4461106 2188550 2188550 defendant Sadeler William celer 588037 588037 Sadeler, William, of Lichefeld, celer 5
4461233 2188598 2188598 plaintiff St John John   588037 588037 St John, John, of Lichefeld 0
4461237 2188599 2188599 plaintiff St John John   588037 588037 St John, John, of Lichefeld 0
4461238 2188599 2188599 defendant Heywode John smith 588037 588037 Heywode, John, of Lichefeld, smith 0
4461239 2188600 2188600 plaintiff St Jones John   588037 588037 St Jones, John, of Lichefeld 0
4470133 2191313 2191313 plaintiff Bredda William chapman 588037 588037 Bredda, William, of Lichefeld, chapman 0
4470534 2191431 2191431 plaintiff Broun William clerk 588037 588037 Broun, William, of Lichefeld, clerk 0
4470625 2191460 2191460 plaintiff Bryd Richard mercer 588037 588037 Bryd, Richard, of Lichefeld, mercer 0
4471540 2191761 2191761 plaintiff Wysse Thomas   588037 588037 Wysse, Thomas, of Lichefeld 2
4472619 2192106 2192106 defendant Mulward John   588037 588037 Mulward, John, of Lichefeld 0
4474676 2192743 2192743 defendant Spicer John   588037 588037 Spicer, John, of Lichefeld 1
4475692 2193076 2193076 plaintiff Ferrour Isabel   588037 588037 Ferrour, Isabel, of Lichefeld 0
4475693 2193076 2193076 defendant Shether John   588037 588037 Shether, John, of Lichefeld 0
4478574 2193965 2193965 plaintiff Heuster Robert   588037 588037 Heuster, Robert, of Lichefeld 0
4479207 2194151 2194151 plaintiff Hubert Thomas   588037 588037 Hubert, Thomas, of Lichefeld, on his own account 0
4480315 2194507 2194507 defendant Preston William de   588037 588037 Preston, William de, of Lichefeld 0
4483347 2195490 2195490 defendant agge Lake Robert   588037 588037 agge Lake, Robert, of Lichefeld 10
4483367 2195493 2195493 defendant atte Lake Robert   588037 588037 atte Lake, Robert, of Lichefeld 9
4483394 2195496 2195496 defendant atte Lake Robert   588037 588037 atte Lake, Robert, of Lichefeld 9

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