names

163 rows where place_id = 588915

✎ 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
3595995 1866377 1866377 defendant Worston William gent 588915 588915 Worston, William, of Plympton Earl, gent 0
3597223 1866754 1866754 defendant Horswyll John mercer 588915 588915 Horswyll, John, of Plympton Earl, mercer 0
3597224 1866754 1866754 defendant Hengeston Robert husbandman 588915 588915 Hengeston, Robert, of Plympton Earl, husbandman 1
3597225 1866754 1866754 defendant Kemston Thomas husbandman 588915 588915 Kemston, Thomas, of Plympton Earl, husbandman 2
3627347 1903403 1903403 defendant Beare John sherman 588915 588915 Beare, John, of Plympton Earl, sherman 1
3651426 1910810 1910810 defendant Holond John yeoman 588915 588915 Holond, John, of Plympton Earl, yeoman 1
3658799 1913009 1913009 defendant Hame Robert tailor 588915 588915 Hame, Robert, of Plympton Earl, tailor 0
3839247 1970204 1970204 defendant More Henry merchant 588915 588915 More, Henry, of Plympton Earl, merchant 0
3839249 1970204 1970204 defendant More Alice   588915 588915 More, Alice, of Plympton Earl 2
3855622 1975398 1975398 defendant More Alice widow 588915 588915 More, Alice, of Plympton Earl, widow 1
3885886 1985536 1985536 defendant Luscombe John merchant 588915 588915 Luscombe, John, of Plympton Earl, merchant 1
3885891 1985537 1985537 defendant Luscombe John merchant 588915 588915 Luscombe, John, of Plympton Earl, merchant 1
3910056 1993667 1993667 defendant Huchyn Walter laborer 588915 588915 Huchyn, Walter, of Plympton Earl, laborer 2
4793270 2293990 2293990 defendant Derston Robert husbandman 588915 588915 Derston, Robert, of Plympton Earl, husbandman 0
4796641 2295100 2295100 defendant Strange John merchant 588915 588915 Strange, John, of Plympton Earl, merchant 0
4796669 2295110 2295110 defendant Sperkewell Richard   588915 588915 Sperkewell, Richard, of Plympton Earl, town clerk 0
4833251 2306408 2306408 defendant Selman Walter merchant 588915 588915 Selman, Walter, of Plympton Earl, merchant 0
4837366 2307626 2307626 defendant Willy John   588915 588915 Willy, John, of Plympton Earl 0
4839509 2308281 2308281 defendant Silverlok John yeoman 588915 588915 Silverlok, John, of Plympton Earl, yeoman 0
4840200 2308484 2308484 defendant Yem Peter carpenter 588915 588915 Yem, Peter, of Plympton Earl, carpenter 1
4840201 2308484 2308484 defendant Quynterell Richard weaver 588915 588915 Quynterell, Richard, of Plympton Earl, weaver 2
4848281 2310934 2310934 defendant Wollecombe Baldwin husbandman 588915 588915 Wollecombe, Baldwin, of Plympton Earl, husbandman 0
4848286 2310936 2310936 defendant Silverlok John husbandman 588915 588915 Silverlok, John, of Plympton Earl, husbandman 0
4849015 2311160 2311160 defendant Hake John husbandman 588915 588915 Hake, John, of Plympton Earl, husbandman 0
4850377 2311573 2311573 defendant Sperkewod Richard gent 588915 588915 Sperkewod, Richard, of Plympton Earl, gent 0
4854007 2312662 2312662 defendant Michell William tailor 588915 588915 Michell, William, of Plympton Earl, tailor 0
4860268 2314571 2314571 defendant Selman Walter merchant 588915 588915 Selman, Walter, of Plympton Earl, merchant 0
4860276 2314572 2314572 defendant Selman Walter merchant 588915 588915 Selman, Walter, of Plympton Earl, merchant 0
4866722 2316555 2316555 defendant Silverlok John yeoman 588915 588915 Silverlok, John, of Plympton Earl, yeoman 0
4873872 2318767 2318767 defendant Badeworthy Richard yeoman 588915 588915 Badeworthy, Richard, of Plympton Earl, yeoman 0
4878452 2320204 2320204 defendant Sparkewill Richard gent 588915 588915 Sparkewill, Richard, of Plympton Earl, gent 0
4887550 2322944 2322944 defendant Silverlok John gent 588915 588915 Silverlok, John, of Plympton Earl, gent 0
4891319 2324011 2324011 defendant Hoigge Robert husbandman 588915 588915 Hoigge, Robert, of Plympton Earl, husbandman 4
4895623 2325301 2325301 defendant Selman Walter merchant 588915 588915 Selman, Walter, of Plympton Earl, merchant 0
4895635 2325306 2325306 defendant Yem Peter husbandman 588915 588915 Yem, Peter, of Plympton Earl, husbandman 0
4900386 2326761 2326761 defendant Sparkwill Richard husbandman 588915 588915 Sparkwill, Richard, of Plympton Earl, husbandman 0
4900387 2326761 2326761 defendant Penbroke Robert laborer 588915 588915 Penbroke, Robert, of Plympton Earl, laborer 1
4900388 2326761 2326761 defendant Wolcombe Baldwin husbandman 588915 588915 Wolcombe, Baldwin, of Plympton Earl, husbandman 2
4902099 2327265 2327265 defendant Silverlok John yeoman 588915 588915 Silverlok, John, of Plympton Earl, yeoman 0
4902889 2327519 2327519 defendant Selman Walter merchant 588915 588915 Selman, Walter, of Plympton Earl, merchant 0
4936038 2337673 2337673 defendant Balard Thomas husbandman 588915 588915 Balard, Thomas, of Plympton Earl, husbandman 0
4936039 2337673 2337673 defendant Balard Robert husbandman 588915 588915 Balard, Robert, of Plympton Earl, husbandman 1
4936041 2337673 2337673 defendant Marchant Thomas husbandman 588915 588915 Marchant, Thomas, of Plympton Earl, husbandman 3
4936433 2337785 2337785 defendant Pyke William merchant 588915 588915 Pyke, William, of Plympton Earl, merchant 0
4948726 2341585 2341585 defendant Wilyam John shoemaker 588915 588915 Wilyam, John, of Plympton Earl, shoemaker 0
4953254 2342934 2342934 defendant Brounyng John shoemaker 588915 588915 Brounyng, John, of Plympton Earl, shoemaker 0
4953255 2342934 2342934 defendant Yeme Peter carpenter 588915 588915 Yeme, Peter, of Plympton Earl, carpenter 1
4957475 2344206 2344206 defendant Sylverlok John yeoman 588915 588915 Sylverlok, John, of Plympton Earl, yeoman 0
4957476 2344206 2344206 defendant Brakle Richard husbandman 588915 588915 Brakle, Richard, of Plympton Earl, husbandman 1
4959222 2344726 2344726 defendant Pounflet John   588915 588915 Pounflet, John, of Plympton Earl, bailiff 0
4960527 2345118 2345118 defendant Letheby Richard baker 588915 588915 Letheby, Richard, of Plympton Earl, baker 0
4960531 2345118 2345118 defendant Watte Stephen cordwainer 588915 588915 Watte, Stephen, of Plympton Earl, cordwainer 4
4961946 2345527 2345527 defendant Russhe Ivo weaver 588915 588915 Russhe, Ivo, of Plympton Earl, weaver 0
4962573 2345711 2345711 defendant Cornyssh John baker 588915 588915 Cornyssh, John, of Plympton Earl, baker 0
4969722 2347892 2347892 defendant Sperkewell Richard husbandman 588915 588915 Sperkewell, Richard, of Plympton Earl, husbandman 0
4969724 2347893 2347893 defendant Sperkewill Richard husbandman 588915 588915 Sperkewill, Richard, of Plympton Earl, husbandman 0
4977013 2350078 2350078 defendant Julyan Thomas   588915 588915 Julyan, Thomas, of Plympton Earl yeoman 3
4979320 2350774 2350774 defendant Silverlok John yeoman 588915 588915 Silverlok, John, of Plympton Earl, yeoman 1
4981687 2351438 2351438 defendant Royssh Ivo weaver 588915 588915 Royssh, Ivo, of Plympton Earl, weaver 0
4984965 2352437 2352437 defendant Mewy John husbandman 588915 588915 Mewy, John, of Plympton Earl, husbandman 0
4984966 2352437 2352437 defendant Chester Walter laborer 588915 588915 Chester, Walter, of Plympton Earl, laborer 1
4985241 2352512 2352512 defendant Sperkewyll Richard husbandman 588915 588915 Sperkewyll, Richard, of Plympton Earl, husbandman 0
4985244 2352513 2352513 defendant Sperkewyll Richard husbandman 588915 588915 Sperkewyll, Richard, of Plympton Earl, husbandman 0
5013691 2360845 2360845 defendant More Robert husbandman 588915 588915 More, Robert, of Plympton Earl, husbandman 0
5017527 2362012 2362012 defendant Yeme Peter, junior carpenter 588915 588915 Yeme, Peter, junior, of Plympton Earl, carpenter 0
5024219 2363998 2363998 defendant Umfray John butcher 588915 588915 Umfray, John, of Plympton Earl, butcher 0
5024220 2363998 2363998 defendant Telye Thomas tailor 588915 588915 Telye, Thomas, of Plympton Earl, tailor 1
5024222 2363999 2363999 defendant Taillour Richard helyer or roofer 588915 588915 Taillour, Richard, of Plympton Earl, helyer or roofer 0
5031985 2366228 2366228 plaintiff Rose Peter (legal representative) 588915 588915 Rose, Peter, of Plympton Earl, executors of 0
5031988 2366228 2366228 defendant Sperkwill Richard yeoman 588915 588915 Sperkwill, Richard, of Plympton Earl, yeoman 0
5031990 2366228 2366228 defendant Pountflet John yeoman 588915 588915 Pountflet, John, of Plympton Earl, yeoman 2
5032806 2366482 2366482 defendant Brokle Richard yeoman 588915 588915 Brokle, Richard, of Plympton Earl, yeoman 0
5056445 2373505 2373505 defendant Braklegh John mercer 588915 588915 Braklegh, John, of Plympton Earl, mercer 0
5056608 2373548 2373548 defendant Brokyng Walter laborer 588915 588915 Brokyng, Walter, of Plympton Earl, laborer 1
5057914 2373939 2373939 defendant Appetorre John   588915 588915 Appetorre, John, of Plympton Earl, bailiff 1
5060419 2374694 2374694 defendant Brakke John mercer 588915 588915 Brakke, John, of Plympton Earl, mercer 0
5060421 2374695 2374695 defendant Brakle John mercer 588915 588915 Brakle, John, of Plympton Earl, mercer 0
5060451 2374703 2374703 defendant Pountflete John husbandman 588915 588915 Pountflete, John, of Plympton Earl, husbandman 4
5065913 2376327 2376327 defendant Flute John cutler 588915 588915 Flute, John, of Plympton Earl, cutler 1
5065916 2376328 2376328 defendant Flute John cutler 588915 588915 Flute, John, of Plympton Earl, cutler 1
5068367 2377040 2377040 defendant Malburgh David husbandman 588915 588915 Malburgh, David, of Plympton Earl, husbandman 0
5068373 2377041 2377041 defendant Malburgh David husbandman 588915 588915 Malburgh, David, of Plympton Earl, husbandman 0
5070550 2377686 2377686 defendant Sylverlok John yeoman 588915 588915 Sylverlok, John, of Plympton Earl, yeoman 0
5070552 2377687 2377687 defendant Sylverlok John yeoman 588915 588915 Sylverlok, John, of Plympton Earl, yeoman 0
5070566 2377692 2377692 defendant Braklegh John yeoman 588915 588915 Braklegh, John, of Plympton Earl, yeoman 0
5073893 2378683 2378683 defendant Lanrak alias Sherman William sherman 588915 588915 Lanrak alias Sherman, William, of Plympton Earl, sherman 1
5073896 2378684 2378684 defendant Lanrak alias Sherman William sherman 588915 588915 Lanrak alias Sherman, William, of Plympton Earl, sherman 0
5075227 2379082 2379082 defendant Appetorre John   588915 588915 Appetorre, John, of Plympton Earl, bailiff 0
5085587 2382180 2382180 defendant Blakewell Richard husbandman 588915 588915 Blakewell, Richard, of Plympton Earl, husbandman 1
5085814 2382246 2382246 defendant Quynterell Thomas weaver 588915 588915 Quynterell, Thomas, of Plympton Earl, weaver 1
5093533 2384507 2384507 defendant William Lawrence laborer 588915 588915 William, Lawrence, of Plympton Earl, laborer 0
5093534 2384507 2384507 defendant Taillour Richard   588915 588915 Taillour, Richard, of Plympton Earl, "tyler" 1
5093973 2384636 2384636 defendant Badworthy Richard husbandman 588915 588915 Badworthy, Richard, of Plympton Earl, husbandman 0
5093974 2384636 2384636 defendant Badworthy John yeoman 588915 588915 Badworthy, John, of Plympton Earl, yeoman 1
5093975 2384636 2384636 defendant Bro- John husbandman 588915 588915 Bro-, John, of Plympton Earl, husbandman 2
5095154 2384997 2384997 defendant Braklegh John yeoman 588915 588915 Braklegh, John, of Plympton Earl, yeoman 0
5096518 2385414 2385414 defendant Tabyn John chapman 588915 588915 Tabyn, John, of Plympton Earl, chapman 2
5097131 2385595 2385595 defendant Tolye Thomas tailor 588915 588915 Tolye, Thomas, of Plympton Earl, tailor 0
5116645 2391301 2391301 defendant Milward John baker 588915 588915 Milward, John, of Plympton Earl, baker 0
5116647 2391302 2391302 defendant Milward John baker 588915 588915 Milward, John, of Plympton Earl, baker 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);