names

133 rows where place_id = 635705

✎ 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
3827056 1966318 1966318 defendant Saxton William miller 635705 635705 Saxton, William, of Well, miller 0
3839260 1970207 1970207 defendant Spendluff Thomas yeoman 635705 635705 Spendluff, Thomas, of Well, yeoman 2
3909611 1993520 1993520 defendant Bateman William   635705 635705 Bateman, William, of Well, husbandman, son of John Bateman 0
3915334 1995495 1995495 plaintiff (not given) Walter rector of Cretynge 635705 635705 Cretynge, Walter, of Well, rector of Hunspill 0
3915338 1995496 1995496 plaintiff (not given) Walter rector of Cretynge 635705 635705 Cretynge, Walter, of Well, rector of Hunspyll 0
3939732 2003593 2003593 defendant Norsse Robert tanner 635705 635705 Norsse, Robert, of Well, tanner 3
3972086 2014797 2014797 plaintiff Foster James yeoman 635705 635705 Foster, James, of Well, yeoman 0
3983335 2018812 2018812 defendant Bate Henry laborer 635705 635705 Bate, Henry, of Well, laborer 0
3992114 2021943 2021943 defendant Alforde Francis butcher 635705 635705 Alforde, Francis, of Well, butcher 0
3996572 2023534 2023534 plaintiff Degon Margaret widow 635705 635705 Margaret his wife, formerly Margaret Lewse, of Well, widow 1
4000974 2025119 2025119 plaintiff Gye Thomas farmer 635705 635705 Gye, Thomas, of Well, farmer 0
4006472 2027093 2027093 plaintiff Lewellin Thomas gent 635705 635705 Lewellin, Thomas, of Well, gent 0
4007985 2027618 2027618 defendant Lane Peter yeoman 635705 635705 Lane, Peter, of Well, yeoman 0
4015605 2030279 2030279 plaintiff Smythe William draper 635705 635705 Smythe, William, of Well, draper 0
4022744 2032858 2032858 defendant Clement John, senior husbandman 635705 635705 Clement, John, senior, of Well, husbandman 0
4022745 2032858 2032858 defendant Bynyng William husbandman 635705 635705 Bynyng, William, of Well, husbandman 1
4022747 2032859 2032859 defendant Clement John, senior husbandman 635705 635705 Clement, John, senior, of Well, husbandman 0
4022748 2032859 2032859 defendant Bynynge William husbandman 635705 635705 Bynynge, William, of Well, husbandman 1
4029420 2035160 2035160 plaintiff Danbye Nicholas merchant 635705 635705 Danbye, Nicholas, of Well, merchant 0
4029422 2035161 2035161 plaintiff Danbye Nicholas merchant 635705 635705 Danbye, Nicholas, of Well, merchant 0
4030917 2035722 2035722 plaintiff Evens John husbandman 635705 635705 Evens, John, of Well, husbandman 0
4031179 2035821 2035821 plaintiff Fary John mariner 635705 635705 Fary, John, of Well, mariner 0
4031182 2035822 2035822 plaintiff Fary John mariner 635705 635705 Fary, John, of Well, mariner 0
4045424 2040815 2040815 plaintiff Sabbe William yeoman 635705 635705 Sabbe, William, of Well, yeoman 0
4064414 2047552 2047552 defendant Aysshe Humphrey tailor 635705 635705 Aysshe, Humphrey, of Well, tailor 0
4067360 2048630 2048630 defendant Aysshe Humphrey tailor 635705 635705 Aysshe, Humphrey, of Well, tailor 0
4068825 2049140 2049140 defendant Smyth William tailor 635705 635705 Smyth, William, of Well, tailor 0
4085409 2055057 2055057 defendant Bowreman William esq 635705 635705 Bowreman, William, of Well, esq 0
4085413 2055059 2055059 defendant Godwen Richard gent 635705 635705 Godwen, Richard, of Well, gent 0
4085421 2055062 2055062 defendant Smyth William capper 635705 635705 Smyth, William, of Well, capper 0
4091172 2057132 2057132 defendant Harrys Nicholas butcher 635705 635705 Harrys, Nicholas, of Well, butcher 0
4092121 2057478 2057478 defendant Goddinge Richard gent 635705 635705 Goddinge, Richard, of Well, gent 0
4096172 2058959 2058959 defendant Castell Thomas yeoman 635705 635705 Castell, Thomas, of Well, yeoman 0
4096173 2058959 2058959 defendant Jett Alexander smith 635705 635705 Jett, Alexander, of Well, smith 1
4102526 2061202 2061202 defendant Harrys Nicholas butcher 635705 635705 Harrys, Nicholas, of Well, butcher 0
4108929 2063448 2063448 defendant Copledyke William husbandman 635705 635705 Copledyke, William, of Well, husbandman 1
4127491 2070127 2070127 defendant Freman Nicholas gent 635705 635705 Freman, Nicholas, of Well, gent 0
4131717 2071663 2071663 defendant Applegate Richard weaver 635705 635705 Applegate, Richard, of Well, weaver 2
4131718 2071663 2071663 defendant Cary Robert, senior husbandman 635705 635705 Cary, Robert, senior, of Well, or of Dulcott, husbandman 3
4131722 2071664 2071664 defendant Applegate Richard weaver 635705 635705 Applegate, Richard, of Well, weaver 2
4131723 2071664 2071664 defendant Cary Robert, senior husbandman 635705 635705 Cary, Robert, senior, of Well, or of Dulcot, husbandman 3
4142822 2075664 2075664 defendant Jones Henry   635705 635705 Jones, Henry, of Well, "grovyer" 2
4144532 2076247 2076247 defendant Thorley William   635705 635705 Thorley, William, of Well, gent, undersheriff of Henry Newton, sheriff of Somerset 0
4150842 2078427 2078427 defendant Freman Nicholas gent 635705 635705 Freman, Nicholas, of Well, gent 0
4155321 2079954 2079954 defendant Dawes Richard innholder 635705 635705 Dawes, Richard, of Well, innholder 0
4155323 2079954 2079954 defendant Wellshette William yeoman 635705 635705 Wellshette, William, of Well, yeoman 2
4155876 2080132 2080132 defendant Earle Humphrey butcher 635705 635705 Earle, Humphrey, of Well, butcher 0
4156420 2080322 2080322 defendant Newton Henry   635705 635705 Newton, Henry, of Well, esq, sheriff 0
4158313 2080977 2080977 defendant Butler John husbandman 635705 635705 Butler, John, of Well, husbandman 0
4158930 2081192 2081192 defendant Durban John yeoman 635705 635705 Durban, John, of Well, yeoman 0
4162712 2082514 2082514 defendant Gett or Jett Sander smith 635705 635705 Gett or Jett, Sander, of Well, smith 2
4162713 2082514 2082514 defendant Vygor William tailor 635705 635705 Vygor, William, of Well, tailor 3
4170263 2085094 2085094 defendant Pytt William husbandman 635705 635705 Pytt, William, of Well, husbandmanBlynman or Blindman, John, of Whitnell, Wells, husbandman 1
4170266 2085095 2085095 defendant Hunte Osmund weaver 635705 635705 Hunte, Osmund, of Well, weaver 0
4171641 2085546 2085546 defendant Pomery Ralph cordwainer 635705 635705 Pomery, Ralph, of Well, cordwainer 3
4179602 2088341 2088341 defendant Myldon Richard yeoman 635705 635705 Myldon, Richard, of Well, yeoman 0
4179606 2088342 2088342 defendant Myldon Richard yeoman 635705 635705 Myldon, Richard, of Well, yeoman 0
4185689 2090498 2090498 defendant Lyte William tanner 635705 635705 Lyte, William, of Well, yeoman, tanner 0
4193412 2093262 2093262 defendant Page Robert yeoman 635705 635705 Page, Robert, of Well, yeoman 1
4193598 2093329 2093329 defendant Trowtell Thomas yeoman 635705 635705 Trowtell, Thomas, of Well, yeoman 2
4193602 2093330 2093330 defendant Pytt William husbandman 635705 635705 Pytt, William, of Well, husbandman 1
4193603 2093330 2093330 defendant Blynman John, senior husbandman 635705 635705 Blynman, John, senior, of Well, or of Whytnell, Wells, husbandman 2
4198245 2094934 2094934 defendant Jenckyns Henry dyer 635705 635705 Jenckyns, Henry, of Well, dyer 0
4211282 2099499 2099499 defendant Leighe Thomas gent 635705 635705 Leighe, Thomas, of Well, gent 0
4221871 2103146 2103146 defendant Watt Edmund clerk 635705 635705 Watt, Edmund, of Well, clerk 0
4221873 2103147 2103147 defendant Watt Edmund clerk 635705 635705 Watt, Edmund, of Well, clerk 0
4239306 2109367 2109367 defendant Alesbye William husbandman 635705 635705 Alesbye, William, of Well, husbandman 0
4240944 2109955 2109955 defendant Atwood Thomas gent 635705 635705 Atwood, Thomas, of Well, gent 0
4240945 2109955 2109955 defendant Caresbroke George yeoman 635705 635705 Caresbroke, George, of Well, yeoman 1
4240946 2109955 2109955 defendant Cuff John husbandman 635705 635705 Cuff, John, of Well, husbandman 2
4240947 2109955 2109955 defendant Woodyer John husbandman 635705 635705 Woodyer, John, of Well, husbandman 3
4240949 2109956 2109956 defendant Gallington John yeoman 635705 635705 Gallington, John, of Well, yeoman 0
4240952 2109957 2109957 defendant Rogers John husbandman 635705 635705 Rogers, John, of Well, husbandman 0
4246580 2111831 2111831 defendant Chamberlyn Hugh (legal representative) 635705 635705 Chamberlyn, Hugh, of Well, mariner, executrix of 1
4246581 2111831 2111831 defendant Chamberlyn Alice widow 635705 635705 Chamberlyn, Alice, of Well, widow 2
4246584 2111832 2111832 defendant Chamberlyn Hugh (legal representative) 635705 635705 Chamberlyn, Hugh, of Well, mariner, executrix of 1
4246585 2111832 2111832 defendant Chamberlyn Alice widow 635705 635705 Chamberlyn, Alice, of Well, widow 2
4256116 2115027 2115027 defendant Kynge John   635705 635705 Kynge, John, of Well, sailor 0
4277481 2122047 2122047 defendant Caterton Thomas gent 635705 635705 Caterton, Thomas, of Well, gent 1
4314736 2135267 2135267 defendant Kynge John yeoman 635705 635705 Kynge, John, of Well, yeoman 1
4326076 2139091 2139091 defendant Odor Elizabeth widow 635705 635705 Odor, Elizabeth, of Well, widow 2
4352990 2148276 2148276 defendant Poridge Robert husbandman 635705 635705 Poridge, Robert, of Well, husbandman 0
4370681 2154567 2154567 defendant Catterton Thomas gent 635705 635705 Catterton, Thomas, of Well, gent 1
4390654 2161490 2161490 defendant Bysse James   635705 635705 (Bysse, James, of Well, Doctor of Theology 1
4492675 2198412 2198412 defendant Maddok Robert   635705 635705 Maddok, Robert, of Well 0
4511902 2204171 2204171 defendant Benetson Walter   635705 635705 Benetson, Walter, of Well 1
4521865 2207176 2207176 defendant Poulsolt Alan   635705 635705 Poulsolt, Alan, of Well 0
4528376 2209149 2209149 plaintiff Marchaunt Thomas   635705 635705 Marchaunt, Thomas, of Well 0
4561576 2219555 2219555 defendant Straddon John   635705 635705 Straddon, John, of Well 1
4617897 2236599 2236599 plaintiff Gryme John   635705 635705 Gryme, John, of Well 0
4626625 2239272 2239272 defendant Kychyn Thomas   635705 635705 Kychyn, Thomas, of Well 0
4660759 2249189 2249189 defendant Mason John yeoman 635705 635705 Mason, John, of Well, yeoman 1
4660760 2249189 2249189 defendant Greg John yeoman 635705 635705 Greg, John, of Well, yeoman 2
4685657 2261106 2261106 defendant Attekynson William weaver 635705 635705 Attekynson, William, of Well, weaver 0
4685660 2261107 2261107 defendant Hunton William shoemaker 635705 635705 Hunton, William, of Well, shoemaker 0
4685661 2261107 2261107 defendant Griges John tailor 635705 635705 Griges, John, of Well, tailor 1
4685662 2261107 2261107 defendant Totey John husbandman 635705 635705 Totey, John, of Well, husbandman 2
4686651 2261436 2261436 defendant Tyler Agnes widow 635705 635705 Tyler, Agnes, of Well, widow 1
4716241 2270390 2270390 plaintiff Weye William   635705 635705 Weye, William, of Well 0
4744446 2278898 2278898 plaintiff Elwarde Simon   635705 635705 Elwarde, Simon, of Well 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);