names

576 rows where place_id = 588802

✎ 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
3595639 1866262 1866262 plaintiff Milleward Richard   588802 588802 Milleward, Richard, of Wotton 0
3636550 1906226 1906226 defendant Baggeworth John husbandman 588802 588802 Baggeworth, John, of Wotton, husbandman 0
3636551 1906226 1906226 defendant Baggeworth Richard husbandman 588802 588802 Baggeworth, Richard, of Wotton, husbandman 1
3636552 1906226 1906226 defendant Baggeworth Thomas husbandman 588802 588802 Baggeworth, Thomas, of Wotton, husbandman 2
3636553 1906226 1906226 defendant Frankysh Henry husbandman 588802 588802 Frankysh, Henry, of Wotton, husbandman 3
3636566 1906229 1906229 defendant Clerke Thomas husbandman 588802 588802 Clerke, Thomas, of Wotton, husbandman 0
3636747 1906287 1906287 defendant Fermour William husbandman 588802 588802 Fermour, William, of Wotton, husbandman 2
3637057 1906388 1906388 defendant Redford Robert husbandman 588802 588802 Redford, Robert, of Wotton, husbandman 2
3641164 1907686 1907686 defendant Robyns William husbandman 588802 588802 Robyns, William, of Wotton, husbandman 1
3647430 1909584 1909584 defendant Howson John   588802 588802 Howson, John, of Wotton 0
3650584 1910550 1910550 defendant Rolfe William husbandman 588802 588802 Rolfe, William, of Wotton, husbandman 3
3652510 1911116 1911116 defendant Thakker Stephen husbandman 588802 588802 Thakker, Stephen, of Wotton, husbandman 0
3655964 1912115 1912115 defendant Bacheler Richard husbandman 588802 588802 Bacheler, Richard, of Wotton, husbandman 0
3655966 1912116 1912116 defendant Bacheler Richard husbandman 588802 588802 Bacheler, Richard, of Wotton, husbandman 0
3663709 1914585 1914585 defendant Bageworthe Richard husbandman 588802 588802 Bageworthe, Richard, of Wotton, Gloucester, husbandman 0
3670210 1916630 1916630 defendant Baskerfeld Richard dyer 588802 588802 Baskerfeld, Richard, of Wotton under Ege, dyer 0
3670211 1916630 1916630 defendant Harfeld George baker 588802 588802 Harfeld, George, of Wotton under Ege, baker 1
3670212 1916630 1916630 defendant Yonge Edward   588802 588802 Yonge, Edward, of Wotton under Ege, card maker 2
3670552 1916753 1916753 defendant Bacheler Richard husbandman 588802 588802 Bacheler, Richard, of Wotton, husbandman 0
3677123 1918887 1918887 defendant Sherd John husbandman 588802 588802 Sherd, John, of Wotton, husbandman 0
3687710 1922324 1922324 defendant Robyns Richard weaver 588802 588802 Robyns, Richard, of Wotton under Egge, weaver 0
3687712 1922324 1922324 defendant Dane James weaver 588802 588802 Dane, James, of Wotton under Egge, weaver 2
3697670 1925494 1925494 defendant Coppyng John husbandman 588802 588802 Coppyng, John, of Wotton, husbandman 1
3711350 1929856 1929856 defendant Robyns Richard weaver 588802 588802 Robyns, Richard, of Wotton under Egge, weaver 0
3712316 1930169 1930169 defendant Horne Richard husbandman 588802 588802 Horne, Richard, of Wotton, husbandman 0
3713222 1930440 1930440 defendant Horne Richard gent 588802 588802 Horne, Richard, of Wotton, gent 0
3713687 1930578 1930578 defendant Stambregge Richard husbandman 588802 588802 Stambregge, Richard, of Wotton, husbandman 1
3713688 1930578 1930578 defendant Crawley Richard husbandman 588802 588802 Crawley, Richard, of Wotton, husbandman 2
3714335 1930781 1930781 defendant Hopley Richard husbandman 588802 588802 Hopley, Richard, of Wotton, husbandman 1
3727156 1934765 1934765 defendant Harresfeld George husbandman 588802 588802 Harresfeld, George, of Wotton, husbandman 0
3735628 1937376 1937376 defendant Robyns Richard weaver 588802 588802 Robyns, Richard, of Wotton under Egge, weaver 1
3739632 1938611 1938611 defendant Estman William husbandman 588802 588802 Estman, William, of Wotton, husbandman 0
3751654 1942433 1942433 defendant Lee Humphrey yeoman 588802 588802 Lee, Humphrey, of Wotton, yeoman 0
3751655 1942433 1942433 defendant Redford Robert husbandman 588802 588802 Redford, Robert, of Wotton, husbandman 1
3753029 1942883 1942883 defendant Case Thomas yeoman 588802 588802 Case, Thomas, of Wotton, yeoman 0
3761754 1945687 1945687 defendant Smyth Robert husbandman 588802 588802 Smyth, Robert, of Wotton, husbandman 1
3765908 1947002 1947002 defendant Plomer Joan widow 588802 588802 Plomer, Joan, of Wotton under Edge, widow 0
3766991 1947343 1947343 defendant Swanne Thomas   588802 588802 Swanne, Thomas, of Wotton under Egge, wax chandler 0
3766992 1947343 1947343 defendant Baskerffeld Richard dyer 588802 588802 Baskerffeld, Richard, of Wotton under Egge, dyer 1
3782561 1952288 1952288 defendant Lane William husbandman 588802 588802 Lane, William, of Wotton, husbandman 1
3782562 1952288 1952288 defendant Coke Christopher husbandman 588802 588802 Coke, Christopher, of Wotton, husbandman 2
3783877 1952729 1952729 defendant Jamys Robert weaver 588802 588802 Jamys, Robert, of Wotton under Egge, weaver 0
3785764 1953336 1953336 defendant Lee Humphrey yeoman 588802 588802 Lee, Humphrey, of Wotton, yeoman 0
3785765 1953336 1953336 defendant Redford Robert husbandman 588802 588802 Redford, Robert, of Wotton, husbandman 1
3792099 1955383 1955383 defendant Browne Edith widow 588802 588802 Browne, Edith, of Wotton under Hedge, widow 0
3799227 1957672 1957672 defendant Tukker Richard tucker or clothier 588802 588802 Tukker, Richard, of Wotton under Egge, tucker or clothier 0
3799447 1957745 1957745 defendant Tully Joan widow 588802 588802 Tully, Joan, of Wotton, widow 0
3799448 1957745 1957745 defendant Farnnewell Richard husbandman 588802 588802 Farnnewell, Richard, of Wotton, husbandman 1
3802527 1958686 1958686 defendant Abek John innholder 588802 588802 Abek, John, of Wotton under Egge, innholder 0
3810875 1961305 1961305 defendant Agnalun alias Aglyn Morgan tucker 588802 588802 Agnalun alias Aglyn, Morgan, of Wotton, tucker 0
3816739 1963141 1963141 defendant Bundell John husbandman 588802 588802 Bundell, John, of Wotton, husbandman 1
3816741 1963141 1963141 defendant Burley William laborer 588802 588802 Burley, William, of Wotton, laborer 3
3817177 1963285 1963285 defendant Fryer William husbandman 588802 588802 Fryer, William, of Wotton, husbandman 2
3820474 1964288 1964288 defendant Leye Richard yeoman 588802 588802 Leye, Richard, of Wotton, yeoman 0
3821013 1964464 1964464 defendant Farmewell Richard husbandman 588802 588802 Farmewell, Richard, of Wotton, husbandman 0
3821534 1964632 1964632 defendant Barnard Thomas husbandman 588802 588802 Barnard, Thomas, of Wotton, husbandman 0
3821536 1964632 1964632 defendant Smyth Robert husbandman 588802 588802 Smyth, Robert, of Wotton, husbandman 2
3822098 1964805 1964805 defendant Sebourne John, junior clothman 588802 588802 Sebourne, John, junior, of Wotton, clothman 1
3822102 1964806 1964806 defendant Sebourne John, junior clothman 588802 588802 Sebourne, John, junior, of Wotton, clothman 1
3829054 1966968 1966968 plaintiff Coppyng William   588802 588802 Coppyng, William, of Wotton 0
3833314 1968347 1968347 defendant Fenne William fuller 588802 588802 Fenne, William, of Wotton, fuller 2
3834072 1968596 1968596 defendant Fen William husbandman 588802 588802 Fen, William, of Wotton, husbandman 0
3835396 1969009 1969009 defendant Smyth Richard baker 588802 588802 Smyth, Richard, of Wotton under Edge, baker 0
3837773 1969729 1969729 defendant Ryckman Richard clothier 588802 588802 Ryckman, Richard, of Wotton under Egge, clothier 0
3844796 1971917 1971917 defendant Alford Margery widow 588802 588802 Alford, Margery, of Wotton, widow 0
3848970 1973273 1973273 defendant Brytwell John husbandman 588802 588802 Brytwell, John, of Wotton, husbandman 0
3848971 1973273 1973273 defendant Brytwell William husbandman 588802 588802 Brytwell, William, of Wotton, husbandman 1
3848972 1973273 1973273 defendant Wytson John husbandman 588802 588802 Wytson, John, of Wotton, husbandman 2
3853018 1974564 1974564 defendant Smythe Robert husbandman 588802 588802 Smythe, Robert, of Wotton, husbandman 0
3853019 1974564 1974564 defendant Barnard Richard husbandman 588802 588802 Barnard, Richard, of Wotton, husbandman 1
3853287 1974648 1974648 defendant Crake John yeoman 588802 588802 Crake, John, of Wotton, yeoman 1
3853290 1974649 1974649 defendant Kyng Thomas husbandman 588802 588802 Kyng, Thomas, of Wotton, husbandman 0
3862285 1977574 1977574 defendant Toppyng Michael clerk 588802 588802 Toppyng, Michael, of Wotton Ryver, clerk 0
3866749 1979115 1979115 defendant Andrewes John husbandman 588802 588802 Andrewes, John, of Wotton, husbandman 0
3867803 1979463 1979463 defendant Barnard Richard husbandman 588802 588802 Barnard, Richard, of Wotton, husbandman 0
3871416 1980688 1980688 defendant Denney Edward husbandman 588802 588802 Denney, Edward, of Wotton, husbandman 1
3878514 1983057 1983057 defendant Bacon Robert shoemaker 588802 588802 Bacon, Robert, of Wotton, shoemaker 4
3884850 1985205 1985205 defendant Browne Edith widow 588802 588802 Browne, Edith, of Wotton, widow 0
3892955 1987889 1987889 defendant Dalton Emery husbandman 588802 588802 Dalton, Emery, of Wotton, husbandman 1
3892956 1987889 1987889 defendant Bacheler John husbandman 588802 588802 Bacheler, John, of Wotton, husbandman 2
3910011 1993655 1993655 defendant Mason John butcher 588802 588802 Mason, John, of Wotton, butcher 0
3910322 1993770 1993770 defendant West Reginald clerk 588802 588802 West, Reginald, of Wotton, clerk 0
3911088 1994035 1994035 defendant Bernard Richard husbandman 588802 588802 Bernard, Richard, of Wotton, husbandman 0
3911089 1994035 1994035 defendant Markham Richard husbandman 588802 588802 Markham, Richard, of Wotton, husbandman 1
3911090 1994035 1994035 defendant Stevynson William laborer 588802 588802 Stevynson, William, of Wotton, laborer 2
3912763 1994600 1994600 defendant Browne Edith widow 588802 588802 Browne, Edith, of Wotton under Hedge, widow 0
3916354 1995853 1995853 defendant Coppyng William yeoman 588802 588802 Coppyng, William, of Wotton, yeoman 3
3919060 1996699 1996699 defendant Colwyll William clothier 588802 588802 Colwyll, William, of Wotton under Hege, clothier 1
3919061 1996699 1996699 defendant Byrton Richard weaver 588802 588802 Byrton, Richard, of Wotton under Hege, weaver 2
3919260 1996772 1996772 defendant Austyn Robert chaplain 588802 588802 Austyn, Robert, of Wotton, chaplain 0
3919601 1996887 1996887 defendant Slowe William   588802 588802 Slowe, William, of Wotton, brick maker 0
3919961 1997015 1997015 defendant Byrton Richard weaver 588802 588802 Byrton, Richard, of Wotton under Hedge, weaver 0
3919962 1997015 1997015 defendant Huishe Thomas weaver 588802 588802 Huishe, Thomas, of Wotton under Hedge, weaver 1
3925749 1998927 1998927 plaintiff Wyllett Thomas yeoman 588802 588802 Wyllett, Thomas, of Wotton, yeoman 0
3932075 2001032 2001032 defendant Dyer John butcher 588802 588802 Dyer, John, of Wotton, butcher 0
3933835 2001612 2001612 defendant Oliver Roger husbandman 588802 588802 Oliver, Roger, of Wotton, husbandman 0
3942560 2004522 2004522 defendant Brightwyn John husbandman 588802 588802 Brightwyn, John, of Wotton, husbandman 0
3950667 2007306 2007306 defendant Goslyn William husbandman 588802 588802 Goslyn, William, of Wotton, husbandman 2
3953084 2008144 2008144 defendant Dyer John butcher 588802 588802 Dyer, John, of Wotton, butcher 0
3953845 2008415 2008415 plaintiff Jones William weaver 588802 588802 Jones, William, of Wotton under Edge, weaver 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);