names

171 rows where place_id = 588573

✎ 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
3594965 1866054 1866054 defendant Cokkys John yeoman 588573 588573 Cokkys, John, of Dunster, yeoman 0
3599459 1867470 1867470 defendant Morgan Richard yeoman 588573 588573 Morgan, Richard, of Dunster, yeoman 0
3600778 1867904 1867904 defendant Lucas Philip gent 588573 588573 Lucas, Philip, of Dunster, gent 0
3627248 1903368 1903368 defendant Wether John husbandman 588573 588573 (Wether, John, of Dunster, husbandman 2
3721948 1933129 1933129 defendant Jeyn William husbandman 588573 588573 Jeyn, William, of Dunster, husbandman 0
3768643 1947840 1947840 defendant Kempe John husbandman 588573 588573 Kempe, John, of Dunster, husbandman 1
3768644 1947840 1947840 defendant Arnold Tege husbandman 588573 588573 Arnold, Tege, of Dunster, husbandman 2
3807375 1960214 1960214 defendant Wymond John merchant 588573 588573 Wymond, John, of Dunster, merchant 0
3807856 1960342 1960342 defendant Whytblacke John butcher 588573 588573 Whytblacke, John, of Dunster, butcher 0
3818120 1963581 1963581 defendant Hoper John brewer 588573 588573 Hoper, John, of Dunster, brewer 0
3846452 1972445 1972445 defendant Everard Thomas yeoman 588573 588573 Everard, Thomas, of Dunster, yeoman 0
3848623 1973153 1973153 defendant Gose Robert yeoman 588573 588573 Gose, Robert, of Dunster, yeoman 0
3896033 1988876 1988876 defendant Everard Thomas gent 588573 588573 Everard, Thomas, of Dunster, gent 0
3926586 1999222 1999222 defendant Hoper alias Worth Roger husbandman 588573 588573 Hoper alias Worth, Roger, of Dunster, husbandman 0
3932006 2001005 2001005 defendant Gought Robert husandman 588573 588573 Gought, Robert, of Dunster, husandman 1
3962459 2011461 2011461 defendant Lutterell Thomas esq 588573 588573 Lutterell, Thomas, of Dunster, esq 0
3969597 2013977 2013977 defendant Pore Giles husbandman 588573 588573 Pore, Giles, of Dunster, husbandman 0
4035545 2037381 2037381 defendant Atwode Silvester yeoman 588573 588573 Atwode, Silvester, of Dunster, yeoman 2
4115978 2066002 2066002 defendant Holcomb Lawrence yeoman 588573 588573 Holcomb, Lawrence, of Dunster, yeoman 1
4131447 2071566 2071566 defendant Launde Thomas (legal representative) 588573 588573 Launde, Thomas, of Dunster, gent, executrix of 0
4152582 2079017 2079017 defendant Wylkins George   588573 588573 Wylkins, George, of Dunster, linen draper 0
4155817 2080114 2080114 defendant Luttrell George esq 588573 588573 Luttrell, George, of Dunster, esq, son of Thomas Luttrell, of Dunster, esq 0
4155819 2080115 2080115 defendant Luttrell George esq 588573 588573 Luttrell, George, of Dunster, esq, son of Thomas Luttrell, of Dunster, esq 0
4166046 2083628 2083628 defendant Launder James yeoman 588573 588573 Launder, James, of Dunster, yeoman 0
4203596 2096813 2096813 defendant Wilkyns John clothier 588573 588573 Wilkyns, John, of Dunster, clothier 0
4203602 2096816 2096816 defendant Wylkyns John clothier 588573 588573 Wylkyns, John, of Dunster, clothier 0
4205618 2097518 2097518 defendant Alford John merchant 588573 588573 Alford, John, of Dunster, merchant 0
4205619 2097518 2097518 defendant Stevens Richard husbandman 588573 588573 Stevens, Richard, of Dunster, husbandman 1
4213363 2100189 2100189 defendant Gare William husbandman 588573 588573 Gare, William, of Dunster, husbandman 3
4218277 2101889 2101889 defendant Hobbes John victualer 588573 588573 Hobbes, John, of Dunster, butcher, victualer 1
4226404 2104707 2104707 defendant Harte William yeoman 588573 588573 Harte, William, of Dunster, yeoman 0
4226966 2104905 2104905 defendant Scorrier William mercer 588573 588573 Scorrier, William, of Dunster, mercer 2
4227042 2104931 2104931 defendant Cole William husbandman 588573 588573 Cole, William, of Dunster, husbandman 0
4242262 2110406 2110406 defendant Bryne Robert tailor 588573 588573 Bryne, Robert, of Dunster, tailor 1
4244714 2111216 2111216 defendant Evered alias Gryffyn John merchant 588573 588573 Evered alias Gryffyn, John, of Dunster, merchant 1
4300870 2130410 2130410 defendant Escott Lawrence yeoman 588573 588573 Escott, Lawrence, of Dunster, yeoman 0
4300873 2130411 2130411 defendant Hart William yeoman 588573 588573 Hart, William, of Dunster, yeoman 0
4302716 2131067 2131067 defendant Alberd Isaac husbandman 588573 588573 Alberd, Isaac, of Dunster, husbandman 0
4332968 2141312 2141312 defendant Escote alias WIlley Lawrence yeoman 588573 588573 Escote alias WIlley, Lawrence, of Dunster, yeoman 0
4332969 2141312 2141312 defendant Blackwill William husbandman 588573 588573 Blackwill, William, of Dunster, husbandman 1
4332970 2141312 2141312 defendant Die John blacksmith 588573 588573 Die, John, of Dunster, blacksmith 2
4362167 2151515 2151515 defendant Grybbell Philip feltmaker 588573 588573 Grybbell, Philip, of Dunster, feltmaker 0
4362168 2151515 2151515 defendant Harte William yeoman 588573 588573 Harte, William, of Dunster, yeoman 1
4362170 2151515 2151515 defendant Ilesopp John blacksmith 588573 588573 Ilesopp, John, of Dunster, blacksmith 3
4392132 2161992 2161992 defendant Harte William gent 588573 588573 Harte, William, of Dunster, gent 1
4399276 2164342 2164342 defendant Smarte John husbandman 588573 588573 Smarte, John, of Dunster, husbandman 0
4455514 2186730 2186730 plaintiff Mohun Joan   588573 588573 Mohun, Joan, of Dunster 0
4456030 2186908 2186908 defendant Melowe John merchant 588573 588573 Melowe, John, of Dunster, merchant 0
4460411 2188315 2188315 defendant Mellowe John   588573 588573 Mellowe, John, of Dunster 0
4492388 2198301 2198301 defendant Melowe John   588573 588573 Melowe, John, of Dunster 0
4492389 2198301 2198301 defendant Mulleward Robert   588573 588573 Mulleward, Robert, of Dunster 1
4536665 2211747 2211747 defendant Laurence Robert   588573 588573 Laurence, Robert, of Dunster 1
4564138 2220355 2220355 defendant Joye John   588573 588573 Joye, John, of Dunster 1
4573090 2223121 2223121 plaintiff Ball William   588573 588573 Ball, William, of Dunster 0
4586753 2227259 2227259 defendant Atkyn Robert   588573 588573 Atkyn, Robert, of Dunster 1
4589657 2228134 2228134 defendant Mellowe John   588573 588573 Mellowe, John, of Dunster 0
4590729 2228454 2228454 plaintiff Marytn Thomas   588573 588573 Marytn, Thomas, of Dunster 0
4594584 2229564 2229564 defendant Dyer William   588573 588573 Dyer, William, of Dunster 0
4627834 2239631 2239631 defendant Mulet William   588573 588573 Mulet, William, of Dunster 0
4644161 2244387 2244387 defendant Chedesoy John   588573 588573 Chedesoy, John, of Dunster 0
4664568 2250398 2250398 defendant Burgeys Richard weaver 588573 588573 Burgeys, Richard, of Dunster, weaver 0
4664569 2250398 2250398 defendant Webber John weaver 588573 588573 Webber, John, of Dunster, weaver 1
4664570 2250398 2250398 defendant Corun Robert weaver 588573 588573 Corun, Robert, of Dunster, weaver 2
4675574 2257970 2257970 defendant Hengestlegh Thomas   588573 588573 Hengestlegh, Thomas, of Dunster 0
4700900 2265684 2265684 defendant Hengestlegh Thomas   588573 588573 Hengestlegh, Thomas, of Dunster 0
4729896 2274557 2274557 defendant Holman Peter chapman 588573 588573 Holman, Peter, of Dunster, chapman 0
4754095 2281660 2281660 defendant Frere John husbandman 588573 588573 Frere, John, of Dunster, husbandman 3
4754100 2281661 2281661 defendant Frere John husbandman 588573 588573 Frere, John, of Dunster, husbandman 3
4762049 2284114 2284114 defendant Yzerde Thomas (legal representative) 588573 588573 Yzerde, Thomas, of Dunster, executor of 0
4772282 2287300 2287300 defendant Loty John   588573 588573 Loty, John, of Dunster, burgess & mercer 0
4797502 2295390 2295390 defendant Sadeler Joan widow 588573 588573 Sadeler, Joan, of Dunster, widow 0
4797503 2295390 2295390 defendant Walssheman Robert laborer 588573 588573 Walssheman, Robert, of Dunster, laborer 1
4797504 2295390 2295390 defendant Thressher Richard laborer 588573 588573 Thressher, Richard, of Dunster, laborer 2
4803015 2297129 2297129 defendant Loty John mercer 588573 588573 Loty, John, of Dunster, mercer 0
4814870 2300761 2300761 defendant Bedewyn John shoemaker 588573 588573 Bedewyn, John, of Dunster, shoemaker 0
4814872 2300761 2300761 defendant Holt William tanner 588573 588573 Holt, William, of Dunster, tanner 2
4814874 2300761 2300761 defendant Holcombe Richard brewer 588573 588573 Holcombe, Richard, of Dunster, brewer 4
4814875 2300761 2300761 defendant Pey John   588573 588573 Pey, John, of Dunster, millward 5
4820325 2302427 2302427 defendant Spencer John husbandman 588573 588573 Spencer, John, of Dunster, husbandman 0
4821650 2302850 2302850 defendant Luterell Hugh (legal representative) 588573 588573 Luterell, Hugh, of Dunster, knight, executor of 0
4822873 2303236 2303236 defendant Loty John merchant 588573 588573 Loty, John, of Dunster, merchant 0
4825058 2303878 2303878 defendant Rous William chapman 588573 588573 Rous, William, of Dunster, chapman 3
4835627 2307135 2307135 defendant Dyer Edmund dyer 588573 588573 Dyer, Edmund, of Dunster, dyer 0
4847834 2310811 2310811 defendant Wylle John carpenter 588573 588573 Wylle, John, of Dunster, carpenter 0
4847835 2310811 2310811 defendant Stanford John mercer 588573 588573 Stanford, John, of Dunster, mercer 1
4851728 2311976 2311976 defendant Barry Thomas   588573 588573 Barry, Thomas, of Dunster, vicar 0
4855853 2313203 2313203 defendant Coke Thomas merchant 588573 588573 Coke, Thomas, of Dunster, merchant 0
4861595 2314998 2314998 plaintiff Crosse Thomas   588573 588573 Crosse, Thomas, of Dunster 0
4861599 2314999 2314999 plaintiff Crosse Thomas   588573 588573 Crosse, Thomas, of Dunster 0
4884914 2322178 2322178 defendant Brodewode John laborer 588573 588573 Brodewode, John, of Dunster, laborer 0
4897582 2325906 2325906 plaintiff Harryes Robert   588573 588573 Harryes, Robert, of Dunster 0
4900735 2326869 2326869 defendant Huwisshe Christine widow 588573 588573 Huwisshe, Christine, of Dunster, widow 0
4900736 2326869 2326869 defendant Water John weaver 588573 588573 Water, John, of Dunster, weaver 1
4900737 2326869 2326869 defendant Piry John weaver 588573 588573 Piry, John, of Dunster, weaver 2
4900738 2326869 2326869 defendant Baker John weaver 588573 588573 Baker, John, of Dunster, weaver 3
4900742 2326871 2326871 plaintiff William thomas (legal representative) 588573 588573 William, thomas, of Dunster, merchant, executrix of 0
4910916 2329926 2329926 defendant atte Water John weaver 588573 588573 atte Water, John, of Dunster, weaver 1
4927930 2335169 2335169 defendant Baille William merchant 588573 588573 Baille, William, of dunster, merchant 0
4942197 2339548 2339548 defendant Stevynes John   588573 588573 Stevynes, John, of Dunster, millward 0
4942198 2339548 2339548 defendant Holt William tanner 588573 588573 Holt, William, of Dunster, tanner 1

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