names

44 rows where place_id = 588026

✎ 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
3593131 1865477 1865477 defendant Sybbey or Sybley Richard miller 588026 588026 Sybbey or Sybley, Richard, of Stoughton, miller 0
3677321 1918956 1918956 defendant Bayly William yeoman 588026 588026 Bayly, William, of Stoughton, yeoman 0
3706042 1928180 1928180 defendant Cumerey Richard carpenter 588026 588026 Cumerey, Richard, of Stoughton, carpenter 1
3712770 1930311 1930311 defendant Popham John, senior husbandman 588026 588026 Popham, John, senior, of Stoughton, husbandman 2
3712771 1930311 1930311 defendant Algar John husbandman 588026 588026 Algar, John, of Stoughton, husbandman 3
3712772 1930311 1930311 defendant Hoggys John husbandman 588026 588026 Hoggys, John, of Stoughton, husbandman 4
3758645 1944698 1944698 defendant Helder William husbandman 588026 588026 Helder, William, of Stoughton, husbandman 3
3769213 1948023 1948023 defendant Gosleyn John laborer 588026 588026 Gosleyn, John, of Stoughton, laborer 0
3808616 1960574 1960574 defendant Hatley Thomas husbandman 588026 588026 Hatley, Thomas, of Stoughton, husbandman 2
3933563 2001512 2001512 defendant Smyth John husbandman 588026 588026 Smyth, John, of Stoughton, husbandman 0
3954363 2008597 2008597 defendant Baldwyn Agatha widow 588026 588026 Baldwyn, Agatha, of Stoughton, widow 1
4268338 2119014 2119014 defendant Carter George yeoman 588026 588026 Carter, George, of Stoughton, yeoman 0
4322198 2137840 2137840 defendant Bowler Robert gent 588026 588026 Bowler, Robert, of Stoughton, gent 0
4350420 2147410 2147410 defendant Lichladd alias Clarke William yeoman 588026 588026 Lichladd alias Clarke, William, of Stoughton, yeoman 0
4401148 2164979 2164979 defendant Crosley Roger clerk 588026 588026 Crosley, Roger, of Stoughton, clerk 1
4407386 2167032 2167032 defendant Glover John husbandman 588026 588026 Glover, John, of Stoughton, husbandman 0
4610342 2234320 2234320 defendant Bolle John   588026 588026 Bolle, John, of Stoughton 1
4629594 2240181 2240181 defendant Carter Thomas   588026 588026 Carter, Thomas, of Stoughton 5
4649219 2245824 2245824 defendant Crowe Thomas   588026 588026 Crowe, Thomas, of Stoughton 2
4768830 2286229 2286229 defendant Garveys William esq 588026 588026 Garveys, William, of Stoughton, esq 0
4815218 2300872 2300872 defendant Lewyn Thomas husbandman 588026 588026 Lewyn, Thomas, of Stoughton, husbandman 0
4832619 2306224 2306224 defendant Webbe John chaplain 588026 588026 Webbe, John, of Stoughton, chaplain 2
4859450 2314332 2314332 defendant Webbe John chaplain 588026 588026 Webbe, John, of Stoughton, chaplain 2
4889939 2323639 2323639 defendant Conley or Couley William husbandman 588026 588026 Conley or Couley, William, of Stoughton, husbandman 2
4927496 2335034 2335034 defendant Coppeden John husbandman 588026 588026 Coppeden, John, of Stoughton, husbandman 0
5008430 2359355 2359355 defendant Est Henry husbandman 588026 588026 Est, Henry, of Stoughton, husbandman 2
5008433 2359356 2359356 defendant Est Henry husbandman 588026 588026 Est, Henry, of Stoughton, husbandman 0
5034990 2367093 2367093 defendant Est Henry husbandman 588026 588026 Est, Henry, of Stoughton, husbandman 0
5044583 2370012 2370012 defendant Moralle John husbandman 588026 588026 Moralle, John, of Stoughton, husbandman 0
5044584 2370012 2370012 defendant Bateseyde John husbandman 588026 588026 Bateseyde, John, of Stoughton, husbandman 1
5087291 2382663 2382663 defendant Morell John husbandman 588026 588026 Morell, John, of Stoughton, husbandman 2
5097527 2385707 2385707 defendant Hardy John yeoman 588026 588026 Hardy, John, of Stoughton, yeoman 2
5099046 2386152 2386152 defendant Canowe Thomas butcher 588026 588026 Canowe, Thomas, of Stoughton, butcher 0
5105002 2387903 2387903 defendant Smyth John   588026 588026 Smyth, John, of Stoughton 1
5105028 2387905 2387905 defendant Smyth John   588026 588026 Smyth, John, of Stoughton 6
5110168 2389384 2389384 defendant Stevyns Geoffrey husbandman 588026 588026 Stevyns, Geoffrey, of Stoughton, husbandman 1
5110388 2389440 2389440 defendant Stevens Richard husbandman 588026 588026 Stevens, Richard, of Stoughton, husbandman 4
5145868 2399921 2399921 defendant Smyth John   588026 588026 Smyth, John, of Stoughton 5
5221563 2422003 2422003 defendant Shory John yeoman 588026 588026 Shory, John, of Stoughton, yeoman 0
5247604 2429457 2429457 defendant Boure John   588026 588026 Boure, John, of Stoughton clerk 2
5254909 2431648 2431648 defendant Dally Ricard husbandman 588026 588026 Dally, Ricard, of Stoughton, husbandman 0
5329981 2454046 2454046 defendant Willyam Oto yeoman 588026 588026 Willyam, Oto, of Stoughton, yeoman 0
5329983 2454047 2454047 defendant Willyam Oto yeoman 588026 588026 Willyam, Oto, of Stoughton, yeoman 0
5562830 2523718 2523718 defendant Bowey Robert husbandman 588026 588026 Bowey, Robert, of Stoughton, husbandman 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);