names

476 rows where place_id = 587826

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592544 1865284 1865284 defendant Middelton John draper 587826 587826 Middelton, John, of Lychefeld, draper 0
3593133 1865478 1865478 defendant Wheret Richard shoemaker 587826 587826 Wheret, Richard, of Lychefeld, shoemaker 0
3594415 1865889 1865889 defendant Broun Richard baker 587826 587826 Broun, Richard, of Lychefeld, baker 3
3605308 1869325 1869325 plaintiff Hyde John (legal representative) 587826 587826 Hyde, John, of Lychefeld, executors of 0
3614731 1872255 1872255 defendant Broun Richard yeoman of the crown 587826 587826 Broun, Richard, of Lychefeld, gent, innholder, yeoman of the crown 0
3617383 1873055 1873055 defendant Bell Henry yeoman 587826 587826 Bell, Henry, of Lychefeld, yeoman 3
3618988 1873551 1873551 defendant Atton or Acton Tomas dyer 587826 587826 Atton or Acton, Tomas, of Lychefeld, dyer 0
3618989 1873551 1873551 defendant Walker Mathew walker 587826 587826 Walker, Mathew, of Lychefeld, walker 1
3618990 1873551 1873551 defendant Warton Peter walker 587826 587826 Warton, Peter, of Lychefeld, walker 2
3627305 1903389 1903389 defendant Fryth Richard gent 587826 587826 Fryth, Richard, of Lychefeld, gent 0
3636939 1906348 1906348 defendant Egerton Richard   587826 587826 Egerton, Richard, of Lychefeld, clerk, resident canon, Lichfeld Cathedral 0
3637860 1906658 1906658 defendant Lyke William yeoman 587826 587826 Lyke, William, of Lychefeld, yeoman 0
3640672 1907524 1907524 plaintiff Atkyns Robert   587826 587826 Atkyns, Robert, of Lychefeld 0
3641101 1907661 1907661 defendant Mogge Thomas butcher 587826 587826 Mogge, Thomas, of Lychefeld, butcher 1
3642663 1908150 1908150 defendant Spencer William tiler 587826 587826 Spencer, William, of Lychefeld, tiler 0
3647677 1909663 1909663 defendant Holland Hugh laborer 587826 587826 Holland, Hugh, of Lychefeld, laborer 2
3648768 1910002 1910002 defendant Swynsto William   587826 587826 (Swynsto, William, of Lychefeld, mason 1
3650168 1910422 1910422 defendant Turner John yeoman 587826 587826 Turner, John, of Lychefeld, yeoman 1
3650169 1910422 1910422 defendant Sherrard John laborer 587826 587826 Sherrard, John, of Lychefeld, laborer 2
3650170 1910422 1910422 defendant Turner John laborer 587826 587826 Turner, John, of Lychefeld, laborer 3
3658677 1912969 1912969 defendant Sprotte Thomas gent 587826 587826 Sprotte, Thomas, of Lychefeld, gent 1
3661031 1913725 1913725 defendant Hopwode George clerk 587826 587826 Hopwode, George, of Lychefeld, clerk 0
3665477 1915154 1915154 defendant Gladwyn Peter carpenter 587826 587826 Gladwyn, Peter, of Lychefeld, carpenter 1
3671342 1917013 1917013 defendant Puylson William cordwainer 587826 587826 Puylson, William, of Lychefeld, cordwainer 0
3671343 1917013 1917013 defendant Banaster Robert cordwainer 587826 587826 Banaster, Robert, of Lychefeld, cordwainer 1
3671345 1917013 1917013 defendant Geslyng James laborer 587826 587826 Geslyng, James, of Lychefeld, laborer 3
3671431 1917044 1917044 defendant Vardon Richard pewterer 587826 587826 Vardon, Richard, of Lychefeld, pewterer 0
3672166 1917293 1917293 defendant Marten Henry husbandman 587826 587826 Marten, Henry, of Lychefeld, husbandman 0
3673999 1917907 1917907 defendant Recheford Thomas mercer 587826 587826 Recheford, Thomas, of Lychefeld, mercer 0
3675196 1918274 1918274 defendant Edmondson Edward gent 587826 587826 Edmondson, Edward, of Lychefeld, gent 0
3675197 1918274 1918274 defendant Ball John yeoman 587826 587826 Ball, John, of Lychefeld, yeoman 1
3676685 1918747 1918747 defendant Kelyng John yeoman 587826 587826 Kelyng, John, of Lychefeld, yeoman 0
3682933 1920774 1920774 defendant Hardyng John capper 587826 587826 Hardyng, John, of Lychefeld, capper 0
3683420 1920938 1920938 defendant Johnson John glover 587826 587826 Johnson, John, of Lychefeld, glover 0
3689168 1922777 1922777 defendant Turner Robert yeoman 587826 587826 Turner, Robert, of Lychefeld, yeoman 0
3689169 1922777 1922777 defendant Fentam John chaplain 587826 587826 Fentam, John, of Lychefeld, chaplain 1
3689170 1922777 1922777 defendant Norton William clerk 587826 587826 Norton, William, of Lychefeld, clerk 2
3689171 1922777 1922777 defendant Smyth William yeoman 587826 587826 Smyth, William, of Lychefeld, yeoman 3
3689262 1922802 1922802 defendant Fygyn John yeoman 587826 587826 Fygyn, John, of Lychefeld, yeoman 2
3701041 1926574 1926574 defendant Heyward Edward miller 587826 587826 Heyward, Edward, of Lychefeld, miller 1
3703943 1927515 1927515 defendant Hart Thomas yeoman 587826 587826 Hart, Thomas, of Lychefeld, yeoman 1
3703944 1927515 1927515 defendant Sweynscoo William   587826 587826 Sweynscoo, William, of Lychefeld, mason 2
3703945 1927515 1927515 defendant Fentam John chaplain 587826 587826 Fentam, John, of Lychefeld, chaplain 3
3707521 1928647 1928647 plaintiff Lytell Edward skinner 587826 587826 Lytell, Edward, of Lychefeld, skinner 0
3707527 1928648 1928648 plaintiff Lytell Edward skinner 587826 587826 Lytell, Edward, of Lychefeld, skinner 0
3716346 1931403 1931403 defendant Hardyng William capper 587826 587826 Hardyng, William, of Lychefeld, capper 0
3716555 1931474 1931474 defendant Hardyng William capper 587826 587826 Hardyng, William, of Lychefeld, capper 0
3720545 1932707 1932707 defendant Heywode Henry corveser 587826 587826 Heywode, Henry, of Lychefeld, corveser 0
3723631 1933664 1933664 defendant Brennryng William capper 587826 587826 Brennryng, William, of Lychefeld, capper 0
3725217 1934173 1934173 defendant Verdon Richard pewterer 587826 587826 Verdon, Richard, of Lychefeld, pewterer 0
3727776 1934957 1934957 defendant Prykett Hugh yeoman 587826 587826 Prykett, Hugh, of Lychefeld, yeoman 2
3727777 1934957 1934957 defendant Strynger John shoemaker 587826 587826 Strynger, John, of Lychefeld, shoemaker 3
3727781 1934958 1934958 defendant Prykett Hugh yeoman 587826 587826 Prykett, Hugh, of Lychefeld, yeoman 2
3727782 1934958 1934958 defendant Strynger John shoemaker 587826 587826 Strynger, John, of Lychefeld, shoemaker 3
3728747 1935230 1935230 defendant Snape John smith 587826 587826 Snape, John, of Lychefeld, smith 0
3730409 1935743 1935743 defendant Asteley John capper 587826 587826 Asteley, John, of Lychefeld, capper 0
3730410 1935743 1935743 defendant Tayllour Thomas sherman 587826 587826 Tayllour, Thomas, of Lychefeld, sherman 1
3732042 1936254 1936254 defendant Marten Richard yeoman 587826 587826 Marten, Richard, of Lychefeld, yeoman 0
3732043 1936254 1936254 defendant Marten Edward gent 587826 587826 Marten, Edward, of Lychefeld, gent 1
3732044 1936254 1936254 defendant Turner Edmund draper 587826 587826 Turner, Edmund, of Lychefeld, draper 2
3732045 1936254 1936254 defendant Myddulton Thomas weaver 587826 587826 Myddulton, Thomas, of Lychefeld, weaver 3
3732046 1936254 1936254 defendant Mogge Thomas butcher 587826 587826 Mogge, Thomas, of Lychefeld, butcher 4
3733066 1936566 1936566 defendant Repyngton Thomas fishmonger 587826 587826 Repyngton, Thomas, of Lychefeld, fishmonger 0
3739440 1938544 1938544 defendant Penyfather Richard mercer 587826 587826 Penyfather, Richard, of Lychefeld, mercer 0
3740222 1938800 1938800 defendant Derbe Edward dyer 587826 587826 Derbe, Edward, of Lychefeld, dyer 0
3747142 1941023 1941023 defendant Repyngton Thomas yeoman 587826 587826 Repyngton, Thomas, of Lychefeld, yeoman 0
3755026 1943520 1943520 defendant Hardyng William capper 587826 587826 Hardyng, William, of Lychefeld, capper 0
3755027 1943520 1943520 defendant Gybson Alice widow 587826 587826 Gybson, Alice, of Lychefeld, widow 1
3759979 1945115 1945115 defendant Dykynson William glover 587826 587826 Dykynson, William, of Lychefeld, glover 5
3761048 1945457 1945457 defendant Pulford Roger yeoman 587826 587826 Pulford, Roger, of Lychefeld, yeoman 0
3761049 1945457 1945457 defendant Pulford John yeoman 587826 587826 Pulford, John, of Lychefeld, yeoman 1
3761050 1945457 1945457 defendant Bowde Thomas yeoman 587826 587826 Bowde, Thomas, of Lychefeld, yeoman 2
3767232 1947391 1947391 plaintiff More William capper 587826 587826 More, William, of Lychefeld, capper 0
3768712 1947861 1947861 defendant Lane Agnes widow 587826 587826 Lane, Agnes, of Lychefeld, widow 1
3769610 1948155 1948155 defendant Wetwode Richard innholder 587826 587826 Wetwode, Richard, of Lychefeld, innholder 0
3769611 1948155 1948155 defendant Kylnes Thomas tailor 587826 587826 Kylnes, Thomas, of Lychefeld, tailor 1
3778335 1950937 1950937 defendant Byrmycham Thomas chapman 587826 587826 Byrmycham, Thomas, of Lychefeld, chapman 1
3778809 1951090 1951090 defendant Austen Robert gent 587826 587826 Austen, Robert, of Lychefeld, gent 0
3778812 1951090 1951090 defendant Stretehey John (legal representative) 587826 587826 Stretehey, John, of Lychefeld, gent, executor of 3
3778813 1951090 1951090 defendant Stretehey Edmund clerk 587826 587826 Stretehey, Edmund, of Lychefeld, clerk 4
3778815 1951091 1951091 defendant Austen Robert gent 587826 587826 Austen, Robert, of Lychefeld, gent 0
3778818 1951091 1951091 defendant Stretehey John (legal representative) 587826 587826 Stretehey, John, of Lychefeld, gent, executor of 3
3778819 1951091 1951091 defendant Stretehey Edmund clerk 587826 587826 Stretehey, Edmund, of Lychefeld, clerk 4
3790483 1954846 1954846 defendant Lane Agnes widow and dyer 587826 587826 Lane, Agnes, of Lychefeld, widow and dyer 0
3793117 1955708 1955708 defendant Hardyng William capper 587826 587826 Hardyng, William, of Lychefeld, capper 0
3796139 1956657 1956657 defendant Shelley William innholder 587826 587826 Shelley, William, of Lychefeld, innholder 0
3796523 1956785 1956785 defendant Skynner John skinner 587826 587826 Skynner, John, of Lychefeld, skinner 1
3802593 1958704 1958704 defendant Penyfather Richard mercer 587826 587826 Penyfather, Richard, of Lychefeld, mercer 1
3807230 1960159 1960159 plaintiff Wigon John (legal representative) 587826 587826 Wigon, John, of Lychefeld, executors of 0
3807362 1960208 1960208 defendant Borderyk John mercer 587826 587826 Borderyk, John, of Lychefeld, mercer 0
3812746 1961880 1961880 defendant Saxson Nicholas yeoman 587826 587826 Saxson, Nicholas, of Lychefeld, yeoman 0
3814082 1962305 1962305 defendant Cristorson William draper 587826 587826 Cristorson, William, of Lychefeld, draper 1
3817625 1963416 1963416 defendant Colyns John mercer 587826 587826 Colyns, John, of Lychefeld, mercer 2
3817626 1963416 1963416 defendant Hill Michael mercer 587826 587826 Hill, Michael, of Lychefeld, mercer 3
3817627 1963416 1963416 defendant Hawkyns Thomas mercer 587826 587826 Hawkyns, Thomas, of Lychefeld, mercer 4
3818181 1963600 1963600 plaintiff Lyttle Robert   587826 587826 Lyttle, Robert, of Lychefeld 0
3818221 1963613 1963613 defendant Deane Thomas capper 587826 587826 Deane, Thomas, of Lychefeld, capper 0
3818222 1963613 1963613 defendant Shyft Richard yeoman 587826 587826 Shyft, Richard, of Lychefeld, yeoman 1
3819207 1963892 1963892 defendant Byrde John chaplain 587826 587826 Byrde, John, of Lychefeld, chaplain 0
3820002 1964137 1964137 defendant Weston John fishmonger 587826 587826 Weston, John, of Lychefeld, fishmonger 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);