names

74 rows where place_id = 591675

✎ 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
3605196 1869290 1869290 defendant Lamberd John husbandman 591675 591675 Lamberd, John, of Hoo juxta Est Derham, husbandman 0
3605203 1869293 1869293 defendant Lamberd John husbandman 591675 591675 Lamberd, John, of Hoo juxta Est Derham, husbandman 0
3638372 1906820 1906820 defendant Warner John husbandman 591675 591675 Warner, John, of Hoo juxta Est Derham, husbandman 0
3638374 1906821 1906821 defendant Warner John husbandman 591675 591675 Warner, John, of Hoo juxta Est Derham, husbandman 0
3645012 1908847 1908847 defendant Clubbe John   591675 591675 Clubbe, John, of Hoo juxta Est Derham, worsted weaver 0
3647302 1909541 1909541 defendant Pakeman Thomas   591675 591675 Pakeman, Thomas, of Hoo juxta Est Derham, notary 0
3685478 1921610 1921610 defendant Dacche Thomas husbandman 591675 591675 Dacche, Thomas, of Hoo juxta Est Derham, husbandman 0
3689574 1922896 1922896 defendant Pakeman Thomas gent 591675 591675 Pakeman, Thomas, of Hoo juxta Est Derham, gent 2
3698622 1925782 1925782 plaintiff Warner John   591675 591675 Warner, John, of Hoo juxta Est Derham 0
3704138 1927588 1927588 defendant Pakeman Thomas gent 591675 591675 Pakeman, Thomas, of Hoo juxta Est Derham, gent 0
3712222 1930134 1930134 defendant Darby Edmund husbandman 591675 591675 Darby, Edmund, of Hoo juxta Est Derham, husbandman 0
3723241 1933540 1933540 defendant Brese John tailor 591675 591675 Brese, John, of Hoo juxta Est Derham, tailor 0
3727514 1934884 1934884 defendant Shortyng Robert carpenter 591675 591675 Shortyng, Robert, of Hoo juxta Est Derham, carpenter 0
3734945 1937164 1937164 defendant Pakeman Thomas gent 591675 591675 Pakeman, Thomas, of Hoo juxta Est Derham, gent 6
3762992 1946055 1946055 defendant Clerke William husbandman 591675 591675 Clerke, William, of Hoo juxta Est Derham, husbandman 3
3774864 1949868 1949868 plaintiff Barker Richard gent 591675 591675 Barker, Richard, of Hoo juxta est Derham, gent 0
3808901 1960663 1960663 defendant Doraunt Walter yeoman 591675 591675 Doraunt, Walter, of Hoo juxta Est Derham, yeoman 0
3814967 1962600 1962600 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 0
3824267 1965464 1965464 defendant Hakes John weaver 591675 591675 Hakes, John, of Hoo juxta Est Derham, weaver 1
3824289 1965468 1965468 defendant Barker Richard yeoman 591675 591675 Barker, Richard, of Hoo juxta Est Derham, yeoman 2
3828835 1966898 1966898 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 0
3828837 1966899 1966899 defendant Shortyng Gilbert carpenter 591675 591675 Shortyng, Gilbert, of Hoo juxta Est Derham, carpenter 0
3828894 1966917 1966917 defendant Shortyng Gilbert carpenter 591675 591675 Shortyng, Gilbert, of Hoo juxta Est Derham, carpenter 0
3829203 1967017 1967017 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 0
3829204 1967017 1967017 defendant Noriche Walter brickburner 591675 591675 Noriche, Walter, of Hoo juxta Est Derham, brickburner 1
3830120 1967320 1967320 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta est Derham, husbandman 1
3830123 1967320 1967320 defendant Johnson John husbandman 591675 591675 Johnson, John, of Hoo juxta Est Derham, husbandman 4
3833824 1968510 1968510 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 2
3839101 1970151 1970151 defendant Wyget Thomas husbandman 591675 591675 Wyget, Thomas, of Hoo juxta Est Derham, husbandman 0
3843739 1971573 1971573 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 0
3844164 1971724 1971724 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 0
3844303 1971769 1971769 defendant Wygott Robert husbandman 591675 591675 Wygott, Robert, of Hoo juxta Est Derham, husbandman 0
3844304 1971769 1971769 defendant Smalle Richard husbandman 591675 591675 Smalle, Richard, of Hoo juxta Est Derham, husbandman 1
3845425 1972130 1972130 defendant Wygett Thomas husbandman 591675 591675 Wygett, Thomas, of Hoo juxta Est Derham, husbandman 0
3845426 1972130 1972130 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 1
3845436 1972132 1972132 defendant Wygett Thomas husbandman 591675 591675 Wygett, Thomas, of Hoo juxta Est Derham, husbandman 0
3845437 1972132 1972132 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 1
3853257 1974638 1974638 defendant Symondys Thomas husbandman 591675 591675 Symondys, Thomas, of Hoo juxta Est Derham, husbandman 0
3855473 1975356 1975356 plaintiff Warner Thomas   591675 591675 Warner, Thomas, of Hoo juxta Est Derham 0
3856540 1975673 1975673 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 0
3858050 1976168 1976168 defendant Clerke William   591675 591675 Clerke, William, of Hoo juxta Est Derham, shepherd 0
3861110 1977195 1977195 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 1
3869337 1979987 1979987 defendant Doraunt Walter husbandman 591675 591675 Doraunt, Walter, of Hoo juxta Est Derham, husbandman 2
3870388 1980342 1980342 defendant Bache Thomas husbandman 591675 591675 Bache, Thomas, of Hoo juxta Est Derham, husbandman 0
3872149 1980916 1980916 defendant Warne Thomas husbandman 591675 591675 Warne, Thomas, of Hoo juxta Est Derham, husbandman 0
3872257 1980945 1980945 defendant Clerke William   591675 591675 Clerke, William, of Hoo juxta Est Derham, shepherd 0
3875777 1982151 1982151 defendant Batche Thomas husbandman 591675 591675 Batche, Thomas, of Hoo juxta Est Derham, husbandman 0
3875778 1982151 1982151 defendant Wygett Thomas husbandman 591675 591675 Wygett, Thomas, of Hoo juxta Est Derham, husbandman 1
3887582 1986097 1986097 defendant Barker Richard gent 591675 591675 Barker, Richard, of Hoo juxta Est Derham, gent 0
3887584 1986098 1986098 defendant Barker Richard gent 591675 591675 Barker, Richard, of Hoo juxta Est Derham, gent 0
3896916 1989180 1989180 defendant Barker Richard gent 591675 591675 Barker, Richard, of Hoo juxta Est Derham, gent 0
3896918 1989181 1989181 defendant Barker Richard yeoman 591675 591675 Barker, Richard, of Hoo juxta Est Derham, yeoman 0
3896922 1989183 1989183 plaintiff Warner Thomas   591675 591675 Warner, Thomas, of Hoo juxta Est Derham 0
3898725 1989779 1989779 defendant Shetyll William miller 591675 591675 Shetyll, William, of Hoo juxta Est Derham, miller 0
3901555 1990744 1990744 defendant Barker Richard gent 591675 591675 Barker, Richard, of Hoo juxta Est Derham, gent 0
3907781 1992886 1992886 defendant Hawes Thomas husbandman 591675 591675 Hawes, Thomas, of Hoo juxta est Derham, husbandman 3
3907974 1992958 1992958 defendant Barker Richard gent 591675 591675 Barker, Richard, of Hoo juxta Est Derham, gent 0
3911300 1994096 1994096 defendant Barker Richard gent 591675 591675 Barker, Richard, of Hoo juxta Est Derham, gent 0
3911306 1994097 1994097 defendant Wygott Thomas husbandman 591675 591675 Wygott, Thomas, of Hoo juxta Est Derham, husbandman 4
3911313 1994100 1994100 plaintiff Warner Thomas   591675 591675 Warner, Thomas, of Hoo juxta Est Derham 0
3911315 1994101 1994101 plaintiff Warner Thomas   591675 591675 Warner, Thomas, of Hoo juxta Est Derham 0
3911317 1994102 1994102 plaintiff Warner Thomas   591675 591675 Warner, Thomas, of Hoo juxta Est Derham 0
3913930 1995005 1995005 defendant Husbond John husbandman 591675 591675 Husbond, John, of Hoo juxta Est Derham, husbandman 0
3923206 1998072 1998072 defendant Wygett Thomas husbandman 591675 591675 Wygett, Thomas, of Hoo juxta Est Derham, husbandman 0
3962114 2011330 2011330 defendant Shetyll Thomas yeoman 591675 591675 Shetyll, Thomas, of Hoo juxta Est Derham, yeoman 0
3970663 2014327 2014327 plaintiff Deye Thomas   591675 591675 Deye, Thomas, of Hoo juxta Est Derham 0
3972008 2014768 2014768 defendant Brytyffe Simon   591675 591675 Brytyffe, Simon, of Hoo juxta Est Derham, brick maker 1
3985014 2019398 2019398 defendant Brytyffe Simon   591675 591675 Brytyffe, Simon, of Hoo juxta Est Derham, brick maker 0
4023559 2033135 2033135 defendant Brytyff John husbandman 591675 591675 Brytyff, John, of Hoo juxta Est Derham, husbandman 0
4045192 2040735 2040735 defendant Brytyff Simon   591675 591675 Brytyff, Simon, of Hoo juxta Est Derham, brick maker 0
4195883 2094115 2094115 defendant Bone Thomas laborer 591675 591675 Bone, Thomas, of Hoo juxta Est Derham, laborer 2
4232803 2106979 2106979 defendant Heyward Henry gent 591675 591675 Heyward, Henry, of Hoo juxta Est Derham, gent 0
4946496 2340898 2340898 plaintiff Ketilston William   591675 591675 Ketilston, William, of Hoo juxta Est Derham 0
4979642 2350866 2350866 defendant Manser Simon husbandman 591675 591675 Manser, Simon, of Hoo juxta Est Derham, husbandman 2

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