names

136 rows where place_id = 586490

✎ 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
3588854 1864164 1864164 defendant Snowe John mercer 586490 586490 Snowe, John, of Milverton, mercer 0
3599880 1867614 1867614 defendant Tydworthy Robert chaplain 586490 586490 Tydworthy, Robert, of Milverton, chaplain 0
3601825 1868228 1868228 defendant Pey John weaver 586490 586490 Pey, John, of Milverton, weaver 0
3602039 1868298 1868298 defendant Houper John fisher 586490 586490 Houper, John, of Milverton, fisher 0
3605500 1869384 1869384 defendant Beste Roger baker 586490 586490 Beste, Roger, of Milverton, baker 0
3610863 1871068 1871068 defendant Houper John yeoman 586490 586490 Houper, John, of Milverton, yeoman 0
3611889 1871379 1871379 defendant Wallyng John husbandman 586490 586490 Wallyng, John, of Milverton, husbandman 0
3611890 1871379 1871379 defendant Edwarde James husbandman 586490 586490 Edwarde, James, of Milverton, husbandman 1
3622328 1874520 1874520 defendant Richard Edward gent 586490 586490 Richard, Edward, of Milverton, gent 0
3629150 1903988 1903988 defendant Togode William husbandman 586490 586490 Togode, William, of Milverton, husbandman 0
3629151 1903988 1903988 defendant Togode John husbandman 586490 586490 Togode, John, of Milverton, husbandman 1
3651594 1910854 1910854 defendant Tedworth Robert clerk 586490 586490 Tedworth, Robert, of Milverton, clerk 0
3790398 1954815 1954815 defendant Togood Thomas husbandman 586490 586490 Togood, Thomas, of Milverton, husbandman 0
3873290 1981284 1981284 defendant Jenyn alias Abder John husbandman 586490 586490 Jenyn alias Abder, John, of Milverton, husbandman 0
3873291 1981284 1981284 defendant Ledbure Robert husbandman 586490 586490 Ledbure, Robert, of Milverton, husbandman 1
4012605 2029232 2029232 defendant Lancaster Justinian   586490 586490 Lancaster, Justinian, of Milverton, clerk, archdeacon of Taunton 0
4136478 2073388 2073388 defendant Rowswell Thomas yeoman 586490 586490 Rowswell, Thomas, of Milverton, yeoman 0
4145003 2076411 2076411 defendant Reynolde John merchant 586490 586490 Reynolde, John, of Milverton, merchant 0
4218780 2102067 2102067 defendant Bewfoe John gent 586490 586490 Bewfoe, John, of Milverton, gent 0
4241589 2110173 2110173 defendant Fawkner Richard husbandman 586490 586490 Fawkner, Richard, of Milverton, husbandman 0
4254435 2114475 2114475 defendant Parsons John   586490 586490 Parsons, John, of Milverton, felt maker 0
4300545 2130289 2130289 defendant Mondaye William yeoman 586490 586490 Mondaye, William, of Milverton, yeoman 0
4329179 2140070 2140070 defendant Gready John tanner 586490 586490 Gready, John, of Milverton, tanner 0
4338660 2143275 2143275 defendant Milton Robert weaver 586490 586490 Milton, Robert, of Milverton, weaver 0
4338662 2143276 2143276 defendant Milton Robert weaver 586490 586490 Milton, Robert, of Milverton, weaver 0
4350673 2147486 2147486 defendant Milton Robert weaver 586490 586490 Milton, Robert, of Milverton, weaver 0
4387855 2160570 2160570 defendant Munday William yeoman 586490 586490 Munday, William, of Milverton, yeoman 2
4398973 2164239 2164239 defendant Greadie John tanner 586490 586490 Greadie, John, of Milverton, tanner 0
4403351 2165689 2165689 defendant Munday William yeoman 586490 586490 Munday, William, of Milverton, yeoman 2
4406269 2166661 2166661 defendant Dysshe Arthur yeoman 586490 586490 Dysshe, Arthur, of Milverton, yeoman 0
4443917 2183066 2183066 defendant Bouchere John   586490 586490 Bouchere, John, of Milverton 0
4465529 2189887 2189887 defendant Hol--- William   586490 586490 Hol---, William, of Milverton 0
4472823 2192173 2192173 defendant Helyer William   586490 586490 Helyer, William, of Milverton 0
4496191 2199482 2199482 plaintiff Cok William   586490 586490 Cok, William, of Milverton 0
4516298 2205508 2205508 plaintiff Cokkes John   586490 586490 Cokkes, John, of Milverton 0
4578810 2224855 2224855 defendant Smyth John   586490 586490 Smyth, John, of Milverton 5
4578817 2224856 2224856 defendant Smyth John   586490 586490 Smyth, John, of Milverton 5
4578845 2224863 2224863 defendant White John   586490 586490 White, John, of Milverton 5
4578846 2224863 2224863 defendant Causy John   586490 586490 Causy, John, of Milverton 6
4588709 2227849 2227849 defendant Cawsse John   586490 586490 Cawsse, John, of Milverton 0
4594419 2229515 2229515 defendant Trokel John   586490 586490 Trokel, John, of Milverton 0
4594425 2229517 2229517 defendant Randolf John   586490 586490 Randolf, John, of Milverton 0
4600181 2231283 2231283 defendant Lye William   586490 586490 Lye, William, of Milverton 1
4602848 2232106 2232106 plaintiff White John   586490 586490 White, John, of Milverton 0
4620166 2237287 2237287 plaintiff Hurdyng Thomas   586490 586490 Hurdyng, Thomas, of Milverton 0
4657670 2248287 2248287 defendant Whyte John   586490 586490 Whyte, John, of Milverton 0
4657672 2248288 2248288 defendant Waryng Edward (legal representative) 586490 586490 Waryng, Edward, of Milverton, executors of 0
4657676 2248289 2248289 defendant Waryng Edward (legal representative) 586490 586490 Waryng, Edward, of Milverton, executors of 0
4658776 2248615 2248615 defendant Clode Thomas tanner 586490 586490 (Clode, Thomas, of Milverton, tanner 1
4684018 2260609 2260609 defendant Hurdyng Thomas tanner 586490 586490 Hurdyng, Thomas, of Milverton, tanner 0
4696195 2264292 2264292 defendant Whytesyde John tanner 586490 586490 Whytesyde, John, of Milverton, tanner 0
4709431 2268305 2268305 defendant Layty John   586490 586490 Layty, John, of Milverton, Soms, scrivenor 0
4709902 2268456 2268456 defendant Hurdyng Thomas husbandman 586490 586490 Hurdyng, Thomas, of Milverton, husbandman 0
4709903 2268456 2268456 defendant Tanner William husbandman 586490 586490 Tanner, William, of Milverton, husbandman 1
4709904 2268456 2268456 defendant Hurdyng John husbandman 586490 586490 Hurdyng, John, of Milverton, husbandman 2
4709905 2268456 2268456 defendant Devenyssh John husbandman 586490 586490 Devenyssh, John, of Milverton, husbandman 3
4710925 2268773 2268773 defendant Fleccher John   586490 586490 Fleccher, John, of Milverton, vicar 0
4736824 2276645 2276645 defendant Hurdyng Thomas tanner 586490 586490 Hurdyng, Thomas, of Milverton, tanner 2
4737874 2276949 2276949 defendant atte Court Geoffrey husbandman 586490 586490 atte Court, Geoffrey, of Milverton, husbandman 0
4740452 2277723 2277723 defendant Warde Roger ploughman 586490 586490 Warde, Roger, of Milverton, ploughman 1
4746659 2279513 2279513 defendant Bailly Geoffrey   586490 586490 Bailly, Geoffrey, of Milverton, bailiff 0
4746733 2279539 2279539 defendant Bailly Geoffrey   586490 586490 Bailly, Geoffrey, of Milverton, bailiff 0
4784832 2291265 2291265 defendant Raull John tanner 586490 586490 Raull, John, of Milverton, tanner 0
4784833 2291265 2291265 defendant Glowe Thomas tanner 586490 586490 Glowe, Thomas, of Milverton, tanner 1
4784834 2291265 2291265 defendant atte Welle John tanner 586490 586490 atte Welle, John, of Milverton, tanner 2
4809180 2299048 2299048 plaintiff Devenyshh John (legal representative) 586490 586490 Devenyshh, John, of Milverton, executors of 0
4859496 2314343 2314343 defendant Tanner Emma   586490 586490 Tanner, Emma, of Milverton, widow of Tanner, Hugh 0
4882901 2321570 2321570 defendant Thorne Nicholas husbandman 586490 586490 Thorne, Nicholas, of Milverton, husbandman 0
4897743 2325961 2325961 defendant Benet John husbandman 586490 586490 Benet, John, of Milverton, husbandman 0
4900774 2326877 2326877 defendant Whitsyde John tanner 586490 586490 Whitsyde, John, of Milverton, tanner 2
4910148 2329698 2329698 defendant Hurdyng Thomas tanner 586490 586490 Hurdyng, Thomas, of Milverton, tanner 0
4910149 2329698 2329698 defendant Sampford Matilda widow 586490 586490 Sampford, Matilda, of Milverton, widow 1
4910772 2329878 2329878 defendant Danyell Richard tanner 586490 586490 Danyell, Richard, of Milverton, tanner 0
4910915 2329926 2329926 defendant atte Water John laborer 586490 586490 atte Water, John, of Milverton, laborer 0
4910917 2329926 2329926 defendant atte Water Richard fisher 586490 586490 atte Water, Richard, of Milverton, fisher 2
4920583 2332950 2332950 defendant Benet John husbandman 586490 586490 Benet, John, of Milverton, husbandman 0
4925212 2334317 2334317 defendant Knyght John husbandman 586490 586490 Knyght, John, of Milverton, husbandman 4
4937812 2338211 2338211 defendant atte Water Richard husbandman 586490 586490 atte Water, Richard, of Milverton, husbandman 2
4938938 2338569 2338569 defendant Hoper John fisher 586490 586490 Hoper, John, of Milverton, fisher 0
4942201 2339548 2339548 defendant Trokyll John fisher 586490 586490 Trokyll, John, of Milverton, fisher 4
4963479 2345989 2345989 defendant Gregory Walter husbandman 586490 586490 Gregory, Walter, of Milverton, husbandman 1
4964311 2346239 2346239 plaintiff Clede Thomas tanner 586490 586490 Clede, Thomas, of Milverton, tanner 0
4964519 2346294 2346294 defendant Canon Henry baker 586490 586490 Canon, Henry, of Milverton, baker 0
4965915 2346738 2346738 defendant Alwey John tanner 586490 586490 Alwey, John, of Milverton, tanner 1
4982225 2351603 2351603 defendant Swenger John husbandman 586490 586490 Swenger, John, of Milverton, husbandman 1
4989214 2353708 2353708 defendant Hoper John fishmonger 586490 586490 Hoper, John, of Milverton, fishmonger 0
5034945 2367079 2367079 defendant Smok John butcher 586490 586490 Smok, John, of Milverton, butcher 0
5034947 2367080 2367080 defendant Smok John butcher 586490 586490 Smok, John, of Milverton, butcher 0
5055699 2373273 2373273 defendant Perrot William, senior husbandman 586490 586490 Perrot, William, senior, of Milverton, husbandman 4
5074937 2379010 2379010 defendant Holdyche William mercer 586490 586490 Holdyche, William, of Milverton, mercer 3
5076867 2379575 2379575 defendant Hamelyn Thomas yeoman 586490 586490 Hamelyn, Thomas, of Milverton, yeoman 0
5076868 2379575 2379575 defendant Powey John yeoman 586490 586490 Powey, John, of Milverton, yeoman 1
5076869 2379575 2379575 defendant Shapelyng John yeoman 586490 586490 Shapelyng, John, of Milverton, yeoman 2
5076870 2379575 2379575 defendant Segar Thomas yeoman 586490 586490 Segar, Thomas, of Milverton, yeoman 3
5133103 2396166 2396166 defendant Fursy Robert husbandman 586490 586490 Fursy, Robert, of Milverton, husbandman 1
5133104 2396166 2396166 defendant Husband (illegible) yeoman 586490 586490 Husband, ---, of Milverton, yeoman 2
5239502 2427138 2427138 defendant Burnard John tailor 586490 586490 Burnard, John, of Milverton, tailor 0
5310574 2448198 2448198 defendant Newenham James gent 586490 586490 Newenham, James, of Milverton, gent 0
5326857 2453107 2453107 defendant Alwey John yeoman 586490 586490 Alwey, John, of Milverton, yeoman 0
5334320 2455335 2455335 defendant Dyer Thomas dyer 586490 586490 Dyer, Thomas, of Milverton, dyer 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);