names

652 rows where place_id = 592299

✎ 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
3594889 1866031 1866031 plaintiff Leyston John (legal representative) 592299 592299 Leyston, John, of Doncaster, executors of 0
3607258 1869934 1869934 defendant Mounford Thomas gent 592299 592299 Mounford, Thomas, of Doncaster, gent 0
3613999 1872038 1872038 plaintiff Bon John (legal representative) 592299 592299 Bon, John, of Doncaster, executors of 0
3623425 1874859 1874859 defendant Smyth John   592299 592299 Smyth, John, of Doncaster, hat maker 1
3625495 1875513 1875513 defendant Montfort Thomas gent 592299 592299 Montfort, Thomas, of Doncaster, gent 2
3625497 1875514 1875514 defendant Montford Thomas gent 592299 592299 Montford, Thomas, of Doncaster, gent 0
3626940 1903278 1903278 plaintiff Beamont John tailor 592299 592299 Beamont, John, of Doncaster, tailor 0
3630966 1904505 1904505 defendant Hommerston William butcher 592299 592299 Hommerston, William, of Doncaster, butcher 0
3632702 1905046 1905046 defendant Poyson John haberdasher 592299 592299 Poyson, John, of Doncaster, haberdasher 0
3632703 1905046 1905046 defendant Keton William gent 592299 592299 Keton, William, of Doncaster, gent 1
3632704 1905046 1905046 defendant Poyson Thomas goldsmith 592299 592299 Poyson, Thomas, of Doncaster, goldsmith 2
3632705 1905046 1905046 defendant Rawson William chapman 592299 592299 Rawson, William, of Doncaster, chapman 3
3632706 1905046 1905046 defendant Rawson Thomas chapman 592299 592299 Rawson, Thomas, of Doncaster, chapman 4
3655986 1912123 1912123 plaintiff (not given) Thomas prior of Burrell 592299 592299 Burrell, Thomas, of Doncaster, prior of the Carmelite Brotherhood 0
3658301 1912851 1912851 defendant Turnour William yeoman 592299 592299 Turnour, William, of Doncaster, yeoman 0
3667480 1915771 1915771 defendant Coke Edward (legal representative) 592299 592299 Coke, Edward, of Doncaster, inn holder, executrix of 0
3674660 1918125 1918125 defendant Turton William yeoman 592299 592299 Turton, William, of Doncaster, yeoman 1
3675854 1918484 1918484 defendant Snell Christopher butcher 592299 592299 Snell, Christopher, of Doncaster, butcher 1
3677743 1919087 1919087 defendant Denton Robert chaplain 592299 592299 Denton, Robert, of Doncaster, chaplain 3
3711307 1929841 1929841 defendant Bentley Thomas, junior yeoman 592299 592299 Bentley, Thomas, junior, of Doncaster, yeoman 1
3712467 1930216 1930216 defendant Dryffeld William baker 592299 592299 Dryffeld, William, of Doncaster, baker 0
3712469 1930217 1930217 defendant Dryffeld William baker 592299 592299 Dryffeld, William, of Doncaster, baker 0
3714577 1930855 1930855 defendant Withes William yeoman 592299 592299 Withes, William, of Doncaster, yeoman 4
3719081 1932247 1932247 defendant Baildon John gent 592299 592299 Baildon, John, of Doncaster, gent 0
3721671 1933070 1933070 defendant Copley Edmund gent 592299 592299 Copley, Edmund, of Doncaster, gent 1
3722499 1933297 1933297 defendant Walmesley alias Maltman Henry fishmonger 592299 592299 Walmesley alias Maltman, Henry, of Doncaster, fishmonger 0
3727829 1934974 1934974 defendant Stokkes John miller 592299 592299 Stokkes, John, of Doncaster, miller 0
3731792 1936174 1936174 defendant Walmesley Henry fisher 592299 592299 Walmesley, Henry, of Doncaster, fisher 0
3731793 1936174 1936174 defendant Lyell Robert sawyer 592299 592299 Lyell, Robert, of Doncaster, sawyer 1
3731794 1936174 1936174 defendant Wilkynson Thomas baker 592299 592299 Wilkynson, Thomas, of Doncaster, baker 2
3731795 1936174 1936174 defendant Croudar Edward laborer 592299 592299 Croudar, Edward, of Doncaster, laborer 3
3743559 1939861 1939861 defendant Fulwode Thomas glover 592299 592299 Fulwode, Thomas, of Doncaster, glover 1
3757868 1944440 1944440 defendant Baildon Robert husbandman 592299 592299 Baildon, Robert, of Doncaster, husbandman 0
3766703 1947246 1947246 defendant German Christopher cutler 592299 592299 German, Christopher, of Doncaster, cutler 0
3779424 1951288 1951288 plaintiff Ellys Thomas mercer 592299 592299 Ellys, Thomas, of Doncaster, mercer 0
3813539 1962152 1962152 plaintiff Ellis Thomas   592299 592299 Ellis, Thomas, of Doncaster 0
3817366 1963342 1963342 defendant Snydall Thomas yeoman 592299 592299 Snydall, Thomas, of Doncaster, yeoman 0
3821515 1964624 1964624 defendant Reynes Ralph   592299 592299 Reynes, Ralph, of Doncaster, bag maker 1
3845145 1972042 1972042 plaintiff Ellys Alexander   592299 592299 Ellys, Alexander, of Doncaster 0
3845146 1972042 1972042 defendant Cokson Cuthbert draper 592299 592299 Cokson, Cuthbert, of Doncaster, draper 0
3861301 1977251 1977251 defendant Ellys Alexander innholder 592299 592299 Ellys, Alexander, of Doncaster, innholder 0
3869812 1980147 1980147 defendant Skyres Edward laborer 592299 592299 Skyres, Edward, of Doncaster, laborer 0
3872467 1981017 1981017 plaintiff Bollok John merchant 592299 592299 Bollok, John, of Doncaster, merchant 0
3905068 1991958 1991958 defendant Worall Hugh esq 592299 592299 Worall, Hugh, of Doncaster, esq 1
3910563 1993847 1993847 defendant Mounte Roger smith 592299 592299 Mounte, Roger, of Doncaster, smith 0
3910575 1993852 1993852 defendant Symkynson John glover 592299 592299 Symkynson, John, of Doncaster, glover 0
3910576 1993852 1993852 defendant Warde John goldsmith 592299 592299 Warde, John, of Doncaster, goldsmith 1
3910577 1993852 1993852 defendant Rawson John laborer 592299 592299 Rawson, John, of Doncaster, laborer 2
3910578 1993852 1993852 defendant Dey John yeoman 592299 592299 Dey, John, of Doncaster, yeoman 3
3910579 1993852 1993852 defendant Fulwood William glover 592299 592299 Fulwood, William, of Doncaster, glover 4
3910580 1993852 1993852 defendant Butterfeld Robert baker 592299 592299 Butterfeld, Robert, of Doncaster, baker 5
3910581 1993852 1993852 defendant Esshe John husbandman 592299 592299 Esshe, John, of Doncaster, husbandman 6
3910582 1993852 1993852 defendant Grenerode James laborer 592299 592299 Grenerode, James, of Doncaster, laborer 7
3931889 2000965 2000965 defendant Esshe John husbandman 592299 592299 Esshe, John, of Doncaster, husbandman 0
3934500 2001834 2001834 defendant Broun John (legal representative) 592299 592299 Broun, John, of Doncaster, chapman, executors of 2
3934501 2001834 2001834 defendant Wittmore Richard chapman 592299 592299 (Wittmore, Richard, of Doncaster, chapman 3
3936815 2002645 2002645 plaintiff Moodye Roger   592299 592299 Moodye, Roger, of Doncaster 0
3936817 2002645 2002645 defendant Burgon Barbara   592299 592299 Burgon, Barbara, of Doncaster, widow, relict of Richard 1
3940906 2003964 2003964 defendant Hawdenby Robert, junior gent 592299 592299 Hawdenby, Robert, junior, of Doncaster, gent 0
3940907 2003964 2003964 defendant Copley George gent 592299 592299 Copley, George, of Doncaster, gent 1
3942021 2004344 2004344 plaintiff Webster Thomas   592299 592299 Webster, Thomas, of Doncaster 0
3954391 2008605 2008605 defendant Brende Nicholas innkeeper 592299 592299 Brende, Nicholas, of Doncaster, innkeeper 0
3954406 2008610 2008610 defendant Mecke Thomas innkeeper 592299 592299 Mecke, Thomas, of Doncaster, innkeeper 0
3954407 2008610 2008610 defendant Webster Thomas innkeeper 592299 592299 Webster, Thomas, of Doncaster, innkeeper 1
3965035 2012374 2012374 defendant Cooke Benedict butcher 592299 592299 Cooke, Benedict, of Doncaster, butcher 0
3966092 2012763 2012763 plaintiff Blenkynshoppe William   592299 592299 Blenkynshoppe, William, of Doncaster 0
3972318 2014885 2014885 defendant Watson Robert yeoman 592299 592299 Watson, Robert, of Doncaster, yeoman 0
3972590 2014990 2014990 defendant Fulwood Nicholas alderman 592299 592299 Fulwood, Nicholas, of Doncaster, alderman 1
3978028 2016890 2016890 defendant Harryson William miller 592299 592299 Harryson, William, of Doncaster, miller 0
3978030 2016890 2016890 defendant Harryson Robert laborer 592299 592299 Harryson, Robert, of Doncaster, laborer 2
3978031 2016890 2016890 defendant Harryson Mary spinster 592299 592299 Harryson, Mary, of Doncaster, spinster 3
3978032 2016890 2016890 defendant Smyth William laborer 592299 592299 Smyth, William, of Doncaster, laborer 4
3979993 2017607 2017607 defendant Hirst William yeoman 592299 592299 Hirst, William, of Doncaster, yeoman 0
4014119 2029780 2029780 plaintiff Savage Richard tailor 592299 592299 Savage, Richard, of Doncaster, tailor 0
4017578 2030994 2030994 plaintiff Thwayt Edmund alderman 592299 592299 Thwayt, Edmund, of Doncaster, alderman 0
4018731 2031431 2031431 defendant Pernetethe Robert alderman 592299 592299 Pernetethe, Robert, of Doncaster, merchant, alderman 0
4028767 2034937 2034937 plaintiff Cowlyng Denis alderman 592299 592299 Cowlyng, Denis, of Doncaster, alderman 0
4028770 2034938 2034938 plaintiff Cowlyng Denis alderman 592299 592299 Cowlyng, Denis, of Doncaster, alderman 0
4028773 2034939 2034939 plaintiff Cowlyng Denis alderman 592299 592299 Cowlyng, Denis, of Doncaster, alderman 0
4033175 2036516 2036516 defendant Skargill Nicholas merchant 592299 592299 Skargill, Nicholas, of Doncaster, merchant 0
4033177 2036517 2036517 defendant Skargyll Nicholas merchant 592299 592299 Skargyll, Nicholas, of Doncaster, merchant 0
4033179 2036518 2036518 defendant Skargyll Nicholas merchant 592299 592299 Skargyll, Nicholas, of Doncaster, merchant 0
4033441 2036617 2036617 defendant Allen Thomas tailor 592299 592299 Allen, Thomas, of Doncaster, tailor 0
4033443 2036618 2036618 defendant Allen Thomas tailor 592299 592299 Allen, Thomas, of Doncaster, tailor 0
4033445 2036619 2036619 defendant Allen Thomas tailor 592299 592299 Allen, Thomas, of Doncaster, tailor 0
4033447 2036620 2036620 defendant Hall James yeoman 592299 592299 Hall, James, of Doncaster, yeoman 0
4033449 2036621 2036621 defendant Hall James yeoman 592299 592299 Hall, James, of Doncaster, yeoman 0
4033451 2036622 2036622 defendant Hall James yeoman 592299 592299 Hall, James, of Doncaster, yeoman 0
4033453 2036623 2036623 defendant Hall James yeoman 592299 592299 Hall, James, of Doncaster, yeoman 0
4046273 2041109 2041109 plaintiff Silvester John draper 592299 592299 Silvester, John, of Doncaster, draper 0
4046275 2041110 2041110 plaintiff Silvester John draper 592299 592299 Silvester, John, of Doncaster, draper 0
4055045 2044202 2044202 defendant Copley Francis esq 592299 592299 Copley, Francis, of Doncaster, esq 0
4057667 2045125 2045125 plaintiff Byrk Robert alderman 592299 592299 Byrk, Robert, of Doncaster, alderman 0
4057669 2045126 2045126 plaintiff Byrke Robert alderman 592299 592299 Byrke, Robert, of Doncaster, alderman 0
4058249 2045334 2045334 defendant Hyrste William haberdasher 592299 592299 Hyrste, William, of Doncaster, haberdasher 0
4058438 2045405 2045405 defendant Willyamson Alice widow 592299 592299 Willyamson, Alice, of Doncaster, widow 0
4058439 2045405 2045405 defendant Hall Richard laborer 592299 592299 Hall, Richard, of Doncaster, laborer 1
4058790 2045537 2045537 defendant Snell or Suell John merchant 592299 592299 Snell or Suell, John, of Doncaster, merchant 0
4060083 2046005 2046005 defendant Beale Richard vintner 592299 592299 Beale, Richard, of Doncaster, vintner 0
4060084 2046005 2046005 defendant Wylbore Thomas gent 592299 592299 Wylbore, Thomas, of Doncaster, gent 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);