names

77 rows where place_id = 590486

✎ 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
3601371 1868091 1868091 defendant Snell Robert yeoman 590486 590486 Snell, Robert, of Stoke Holy Cross, yeoman 3
3603420 1868739 1868739 defendant Uttyng John yeoman 590486 590486 Uttyng, John, of Stoke Holy Cross, yeoman 9
3605725 1869452 1869452 defendant Hendry Thomas husbandman 590486 590486 Hendry, Thomas, of Stoke Holy Cross, husbandman 4
3608504 1870319 1870319 defendant Hendry Thomas husbandman 590486 590486 Hendry, Thomas, of Stoke Holy Cross, husbandman 2
3615412 1872461 1872461 defendant Gylys William yeoman 590486 590486 Gylys, William, of Stoke Holy Cross, yeoman 1
3617551 1873112 1873112 defendant Hendry Thomas husbandman 590486 590486 Hendry, Thomas, of Stoke Holy Cross, husbandman 1
3625769 1875597 1875597 defendant Gyles William husbandman 590486 590486 Gyles, William, of Stoke Holy Cross, husbandman 1
3625773 1875598 1875598 defendant Gyles William husbandman 590486 590486 Gyles, William, of Stoke Holy Cross, husbandman 0
3642163 1907997 1907997 defendant Thakker Thomas husbandman 590486 590486 Thakker, Thomas, of Stoke Holy Cross, husbandman 0
3642164 1907997 1907997 defendant Thakker Richard laborer 590486 590486 Thakker, Richard, of Stoke Holy Cross, laborer 1
3642165 1907997 1907997 defendant Boys Richard laborer 590486 590486 Boys, Richard, of Stoke Holy Cross, laborer 2
3645507 1908995 1908995 defendant Thakker Thomas yeoman 590486 590486 Thakker, Thomas, of Stoke Holy Cross, yeoman 3
3654144 1911558 1911558 defendant Lathelos John husbandman 590486 590486 Lathelos, John, of Stoke Holy Cross, husbandman 2
3798983 1957593 1957593 defendant Byllyngford Edmund gent 590486 590486 Byllyngford, Edmund, of Stoke Holy Cross, gent 0
3837024 1969492 1969492 defendant Belyngford Edward esq 590486 590486 Belyngford, Edward, of Stoke Holy Cross, esq 0
3853079 1974581 1974581 defendant Belyngford Edmund esq 590486 590486 Belyngford, Edmund, of Stoke Holy Cross, esq 0
3867512 1979370 1979370 defendant Belyngford Edward esq 590486 590486 Belyngford, Edward, of Stoke Holy Cross, esq 0
3887016 1985920 1985920 defendant Byllyngford Edward esq 590486 590486 Byllyngford, Edward, of Stoke Holy Cross, esq 1
3893603 1988086 1988086 defendant Byllyngforth Edward esq 590486 590486 Byllyngforth, Edward, of Stoke Holy Cross, esq 0
3897610 1989413 1989413 defendant Byllyngford Edward esq 590486 590486 Byllyngford, Edward, of Stoke Holy Cross, esq 0
3904542 1991768 1991768 defendant Byllyngforth Edward esq 590486 590486 Byllyngforth, Edward, of Stoke Holy Cross, esq 0
3907867 1992920 1992920 defendant Byllyngforth Edward esq 590486 590486 Byllyngforth, Edward, of Stoke Holy Cross, esq 0
3909291 1993401 1993401 defendant Byllyngford Edward esq 590486 590486 Byllyngford, Edward, of Stoke Holy Cross, esq 0
3911949 1994321 1994321 defendant Byllyngford Edward esq 590486 590486 Byllyngford, Edward, of Stoke Holy Cross, esq 0
3963877 2011969 2011969 defendant Meke Thomas yeoman 590486 590486 Meke, Thomas, of Stoke Holy Cross, yeoman 1
3978854 2017186 2017186 defendant Lachelus or Lachelns John husbandman 590486 590486 Lachelus or Lachelns, John, of Stoke Holy Cross, husbandman 0
4056898 2044849 2044849 defendant Hardingham Thomas yeoman 590486 590486 Hardingham, Thomas, of Stoke Holy Cross, yeoman 0
4056899 2044849 2044849 defendant Hardingham John yeoman 590486 590486 Hardingham, John, of Stoke Holy Cross, or of Caster St Edmund, yeoman 1
4065013 2047769 2047769 defendant Brown Thomas laborer 590486 590486 Brown, Thomas, of Stoke Holy Cross, laborer 1
4076840 2052002 2052002 defendant Burges Thomas husbandman 590486 590486 Burges, Thomas, of Stoke Holy Cross, husbandman 0
4076841 2052002 2052002 defendant Hardyngham John husbandman 590486 590486 Hardyngham, John, of Stoke Holy Cross, husbandman 1
4086752 2055548 2055548 defendant Graye Roger gent 590486 590486 Graye, Roger, of Stoke Holy Cross, gent 2
4087261 2055733 2055733 defendant Graye Roger gent 590486 590486 Graye, Roger, of Stoke Holy Cross, gent 2
4100597 2060541 2060541 defendant Billingforde Thomas esq 590486 590486 Billingforde, Thomas, of Stoke Holy Cross, or of Blackeforde, esq 0
4111450 2064343 2064343 defendant Gurney Stephen husbandman 590486 590486 Gurney, Stephen, of Stoke Holy Cross, husbandman 0
4148654 2077652 2077652 defendant Grey John gent 590486 590486 Grey, John, of Stoke Holy Cross, or of Magna Thorneham, Suff, gent 0
4249796 2112914 2112914 defendant Thacker Richard yeoman 590486 590486 Thacker, Richard, of Stoke Holy Cross, yeoman 0
4310678 2133880 2133880 plaintiff Billingforde Thomas, senior (legal representative) 590486 590486 Billingforde, Thomas, senior, of Stoke Holy Cross, esq, executors of 0
4392367 2162072 2162072 defendant Scott John miller 590486 590486 Scott, John, of Stoke Holy Cross, miller 1
4744881 2279018 2279018 defendant Colman Andrew yeoman 590486 590486 Colman, Andrew, of Stoke Holy Cross, yeoman 4
4809528 2299149 2299149 defendant Blythe Roger yeoman 590486 590486 Blythe, Roger, of Stoke Holy Cross, yeoman 1
4829922 2305402 2305402 defendant Dunston Richard miller 590486 590486 Dunston, Richard, of Stoke Holy Cross, miller 4
4867787 2316895 2316895 defendant Byllyngford William   590486 590486 Byllyngford, William, of Stoke Holy Cross 0
4867788 2316895 2316895 defendant Fystolf John yeoman 590486 590486 Fystolf, John, of Stoke Holy Cross, yeoman 1
4872441 2318345 2318345 defendant Millere Richard husbandman 590486 590486 Millere, Richard, of Stoke Holy Cross, husbandman 2
4872448 2318345 2318345 defendant Fystolf John yeoman 590486 590486 Fystolf, John, of Stoke Holy Cross, yeoman 9
4874121 2318848 2318848 defendant Blythe Roger husbandman 590486 590486 Blythe, Roger, of Stoke Holy Cross, husbandman 0
4892221 2324311 2324311 defendant Nepe Thomas miller 590486 590486 Nepe, Thomas, of Stoke Holy Cross, miller 4
4906652 2328668 2328668 defendant Ne- Thomas miller 590486 590486 Ne-, Thomas, of Stoke Holy Cross, miller 1
4936762 2337875 2337875 defendant Blythe Roger yeoman 590486 590486 Blythe, Roger, of Stoke Holy Cross, yeoman 3
4939924 2338872 2338872 defendant Blythe Roger yeoman 590486 590486 Blythe, Roger, of Stoke Holy Cross, yeoman 0
4944585 2340288 2340288 defendant Chaumber William husbandman 590486 590486 Chaumber, William, of Stoke Holy Cross, husbandman 0
4949894 2341944 2341944 defendant Blythe Roger yeoman 590486 590486 Blythe, Roger, of Stoke Holy Cross, yeoman 3
4958446 2344495 2344495 defendant Blythe Roger yeoman 590486 590486 Blythe, Roger, of Stoke Holy Cross, yeoman 0
4958447 2344495 2344495 defendant Blythe Thomas yeoman 590486 590486 Blythe, Thomas, of Stoke Holy Cross, yeoman 1
5002087 2357509 2357509 defendant Gyles Richard husbandman 590486 590486 Gyles, Richard, of Stoke Holy Cross, husbandman 1
5002446 2357627 2357627 defendant Wode Robert gent 590486 590486 (Wode, Robert, of Stoke Holy Cross, gent 1
5008123 2359260 2359260 defendant (illegible) William laborer 590486 590486 _, William, of Stoke Holy Cross, laborer 3
5064240 2375850 2375850 defendant Snell of Suell Robert husbandman 590486 590486 Snell of Suell, Robert, of Stoke Holy Cross, husbandman 0
5085845 2382255 2382255 defendant Herkyn Robert yeoman 590486 590486 Herkyn, Robert, of Stoke Holy Cross, yeoman 1
5102719 2387208 2387208 defendant Billyngford John esq 590486 590486 Billyngford, John, of Stoke Holy Cross, or of Blakworth, Norf, esq 2
5104320 2387686 2387686 defendant Harkyn Robert yeoman 590486 590486 Harkyn, Robert, of Stoke Holy Cross, yeoman 0
5235399 2425936 2425936 defendant Herkyn Robert yeoman 590486 590486 Herkyn, Robert, of Stoke Holy Cross, yeoman 0
5238159 2426748 2426748 defendant Joce Richard yeoman 590486 590486 Joce, Richard, of Stoke Holy Cross, yeoman 3
5296277 2443901 2443901 defendant Harkyn Robert laborer 590486 590486 Harkyn, Robert, of Stoke Holy Cross, laborer 4
5369879 2466167 2466167 defendant Hendry Thomas   590486 590486 Hendry, Thomas, of Stoke Holy Cross, tallow chandler 0
5391589 2472665 2472665 defendant Hendry Thomas yeoman 590486 590486 Hendry, Thomas, of Stoke Holy Cross, yeoman 1
5401986 2475626 2475626 defendant Vayng John husbandman 590486 590486 Vayng, John, of Stoke Holy Cross, husbandman 3
5404609 2476394 2476394 defendant Hendry Thomas yeoman 590486 590486 Hendry, Thomas, of Stoke Holy Cross, yeoman 1
5414898 2479387 2479387 defendant Uttyng John husbandman 590486 590486 Uttyng, John, of Stoke Holy Cross, husbandman 2
5433214 2484899 2484899 defendant Hendry Richard laborer 590486 590486 Hendry, Richard, of Stoke Holy Cross, laborer 0
5441390 2487344 2487344 defendant Uttyng John husbandman 590486 590486 Uttyng, John, of Stoke Holy Cross, husbandman 1
5459886 2492885 2492885 defendant Uttyng John husbandman 590486 590486 Uttyng, John, of Stoke Holy Cross, husbandman 0
5484513 2500288 2500288 defendant Uttyng John husbandman 590486 590486 Uttyng, John, of Stoke Holy Cross, husbandman 1
5489669 2501791 2501791 defendant Handry Thomas husbandman 590486 590486 Handry, Thomas, of Stoke Holy Cross, husbandman 2
5523412 2512152 2512152 defendant Hendry John yeoman 590486 590486 Hendry, John, of Stoke Holy Cross, yeoman 0
5554372 2521315 2521315 defendant Pydde Stephen chaplain 590486 590486 Pydde, Stephen, of Stoke Holy Cross, chaplain 2

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