names

104 rows where place_id = 603624

✎ 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
3655162 1911874 1911874 defendant Michell Drugon merchant 603624 603624 Michell, Drugon, of Truro, merchant 0
3655168 1911875 1911875 defendant Michell John merchant 603624 603624 Michell, John, of Truro, merchant 0
3656833 1912394 1912394 defendant Treweke John merchant 603624 603624 Treweke, John, of Truro, merchant 0
3663667 1914571 1914571 defendant Dyer Thomas dyer 603624 603624 Dyer, Thomas, of Truro, dyer 0
3664070 1914713 1914713 defendant Lanehyne or Lavehyne William gent 603624 603624 Lanehyne or Lavehyne, William, of Truro, gent 0
3666255 1915395 1915395 defendant Michell Drucon merchant 603624 603624 Michell, Drucon, of Truro, merchant 0
3666256 1915395 1915395 defendant Jemyn John merchant 603624 603624 Jemyn, John, of Truro, merchant 1
3666257 1915395 1915395 defendant Treveneth John clerk 603624 603624 Treveneth, John, of Truro, clerk 2
3666258 1915395 1915395 defendant Norton Otto butcher 603624 603624 Norton, Otto, of Truro, butcher 3
3885862 1985528 1985528 defendant Condorowe alias Wyllyam Thomas merchant 603624 603624 Condorowe alias Wyllyam, Thomas, of Truro, merchant 0
3928266 1999788 1999788 defendant Drewe Thomas draper 603624 603624 Drewe, Thomas, of Truro, draper 0
3930116 2000419 2000419 plaintiff Coke John   603624 603624 Coke, John, of Truro 0
3931923 2000978 2000978 defendant Danyell Richard carpeter 603624 603624 Danyell, Richard, of Truro, carpeter 0
3934861 2001962 2001962 defendant Porkyllys John tailor 603624 603624 Porkyllys, John, of Truro, tailor 0
3940668 2003885 2003885 defendant Condorowe Thomas merchant 603624 603624 Condorowe, Thomas, of Truro, merchant 0
3960956 2010931 2010931 plaintiff Thomas John gent 603624 603624 Thomas, John, of Truro, gent 0
4113709 2065187 2065187 defendant Singleton Richard yeoman 603624 603624 Singleton, Richard, of Truro, yeoman 0
4113710 2065187 2065187 defendant Laye William husbandman 603624 603624 Laye, William, of Truro, husbandman 1
4113711 2065187 2065187 defendant Trosten George husbandman 603624 603624 Trosten, George, of Truro, husbandman 2
4113712 2065187 2065187 defendant Richard Ralph husbandman 603624 603624 Richard, Ralph, of Truro, husbandman 3
4137326 2073699 2073699 defendant Traston alias Straughton George merchant 603624 603624 Traston alias Straughton, George, of Truro, merchant 0
4310756 2133905 2133905 defendant Kynge Henry husbandman 603624 603624 Kynge, Henry, of Truro, husbandman 0
4458495 2187705 2187705 plaintiff Raulyn John   603624 603624 Raulyn, John, of Truro 0
4462422 2188938 2188938 defendant Wylle Thomas   603624 603624 Wylle, Thomas, of Truro, parson of the church of the BM 0
4463227 2189194 2189194 defendant Smyth John   603624 603624 Smyth, John, of Truro 2
4469351 2191082 2191082 defendant Map Reginald   603624 603624 Map, Reginald, of Truro 5
4469353 2191082 2191082 defendant Bouston John   603624 603624 Bouston, John, of Truro 7
4469354 2191082 2191082 defendant Peautrer Richard   603624 603624 Peautrer, Richard, of Truro 8
4469355 2191082 2191082 defendant Thomas John   603624 603624 Thomas, John, of Truro 9
4469364 2191084 2191084 defendant Map Reginald   603624 603624 with Map, Reginald, of Truro 4
4469367 2191084 2191084 defendant Donston John   603624 603624 Donston, John, of Truro 7
4469368 2191084 2191084 defendant Peautrer Richard   603624 603624 Peautrer, Richard, of Truro 8
4469369 2191084 2191084 defendant Thomas Joan   603624 603624 Thomas, Joan, of Truro 9
4502185 2201283 2201283 plaintiff Meger John   603624 603624 Meger, John, of Truro 0
4502188 2201283 2201283 defendant Emond Jhn brasier 603624 603624 Emond, Jhn, of Truro, brasier 2
4502189 2201283 2201283 defendant Hopkyn John   603624 603624 Hopkyn, John, of Truro 3
4508791 2203228 2203228 plaintiff Archer John   603624 603624 Archer, John, of Truro 0
4523791 2207769 2207769 defendant Penhalo Ralph   603624 603624 Penhalo, Ralph, of Truro 0
4544569 2214217 2214217 defendant Penhall Ralph   603624 603624 Penhall, Ralph, of Truro 0
4549967 2215922 2215922 defendant Tremayn Rciahrd   603624 603624 Tremayn, Rciahrd, of Truro 2
4571801 2222767 2222767 plaintiff Archer John   603624 603624 Archer, John, of Truro 0
4572199 2222852 2222852 defendant John Thomas   603624 603624 John, Thomas, of Truro 11
4603536 2232292 2232292 defendant Thomma John   603624 603624 Thomma, John, of Truro 4
4605213 2232797 2232797 plaintiff Archer John   603624 603624 Archer, John, of Truro 0
4606368 2233108 2233108 plaintiff Bailly John   603624 603624 Bailly, John, of Truro 0
4623334 2238269 2238269 defendant Kembre Lawrence butcher 603624 603624 Kembre, Lawrence, of Truro, butcher 0
4623335 2238269 2238269 defendant Gwyn David   603624 603624 together with Gwyn, David, of Truro, glove maker 1
4632063 2240911 2240911 plaintiff Archer John   603624 603624 Archer, John, of Truro 1
4669094 2256042 2256042 plaintiff Bleyn John   603624 603624 Bleyn, John, of Truro 0
4669096 2256042 2256042 defendant Belzeter John belzetter or bellfounder 603624 603624 Belzeter, John, of Truro, belzetter or bellfounder 1
4669097 2256042 2256042 defendant Du John sadler 603624 603624 Du, John, of Truro, sadler 2
4669098 2256042 2256042 defendant Hopkyn John yeoman 603624 603624 Hopkyn, John, of Truro, yeoman 3
4669099 2256043 2256043 plaintiff Bleyn Ralph   603624 603624 Bleyn, Ralph, of Truro 0
4669100 2256043 2256043 defendant Seys James yeoman 603624 603624 Seys, James, of Truro, yeoman 0
4677882 2258697 2258697 defendant Praas William   603624 603624 Praas, William, of Truro, milward 0
4677884 2258698 2258698 defendant Prass William   603624 603624 Prass, William, of Truro, milward 0
4683552 2260460 2260460 plaintiff Sadeler Benedict   603624 603624 (Sadeler, Benedict, of Truro 1
4689085 2262147 2262147 defendant Vagge John weaver 603624 603624 Vagge, John, of Truro, weaver 1
4689086 2262147 2262147 defendant Porther Richard   603624 603624 Porther, Richard, of Truro, mason 2
4692191 2263078 2263078 defendant Du John sadler 603624 603624 Du, John, of Truro, sadler 1
4694277 2263710 2263710 plaintiff Bleyn John   603624 603624 Bleyn, John, of Truro 0
4694279 2263710 2263710 defendant Hopkyn John yeoman 603624 603624 Hopkyn, John, of Truro, yeoman 1
4694280 2263711 2263711 plaintiff Bleyn Ralph   603624 603624 Bleyn, Ralph, of Truro 0
4694281 2263711 2263711 defendant Seys James yeoman 603624 603624 Seys, James, of Truro, yeoman 0
4709429 2268304 2268304 defendant Condorolle Walter gent 603624 603624 Condorolle, Walter, of Truro, gent 0
4725937 2273399 2273399 defendant Ressant Henry laborer 603624 603624 Ressant, Henry, of Truro, laborer 3
4725938 2273399 2273399 defendant Due John sadler 603624 603624 Due, John, of Truro, sadler 4
4725939 2273399 2273399 defendant Herbert Mark laborer 603624 603624 Herbert, Mark, of Truro, laborer 5
4728659 2274201 2274201 defendant Brim Walter   603624 603624 Brim, Walter, of Truro, mill ward 0
4728660 2274201 2274201 defendant Hykke Thomas   603624 603624 Hykke, Thomas, of Truro, mill ward 1
4729389 2274409 2274409 defendant Urban Nicholas tailor 603624 603624 Urban, Nicholas, of Truro, tailor 1
4729390 2274409 2274409 defendant Trevyns William gent 603624 603624 Trevyns, William, of Truro, gent 2
4731614 2275079 2275079 defendant Whitten Richard butcher 603624 603624 Whitten, Richard, of Truro, butcher 0
4741314 2277955 2277955 defendant Aly John tanner 603624 603624 Aly, John, of Truro, tanner 2
4742935 2278446 2278446 plaintiff Clerk John   603624 603624 Clerk, John, of Truro, on his own account 0
4742937 2278446 2278446 defendant Power John tailor 603624 603624 Power, John, of truro, tailor 1
4750569 2280651 2280651 defendant Sebill Thomas tailor 603624 603624 Sebill, Thomas, of Truro, tailor 2
4768575 2286151 2286151 defendant Lybowe John merchant 603624 603624 Lybowe, John, of Truro, merchant 0
4769502 2286441 2286441 defendant Trefyns William yeoman 603624 603624 Trefyns, William, of Truro, yeoman 0
4770052 2286605 2286605 defendant Trefyns William yeoman 603624 603624 Trefyns, William, of Truro, yeoman 0
4774028 2287861 2287861 defendant Webber John husbandman 603624 603624 Webber, John, of Truro, husbandman 0
4820662 2302535 2302535 defendant Hendre Roger yeoman 603624 603624 Hendre, Roger, of Truro, yeoman 1
4820665 2302536 2302536 defendant Hendre Roger yeoman 603624 603624 Hendre, Roger, of Truro, yeoman 1
4825211 2303927 2303927 defendant Bleyn Ralph merchant 603624 603624 Bleyn, Ralph, of Truro, merchant 0
4850069 2311482 2311482 defendant Penros John gent 603624 603624 Penros, John, of Truro, gent 0
4908099 2329091 2329091 defendant Naustasek Henry mariner 603624 603624 Naustasek, Henry, of Truro, mariner 0
4908100 2329091 2329091 defendant Draper Martin merchant 603624 603624 Draper, Martin, of Truro, merchant 1
4908101 2329091 2329091 defendant Tramboll Nicholas merchant 603624 603624 Tramboll, Nicholas, of Truro, merchant 2
4930669 2336003 2336003 plaintiff Trevesythyk Reginald   603624 603624 Trevesythyk, Reginald, of Truro 0
5045239 2370204 2370204 defendant Melender John   603624 603624 Melender, John, of Truro, millward 1
5186887 2411907 2411907 defendant Lagharne William gent 603624 603624 Lagharne, William, of Truro, gent 0
5205435 2417342 2417342 defendant Lagharne William gent 603624 603624 Lagharne, William, of Truro, gent 0
5370189 2466261 2466261 defendant Trewyke Robert fuller of cloth 603624 603624 Trewyke, Robert, of Truro, fuller of cloth 0
5370190 2466261 2466261 defendant Trewyke Richard fuller of cloth 603624 603624 Trewyke, Richard, of Truro, fuller of cloth 1
5376696 2468307 2468307 defendant Jakpody Walter tailor 603624 603624 Jakpody, Walter, of Truro, tailor 1
5407158 2477107 2477107 defendant Veysy William gent 603624 603624 Veysy, William, of Truro, gent 1
5407172 2477110 2477110 defendant Marcowe John yeoman 603624 603624 Marcowe, John, of Truro, yeoman 3
5438924 2486563 2486563 defendant John Thomas merchant 603624 603624 John, Thomas, of Truro, merchant 1
5439126 2486626 2486626 defendant Veysy William gent 603624 603624 Veysy, William, of Truro, gent 1
5442939 2487800 2487800 defendant John Thomas merchant 603624 603624 John, Thomas, of Truro, merchant 2

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