names

757 rows where place_id = 587516

✎ 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
3591636 1865003 1865003 defendant Hunt John yeoman 587516 587516 Hunt, John, of Stafford, yeoman 0
3591637 1865003 1865003 defendant Rydware Richard roper 587516 587516 Rydware, Richard, of Stafford, roper 1
3591638 1865003 1865003 defendant Joyse John gent 587516 587516 Joyse, John, of Stafford, gent 2
3591639 1865003 1865003 defendant Empson William   587516 587516 Empson, William, of Stafford, cartwright 3
3591640 1865003 1865003 defendant Wratton Richard barker 587516 587516 Wratton, Richard, of Stafford, barker 4
3596114 1866413 1866413 defendant Gillot John barber 587516 587516 Gillot, John, of Stafford, barber 0
3598543 1867170 1867170 defendant Botery Roger tanner 587516 587516 Botery, Roger, of Stafford, tanner 0
3603035 1868617 1868617 defendant Swyneshed Robert gent 587516 587516 Swyneshed, Robert, of Stafford, gent 0
3603479 1868754 1868754 defendant Bromley John draper 587516 587516 Bromley, John, of Stafford, draper 0
3608009 1870158 1870158 defendant Colwich William, junior gent 587516 587516 Colwich, William, junior, of Stafford, gent 1
3613319 1871815 1871815 plaintiff Weston John yeoman 587516 587516 Weston, John, of Stafford, yeoman 1
3613322 1871816 1871816 plaintiff Weston John yeoman 587516 587516 Weston, John, of Stafford, yeoman 1
3617912 1873226 1873226 defendant Robynson Thomas cordwainer 587516 587516 Robynson, Thomas, of Stafford, cordwainer 0
3624385 1875160 1875160 defendant Buglyn Richard yeoman 587516 587516 Buglyn, Richard, of Stafford, yeoman 0
3624386 1875160 1875160 defendant Grene Ralph yeoman 587516 587516 Grene, Ralph, of Stafford, yeoman 1
3624850 1875307 1875307 defendant Narbury Johnm vintner 587516 587516 Narbury, Johnm, of Stafford, vintner 2
3630821 1904461 1904461 defendant Bromley Thomas butcher 587516 587516 Bromley, Thomas, of Stafford, butcher 2
3648976 1910068 1910068 defendant Laundour Robert yeoman 587516 587516 Laundour, Robert, of Stafford, yeoman 0
3662276 1914116 1914116 defendant Thyknes Ralph gent 587516 587516 Thyknes, Ralph, of Stafford, gent 0
3662277 1914117 1914117 plaintiff (not given) John prior of Massingham 587516 587516 Massingham, John, of Stafford, prior of the Monastery of St Thomas the martyr 0
3662414 1914157 1914157 plaintiff (not given) John prior of Messyngham 587516 587516 Messyngham, John, of Stafford, prior of the monastery of St Thomas 0
3662417 1914158 1914158 plaintiff (not given) John prior of Mesyngham 587516 587516 Mesyngham, John, of Stafford, prior of the Monastery of St Thomas near Stafford 0
3662420 1914159 1914159 plaintiff (not given) John prior of Mesyngham 587516 587516 Mesyngham, John, of Stafford, prior of the monastery of St Thomas the martyr 0
3662423 1914160 1914160 plaintiff (not given) Thomas prior of Mesyngham 587516 587516 Mesyngham, Thomas, of Stafford, prior of the Monastery of St Thomas the martyr 0
3665163 1915058 1915058 defendant Offeley William yeoman 587516 587516 Offeley, William, of Stafford, yeoman 0
3665165 1915058 1915058 defendant Starde Margaret widow 587516 587516 Starde, Margaret, of Stafford, widow 2
3665513 1915165 1915165 plaintiff Stanley John   587516 587516 Stanley, John, of Stafford 0
3665515 1915166 1915166 plaintiff Stanley John   587516 587516 Stanley, John, of Stafford 0
3666764 1915550 1915550 defendant Dilron John yeoman 587516 587516 Dilron, John, of Stafford, yeoman 0
3666769 1915551 1915551 defendant Dylron John yeoman 587516 587516 Dylron, John, of Stafford, yeoman 0
3667542 1915789 1915789 plaintiff Wrottesly Richard esq & sheriff 587516 587516 Wrottesly, Richard, of Stafford, esq & sheriff 0
3668906 1916208 1916208 plaintiff Barbor Robert   587516 587516 Barbor, Robert, of Stafford 0
3673030 1917573 1917573 defendant Boughey Hugh yeoman 587516 587516 Boughey, Hugh, of Stafford, yeoman 0
3675858 1918486 1918486 defendant Yttell John dyer 587516 587516 Yttell, John, of Stafford, dyer 0
3677723 1919080 1919080 defendant Dylron John yeoman 587516 587516 Dylron, John, of Stafford, yeoman 0
3678075 1919188 1919188 defendant Thyknes Ralph gent 587516 587516 Thyknes, Ralph, of Stafford, gent 0
3678248 1919252 1919252 defendant Brodhed Humphrey yeoman 587516 587516 Brodhed, Humphrey, of Stafford, yeoman 0
3678249 1919252 1919252 defendant Eyndman Philip   587516 587516 Eyndman, Philip, of Stafford, hat maker 1
3678250 1919252 1919252 defendant Unton Richard yeoman 587516 587516 Unton, Richard, of Stafford, yeoman 2
3683748 1921050 1921050 defendant Crompton Ovet butcher 587516 587516 Crompton, Ovet, of Stafford, butcher 0
3684053 1921146 1921146 defendant Noble Hugh   587516 587516 Noble, Hugh, of Stafford, gent, administrators of 0
3684054 1921146 1921146 defendant Mercer Roland gent 587516 587516 (Mercer, Roland, of Stafford, gent 1
3686449 1921916 1921916 defendant Securston Thomas butcher 587516 587516 Securston, Thomas, of Stafford, butcher 1
3686451 1921916 1921916 defendant Marsshall William butcher 587516 587516 Marsshall, William, of Stafford, butcher 3
3688169 1922450 1922450 defendant Grotton Margery widow 587516 587516 Grotton, Margery, of Stafford, widow 2
3688182 1922453 1922453 defendant Peyke Richard innholder 587516 587516 Peyke, Richard, of Stafford, innholder 0
3688183 1922453 1922453 defendant Fernyall Richard draper 587516 587516 Fernyall, Richard, of Stafford, draper 1
3688185 1922453 1922453 defendant Haryson William husbandman 587516 587516 Haryson, William, of Stafford, husbandman 3
3688626 1922600 1922600 defendant Shelley William upholsterer 587516 587516 Shelley, William, of Stafford, upholsterer 0
3693017 1924020 1924020 plaintiff Leyse Robert tanner 587516 587516 Leyse, Robert, of Stafford, tanner 0
3693884 1924291 1924291 defendant Mason William glover 587516 587516 Mason, William, of Stafford, glover 0
3710702 1929667 1929667 defendant Cotton Henry yeoman 587516 587516 Cotton, Henry, of Stafford, yeoman 2
3711784 1930002 1930002 defendant Sekarston Thomas butcher 587516 587516 Sekarston, Thomas, of Stafford, butcher 0
3711785 1930002 1930002 defendant Jurden Richard barber 587516 587516 Jurden, Richard, of Stafford, barber 1
3716772 1931536 1931536 defendant Doryngton Agnes widow 587516 587516 Doryngton, Agnes, of Stafford, widow 4
3719605 1932397 1932397 defendant Hunt George butcher 587516 587516 Hunt, George, of Stafford, butcher 0
3725009 1934107 1934107 plaintiff Shelley William   587516 587516 Shelley, William, of Stafford 0
3725011 1934107 1934107 plaintiff Mason William   587516 587516 Mason, William, of Stafford 2
3746049 1940668 1940668 defendant Cradooke William clerk 587516 587516 Cradooke, William, of Stafford, clerk 1
3748394 1941429 1941429 defendant Patrik Thomas butcher 587516 587516 Patrik, Thomas, of Stafford, butcher 0
3748754 1941542 1941542 defendant Compton Juett butcher 587516 587516 Compton, Juett, of Stafford, butcher 0
3757526 1944329 1944329 defendant Offeley William chapman 587516 587516 Offeley, William, of Stafford, chapman 0
3764728 1946632 1946632 defendant Sagurston Thomas butcher 587516 587516 Sagurston, Thomas, of Stafford, butcher 0
3772527 1949098 1949098 defendant Crumpton Inet or Juet butcher 587516 587516 Crumpton, Inet or Juet, of Stafford, butcher 0
3776773 1950481 1950481 defendant Jordan Richard barber 587516 587516 Jordan, Richard, of Stafford, barber 1
3780876 1951753 1951753 defendant Clere John (legal representative) 587516 587516 Clere, John, of Stafford, mercer, executors of 0
3781140 1951837 1951837 defendant Masse John clothmaker 587516 587516 Masse, John, of Stafford, clothmaker 0
3783815 1952708 1952708 plaintiff Lese Robert   587516 587516 Lese, Robert, of Stafford 0
3783818 1952708 1952708 defendant Chedylton John cordwainer 587516 587516 Chedylton, John, of Stafford, cordwainer 2
3783819 1952708 1952708 defendant Coke William cordwainer 587516 587516 Coke, William, of Stafford, cordwainer 3
3784680 1952996 1952996 defendant Styche Humphrey butcher 587516 587516 Styche, Humphrey, of Stafford, butcher 1
3784681 1952996 1952996 defendant Coton Henry yeoman 587516 587516 Coton, Henry, of Stafford, yeoman 2
3785230 1953164 1953164 defendant Maste John dyer 587516 587516 Maste, John, of Stafford, dyer 0
3790313 1954788 1954788 defendant Whitmore John capper 587516 587516 Whitmore, John, of Stafford, capper 2
3793116 1955708 1955708 plaintiff Bokeley Thomas capper 587516 587516 Bokeley, Thomas, of Stafford, capper 0
3793386 1955792 1955792 defendant Doryngton John draper 587516 587516 Doryngton, John, of Stafford, draper 4
3797023 1956947 1956947 defendant Doryngton John mercer 587516 587516 Doryngton, John, of Stafford, mercer 0
3804933 1959487 1959487 defendant Redman John clerk 587516 587516 Redman, John, of Stafford, clerk 0
3804934 1959487 1959487 defendant Gybbons Richard laborer 587516 587516 Gybbons, Richard, of Stafford, laborer 1
3804935 1959487 1959487 defendant Neelson John spurrier 587516 587516 Neelson, John, of Stafford, spurrier 2
3806453 1959931 1959931 defendant Whitmore John capper 587516 587516 Whitmore, John, of Stafford, capper 3
3812603 1961828 1961828 defendant Bramley John capper 587516 587516 Bramley, John, of Stafford, capper 3
3820357 1964246 1964246 defendant Blyht Nicholas shoemaker 587516 587516 Blyht, Nicholas, of Stafford, shoemaker 0
3822111 1964809 1964809 defendant Bromley Thomas capper 587516 587516 Bromley, Thomas, of Stafford, capper 0
3822738 1965012 1965012 defendant Homersley Richard draper 587516 587516 Homersley, Richard, of Stafford, draper 0
3822739 1965012 1965012 defendant Savage Henry tailor 587516 587516 Savage, Henry, of Stafford, tailor 1
3825490 1965822 1965822 defendant Wether Margery widow 587516 587516 Wether, Margery, of Stafford, widow 0
3825600 1965857 1965857 defendant Patryk Thomas butcher 587516 587516 Patryk, Thomas, of Stafford, butcher 0
3829279 1967041 1967041 defendant Bold Edward capper 587516 587516 Bold, Edward, of Stafford, capper 1
3829280 1967041 1967041 defendant Peke Richard weaver 587516 587516 Peke, Richard, of Stafford, weaver 2
3837472 1969624 1969624 defendant Mason William yeoman 587516 587516 Mason, William, of Stafford, yeoman 0
3837473 1969624 1969624 defendant Brett William dyer 587516 587516 Brett, William, of Stafford, dyer 1
3837887 1969763 1969763 defendant Daryngton John   587516 587516 Daryngton, John, of Stafford, draper, son of Daryngton, Robert 0
3838741 1970045 1970045 defendant Coton Henry yeoman 587516 587516 Coton, Henry, of Stafford, yeoman 0
3841980 1971051 1971051 defendant Pick Thomas gent 587516 587516 Pick, Thomas, of Stafford, gent 3
3845618 1972171 1972171 defendant Dex Thomas capper 587516 587516 Dex, Thomas, of Stafford, capper 3
3848589 1973141 1973141 defendant Harnolde Thomas   587516 587516 Harnolde, Thomas, of Stafford, hat maker 0
3850736 1973822 1973822 defendant Ithell John dyer 587516 587516 Ithell, John, of Stafford, dyer 0
3850737 1973822 1973822 defendant Horne William husbandman 587516 587516 Horne, William, of Stafford, husbandman 1
3850743 1973824 1973824 defendant Ithell John dyer 587516 587516 Ithell, John, of Stafford, dyer 0

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