names

109 rows where place_id = 588045

✎ 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
3593177 1865497 1865497 plaintiff Harryngton Robert esq 588045 588045 Harryngton, Robert, of Exton, esq 0
3685070 1921475 1921475 defendant Vycary Robert husbandman 588045 588045 Vycary, Robert, of Exton, husbandman 0
3704021 1927545 1927545 defendant Monke John yeoman 588045 588045 Monke, John, of Exton, yeoman 1
3704022 1927545 1927545 defendant Salysbury John yeoman 588045 588045 Salysbury, John, of Exton, yeoman 2
3708283 1928885 1928885 defendant Salysbury John yeoman 588045 588045 Salysbury, John, of Exton, yeoman 0
3710340 1929552 1929552 defendant Wytherygge David husbandman 588045 588045 Wytherygge, David, of Exton, husbandman 0
3738690 1938309 1938309 defendant Vycary William yeoman 588045 588045 Vycary, William, of Exton, yeoman 0
3776154 1950285 1950285 defendant Hunt William yeoman 588045 588045 Hunt, William, of Exton, yeoman 1
3787278 1953813 1953813 defendant Dawe Thomas husbandman 588045 588045 Dawe, Thomas, of Exton, husbandman 0
3811139 1961380 1961380 defendant Fauconer Thomas yeoman 588045 588045 Fauconer, Thomas, of Exton, yeoman 1
3812944 1961945 1961945 defendant Awten John husbandman 588045 588045 Awten, John, of Exton, husbandman 0
3883148 1984625 1984625 defendant Baker John husbandman 588045 588045 Baker, John, of Exton, husbandman 0
3884434 1985064 1985064 defendant Cutlett Cuthbert husbandman 588045 588045 Cutlett, Cuthbert, of Exton, husbandman 0
4009128 2028031 2028031 plaintiff Myddylton John yeoman 588045 588045 Myddylton, John, of Exton, yeoman 0
4034421 2036983 2036983 plaintiff Harryngton James   588045 588045 Harryngton, James, of Exton, knight 0
4187373 2091085 2091085 defendant Tayler Richard yeoman 588045 588045 Tayler, Richard, of Exton, yeoman 1
4218074 2101818 2101818 defendant Fardell William yeoman 588045 588045 Fardell, William, of Exton, yeoman 2
4434390 2175509 2175509 plaintiff Knoston Richard (legal representative) 588045 588045 Knoston, Richard, of Exton, executors of 0
4434391 2175509 2175509 plaintiff Taillour John   588045 588045 (Taillour, John, of Exton 1
4438985 2181487 2181487 defendant Walker John   588045 588045 Walker, John, of Exton 0
4456405 2187027 2187027 defendant Nyweman Thomas   588045 588045 Nyweman, Thomas, of Exton 8
4478782 2194032 2194032 defendant Calaywey John   588045 588045 Calaywey, John, of Exton 1
4478785 2194033 2194033 defendant Calaywey John   588045 588045 Calaywey, John, of Exton 1
4481431 2194885 2194885 defendant Smyth William   588045 588045 Smyth, William, of Exton 0
4502494 2201363 2201363 defendant Gybbe William   588045 588045 Gybbe, William, of Exton 3
4536480 2211684 2211684 defendant Ede (illegible)   588045 588045 Ede, _, of Exton 1
4549864 2215892 2215892 defendant Tawell William   588045 588045 Tawell, William, of Exton 0
4576935 2224292 2224292 defendant Warde John   588045 588045 Warde, John, of Exton 3
4641910 2243741 2243741 defendant Calewey John   588045 588045 Calewey, John, of Exton 2
4676273 2258192 2258192 plaintiff German William   588045 588045 German, William, of Exton 1
4677263 2258506 2258506 defendant Walsshe John   588045 588045 Walsshe, John, of Exton, parson 0
4677264 2258506 2258506 defendant atte Hoo Henry draper 588045 588045 with atte Hoo, Henry, of Exton, draper 1
4677266 2258507 2258507 defendant Walsshe John   588045 588045 Walsshe, John, of Exton, parson 0
4677267 2258507 2258507 defendant atte Hoo Henry draper 588045 588045 atte Hoo, Henry, of Exton, draper 1
4695507 2264076 2264076 defendant Penter John husbandman 588045 588045 Penter, John, of Exton, husbandman 0
4766026 2285366 2285366 plaintiff Coteler William   588045 588045 Coteler, William, of Exton 1
4769736 2286505 2286505 defendant Nevell John husbandman 588045 588045 Nevell, John, of Exton, husbandman 4
4782268 2290456 2290456 defendant Fleccher John fletcher 588045 588045 Fleccher, John, of Exton, fletcher 0
4814860 2300758 2300758 defendant Jore William husbandman 588045 588045 Jore, William, of Exton, husbandman 0
4829094 2305141 2305141 defendant Vycory Hugh husbandman 588045 588045 Vycory, Hugh, of Exton, husbandman 0
4833058 2306357 2306357 defendant Webster John husbandman 588045 588045 Webster, John, of Exton, husbandman 0
4843892 2309608 2309608 plaintiff Mey William   588045 588045 Mey, William, of Exton 0
4847060 2310584 2310584 defendant Hart John yeoman 588045 588045 Hart, John, of Exton, yeoman 4
4848881 2311116 2311116 plaintiff Smyth John   588045 588045 Smyth, John, of Exton 0
4848883 2311117 2311117 plaintiff Smyth John   588045 588045 Smyth, John, of Exton 0
4852477 2312195 2312195 plaintiff Webster John   588045 588045 Webster, John, of Exton 0
4862725 2315327 2315327 defendant Crempeto John husbandman 588045 588045 Crempeto, John, of Exton, husbandman 0
4865207 2316092 2316092 defendant Revell or Renell John husbandman 588045 588045 Revell or Renell, John, of Exton, husbandman 2
4865212 2316093 2316093 defendant Renell or Revell John husbandman 588045 588045 Renell or Revell, John, of Exton, husbandman 1
4871981 2318215 2318215 defendant Baron John butcher 588045 588045 Baron, John, of Exton, butcher 5
4900818 2326886 2326886 defendant Boleworthy Richard husbandman 588045 588045 Boleworthy, Richard, of Exton, husbandman 0
4921172 2333139 2333139 defendant Kippyng Henry gent 588045 588045 Kippyng, Henry, of Exton, gent 1
4921173 2333139 2333139 defendant Seward John yeoman 588045 588045 Seward, John, of Exton, yeoman 2
4921174 2333139 2333139 defendant Coverdale William yeoman 588045 588045 Coverdale, William, of Exton, yeoman 3
4921178 2333140 2333140 defendant Seward John yeoman 588045 588045 Seward, John, of Exton, yeoman 1
4921179 2333140 2333140 defendant Coverdale William yeoman 588045 588045 Coverdale, William, of Exton, yeoman 2
4923091 2333641 2333641 defendant Westerdale Thomas husbandman 588045 588045 Westerdale, Thomas, of Exton, husbandman 0
4929840 2335748 2335748 plaintiff Taillour John   588045 588045 Taillour, John, of Exton 0
4929841 2335748 2335748 defendant Taillour John   588045 588045 Taillour, John, of Exton 0
4934497 2337184 2337184 plaintiff Auncell John husbandman 588045 588045 Auncell, John, of Exton, husbandman 0
4978339 2350471 2350471 defendant Stanley Robert courser 588045 588045 Stanley, Robert, of Exton, courser 0
4990023 2353927 2353927 defendant Fynecombe Robert husbandman 588045 588045 Fynecombe, Robert, of Exton, husbandman 0
4990024 2353927 2353927 defendant Croosse Robert husbandman 588045 588045 Croosse, Robert, of Exton, husbandman 1
4990026 2353928 2353928 defendant Smyth Walter smith 588045 588045 Smyth, Walter, of Exton, smith 0
4990027 2353928 2353928 defendant Rede John husbandman 588045 588045 Rede, John, of Exton, husbandman 1
5013428 2360763 2360763 defendant Fremantell Thomas husbandman 588045 588045 Fremantell, Thomas, of Exton, husbandman 0
5027051 2364782 2364782 defendant Atkyns John husbandman 588045 588045 Atkyns, John, of Exton, husbandman 0
5082365 2381223 2381223 defendant Hobbes John husbandman 588045 588045 Hobbes, John, of Exton, husbandman 0
5082366 2381223 2381223 defendant Hobbes Hugh husbandman 588045 588045 Hobbes, Hugh, of Exton, husbandman 1
5082367 2381223 2381223 defendant Stabull John husbandman 588045 588045 Stabull, John, of Exton, husbandman 2
5082368 2381223 2381223 defendant Clerk William husbandman 588045 588045 Clerk, William, of Exton, husbandman 3
5082369 2381223 2381223 defendant Souter John husbandman 588045 588045 Souter, John, of Exton, husbandman 4
5086750 2382519 2382519 defendant Cook William husbandman 588045 588045 Cook, William, of Exton, husbandman 0
5086751 2382519 2382519 defendant Milfam William husbandman 588045 588045 Milfam, William, of Exton, husbandman 1
5086752 2382519 2382519 defendant Haywode John husbandman 588045 588045 Haywode, John, of Exton, husbandman 2
5086753 2382519 2382519 defendant Smyth William husbandman 588045 588045 Smyth, William, of Exton, husbandman 3
5086754 2382519 2382519 defendant Baron Thomas husbandman 588045 588045 Baron, Thomas, of Exton, husbandman 4
5086755 2382519 2382519 defendant Smyth Henry husbandman 588045 588045 Smyth, Henry, of Exton, husbandman 5
5103749 2387518 2387518 defendant Dey Henry yeoman 588045 588045 Dey, Henry, of Exton, yeoman 0
5103752 2387519 2387519 defendant Deye Henry yeoman 588045 588045 Deye, Henry, of Exton, yeoman 0
5120918 2392548 2392548 defendant Barnaby John chaplain 588045 588045 Barnaby, John, of Exton, chaplain 0
5121206 2392631 2392631 defendant Norys William yeoman 588045 588045 Norys, William, of Exton, yeoman 1
5186144 2411697 2411697 defendant Saundyr William husbandman 588045 588045 Saundyr, William, of Exton, husbandman 0
5186146 2411698 2411698 defendant Saundyr William husbandman 588045 588045 Saundyr, William, of Exton, husbandman 0
5300644 2445155 2445155 defendant Laughton Robert husbandman 588045 588045 Laughton, Robert, of Exton, husbandman 0
5306619 2446969 2446969 defendant Goldsmyth Henry gent 588045 588045 Goldsmyth, Henry, of Exton, gent 0
5308366 2447539 2447539 defendant Stabull William yeoman 588045 588045 Stabull, William, of Exton, yeoman 0
5317185 2450222 2450222 defendant Goldesmyth Henry gent 588045 588045 Goldesmyth, Henry, of Exton, gent 3
5373842 2467416 2467416 defendant Goldsmyth Henry gent 588045 588045 Goldsmyth, Henry, of Exton, gent 0
5386623 2471237 2471237 defendant Haryngton Thomas gent 588045 588045 Haryngton, Thomas, of Exton, gent 2
5394622 2473522 2473522 defendant Dowener William miller 588045 588045 Dowener, William, of Exton, miller 1
5395024 2473643 2473643 defendant Haryngon Thomas gent 588045 588045 Haryngon, Thomas, of Exton, gent 2
5411533 2478408 2478408 defendant Tomson John shoemaker 588045 588045 Tomson, John, of Exton, shoemaker 0
5426583 2482897 2482897 defendant Haryngton Thomas gent 588045 588045 Haryngton, Thomas, of Exton, gent 2
5426592 2482899 2482899 defendant Harryngton Thomas gent 588045 588045 Harryngton, Thomas, of Exton, gent 2
5457370 2492105 2492105 defendant Harryngton Thomas gent 588045 588045 Harryngton, Thomas, of Exton, gent 2
5474779 2497439 2497439 defendant Leek John husbandman 588045 588045 Leek, John, of Exton, husbandman 1
5490695 2502110 2502110 defendant Thornton John husbandman 588045 588045 Thornton, John, of Exton, husbandman 1
5490696 2502110 2502110 defendant Salysbury Thomas husbandman 588045 588045 Salysbury, Thomas, of Exton, husbandman 2
5491995 2502513 2502513 defendant Kyng John butcher 588045 588045 Kyng, John, of Exton, butcher 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);