names

164 rows where place_id = 599723

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612120 1871434 1871434 defendant Enys or Guys Nicholas husbandman 599723 599723 Enys or Guys, Nicholas, of Plympton Prior, husbandman 0
3612121 1871434 1871434 defendant Wilberton Richard husbandman 599723 599723 Wilberton, Richard, of Plympton Prior, husbandman 1
3612128 1871434 1871434 defendant Strode William gent 599723 599723 Strode, William, of Plympton Prior, gent 8
3612129 1871434 1871434 defendant Strode Richard gent 599723 599723 Strode, Richard, of Plympton Prior, gent 9
3637977 1906698 1906698 defendant Norden Joan widow 599723 599723 Norden, Joan, of Plympton, widow 1
3656891 1912412 1912412 defendant (not given) John prior of -- 599723 599723 --, John, of Plympton, prior of the Monastery of St Peter & St Paul 0
3656893 1912413 1912413 defendant (not given) John prior of Howe 599723 599723 Howe, John, of Plympton, prior of the church of St Peter & St Paul 0
3656897 1912414 1912414 defendant (not given) John prior of Howe 599723 599723 Howe, John, of Plympton, prior of the church of St Peter & St Paul 1
3682149 1920524 1920524 defendant Ryke John gent 599723 599723 Ryke, John, of Plympton, gent 0
3682759 1920707 1920707 defendant Trewarth John mercer 599723 599723 Trewarth, John, of Plympton, mercer 0
3698246 1925675 1925675 defendant Whyte Richard husbandman 599723 599723 Whyte, Richard, of Plympton, husbandman 0
3752242 1942623 1942623 defendant Sherwell William weaver 599723 599723 Sherwell, William, of Plympton, weaver 1
3757562 1944343 1944343 defendant Baron William mercer 599723 599723 Baron, William, of Plympton, mercer 0
3761163 1945494 1945494 defendant Strode Richard esq 599723 599723 Strode, Richard, of Plympton, esq 0
3768377 1947754 1947754 defendant Beare John yeoman 599723 599723 Beare, John, of Plympton, yeoman 0
3781692 1952017 1952017 defendant Baron William mercer 599723 599723 Baron, William, of Plympton, mercer 0
3796408 1956745 1956745 defendant Strode Richard esq 599723 599723 Strode, Richard, of Plympton, esq 0
3810013 1961020 1961020 defendant Baron William mercer 599723 599723 Baron, William, of Plympton, mercer 0
3819967 1964125 1964125 defendant Barne William mercer 599723 599723 Barne, William, of Plympton, mercer 0
3819971 1964126 1964126 defendant Bere John baker 599723 599723 Bere, John, of Plympton, baker 0
3826785 1966230 1966230 defendant Wyet Richard smith 599723 599723 Wyet, Richard, of Plympton, smith 0
3851982 1974208 1974208 defendant Lyswyll John tanner 599723 599723 Lyswyll, John, of Plympton, tanner 6
3946386 2005808 2005808 defendant Hynston Robert husbandman 599723 599723 Hynston, Robert, of Plympton, husbandman 0
3946387 2005808 2005808 defendant Haywood John carpenter 599723 599723 Haywood, John, of Plympton, carpenter 1
3961074 2010967 2010967 defendant Holberton John laborer 599723 599723 Holberton, John, of Plympton, laborer 0
3973726 2015385 2015385 plaintiff Hake John   599723 599723 Hake, John, of Plympton 0
3977731 2016780 2016780 defendant Sperke John merchant 599723 599723 Sperke, John, of Plympton, merchant 0
3978673 2017118 2017118 plaintiff Molton William merchant 599723 599723 Molton, William, of Plympton, merchant 0
3978675 2017119 2017119 plaintiff Molton William merchant 599723 599723 Molton, William, of Plympton, merchant 0
3983503 2018874 2018874 plaintiff Sparke John merchant 599723 599723 Sparke, John, of Plympton, merchant 0
4066870 2048447 2048447 defendant Quashe Robert tailor 599723 599723 Quashe, Robert, of Plympton, tailor 2
4316354 2135836 2135836 defendant Ryder John   599723 599723 Ryder, John, of Plympton, groom 0
4359543 2150572 2150572 defendant Ryder John gent 599723 599723 Ryder, John, of Plympton, gent 1
4477684 2193688 2193688 defendant Wills William   599723 599723 Wills, William, of Plympton 0
4486937 2196631 2196631 defendant Boswyns Roger   599723 599723 Boswyns, Roger, of Plympton 0
4491637 2198070 2198070 plaintiff Wogwill John   599723 599723 Wogwill, John, of Plympton 0
4525818 2208373 2208373 defendant Helyer Walter   599723 599723 Helyer, Walter, of Plympton 3
4528130 2209074 2209074 defendant Helier Walter   599723 599723 Helier, Walter, of Plympton 17
4570253 2222269 2222269 plaintiff Woggewill John draper 599723 599723 Woggewill, John, of Plympton, draper 0
4583542 2226275 2226275 plaintiff Frere William   599723 599723 Frere, William, of Plympton, burgess 0
4590186 2228296 2228296 defendant Helyer Watler   599723 599723 Helyer, Watler, of Plympton 0
4603174 2232200 2232200 plaintiff William John   599723 599723 William, John, of Plympton 0
4608180 2233669 2233669 plaintiff Bonde John   599723 599723 Bonde, John, of Plympton 0
4616721 2236230 2236230 defendant Box Henry   599723 599723 Box, Henry, of Plympton 1
4620839 2237497 2237497 defendant Scryvener John   599723 599723 Scryvener, John, of Plympton 0
4641391 2243576 2243576 defendant Wilky or Wiwy John tailor 599723 599723 Wilky or Wiwy, John, of Plympton, tailor 0
4651547 2246487 2246487 defendant Wynkelegh John   599723 599723 Wynkelegh, John, of Plympton, bailiff 5
4658547 2248552 2248552 defendant Crese Gilbert merchant 599723 599723 Crese, Gilbert, of Plympton, merchant 0
4659580 2248847 2248847 defendant Silverlok John, junior chapman 599723 599723 Silverlok, John, junior, of Plympton, chapman 0
4661261 2249344 2249344 defendant Bokeler William husbandman 599723 599723 Bokeler, William, of Plympton, husbandman 0
4661262 2249344 2249344 defendant Boys Thomas tanner 599723 599723 Boys, Thomas, of Plympton, tanner 1
4661263 2249344 2249344 defendant Sporeham Gilbert baker 599723 599723 Sporeham, Gilbert, of Plympton, baker 2
4661265 2249344 2249344 defendant Odymere Thomas baker 599723 599723 Odymere, Thomas, of Plympton, baker 4
4661266 2249344 2249344 defendant Leye Thomas laborer 599723 599723 Leye, Thomas, of Plympton, laborer 5
4661267 2249344 2249344 defendant Sparkewell Simon husbandman 599723 599723 Sparkewell, Simon, of Plympton, husbandman 6
4664937 2250514 2250514 defendant Mulleward Thomas   599723 599723 Mulleward, Thomas, of Plympton, millward 0
4672923 2257171 2257171 defendant Reve or Rene John yeoman 599723 599723 Reve or Rene, John, of Plympton, yeoman 0
4677067 2258443 2258443 defendant Turs Peter yeoman 599723 599723 Turs, Peter, of Plympton, yeoman 0
4679978 2259341 2259341 defendant Heweton Richard shoemaker 599723 599723 Heweton, Richard, of Plympton, shoemaker 1
4689266 2262204 2262204 defendant Soper William   599723 599723 Soper, William, of Plympton, milward 2
4691408 2262838 2262838 defendant Taylour William yeoman 599723 599723 Taylour, William, of Plympton, yeoman 0
4691471 2262856 2262856 defendant Hameleyn John merchant 599723 599723 Hameleyn, John, of Plympton, merchant 0
4691472 2262856 2262856 defendant Rose Peter tailor 599723 599723 Rose, Peter, of Plympton, tailor 1
4695049 2263944 2263944 plaintiff Braklee John   599723 599723 Braklee, John, of Plympton 0
4695468 2264062 2264062 defendant Turs Peter   599723 599723 Turs, Peter, of Plympton, town clerk 0
4695470 2264063 2264063 defendant Gurs Peter   599723 599723 Gurs, Peter, of Plympton, town clerk 0
4698203 2264923 2264923 defendant Coleford Reginald yeoman 599723 599723 Coleford, Reginald, of Plympton, yeoman 0
4698302 2264948 2264948 defendant Silverlok John gent 599723 599723 Silverlok, John, of Plympton, gent 0
4699029 2265168 2265168 defendant Wynkelash John   599723 599723 Wynkelash, John, of Plympton, bailiff 1
4709641 2268379 2268379 defendant Hornebrok John husbandman 599723 599723 Hornebrok, John, of Plympton, husbandman 0
4709739 2268405 2268405 defendant Martyn Peter shipman 599723 599723 Martyn, Peter, of Plympton, shipman 2
4710411 2268609 2268609 defendant Helyer John tanner 599723 599723 Helyer, John, of Plympton, tanner 3
4712022 2269071 2269071 defendant White Walter yeoman 599723 599723 White, Walter, of Plympton, yeoman 1
4715151 2270066 2270066 defendant Turs Peter   599723 599723 Turs, Peter, of Plympton, town clerk 0
4727665 2273894 2273894 defendant Hillyng Walter chapman 599723 599723 Hillyng, Walter, of Plympton, chapman 2
4734533 2275968 2275968 plaintiff Selman Walter   599723 599723 Selman, Walter, of Plympton 0
4734605 2275986 2275986 defendant Sperkewell Richard husbandman 599723 599723 Sperkewell, Richard, of Plympton, husbandman 1
4734606 2275986 2275986 defendant Silverlok John husbandman 599723 599723 Silverlok, John, of Plympton, husbandman 2
4737926 2276968 2276968 defendant Helyer Hugh haulier 599723 599723 Helyer, Hugh, of Plympton, haulier 0
4750871 2280738 2280738 defendant Balfote Walter sheerman 599723 599723 Balfote, Walter, of Plympton, sheerman 1
4751408 2280894 2280894 plaintiff Silverlok John   599723 599723 Silverlok, John, of Plympton, on his own account 0
4751422 2280898 2280898 defendant Silverlok John (legal representative) 599723 599723 Silverlok, John, of Plympton, gent, executors of 0
4751424 2280898 2280898 defendant Fordon John clerk 599723 599723 Fordon, John, of Plympton, clerk 2
4756234 2282322 2282322 defendant Wynkelegh John husbandman 599723 599723 Wynkelegh, John, of Plympton, husbandman 1
4759028 2283176 2283176 defendant Wynkelegh John   599723 599723 Wynkelegh, John, of Plympton, bailiff 0
4762135 2284136 2284136 defendant Sporham Gilbert baker 599723 599723 Sporham, Gilbert, of Plympton, baker 0
4763857 2284687 2284687 defendant Blakehalle Anne widow 599723 599723 Blakehalle, Anne, of Plympton, widow 0
4763858 2284687 2284687 defendant Skydmore (illegible) dyer 599723 599723 Skydmore, _, of Plympton, dyer 1
4763859 2284687 2284687 defendant Crese Richard yeoman 599723 599723 Crese, Richard, of Plympton, yeoman 2
4765536 2285213 2285213 defendant Wylke John tailor 599723 599723 Wylke, John, of Plympton, tailor 0
4765538 2285213 2285213 defendant Gode John weaver 599723 599723 Gode, John, of Plympton, weaver 2
4765539 2285213 2285213 defendant Symon Henry yeoman 599723 599723 Symon, Henry, of Plympton, yeoman 3
4770140 2286629 2286629 plaintiff Prior Nicholas   599723 599723 Prior, Nicholas, of Plympton 0
4775566 2288352 2288352 defendant Colefore Reginald butcher 599723 599723 Colefore, Reginald, of Plympton, butcher 0
4802203 2296879 2296879 defendant Sperkewyll William husbandman 599723 599723 Sperkewyll, William, of Plympton, husbandman 2
4804170 2297493 2297493 defendant Prygge Edward   599723 599723 Prygge, Edward, of Plympton, holy water clerk 1
4806627 2298282 2298282 defendant Serle John   599723 599723 Serle, John, of Plympton 0
4806832 2298348 2298348 defendant Wynkelegh John   599723 599723 Wynkelegh, John, of Plympton, bailiff 0
4823695 2303501 2303501 defendant Coleford Reginald butcher 599723 599723 Coleford, Reginald, of Plympton, butcher 2
4832038 2306051 2306051 defendant Yem Peter husbandman 599723 599723 Yem, Peter, of Plympton, husbandman 1

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