names

43 rows where place_id = 665625

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3977744 2016786 2016786 defendant Hydley Thomas husbandman 665625 665625 Hydley, Thomas, of Sedgeley, husbandman 0
4056342 2044652 2044652 defendant Pytt George laborer 665625 665625 Pytt, George, of Sedgeley, laborer 1
4056343 2044652 2044652 defendant Jevon William laborer 665625 665625 Jevon, William, of Sedgeley, laborer 2
4061877 2046644 2046644 defendant Bradley Richard nailer 665625 665625 Bradley Richard, of Sedgeley, nailer 0
4065573 2047977 2047977 defendant Cox Thomas butcher 665625 665625 Cox, Thomas, of Sedgeley, butcher 1
4067702 2048760 2048760 defendant Bradeley John nailer 665625 665625 Bradeley, John, of Sedgeley, nailer 1
4070337 2049686 2049686 defendant Bradley Richard nailer 665625 665625 Bradley, Richard, of Sedgeley, nailer 1
4070338 2049686 2049686 defendant Hukmons Thomas nailer 665625 665625 Hukmons, Thomas, of Sedgeley, nailer 2
4074591 2051215 2051215 defendant Hydley Thomas yeoman 665625 665625 Hydley, Thomas, of Sedgeley, yeoman 0
4143258 2075809 2075809 defendant Webbe John laborer 665625 665625 Webbe, John, of Sedgeley, laborer 1
4172603 2085876 2085876 defendant Jeaven Richard yeoman 665625 665625 Jeaven, Richard, of Sedgeley, yeoman 0
4172604 2085876 2085876 defendant Gybbons Thomas yeoman 665625 665625 Gybbons, Thomas, of Sedgeley, yeoman 1
4177755 2087694 2087694 defendant Hardwick Nicholas husbandman 665625 665625 Hardwick, Nicholas, of Sedgeley, husbandman 0
4177756 2087694 2087694 defendant Park Humphrey husbandman 665625 665625 together with Park, Humphrey, of Sedgeley, husbandman 1
4182684 2089423 2089423 defendant Hall Philip gent 665625 665625 Hall, Philip, of Sedgeley, gent 1
4219960 2102484 2102484 defendant Park alias Parsehouse Thomas blacksmith 665625 665625 Park alias Parsehouse, Thomas, of Sedgeley, blacksmith 0
4246532 2111815 2111815 defendant Broughton John gent 665625 665625 Broughton, John, of Sedgeley, gent 0
4268907 2119196 2119196 defendant Parsehowse Thomas stringer 665625 665625 Parsehowse, Thomas, of Sedgeley, stringer 0
4309818 2133588 2133588 defendant Gardener Kenelm laborer 665625 665625 Gardener, Kenelm, of Sedgeley, laborer 2
4310512 2133830 2133830 defendant Jukes Thomas smith 665625 665625 Jukes, Thomas, of Sedgeley, smith 0
4314864 2135312 2135312 defendant Marshe John gent 665625 665625 Marshe, John, of Sedgeley, gent 0
4316627 2135935 2135935 defendant Hardwicke John yeoman 665625 665625 Hardwicke, John, of Sedgeley, yeoman 0
4326355 2139179 2139179 defendant Persehouse Thomas laborer 665625 665625 Persehouse, Thomas, of Sedgeley, laborer 2
4332816 2141257 2141257 defendant Walton Thomas nailer 665625 665625 Walton, Thomas, of Sedgeley, nailer 0
4332817 2141257 2141257 defendant Walton Ellen widow 665625 665625 Walton, Ellen, of Sedgeley, widow 1
4334291 2141749 2141749 defendant Bensted Stephen yeoman 665625 665625 Bensted, Stephen, of Sedgeley, yeoman 0
4334292 2141749 2141749 defendant Wylson William husbandman 665625 665625 Wylson, William, of Sedgeley, husbandman 1
4334294 2141749 2141749 defendant Holmer William yeoman 665625 665625 Holmer, William, of Sedgeley, yeoman 3
4335084 2142007 2142007 defendant Barrett Elizabeth spinster 665625 665625 Elizabeth his wife, formerly Elizabwth Hodgettes, of Sedgeley, spinster 1
4343942 2145159 2145159 defendant Hardwick John tailor 665625 665625 Hardwick, John, of Sedgeley, tailor 2
4346187 2145918 2145918 defendant Downynge John smith 665625 665625 Downynge, John, of Sedgeley, smith 0
4346936 2146180 2146180 defendant Hickmans John yeoman 665625 665625 Hickmans, John, of Sedgeley, yeoman 0
4346937 2146180 2146180 defendant Perkehouse or Parsehouse Thomas nailer 665625 665625 Perkehouse or Parsehouse, Thomas, of Sedgeley, nailer 1
4346953 2146186 2146186 defendant Marshe William yeoman 665625 665625 Marshe, William, of Sedgeley, yeoman 0
4391396 2161739 2161739 defendant Jukes Thomas yeoman 665625 665625 Jukes, Thomas, of Sedgeley, yeoman 0
4391397 2161739 2161739 defendant Parsehowse Thomas blacksmith 665625 665625 Parsehowse, Thomas, of Sedgeley, blacksmith 1
4391398 2161739 2161739 defendant Marshe William nailer 665625 665625 Marshe, William, of Sedgeley, nailer 2
4391399 2161739 2161739 defendant Moseley John nailer 665625 665625 Moseley, John, of Sedgeley, nailer 3
4396465 2163392 2163392 defendant Jeven Richard yeoman 665625 665625 Jeven, Richard, of Sedgeley, yeoman 0
4396467 2163393 2163393 defendant Jevon Richard yeoman 665625 665625 Jevon, Richard, of Sedgeley, yeoman 0
4402865 2165544 2165544 defendant Park Thomas yeoman 665625 665625 Park, Thomas, of Sedgeley, yeoman 0
4409869 2167904 2167904 defendant Parkes Thomas, senior nailer 665625 665625 Parkes, Thomas, senior, of Sedgeley, nailer 0
4409870 2167904 2167904 defendant Parkes Thomas, junior nailer 665625 665625 Parkes, Thomas, junior, of Sedgeley, nailer 1

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