names

182 rows where place_id = 588844

✎ 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
3595762 1866307 1866307 defendant Cok John husbandman 588844 588844 Cok, John, of Banham, husbandman 2
3642745 1908178 1908178 defendant Canne James chapman 588844 588844 Canne, James, of Banham, chapman 1
3662501 1914187 1914187 defendant Colby Thomas husbandman 588844 588844 Colby, Thomas, of Banham, husbandman 0
3677323 1918957 1918957 defendant Neve John husbandman 588844 588844 Neve, John, of Banham, husbandman 0
3684117 1921169 1921169 defendant Bexster Robert husbandman 588844 588844 Bexster, Robert, of Banham, husbandman 0
3684118 1921169 1921169 defendant Chapman Thomas husbandman 588844 588844 Chapman, Thomas, of Banham, husbandman 1
3687424 1922244 1922244 defendant Colby Thomas husbandman 588844 588844 Colby, Thomas, of Banham, husbandman 1
3687463 1922257 1922257 defendant Colby William husbandman 588844 588844 Colby, William, of Banham, husbandman 1
3689760 1922954 1922954 defendant Neve Robert butcher 588844 588844 Neve, Robert, of Banham, butcher 3
3693347 1924133 1924133 defendant Dexter Robert husbandman 588844 588844 Dexter, Robert, of Banham, husbandman 1
3693986 1924321 1924321 defendant Cuttyng Roger husbandman 588844 588844 Cuttyng, Roger, of Banham, husbandman 0
3693987 1924321 1924321 defendant Cuttyng Thomas husbandman 588844 588844 Cuttyng, Thomas, of Banham, husbandman 1
3702459 1927030 1927030 defendant Glover William husbandman 588844 588844 Glover, William, of Banham, husbandman 2
3702460 1927030 1927030 defendant Eyre Robert husbandman 588844 588844 Eyre, Robert, of Banham, husbandman 3
3709604 1929313 1929313 defendant Downyng Robert husbandman 588844 588844 Downyng, Robert, of Banham, husbandman 0
3712323 1930171 1930171 defendant Neve Robert butcher 588844 588844 Neve, Robert, of Banham, butcher 0
3712325 1930171 1930171 defendant Colby William gent 588844 588844 Colby, William, of Banham, gent 2
3749114 1941653 1941653 defendant Neve Robert butcher 588844 588844 Neve, Robert, of Banham, butcher 0
3759391 1944926 1944926 plaintiff Clerke John   588844 588844 Clerke, John, of Banham 0
3759412 1944933 1944933 defendant Walman Richard husbandman 588844 588844 Walman, Richard, of Banham, husbandman 1
3759417 1944934 1944934 defendant Clerk Robert husbandman 588844 588844 Clerk, Robert, of Banham, husbandman 0
3763734 1946303 1946303 defendant Neve Robert butcher 588844 588844 Neve, Robert, of Banham, butcher 0
3766235 1947093 1947093 defendant Colby William husbandman 588844 588844 Colby, William, of Banham, husbandman 0
3767559 1947490 1947490 defendant Chamberleyn Henry husbandman 588844 588844 Chamberleyn, Henry, of Banham, husbandman 0
3767560 1947490 1947490 defendant Buk Simon laborer 588844 588844 Buk, Simon, of Banham, laborer 1
3767561 1947490 1947490 defendant Roper Thomas husbandman 588844 588844 Roper, Thomas, of Banham, husbandman 2
3767564 1947491 1947491 defendant Downyng Robert yeoman 588844 588844 Downyng, Robert, of Banham, yeoman 0
3783298 1952527 1952527 defendant Neve Edward husbandman 588844 588844 Neve, Edward, of Banham, husbandman 3
3794710 1956221 1956221 defendant Buk Simon husbandman 588844 588844 Buk, Simon, of Banham, husbandman 0
3794711 1956221 1956221 defendant Cuttyng Thomas husbandman 588844 588844 Cuttyng, Thomas, of Banham, husbandman 1
3794712 1956221 1956221 defendant Dexter Robert carpenter 588844 588844 Dexter, Robert, of Banham, carpenter 2
3803534 1959012 1959012 defendant Snowe John   588844 588844 Snowe, John, of Banham, brick maker 1
3811788 1961587 1961587 defendant Wyth Henry husbandman 588844 588844 Wyth, Henry, of Banham, husbandman 1
3814471 1962440 1962440 defendant Downyng Robert yeoman 588844 588844 Downyng, Robert, of Banham, yeoman 0
3828160 1966674 1966674 defendant Cane alias Ploughman John butcher 588844 588844 Cane alias Ploughman, John, of Banham, butcher 1
3828164 1966676 1966676 defendant Cuttyng Roger husbandman 588844 588844 Cuttyng, Roger, of Banham, husbandman 0
3828165 1966676 1966676 defendant Cuttyng Thomas husbandman 588844 588844 Cuttyng, Thomas, of Banham, husbandman 1
3828616 1966828 1966828 defendant Gent Reginald husbandman 588844 588844 Gent, Reginald, of Banham, husbandman 1
3833459 1968395 1968395 defendant Cotney Rowland clerk 588844 588844 Cotney, Rowland, of Banham, clerk 0
3838980 1970120 1970120 defendant Grymston William gent 588844 588844 Grymston, William, of Banham, gent 0
3843506 1971506 1971506 plaintiff Clerke Thomas   588844 588844 Clerke, Thomas, of Banham 0
3851801 1974153 1974153 plaintiff Plowman Isabel (legal representative) 588844 588844 Plowman, Isabel, of Banham, widow, executors of 0
3851803 1974153 1974153 plaintiff Downyng John   588844 588844 Downyng, John, of Banham 2
3851804 1974153 1974153 defendant Canne at Grene Thomas husbandman 588844 588844 Canne at Grene, Thomas, of Banham, husbandman 0
3855462 1975351 1975351 defendant Colby William yeoman 588844 588844 Colby, William, of Banham, yeoman 0
3859236 1976581 1976581 defendant Colby William yeoman 588844 588844 Colby, William, of Banham, yeoman 0
3859260 1976590 1976590 defendant Churcheman Agnes widow 588844 588844 Churcheman, Agnes, of Banham, widow 2
3866925 1979177 1979177 defendant Glover William husbandman 588844 588844 Glover, William, of Banham, husbandman 0
3873817 1981464 1981464 plaintiff Clerke Thomas   588844 588844 Clerke, Thomas, of Banham 0
3873818 1981464 1981464 defendant Jamys William husbandman 588844 588844 Jamys, William, of Banham, husbandman 0
3873819 1981465 1981465 plaintiff Clerke Thomas   588844 588844 Clerke, Thomas, of Banham 0
3873824 1981466 1981466 plaintiff Clerke Thomas   588844 588844 Clerke, Thomas, of Banham 0
3891493 1987421 1987421 plaintiff Lebald James   588844 588844 Lebald, James, of Banham 0
3894504 1988371 1988371 plaintiff Rouse Anne widow 588844 588844 Rouse, Anne, of Banham, widow 0
3901110 1990597 1990597 defendant Wolman Richard husbandman 588844 588844 Wolman, Richard, of Banham, husbandman 2
3901116 1990598 1990598 defendant Wolman Richard husbandman 588844 588844 Wolman, Richard,of Banham, husbandman 2
3903515 1991403 1991403 defendant Chamber John yeoman 588844 588844 Chamber, John, of Banham, yeoman 1
3903516 1991403 1991403 defendant Jamys Thomas yeoman 588844 588844 Jamys, Thomas, of Banham, yeoman 2
3908722 1993214 1993214 defendant Jamys Thomas   588844 588844 Jamys, Thomas, of Banham, wheelwright 0
3914632 1995237 1995237 plaintiff Catton Robert   588844 588844 Catton, Robert, of Banham 0
3922059 1997712 1997712 defendant Chamber John husbandman 588844 588844 Chamber, John, of Banham, husbandman 0
3938734 2003296 2003296 defendant Jamys Thomas husbandman 588844 588844 Jamys, Thomas, of Banham, husbandman 0
3938736 2003296 2003296 defendant Jamys William husbandman 588844 588844 Jamys, William, of Banham, husbandman 2
3941716 2004246 2004246 plaintiff Waller Robert   588844 588844 Waller, Robert, of Banham 0
3950893 2007378 2007378 defendant Kynge John miller 588844 588844 Kynge, John, of Banham, miller 0
3955187 2008879 2008879 defendant Luke Edward yeoman 588844 588844 Luke, Edward, of Banham, yeoman 0
3960312 2010701 2010701 defendant Ploughman alias Canne Thomas cooper 588844 588844 Ploughman alias Canne, Thomas, of Banham, cooper 0
3967528 2013276 2013276 defendant Ryche Richard husbandman 588844 588844 Ryche, Richard, of Banham, husbandman 4
3969693 2014006 2014006 defendant Pondemaker John embroiderer 588844 588844 Pondemaker, John, of Banham, embroiderer 2
3973511 2015305 2015305 defendant Nycols Lewis gent 588844 588844 Nycols, Lewis, of Banham, gent 0
3980661 2017848 2017848 defendant Clerke John weaver 588844 588844 Clerke, John, of Banham, weaver 0
3980662 2017848 2017848 defendant Parker William husbandman 588844 588844 Parker, William, of Banham, husbandman 1
3986477 2019907 2019907 defendant Parker William husbandman 588844 588844 Parker, William, of Banham, husbandman 0
3994154 2022660 2022660 plaintiff Clerke John   588844 588844 Clerke, John, of Banham 1
4052954 2043492 2043492 defendant Bullock William yeoman 588844 588844 Bullock, William, of Banham, yeoman 0
4063375 2047190 2047190 defendant Cuttyng John husbandman 588844 588844 Cuttyng, John, of Banham, husbandman 0
4081180 2053578 2053578 defendant Nobes Thomas carpenter 588844 588844 Nobes, Thomas, of Banham, carpenter 3
4103405 2061501 2061501 defendant Roffe or Rosse Thomas   588844 588844 Roffe or Rosse, Thomas, of Banham, pale maker 0
4106110 2062479 2062479 defendant Knolles John glasier 588844 588844 Knolles, John, of Banham, glasier 0
4119063 2067102 2067102 defendant Gyll Robert husbandman 588844 588844 Gyll, Robert, of Banham, husbandman 1
4119064 2067102 2067102 defendant Pondmaker John yeoman 588844 588844 Pondmaker, John, of Banham, yeoman 2
4144308 2076170 2076170 defendant Roberd John husbandman 588844 588844 Roberd, John, of Banham, husbandman 2
4146121 2076791 2076791 defendant Langden Clement yeoman 588844 588844 Langden, Clement, of Banham, yeoman 1
4184161 2089956 2089956 defendant Goldingham Thomas gent 588844 588844 Goldingham, Thomas, of Banham, gent 3
4184166 2089957 2089957 defendant Goldingham Thomas gent 588844 588844 Goldingham Thomas, of Banham, gent 3
4202275 2096336 2096336 defendant Warwell alias Warwycke Roland yeoman 588844 588844 Warwell alias Warwycke, Roland, of Banham, yeoman, son of Clement Warwycke, of Banham, yeoman 0
4205163 2097353 2097353 defendant Sporle Thomas yeoman 588844 588844 Sporle, Thomas, of Banham, yeoman 0
4205759 2097563 2097563 defendant Roberd William   588844 588844 Roberd, William, of Banham, surgeon 1
4212036 2099758 2099758 defendant Grene Edward gent 588844 588844 Grene, Edward, of Banham, gent 3
4213418 2100210 2100210 defendant Glamfyld Nicholas glover 588844 588844 Glamfyld, Nicholas, of Banham, glover 2
4214144 2100464 2100464 defendant Stone Henry husbandman 588844 588844 Stone, Henry, of Banham, husbandman 0
4214593 2100610 2100610 defendant Kynge John   588844 588844 Kynge, John, of Banham, shepherd 0
4214596 2100610 2100610 defendant Pyte Nicholas husbandman 588844 588844 Pyte, Nicholas, of Banham, husbandman 3
4214808 2100684 2100684 defendant Robart William   588844 588844 Robart, William, of Banham, surgeon 0
4214809 2100684 2100684 defendant Parker Edward weaver 588844 588844 Parker, Edward, of Banham, weaver 1
4223478 2103701 2103701 defendant Keene John   588844 588844 Keene, John, of Banham, linen weaver 1
4230817 2106277 2106277 defendant Cann Edward husbandman 588844 588844 Cann, Edward, of Banham, husbandman 0
4230818 2106277 2106277 defendant James William husbandman 588844 588844 James, William, of Banham, husbandman 1
4230819 2106277 2106277 defendant Cooper John husbandman 588844 588844 Cooper, John, of Banham, husbandman 2
4230820 2106277 2106277 defendant Dodson Peter husbandman 588844 588844 Dodson, Peter, of Banham, husbandman 3

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