names

218 rows where place_id = 588930

✎ 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
3596035 1866388 1866388 defendant Parker Nicholas gent 588930 588930 Parker, Nicholas, of Honyng, gent 0
3599592 1867509 1867509 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3599593 1867509 1867509 defendant Anable William   588930 588930 Anable, William, of Honyng, worsted weaver 1
3610148 1870837 1870837 defendant Coke John husbandman 588930 588930 Coke, John, of Honyng, husbandman 4
3610155 1870838 1870838 defendant Coke John husbandman 588930 588930 Coke, John, of Honyng, husbandman 4
3614555 1872200 1872200 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3616067 1872661 1872661 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3616069 1872662 1872662 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3616071 1872663 1872663 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3622023 1874429 1874429 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3622026 1874430 1874430 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3647877 1909731 1909731 defendant Anabill Thomas   588930 588930 Anabill, Thomas, of Honyng, worsted weaver 0
3647879 1909732 1909732 defendant Benyngton Thomas miller 588930 588930 Benyngton, Thomas, of Honyng, miller 0
3647883 1909733 1909733 defendant Benyngton Thomas miller 588930 588930 Benyngton, Thomas, of Honyng, miller 2
3647884 1909733 1909733 defendant Anebyll Thomas   588930 588930 Anebyll, Thomas, of Honyng, worsted weaver 3
3663459 1914497 1914497 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3663464 1914498 1914498 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3674689 1918131 1918131 defendant Ryall Peter   588930 588930 Ryall, Peter, of Honyng, worsted weaver 2
3695069 1924668 1924668 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3695070 1924668 1924668 defendant Parker Richard gent 588930 588930 Parker, Richard, of Honyng, gent 1
3699832 1926172 1926172 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3700976 1926555 1926555 defendant Cole Roger husbandman 588930 588930 Cole, Roger, of Honyng, husbandman 1
3715288 1931070 1931070 defendant Annabill alias Smyth Thomas   588930 588930 Annabill alias Smyth, Thomas, of Honyng, worsted weaver 0
3715289 1931070 1931070 defendant Chambyr alias Lessy John yeoman 588930 588930 Chambyr alias Lessy, John, of Honyng, yeoman 1
3715290 1931070 1931070 defendant Benyngton Thomas yeoman 588930 588930 Benyngton, Thomas, of Honyng, yeoman 2
3717093 1931631 1931631 plaintiff Curteys Richard   588930 588930 Curteys, Richard, of Honyng 0
3717097 1931631 1931631 defendant Denny Henry   588930 588930 Denny, Henry, of Honyng, worsted weaver 0
3720166 1932583 1932583 defendant Parkar John gent 588930 588930 Parkar, John, of Honyng, gent 2
3730637 1935815 1935815 defendant Prowdlove Peter clerk 588930 588930 Prowdlove, Peter, of Honyng, clerk 0
3733051 1936560 1936560 defendant Curteys Richard husbandman 588930 588930 Curteys, Richard, of Honyng, husbandman 0
3733802 1936825 1936825 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3733804 1936826 1936826 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3735508 1937345 1937345 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3747570 1941157 1941157 defendant Parker John gent 588930 588930 Parker, John, of Honyng, gent 0
3747572 1941157 1941157 defendant Foster John husbandman 588930 588930 Foster, John, of Honyng, husbandman 2
3747573 1941157 1941157 defendant Chapman Thomas husbandman 588930 588930 Chapman, Thomas, of Honyng, husbandman 3
3750418 1942050 1942050 defendant Deynes William yeoman 588930 588930 Deynes, William, of Honyng, yeoman 0
3756390 1943970 1943970 defendant Prowdlove Peter clerk 588930 588930 Prowdlove, Peter, of Honyng, clerk 0
3758997 1944801 1944801 defendant Ryall Peter   588930 588930 Ryall, Peter, of Honyng, worsted weaver 4
3761446 1945593 1945593 defendant Foster John husbandman 588930 588930 Foster, John, of Honyng, husbandman 1
3789698 1954608 1954608 defendant Prowdelowe Peter clerk 588930 588930 Prowdelowe, Peter, of Honyng, clerk 0
3791187 1955076 1955076 defendant Garnys Richard   588930 588930 Garnys, Richard, of Honyng, worsted weaver 0
3794406 1956126 1956126 defendant Riell Peter   588930 588930 Riell, Peter, of Honyng, worsted weaver 3
3807470 1960241 1960241 defendant Thorn Thomas gent 588930 588930 Thorn, Thomas, of Honyng, gent 0
3807577 1960276 1960276 defendant Andrews Thomas   588930 588930 Andrews, Thomas, of Honyng, worsted weaver 4
3819745 1964056 1964056 defendant Thorne Thomas yeoman 588930 588930 Thorne, Thomas, of Honyng, yeoman 2
3821936 1964754 1964754 defendant Coke Roger husbandman 588930 588930 Coke, Roger, of Honyng, husbandman 1
3833895 1968538 1968538 defendant Sower Thomas husbandman 588930 588930 Sower, Thomas, of Honyng, husbandman 1
3836770 1969399 1969399 defendant Benyngton Thomas husbandman 588930 588930 Benyngton, Thomas, of Honyng, husbandman 1
3849258 1973361 1973361 defendant Thorne Thomas gent 588930 588930 Thorne, Thomas, of Honyng, gent 0
3849354 1973395 1973395 defendant Coke Roger husbandman 588930 588930 Coke, Roger, of Honyng, husbandman 1
3873957 1981512 1981512 defendant Thorne Thomas yeoman 588930 588930 Thorne, Thomas, of Honyng, yeoman 1
3882668 1984467 1984467 defendant Chamber John miller 588930 588930 Chamber, John, of Honyng, miller 1
3891528 1987431 1987431 defendant Thaxter William husbandman 588930 588930 Thaxter, William, of Honyng, husbandman 1
3907454 1992787 1992787 plaintiff Parker John (legal representative) 588930 588930 Parker, John, of Honyng, gent, executor of 0
3907457 1992788 1992788 plaintiff Parker John (legal representative) 588930 588930 Parker, John, of Honyng, gent, executor of 0
3913455 1994836 1994836 defendant Deynes George gent 588930 588930 Deynes, George, of Honyng, gent 0
3925596 1998873 1998873 defendant Fox Henry   588930 588930 Fox, Henry, of Honyng, worsted weaver 4
3951184 2007482 2007482 defendant Skyrwyth William husbandman 588930 588930 Skyrwyth, William, of Honyng, husbandman 3
3951189 2007483 2007483 defendant Skyrwyth William husbandman 588930 588930 Skyrwyth, William, of Honyng, husbandman 3
3963602 2011880 2011880 defendant Argent Ralph tailor 588930 588930 Argent, Ralph, of Honyng, tailor 1
3974781 2015742 2015742 defendant Tante or Taute John husbandman 588930 588930 Tante or Taute, John, of Honyng, husbandman 1
3984256 2019134 2019134 defendant Heydon William esq 588930 588930 Heydon, William, of Honyng, esq 0
3993205 2022314 2022314 defendant Elwarde Charles yeoman 588930 588930 Elwarde, Charles, of Honyng, yeoman 0
3998310 2024138 2024138 defendant Elward Charles yeoman 588930 588930 Elward, Charles, of of Honyng, yeoman 3
4014503 2029912 2029912 defendant Elward Charles yeoman 588930 588930 Elward, Charles, of Honyng, yeoman 1
4014507 2029913 2029913 defendant Elwarde Charles yeoman 588930 588930 Elwarde, Charles, of Honyng, yeoman 1
4029265 2035113 2035113 defendant Sall Peter   588930 588930 Sall, Peter, of Honyng, worsted weaver 1
4039481 2038744 2038744 defendant Ryvett John yeoman 588930 588930 Ryvett, John, of Honyng, yeoman 0
4039482 2038744 2038744 defendant Aylward Charles yeoman 588930 588930 Aylward, Charles, of Honyng, yeoman 1
4052993 2043504 2043504 defendant Ryvers John clerk 588930 588930 Ryvers, John, of Honyng, clerk 6
4061922 2046662 2046662 defendant Sutton Robert husbandman 588930 588930 Sutton, Robert, of Honyng, husbandman 1
4080493 2053336 2053336 defendant Mussell Thomas butcher 588930 588930 Mussell, Thomas, of Honyng, butcher 0
4080494 2053336 2053336 defendant Blythe Henry thatcher 588930 588930 Blythe, Henry, of Honyng, thatcher 1
4082363 2054000 2054000 defendant Fayerman John husbandman 588930 588930 Fayerman, John, of Honyng, husbandman 0
4082364 2054000 2054000 defendant Chambers William husbandman 588930 588930 Chambers, William, of Honyng, husbandman 1
4082365 2054000 2054000 defendant Shale Nicholas husbandman 588930 588930 Shale, Nicholas, of Honyng, husbandman 2
4086290 2055370 2055370 defendant Martyns Thomas husbandman 588930 588930 Martyns, Thomas, of Honyng, husbandman 1
4104938 2062043 2062043 defendant Bradfylde Henry (legal representative) 588930 588930 Bradfylde, Henry, of Honyng, yeoman, executrix of 0
4104939 2062043 2062043 defendant Bradfylde Margaret widow 588930 588930 Bradfylde, Margaret, of Honyng, widow 1
4111176 2064249 2064249 defendant Shale Nicholas husbandman 588930 588930 Shale, Nicholas, of Honyng, husbandman 3
4111180 2064250 2064250 defendant Martyns Thomas husbandman 588930 588930 Martyns, Thomas, of Honyng, husbandman 2
4111767 2064459 2064459 defendant Francke Robert husbandman 588930 588930 Francke, Robert, of Honyng, husbandman 0
4149429 2077927 2077927 defendant Coventre James husbandman 588930 588930 Coventre, James, of Honyng, husbandman 3
4162144 2082315 2082315 defendant Newman John husbandman 588930 588930 Newman, John, of Honyng, husbandman 2
4197405 2094648 2094648 defendant Tant John yeoman 588930 588930 Tant, John, of Honyng, yeoman 0
4199457 2095359 2095359 defendant Gurney William gent 588930 588930 Gurney, William, of Honyng, gent 0
4220050 2102512 2102512 defendant Musset Thomas butcher 588930 588930 Musset, Thomas, of Honyng, butcher 0
4228952 2105608 2105608 defendant Mussett or Muffett Thomas butcher 588930 588930 Mussett or Muffett, Thomas, of Honyng, butcher 0
4253140 2114048 2114048 defendant Norgate Edmund yeoman 588930 588930 Norgate, Edmund, of Honyng, yeoman 0
4383865 2159307 2159307 defendant Norgate Edmund yeoman 588930 588930 Norgate, Edmund, of Honyng, yeoman 1
4454374 2186381 2186381 defendant Meryman John   588930 588930 Meryman, John, of Honyng 13
4459388 2187988 2187988 plaintiff Rustyng Edmund   588930 588930 Rustyng, Edmund, of Honyng 0
4459389 2187988 2187988 defendant Bintyng Nicholas   588930 588930 Bintyng, Nicholas, of Honyng 0
4459390 2187988 2187988 defendant Buntyng Edmund   588930 588930 Buntyng, Edmund, of Honyng 1
4499147 2200377 2200377 defendant Child John   588930 588930 Child, John, of Honyng 0
4531108 2210007 2210007 defendant Sket John   588930 588930 Sket, John, of Honyng 1
4544561 2214214 2214214 plaintiff Baxtere John   588930 588930 Baxtere, John, of Honyng 0
4560757 2219317 2219317 defendant Rustyng John   588930 588930 Rustyng, John, of Honyng 0
4572264 2222867 2222867 defendant Elfeld John   588930 588930 Elfeld, John, of Honyng 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);