names

61 rows where place_id = 597660

✎ 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
3629355 1904041 1904041 defendant Bruer Henry laborer 597660 597660 Bruer, Henry, of Danbury, laborer 0
3629357 1904042 1904042 defendant Bruer Henry laborer 597660 597660 Bruer, Henry, of Danbury, laborer 0
3638775 1906948 1906948 defendant Fox John limeburner 597660 597660 Fox, John, of Danbury, limeburner 0
3658293 1912849 1912849 defendant Fuller John butcher 597660 597660 Fuller, John, of Danbury, butcher 0
3672305 1917339 1917339 defendant Bultell John tailor 597660 597660 Bultell, John, of Danbury, tailor 1
3672306 1917339 1917339 defendant Thorroke Thomas laborer 597660 597660 Thorroke, Thomas, of Danbury, laborer 2
3672307 1917339 1917339 defendant Paperell William   597660 597660 Paperell, William, of Danbury, tile maker 3
3675023 1918217 1918217 defendant Aleyn Robert husbandman 597660 597660 Aleyn, Robert, of Danbury, husbandman 1
3695479 1924808 1924808 defendant Estwode Hugh beer brewer 597660 597660 Estwode, Hugh, of Danbury, beer brewer 2
3749158 1941664 1941664 defendant Baker John yeoman 597660 597660 Baker, John, of Danbury, yeoman 2
3774057 1949601 1949601 defendant Style Edward   597660 597660 Style, Edward, of Danbury, wheelwright 2
3777489 1950710 1950710 defendant Vessy John tanner 597660 597660 Vessy, John, of Danbury, tanner 0
3782485 1952267 1952267 plaintiff Hudson Thomas   597660 597660 Hudson, Thomas, of Danbury, clerk, administrators of 0
3784656 1952987 1952987 defendant Darcy Thomas gent 597660 597660 Darcy, Thomas, of Danbury, gent 1
3787293 1953818 1953818 defendant Stylle Edward wheeler 597660 597660 Stylle, Edward, of Danbury, wheeler 2
3801887 1958489 1958489 defendant Rede Robert   597660 597660 Rede, Robert, of Danbury, tile maker 0
3826139 1966017 1966017 defendant Rolff Richard tanner 597660 597660 Rolff, Richard, of Danbury, tanner 0
3826860 1966249 1966249 defendant Rolff Richard tanner 597660 597660 Rolff, Richard, of Danbury, tanner 2
3828790 1966881 1966881 defendant Rolff Richard tanner 597660 597660 Rolff, Richard, of Danbury, tanner 0
3902223 1990980 1990980 defendant Thrustell Agnes widow 597660 597660 Thrustell, Agnes, of Danbury, widow 0
4046142 2041059 2041059 defendant Revett John (legal representative) 597660 597660 Revett, John, of Danbury, son of Thomas Rayner, of Debenham, executors of 0
4046146 2041060 2041060 defendant Revett John (legal representative) 597660 597660 Revett, John, of Danbury, son of Thomas Revett, of Debenham, Suff, executors of 0
4210579 2099254 2099254 defendant Gowers Richard tailor 597660 597660 Gowers, Richard, of Danbury, tailor 3
4355472 2149136 2149136 defendant Beard Thomas husbandman 597660 597660 Beard, Thomas, of Danbury, husbandman 0
4393182 2162327 2162327 defendant Packman Nicholas glover 597660 597660 Packman, Nicholas, of Danbury, glover 0
4595324 2229790 2229790 defendant Wyche John butcher 597660 597660 Wyche, John, of Danbury, butcher 0
4677305 2258521 2258521 defendant Uttyng Thomas husbandman 597660 597660 Uttyng, Thomas, of Danbury, husbandman 2
4707378 2267683 2267683 plaintiff Merk John   597660 597660 Merk, John, of Danbury 0
4707379 2267683 2267683 defendant Helman John   597660 597660 Helman, John, of Danbury, wheel wright 0
4814490 2300640 2300640 plaintiff Ive John   597660 597660 Ive, John, of Danbury 0
4825788 2304101 2304101 defendant Ive John yeoman 597660 597660 Ive, John, of Danbury, yeoman 0
4842663 2309240 2309240 defendant Suthwell Richard   597660 597660 Suthwell, Richard, of Danbury, parson 0
4906274 2328551 2328551 defendant Darcy Robert esq 597660 597660 Darcy, Robert, of Danbury, esq 0
4971810 2348496 2348496 defendant Carter John tilemaker 597660 597660 Carter, John, of Danbury, tilemaker 0
4972101 2348594 2348594 defendant Fuller John, junior husbandman 597660 597660 Fuller, John, junior, of Danbury, husbandman 1
4978005 2350386 2350386 defendant atte Wode John laborer 597660 597660 (atte Wode, John, of Danbury, laborer 4
5013499 2360784 2360784 defendant Spark John fuller 597660 597660 Spark, John, of Danbury, fuller 2
5062131 2375229 2375229 defendant Reynold John husbandman 597660 597660 Reynold, John, of Danbury, husbandman 2
5082647 2381315 2381315 defendant Reynold John yeoman 597660 597660 Reynold, John, of Danbury, yeoman 2
5093336 2384448 2384448 defendant Meerke Alan husbandman 597660 597660 Meerke, Alan, of Danbury, husbandman 1
5102730 2387211 2387211 defendant Bode John farmer 597660 597660 Bode, John, of Danbury, farmer 0
5102897 2387267 2387267 defendant Bode John farmer 597660 597660 Bode, John, of Danbury, farmer 0
5180259 2409965 2409965 defendant Bode John farmer 597660 597660 Bode, John, of Danbury, farmer 0
5198669 2415367 2415367 defendant Fuller John husbandman 597660 597660 Fuller, John, of Danbury, husbandman 3
5210659 2418858 2418858 defendant Fuller John husbandman 597660 597660 Fuller, John, of Danbury, husbandman 3
5233936 2425515 2425515 defendant Bode John husbandman 597660 597660 Bode, John, of Danbury, husbandman 1
5329316 2453852 2453852 defendant Waryn Thomas yeoman 597660 597660 Waryn, Thomas, of Danbury, yeoman 0
5331238 2454416 2454416 defendant Waryn Thomas yeoman 597660 597660 Waryn, Thomas, of Danbury, yeoman 0
5342084 2457718 2457718 defendant Tendryng Thomas yeoman 597660 597660 Tendryng, Thomas, of Danbury, yeoman 1
5350050 2460139 2460139 defendant Fuller John butcher 597660 597660 Fuller, John, of Danbury, butcher 5
5496588 2503894 2503894 defendant Fuller John yeoman 597660 597660 Fuller, John, of Danbury, yeoman 0
5544832 2518492 2518492 defendant Wareyn Thomas yeoman 597660 597660 Wareyn, Thomas, of Danbury, yeoman 1
5561008 2523190 2523190 defendant Populero John yeoman 597660 597660 Populero, John, of Danbury, yeoman 0
5577302 2527956 2527956 defendant Hawis John tanner 597660 597660 Hawis, John, of Danbury, tanner 0
5578201 2528253 2528253 defendant Mounteney Robert gent 597660 597660 Mounteney, Robert, of Danbury, gent 2
5587665 2531157 2531157 defendant Hawes John husbandman 597660 597660 Hawes, John, of Danbury, husbandman 3
5587955 2531245 2531245 defendant Hamond John husbandman 597660 597660 Hamond, John, of Danbury, husbandman 0
5594194 2533161 2533161 defendant Knaggys William yeoman 597660 597660 Knaggys, William, of Danbury, yeoman 0
5631192 2553765 2553765 defendant Mathewe Robert weaver 597660 597660 Mathewe, Robert, of Danbury, weaver 1
5631193 2553765 2553765 defendant Badwe or Badowe John tanner 597660 597660 Badwe or Badowe, John, of Danbury, tanner 2
5631195 2553765 2553765 defendant Wyse John wheeler 597660 597660 Wyse, John, of Danbury, wheeler 4

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