names

82 rows where place_id = 592653

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608413 1870291 1870291 defendant Stoneman John husbandman 592653 592653 Stoneman, John, of South Tauton, husbandman 0
3705369 1927967 1927967 defendant Dunnyng Robert yeoman 592653 592653 Dunnyng, Robert, of South Tauton, yeoman 0
4651546 2246487 2246487 defendant Vele Geoffrey   592653 592653 Vele, Geoffrey, of South Tauton, bailiff 4
4732281 2275274 2275274 defendant Oxenham Richard yeoman 592653 592653 Oxenham, Richard, of South Tauton, yeoman 3
4779401 2289541 2289541 defendant Colebeare William husbandman 592653 592653 Colebeare, William, of South Tauton, husbandman 0
4779404 2289542 2289542 defendant Colebeare William husbandman 592653 592653 Colebeare, William, of South Tauton, husbandman 1
4781996 2290372 2290372 defendant Northmore Geoffrey husbandman 592653 592653 Northmore, Geoffrey, of South Tauton, husbandman 0
4852127 2312093 2312093 defendant atte Hole Richard husbandman 592653 592653 atte Hole, Richard, of South Tauton, husbandman 0
4852128 2312093 2312093 defendant atte Hole Walter husbandman 592653 592653 atte Hole, Walter, of South Tauton, husbandman 1
4856491 2313409 2313409 defendant Taverner John mercer 592653 592653 Taverner, John, of South Tauton, mercer 0
4858967 2314183 2314183 defendant Barry Thomas husbandman 592653 592653 Barry, Thomas, of South Tauton, husbandman 0
4878439 2320200 2320200 defendant Batteshill John husbandman 592653 592653 Batteshill, John, of South Tauton, husbandman 0
4880061 2320673 2320673 defendant atte Hole Richard husbandman 592653 592653 atte Hole, Richard, of South Tauton, husbandman 0
4880062 2320673 2320673 defendant atte Hole Walter husbandman 592653 592653 atte Hole, Walter, of South Tauton, husbandman 1
4895627 2325303 2325303 defendant Adelard William tanner 592653 592653 Adelard, William, of South Tauton, tanner 0
4895628 2325303 2325303 defendant Quans William smith 592653 592653 Quans, William, of South Tauton, smith 1
4947313 2341152 2341152 defendant Duntyng William husbandman 592653 592653 Duntyng, William, of South Tauton, husbandman 2
4961214 2345321 2345321 defendant Nympte William husbandman 592653 592653 Nympte, William, of South Tauton, husbandman 0
4969730 2347896 2347896 defendant Oxenham Richard husbandman 592653 592653 Oxenham, Richard, of South Tauton, husbandman 0
4969732 2347896 2347896 defendant Adescote Thomas husbandman 592653 592653 Adescote, Thomas, of South Tauton, husbandman 2
4969733 2347896 2347896 defendant Hole Richard husbandman 592653 592653 Hole, Richard, of South Tauton, husbandman 3
4969734 2347896 2347896 defendant Swaynston John husbandman 592653 592653 Swaynston, John, of South Tauton, husbandman 4
4969735 2347896 2347896 defendant Smyth William shoemaker 592653 592653 Smyth, William, of South Tauton, shoemaker 5
4969736 2347896 2347896 defendant Adam Robert husbandman 592653 592653 Adam, Robert, of South Tauton, husbandman 6
4969737 2347896 2347896 defendant Batteshill Richard husbandman 592653 592653 Batteshill, Richard, of South Tauton, husbandman 7
4969740 2347896 2347896 defendant Blakemore John   592653 592653 Blakemore, John, of South Tauton, groom 10
4981965 2351522 2351522 defendant Frend Richard tailor 592653 592653 Frend, Richard, of South Tauton, tailor 0
4984666 2352343 2352343 defendant Strange John husbandman 592653 592653 together with Strange, John, of South Tauton, husbandman 2
4984667 2352343 2352343 defendant Oxenham Richard husbandman 592653 592653 Oxenham, Richard, of South Tauton, husbandman 3
4984670 2352343 2352343 defendant Crosse William laborer 592653 592653 Crosse, William, of South Tauton, laborer 6
4992664 2354688 2354688 defendant Wodeman John   592653 592653 Wodeman, John, of South Tauton, groom 1
4992665 2354688 2354688 defendant Quans William yeoman 592653 592653 Quans, William, of South Tauton, yeoman 2
5001253 2357245 2357245 defendant Battyshill Richard husbandman 592653 592653 Battyshill, Richard, of South Tauton, husbandman 0
5008416 2359352 2359352 defendant Milford William gent 592653 592653 Milford, William, of South Tauton, gent 0
5027759 2364995 2364995 defendant Bydelake Robert husbandman 592653 592653 Bydelake, Robert, of South Tauton, husbandman 5
5034977 2367088 2367088 defendant Milford William gent 592653 592653 Milford, William, of South Tauton, gent 0
5037897 2367965 2367965 defendant Wyke Richard gent 592653 592653 Wyke, Richard, of South Tauton, gent 0
5037900 2367965 2367965 defendant Tawe Oto laborer 592653 592653 Tawe, Oto, of South Tauton, laborer 3
5037901 2367965 2367965 defendant Wyke Robert yeoman 592653 592653 Wyke, Robert, of South Tauton, yeoman 4
5055953 2373350 2373350 defendant Wonston Richard husbandman 592653 592653 Wonston, Richard, of South Tauton, husbandman 0
5055954 2373350 2373350 defendant Wyke William husbandman 592653 592653 Wyke, William, of South Tauton, husbandman 1
5055955 2373350 2373350 defendant Shaplegh Robert husbandman 592653 592653 Shaplegh, Robert, of South Tauton, husbandman 2
5055956 2373350 2373350 defendant Wonston John husbandman 592653 592653 Wonston, John, of South Tauton, husbandman 3
5062598 2375371 2375371 defendant Oxenham Richard husbandman 592653 592653 Oxenham, Richard, of South Tauton, husbandman 0
5106113 2388225 2388225 defendant Wyke John gent 592653 592653 Wyke, John, of South Tauton, gent 0
5111538 2389771 2389771 defendant Oxenham Richard husbandman 592653 592653 Oxenham, Richard, of South Tauton, husbandman 0
5112359 2390001 2390001 defendant Oxenham Richard yeoman 592653 592653 Oxenham, Richard, of South Tauton, yeoman 0
5123982 2393467 2393467 defendant Wyke Richard gent 592653 592653 Wyke, Richard, of South Tauton, gent 0
5123983 2393467 2393467 defendant Wyke William gent 592653 592653 Wyke, William, of South Tauton, gent 1
5123984 2393467 2393467 defendant Wyke John, junior gent 592653 592653 Wyke, John, junior, of South Tauton, gent 2
5123985 2393467 2393467 defendant Towe John   592653 592653 Towe, John, of South Tauton, groom 3
5142620 2398970 2398970 defendant Dounyng John tailor 592653 592653 Dounyng, John, of South Tauton, tailor 1
5142621 2398970 2398970 defendant Taylour John tailor 592653 592653 Taylour, John, of South Tauton, tailor 2
5221732 2422053 2422053 defendant Sture Richard husbandman 592653 592653 Sture, Richard, of South Tauton, husbandman 1
5228942 2424069 2424069 defendant Northmore Richard husbandman 592653 592653 Northmore, Richard, of South Tauton, husbandman 0
5228943 2424069 2424069 defendant Adam Richard husbandman 592653 592653 Adam, Richard, of South Tauton, husbandman 1
5251592 2430603 2430603 defendant Addescote John husbandman 592653 592653 Addescote, John, of South Tauton, husbandman 0
5251593 2430603 2430603 defendant Dyscombe Henry husbandman 592653 592653 Dyscombe, Henry, of South Tauton, husbandman 1
5251595 2430603 2430603 defendant Aller Thomas   592653 592653 Aller, Thomas, of South Tauton, groom 3
5263421 2434308 2434308 defendant Frende Richard husbandman 592653 592653 Frende, Richard, of South Tauton, husbandman 0
5268062 2435772 2435772 defendant Dunnyng John husbandman & son & heir of William Dunnyng 592653 592653 Dunnyng, John, of South Tauton, husbandman & son & heir of William Dunnyng 0
5294797 2443461 2443461 defendant Colebeare William, junior yeoman 592653 592653 Colebeare, William, junior, of South Tauton, yeoman 1
5296853 2444068 2444068 defendant Hole Richard tucker 592653 592653 Hole, Richard, of South Tauton, tucker 0
5296854 2444068 2444068 defendant Hole Henry laborer 592653 592653 Hole, Henry, of South Tauton, laborer 1
5311395 2448442 2448442 defendant Rondell Walter clerk 592653 592653 Rondell, Walter, of South Tauton, clerk 0
5311405 2448443 2448443 defendant Rondell Walter clerk 592653 592653 Rondell, Walter, of South Tauton, clerk 0
5311412 2448444 2448444 defendant Rondell Walter clerk 592653 592653 Rondell, Walter, of South Tauton, clerk 0
5319003 2450775 2450775 defendant Oxenham William yeoman 592653 592653 Oxenham, William, of South Tauton, yeoman 0
5445942 2488674 2488674 defendant Sloman Robert butcher 592653 592653 Sloman, Robert, of South Tauton, butcher 2
5521958 2511682 2511682 defendant Taverner Richard gent 592653 592653 Taverner, Richard, of South Tauton, gent 0
5636544 2555379 2555379 defendant Oxenham Richard yeoman 592653 592653 Oxenham, Richard, of South Tauton, yeoman 0
5636545 2555379 2555379 defendant Oxenham Thomas tucker 592653 592653 Oxenham, Thomas, of South Tauton, tucker 1
5636546 2555379 2555379 defendant Oxenham William   592653 592653 Oxenham, William, of South Tauton, holy water clerk 2
5636547 2555379 2555379 defendant Oxenham John   592653 592653 Oxenham, John, of South Tauton, groom 3
5636548 2555379 2555379 defendant Mylleford William gent 592653 592653 Mylleford, William, of South Tauton, gent 4
5636549 2555379 2555379 defendant Leveton Geoffrey husbandman 592653 592653 Leveton, Geoffrey, of South Tauton, husbandman 5
5636550 2555379 2555379 defendant Batteshill John husbandman 592653 592653 Batteshill, John, of South Tauton, husbandman 6
5636551 2555379 2555379 defendant Aderscote William butcher 592653 592653 Aderscote, William, of South Tauton, butcher 7
5636552 2555379 2555379 defendant Selyman Thomas tailor 592653 592653 Selyman, Thomas, of South Tauton, tailor 8
5636553 2555379 2555379 defendant Trendelbeare John husbandman 592653 592653 Trendelbeare, John, of South Tauton, husbandman 9
5636554 2555379 2555379 defendant Wilman John husbandman 592653 592653 Wilman, John, of South Tauton, husbandman 10
5636555 2555379 2555379 defendant Wouston or Wonston John laborer 592653 592653 Wouston or Wonston, John, of South Tauton, laborer 11

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