names

130 rows where place_id = 598289

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631865 1904775 1904775 defendant Smyth William husbandman 598289 598289 Smyth, William, of Swynneshed, husbandman 0
3637205 1906437 1906437 defendant Wynter Thomas butcher 598289 598289 Wynter, Thomas, of Swynneshed, butcher 0
3637365 1906492 1906492 plaintiff Skynner John (legal representative) 598289 598289 Skynner, John, of Swynneshed, executrix of 0
3637367 1906492 1906492 defendant Broun Thomas yeoman 598289 598289 Broun, Thomas, of Swynneshed, yeoman 0
3639748 1907241 1907241 plaintiff Wodheth alias Webster John yeoman 598289 598289 Wodheth alias Webster, John, of Swynneshed, yeoman 0
3647667 1909659 1909659 defendant Garrard John yeoman 598289 598289 Garrard, John, of Swynneshed, yeoman 0
3667452 1915760 1915760 plaintiff Wolmer Richard gent 598289 598289 Wolmer, Richard, of Swynneshed, gent 0
3670335 1916674 1916674 defendant Paky William butcher 598289 598289 Paky, William, of Swynneshed, butcher 0
3670336 1916674 1916674 defendant Howson Edward mercer 598289 598289 Howson, Edward, of Swynneshed, mercer 1
3670498 1916735 1916735 defendant Honnyng Roger yeoman 598289 598289 Honnyng, Roger, of Swynneshed, yeoman 0
3670499 1916735 1916735 defendant Hall Thomas yeoman 598289 598289 Hall, Thomas, of Swynneshed, yeoman 1
3674990 1918208 1918208 defendant Apchurche John miller 598289 598289 Apchurche, John, of Swynneshed, miller 0
3675026 1918218 1918218 defendant Frereneve William husbandman 598289 598289 Frereneve, William, of Swynneshed, husbandman 0
3675029 1918220 1918220 plaintiff Halgh John gent 598289 598289 Halgh, John, of Swynneshed, gent 0
3675031 1918220 1918220 defendant Smyth Richard chaplain 598289 598289 Smyth, Richard, of Swynneshed, chaplain 0
3680454 1919968 1919968 defendant Maye Roger, junior laborer 598289 598289 Maye, Roger, junior, of Swynneshed, laborer 0
3680455 1919968 1919968 defendant Frerneff William laborer 598289 598289 Frerneff, William, of Swynneshed, laborer 1
3690953 1923333 1923333 defendant Echerd Robert laborer 598289 598289 Echerd, Robert, of Swynneshed, laborer 0
3690991 1923346 1923346 plaintiff Halgh John (legal representative) 598289 598289 Halgh, John, of Swynneshed, executor of 0
3690994 1923347 1923347 plaintiff Halgh John (legal representative) 598289 598289 Halgh, John, of Swynneshed, executor of 0
3690998 1923348 1923348 plaintiff Halgh John (legal representative) 598289 598289 Halgh, John, of Swynneshed, gent, executor of 0
3691000 1923348 1923348 defendant Pulvertoft Robert husbandman 598289 598289 Pulvertoft, Robert, of Swynneshed, husbandman 0
3691001 1923349 1923349 plaintiff Halgh John (legal representative) 598289 598289 Halgh, John, of Swynneshed, gent, executor of 0
3699306 1925998 1925998 defendant Paky William butcher 598289 598289 Paky, William, of Swynneshed, butcher 0
3701273 1926642 1926642 defendant Hough Thomas gent 598289 598289 Hough, Thomas, of Swynneshed, gent 0
3705321 1927954 1927954 plaintiff Halgh John (legal representative) 598289 598289 Halgh, John, of Swynneshed, gent, executor of 0
3705329 1927957 1927957 defendant Paky Thomas butcher 598289 598289 Paky, Thomas, of Swynneshed, butcher 0
3735097 1937219 1937219 defendant Echard Robert laborer 598289 598289 Echard, Robert, of Swynneshed, laborer 0
3736429 1937638 1937638 defendant Morefote Robert husbandman 598289 598289 Morefote, Robert, of Swynneshed, husbandman 0
3738618 1938287 1938287 defendant Grene William sherman 598289 598289 Grene, William, of Swynneshed, sherman 2
3752735 1942784 1942784 defendant Pakye William butcher 598289 598289 Pakye, William, of Swynneshed, butcher 0
3752736 1942784 1942784 defendant Frerneif William husbandman 598289 598289 Frerneif, William, of Swynneshed, husbandman 1
3752737 1942784 1942784 defendant Broune John, junior   598289 598289 Broune, John, junior, of Swynneshed 2
3773854 1949534 1949534 plaintiff Wynter Thomas (legal representative) 598289 598289 Wynter, Thomas, of Swynneshed, yeoman, administratrix of 0
3775565 1950101 1950101 defendant Smyth William husbandman 598289 598289 Smyth, William, of Swynneshed, husbandman 0
3776012 1950242 1950242 defendant Coke William husbandman 598289 598289 Coke, William, of Swynneshed, husbandman 0
3782726 1952341 1952341 defendant Carter of Richard miller 598289 598289 Carter, of Richard, of Swynneshed, miller 2
3782731 1952342 1952342 defendant Carter Richard miller 598289 598289 Carter, Richard, of Swynneshed, miller 2
3784278 1952872 1952872 defendant Storkes William husbandman 598289 598289 Storkes, William, of Swynneshed, husbandman 1
3784280 1952872 1952872 defendant Tylney Richard husbandman 598289 598289 Tylney, Richard, of Swynneshed, husbandman 3
3794557 1956177 1956177 defendant Pulvertoft Thomas laborer 598289 598289 Pulvertoft, Thomas, of Swynneshed, laborer 1
3798034 1957284 1957284 defendant Hutton Elizabeth widow 598289 598289 Hutton, Elizabeth, of Swynneshed, widow 0
3798035 1957284 1957284 defendant Adamson Robert thatcher 598289 598289 Adamson, Robert, of Swynneshed, thatcher 1
3798036 1957284 1957284 defendant Fereby Nicholas laborer 598289 598289 Fereby, Nicholas, of Swynneshed, laborer 2
3798037 1957284 1957284 defendant Paky William butcher 598289 598289 Paky, William, of Swynneshed, butcher 3
3809601 1960890 1960890 plaintiff Bennet William   598289 598289 Bennet, William, of Swynneshed 0
3815409 1962736 1962736 defendant Hawdaill John husbandman 598289 598289 Hawdaill, John, of Swynneshed, husbandman 0
3842445 1971173 1971173 defendant Carter Richard miller 598289 598289 Carter, Richard, of Swynneshed, miller 2
3842647 1971232 1971232 plaintiff Bull Robert (legal representative) 598289 598289 Bull, Robert, of Swynneshed, executors of 0
3842650 1971232 1971232 defendant Paky William butcher 598289 598289 Paky, William, of Swynneshed, butcher 0
3845807 1972239 1972239 defendant Paky Nicholas butcher 598289 598289 Paky, Nicholas, of Swynneshed, butcher 0
3850946 1973888 1973888 defendant Carter Richard   598289 598289 Carter, Richard, of Swynneshed, millwright 0
3850947 1973888 1973888 defendant Grene William sherman 598289 598289 Grene, William, of Swynneshed, sherman 1
3850949 1973888 1973888 defendant May Henry yeoman 598289 598289 May, Henry, of Swynneshed, yeoman 3
3850956 1973889 1973889 defendant Straker Thomas husbandman 598289 598289 Straker, Thomas, of Swynneshed, husbandman 4
3853218 1974625 1974625 defendant Ellys Thomas husbandman 598289 598289 Ellys, Thomas, of Swynneshed, husbandman 0
3853219 1974625 1974625 defendant Browne William mercer 598289 598289 Browne, William, of Swynneshed, mercer 1
3853220 1974625 1974625 defendant Wryght Richard husbandman 598289 598289 Wryght, Richard, of Swynneshed, husbandman 2
3853221 1974625 1974625 defendant Bull Richard husbandman 598289 598289 Bull, Richard, of Swynneshed, husbandman 3
3853222 1974625 1974625 defendant Rawlett Thomas weaver 598289 598289 Rawlett, Thomas, of Swynneshed, weaver 4
3853223 1974625 1974625 defendant Bullok John husbandman 598289 598289 Bullok, John, of Swynneshed, husbandman 5
3858922 1976473 1976473 defendant Bell Thomas husbandman 598289 598289 (Bell, Thomas, of Swynneshed, husbandman 1
3858926 1976474 1976474 defendant Paky William butcher 598289 598289 Paky, William, of Swynneshed, butcher 0
3865121 1978537 1978537 defendant Hartley Thomas husbandman 598289 598289 Hartley, Thomas, of Swynneshed, husbandman 0
3865123 1978537 1978537 defendant Moone Simon carpenter 598289 598289 Moone, Simon, of Swynneshed, carpenter 2
3865863 1978813 1978813 defendant Comyn Thomas carpenter 598289 598289 Comyn, Thomas, of Swynneshed, carpenter 0
3865864 1978813 1978813 defendant Lucas William roper 598289 598289 Lucas, William, of Swynneshed, roper 1
3865867 1978814 1978814 defendant Jentyll Simon draper 598289 598289 Jentyll, Simon, of Swynneshed, draper 1
3865868 1978814 1978814 defendant Hawdale John laborer 598289 598289 Hawdale, John, of Swynneshed, laborer 2
3865869 1978814 1978814 defendant Lucas William husbandman 598289 598289 Lucas, William, of Swynneshed, draper, Bell, Thomas, of Swynneshed, husbandman 3
3866947 1979183 1979183 defendant Hune Thomas husbandman 598289 598289 Hune, Thomas, of Swynneshed, husbandman 0
3867722 1979438 1979438 defendant Ellys Thomas husbandman 598289 598289 Ellys, Thomas, of Swynneshed, husbandman 0
3867723 1979438 1979438 defendant Browne William mercer 598289 598289 Browne, William, of Swynneshed, mercer 1
3867724 1979438 1979438 defendant Wright Richard husbandman 598289 598289 Wright, Richard, of Swynneshed, husbandman 2
3867725 1979438 1979438 defendant Bull Richard husbandman 598289 598289 Bull, Richard, of Swynneshed, husbandman 3
3867726 1979438 1979438 defendant Rowlett Thomas weaver 598289 598289 Rowlett, Thomas, of Swynneshed, weaver 4
3867727 1979438 1979438 defendant Bullok John husbandman 598289 598289 Bullok, John, of Swynneshed, husbandman 5
3869772 1980132 1980132 defendant Cokket Robert yeoman 598289 598289 Cokket, Robert, of Swynneshed, yeoman 0
3870750 1980463 1980463 defendant Wynter Richard fisher 598289 598289 Wynter, Richard, of Swynneshed, fisher 0
3870751 1980463 1980463 defendant Hawdall John fisher 598289 598289 Hawdall, John, of Swynneshed, fisher 1
3870752 1980463 1980463 defendant Cemmok Thomas laborer 598289 598289 Cemmok, Thomas, of Swynneshed, laborer 2
3873940 1981504 1981504 defendant Cokket Robert yeoman 598289 598289 Cokket, Robert, of Swynneshed, yeoman 0
3876678 1982445 1982445 defendant Deconson George laborer 598289 598289 Deconson, George, of Swynneshed, laborer 0
3876680 1982445 1982445 defendant Bothe Thomas laborer 598289 598289 Bothe, Thomas, of Swynneshed, laborer 2
3876682 1982446 1982446 defendant Couper Henry laborer 598289 598289 Couper, Henry, of Swynneshed, laborer 0
3876683 1982446 1982446 defendant Knyght John laborer 598289 598289 Knyght, John, of Swynneshed, laborer 1
3876781 1982477 1982477 defendant Gentyll Simon yeoman 598289 598289 Gentyll, Simon, of Swynneshed, yeoman 0
3880919 1983890 1983890 defendant Howson Edward husbandman 598289 598289 Howson, Edward, of Swynneshed, husbandman 0
3881657 1984115 1984115 defendant Ellys Thomas husbandman 598289 598289 Ellys, Thomas, of Swynneshed, husbandman 0
3881658 1984115 1984115 defendant Brown William mercer 598289 598289 Brown, William, of Swynneshed, mercer 1
3881659 1984115 1984115 defendant Wryght Richard husbandman 598289 598289 Wryght, Richard, of Swynneshed, husbandman 2
3881660 1984115 1984115 defendant Bull Richard husbandman 598289 598289 Bull, Richard, of Swynneshed, husbandman 3
3881661 1984115 1984115 defendant Rowlett Thomas weaver 598289 598289 Rowlett, Thomas, of Swynneshed, weaver 4
3881662 1984115 1984115 defendant Bullok John husbandman 598289 598289 Bullok, John, of Swynneshed, husbandman 5
3890095 1986922 1986922 defendant Drewry John   598289 598289 Drewry, John, of Swynneshed, cook 0
3890096 1986922 1986922 defendant Awben Michael laborer 598289 598289 Awben, Michael, of Swynneshed, laborer 1
3890097 1986922 1986922 defendant Wynter Richard fishmonger 598289 598289 Wynter, Richard, of Swynneshed, fishmonger 2
3890809 1987193 1987193 defendant May Henry husbandman 598289 598289 May, Henry, of Swynneshed, husbandman 1
3897560 1989396 1989396 defendant Carter Richard   598289 598289 Carter, Richard, of Swynneshed, millwright 0
3914014 1995031 1995031 plaintiff Browne William mercer 598289 598289 Browne, William, of Swynneshed, mercer 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);