names

64 rows where place_id = 617530

✎ 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
3719974 1932517 1932517 defendant Munson John weaver 617530 617530 Munson, John, of Naylond, weaver 0
3721620 1933061 1933061 defendant Hamond Thomasine widow 617530 617530 Hamond, Thomasine, of Naylond, widow 1
3728800 1935254 1935254 defendant Malle John clothier 617530 617530 Malle, John, of Naylond, clothier 2
3728811 1935257 1935257 defendant Abell John, junior   617530 617530 Abell, John, junior, of Naylond, merchant, administrators of 0
3729248 1935398 1935398 defendant Sutton Thomas sherman 617530 617530 Sutton, Thomas, of Naylond, sherman 1
3730238 1935685 1935685 defendant Abell John, junior   617530 617530 Abell, John, junior, of Naylond, merchant, administrators of 0
3730241 1935686 1935686 defendant Abell John, junior   617530 617530 Abell, John, junior, of Naylond, merchant, administrators of 0
3734289 1936962 1936962 defendant Abell Edmund clothmaker 617530 617530 Abell, Edmund, of Naylond, clothmaker 1
3734291 1936962 1936962 defendant Barnard John, junior husbandman 617530 617530 Barnard, John, junior, of Naylond, husbandman 3
3736365 1937616 1937616 defendant Turnour Robert butcher 617530 617530 Turnour, Robert, of Naylond, butcher 3
3740050 1938743 1938743 defendant Gege John butcher 617530 617530 Gege, John, of Naylond, butcher 0
3740052 1938744 1938744 defendant Gege John butcher 617530 617530 Gege, John, of Naylond, butcher 0
3746706 1940883 1940883 plaintiff Cowper Robert clothmaker 617530 617530 Cowper, Robert, of Naylond, clothmaker 0
3758412 1944625 1944625 defendant Colman Thomas yeoman 617530 617530 Colman, Thomas, of Naylond, yeoman 0
3758416 1944627 1944627 defendant Colman Thomas yeoman 617530 617530 Colman, Thomas, of Naylond, yeoman 0
3773974 1949576 1949576 plaintiff Abell John (legal representative) 617530 617530 Abell, John, of Naylond, clothmaker, executor of 0
3803116 1958877 1958877 plaintiff Pygott Richard (legal representative) 617530 617530 Pygott, Richard, of Naylond, clothmaker, executors of 0
3803122 1958878 1958878 plaintiff Pygott Richard (legal representative) 617530 617530 Pygott, Richard, of Naylond, clothmaker, executors of 0
3811093 1961366 1961366 plaintiff Byrde John shoemaker 617530 617530 Byrde, John, of Naylond, shoemaker 0
3812512 1961801 1961801 plaintiff Cowper Robert clothmaker 617530 617530 Cowper, Robert, of Naylond, clothmaker 0
3829531 1967124 1967124 defendant Pygott Anthony clothier 617530 617530 Pygott, Anthony, of Naylond, clothier 0
3829569 1967139 1967139 defendant Fryth Thomas (legal representative) 617530 617530 Fryth, Thomas, of Naylond, clothmaker, executrix of 0
3832159 1967969 1967969 defendant Wryght John   617530 617530 Wryght, John, of Naylond, mason 0
3833864 1968525 1968525 defendant Ranam Stephen yeoman 617530 617530 Ranam, Stephen, of Naylond, yeoman 0
3837591 1969665 1969665 defendant Sowle William carrier 617530 617530 Sowle, William, of Naylond, carrier 2
3839003 1970126 1970126 defendant Baker John weaver 617530 617530 Baker, John, of Naylond, weaver 1
3839005 1970126 1970126 defendant Baldwyn Robert   617530 617530 Baldwyn, Robert, of Naylond, horse courser 3
3840982 1970749 1970749 defendant Long Thomas   617530 617530 Long, Thomas, of Naylond, wax chandler 0
3852474 1974381 1974381 defendant Taylour Martin sherman 617530 617530 Taylour, Martin, of Naylond, sherman 1
3852708 1974455 1974455 defendant Abell Richard (legal representative) 617530 617530 Abell, Richard, of Naylond, executors of 0
3852709 1974455 1974455 defendant Merellys John yeoman 617530 617530 (Merellys, John, of Naylond, yeoman 1
3867092 1979232 1979232 defendant Abell Richard (legal representative) 617530 617530 Abell, Richard, of Naylond, executors of 0
3867093 1979232 1979232 defendant Merellys John yeoman 617530 617530 (Merellys, John, of Naylond, yeoman 1
3869546 1980057 1980057 defendant Wryght William   617530 617530 Wryght, William, of Naylond, surgeon 2
3869547 1980057 1980057 defendant Pygott William barber 617530 617530 Pygott, William, of Naylond, barber 3
3872270 1980950 1980950 defendant Haddam James weaver 617530 617530 Haddam, James, of Naylond, weaver 1
3874786 1981785 1981785 defendant Spede Alice widow 617530 617530 Spede, Alice, of Naylond, widow 3
3877066 1982571 1982571 defendant Tompson Richard clothmaker 617530 617530 Tompson, Richard, of Naylond, clothmaker 0
3877068 1982571 1982571 defendant Rutter Christopher clothmaker 617530 617530 Rutter, Christopher, of Naylond, clothmaker 2
3877069 1982571 1982571 defendant Holton John clothier 617530 617530 Holton, John, of Naylond, clothier 3
3898087 1989570 1989570 defendant Roos Edward gent 617530 617530 Roos, Edward, of Naylond, gent 0
3915011 1995374 1995374 defendant Danyell John fuller 617530 617530 Danyell, John, of Naylond, fuller 0
3915012 1995374 1995374 defendant Browne Robert carpenter 617530 617530 Browne, Robert, of Naylond, carpenter 1
3929206 2000111 2000111 defendant Brett Henry husbandman 617530 617530 Brett, Henry, of Naylond, husbandman 0
3929208 2000111 2000111 defendant Wode Henry laborer 617530 617530 Wode, Henry, of Naylond, laborer 2
3929209 2000111 2000111 defendant Sonyer John laborer 617530 617530 Sonyer, John, of Naylond, laborer 3
3987860 2020404 2020404 defendant Preston Elizabeth widow 617530 617530 Elizabeth his wife, formerly Elizabeth Coppyn, of Naylond, widow 1
4115510 2065834 2065834 defendant Wade John, junior laborer 617530 617530 Wade, John, junior, of Naylond, laborer 1
4119315 2067203 2067203 defendant Maull George clothier 617530 617530 Maull, George, of Naylond, clothier 0
4119316 2067203 2067203 defendant Maull James clothier 617530 617530 Maull, James, of Naylond, clothier 1
4131632 2071633 2071633 defendant Maull George clothier 617530 617530 Maull, George, of Naylond, clothier 0
4197899 2094816 2094816 defendant Webbe Robert tanner 617530 617530 Webbe, Robert, of Naylond, tanner 0
4201726 2096149 2096149 defendant Thurmoode Robert sherman 617530 617530 Thurmoode, Robert, of Naylond, or of Hadleighe, sherman 2
4238760 2109176 2109176 defendant Maslyn Richard   617530 617530 Maslyn, Richard, of Naylond butcher 0
4244091 2111006 2111006 defendant Taylar James Suff, yeoman 617530 617530 Taylar James, of Naylond, Suff, yeoman 0
4268054 2118932 2118932 defendant Myns John clothier 617530 617530 Myns, John, of Naylond, clothier 2
4384373 2159465 2159465 defendant Smyth Thomas miller 617530 617530 Smyth, Thomas, of Naylond, miller 0
4384376 2159466 2159466 defendant Smythe Thomas miller 617530 617530 Smythe, Thomas, of Naylond, miller 0
4384377 2159466 2159466 defendant Boston William yeoman 617530 617530 Boston, William, of Naylond, yeoman 1
4407003 2166900 2166900 defendant Bennytt John blacksmith 617530 617530 Bennytt, John, of Naylond, blacksmith 2
5385558 2470939 2470939 defendant Smyth Jacob yeoman 617530 617530 Smyth, Jacob, of Naylond, yeoman 0
5485989 2500697 2500697 plaintiff Reygnham Robert clothmaker 617530 617530 Reygnham, Robert, of Naylond, clothmaker 0
5526356 2512820 2512820 defendant Pryour John weaver 617530 617530 Pryour, John, of Naylond, weaver 4
5581395 2529249 2529249 defendant Aylward Thomas smith 617530 617530 Aylward, Thomas, of Naylond, smith 4

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);