names

192 rows where place_id = 604030

✎ 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
3656619 1912324 1912324 defendant Smyth John gent 604030 604030 Smyth, John, of Exeter, Devon, gent 0
3657260 1912531 1912531 defendant Currant Richard yeoman 604030 604030 Currant, Richard, of Exeter, Devon, yeoman 2
3659283 1913158 1913158 defendant Symon William yeoman 604030 604030 Symon, William, of Exeter, Devon, yeoman 1
3659886 1913348 1913348 defendant Slogge Robert chapman 604030 604030 Slogge, Robert, of Exeter, Devon, chapman 0
3661668 1913925 1913925 defendant Strete Henry   604030 604030 Strete, Henry, of Exeter, Devon, serjeant-at-arms 1
3667302 1915712 1915712 defendant Kyrkeham Nicholas esq 604030 604030 Kyrkeham, Nicholas, of Exeter, Devon, esq 0
3719317 1932330 1932330 defendant Copston Charles gent 604030 604030 Copston, Charles, of Exeter, Devon, gent 0
3940807 2003931 2003931 plaintiff Strowbrydge John merchant 604030 604030 Strowbrydge, John, of Exeter, Devon, merchant 0
4123463 2068696 2068696 defendant Will John husbandman 604030 604030 Will, John, of Exeter, of Exmynster, Devon, husbandman 1
4245588 2111502 2111502 defendant Stoneman John yeoman 604030 604030 Stoneman, John, of Exeter, of Aishwater, Devon, yeoman 0
4488196 2197022 2197022 defendant Harper Roger   604030 604030 Harper, Roger, of Exeter, Devon, parson of Holy Trinity church 0
4520770 2206836 2206836 defendant Aleyn Henry   604030 604030 Aleyn, Henry, of Exeter, Devon 0
4676167 2258159 2258159 defendant Eston Robert skinner 604030 604030 Eston, Robert, of Exeter, Devon, skinner 2
4683410 2260413 2260413 defendant Veysy Robert chapman 604030 604030 Veysy, Robert, of Exeter, Devon, chapman 0
4683437 2260422 2260422 defendant Neweman John chaplain 604030 604030 Neweman, John, of Exeter, Devon, chaplain 0
4684815 2260851 2260851 defendant Smyth John chapman 604030 604030 Smyth, John, of Exeter, Devon, chapman 0
4684817 2260851 2260851 defendant Tuker Robert chapman 604030 604030 Tuker, Robert, of Exeter, Devon, chapman 2
4691021 2262716 2262716 defendant Crese Richard merchant 604030 604030 Crese, Richard, of Exeter, Devon, merchant 1
4694821 2263873 2263873 defendant Ersdekene Martin clerk 604030 604030 Ersdekene, Martin, of Exeter, Devon, clerk 0
4695913 2264207 2264207 defendant Archedekene Martin clerk 604030 604030 Archedekene, Martin, of Exeter, Devon, clerk 2
4698414 2264981 2264981 defendant Parke John clerk 604030 604030 Parke, John, of Exeter, Devon, clerk 0
4700185 2265478 2265478 defendant Archedekene Martin clerk 604030 604030 Archedekene, Martin, of Exeter, Devon, clerk 2
4700224 2265487 2265487 defendant Clement Richard skinner 604030 604030 Clement, Richard, of Exeter, Devon, skinner 3
4708699 2268094 2268094 defendant Lond Robert skinner 604030 604030 Lond, Robert, of Exeter, Devon, skinner 1
4708701 2268094 2268094 defendant Wastell Nicholas yeoman 604030 604030 Wastell, Nicholas, of Exeter, Devon, yeoman 3
4709201 2268244 2268244 defendant Veysy Robert chapman 604030 604030 Veysy, Robert, of Exeter, Devon, chapman 0
4713916 2269678 2269678 defendant Eston Thomas   604030 604030 Eston, Thomas, of Exeter, Devon, burgess 0
4714671 2269918 2269918 defendant Veysy Robert   604030 604030 Veysy, Robert, of Exeter, Devon 5
4714673 2269918 2269918 defendant Smyth Nicholas shipman 604030 604030 Smyth, Nicholas, of Exeter, Devon, shipman 7
4720152 2271646 2271646 defendant Benet John skinner 604030 604030 Benet, John, of Exeter, Devon, skinner 1
4723150 2272552 2272552 defendant Park John clerk 604030 604030 Park, John, of Exeter, Devon, clerk 0
4726703 2273622 2273622 defendant Swayn Henry dyer 604030 604030 Swayn, Henry, of Exeter, Devon, dyer 0
4727935 2273980 2273980 defendant Redman Thomas clerk 604030 604030 Redman, Thomas, of Exeter, Devon, clerk 0
4734326 2275907 2275907 defendant Bysshoppe Nicholas fuller 604030 604030 Bysshoppe, Nicholas, of Exeter, Devon, fuller 0
4734388 2275924 2275924 defendant Benet John skinner 604030 604030 Benet, John, of Exeter, Devon, skinner 2
4735372 2276207 2276207 defendant Norton Robert   604030 604030 Norton, Robert, of Exeter, Devon, bell maker 0
4746082 2279352 2279352 defendant Swayn Henry cyer 604030 604030 Swayn, Henry, of Exeter, Devon, cyer 0
4754749 2281868 2281868 defendant Pyll John gent 604030 604030 Pyll, John, of Exeter, Devon, gent 4
4757212 2282625 2282625 defendant Longe John chapman 604030 604030 Longe, John, of Exeter, Devon, chapman 0
4763834 2284682 2284682 plaintiff Hakkeworthy John   604030 604030 Hakkeworthy, John, of Exeter, Devon 0
4765033 2285039 2285039 defendant Morhay Robert husbandman 604030 604030 (Morhay, Robert, of Exeter, Devon, husbandman 1
4765037 2285040 2285040 defendant atte Haye John husbandman 604030 604030 atte Haye, John, of Exeter, Devon, husbandman 1
4768328 2286066 2286066 defendant Chambyre John de husbandman 604030 604030 (Chambyre, John de, of Exeter, Devon, husbandman 1
4769932 2286568 2286568 defendant Wastell Nicholas gent 604030 604030 Wastell, Nicholas, of Exeter, Devon, gent 0
4773877 2287809 2287809 defendant Laury John   604030 604030 Laury, John, of Exeter, Devon, glove maker 0
4774419 2287982 2287982 defendant Cobthorp Reginald carrier 604030 604030 Cobthorp, Reginald, of Exeter, Devon, carrier 0
4804714 2297674 2297674 defendant Pencrych William   604030 604030 Pencrych, William, of Exeter, Devon, archdeacon of St Davids 0
4805939 2298066 2298066 defendant Jorwarth Thomas   604030 604030 Jorwarth, Thomas, of Exeter, Devon, drover & of Irchenfeld, Wales 1
4805956 2298071 2298071 defendant Jorwarth Thomas   604030 604030 Jorwarth, Thomas, of Exeter, Devon, drover & of Irchenfled, Wales 1
4809236 2299063 2299063 defendant Penkerych William clerk 604030 604030 Penkerych, William, of Exeter, Devon, clerk 0
4815488 2300950 2300950 defendant Pruet John clerk 604030 604030 Pruet, John, of Exeter, Devon, clerk 1
4815493 2300952 2300952 defendant Pruet John   604030 604030 Pruet, John, of Exeter, Devon 1
4818725 2301944 2301944 defendant Noble John clerk 604030 604030 Noble, John, of Exeter, Devon, clerk 0
4819614 2302206 2302206 defendant Spicer John hosier 604030 604030 Spicer, John, of Exeter, Devon, hosier 0
4823757 2303519 2303519 defendant Morton John clerk 604030 604030 Morton, John, of Exeter, Devon, clerk 0
4824466 2303701 2303701 defendant Weston Simon husbandman 604030 604030 Weston, Simon, of Exeter, Devon, husbandman 0
4824472 2303702 2303702 defendant Holbyche John merchant 604030 604030 Holbyche, John, of Exeter, Devon, merchant 1
4824476 2303703 2303703 defendant Weston Simon husbandman 604030 604030 Weston, Simon, of Exeter, Devon, husbandman 0
4825164 2303913 2303913 defendant Talbot Richard gent & son of John Talbot 604030 604030 Talbot, Richard, of Exeter, Devon, gent & son of John Talbot 0
4825169 2303914 2303914 defendant Talbot Richard gent & son of John Talbot 604030 604030 Talbot, Richard, of Exeter, Devon, gent & son of John Talbot 0
4827087 2304516 2304516 defendant Raulyn John merchant 604030 604030 Raulyn, John, of Exeter, Devon, merchant 0
4831362 2305839 2305839 defendant Potter Richard dyer 604030 604030 Potter, Richard, of Exeter, Devon, dyer 3
4833263 2306413 2306413 defendant Crosse John merchant 604030 604030 Crosse, John, of Exeter, Devon, merchant 0
4834301 2306737 2306737 defendant Body Stephen skinner 604030 604030 Body, Stephen, of Exeter, Devon, skinner 4
4834307 2306738 2306738 defendant Body Stephen skinner 604030 604030 Body, Stephen, of Exeter, Devon, skinner 4
4837026 2307538 2307538 defendant Pencrych William   604030 604030 Pencrych, William, of Exeter, Devon, clerk & of St David's, archdeacon 0
4837030 2307540 2307540 defendant Pencrych William   604030 604030 Pencrych, William, of Exeter, Devon, clerk, alias arch deacon of Wales 0
4839026 2308135 2308135 defendant Legh Robert husbandman 604030 604030 Legh, Robert, of Exeter, Devon, husbandman 0
4841729 2308951 2308951 defendant Pencriche William   604030 604030 Pencriche, William, of Exeter, Devon, canon of the cathedral church 0
4842694 2309252 2309252 defendant Pyke Joyhn skinner 604030 604030 Pyke, Joyhn, of Exeter, Devon, skinner 0
4849592 2311347 2311347 defendant Legh William gent 604030 604030 Legh, William, of Exeter, Devon, gent 1
4851100 2311794 2311794 defendant Morton John clerk 604030 604030 Morton, John, of Exeter, Devon, clerk 0
4909149 2329405 2329405 defendant Bromford Robert loder 604030 604030 Bromford, Robert, of Exeter, Devon, loder 0
4911516 2330103 2330103 defendant Pencryeth William clerk 604030 604030 Pencryeth, William, of Exeter, Devon, clerk 0
4913806 2330819 2330819 defendant Pencrych William clerk 604030 604030 Pencrych, William, of Exeter, Devon, clerk 0
4914059 2330907 2330907 defendant Coyll Simon goldsmith 604030 604030 Coyll, Simon, of Exeter, Devon, goldsmith 1
4916172 2331560 2331560 defendant Polford John clerk 604030 604030 Polford, John, of Exeter, Devon, clerk 0
4916335 2331610 2331610 defendant Polford John clerk 604030 604030 Polford, John, of Exeter, Devon, clerk 0
4918197 2332212 2332212 defendant Norton William merchant 604030 604030 Norton, William, of Exeter, Devon, merchant 0
4919579 2332625 2332625 defendant atte Welle William merchant 604030 604030 atte Welle, William, of Exeter, Devon, merchant 0
4925253 2334328 2334328 defendant Weston Simon merchant 604030 604030 Weston, Simon, of Exeter, Devon, merchant 0
4926920 2334848 2334848 defendant mIlle John gent 604030 604030 mIlle, John, of Exeter, Devon, gent 3
4928400 2335303 2335303 defendant Pencriche William clerk 604030 604030 Pencriche, William, of Exeter, Devon, clerk 0
4928402 2335304 2335304 defendant Pencriche William clerk 604030 604030 Pencriche, William, of Exeter, Devon, clerk 0
4932237 2336483 2336483 defendant Caryere Ralph carrier 604030 604030 Caryere, Ralph, of Exeter, Devon, carrier 0
4989357 2353752 2353752 defendant Person Thomas skinner 604030 604030 Person, Thomas, of Exeter, Devon, skinner 0
4989362 2353753 2353753 defendant Person Thomas skinner 604030 604030 Person, Thomas, of Exeter, Devon, skinner 0
4998756 2356516 2356516 defendant Penkryche William clerk 604030 604030 Penkryche, William, of Exeter, Devon, clerk 3
4999718 2356795 2356795 defendant Penrcyche William clerk 604030 604030 Penrcyche, William, of Exeter, Devon, clerk 0
5000331 2356968 2356968 defendant Haddon Hugh mercer 604030 604030 Haddon, Hugh, of Exeter, Devon, mercer 2
5000357 2356971 2356971 defendant Haddon Hugh mercer 604030 604030 Haddon, Hugh, of Exeter, Devon, mercer 2
5000759 2357099 2357099 defendant Oterham Stephen merchant 604030 604030 Oterham, Stephen, of Exeter, Devon, merchant 0
5001632 2357369 2357369 plaintiff Clerk John   604030 604030 Clerk, John, of Exeter, Devon 1
5011266 2360153 2360153 defendant Whetetaker Gilbert skinner 604030 604030 Whetetaker, Gilbert, of Exeter, Devon, skinner 0
5011268 2360154 2360154 defendant Whetetaker Gilbert skinner 604030 604030 Whetetaker, Gilbert, of Exeter, Devon, skinner 0
5045732 2370358 2370358 defendant Duke William chapman 604030 604030 Duke, William, of Exeter, Devon, chapman 0
5046223 2370499 2370499 defendant Clerk John merchant 604030 604030 Clerk, John, of Exeter, Devon, merchant 0
5047814 2370962 2370962 defendant Clerk John merchant 604030 604030 Clerk, John, of Exeter, Devon, merchant 0
5048115 2371059 2371059 defendant atte Wylle John yeoman 604030 604030 atte Wylle, John, of Exeter, Devon, yeoman 1
5048255 2371113 2371113 defendant Kyrkeby Robert esq 604030 604030 Kyrkeby, Robert, of Exeter, Devon, esq 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);