names

112 rows where place_id = 588756

✎ 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
3595480 1866221 1866221 defendant Fox Henry husbandman 588756 588756 Fox, Henry, of Holton, husbandman 0
3605164 1869280 1869280 plaintiff Hotholgan John   588756 588756 Hotholgan, John, of Holton 0
3611254 1871198 1871198 defendant Peyrs Alexander husbandman 588756 588756 Peyrs, Alexander, of Holton, husbandman 0
3611255 1871198 1871198 defendant Fox Henry husbandman 588756 588756 Fox, Henry, of Holton, husbandman 1
3611256 1871198 1871198 defendant Fox Thomas fletcher 588756 588756 Fox, Thomas, of Holton, fletcher 2
3611257 1871198 1871198 defendant Arnold William husbandman 588756 588756 Arnold, William, of Holton, husbandman 3
3627972 1903604 1903604 defendant Colman John   588756 588756 Colman, John, of Holton, ash burner 0
3750982 1942234 1942234 defendant Forman John husbandman 588756 588756 Forman, John, of Holton, husbandman 0
3757606 1944358 1944358 defendant Stede John husbandman 588756 588756 Stede, John, of Holton, husbandman 2
3759780 1945053 1945053 defendant Farman John butcher 588756 588756 Farman, John, of Holton, butcher 0
3759782 1945053 1945053 defendant Coryor John husbandman 588756 588756 Coryor, John, of Holton, husbandman 2
3767406 1947450 1947450 defendant Forman John husbandman 588756 588756 Forman, John, of Holton, husbandman 0
3771956 1948922 1948922 defendant Bregges John yeoman 588756 588756 Bregges, John, of Holton, yeoman 0
3771957 1948922 1948922 defendant Dey Robert husbandman 588756 588756 Dey, Robert, of Holton, husbandman 1
3793187 1955727 1955727 defendant Stede John husbandman 588756 588756 Stede, John, of Holton, husbandman 1
3793230 1955742 1955742 defendant Benett Thomas husbandman 588756 588756 Benett, Thomas, of Holton, husbandman 1
3795002 1956301 1956301 defendant Bennett Thomas husbandman 588756 588756 Bennett, Thomas, of Holton, husbandman 2
3840252 1970519 1970519 defendant Davy John husbandman 588756 588756 Davy, John, of Holton, husbandman 3
3845366 1972111 1972111 defendant Neve Thomas butcher 588756 588756 Neve, Thomas, of Holton, butcher 0
3855448 1975346 1975346 defendant Crispe Thomas   588756 588756 Crispe, Thomas, of Holton, wheelwright 1
3888591 1986442 1986442 defendant Knyghtis Thomas laborer 588756 588756 Knyghtis, Thomas, of Holton, laborer 4
3888592 1986442 1986442 defendant Cryspe Robert husbandman 588756 588756 Cryspe, Robert, of Holton, husbandman 5
3888593 1986442 1986442 defendant Bakeler Thomas husbandman 588756 588756 Bakeler, Thomas, of Holton, husbandman 6
3888699 1986477 1986477 defendant Davy John husbandman 588756 588756 Davy, John, of Holton, husbandman 0
3888701 1986478 1986478 defendant Davy John husbandman 588756 588756 Davy, John, of Holton, husbandman 0
3915597 1995584 1995584 defendant Smythe William husbandman 588756 588756 Smythe, William, of Holton, husbandman 3
3917107 1996080 1996080 defendant Wynter William husbandman 588756 588756 Wynter, William, of Holton, husbandman 0
3968783 2013709 2013709 defendant Nonne Richard husbandman 588756 588756 Nonne, Richard, of Holton, husbandman 0
3977218 2016602 2016602 plaintiff Lece Robert husbandman 588756 588756 Lece, Robert, of Holton, husbandman 0
4015544 2030256 2030256 defendant Holyngworth Thomas   588756 588756 Holyngworth, Thomas, of Holton, surgeon 0
4023393 2033077 2033077 plaintiff Barrett Richard gent 588756 588756 Barrett, Richard, of Holton, gent 0
4031313 2035873 2035873 defendant Wynter William husbandman 588756 588756 Wynter, William, of Holton, husbandman 0
4052267 2043234 2043234 defendant Dorissall Richard husbandman 588756 588756 Dorissall, Richard, of Holton, husbandman 1
4080076 2053180 2053180 defendant Bryant John clerk 588756 588756 Bryant, John, of Holton, or of Ilketsell Andrew, clerk 0
4090904 2057037 2057037 defendant Wynter William husbandman 588756 588756 Wynter, William, of Holton, husbandman 3
4133538 2072325 2072325 defendant Curteys Thomas yeoman 588756 588756 Curteys, Thomas, of Holton, yeoman 0
4188065 2091328 2091328 defendant Wynter William husbandman 588756 588756 Wynter, William, of Holton, husbandman 0
4194462 2093613 2093613 defendant Smyth John husbandman 588756 588756 Smyth, John, of Holton, husbandman 0
4213516 2100242 2100242 defendant Dearseley John husbandman 588756 588756 Dearseley, John, of Holton, husbandman 3
4215618 2100960 2100960 defendant Cheseman Anthony yeoman 588756 588756 Cheseman, Anthony, of Holton, yeoman 0
4215620 2100960 2100960 defendant Wylson Thomas husbandman 588756 588756 Wylson, Thomas, of Holton, husbandman 2
4215621 2100960 2100960 defendant Richdale William yeoman 588756 588756 Richdale, William, of Holton, yeoman 3
4215623 2100961 2100961 defendant Grantham Humphrey husbandman 588756 588756 Grantham, Humphrey, of Holton, husbandman 0
4228286 2105375 2105375 defendant Killinge or Keelinge William   588756 588756 Killinge or Keelinge, William, of Holton, yeoman, bailiff of wapentake of Wragg 0
4229824 2105915 2105915 defendant Keelinge William yeoman 588756 588756 Keelinge, William, of Holton, or of Henton, yeoman 0
4233193 2107119 2107119 defendant Cheseman Anthony yeoman 588756 588756 Cheseman, Anthony, of Holton, yeoman 0
4233194 2107119 2107119 defendant Wylson John husbandman 588756 588756 Wylson, John, of Holton, husbandman 1
4233195 2107119 2107119 defendant Wylson Thomas husbandman 588756 588756 Wylson, Thomas, of Holton, husbandman 2
4233196 2107119 2107119 defendant Richdale William yeoman 588756 588756 Richdale, William, of Holton, yeoman 3
4233198 2107120 2107120 defendant Grantham Humphrey husbandman 588756 588756 Grantham, Humphrey, of Holton, husbandman 0
4246610 2111841 2111841 defendant Pegge Edmund carpenter 588756 588756 Pegge, Edmund, of Holton, carpenter 2
4246982 2111966 2111966 defendant Holton John husbandman 588756 588756 Holton, John, of Holton, husbandman 0
4253962 2114324 2114324 defendant Baildon or Bawldon William clerk 588756 588756 Baildon or Bawldon, William, of Holton, clerk 0
4253963 2114324 2114324 defendant Walker William laborer 588756 588756 Walker, William, of Holton, laborer 1
4257320 2115425 2115425 defendant Killinge or Keelinge William   588756 588756 Killinge or Keelinge, William, of Holton, yeoman, bailiff of Wragg Wapentake 0
4286048 2125065 2125065 defendant Gould Roger yeoman 588756 588756 Gould, Roger, of Holton, yeoman 0
4286891 2125367 2125367 defendant Bailden or Bawlden William clerk 588756 588756 Bailden or Bawlden, William, of Holton, clerk 0
4286892 2125367 2125367 defendant Walker William laborer 588756 588756 Walker, William, of Holton, laborer 1
4303546 2131366 2131366 defendant Wynter William yeoman 588756 588756 Wynter, William, of Holton, yeoman 1
4314401 2135150 2135150 defendant Baildon or Bawlden William clerk 588756 588756 Baildon or Bawlden, William, of Holton, clerk 0
4314402 2135150 2135150 defendant Walker William laborer 588756 588756 Walker, William, of Holton, laborer 1
4327478 2139512 2139512 defendant Golde Roger yeoman 588756 588756 Golde, Roger, of Holton, yeoman 0
4342353 2144599 2144599 defendant Bouthe Anthony yeoman 588756 588756 Bouthe, Anthony, of Holton, yeoman 1
4376300 2156594 2156594 defendant Betour William laborer 588756 588756 Betour, William, of Holton, laborer 0
4376301 2156594 2156594 defendant Hodgson Stephen laborer 588756 588756 Hodgson, Stephen, of Holton, laborer 1
4394955 2162898 2162898 defendant Bryant John miller 588756 588756 Bryant, John, of Holton, miller 0
4408582 2167459 2167459 defendant Gould Roger yeoman 588756 588756 Gould, Roger, of Holton, yeoman 0
4558851 2218730 2218730 defendant Harymate Thomas   588756 588756 Harymate, Thomas, of Holton 0
4594714 2229601 2229601 defendant Bakere William   588756 588756 Bakere, William, of Holton 0
4616334 2236100 2236100 defendant Beleson John   588756 588756 Beleson, John, of Holton 1
4688582 2261991 2261991 defendant Ose Thomas yeoman 588756 588756 Ose, Thomas, of Holton, yeoman 1
4724129 2272841 2272841 defendant Judson John husbandman 588756 588756 Judson, John, of Holton, husbandman 0
4812778 2300112 2300112 defendant Fox Thomas yeoman 588756 588756 Fox, Thomas, of Holton, yeoman 1
4885564 2322365 2322365 defendant Brook William (legal representative) 588756 588756 Brook, William, of Holton, administrator of 0
4940539 2339067 2339067 defendant Benet John husbandman 588756 588756 Benet, John, of Holton, husbandman 0
4940542 2339068 2339068 defendant Benet John husbandman 588756 588756 Benet, John, of Holton, husbandman 0
4949389 2341795 2341795 defendant Baker John sawyer 588756 588756 Baker, John, of Holton, sawyer 2
4958846 2344618 2344618 defendant Hill Robert yeoman 588756 588756 Hill, Robert, of Holton, yeoman 0
5093924 2384622 2384622 defendant Squyer John husbandman 588756 588756 Squyer, John, of Holton, husbandman 0
5123013 2393161 2393161 defendant Goche Richard butcher 588756 588756 Goche, Richard, of Holton, butcher 0
5139153 2397944 2397944 defendant Fox (illegible) laborer 588756 588756 Fox, ---, of Holton, laborer 1
5146888 2400229 2400229 defendant Goodman Stephen   588756 588756 Goodman, Stephen, of Holton, parson 1
5166803 2406016 2406016 defendant Goodman Stephen   588756 588756 Goodman, Stephen, of Holton, parson 1
5203137 2416677 2416677 defendant Goodman Stephen   588756 588756 Goodman, Stephen, of Holton 1
5232800 2425178 2425178 defendant Goodman Stephen clerk 588756 588756 Goodman, Stephen, of Holton, clerk 4
5256963 2432309 2432309 defendant Roseman John   588756 588756 Roseman, John, of Holton, wool chapman 1
5267712 2435660 2435660 defendant Lowys Thomas tailor 588756 588756 Lowys, Thomas, of Holton, tailor 2
5282064 2439827 2439827 defendant Couper William husbandman 588756 588756 Couper, William, of Holton, husbandman 2
5288656 2441703 2441703 defendant Cullum John yeoman 588756 588756 Cullum, John, of Holton, yeoman 0
5301406 2445372 2445372 defendant Couper William husbandman 588756 588756 Couper, William, of Holton, husbandman 1
5305739 2446729 2446729 defendant Cullum John yeoman 588756 588756 Cullum, John, of Holton, yeoman 0
5313696 2449127 2449127 defendant Robynson John yeoman 588756 588756 Robynson, John, of Holton, yeoman 0
5319839 2451026 2451026 defendant Funteyn Martin   588756 588756 Funteyn, Martin, of Holton 3
5320361 2451176 2451176 defendant Northern John husbandman 588756 588756 Northern, John, of Holton, husbandman 0
5333582 2455118 2455118 defendant Herman Robert yeoman 588756 588756 Herman, Robert, of Holton, yeoman 1
5333583 2455118 2455118 defendant Herman William yeoman 588756 588756 Herman, William, of Holton, yeoman 2
5333588 2455119 2455119 defendant Herman Robert yeoman 588756 588756 Herman, Robert, of Holton, yeoman 1
5333589 2455119 2455119 defendant Herman William yeoman 588756 588756 Herman, William, of Holton, yeoman 2
5414223 2479189 2479189 defendant More Nicholas husbandman 588756 588756 More, Nicholas, of Holton, husbandman 0
5429882 2483880 2483880 defendant More Nicholas husbandman 588756 588756 More, Nicholas, of Holton, husbandman 0

Next page

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