names

483 rows where place_id = 589412

✎ 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
3597576 1866867 1866867 defendant Tagge John yeoman 589412 589412 Tagge, John, of Pynchebek, yeoman 0
3597589 1866871 1866871 defendant Tagge John yeoman 589412 589412 Tagge, John, of Pynchebek, yeoman 0
3607114 1869891 1869891 plaintiff Pynchebek Richard (legal representative) 589412 589412 Pynchebek, Richard, of Pynchebek, esq, administrator of 0
3608815 1870418 1870418 defendant Pyunchebek Thomas esq 589412 589412 Pyunchebek, Thomas, of Pynchebek, esq 0
3611782 1871351 1871351 defendant Soule Robert husbandman 589412 589412 Soule, Robert, of Pynchebek, husbandman 0
3619534 1873678 1873678 plaintiff Johnson Simon   589412 589412 Johnson, Simon, of Pynchebek 1
3619535 1873678 1873678 plaintiff Harllewyn John   589412 589412 Harllewyn, John, of Pynchebek 2
3620674 1874044 1874044 defendant Breche John barber 589412 589412 Breche, John, of Pynchebek, barber 0
3620675 1874044 1874044 defendant Fraunce Thomas husbandman 589412 589412 Fraunce, Thomas, of Pynchebek, husbandman 1
3620676 1874044 1874044 defendant Glover William husbandman 589412 589412 Glover, William, of Pynchebek, husbandman 2
3620677 1874044 1874044 defendant Fraunce John yeoman 589412 589412 Fraunce, John, of Pynchebek, yeoman 3
3620908 1874102 1874102 defendant Almond William roper 589412 589412 Almond, William, of Pynchebek, roper 1
3624772 1875283 1875283 defendant Sykylbryce Thomas gent 589412 589412 Sykylbryce, Thomas, of Pynchebek, gent 0
3626869 1903254 1903254 defendant Holande Robert yeoman 589412 589412 Holande, Robert, of Pynchebek, yeoman 0
3634186 1905494 1905494 defendant Chatours John roper 589412 589412 Chatours, John, of Pynchebek, roper 3
3652903 1911233 1911233 defendant Holond Robert husbandman 589412 589412 Holond, Robert, of Pynchebek, husbandman 5
3666439 1915454 1915454 defendant Russell Thomas carpenter 589412 589412 Russell, Thomas, of Pynchebek, carpenter 2
3669331 1916346 1916346 defendant Mesam Thomas laborer 589412 589412 Mesam, Thomas, of Pynchebek, laborer 0
3669332 1916346 1916346 defendant Love Alice widow 589412 589412 Love, Alice, of Pynchebek, widow 1
3669855 1916517 1916517 defendant Nunne John laborer 589412 589412 Nunne, John, of Pynchebek, laborer 0
3672389 1917367 1917367 defendant Gune Thomas   589412 589412 Gune, Thomas, of Pynchebek, flax chapman 0
3672458 1917385 1917385 defendant Hyatt John husbandman 589412 589412 Hyatt, John, of Pynchebek, husbandman 0
3672710 1917468 1917468 defendant Pedder Thomas laborer 589412 589412 Pedder, Thomas, of Pynchebek, laborer 0
3681738 1920385 1920385 defendant Pynchebek Gilbert esq 589412 589412 Pynchebek, Gilbert, of Pynchebek, esq 0
3686166 1921837 1921837 defendant Pynchebek Gilbert esq 589412 589412 Pynchebek, Gilbert, of Pynchebek, esq 0
3686955 1922086 1922086 defendant Pynchebek Gilbert esq 589412 589412 Pynchebek, Gilbert, of Pynchebek, esq 0
3703977 1927527 1927527 defendant Pynchebek Gilbert esq 589412 589412 Pynchebek, Gilbert, of Pynchebek, esq 0
3706532 1928327 1928327 defendant Dere Robert yeoman 589412 589412 Dere, Robert, of Pynchebek, yeoman 0
3709325 1929213 1929213 plaintiff Prest John   589412 589412 Prest, John, of Pynchebek 0
3714511 1930835 1930835 defendant Toche William husbandman 589412 589412 Toche, William, of Pynchebek, husbandman 0
3716446 1931436 1931436 defendant Pate John waterman 589412 589412 Pate, John, of Pynchebek, waterman 2
3726314 1934500 1934500 defendant Russell Thomas carpenter 589412 589412 Russell, Thomas, of Pynchebek, carpenter 1
3732789 1936484 1936484 defendant Russell Thomas, senior carpenter 589412 589412 Russell, Thomas, senior, of Pynchebek, carpenter 0
3750800 1942175 1942175 plaintiff Maynard John (legal representative) 589412 589412 Maynard, John, of Pynchebek, yeoman, executors of 0
3760406 1945258 1945258 defendant Russell William carpenter 589412 589412 Russell, William, of Pynchebek, carpenter 0
3761020 1945450 1945450 plaintiff Durbage Thomas (legal representative) 589412 589412 Durbage, Thomas, of Pynchebek, executor of 0
3767949 1947612 1947612 defendant Awsyn William husbandman 589412 589412 Awsyn, William, of Pynchebek, husbandman 0
3767951 1947612 1947612 defendant Thorpe William husbandman 589412 589412 Thorpe, William, of Pynchebek, husbandman 2
3770745 1948537 1948537 defendant Durbag Robert husbandman 589412 589412 Durbag, Robert, of Pynchebek, husbandman 0
3774099 1949613 1949613 defendant Cawthrop John husbandman 589412 589412 Cawthrop, John, of Pynchebek, husbandman 0
3778471 1950982 1950982 defendant Calthorpe John husbandman 589412 589412 Calthorpe, John, of Pynchebek, husbandman 0
3784546 1952954 1952954 plaintiff Maynard John (legal representative) 589412 589412 Maynard, John, of Pynchebek, yeoman, executors of 0
3791874 1955304 1955304 defendant Calthrop John husbandman 589412 589412 Calthrop, John, of Pynchebek, husbandman 0
3795800 1956553 1956553 defendant Atkynson Robert husbandman 589412 589412 Atkynson, Robert, of Pynchebek, husbandman 4
3799273 1957686 1957686 defendant Toche William husbandman 589412 589412 Toche, William, of Pynchebek, husbandman 0
3807370 1960212 1960212 defendant White Ralph flaxman 589412 589412 White, Ralph, of Pynchebek, flaxman 0
3807371 1960212 1960212 defendant Moller Richard flaxman 589412 589412 Moller, Richard, of Pynchebek, flaxman 1
3808406 1960505 1960505 defendant Calthorp John husbandman 589412 589412 Calthorp, John, of Pynchebek, husbandman 0
3812776 1961890 1961890 defendant Rede Richard husbandman 589412 589412 Rede, Richard, of Pynchebek, husbandman 0
3812777 1961890 1961890 defendant Wright John laborer 589412 589412 Wright, John, of Pynchebek, laborer 1
3822981 1965096 1965096 defendant Russell Thomas carpenter 589412 589412 Russell, Thomas, of Pynchebek, carpenter 1
3825608 1965861 1965861 defendant Linoln Robert husbandman 589412 589412 Linoln, Robert, of Pynchebek, husbandman 0
3825609 1965861 1965861 defendant Chaters William roper 589412 589412 Chaters, William, of Pynchebek, roper 1
3825610 1965861 1965861 defendant Wright John husbandman 589412 589412 Wright, John, of Pynchebek, husbandman 2
3836503 1969324 1969324 defendant Walpole Robert gent 589412 589412 Walpole, Robert, of Pynchebek, gent 0
3839435 1970258 1970258 defendant Sikilprice Robert yeoman 589412 589412 Sikilprice, Robert, of Pynchebek, yeoman 0
3840034 1970449 1970449 defendant Yong John husbandman 589412 589412 Yong, John, of Pynchebek, husbandman 0
3841705 1970989 1970989 defendant Almond Richard smith 589412 589412 Almond, Richard, of Pynchebek, smith 0
3844434 1971809 1971809 plaintiff Cust Hugh (legal representative) 589412 589412 Cust, Hugh, of Pynchebek, yeoman, executors of 0
3851054 1973922 1973922 defendant Bathe Richard yeoman 589412 589412 Bathe, Richard, of Pynchebek, yeoman 0
3851055 1973922 1973922 defendant Pedder Robert husbandman 589412 589412 Pedder, Robert, of Pynchebek, husbandman 1
3851056 1973922 1973922 defendant Storer Richard husbandman 589412 589412 Storer, Richard, of Pynchebek, husbandman 2
3858039 1976164 1976164 defendant Levesey William laborer 589412 589412 Levesey, William, of Pynchebek, laborer 0
3860336 1976958 1976958 plaintiff Cust Hugh (legal representative) 589412 589412 Cust, Hugh, of Pynchebek, yeoman, executors of 0
3862589 1977683 1977683 defendant Sykylprice Robert yeoman 589412 589412 Sykylprice, Robert, of Pynchebek, yeoman 0
3862590 1977683 1977683 defendant Sykylprice Simon husbandman 589412 589412 Sykylprice, Simon, of Pynchebek, husbandman 1
3862591 1977683 1977683 defendant Sykylprice Nicholas laborer 589412 589412 Sykylprice, Nicholas, of Pynchebek, laborer 2
3862593 1977684 1977684 defendant Sykylprice Simon husbandman 589412 589412 Sykylprice, Simon, of Pynchebek, husbandman 0
3862594 1977684 1977684 defendant Sykylprice Nicholas laborer 589412 589412 Sykylprice, Nicholas, of Pynchebek, laborer 1
3862595 1977684 1977684 defendant Sykylprice Robert yeoman 589412 589412 Sykylprice, Robert, of Pynchebek, yeoman 2
3870925 1980524 1980524 defendant Laughton Thomas thatcher 589412 589412 Laughton, Thomas, of Pynchebek, thatcher 0
3873520 1981359 1981359 defendant Harlewyn Robert husbandman 589412 589412 Harlewyn, Robert, of Pynchebek, husbandman 0
3874888 1981823 1981823 defendant Pytterell John husbandman 589412 589412 Pytterell, John, of Pynchebek, husbandman 0
3875988 1982220 1982220 defendant Promall James husbandman 589412 589412 Promall, James, of Pynchebek, husbandman 0
3877900 1982851 1982851 defendant Jenkynson Thomas laborer 589412 589412 Jenkynson, Thomas, of Pynchebek, laborer 0
3879119 1983267 1983267 defendant Preste John yeoman 589412 589412 Preste, John, of Pynchebek, yeoman 0
3883028 1984590 1984590 defendant Love Thomas husbandman 589412 589412 Love, Thomas, of Pynchebek, husbandman 0
3883029 1984590 1984590 defendant Love Robert husbandman 589412 589412 Love, Robert, of Pynchebek, husbandman 1
3887189 1985980 1985980 defendant Webster John husbandman 589412 589412 Webster, John, of Pynchebek, husbandman 0
3892833 1987852 1987852 defendant Glover Henry husbandman 589412 589412 Glover, Henry, of Pynchebek, husbandman 2
3892834 1987852 1987852 defendant Soule Robert husbandman 589412 589412 Soule, Robert, of Pynchebek, husbandman 3
3895289 1988631 1988631 defendant Prentall James husbandman 589412 589412 Prentall, James, of Pynchebek, husbandman 0
3898604 1989741 1989741 defendant Marchaunt John yeoman 589412 589412 Marchaunt, John, of Pynchebek, yeoman 0
3899359 1989997 1989997 defendant Marchaunt John yeoman 589412 589412 Marchaunt, John, of Pynchebek, yeoman 0
3899578 1990078 1990078 defendant Sayle Robert yeoman 589412 589412 Sayle, Robert, of Pynchebek, yeoman 0
3901226 1990636 1990636 defendant Webster John husbandman 589412 589412 Webster, John, of Pynchebek, husbandman 0
3902414 1991037 1991037 defendant Hodylston Robert yeoman 589412 589412 Hodylston, Robert, of Pynchebek, yeoman 0
3911128 1994049 1994049 plaintiff Walpole Thomas chaplain 589412 589412 Walpole, Thomas, of Pynchebek, chaplain 0
3924055 1998356 1998356 plaintiff Sykylpryce Edward yeoman 589412 589412 (Sykylpryce, Edward, of Pynchebek, yeoman 1
3924056 1998356 1998356 plaintiff Sykylpryce Nicholas yeoman 589412 589412 Sykylpryce, Nicholas, of Pynchebek, yeoman 2
3930747 2000633 2000633 defendant Grove Margaret widow 589412 589412 Grove, Margaret, of Pynchebek, widow 0
3937441 2002857 2002857 plaintiff Ogle Richard gent 589412 589412 Ogle, Richard, of Pynchebek, gent 0
3940991 2003994 2003994 plaintiff Ogle Richard esq 589412 589412 (Ogle, Richard, of Pynchebek, esq 1
3951547 2007596 2007596 defendant Croke Geoffrey husbandman 589412 589412 Croke, Geoffrey, of Pynchebek, husbandman 0
3951549 2007597 2007597 defendant Russell Arnold husbandman 589412 589412 Russell, Arnold, of Pynchebek, husbandman 0
3975435 2015973 2015973 defendant Skygg Robert yeoman 589412 589412 Skygg, Robert, of Pynchebek, yeoman 0
3992948 2022234 2022234 defendant Fletcher William husbandman 589412 589412 Fletcher, William, of Pynchebek, husbandman 1
3994732 2022869 2022869 defendant Rede Robert yeoman 589412 589412 Rede, Robert, of Pynchebek, yeoman 1
3994734 2022870 2022870 plaintiff Colvell John esq 589412 589412 Colvell, John, of Pynchebek, esq 0
3994736 2022871 2022871 plaintiff Colvell John gent 589412 589412 Colvell, John, of Pynchebek, gent 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);