names

338 rows where place_id = 585995

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587652 1863783 1863783 defendant Grene John husbandman 585995 585995 Grene, John, of Neweton, husbandman 0
3602694 1868506 1868506 defendant Dawes John yeoman 585995 585995 Dawes, John, of Neweton, yeoman 0
3604091 1868946 1868946 defendant Waspe Edmund husbandman 585995 585995 Waspe, Edmund, of Neweton, husbandman 2
3608062 1870174 1870174 defendant Swyfte John husbandman 585995 585995 Swyfte, John, of Neweton, husbandman 1
3608063 1870174 1870174 defendant Copildike Thomas husbandman 585995 585995 Copildike, Thomas, of Neweton, husbandman 2
3612356 1871496 1871496 defendant Weyver Thomas yeoman 585995 585995 Weyver, Thomas, of Neweton, yeoman 3
3612357 1871496 1871496 defendant Weyver John cordwainer 585995 585995 Weyver, John, of Neweton, cordwainer 4
3614297 1872133 1872133 defendant Penyngton Adam gent 585995 585995 Penyngton, Adam, of Neweton, Cumber, gent 0
3620189 1873891 1873891 defendant Barne Richard mariner 585995 585995 Barne, Richard, of Neweton Abbot, mariner 1
3621908 1874393 1874393 defendant Merkyn Richard yeoman 585995 585995 Merkyn, Richard, of Neweton, yeoman 7
3874275 1981618 1981618 defendant Dunne Richard yeoman 585995 585995 Dunne, Richard, of Neweton, yeoman 0
4436480 2176147 2176147 plaintiff Sirych John   585995 585995 Sirych, John, of Neweton 0
4462758 2189050 2189050 defendant Spak William   585995 585995 Spak, William, of Neweton 2
4462921 2189099 2189099 defendant Sprot Richard   585995 585995 Sprot, Richard, of Neweton 0
4473192 2192279 2192279 plaintiff Creketot William   585995 585995 Creketot, William, of Neweton 0
4473197 2192280 2192280 plaintiff Creketot William   585995 585995 Creketot, William, of Neweton 0
4501542 2201085 2201085 defendant Atkynson Henry   585995 585995 Atkynson, Henry, of Neweton 2
4503459 2201653 2201653 defendant Wyresdale William   585995 585995 Wyresdale, William, of Neweton 1
4503460 2201653 2201653 defendant Boweman John   585995 585995 Boweman, John, of Neweton 2
4503461 2201653 2201653 defendant Lyverton Thomas   585995 585995 Lyverton, Thomas, of Neweton 3
4503462 2201653 2201653 defendant Sawyer John   585995 585995 Sawyer, John, of Neweton 4
4503463 2201653 2201653 defendant Pyndere Thomas   585995 585995 Pyndere, Thomas, of Neweton 5
4503464 2201653 2201653 defendant Poydell John   585995 585995 Poydell, John, of Neweton 6
4503763 2201741 2201741 defendant Taillour Robert   585995 585995 Taillour, Robert, of Neweton 0
4506567 2202542 2202542 defendant Gudale John, junior   585995 585995 Gudale, John, junior, of Neweton 2
4518263 2206086 2206086 defendant Brerelay Thomas   585995 585995 Brerelay, Thomas, of Neweton 2
4519509 2206460 2206460 defendant Derby John   585995 585995 Derby, John, of Neweton 0
4520927 2206885 2206885 defendant Burton John   585995 585995 Burton, John, of Neweton 0
4522254 2207304 2207304 defendant Penges_ William   585995 585995 Penges_, William, of Neweton 1
4522262 2207305 2207305 defendant Pengeston William   585995 585995 Pengeston, William, of Neweton 2
4523433 2207651 2207651 defendant Thornton Robert   585995 585995 Thornton, Robert, of Neweton 0
4523562 2207693 2207693 defendant Anlaby Peter   585995 585995 Anlaby, Peter, of neweton 0
4534366 2211017 2211017 defendant Jakson Robert   585995 585995 Jakson, Robert, of Neweton 0
4534659 2211112 2211112 plaintiff Scot William   585995 585995 Scot, William, of Neweton 0
4538435 2212308 2212308 defendant Babbecombe Nicholas   585995 585995 Babbecombe, Nicholas, of Neweton 0
4543042 2213715 2213715 defendant Burton John   585995 585995 Burton, John, of Neweton 0
4547076 2215020 2215020 defendant Blankpayn John   585995 585995 Blankpayn, John, of Neweton 2
4548020 2215316 2215316 defendant Pete John   585995 585995 Pete, John, of Neweton 1
4548021 2215316 2215316 defendant Dune John   585995 585995 Dune, John, of Neweton 2
4548022 2215316 2215316 defendant Atkynson William   585995 585995 Atkynson, William, of Neweton 3
4548470 2215462 2215462 defendant Sewall John   585995 585995 Sewall, John, of Neweton 0
4552263 2216663 2216663 defendant Brysete Richard   585995 585995 Brysete, Richard, of Neweton 0
4554234 2217252 2217252 defendant del Strother Henry   585995 585995 del Strother, Henry, of Neweton 1
4554239 2217253 2217253 defendant del Strother Henry   585995 585995 del Strother, Henry, of Neweton 1
4556547 2217984 2217984 plaintiff Huntley John   585995 585995 Huntley, John, of Neweton 0
4559751 2219003 2219003 defendant Barkeby Robert de   585995 585995 Barkeby, Robert de, of Neweton 1
4559752 2219003 2219003 defendant Shepherd William   585995 585995 Shepherd, William, of Neweton 2
4561858 2219642 2219642 plaintiff Pese John   585995 585995 Pese, John, of Neweton 0
4561860 2219643 2219643 plaintiff Pese John   585995 585995 Pese, John, of Neweton 0
4571216 2222565 2222565 defendant Warter Hugh   585995 585995 Warter, Hugh, of Neweton 1
4571790 2222763 2222763 plaintiff Apthwayt Richard   585995 585995 Apthwayt, Richard, of Neweton 0
4580039 2225245 2225245 defendant atte Nore John   585995 585995 atte Nore, John, of Neweton 0
4586596 2227216 2227216 defendant Wilmot William   585995 585995 Wilmot, William, of Neweton 3
4593716 2229308 2229308 defendant Dyre Roger   585995 585995 Dyre, Roger, of Neweton 0
4593719 2229309 2229309 defendant Dyre Roger   585995 585995 Dyre, Roger, of Neweton 0
4614037 2235404 2235404 defendant Hille John   585995 585995 Hille, John, of Neweton 0
4618369 2236757 2236757 defendant Neweton Hugh de   585995 585995 Neweton, Hugh de, of Neweton, son of Reginald 0
4623132 2238210 2238210 defendant Wyllys John   585995 585995 Wyllys, John, of Neweton 2
4624182 2238544 2238544 defendant Wylmote William   585995 585995 Wylmote, William, of Neweton 0
4632674 2241104 2241104 defendant Barwe John   585995 585995 Barwe, John, of Neweton 1
4633037 2241201 2241201 defendant Robertessone Henry   585995 585995 Robertessone, Henry, of Neweton 1
4634323 2241579 2241579 defendant Raulyn John   585995 585995 Raulyn, John, of Neweton 0
4637176 2242426 2242426 defendant Turnour Alexander   585995 585995 Turnour, Alexander, of Neweton 4
4645511 2244756 2244756 plaintiff Neweton William de   585995 585995 Neweton, William de, of Neweton 0
4647994 2245480 2245480 defendant Bacon Stephen   585995 585995 Bacon, Stephen, of Neweton 2
4656321 2247868 2247868 defendant Sogyowe William tinner 585995 585995 Sogyowe, William, of Neweton, tinner 3
4656381 2247889 2247889 defendant Watson John husbandman 585995 585995 Watson, John, of Neweton, husbandman 0
4656382 2247889 2247889 defendant Watson Hugh husbandman 585995 585995 Watson, Hugh, of Neweton, husbandman 1
4656383 2247889 2247889 defendant Spragan William husbandman 585995 585995 Spragan, William, of Neweton, husbandman 2
4656384 2247889 2247889 defendant Spragan John smith 585995 585995 Spragan, John, of Neweton, smith 3
4656386 2247890 2247890 defendant Watson John husbandman 585995 585995 Watson, John, of Neweton, husbandman 0
4656387 2247890 2247890 defendant Watson Hugh husbandman 585995 585995 Watson, Hugh, of Neweton, husbandman 1
4656388 2247890 2247890 defendant Spragan William husbandman 585995 585995 Spragan, William, of Neweton, husbandman 2
4656389 2247890 2247890 defendant Spragan John smith 585995 585995 Spragan, John, of Neweton, smith 3
4656582 2247951 2247951 defendant Sergant Thomas laborer 585995 585995 Sergant, Thomas, of Neweton, laborer 5
4657970 2248379 2248379 defendant Porter Thomas husbandman 585995 585995 Porter, Thomas, of Neweton Morker, husbandman 0
4657971 2248379 2248379 defendant Gefson William husbandman 585995 585995 Gefson, William, of Neweton Morker, husbandman 1
4657972 2248379 2248379 defendant Lemyng Richard husbandman 585995 585995 Lemyng, Richard, of Neweton Morker, husbandman 2
4657973 2248379 2248379 defendant Hunton William husbandman 585995 585995 Hunton, William, of Neweton Morker, husbandman 3
4657974 2248379 2248379 defendant Lytster Thomas husbandman 585995 585995 Lytster, Thomas, of Neweton Morker, husbandman 4
4657975 2248379 2248379 defendant Shephyrd William husbandman 585995 585995 Shephyrd, William, of Neweton Morker, husbandman 5
4657976 2248379 2248379 defendant Nicolson Thomas husbandman 585995 585995 Nicolson, Thomas, of Neweton Morker, husbandman 6
4657977 2248379 2248379 defendant Smyth Adam husbandman 585995 585995 Smyth, Adam, of Neweton Morker, husbandman 7
4657978 2248379 2248379 defendant More John husbandman 585995 585995 More, John, of Neweton Morker, husbandman 8
4657979 2248379 2248379 defendant Spense John husbandman 585995 585995 Spense, John, of Neweton Morker, husbandman 9
4657980 2248379 2248379 defendant Gefson John husbandman 585995 585995 Gefson, John, of Neweton Morker, husbandman 10
4657981 2248379 2248379 defendant Carter Stephen husbandman 585995 585995 Carter, Stephen, of Neweton Morker, husbandman 11
4657982 2248379 2248379 defendant Pygot John husbandman 585995 585995 Pygot, John, of Neweton Morker, husbandman 12
4659914 2248955 2248955 defendant Gybbe Nicholas jusbandman 585995 585995 Gybbe, Nicholas, of Neweton, jusbandman 1
4659922 2248955 2248955 defendant Burghton Ralph husbandman 585995 585995 Burghton, Ralph, of Neweton, husbandman 9
4663484 2250055 2250055 defendant Frelond John   585995 585995 Frelond, John, of Neweton, franklin 0
4663485 2250055 2250055 defendant Tanner John husbandman 585995 585995 Tanner, John, of Neweton, husbandman 1
4663486 2250055 2250055 defendant atte Towenesende Richard husbandman 585995 585995 atte Towenesende, Richard, of Neweton, husbandman 2
4663487 2250055 2250055 defendant Boure John husbandman 585995 585995 together with Boure, John, of Neweton, husbandman 3
4663850 2250178 2250178 defendant Gray William husbandman 585995 585995 Gray, William, of Neweton, husbandman 1
4666102 2250864 2250864 defendant Bowepit Nicholas husbandman 585995 585995 Bowepit, Nicholas, of Neweton, husbandman 5
4680015 2259353 2259353 defendant Carpenter Geoffrey husbandman 585995 585995 Carpenter, Geoffrey, of Neweton, husbandman 0
4680302 2259452 2259452 defendant Peche Robert yeoman 585995 585995 Peche, Robert, of Neweton, yeoman 2
4680303 2259452 2259452 defendant Symmyngwhayt William yeoman 585995 585995 Symmyngwhayt, William, of Neweton, yeoman 3
4685392 2261026 2261026 defendant Auncell William husbandman 585995 585995 Auncell, William, of Neweton, husbandman 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);