names

1,027 rows where place_id = 586887

✎ 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
3589903 1864482 1864482 defendant Gargrave Robert esq 586887 586887 Gargrave, Robert, of Wakefeld, esq 0
3592713 1865335 1865335 defendant Tate Thomas yeoman 586887 586887 Tate, Thomas, of Wakefeld, yeoman 0
3592854 1865381 1865381 defendant Cokson Robert yeoman 586887 586887 Cokson, Robert, of Wakefeld, yeoman 0
3592858 1865383 1865383 plaintiff Gryce Thomas   586887 586887 Gryce, Thomas, of Wakefeld 0
3592861 1865383 1865383 defendant Wowan Thomas yeoman 586887 586887 Wowan, Thomas, of Wakefeld, yeoman 2
3595402 1866194 1866194 defendant Lyster Thomas   586887 586887 Lyster, Thomas, of Wakefeld, attorney 0
3600263 1867729 1867729 defendant Cudworth Oliver chaplain 586887 586887 Cudworth, Oliver, of Wakefeld, chaplain 0
3600284 1867734 1867734 defendant Tytyng Robert glover 586887 586887 Tytyng, Robert, of Wakefeld, glover 5
3601734 1868198 1868198 defendant Blome Thomas goldsmith 586887 586887 Blome, Thomas, of Wakefeld, goldsmith 0
3603740 1868841 1868841 defendant Ratclyff Ottwell chapman 586887 586887 Ratclyff, Ottwell, of Wakefeld, chapman 1
3603775 1868850 1868850 defendant Bonland John innholder 586887 586887 Bonland, John, of Wakefeld, innholder 4
3607355 1869961 1869961 defendant Lister Thomas gent 586887 586887 Lister, Thomas, of Wakefeld, gent 0
3627235 1903364 1903364 defendant Goldsmyth Thomas dyer 586887 586887 Goldsmyth, Thomas, of Wakefeld, dyer 0
3628248 1903694 1903694 defendant Lacy Christopher gent 586887 586887 Lacy, Christopher, of Wakefeld, gent 0
3629830 1904182 1904182 defendant Roper John clothier 586887 586887 Roper, John, of Wakefeld, clothier 1
3629831 1904182 1904182 defendant Franke Robert clothier 586887 586887 Franke, Robert, of Wakefeld, clothier 2
3629832 1904182 1904182 defendant Franke John clothier 586887 586887 Franke, John, of Wakefeld, clothier 3
3630298 1904324 1904324 defendant Box John gent 586887 586887 Box, John, of Wakefeld, gent 0
3630299 1904324 1904324 defendant Arundell William yeoman 586887 586887 Arundell, William, of Wakefeld, yeoman 1
3631607 1904700 1904700 defendant Topclyff Joan spinster 586887 586887 Topclyff, Joan, of Wakefeld, spinster 1
3631608 1904700 1904700 defendant Goope or Ecope Thomas yeoman 586887 586887 Goope or Ecope, Thomas, of Wakefeld, yeoman 2
3641603 1907834 1907834 defendant Robert John mercer 586887 586887 Robert, John, of Wakefeld, mercer 0
3641604 1907834 1907834 defendant Maysterman William butcher 586887 586887 Maysterman, William, of Wakefeld, butcher 1
3642028 1907955 1907955 defendant Frank Robert dyer 586887 586887 Frank, Robert, of Wakefeld, dyer 1
3644386 1908662 1908662 defendant Waterton Robert gent 586887 586887 Waterton, Robert, of Wakefeld, gent 0
3646728 1909378 1909378 defendant Camsall William dyer 586887 586887 Camsall, William, of Wakefeld, dyer 0
3646730 1909378 1909378 defendant Prynse William cooper 586887 586887 Prynse, William, of Wakefeld, cooper 2
3649035 1910087 1910087 defendant Cales Thomas yeoman 586887 586887 Cales, Thomas, of Wakefeld, yeoman 0
3649036 1910087 1910087 defendant Goldsmyth Jasper yeoman 586887 586887 Goldsmyth, Jasper, of Wakefeld, yeoman 1
3650258 1910453 1910453 defendant Wylson Miles chapman 586887 586887 Wylson, Miles, of Wakefeld, chapman 0
3651159 1910727 1910727 defendant Grave Robert yeoman 586887 586887 Grave, Robert, of Wakefeld, yeoman 0
3652590 1911145 1911145 defendant Suger William glover 586887 586887 Suger, William, of Wakefeld, glover 0
3653707 1911422 1911422 defendant Grave Robert yeoman 586887 586887 Grave, Robert, of Wakefeld, yeoman 0
3654333 1911615 1911615 defendant Smalpage John dyer 586887 586887 Smalpage, John, of Wakefeld, dyer 0
3655181 1911880 1911880 defendant Smalpage Thomas dyer 586887 586887 Smalpage, Thomas, of Wakefeld, dyer 0
3656076 1912153 1912153 defendant Goldsmyth Thomas dyer 586887 586887 Goldsmyth, Thomas, of Wakefeld, dyer 0
3659664 1913278 1913278 plaintiff Grice Thomas, senior   586887 586887 Grice, Thomas, senior, of Wakefeld 0
3661069 1913736 1913736 defendant Warbilton Geoffrey dyer 586887 586887 Warbilton, Geoffrey, of Wakefeld, dyer 0
3661070 1913736 1913736 defendant Pereson Nicholas clothier 586887 586887 Pereson, Nicholas, of Wakefeld, clothier 1
3661307 1913812 1913812 defendant Awmeler Lawrence   586887 586887 Awmeler, Lawrence, of Wakefeld, cloth dryver 0
3665525 1915169 1915169 defendant Graistok Thomas dyer 586887 586887 Graistok, Thomas, of Wakefeld, dyer 1
3667330 1915719 1915719 defendant Tatersall Thomas chapman 586887 586887 Tatersall, Thomas, of Wakefeld, chapman 0
3667335 1915720 1915720 defendant Greistok Robert dyer 586887 586887 Greistok, Robert, of Wakefeld, dyer 3
3669497 1916398 1916398 defendant Killyngbek Thomas butcher 586887 586887 Killyngbek, Thomas, of Wakefeld, butcher 0
3669499 1916398 1916398 defendant Grave Robert yeoman 586887 586887 Grave, Robert, of Wakefeld, yeoman 2
3670493 1916733 1916733 defendant Wales Alexander   586887 586887 Wales, Alexander, of Wakefeld, mason 0
3670494 1916733 1916733 defendant Shotilworth John clothier 586887 586887 Shotilworth, John, of Wakefeld, clothier 1
3672162 1917291 1917291 defendant Goldsmyth Thomas dyer 586887 586887 Goldsmyth, Thomas, of Wakefeld, dyer 0
3676500 1918694 1918694 defendant Whittyll William clothmaker 586887 586887 Whittyll, William, of Wakefeld, clothmaker 1
3676501 1918694 1918694 defendant Wales Alexander   586887 586887 Wales, Alexander, of Wakefeld, mason 2
3676502 1918695 1918695 plaintiff Jepson Brian clothier 586887 586887 Jepson, Brian, of Wakefeld, clothier 0
3679205 1919564 1919564 defendant Parker Miles clothmaker 586887 586887 Parker, Miles, of Wakefeld, clothmaker 0
3679930 1919789 1919789 defendant Sulger William glover 586887 586887 Sulger, William, of Wakefeld, glover 1
3679931 1919789 1919789 defendant Goldmyth Thomas dyer 586887 586887 Goldmyth, Thomas, of Wakefeld, dyer 2
3679934 1919790 1919790 defendant Sulger William glover 586887 586887 Sulger, William, of Wakefeld, glover 1
3679935 1919790 1919790 defendant Goldsmyth Thomas dyer 586887 586887 Goldsmyth, Thomas, of Wakefeld, dyer 2
3682681 1920687 1920687 defendant Eland Robert esq 586887 586887 Eland, Robert, of Wakefeld, esq 0
3682682 1920687 1920687 defendant Snath George gent 586887 586887 Snath, George, of Wakefeld, gent 1
3682685 1920688 1920688 defendant Elande Robert esq 586887 586887 Elande, Robert, of Wakefeld, esq 0
3682686 1920688 1920688 defendant Snayth George gent 586887 586887 Snayth, George, of Wakefeld, gent 1
3682695 1920691 1920691 defendant Gargrave Thomas, senior gent 586887 586887 Gargrave, Thomas, senior, of Wakefeld, gent 0
3682711 1920695 1920695 defendant Gargrave Thomas, senior gent 586887 586887 Gargrave, Thomas, senior, of Wakefeld, gent 0
3683377 1920924 1920924 defendant Suger William glover 586887 586887 Suger, William, of Wakefeld, glover 0
3683851 1921085 1921085 defendant Spynk William dyer 586887 586887 Spynk, William, of Wakefeld, dyer 0
3683852 1921085 1921085 defendant Spynk Richard dyer 586887 586887 Spynk, Richard, of Wakefeld, dyer 1
3683853 1921085 1921085 defendant Graystok Thomas dyer 586887 586887 Graystok, Thomas, of Wakefeld, dyer 2
3683854 1921085 1921085 defendant Smalpage Thomas dyer 586887 586887 Smalpage, Thomas, of Wakefeld, dyer 3
3683855 1921085 1921085 defendant Braswell Thomas dyer 586887 586887 Braswell, Thomas, of Wakefeld, dyer 4
3684023 1921136 1921136 plaintiff Wilson Robert kendalman 586887 586887 Wilson, Robert, of Wakefeld, kendalman 0
3684024 1921136 1921136 defendant Robart John mercer 586887 586887 Robart, John, of Wakefeld, mercer 0
3684789 1921379 1921379 defendant Lynley Robert glover 586887 586887 Lynley, Robert, of Wakefeld, glover 0
3684877 1921406 1921406 defendant Palmer William saddler 586887 586887 Palmer, William, of Wakefeld, saddler 0
3685935 1921758 1921758 defendant Godman Henry yeoman 586887 586887 Godman, Henry, of Wakefeld, yeoman 1
3691908 1923631 1923631 defendant Suger John glover 586887 586887 Suger, John, of Wakefeld, glover 0
3691930 1923637 1923637 defendant Flemyng William gent 586887 586887 Flemyng, William, of Wakefeld, gent 0
3692858 1923964 1923964 defendant Spynke William dyer 586887 586887 Spynke, William, of Wakefeld, dyer 0
3692860 1923965 1923965 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 0
3694606 1924516 1924516 defendant Denton Richard barker 586887 586887 Denton, Richard, of Wakefeld, barker 1
3697466 1925427 1925427 defendant Grenewode Robert mercer 586887 586887 Grenewode, Robert, of Wakefeld, mercer 0
3698448 1925734 1925734 defendant Suger William glover 586887 586887 Suger, William, of Wakefeld, glover 0
3699524 1926082 1926082 defendant Oxenfeld Robert clothier 586887 586887 Oxenfeld, Robert, of Wakefeld, clothier 1
3699527 1926083 1926083 defendant Oxenfeld Robert husbandman 586887 586887 Oxenfeld, Robert, of Wakefeld, husbandman 1
3699915 1926203 1926203 defendant Suger William glover 586887 586887 Suger, William, of Wakefeld, glover 0
3704625 1927733 1927733 defendant Goodman Henry merchant 586887 586887 Goodman, Henry, of Wakefeld, merchant 1
3705141 1927898 1927898 plaintiff Gryce Oswold clothman 586887 586887 Gryce, Oswold, of Wakefeld, clothman 0
3705142 1927898 1927898 defendant Wyndyll Richard mercer 586887 586887 Wyndyll, Richard, of Wakefeld, mercer 0
3705143 1927898 1927898 defendant Wyndyll John husbandman 586887 586887 Wyndyll, John, of Wakefeld, husbandman 1
3705145 1927898 1927898 defendant Sewgur Thomas draper 586887 586887 Sewgur, Thomas, of Wakefeld, draper 3
3705146 1927898 1927898 defendant Wilson Miles clothman 586887 586887 Wilson, Miles, of Wakefeld, clothman 4
3707146 1928522 1928522 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 0
3707148 1928523 1928523 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 0
3707150 1928524 1928524 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 0
3707153 1928525 1928525 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 0
3707156 1928526 1928526 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 0
3707158 1928526 1928526 defendant Metheley John fuller 586887 586887 Metheley, John, of Wakefeld, fuller 2
3707160 1928527 1928527 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 0
3707161 1928527 1928527 defendant Pekke John esq 586887 586887 Pekke, John, of Wakefeld, esq 1
3707163 1928528 1928528 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 0
3707166 1928529 1928529 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 0
3707167 1928529 1928529 defendant Spynke William dyer 586887 586887 Spynke, William, of Wakefeld, dyer 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);