names

286 rows where place_id = 586731

✎ 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
3589481 1864345 1864345 defendant Lyster Thomas gent 586731 586731 Lyster, Thomas, of Wakefeld, Yorks, gent 1
3593028 1865447 1865447 defendant Lyster Thomas gent 586731 586731 Lyster, Thomas, of Wakefeld, Yorks, gent 0
3603739 1868841 1868841 defendant Ratclyff Richard chapman 586731 586731 Ratclyff, Richard, of Wakefeld, Yorks, chapman 0
3604833 1869178 1869178 defendant Radcliffe Otwin chapman 586731 586731 Radcliffe, Otwin, of Wakefeld, Yorks, chapman 2
3605382 1869351 1869351 defendant Crosser Robert dyer 586731 586731 Crosser, Robert, of Wakefeld, Yorks, dyer 0
3606034 1869552 1869552 defendant Lyster Thomas gent 586731 586731 Lyster, Thomas, of Wakefeld, Yorks, gent 0
3609288 1870563 1870563 defendant Lyster Thomas gent 586731 586731 Lyster, Thomas, of Wakefeld, Yorks, gent 3
3629829 1904182 1904182 defendant Sproxston William dyer 586731 586731 Sproxston, William, of Wakefeld, Yorks, dyer 0
3646021 1909151 1909151 defendant Robartys John chapman 586731 586731 Robartys, John, of Wakefeld, Yorks, chapman 0
3647243 1909523 1909523 defendant Greve Robert chapman 586731 586731 Greve, Robert, of Wakefeld, Yorks, chapman 1
3647249 1909525 1909525 defendant Greve Robert chapman 586731 586731 Greve, Robert, of Wakefeld, Yorks, chapman 1
3648982 1910071 1910071 defendant Spryng William dyer 586731 586731 Spryng, William, of Wakefeld, Yorks, dyer 0
3649044 1910091 1910091 defendant Grastok Richard dyer 586731 586731 Grastok, Richard, of Wakefeld, Yorks, dyer 0
3657099 1912484 1912484 defendant Smalpage Thomas dyer 586731 586731 Smalpage, Thomas, of Wakefeld, Yorks, dyer 0
3658658 1912962 1912962 defendant Graystok Robert dyer 586731 586731 Graystok, Robert, of Wakefeld, Yorks, dyer 0
3658661 1912963 1912963 defendant Graystok Robert dyer 586731 586731 Graystok, Robert, of Wakefeld, Yorks, dyer 0
3665095 1915030 1915030 defendant Graystok Richard merchant 586731 586731 Graystok, Richard, of Wakefeld, Yorks, merchant 2
3668061 1915951 1915951 defendant Snaith George esq 586731 586731 Snaith, George, of Wakefeld, Yorks, esq 0
3668063 1915952 1915952 defendant Sugur William yeoman 586731 586731 Sugur, William, of Wakefeld, Yorks, yeoman 0
3669459 1916386 1916386 defendant Robert John mercer 586731 586731 Robert, John, of Wakefeld, Yorks, mercer 0
3669901 1916531 1916531 defendant Tatorsall Thomas chapman 586731 586731 Tatorsall, Thomas, of Wakefeld, Yorks, chapman 3
3672157 1917289 1917289 defendant Grenewoode Robert mercer 586731 586731 Grenewoode, Robert, of Wakefeld, Yorks, mercer 0
3672420 1917375 1917375 defendant Goldsmyth Thomas dyer 586731 586731 Goldsmyth, Thomas, of Wakefeld, Yorks, dyer 0
3673065 1917584 1917584 defendant Oxenfeld Robert clothman 586731 586731 Oxenfeld, Robert, of Wakefeld, Yorks, clothman 4
3678924 1919477 1919477 defendant Robertes John mercer 586731 586731 Robertes, John, of Wakefeld, Yorks, mercer 0
3679207 1919565 1919565 defendant Parker Miles clothmaker 586731 586731 Parker, Miles, of Wakefeld, Yorks, clothmaker 0
3679714 1919723 1919723 defendant Smalpage Thomas clothier 586731 586731 Smalpage, Thomas, of Wakefeld, Yorks, clothier 0
3679929 1919789 1919789 defendant Grastoke Thomas dyer 586731 586731 Grastoke, Thomas, of Wakefeld, Yorks, dyer 0
3679933 1919790 1919790 defendant Grastoke Thomas dyer 586731 586731 Grastoke, Thomas, of Wakefeld, Yorks, dyer 0
3681343 1920253 1920253 defendant Greystok Thomas clothman 586731 586731 Greystok, Thomas, of Wakefeld, Yorks, clothman 0
3681353 1920257 1920257 defendant Smyth William dyer 586731 586731 Smyth, William, of Wakefeld, Yorks, dyer 0
3681529 1920313 1920313 defendant Robardys John merchant 586731 586731 Robardys, John, of Wakefeld, Yorks, merchant 0
3681531 1920314 1920314 defendant Roberdys John merchant 586731 586731 Roberdys, John, of Wakefeld, Yorks, merchant 0
3683239 1920877 1920877 defendant Graistoke Thomas clothman 586731 586731 Graistoke, Thomas, of Wakefeld, Yorks, clothman 0
3694900 1924613 1924613 defendant Grenewod Robert chapman 586731 586731 Grenewod, Robert, of Wakefeld, Yorks, chapman 1
3699523 1926082 1926082 defendant Wylson Robert clothier 586731 586731 Wylson, Robert, of Wakefeld, Yorks, clothier 0
3699526 1926083 1926083 defendant Wylson Robert clothier 586731 586731 Wylson, Robert, of Wakefeld, Yorks, clothier 0
3699539 1926087 1926087 defendant Oxenfeld Robert   586731 586731 Oxenfeld, Robert, of Wakefeld, Yorks, cloth driver 0
3699910 1926201 1926201 defendant Rokesby John dyer 586731 586731 Rokesby, John, of Wakefeld, Yorks, dyer 0
3699985 1926229 1926229 defendant Rokesby John dyer 586731 586731 Rokesby, John, of Wakefeld, Yorks, dyer 0
3704273 1927634 1927634 defendant Goodman Richard merchant 586731 586731 Goodman, Richard, of Wakefeld, Yorks, merchant 0
3704624 1927733 1927733 defendant Walker Roland clothman 586731 586731 Walker, Roland, of Wakefeld, Yorks, clothman 0
3712085 1930098 1930098 defendant Cokson Richard clothman 586731 586731 Cokson, Richard, of Wakefeld, Yorks, clothman 0
3712089 1930099 1930099 defendant Cokson Richard clothman 586731 586731 Cokson, Richard, of Wakefeld, Yorks, clothman 0
3718638 1932107 1932107 defendant Godman Henry merchant 586731 586731 Godman, Henry, of Wakefeld, Yorks, merchant 0
3719437 1932353 1932353 defendant Cokson Richard chapman 586731 586731 Cokson, Richard, of Wakefeld, Yorks, chapman 1
3721369 1932991 1932991 defendant Goldsmyth Thomas clothman 586731 586731 Goldsmyth, Thomas, of Wakefeld, Yorks, clothman 3
3723424 1933593 1933593 defendant Oxenfeld Robert clothman 586731 586731 Oxenfeld, Robert, of Wakefeld, Yorks, clothman 0
3723433 1933595 1933595 defendant Oxenfeld Robert clothman 586731 586731 Oxenfeld, Robert, of Wakefeld, Yorks, clothman 0
3724327 1933895 1933895 defendant Thyrleston John (legal representative) 586731 586731 Thyrleston, John, of Wakefeld, Yorks, pewterer, executor of 1
3724331 1933896 1933896 defendant Thyrleston Thomas pewterer 586731 586731 Thyrleston, Thomas, of Wakefeld, Yorks, pewterer 1
3727670 1934926 1934926 defendant Turton Richard gent 586731 586731 Turton, Richard, of Wakefeld, Yorks, gent 3
3746289 1940750 1940750 defendant Cokeson Richard clothman 586731 586731 Cokeson, Richard, of Wakefeld, Yorks, clothman 0
3754981 1943505 1943505 defendant Cookeson Richard clothman 586731 586731 Cookeson, Richard, of Wakefeld, Yorks, clothman 0
3755431 1943652 1943652 defendant Wylson Robert clothier 586731 586731 Wylson, Robert, of Wakefeld, Yorks, clothier 0
3765720 1946944 1946944 defendant Cokson Richard clothier 586731 586731 Cokson, Richard, of Wakefeld, Yorks, clothier 0
3772989 1949255 1949255 defendant Turton Richard   586731 586731 Turton, Richard, of Wakefeld, Yorks, knight 0
3779208 1951217 1951217 defendant Wilson Miles clothman 586731 586731 Wilson, Miles, of Wakefeld, Yorks, clothman 0
3791886 1955309 1955309 defendant Wylson Peter clothman 586731 586731 Wylson, Peter, of Wakefeld, Yorks, clothman 1
3794386 1956123 1956123 defendant Gryse Oswald merchant 586731 586731 Gryse, Oswald, of Wakefeld, Yorks, merchant 0
3798628 1957479 1957479 defendant Jobson Brian clothman 586731 586731 Jobson, Brian, of Wakefeld, Yorks, clothman 0
3798631 1957480 1957480 defendant Jobson Brian clothman 586731 586731 Jobson, Brian, of Wakefeld, Yorks, clothman 0
3798839 1957551 1957551 defendant Jopson Brian clothier 586731 586731 Jopson, Brian, of Wakefeld, Yorks, clothier 0
3806932 1960077 1960077 defendant Turton Richard gent 586731 586731 Turton, Richard, of Wakefeld, Yorks, gent 0
3812285 1961738 1961738 defendant Dalton Richard husbandman 586731 586731 Dalton, Richard, of Wakefeld, Yorks, husbandman 0
3812291 1961739 1961739 defendant Jobson Brian clothier 586731 586731 Jobson, Brian, of Wakefeld, Yorks, clothier 1
3816274 1962999 1962999 defendant Jopson Brian clothier 586731 586731 Jopson, Brian, of Wakefeld, Yorks, clothier 0
3816401 1963038 1963038 defendant Jenkynson Richard gent 586731 586731 (Jenkynson, Richard, of Wakefeld, Yorks, gent 1
3817673 1963430 1963430 defendant Turton Richard gent 586731 586731 Turton, Richard, of Wakefeld, Yorks, gent 0
3821497 1964618 1964618 defendant Oxenfeld Robert clothman 586731 586731 Oxenfeld, Robert, of Wakefeld, Yorks, clothman 2
3825151 1965732 1965732 defendant Burse William yeoman 586731 586731 Burse, William, of Wakefeld, Yorks, yeoman 0
3825855 1965936 1965936 defendant Gryce Oswald clothman 586731 586731 Gryce, Oswald, of Wakefeld, Yorks, clothman 0
3828900 1966918 1966918 defendant Jobson Brian clothier 586731 586731 Jobson, Brian, of Wakefeld, Yorks, clothier 0
3829945 1967260 1967260 defendant Lykebarowe Thomas clothman 586731 586731 Lykebarowe, Thomas, of Wakefeld, Yorks, clothman 0
3833943 1968554 1968554 defendant Pymond Richard merchant venturer 586731 586731 Pymond, Richard, of Wakefeld, Yorks, merchant venturer 0
3836755 1969394 1969394 defendant Grenewood Robert mercer 586731 586731 Grenewood, Robert, of Wakefeld, Yorks, mercer 0
3836757 1969395 1969395 defendant Grenewood Robert mercer 586731 586731 Grenewood, Robert, of Wakefeld, Yorks, mercer 0
3838962 1970114 1970114 defendant Gryse Oswald chapman 586731 586731 Gryse, Oswald, of Wakefeld, Yorks, chapman 0
3840296 1970532 1970532 defendant Medeley John clothier 586731 586731 Medeley, John, of Wakefeld, Yorks, clothier 0
3840300 1970533 1970533 defendant Medley John clothier 586731 586731 Medley, John, of Wakefeld, Yorks, clothier 0
3840304 1970534 1970534 defendant Medley John clothier 586731 586731 Medley, John, of Wakefeld, Yorks, clothier 0
3842562 1971202 1971202 defendant Cokson Robert yeoman 586731 586731 Cokson, Robert, of Wakefeld, Yorks, yeoman 0
3844721 1971891 1971891 defendant Rokysby John dyer 586731 586731 Rokysby, John, of Wakefeld, Yorks, dyer 0
3856174 1975554 1975554 plaintiff Wilson Robert (legal representative) 586731 586731 Wilson, Robert, of Wakefeld, Yorks, executors of 0
3856178 1975555 1975555 plaintiff Wilson Robert (legal representative) 586731 586731 Wilson, Robert, of Wakefeld, Yorks, executors of 0
3859820 1976784 1976784 defendant Brykytt Gilbert chapman 586731 586731 Brykytt, Gilbert, of Wakefeld, Yorks, chapman 2
3859824 1976785 1976785 defendant Brykytt Gilbert chapman 586731 586731 Brykytt, Gilbert, of Wakefeld, Yorks, chapman 2
3859837 1976789 1976789 defendant Brykytt Gilbert chapman 586731 586731 Brykytt, Gilbert, of Wakefeld, Yorks, chapman 2
3870499 1980373 1980373 plaintiff Wylson Robert (legal representative) 586731 586731 Wylson, Robert, of Wakefeld, Yorks, executors of 0
3875037 1981878 1981878 defendant Thompson alias Brasyer Arthur yeoman 586731 586731 Thompson alias Brasyer, Arthur, of Wakefeld, Yorks, yeoman 0
3878252 1982976 1982976 defendant Gryce Oswald clothman 586731 586731 Gryce, Oswald, of Wakefeld, Yorks, clothman 0
3878679 1983117 1983117 defendant Lokys William   586731 586731 Lokys, William, of Wakefeld, Yorks, caryour 3
3882291 1984336 1984336 defendant Medley John clothman 586731 586731 Medley, John, of Wakefeld, Yorks, clothman 0
3882493 1984409 1984409 plaintiff Tatersalle Thomas yeoman 586731 586731 Tatersalle, Thomas, of Wakefeld, Yorks, yeoman 0
3885178 1985293 1985293 defendant Wylson Robert clothier 586731 586731 Wylson, Robert, of Wakefeld, Yorks, clothier 0
3891047 1987271 1987271 defendant Robert John yeoman 586731 586731 Robert, John, of Wakefeld, Yorks, yeoman 0
3891295 1987355 1987355 defendant Gryce Oswald clothman 586731 586731 Gryce, Oswald, of Wakefeld, Yorks, clothman 0
3898649 1989756 1989756 defendant Nicolson Henry chapman 586731 586731 Nicolson, Henry, of Wakefeld, Yorks, chapman 0
3913015 1994683 1994683 defendant Wylson Robert clothier 586731 586731 Wylson, Robert, of Wakefeld, Yorks, clothier 0
3915759 1995648 1995648 defendant Noder William clothmaker 586731 586731 Noder, William, of Wakefeld, Yorks, clothmaker 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);