names

63 rows where place_id = 601616

✎ 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
3646257 1909219 1909219 defendant Badcok Richard brewer 601616 601616 Badcok, Richard, of Hawkeherst, brewer 2
3664515 1914852 1914852 defendant Grey Alexander tailor 601616 601616 Grey, Alexander, of Hawkeherst, tailor 0
3664522 1914855 1914855 defendant Broun John yeoman 601616 601616 Broun, John, of Hawkeherst, yeoman 0
3686363 1921893 1921893 defendant Jenkyn William husbandman 601616 601616 Jenkyn, William, of Hawkeherst, husbandman 0
3687330 1922216 1922216 defendant Tailour Robert yeoman 601616 601616 Tailour, Robert, of Hawkeherst, yeoman 1
3687331 1922216 1922216 defendant Basden William yeoman 601616 601616 Basden, William, of Hawkeherst, yeoman 2
3687895 1922376 1922376 defendant Dunke Thomas laborer 601616 601616 Dunke, Thomas, of Hawkeherst, laborer 0
3693852 1924278 1924278 defendant Whatman Thomas   601616 601616 Whatman, Thomas, of Hawkeherst, tallow chandler 0
3698812 1925846 1925846 defendant Graunte Robert husbandman 601616 601616 Graunte, Robert, of Hawkeherst, husbandman 5
3707795 1928737 1928737 defendant Bechyng Edward clothmaker 601616 601616 Bechyng, Edward, of Hawkeherst, clothmaker 0
3740638 1938934 1938934 defendant Congherst Edmund tailor 601616 601616 Congherst, Edmund, of Hawkeherst, tailor 0
3792894 1955631 1955631 defendant Stonestrete Stephen yeoman or ash burner 601616 601616 Stonestrete, Stephen, of Hawkeherst, yeoman or ash burner 1
3795714 1956528 1956528 defendant Wever James tanner 601616 601616 Wever, James, of Hawkeherst, tanner 0
3795716 1956528 1956528 defendant Peynde Thomas rippier 601616 601616 Peynde, Thomas, of Hawkeherst, rippier 2
3797215 1957011 1957011 defendant Hykmotte Richard mercer 601616 601616 Hykmotte, Richard, of Hawkeherst, mercer 0
3818693 1963749 1963749 defendant Congherst Edmund yeoman 601616 601616 Congherst, Edmund, of Hawkeherst, yeoman 0
3821039 1964472 1964472 defendant Benden Henry tanner 601616 601616 Benden, Henry, of Hawkeherst, tanner 0
3845829 1972249 1972249 defendant Robardis Henry tailor 601616 601616 Robardis, Henry, of Hawkeherst, tailor 0
3847742 1972866 1972866 defendant Seseley John, senior husbandman 601616 601616 Seseley, John, senior, of Hawkeherst, husbandman 1
3850150 1973637 1973637 defendant Scysseley John clothier 601616 601616 Scysseley, John, of Hawkeherst, clothier 0
3867463 1979354 1979354 plaintiff Scotte Thomas (legal representative) 601616 601616 Scotte, Thomas, of Hawkeherst, gent, executors of 0
3977596 2016733 2016733 defendant Sysley Thomas clothier 601616 601616 Sysley, Thomas, of Hawkeherst, clothier 1
3981772 2018238 2018238 defendant Robert Herbert merchant 601616 601616 Robert, Herbert, of Hawkeherst, merchant 0
4012514 2029197 2029197 defendant Dens William weaver 601616 601616 Dens, William, of Hawkeherst, weaver 0
4017028 2030793 2030793 plaintiff Syseley Henry clothier 601616 601616 Syseley, Henry, of Hawkeherst, clothier 0
4017029 2030793 2030793 defendant Syseley Thomas clothier 601616 601616 Syseley, Thomas, of Hawkeherst, clothier 0
4022750 2032860 2032860 defendant Everenden William husbandman 601616 601616 Everenden, William, of Hawkeherst, husbandman 0
4022752 2032861 2032861 defendant Everenden William husbandman 601616 601616 Everenden, William, of Hawkeherst, husbandman 0
4044749 2040569 2040569 defendant Seyslye Thomas clothier 601616 601616 Seyslye, Thomas, of Hawkeherst, clothier 0
4044758 2040574 2040574 plaintiff Roberth Edmund merchant 601616 601616 Roberth, Edmund, of Hawkeherst, merchant 0
4056085 2044564 2044564 defendant Vallans William shoemaker 601616 601616 Vallans, William, of Hawkeherst, shoemaker 0
4056086 2044564 2044564 defendant Spryngett William clothier 601616 601616 Spryngett, William, of Hawkeherst, clothier 1
4071761 2050200 2050200 defendant Sprynget Robert yeoman 601616 601616 Sprynget, Robert, of Hawkeherst, yeoman 0
4074973 2051350 2051350 defendant Buckherst Thomas clothier 601616 601616 Buckherst, Thomas, of Hawkeherst, clothier 0
4074975 2051351 2051351 defendant Syslye Thomas clothier 601616 601616 Syslye, Thomas, of Hawkeherst, clothier 0
4104056 2061724 2061724 defendant Dence William weaver 601616 601616 Dence, William, of Hawkeherst, weaver 0
4130348 2071163 2071163 defendant Mercer Henry husbandman 601616 601616 Mercer, Henry, of Hawkeherst, husbandman 0
4153796 2079428 2079428 defendant Mercer Henry husbandman 601616 601616 Mercer, Henry, of Hawkeherst, husbandman 0
4160806 2081856 2081856 defendant Buckherst Thomas clothier 601616 601616 Buckherst, Thomas, of Hawkeherst, clothier 1
4167729 2084204 2084204 defendant Graunt Zachary miller 601616 601616 Graunt, Zachary, of Hawkeherst, miller 0
4167783 2084221 2084221 defendant Sloweman Edward   601616 601616 Sloweman, Edward, of Hawkeherst, "ryppyer" or fishmonger 2
4168023 2084304 2084304 defendant Potten Robert yeoman 601616 601616 Potten, Robert, of Hawkeherst, yeoman 0
4168024 2084304 2084304 defendant Dennett Stephen husbandman 601616 601616 Dennett, Stephen, of Hawkeherst, husbandman 1
4168025 2084304 2084304 defendant Pyne Thomas husbandman 601616 601616 Pyne, Thomas, of Hawkeherst, husbandman 2
4168026 2084304 2084304 defendant Curde John husbandman 601616 601616 Curde, John, of Hawkeherst, husbandman 3
4175665 2086959 2086959 defendant Ayers Thomas husbandman 601616 601616 Ayers, Thomas, of Hawkeherst, husbandman 0
4196797 2094428 2094428 defendant Summer John tailor 601616 601616 Summer, John, of Hawkeherst, tailor 1
4198974 2095198 2095198 defendant Ayers Thomas husbandman 601616 601616 Ayers, Thomas, of Hawkeherst, husbandman 0
4198995 2095205 2095205 defendant Spryngatt John husbandman 601616 601616 Spryngatt, John, of Hawkeherst, husbandman 1
4224299 2103982 2103982 defendant Baker William shoemaker 601616 601616 Baker, William, of Hawkeherst, shoemaker 0
4228234 2105356 2105356 defendant Graunte Zacheus weaver 601616 601616 Graunte, Zacheus, of Hawkeherst, weaver 0
4250145 2113027 2113027 defendant Baker William shoemaker 601616 601616 Baker, William, of Hawkeherst, shoemaker 0
4286387 2125172 2125172 defendant Bechyng Andrew clothier 601616 601616 Bechyng, Andrew, of Hawkeherst, clothier 0
4286388 2125172 2125172 defendant Standen Thomas, junior smith 601616 601616 together with Standen, Thomas, junior, of Hawkeherst, smith 1
4286389 2125172 2125172 defendant Ashenden Robert weaver 601616 601616 Ashenden, Robert, of Hawkeherst, weaver 2
4323858 2138391 2138391 defendant Omerden Peter blacksmith 601616 601616 Omerden, Peter, of Hawkeherst, blacksmith 3
4327851 2139638 2139638 defendant Graunte Zacheus yeoman 601616 601616 Graunte, Zacheus, of Hawkeherst, yeoman 0
4327852 2139638 2139638 defendant Omanden Peter blacksmith 601616 601616 Omanden, Peter, of Hawkeherst, blacksmith 1
4360217 2150820 2150820 defendant Baker William shoemaker 601616 601616 Baker, William, of Hawkeherst, shoemaker 1
4365040 2152551 2152551 defendant Hamond Thomas husbandman 601616 601616 Hamond, Thomas, of Hawkeherst, husbandman 0
5517857 2510427 2510427 plaintiff Whatman Juliane (legal representative) 601616 601616 Whatman, Juliane, of Hawkeherst, executor of 0
5547022 2519134 2519134 defendant Warde Richard clerk 601616 601616 Warde, Richard, of Hawkeherst, clerk 0
5588375 2531365 2531365 defendant Pende Thomas yeoman 601616 601616 Pende, Thomas, of Hawkeherst, yeoman 0

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