names

138 rows where place_id = 586052

✎ 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
3587814 1863833 1863833 defendant Marten Thomas husbandman 586052 586052 Marten, Thomas, of Bishops Hatfeld, husbandman 0
3587823 1863837 1863837 defendant Smyth Thomas pardoner 586052 586052 Smyth, Thomas, of Bishops Hatfeld, pardoner 0
3590583 1864696 1864696 defendant Potter William husbandman 586052 586052 Potter, William, of Bishops Hatfeld, husbandman 4
3614728 1872254 1872254 defendant Den Henry potter 586052 586052 Den, Henry, of Bishops Hatfeld, potter 2
3614802 1872282 1872282 defendant Colyns Thomas brewer 586052 586052 Colyns, Thomas, of Bishops Hatfeld, brewer 0
3619256 1873625 1873625 defendant Howe Roger butcher 586052 586052 Howe, Roger, of Bishops Hatfeld, butcher 0
3619257 1873625 1873625 defendant Benne Henry potter 586052 586052 Benne, Henry, of Bishops Hatfeld, potter 1
3620352 1873947 1873947 defendant Feld Nicholas husbandman 586052 586052 Feld, Nicholas, of Bishops Hatfeld, husbandman 0
3621182 1874169 1874169 defendant Lowen Thomas yeoman 586052 586052 Lowen, Thomas, of Bishops Hatfeld, yeoman 0
3621183 1874169 1874169 defendant Budder Thomas yeoman 586052 586052 Budder, Thomas, of Bishops Hatfeld, yeoman 1
3621184 1874169 1874169 defendant Potter William yeoman 586052 586052 Potter, William, of Bishops Hatfeld, yeoman 2
3621185 1874169 1874169 defendant Staple Thomas yeoman 586052 586052 Staple, Thomas, of Bishops Hatfeld, yeoman 3
3621186 1874169 1874169 defendant Barbour Robert laborer 586052 586052 Barbour, Robert, of Bishops Hatfeld, laborer 4
3621187 1874169 1874169 defendant Budder Richard laborer 586052 586052 Budder, Richard, of Bishops Hatfeld, laborer 5
3632698 1905044 1905044 defendant Mason John chaplain 586052 586052 Mason, John, of Bishops Hatfeld, chaplain 2
3635827 1906006 1906006 plaintiff Platte James yeoman 586052 586052 Platte, James, of Bishops Hatfeld, yeoman 0
3645028 1908853 1908853 defendant Roberdes John husbandman 586052 586052 Roberdes, John, of Bishops Hatfeld, husbandman 0
3674014 1917913 1917913 defendant Plomer William yeoman 586052 586052 Plomer, William, of Bishops Hatfeld, yeoman 0
3702358 1926995 1926995 defendant Astry John miller 586052 586052 Astry, John, of Bishops Hatfeld, miller 0
3702359 1926995 1926995 defendant Lewen Thomas yeoman 586052 586052 Lewen, Thomas, of Bishops Hatfeld, yeoman 1
3729612 1935510 1935510 defendant Archer Richard, junior husbandman 586052 586052 Archer, Richard, junior, of Bishops Hatfeld, husbandman 0
3729613 1935510 1935510 defendant Noorse John warrener 586052 586052 Noorse, John, of Bishops Hatfeld, warrener 1
3735323 1937282 1937282 defendant Surgyn alias Wythurst John   586052 586052 Surgyn alias Wythurst, John, of Bishops Hatfeld, surgeon 0
3737988 1938096 1938096 defendant Bassyngbourne John gent 586052 586052 Bassyngbourne, John, of Bishops Hatfeld, gent 0
3737989 1938096 1938096 defendant Dane Henry tailor 586052 586052 Dane, Henry, of Bishops Hatfeld, tailor 1
3737990 1938096 1938096 defendant Palmer Thomas laborer 586052 586052 Palmer, Thomas, of Bishops Hatfeld, laborer 2
3757487 1944315 1944315 defendant Hawkyns Roger miller 586052 586052 Hawkyns, Roger, of Bishops Hatfeld, miller 1
3764218 1946462 1946462 defendant Notte Roger yeoman 586052 586052 Notte, Roger, of Bishops Hatfeld, yeoman 0
3800994 1958221 1958221 defendant Baker Thomas yeoman 586052 586052 Baker, Thomas, of Bishops Hatfeld, yeoman 0
3806417 1959918 1959918 defendant Harryson Richard husbandman 586052 586052 Harryson, Richard, of Bishops Hatfeld, husbandman 0
3806418 1959918 1959918 defendant Harryson John laborer 586052 586052 Harryson, John, of Bishops Hatfeld, laborer 1
3812552 1961813 1961813 defendant Deye John potter 586052 586052 Deye, John,of Bishops Hatfeld, potter 1
3821647 1964655 1964655 defendant Shawe William laborer 586052 586052 Shawe, William, of Bishops Hatfeld, laborer 2
3843887 1971628 1971628 defendant Leonard Robert yeoman 586052 586052 Leonard, Robert, of Bishops Hatfeld, yeoman 0
3853460 1974707 1974707 defendant Carpenter John maltman 586052 586052 Carpenter, John, of Bishops Hatfeld, maltman 1
3865669 1978737 1978737 defendant Archer John yeoman 586052 586052 Archer, John, of Bishops Hatfeld, yeoman 0
3913897 1994995 1994995 defendant Brett John yeoman 586052 586052 Brett, John, of Bishops Hatfeld, yeoman 1
4000618 2024994 2024994 defendant Synyard James yeoman 586052 586052 Synyard, James, of Bishops Hatfeld, yeoman 1
4005022 2026580 2026580 defendant Tooke William esq 586052 586052 Tooke, William, of Bishops Hatfeld, esq 0
4005025 2026581 2026581 defendant Tooke William esq 586052 586052 Tooke, William, of Bishops Hatfeld, esq 0
4797343 2295341 2295341 defendant Legge Thomas laborer 586052 586052 Legge, Thomas, of Bishops Hatfeld, laborer 1
4799800 2296123 2296123 defendant Grene John butcher 586052 586052 Grene, John, of Bishops Hatfeld, butcher 0
4799801 2296123 2296123 defendant Couper Thomas cooper 586052 586052 Couper, Thomas, of Bishops Hatfeld, cooper 1
4799802 2296123 2296123 defendant Berwyk Walter husbandman 586052 586052 Berwyk, Walter, of Bishops Hatfeld, husbandman 2
4799803 2296123 2296123 defendant Mower William laborer 586052 586052 Mower, William, of Bishops Hatfeld, laborer 3
4799804 2296123 2296123 defendant Walsshman William laborer 586052 586052 Walsshman, William, of Bishops Hatfeld, laborer 4
4845949 2310240 2310240 defendant Fyssh John   586052 586052 Fyssh, John, of Bishops Hatfeld, administrators of 0
4845951 2310240 2310240 defendant Fyssh William gent 586052 586052 Fyssh, William, of Bishops Hatfeld, gent 2
4860717 2314711 2314711 defendant Doune or Donne John husbandman 586052 586052 Doune or Donne, John, of Bishops Hatfeld, husbandman 2
4862660 2315305 2315305 defendant Fyssh William husbandman 586052 586052 Fyssh, William, of Bishops Hatfeld, husbandman 1
4862661 2315305 2315305 defendant Ikham John tailor 586052 586052 Ikham, John, of Bishops Hatfeld, tailor 2
4878852 2320319 2320319 defendant Bygge John   586052 586052 Bygge, John, of Bishops Hatfeld, franklin 3
4889416 2323481 2323481 defendant Fysshe William gent 586052 586052 Fysshe, William, of Bishops Hatfeld, gent, son of Fysshe, john, of Bishops Hatfeld, gent 0
4909152 2329406 2329406 defendant Grene John, senior   586052 586052 Grene, John, senior, of Bishops Hatfeld, senior 0
4936907 2337919 2337919 defendant Crowe John laborer 586052 586052 Crowe, John, of Bishops Hatfeld, laborer 0
4936908 2337919 2337919 defendant Sterne John laborer 586052 586052 Sterne, John, of Bishops Hatfeld, laborer 1
4936909 2337919 2337919 defendant Albryght John laborer 586052 586052 Albryght, John, of Bishops Hatfeld, laborer 2
4938711 2338492 2338492 defendant Bordale John laborer 586052 586052 Bordale, John, of Bishops Hatfeld, laborer 0
4949597 2341869 2341869 plaintiff Neweman Nicholas   586052 586052 Neweman, Nicholas, of Bishops Hatfeld 0
4949598 2341869 2341869 defendant Bygge John gent 586052 586052 Bygge, John, of Bishops Hatfeld, gent 0
4956560 2343919 2343919 defendant Baseley William husbandman 586052 586052 Baseley, William, of Bishops Hatfeld, husbandman 4
4956561 2343919 2343919 defendant Belperch Stephen husbandman 586052 586052 Belperch, Stephen, of Bishops Hatfeld, husbandman 5
4956563 2343919 2343919 defendant Curteys John yeoman 586052 586052 Curteys, John, of Bishops Hatfeld, yeoman 7
4956570 2343920 2343920 defendant Baseley William, senior husbandman 586052 586052 Baseley, William, senior, of Bishops Hatfeld, husbandman 4
4956571 2343920 2343920 defendant Belperch Stephen husbandman 586052 586052 Belperch, Stephen, of Bishops Hatfeld, husbandman 5
4956573 2343920 2343920 defendant Curteys John yeoman 586052 586052 Curteys, John, of Bishops Hatfeld, yeoman 7
4956971 2344042 2344042 defendant de Cotys John husbandman 586052 586052 de Cotys, John, of Bishops Hatfeld, husbandman 0
4956972 2344042 2344042 defendant Neuman Nicholas smith 586052 586052 Neuman, Nicholas, of Bishops Hatfeld, smith 1
4969347 2347791 2347791 defendant Besseley William husbandman 586052 586052 Besseley, William, of Bishops Hatfeld, husbandman 0
4975275 2349561 2349561 defendant Martyn John collier 586052 586052 Martyn, John, of Bishops Hatfeld, collier 0
4975276 2349561 2349561 defendant Bone or Boue Thomas husbandman 586052 586052 Bone or Boue, Thomas, of Bishops Hatfeld, husbandman 1
5026784 2364706 2364706 plaintiff Lok John   586052 586052 Lok, John, of Bishops Hatfeld 0
5037041 2367704 2367704 defendant Donne or Doune Bartholomew   586052 586052 Donne or Doune, Bartholomew, of Bishops Lenn, singleman, his son 1
5060075 2374579 2374579 defendant Goldsmyth Thomas yeoman 586052 586052 Goldsmyth, Thomas, of Bishops Hatfeld, yeoman 1
5068279 2377017 2377017 defendant Berewyk William yeoman 586052 586052 Berewyk, William, of Bishops Hatfeld, yeoman 0
5074337 2378821 2378821 plaintiff White William (legal representative) 586052 586052 White, William, of Bishops Hatfeld, laborer, executors of 0
5105632 2388097 2388097 defendant Ikhom Thomas husbandman 586052 586052 Ikhom, Thomas, of Bishops Hatfeld, husbandman 1
5109166 2389103 2389103 defendant Boon John yeoman 586052 586052 Boon, John, of Bishops Hatfeld, yeoman 1
5110344 2389428 2389428 defendant Legge Thomas laborer 586052 586052 Legge, Thomas, of Bishops Hatfeld, laborer 2
5117978 2391688 2391688 defendant Tymmes John miller 586052 586052 Tymmes, John, of Bishops Hatfeld, miller 1
5121042 2392583 2392583 defendant Bone William collier 586052 586052 Bone, William, of Bishops Hatfeld, collier 4
5212585 2419428 2419428 defendant Lok John yeoman 586052 586052 Lok, John, of Bishops Hatfeld, yeoman 0
5214552 2419985 2419985 defendant Sonder or Souder John butcher 586052 586052 Sonder or Souder, John, of Bishops Hatfeld, butcher 0
5221077 2421868 2421868 defendant Elynor William husbandman 586052 586052 Elynor, William, of Bishops Hatfeld, husbandman 0
5221079 2421869 2421869 defendant Elynor William husbandman 586052 586052 Elynor, William, of Bishops Hatfeld, husbandman 0
5226245 2423340 2423340 plaintiff Spryngold John   586052 586052 Spryngold, John, of Bishops Hatfeld 0
5226247 2423340 2423340 defendant Devenshire John husbandman 586052 586052 Devenshire, John, of Bishops Hatfeld, husbandman 1
5258367 2432732 2432732 defendant Landysdale Thomas laborer 586052 586052 Landysdale, Thomas, of Bishops Hatfeld, laborer 0
5258368 2432732 2432732 defendant Landysdale Edmund laborer 586052 586052 Landysdale, Edmund, of Bishops Hatfeld, laborer 1
5258369 2432732 2432732 defendant Ikham Thomas laborer 586052 586052 Ikham, Thomas, of Bishops Hatfeld, laborer 2
5264232 2434572 2434572 defendant Andrewe Richard laborer 586052 586052 Andrewe, Richard, of Bishops Hatfeld, laborer 0
5264233 2434572 2434572 defendant Clerk Thomas laborer 586052 586052 Clerk, Thomas, of Bishops Hatfeld, laborer 1
5264235 2434573 2434573 defendant Andrewe William husbandman 586052 586052 Andrewe, William, of Bishops Hatfeld, husbandman 0
5264236 2434573 2434573 defendant Andrewe John, senior husbandman 586052 586052 Andrewe, John, senior, of Bishops Hatfeld, husbandman 1
5264237 2434573 2434573 defendant Andrewe John, junior laborer 586052 586052 Andrewe, John, junior, of Bishops Hatfeld, laborer 2
5283689 2440276 2440276 defendant Watson John butcher 586052 586052 Watson, John, of Bishops Hatfeld, butcher 1
5317709 2450387 2450387 defendant Batell Robert husbandman 586052 586052 Batell, Robert, of Bishops Hatfeld, husbandman 1
5317714 2450387 2450387 defendant Batyll Humphrey husbandman 586052 586052 Batyll, Humphrey, of Bishops Hatfeld, husbandman 6
5322131 2451690 2451690 defendant Roger John innholder 586052 586052 Roger, John, of Bishops Hatfeld, innholder 0
5342281 2457781 2457781 defendant Bredon John yeoman 586052 586052 Bredon, John, of Bishops Hatfeld, yeoman 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);