names

73 rows where place_id = 593572

✎ 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
3612406 1871508 1871508 defendant Newelond John husbandman 593572 593572 Newelond, John, of Dylham, husbandman 0
3656313 1912220 1912220 defendant Bloms William butcher 593572 593572 Bloms, William, of Dylham, butcher 0
3702195 1926942 1926942 defendant Northgate John (legal representative) 593572 593572 Northgate, John, of Dylham, husbandman, executors of 2
3702196 1926942 1926942 defendant Annot or Aimot John yeoman 593572 593572 (Annot or Aimot, John, of Dylham, yeoman 3
3702197 1926942 1926942 defendant Lambard John husbandman 593572 593572 Lambard, John, of Dylham, husbandman 4
3747369 1941093 1941093 plaintiff Eche Lawrence (legal representative) 593572 593572 Eche, Lawrence, of Dylham, executor of 0
3747371 1941093 1941093 defendant Sadler Nicholas husbandman 593572 593572 Sadler, Nicholas, of Dylham, husbandman 0
3853537 1974730 1974730 defendant Thorne Thomas gent 593572 593572 Thorne, Thomas, of Dylham, gent 0
3853539 1974731 1974731 defendant Thorne Thomas gent 593572 593572 Thorne, Thomas, of Dylham, gent 0
3867232 1979278 1979278 defendant Jarvys Nicholas yeoman 593572 593572 Jarvys, Nicholas, of Dylham, yeoman 0
3867233 1979278 1979278 defendant Norgate John husbandman 593572 593572 Norgate, John, of Dylham, husbandman 1
3867234 1979278 1979278 defendant Kevyt William yeoman 593572 593572 Kevyt, William, of Dylham, yeoman 2
3956216 2009242 2009242 defendant Dockyng Thomas   593572 593572 Dockyng, Thomas, of Dylham 0
3970724 2014351 2014351 plaintiff Dockyng Thomas husbandman 593572 593572 Dockyng, Thomas, of Dylham, husbandman 0
3982728 2018592 2018592 plaintiff Sewell Richard   593572 593572 Sewell, Richard, of Dylham 0
4010446 2028507 2028507 defendant Sewell Richard yeoman 593572 593572 Sewell, Richard, of Dylham, yeoman 0
4014505 2029913 2029913 plaintiff Sewell Richard yeoman 593572 593572 Sewell, Richard, of Dylham, yeoman 0
4045861 2040966 2040966 plaintiff Sewell Richard yeoman 593572 593572 Sewell, Richard, of Dylham, yeoman 0
4046963 2041366 2041366 plaintiff Sowell Richard yeoman 593572 593572 Sowell, Richard, of Dylham, yeoman 0
4075433 2051515 2051515 defendant Thompson Henry laborer or sawyer 593572 593572 Thompson, Henry, of Dylham, laborer or sawyer 2
4076105 2051745 2051745 defendant Wallpoole John tailor 593572 593572 Wallpoole, John, of Dylham, tailor 2
4076111 2051746 2051746 defendant Cubitt Thomas butcher 593572 593572 Cubitt, Thomas, of Dylham, butcher 1
4076121 2051748 2051748 plaintiff Sewell Richard (legal representative) 593572 593572 Sewell, Richard, of Dylham, yeoman, executors of 0
4076125 2051749 2051749 plaintiff Sewell Richard (legal representative) 593572 593572 Sewell, Richard, of Dylham, yeoman, executors of 0
4076129 2051750 2051750 plaintiff Sewell Richard (legal representative) 593572 593572 Sewell, Richard, of Dylham, yeoman, executors of 0
4076133 2051751 2051751 plaintiff Sewell Richard (legal representative) 593572 593572 Sewell, Richard, of Dylham, yeoman, executors of 0
4076827 2051999 2051999 defendant Cubytt Thomas butcher 593572 593572 Cubytt, Thomas, of Dylham, butcher 0
4094961 2058526 2058526 defendant Cubitt William yeoman 593572 593572 Cubitt, William, of Dylham, yeoman 0
4194332 2093567 2093567 defendant Dockynge Thomas yeoman 593572 593572 Dockynge, Thomas, of Dylham, yeoman 0
4194333 2093567 2093567 defendant Dockynge William husbandman 593572 593572 Dockynge, William, of Dylham, husbandman 1
4208785 2098620 2098620 defendant Drake Thomas laborer 593572 593572 Drake, Thomas, of Dylham, laborer 1
4208786 2098620 2098620 defendant Harryson Robert tailor 593572 593572 Harryson, Robert, of Dylham, tailor 2
4261124 2116689 2116689 defendant Poyte Edward (legal representative) 593572 593572 Poyte, Edward, of Dylham, worsted weaver, executors of 3
4291053 2126865 2126865 defendant Kempe William gent 593572 593572 Kempe, William, of Dylham, gent 0
4321046 2137456 2137456 defendant Gylbert Robert husbandman 593572 593572 Gylbert, Robert, of Dylham, husbandman 0
4321047 2137456 2137456 defendant Davy or Davys Hugh yeoman 593572 593572 Davy or Davys, Hugh, of Dylham, yeoman 1
4362845 2151771 2151771 defendant Debydge Hugh husbandman 593572 593572 Debydge, Hugh, of Dylham, husbandman 0
4387664 2160510 2160510 defendant Kydd John laborer 593572 593572 Kydd, John, of Dylham, laborer 3
4388963 2160941 2160941 defendant Debydge Hugh husbandman 593572 593572 Debydge, Hugh, of Dylham, husbandman 0
4628658 2239886 2239886 defendant Brygate John   593572 593572 Brygate, John, of Dylham 1
4839763 2308349 2308349 plaintiff Hawys Robert   593572 593572 Hawys, Robert, of Dylham 0
4907895 2329030 2329030 defendant Jeffreys Thomas husbandman 593572 593572 Jeffreys, Thomas, of Dylham, husbandman 0
4907896 2329030 2329030 defendant Love John carpenter 593572 593572 Love, John, of Dylham, carpenter 1
4998269 2356352 2356352 plaintiff Inglose Henry   593572 593572 Inglose, Henry, of Dylham 0
5007397 2359056 2359056 defendant Adamys John yeoman 593572 593572 Adamys, John, of Dylham, yeoman 0
5056210 2373434 2373434 defendant Astelee Thomas husbandman 593572 593572 Astelee, Thomas, of Dylham, husbandman 0
5215085 2420136 2420136 defendant Inglose Henry esq 593572 593572 Inglose, Henry, of Dylham, esq 0
5227265 2423603 2423603 defendant Love Edmund husbandman 593572 593572 Love, Edmund, of Dylham, husbandman 0
5243827 2428388 2428388 defendant Jonnesson William yeoman 593572 593572 Jonnesson, William, of Dylham, yeoman 2
5245484 2428835 2428835 defendant atte Stones Nicholas yeoman 593572 593572 atte Stones, Nicholas, of Dylham, yeoman 0
5245485 2428835 2428835 defendant Scoles Robert husbandman 593572 593572 Scoles, Robert, of Dylham, husbandman 1
5257988 2432620 2432620 defendant Inglose Henry (legal representative) 593572 593572 Inglose, Henry, of Dylham, knight, executors of 0
5290779 2442307 2442307 defendant Inglose Henry esq 593572 593572 Inglose, Henry, of Dylham, esq 0
5296403 2443937 2443937 defendant Dryver Henry husbandman 593572 593572 Dryver, Henry, of Dylham, husbandman 1
5331756 2454579 2454579 defendant Ilberd Geoffrey clerk 593572 593572 Ilberd, Geoffrey, of Dylham, clerk 13
5376059 2468104 2468104 plaintiff Rycheres John gent 593572 593572 Rycheres, John, of Dylham, gent 0
5386277 2471137 2471137 defendant Wryght Alexander husbandman 593572 593572 Wryght, Alexander, of Dylham, husbandman 1
5391981 2472784 2472784 defendant Eche William husbandman 593572 593572 Eche, William, of Dylham, husbandman 2
5399089 2474810 2474810 defendant Blome Richard husbandman 593572 593572 Blome, Richard, of Dylham, husbandman 3
5402287 2475727 2475727 defendant Ethe William husbandman 593572 593572 Ethe, William, of Dylham, husbandman 2
5408632 2477545 2477545 defendant Blome Richard husbandman 593572 593572 Blome, Richard, of Dylham, husbandman 3
5421877 2481480 2481480 defendant Blome Richard husbandman 593572 593572 Blome, Richard, of Dylham, husbandman 3
5436251 2485779 2485779 plaintiff Rycheres John esq 593572 593572 Rycheres, John, of Dylham, esq 0
5441648 2487421 2487421 defendant Blome Richard husbandman 593572 593572 Blome, Richard, of Dylham, husbandman 1
5441678 2487428 2487428 defendant Blome Richard husbandman 593572 593572 Blome, Richard, of Dylham, husbandman 2
5450984 2490186 2490186 plaintiff Rycheres John esq 593572 593572 Rycheres, John, of Dylham, esq 0
5462929 2493823 2493823 plaintiff Richerds John esq 593572 593572 Richerds, John, of Dylham, esq 0
5474464 2497345 2497345 plaintiff Richerds John esq 593572 593572 Richerds, John, of Dylham, esq 0
5483868 2500119 2500119 defendant Grym or Gryme Gregory husbandman 593572 593572 Grym or Gryme, Gregory, of Dylham, or of Est Derham, husbandman 0
5525673 2512622 2512622 defendant Denawe or Devawe John husbandman 593572 593572 Denawe or Devawe, John, of Dylham, husbandman 2
5526581 2512881 2512881 defendant Carton Thomas clerk 593572 593572 Carton, Thomas, of Dylham, clerk 0
5556766 2521937 2521937 defendant Rycher John gent 593572 593572 Rycher, John, of Dylham, gent 1
5589684 2531771 2531771 defendant Inglos Henry esq 593572 593572 Inglos, Henry, of Dylham, esq 1

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