names

124 rows where place_id = 621415

✎ 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
3661456 1913854 1913854 defendant Michell John gent 621415 621415 Michell, John, of St Columb Major, gent 1
3700995 1926561 1926561 defendant Burlas Richard gent 621415 621415 Burlas, Richard, of St Columbe Major, gent 0
3711456 1929889 1929889 defendant Gavergon John gent 621415 621415 Gavergon, John, of St Columbe Major, gent 0
3741244 1939119 1939119 defendant Brodemede William carrier 621415 621415 Brodemede, William, of St Sativole, Exeter, carrier 1
3747820 1941239 1941239 defendant Meris William laborer 621415 621415 Meris, William, of St Bartholomew, Chichester, laborer 1
3748427 1941442 1941442 plaintiff Grene John   621415 621415 Grene, John, of St Margaret, Westminster, notary public 0
3779560 1951335 1951335 defendant Shapton William gent 621415 621415 Shapton, William, of St Sativole, Exeter, gent 0
3779562 1951336 1951336 defendant Shapton William gent 621415 621415 Shapton, William, of St Sativole, Exeter, gent 0
3830798 1967514 1967514 defendant Comyshed Christopher yeoman 621415 621415 Comyshed, Christopher, of St Satmole, Exeter, yeoman 0
3861350 1977263 1977263 defendant Flemyng John chaplain 621415 621415 Flemyng, John, of St Satmole, chaplain 1
3861351 1977263 1977263 defendant Flemyng Satmole shipster 621415 621415 Flemyng, Satmole, of St Satmole, shipster 2
3876639 1982433 1982433 defendant Carowe Simon laborer 621415 621415 Carowe, Simon, of St Satmole, Exeter, laborer 0
3876640 1982433 1982433 defendant Carowe Robert laborer 621415 621415 Carowe, Robert, of St Satmole, Exeter, laborer 1
3876641 1982433 1982433 defendant Pyers alias Blake William carpenter 621415 621415 Pyers alias Blake, William, of St Satmole, carpenter 2
3879663 1983454 1983454 defendant Watte William yeoman 621415 621415 Watte, William, of St Columbe Major, yeoman 0
3892511 1987741 1987741 defendant Robert Richard yeoman 621415 621415 Robert, Richard, of St Columb Minor, yeoman 3
3893447 1988036 1988036 defendant Angove Nicholas husbandman 621415 621415 Angove, Nicholas, of St Columb Minor, husbandman 0
3897087 1989246 1989246 defendant ap Stephyn Edward gent 621415 621415 ap Stephyn, Edward, of St Frede, Radnor, gent 1
3916229 1995813 1995813 defendant Stephyns William brewer 621415 621415 Stephyns, William, of St Sativole, brewer 1
3925081 1998704 1998704 defendant Tregennowe John husbandman 621415 621415 Tregennowe, John, of St Columbe Minor, husbandman 0
3925082 1998704 1998704 defendant Tregennowe Joan spinster 621415 621415 Tregennowe, Joan, of St Columbe Minor, spinster 1
3929919 2000349 2000349 plaintiff Clarke Arthur (legal representative) 621415 621415 Clarke, Arthur, of St Botolphs, Colchester, gent, administratrix of 0
3931453 2000817 2000817 defendant Carrowe Simon brewer 621415 621415 Carrowe, Simon, of St Sativole, Exeter, brewer 0
3936697 2002601 2002601 defendant Morcombe Henry barber 621415 621415 Morcombe, Henry, of St Colombe Major, barber 1
3942170 2004401 2004401 defendant Walker John (legal representative) 621415 621415 Walker, John, of St Peters, Worcester, clothier & shoe maker, executrix of 0
3947740 2006273 2006273 defendant Floyde alias Walshman John butcher 621415 621415 Floyde alias Walshman, John, of St Sativole, butcher 0
3974841 2015765 2015765 defendant Goffe John weaver 621415 621415 Goffe, John, of St Sativole, Exeter, weaver 0
3979270 2017333 2017333 defendant Nelder John   621415 621415 Nelder, John, of St Germans, junior 0
3980980 2017954 2017954 defendant Wyll Robert butcher 621415 621415 Wyll, Robert, of St Sativole, butcher 0
4022256 2032685 2032685 defendant ap Howell Meredith yeoman 621415 621415 ap Howell, Meredith, of St Harmon, Radnor, yeoman 0
4025005 2033606 2033606 plaintiff Bowth or Booth Thomas   621415 621415 Bowth or Booth, Thomas, of St Johns or Gloucester Hall 0
4140331 2074787 2074787 defendant Teage Cecily widow 621415 621415 Teage, Cecily, of St Colombe Major, widow 0
4168543 2084482 2084482 defendant Merifelde John gent 621415 621415 Merifelde, John, of St Colombe Mahor, gent 2
4176633 2087301 2087301 defendant Jenking Madock yeoman 621415 621415 Jenking, Madock, of St Peters, yeoman 0
4180328 2088600 2088600 defendant Callwaye Robert cordwainer 621415 621415 Callwaye, Robert, of St Colombe Major, cordwainer 0
4198312 2094958 2094958 defendant Barrowe Robert yeoman 621415 621415 Barrowe, Robert, of St Sydwells, Exeter, yeoman 0
4244149 2111026 2111026 defendant Braban Thomas yeoman 621415 621415 Braban, Thomas, of St Colombe Major, yeoman 0
4244150 2111026 2111026 defendant Pollard Benedict husbandman 621415 621415 Pollard, Benedict, of St Colombe Major, husbandman 1
4289989 2126484 2126484 defendant Weightweeke Richard   621415 621415 Weightweeke, Richard, of St Margaret Westminster, gent, servant of Queen's chamber 0
4296640 2128899 2128899 defendant Bedo Margaret ap David ap Jenkin widow 621415 621415 Bedo, Margaret ap David ap Jenkin, of St Harmon, Radnor, widow 0
4311736 2134245 2134245 defendant Halstaff Ralph butcher 621415 621415 Halstaff, Ralph, of St Sidwells, Exeter, butcher 3
4387987 2160610 2160610 defendant Mundey William, junior husbandman 621415 621415 Mundey, William, junior, of St Colombe Minor, husbandman 0
4476917 2193439 2193439 defendant Spencer John   621415 621415 Spencer, John, of St Bartholomew's Gloucester, servant of the prior 1
4509734 2203528 2203528 plaintiff Avery John   621415 621415 Avery, John, of St Germans, prior 0
4512919 2204475 2204475 defendant Bray John (legal representative) 621415 621415 Bray, John, of St Columbe Major, parson, executor of 0
4564662 2220509 2220509 defendant Sutton Henry   621415 621415 Sutton, Henry, of St Werburge, Westchester, abbot 0
4639427 2243045 2243045 plaintiff Cook Thomas   621415 621415 Cook, Thomas, of St Keram, Exeter, rector 0
4683451 2260426 2260426 defendant Gotteboys Thomas husbandman 621415 621415 Gotteboys, Thomas, of St Columb Major, husbandman 0
4690275 2262513 2262513 defendant Hikke Thomas husbandman 621415 621415 Hikke, Thomas, of St Menvre or St Minver, husbandman 0
4731006 2274901 2274901 defendant Harry John mercer 621415 621415 Harry, John, of St Columbe Major, mercer 0
4744615 2278945 2278945 defendant Kempe William woolman 621415 621415 Kempe, William, of St Pancras, woolman 1
4748705 2280105 2280105 defendant Arnold William carpenter 621415 621415 Arnold, William, of St Bartholomew's, Chichester, carpenter 0
4760983 2283780 2283780 plaintiff Depyng John   621415 621415 Depyng, John, of St Botolf's, prior 0
4795978 2294889 2294889 defendant Stoute William yeoman 621415 621415 Stoute, William, of St Pancras, Chichester, yeoman 0
4800628 2296375 2296375 defendant Wilkyn Reginald butcher 621415 621415 Wilkyn, Reginald, of St Columbe Major, butcher 2
4830418 2305548 2305548 defendant Turney John   621415 621415 Turney, John, of St Neots, prior 0
4831866 2305990 2305990 defendant Turveye John   621415 621415 Turveye, John, of St Neots, prior 0
4859249 2314269 2314269 defendant Carpenter Nicholas laborer 621415 621415 Carpenter, Nicholas, of St Sativole, laborer 0
4892038 2324247 2324247 defendant Raulyn John husbandman 621415 621415 Raulyn, John, of St Columbe Major, husbandman 2
4909322 2329458 2329458 defendant Brene Robert husbandman 621415 621415 Brene, Robert, of St Satmole, husbandman 0
4910947 2329936 2329936 defendant Raynell Stephen gent 621415 621415 Raynell, Stephen, of St Satmole, gent 0
4935699 2337555 2337555 defendant Wysky Thomas weaver 621415 621415 Wysky, Thomas, of St Pancras, Chichester, weaver 0
4936553 2337815 2337815 defendant Raynell or Rayvell Stephen gent 621415 621415 Raynell or Rayvell, Stephen, of St Sativole, gent 0
4947009 2341056 2341056 defendant Badcok William woolman 621415 621415 Badcok, William, of St Pancras, Chichester, woolman 0
4952800 2342793 2342793 defendant Seneger Simon husbandman 621415 621415 Seneger, Simon, of St Sativole, Exeter, husbandman 3
4954046 2343173 2343173 defendant Skynner Thomas skinner 621415 621415 Skynner, Thomas, of St Pancras, Chichester, skinner 0
4956803 2343995 2343995 defendant atte Vanne Thomas weaver 621415 621415 atte Vanne, Thomas, of St Pancras, Chichester, weaver 0
4956805 2343995 2343995 defendant Kyng Geoffrey butcher 621415 621415 Kyng, Geoffrey, of St Bartholomew, Chichester, butcher 2
4978410 2350491 2350491 defendant Thomyowe Simon tinner 621415 621415 Thomyowe, Simon, of St Columbe Major, tinner 0
4982519 2351687 2351687 defendant Facy W merchant 621415 621415 Facy, W, of St Columba Major, merchant 2
4982523 2351687 2351687 defendant Clemowe John husbandman 621415 621415 Clemowe, John, of St Columba Major, husbandman 6
4982526 2351688 2351688 defendant Facy William merchant 621415 621415 Facy, William, of St Columbe Major, merchant 1
4982530 2351688 2351688 defendant Clemowe John husbandman 621415 621415 Clemowe, John, of St Columbe Major, husbandman 5
4987402 2353184 2353184 defendant Clemmowe John husbandman 621415 621415 Clemmowe, John, of St Columb Major, husbandman 2
4993882 2355039 2355039 plaintiff Eton John   621415 621415 Eton, John, of St Neot's, prior 0
5001251 2357244 2357244 defendant Catur John dyer 621415 621415 Catur, John, of St Botolphs, dyer 0
5031477 2366064 2366064 defendant Geffrey John husbandman 621415 621415 Geffrey, John, of St Sativole, Exeter, husbandman 0
5054997 2373057 2373057 defendant Baker Henry baker 621415 621415 Baker, Henry, of St Sidewelisse, Exeter, baker 0
5058213 2374012 2374012 defendant Raynold Stephen gent 621415 621415 Raynold, Stephen, of St Sydewells, Exeter, gent 0
5069334 2377318 2377318 defendant Fichet Simon smith 621415 621415 Fichet, Simon, of St Sativole, Exeter, smith 0
5070449 2377654 2377654 defendant Mathu John carpenter 621415 621415 Mathu, John, of St Sativole, Exeter, carpenter 0
5070450 2377654 2377654 defendant Beare Agnes widow 621415 621415 Beare, Agnes, of St Sativole, Exeter, widow 1
5070452 2377654 2377654 defendant Allercote John husbandman 621415 621415 Allercote, John, of St Sativole, Exeter, husbandman 3
5075942 2379297 2379297 defendant Rondell Alice widow 621415 621415 Rondell, Alice, of St Sativole, widow 0
5083263 2381495 2381495 defendant Dolyng John mercer 621415 621415 Dolyng, John, of St Sidewellis, Exeter, mercer 0
5083264 2381495 2381495 defendant Benet John laborer 621415 621415 Benet, John, of St Sidewellis, Exeter, laborer 1
5083265 2381495 2381495 defendant Benet Richard laborer 621415 621415 Benet, Richard, of St Sidewellis, Exeter, laborer 2
5083268 2381496 2381496 defendant Dolyng John mercer 621415 621415 Dolyng, John, of St Sydewellysse, Exeter, mercer 0
5089295 2383237 2383237 defendant Raynold Stephen gent 621415 621415 Raynold, Stephen, of St Sydeswelysse, Exeter, gent 0
5089296 2383237 2383237 defendant Lake John   621415 621415 Lake, John, of St Sydeswelysse, Exeter, bailiff 1
5095326 2385054 2385054 defendant Segur Simon husbandman 621415 621415 Segur, Simon, of St Sydewellysse, Exeter, husbandman 1
5106156 2388238 2388238 defendant Halnur or Halmir Thomas gent 621415 621415 Halnur or Halmir, Thomas, of St Columbe Major, gent 0
5115982 2391102 2391102 defendant Walter Richard pardoner 621415 621415 Walter, Richard, of St Sidwells, Exeter, pardoner 0
5115983 2391102 2391102 defendant Pounde Thomas laborer 621415 621415 Pounde, Thomas, of St Sidwells, Exeter, laborer 1
5131587 2395719 2395719 defendant Austys John husbandman 621415 621415 Austys, John, of St Keyne, junior, husbandman 3
5137038 2397347 2397347 defendant Tomeyowe Lawrence husbandman 621415 621415 Tomeyowe, Lawrence, of St Columb Major, husbandman 2
5213181 2419585 2419585 defendant Gardyner Thomas carrier 621415 621415 Gardyner, Thomas, of St Sydewells, Exeter, carrier 0
5213185 2419586 2419586 defendant Clemmowe Philip husbandman 621415 621415 Clemmowe, Philip, of St Columbe Major, husbandman 2
5213448 2419666 2419666 defendant Symon John gent 621415 621415 Symon, John, of St Sydewels, Exeter, gent 0
5215655 2420302 2420302 defendant Rede William laborer 621415 621415 Rede, William, of St Sativole, Exeter, laborer 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);