names

78 rows where place_id = 598982

✎ 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
3634778 1905675 1905675 defendant Baker Richard innholder 598982 598982 Baker, Richard, of Mulverton, innholder 0
4055318 2044301 2044301 plaintiff Rudlond Thomas yeoman 598982 598982 Rudlond, Thomas, of Mulverton, yeoman 1
4207199 2098066 2098066 defendant Cuddon Francis gent 598982 598982 Cuddon, Francis, of Mulverton, gent 0
4261705 2116869 2116869 defendant Curson Hugh husbandman 598982 598982 Curson, Hugh, of Mulverton, husbandman 0
4285104 2124723 2124723 defendant Curson Agnes widow 598982 598982 Curson, Agnes, of Mulverton, widow 1
4386891 2160284 2160284 defendant Lythe William husbandman 598982 598982 Lythe, William, of Mulverton, husbandman 1
4454655 2186474 2186474 defendant Pope Richard   598982 598982 Pope, Richard, of Mulverton 0
4484234 2195769 2195769 defendant Helyer William   598982 598982 Helyer, William, of Mulverton 1
4496286 2199512 2199512 plaintiff Colle John   598982 598982 Colle, John, of Mulverton 0
4557854 2218386 2218386 plaintiff Legh William   598982 598982 Legh, William, of Mulverton 0
4586898 2227302 2227302 defendant Beche Richard   598982 598982 Beche, Richard, of Mulverton 0
4586900 2227303 2227303 defendant Boucher Richard   598982 598982 Boucher, Richard, of Mulverton 0
4636918 2242358 2242358 defendant Rychere John   598982 598982 Rychere, John, of Mulverton 1
4654516 2247289 2247289 defendant Forthyngton John   598982 598982 (Forthyngton, John, of Mulverton, holy water clerk 1
4654517 2247289 2247289 defendant Clode Thomas tanner 598982 598982 Clode, Thomas, of Mulverton, tanner 2
4657660 2248285 2248285 defendant Sampford Hugh   598982 598982 Sampford, Hugh, of Mulverton 0
4657663 2248285 2248285 defendant Powe Richard   598982 598982 Powe, Richard, of Mulverton 3
4657664 2248285 2248285 defendant Morle Thomas   598982 598982 Morle, Thomas, of Mulverton, "spelemaker" 4
4660890 2249230 2249230 defendant Fordyngton John   598982 598982 Fordyngton, John, of Mulverton, holy water clerk 2
4666159 2250885 2250885 defendant Benet John courser 598982 598982 Benet, John, of Mulverton, courser 0
4672518 2257054 2257054 plaintiff Cokkes John lawyer 598982 598982 Cokkes, John, of Mulverton, lawyer 0
4672520 2257054 2257054 defendant Morley Thomas husbandman 598982 598982 with Morley, Thomas, of Mulverton, husbandman 1
4672523 2257054 2257054 defendant Muskam John husbandman 598982 598982 Muskam, John, of Mulverton, husbandman 4
4672524 2257055 2257055 plaintiff Cokkes John lawyer 598982 598982 Cokkes, John, of Mulverton, lawyer, on his own account 0
4672525 2257055 2257055 defendant Morley Thomas husbandman 598982 598982 Morley, Thomas, of Mulverton, husbandman 0
4672528 2257055 2257055 defendant Muskam John husbandman 598982 598982 Muskam, John, of Mulverton, husbandman 3
4696191 2264290 2264290 defendant Rawle John tanner 598982 598982 Rawle, John, of Mulverton, tanner 0
4696193 2264291 2264291 defendant Hurdyng Thomas tanner 598982 598982 Hurdyng, Thomas, of Mulverton, tanner 0
4696197 2264293 2264293 defendant Hull Robert husbandman 598982 598982 Hull, Robert, of Mulverton, husbandman 0
4696198 2264293 2264293 defendant Cornyssh Thomas   598982 598982 Cornyssh, Thomas, of Mulverton, shoe maker 1
4696201 2264293 2264293 defendant Bonwedon William butcher 598982 598982 Bonwedon, William, of Mulverton, butcher 4
4696204 2264294 2264294 defendant Gregory Walter husbandman 598982 598982 Gregory, Walter, of Mulverton, husbandman 0
4696205 2264294 2264294 defendant atte Rygge John husbandman 598982 598982 atte Rygge, John, of Mulverton, husbandman 1
4696206 2264294 2264294 defendant Knyght William husbandman 598982 598982 Knyght, William, of Mulverton, husbandman 2
4704332 2266733 2266733 defendant Canon Henry yeoman 598982 598982 Canon, Henry, of Mulverton, yeoman 0
4704335 2266733 2266733 defendant Bowedon William butcher 598982 598982 Bowedon, William, of Mulverton, butcher 3
4704342 2266734 2266734 defendant Basset John husbandman 598982 598982 Basset, John, of Mulverton, husbandman 4
4704343 2266734 2266734 defendant Cole John husbandman 598982 598982 Cole, John, of Mulverton, husbandman 5
4704344 2266734 2266734 defendant Roe William husbandman 598982 598982 Roe, William, of Mulverton, husbandman 6
4710067 2268504 2268504 defendant Rither John, sen husbandman 598982 598982 Rither, John, sen, of Mulverton, husbandman 0
4713955 2269693 2269693 defendant Peyton alias Hopere Robert husbandman 598982 598982 Peyton alias Hopere, Robert, of Mulverton, husbandman 1
4733043 2275514 2275514 defendant Richard John, sen husbandman 598982 598982 Richard, John, sen, of Mulverton, husbandman 0
4733045 2275514 2275514 defendant Bowedon William butcher 598982 598982 Bowedon, William, of Mulverton, butcher 2
4754649 2281836 2281836 defendant Warre William esq 598982 598982 Warre, William, of Mulverton, esq 0
4757382 2282679 2282679 defendant Mosselyn John husbandman 598982 598982 Mosselyn, John, of Mulverton, husbandman 0
4758518 2283044 2283044 defendant Devenyssh John smith 598982 598982 Devenyssh, John, of Mulverton, smith 0
4758520 2283045 2283045 defendant Wheler Henry tanner 598982 598982 Wheler, Henry, of Mulverton, tanner 0
4771363 2287027 2287027 plaintiff Sandford Hugh (legal representative) 598982 598982 Sandford, Hugh, of Mulverton, executors of 0
4788876 2292573 2292573 defendant Warre William esq 598982 598982 Warre, William, of Mulverton, esq 0
4808393 2298802 2298802 defendant Tanner Hugh tanner 598982 598982 Tanner, Hugh, of Mulverton, tanner 2
4810300 2299366 2299366 defendant Payn William, senior husbandman 598982 598982 Payn, William, senior, of Mulverton, husbandman 2
4814877 2300762 2300762 defendant atte Pury Nicholas husbandman 598982 598982 atte Pury, Nicholas, of Mulverton, husbandman 0
4822515 2303116 2303116 defendant Furseman Thomas dyer 598982 598982 Furseman, Thomas, of Mulverton, dyer 0
4833132 2306376 2306376 defendant Sandford William gent 598982 598982 Sandford, William, of Mulverton, gent 4
4833137 2306376 2306376 defendant Sandford Maud widow 598982 598982 Sandford, Maud, of Mulverton, widow 9
4838499 2307955 2307955 defendant Clode Thomas husbandman 598982 598982 Clode, Thomas, of Mulverton, husbandman 2
4841169 2308774 2308774 defendant Hurdyng Thomas husbandman 598982 598982 Hurdyng, Thomas, of Mulverton, husbandman 0
4845523 2310112 2310112 defendant Hille Richard husbandman 598982 598982 Hille, Richard, of Mulverton, husbandman 1
4859254 2314271 2314271 defendant Hurdyng William shoemaker 598982 598982 Hurdyng, William, of Mulverton, shoemaker 1
4859255 2314271 2314271 defendant Roo William carpenter 598982 598982 Roo, William, of Mulverton, carpenter 2
4859256 2314271 2314271 defendant Savage Thomas clerk 598982 598982 Savage, Thomas, of Mulverton, clerk 3
4859259 2314271 2314271 defendant Aldeway John, senior tanner 598982 598982 Aldeway, John, senior, of Mulverton, tanner 6
4859260 2314271 2314271 defendant Wyvelescombe William shoemaker 598982 598982 Wyvelescombe, William, of Mulverton, shoemaker 7
4859261 2314271 2314271 defendant Rendall John laborer 598982 598982 Rendall, John, of Mulverton, laborer 8
4859262 2314271 2314271 defendant Wille John laborer 598982 598982 Wille, John, of Mulverton, laborer 9
4859263 2314271 2314271 defendant Aldeway John, junior laborer 598982 598982 Aldeway, John, junior, of Mulverton, laborer 10
4865078 2316053 2316053 defendant Molton Roger tanner 598982 598982 Molton, Roger, of Mulverton, tanner 2
4879107 2320397 2320397 defendant Scotte William husbandman 598982 598982 Scotte, William, of Mulverton, husbandman 8
4924535 2334112 2334112 defendant Belsted Robert husbandman 598982 598982 Belsted, Robert, of Mulverton, husbandman 3
5046256 2370512 2370512 defendant Mere Richard fisher 598982 598982 Mere, Richard, of Mulverton, fisher 2
5142332 2398878 2398878 plaintiff Whiteside John, senior (legal representative) 598982 598982 Whiteside, John, senior, of Mulverton, tanner, executor of 0
5142335 2398879 2398879 plaintiff Whiteside John, senior (legal representative) 598982 598982 Whiteside, John, senior, of Mulverton, tanner, executor of 0
5201791 2416291 2416291 defendant Chalner John husbandman 598982 598982 Chalner, John, of Mulverton, husbandman 0
5246577 2429162 2429162 defendant Ederyche Walter husbandman 598982 598982 Ederyche, Walter, of Mulverton, husbandman 0
5359599 2463036 2463036 defendant Curteysse Robert husbandman 598982 598982 Curteysse, Robert, of Mulverton, husbandman 1
5628664 2552936 2552936 defendant Bowedon William butcher 598982 598982 Bowedon, William, of Mulverton, butcher 1
5628665 2552936 2552936 defendant Tanner William tanner 598982 598982 Tanner, William, of Mulverton, tanner 2
5630910 2553680 2553680 defendant Benet John husbandman 598982 598982 Benet, John, of Mulverton, husbandman 0

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