names

116 rows where place_id = 596734

✎ 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
3625944 1902971 1902971 defendant Sybblys Richard husbandman 596734 596734 Sybblys, Richard, of Dymmok, husbandman 0
3683943 1921112 1921112 defendant Weyle Roger husbandman 596734 596734 Weyle, Roger, of Dymmok, husbandman 0
3683944 1921112 1921112 defendant Weyle William husbandman 596734 596734 Weyle, William, of Dymmok, husbandman 1
3775387 1950043 1950043 defendant Wyls Ralph husbandman 596734 596734 Wyls, Ralph, of Dymmok, husbandman 0
3780580 1951656 1951656 defendant Sybbys John yeoman 596734 596734 Sybbys, John, of Dymmok, yeoman 0
3790365 1954802 1954802 defendant Hylle Thomas yeoman 596734 596734 Hylle, Thomas, of Dymmok, yeoman 1
3802611 1958711 1958711 defendant Syblyes John husbandman 596734 596734 Syblyes, John, of Dymmok, husbandman 0
3835182 1968943 1968943 defendant Barston Thomas gent 596734 596734 Barston, Thomas, of Dymmok, gent 1
3909079 1993336 1993336 defendant Baston Thomas gent 596734 596734 Baston, Thomas, of Dymmok, gent 1
3989642 2021039 2021039 defendant Bradford Richard yeoman 596734 596734 Bradford, Richard, of Dymmok, yeoman 0
4453381 2186063 2186063 defendant Payn John   596734 596734 Payn, John, of Dymmok 3
4453385 2186063 2186063 defendant Payn Richard   596734 596734 Payn, Richard, of Dymmok, servant of Julian Payn 7
4525133 2208204 2208204 plaintiff Hynton Richard   596734 596734 Hynton, Richard, of Dymmok 0
4526526 2208579 2208579 defendant Henton Richard   596734 596734 Henton, Richard, of Dymmok 0
4546864 2214947 2214947 defendant Shayl John   596734 596734 Shayl, John, of Dymmok 0
4577831 2224572 2224572 defendant Reynald John   596734 596734 Reynald, John, of Dymmok 0
4577832 2224572 2224572 defendant Felmyll William   596734 596734 Felmyll, William, of Dymmok 1
4585295 2226824 2226824 defendant Cley Richard carpenter 596734 596734 Cley, Richard, of Dymmok, carpenter 7
4626567 2239255 2239255 defendant Tryg Henry   596734 596734 Tryg, Henry, of Dymmok 0
4627966 2239671 2239671 defendant Trygge Henry   596734 596734 Trygge, Henry, of Dymmok 2
4627973 2239672 2239672 defendant Trygge Henry   596734 596734 Trygge, Henry, of Dymmok 2
4654436 2247262 2247262 defendant Trygge Henry ploughman 596734 596734 Trygge, Henry, of Dymmok, ploughman 0
4654894 2247411 2247411 defendant Sheyle John husbandman 596734 596734 Sheyle, John, of Dymmok, husbandman 1
4668846 2255960 2255960 defendant Trygg Thomas yeoman 596734 596734 Trygg, Thomas, of Dymmok, yeoman 3
4680143 2259398 2259398 defendant Reynald John husbandman 596734 596734 Reynald, John, of Dymmok, husbandman 0
4680891 2259645 2259645 defendant Velmylle John ploughman 596734 596734 Velmylle, John, of Dymmok, ploughman 0
4682430 2260126 2260126 defendant Penbrigge John gent 596734 596734 Penbrigge, John, of Dymmok, gent 0
4682431 2260126 2260126 defendant Wodecote Thomas laborer 596734 596734 Wodecote, Thomas, of Dymmok, laborer 1
4708294 2267967 2267967 defendant Penbrigge John gent 596734 596734 Penbrigge, John, of Dymmok, gent 0
4744949 2279036 2279036 defendant Wyllus Edmund husbandman 596734 596734 Wyllus, Edmund, of Dymmok, husbandman 0
4744950 2279036 2279036 defendant Hamwell Edmund husbandman 596734 596734 Hamwell, Edmund, of Dymmok, husbandman 1
4745339 2279146 2279146 defendant Sheyll John, senior husbandman 596734 596734 Sheyll, John, senior, of Dymmok, husbandman 1
4748764 2280123 2280123 defendant Grene Richard tailor 596734 596734 Grene, Richard, of Dymmok, tailor 0
4748815 2280139 2280139 defendant Hulle William cooper 596734 596734 Hulle, William, of Dymmok, cooper 0
4780106 2289783 2289783 defendant Weneyate Richard yeoman 596734 596734 Weneyate, Richard, of Dymmok, yeoman 1
4780107 2289783 2289783 defendant Weneyate Edmund yeoman 596734 596734 Weneyate, Edmund, of Dymmok, yeoman 2
4780108 2289783 2289783 defendant Hale William husbandman 596734 596734 Hale, William, of Dymmok, husbandman 3
4780109 2289783 2289783 defendant Chanfrey Thomas husbandman 596734 596734 Chanfrey, Thomas, of Dymmok, husbandman 4
4780110 2289783 2289783 defendant Grombage Thomas husbandman 596734 596734 Grombage, Thomas, of Dymmok, husbandman 5
4780111 2289783 2289783 defendant Pous or Pons John husbandman 596734 596734 Pous or Pons, John, of Dymmok, husbandman 6
4780112 2289783 2289783 defendant Ferer Richard yeoman 596734 596734 Ferer, Richard, of Dymmok, yeoman 7
4780113 2289783 2289783 defendant Wele Henry husbandman 596734 596734 Wele, Henry, of Dymmok, husbandman 8
4780114 2289783 2289783 defendant Drewe John husbandman 596734 596734 Drewe, John, of Dymmok, husbandman 9
4789560 2292806 2292806 defendant Hanfeld Edmund husbandman 596734 596734 Hanfeld, Edmund, of Dymmok, husbandman 0
4789562 2292806 2292806 defendant Morehell Walter husbandman 596734 596734 Morehell, Walter, of Dymmok, husbandman 2
4796007 2294900 2294900 defendant Sheyll John, senior yeoman 596734 596734 Sheyll, John, senior, of Dymmok, yeoman 0
4796009 2294901 2294901 defendant Sheyll John, senior yeoman 596734 596734 Sheyll, John, senior, of Dymmok, yeoman 0
4796010 2294901 2294901 defendant Sheyll John, junior yeoman 596734 596734 Sheyll, John, junior, of Dymmok, yeoman 1
4796011 2294901 2294901 defendant Hynton Richard yeoman 596734 596734 Hynton, Richard, of Dymmok, yeoman 2
4801766 2296734 2296734 defendant Wyllys Edmund husbandman 596734 596734 Wyllys, Edmund, of Dymmok, husbandman 1
4801767 2296734 2296734 defendant Wyllys Thomas husbandman 596734 596734 Wyllys, Thomas, of Dymmok, husbandman 2
4801768 2296734 2296734 defendant Wyllys Ralph husbandman 596734 596734 Wyllys, Ralph, of Dymmok, husbandman 3
4805218 2297831 2297831 defendant Raynold John husbandman 596734 596734 Raynold, John, of Dymmok, husbandman 0
4812224 2299938 2299938 defendant Hulk Lucy widow 596734 596734 Hulk, Lucy, of Dymmok, widow 0
4817498 2301564 2301564 defendant Hull Lucy widow 596734 596734 Hull, Lucy, of Dymmok, widow 0
4835446 2307082 2307082 defendant ap Adam Maurice husbandman 596734 596734 ap Adam, Maurice, of Dymmok, husbandman 0
4852122 2312091 2312091 defendant Wilashulle Richard husbandman 596734 596734 Wilashulle, Richard, of Dymmok, husbandman 0
4852123 2312091 2312091 defendant Wyllys Roger husbandman 596734 596734 Wyllys, Roger, of Dymmok, husbandman 1
4866047 2316351 2316351 defendant Willys Edmund husbandman 596734 596734 Willys, Edmund, of Dymmok, husbandman 0
4876827 2319724 2319724 defendant Spylman John husbandman 596734 596734 Spylman, John, of Dymmok, husbandman 1
4876828 2319724 2319724 defendant Grene Richard tailor 596734 596734 Grene, Richard, of Dymmok, tailor 2
4876830 2319724 2319724 defendant Wyllys John husbandman 596734 596734 Wyllys, John, of Dymmok, husbandman 4
4882041 2321283 2321283 defendant Mallery Geoffrey chapman 596734 596734 Mallery, Geoffrey, of Dymmok, chapman 1
4956604 2343929 2343929 defendant Haukyns John husbandman 596734 596734 Haukyns, John, of Dymmok, husbandman 0
4956606 2343929 2343929 defendant Willasell Richard husbandman 596734 596734 Willasell, Richard, of Dymmok, husbandman 2
4961942 2345525 2345525 defendant Bristed Edmund husbandman 596734 596734 Bristed, Edmund, of Dymmok, husbandman 0
5020919 2363013 2363013 defendant Hoper John husbandman 596734 596734 Hoper, John, of Dymmok, husbandman 2
5023592 2363811 2363811 defendant Broun Thomas husbandman 596734 596734 Broun, Thomas, of Dymmok, husbandman 0
5023593 2363811 2363811 defendant Broun Elizabeth single woman 596734 596734 Broun, Elizabeth, of Dymmok, single woman 1
5028986 2365346 2365346 defendant Horseman Richard husbandman 596734 596734 Horseman, Richard, of Dymmok, husbandman 2
5058936 2374239 2374239 defendant Spylleman John husbandman 596734 596734 Spylleman, John, of Dymmok, husbandman 1
5061670 2375082 2375082 defendant Wodeley Simon husbandman 596734 596734 Wodeley, Simon, of Dymmok, husbandman 2
5062541 2375351 2375351 defendant Merabull John husbandman 596734 596734 Merabull, John, of Dymmok, husbandman 0
5062543 2375351 2375351 defendant Hyet Roger husbandman 596734 596734 Hyet, Roger, of Dymmok, husbandman 2
5082398 2381234 2381234 defendant Willys Roger (legal representative) 596734 596734 Willys, Roger, of Dymmok, executrix of 4
5082402 2381235 2381235 defendant Dobyns John yeoman 596734 596734 Dobyns, John, of Dymmok, yeoman 1
5100076 2386460 2386460 defendant Haukyns William husbandman 596734 596734 Haukyns, William, of Dymmok, husbandman 0
5100077 2386460 2386460 defendant Shayle Walter husbandman 596734 596734 Shayle, Walter, of Dymmok, husbandman 1
5100078 2386460 2386460 defendant Spylleman John husbandman 596734 596734 Spylleman, John, of Dymmok, husbandman 2
5103187 2387361 2387361 defendant Brugge Thomas gent 596734 596734 Brugge, Thomas, of Dymmok, gent 0
5103188 2387361 2387361 defendant Haukyns William yeoman 596734 596734 Haukyns, William, of Dymmok, yeoman 1
5103189 2387361 2387361 defendant Wymond John yeoman 596734 596734 Wymond, John, of Dymmok, yeoman 2
5123475 2393316 2393316 defendant Sheyle John husbandman 596734 596734 Sheyle, John, of Dymmok, husbandman, son of Sheyle, Wiliam, junior, of Dymmok, husbandman 0
5128431 2394790 2394790 defendant Sheyll Walter yeoman 596734 596734 Sheyll, Walter, of Dymmok, yeoman 3
5129954 2395250 2395250 defendant Moreldr Richard husbandman 596734 596734 Moreldr, Richard, of Dymmok, husbandman 0
5129956 2395250 2395250 defendant B--ste-- Edmund yeman 596734 596734 B--ste--, Edmund, of Dymmok, yeman 2
5147520 2400417 2400417 defendant Sheyll Walter   596734 596734 Sheyll, Walter, of Dymmok 3
5149189 2400894 2400894 defendant Moreld Richard husbandman 596734 596734 Moreld, Richard, of Dymmok, husbandman 0
5149191 2400894 2400894 defendant Brustede Edmund yeoman 596734 596734 Brustede, Edmund, of Dymmok, yeoman 2
5216723 2420625 2420625 defendant Pembrigge Thomas gent 596734 596734 Pembrigge, Thomas, of Dymmok, gent 0
5216724 2420625 2420625 defendant Wilton Thomas yeoman 596734 596734 Wilton, Thomas, of Dymmok, yeoman 1
5216725 2420625 2420625 defendant Dobyns John yeoman 596734 596734 Dobyns, John, of Dymmok, yeoman 2
5216726 2420625 2420625 defendant Bursted Edmund yeoman 596734 596734 Bursted, Edmund, of Dymmok, yeoman 3
5216727 2420625 2420625 defendant Morell Richard yeoman 596734 596734 Morell, Richard, of Dymmok, yeoman 4
5223553 2422577 2422577 defendant Brugge Thomas gent 596734 596734 Brugge, Thomas, of Dymmok, gent 0
5279772 2439166 2439166 defendant Myrrabill Walter yeoman 596734 596734 Myrrabill, Walter, of Dymmok, yeoman 0
5296435 2443947 2443947 defendant Brugge Thomas gent 596734 596734 Brugge, Thomas, of Dymmok, gent 0
5296437 2443947 2443947 defendant Spylman William yeoman 596734 596734 Spylman, William, of Dymmok, yeoman 2
5296981 2444113 2444113 plaintiff Wyllys Thomas (legal representative) 596734 596734 Wyllys, Thomas, of Dymmok, executor of 0
5296983 2444113 2444113 defendant Mirrabill Walter husbandman 596734 596734 Mirrabill, Walter, of Dymmok, 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);