names

144 rows where place_id = 590079

✎ 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
3599809 1867586 1867586 defendant Larke William butcher 590079 590079 Larke, William, of Cranebroke, Kent, butcher 0
3599812 1867587 1867587 defendant Larke William butcher 590079 590079 Larke, William, of Cranebroke, Kent, butcher 0
3601596 1868155 1868155 defendant Lane John yeoman 590079 590079 Lane, John, of Cranebroke, Kent, yeoman 1
3607332 1869955 1869955 defendant Herenden James yeoman 590079 590079 Herenden, James, of Cranebroke, Kent, yeoman 0
3612743 1871634 1871634 defendant Herenden James yeoman 590079 590079 Herenden, James, of Cranebroke, Kent, yeoman 0
3617916 1873228 1873228 defendant Yonge John clothmaker 590079 590079 Yonge, John, of Cranebroke, Kent, clothmaker 0
3626032 1902999 1902999 defendant Coushman or Conshman Simon weaver 590079 590079 Coushman or Conshman, Simon, of Cranebroke, Kent, weaver 1
3649516 1910237 1910237 defendant Bregger William clothman 590079 590079 Bregger, William, of Cranebroke, Kent, clothman 0
3670839 1916845 1916845 defendant Bysshop John clothman 590079 590079 Bysshop, John, of Cranebroke, Kent, clothman 1
3691723 1923571 1923571 defendant Cowcheman Robert clothman 590079 590079 Cowcheman, Robert, of Cranebroke, Kent, clothman 0
3702788 1927145 1927145 defendant Dowle John shoemaker 590079 590079 Dowle, John, of Cranebroke, Kent, shoemaker 0
3706011 1928171 1928171 defendant Sheffe John clothman 590079 590079 Sheffe, John, of Cranebroke, Kent, clothman 0
3711419 1929876 1929876 defendant Carkerege Lawrence clothman 590079 590079 Carkerege, Lawrence, of Cranebroke, Kent, clothman 1
3722310 1933239 1933239 defendant Nasshe Thomas weaver 590079 590079 Nasshe, Thomas, of Cranebroke, Kent, weaver 0
3730824 1935868 1935868 defendant Penell Richard clothman 590079 590079 Penell, Richard, of Cranebroke, Kent, clothman 0
3739045 1938418 1938418 defendant Taylour John yeoman 590079 590079 Taylour, John, of Cranebroke, Kent, yeoman 1
3751664 1942436 1942436 defendant Taillour John yeoman 590079 590079 Taillour, John, of Cranebroke, Kent, yeoman 1
3764951 1946700 1946700 defendant Androwe Giles clothier 590079 590079 Androwe, Giles, of Cranebroke, Kent, clothier 0
3782637 1952312 1952312 defendant Wardaker John clothier 590079 590079 Wardaker, John, of Cranebroke, Kent, clothier 1
3782643 1952313 1952313 defendant Wardaker John clothier 590079 590079 Wardaker, John, of Cranebroke, Kent, clothier 1
3783896 1952736 1952736 defendant Austen Henry chapman 590079 590079 Austen, Henry, of Cranebroke, Kent, chapman 2
3787494 1953878 1953878 defendant Robertys Thomas gent 590079 590079 Robertys, Thomas, of Cranebroke, Kent, gent 2
3800350 1958028 1958028 defendant Netter William clothman 590079 590079 Netter, William, of Cranebroke, Kent, clothman 1
3800361 1958030 1958030 defendant Awsten Henry chapman 590079 590079 Awsten, Henry, of Cranebroke, Kent, chapman 2
3800364 1958031 1958031 defendant Nettar William clothman 590079 590079 Nettar, William, of Cranebroke, Kent, clothman 1
3800752 1958148 1958148 defendant Carterych Lawrence clothier 590079 590079 Carterych, Lawrence, of Cranebroke, Kent, clothier 1
3800756 1958149 1958149 defendant Cartryche Lawrence clothier 590079 590079 Cartryche, Lawrence, of Cranebroke, Kent, clothier 1
3803772 1959093 1959093 defendant Robertys Thomas gent 590079 590079 Robertys, Thomas, of Cranebroke, Kent, gent 2
3810400 1961142 1961142 defendant Davy Thomas clothier 590079 590079 Davy, Thomas, of Cranebroke, Kent, clothier 1
3811088 1961364 1961364 defendant Skeff Richard clothman 590079 590079 Skeff, Richard, of Cranebroke, Kent, clothman 0
3811970 1961651 1961651 defendant Eggylston John butcher 590079 590079 Eggylston, John, of Cranebroke, Kent, butcher 0
3814560 1962466 1962466 defendant Cart Thomas clothier 590079 590079 Cart, Thomas, of Cranebroke, Kent, clothier 2
3815538 1962774 1962774 defendant Arnold John yeoman 590079 590079 Arnold, John, of Cranebroke, Kent, yeoman 0
3819685 1964038 1964038 defendant Katt Thomas clothman 590079 590079 Katt, Thomas, of Cranebroke, Kent, clothman 0
3822963 1965090 1965090 defendant Sheff John clothier 590079 590079 Sheff, John, of Cranebroke, Kent, clothier 0
3831749 1967830 1967830 defendant Ware John yeoman 590079 590079 Ware, John, of Cranebroke, Kent, yeoman 4
3832482 1968081 1968081 defendant Catte Thomas clothier 590079 590079 Catte, Thomas, of Cranebroke, Kent, clothier 0
3834931 1968862 1968862 defendant Davy Thomas yeoman 590079 590079 Davy, Thomas, of Cranebroke, Kent, yeoman 1
3835571 1969063 1969063 defendant Wilford Thomas esq 590079 590079 Wilford, Thomas, of Cranebroke, Kent, esq 0
3838786 1970059 1970059 defendant Davy Thomas yeoman 590079 590079 Davy, Thomas, of Cranebroke, Kent, yeoman 0
3842159 1971096 1971096 defendant Olford Roger yeoman 590079 590079 (Olford, Roger, of Cranebroke, Kent, yeoman 1
3842163 1971097 1971097 defendant Olforde Roger yeoman 590079 590079 (Olforde, Roger, of Cranebroke, Kent, yeoman 1
3859493 1976664 1976664 plaintiff Chetynden Matthew butcher 590079 590079 Chetynden, Matthew, of Cranebroke, Kent, butcher 0
3864857 1978447 1978447 defendant Ledys James clothier 590079 590079 Ledys, James, of Cranebroke, Kent, clothier 1
3868413 1979673 1979673 defendant Pette Hugh clothier 590079 590079 Pette, Hugh, of Cranebroke, Kent, clothier 1
3870579 1980401 1980401 defendant Love John clothier 590079 590079 Love, John, of Cranebroke, Kent, clothier 0
3872671 1981076 1981076 defendant Scranton Simon clothmaker 590079 590079 Scranton, Simon, of Cranebroke, Kent, clothmaker 2
3877637 1982761 1982761 defendant Smyth Thomas clothier 590079 590079 Smyth, Thomas, of Cranebroke, Kent, clothier 0
3878550 1983071 1983071 defendant Brykenden William clothier 590079 590079 Brykenden, William, of Cranebroke, Kent, clothier 1
3879108 1983263 1983263 defendant Peene John clothier 590079 590079 Peene, John, of Cranebroke, Kent, clothier 2
3880419 1983706 1983706 defendant Halford Roger gent 590079 590079 Halford, Roger, of Cranebroke, Kent, gent 3
3881024 1983922 1983922 defendant Sheffe John yeoman 590079 590079 Sheffe, John, of Cranebroke, Kent, yeoman 0
3886338 1985685 1985685 defendant Henley Walter clothmaker 590079 590079 Henley, Walter, of Cranebroke, Kent, clothmaker 0
3887062 1985938 1985938 defendant Bechyng John clothier 590079 590079 Bechyng, John, of Cranebroke, Kent, clothier 2
3887069 1985939 1985939 defendant Bechyng John clothier 590079 590079 Bechyng, John, of Cranebroke, Kent, clothier 2
3888705 1986479 1986479 defendant Chetynden Matthew butcher 590079 590079 (Chetynden, Matthew, of Cranebroke, Kent, butcher 1
3891350 1987374 1987374 defendant Draner Thomas gent 590079 590079 Draner, Thomas, of Cranebroke, Kent, gent 0
3891472 1987414 1987414 defendant Burre Thomas yeoman and clothmaker 590079 590079 Burre, Thomas, of Cranebroke, Kent, yeoman and clothmaker 4
3894982 1988530 1988530 plaintiff Sharpe John clothier 590079 590079 Sharpe, John, of Cranebroke, Kent, clothier 0
3895890 1988833 1988833 defendant Sharpe Thomas clothier 590079 590079 Sharpe, Thomas, of Cranebroke, Kent, clothier 1
3898655 1989758 1989758 defendant Love John chapman 590079 590079 Love, John, of Cranebroke, Kent, chapman 2
3900064 1990243 1990243 defendant Roberd Thomas esq 590079 590079 Roberd, Thomas, of Cranebroke, Kent, esq 0
3901948 1990879 1990879 plaintiff Davye Thomas merchant 590079 590079 Davye, Thomas, of Cranebroke, Kent, merchant 0
3905714 1992189 1992189 defendant Weller Richard clothier 590079 590079 Weller, Richard, of Cranebroke, Kent, clothier 0
3905940 1992271 1992271 defendant Collyar Richard clothier 590079 590079 Collyar, Richard, of Cranebroke, Kent, clothier 0
3906508 1992468 1992468 defendant Wilforde Thomas esq 590079 590079 Wilforde, Thomas, of Cranebroke, Kent, esq 0
3910780 1993927 1993927 defendant Robertys Thomas esq 590079 590079 Robertys, Thomas, of Cranebroke, Kent, esq 0
3914867 1995321 1995321 defendant Bigg Gervase clothmaker 590079 590079 Bigg, Gervase, of Cranebroke, Kent, clothmaker 0
3915223 1995453 1995453 plaintiff Courtopp John clothier 590079 590079 Courtopp, John, of Cranebroke, Kent, clothier 0
3925508 1998843 1998843 defendant Skranton Simon clothier 590079 590079 Skranton, Simon, of Cranebroke, Kent, clothier 2
3964848 2012315 2012315 defendant Davyes Stephen gent 590079 590079 Davyes, Stephen, of Cranebroke, Kent, gent 0
3979281 2017338 2017338 defendant Harman John clothier 590079 590079 Harman, John, of Cranebroke, Kent, clothier 0
3999143 2024452 2024452 defendant Davies Stephen merchant 590079 590079 Davies, Stephen, of Cranebroke, Kent, merchant 0
4013158 2029437 2029437 defendant Dens Alexander clothier 590079 590079 Dens, Alexander, of Cranebroke, Kent, clothier 0
4013291 2029487 2029487 defendant Davys Stephen merchant 590079 590079 Davys, Stephen, of Cranebroke, Kent, merchant 0
4029141 2035065 2035065 plaintiff Cryppes John ewaver 590079 590079 Cryppes, John, of Cranebroke, Kent, ewaver 0
4058773 2045530 2045530 defendant Myles Christopher clothier 590079 590079 Myles, Christopher, of Cranebroke, Kent, clothier 0
4072185 2050352 2050352 plaintiff Odye Hugh clothier 590079 590079 Odye, Hugh, of Cranebroke, Kent, clothier 0
4106306 2062544 2062544 defendant Portryffe Thomas yeoman 590079 590079 Portryffe, Thomas, of Cranebroke, Kent, yeoman 1
4106310 2062545 2062545 defendant Portryffe Thomas yeoman 590079 590079 Portryffe, Thomas, of Cranebroke, Kent, yeoman 1
4106311 2062545 2062545 defendant Kylsden Henry clothier 590079 590079 Kylsden, Henry, of Cranebroke, Kent, clothier 2
4145494 2076582 2076582 defendant Love John gent 590079 590079 Love, John, of Cranebroke, Kent, gent 0
4206754 2097903 2097903 defendant Cowchman Alexander clothier 590079 590079 Cowchman, Alexander, of Cranebroke, Kent, clothier 1
4298581 2129599 2129599 defendant Tull John yeoman 590079 590079 Tull, John, of Cranebroke, Kent, yeoman 0
4615117 2235738 2235738 defendant Cardere Richard   590079 590079 Cardere, Richard, of Cranebroke, Kent 0
4651793 2246512 2246512 defendant Stevenys William clerk 590079 590079 Stevenys, William, of Cranebroke, Kent, clerk 8
4784636 2291201 2291201 defendant Lynche William chapman 590079 590079 Lynche, William, of Cranebroke, Kent, chapman 0
4784641 2291202 2291202 defendant Lynche William chapman 590079 590079 Lynche, William, of Cranebroke, Kent, chapman 0
4785671 2291548 2291548 defendant Curtynden William   590079 590079 together with Curtynden, William, of Cranebroke, Kent, groom 1
4791510 2293440 2293440 defendant Lycnhe William chapman 590079 590079 Lycnhe, William, of Cranebroke, Kent, chapman 0
4795907 2294870 2294870 defendant Watte John chapman 590079 590079 Watte, John, of Cranebroke, Kent, chapman 1
4795913 2294871 2294871 defendant Watte John chapman 590079 590079 Watte, John, of Cranebroke, Kent, chapman 1
4895268 2325179 2325179 defendant Cardere Stephen chapman 590079 590079 Cardere, Stephen, of Cranebroke, Kent, chapman 2
4904510 2328019 2328019 defendant atte Wode John husbandman 590079 590079 atte Wode, John, of Cranebroke, Kent, husbandman 0
4935313 2337446 2337446 defendant Godard William husbandman 590079 590079 Godard, William, of Cranebroke, Kent, husbandman 0
4935360 2337456 2337456 defendant Bettenham John gent 590079 590079 Bettenham, John, of Cranebroke, Kent, gent 0
4944591 2340291 2340291 defendant Joly John husbandman 590079 590079 Joly, John, of Cranebroke, Kent, husbandman 0
4973938 2349167 2349167 defendant Synkeden Richard dyer 590079 590079 Synkeden, Richard, of Cranebroke, Kent, dyer 0
5017871 2362111 2362111 defendant Middelton Thomas skinner 590079 590079 Middelton, Thomas, of Cranebroke, Kent, skinner 0
5110310 2389421 2389421 defendant Bettenham Henry gent 590079 590079 Bettenham, Henry, of Cranebroke, Kent, 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);