names

169 rows where place_id = 591693

✎ 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
3605260 1869312 1869312 defendant Fyssher Richard husbandman 591693 591693 Fyssher, Richard, of Cheltenham, husbandman 1
3605680 1869441 1869441 defendant Baker Richard yeoman 591693 591693 Baker, Richard, of Cheltenham, yeoman 2
3605685 1869442 1869442 defendant Baker Richard yeoman 591693 591693 Baker, Richard, of Cheltenham, yeoman 2
3622912 1874696 1874696 defendant Wynbolt Walter husbandman 591693 591693 Wynbolt, Walter, of Cheltenham, husbandman 0
3670615 1916774 1916774 defendant Frenche Reginald husbandman 591693 591693 Frenche, Reginald, of Cheltenham, husbandman 0
3707506 1928641 1928641 defendant Machyn Thomas, senior yeoman. 591693 591693 Machyn, Thomas, senior, of Cheltenham, yeoman. Executor of 0
3707507 1928641 1928641 defendant Machyn William yeoman 591693 591693 Machyn, William, of Cheltenham, yeoman 1
3721967 1933136 1933136 defendant Machyn Thomas, senior (legal representative) 591693 591693 Machyn, Thomas, senior, of Cheltenham, yeoman, executor of 0
3721968 1933136 1933136 defendant Machyn William yeoman 591693 591693 Machyn, William, of Cheltenham, yeoman 1
3744050 1940033 1940033 defendant White John yeoman 591693 591693 White, John, of Cheltenham, yeoman 1
3750951 1942222 1942222 defendant Farrenter Walter butcher 591693 591693 Farrenter, Walter, of Cheltenham, butcher 0
3750952 1942222 1942222 defendant Tasker Richard husbandman 591693 591693 Tasker, Richard, of Cheltenham, husbandman 1
3781258 1951878 1951878 defendant Strode John laborer 591693 591693 Strode, John, of Cheltenham, laborer 1
3803646 1959055 1959055 defendant Frenche alias Lane Reginald yeoman 591693 591693 Frenche alias Lane, Reginald, of Cheltenham, yeoman 0
3815431 1962743 1962743 defendant Meryet Thomas husbandman 591693 591693 Meryet, Thomas, of Cheltenham, husbandman 1
3815432 1962743 1962743 defendant Halsted Richard yeoman 591693 591693 Halsted, Richard, of Cheltenham, yeoman 2
3833218 1968321 1968321 plaintiff Lane Thomas   591693 591693 Lane, Thomas, of Cheltenham 0
3918889 1996640 1996640 defendant Farraunter Walter butcher 591693 591693 Farraunter, Walter, of Cheltenham, butcher 0
3940928 2003973 2003973 defendant Benbow Edmund husbandman 591693 591693 Benbow, Edmund, of Cheltenham, husbandman 0
4009536 2028177 2028177 defendant Macy Lawrence yeoman 591693 591693 Macy, Lawrence, of Cheltenham, yeoman 0
4010274 2028443 2028443 defendant Brokebanck Thomas butcher 591693 591693 Brokebanck, Thomas, of Cheltenham, butcher 0
4035387 2037330 2037330 defendant Trynder Robert husbandman 591693 591693 Trynder, Robert, of Cheltenham, husbandman 0
4035390 2037331 2037331 defendant Trynder Robert husbandman or miller 591693 591693 Trynder, Robert, of Cheltenham, husbandman or miller 0
4036616 2037779 2037779 plaintiff Hygg Thomas, junior yeoman 591693 591693 Hygg, Thomas, junior, of Cheltenham, yeoman 0
4036620 2037780 2037780 plaintiff Hygg Thomas, junior yeoman 591693 591693 Hygg, Thomas, junior, of Cheltenham, yeoman 0
4036624 2037781 2037781 plaintiff Hygges Thomas yeoman 591693 591693 Hygges, Thomas, of Cheltenham, yeoman 0
4039394 2038715 2038715 defendant Wager Edward yeoman 591693 591693 Wager, Edward, of Cheltenham, yeoman 0
4107602 2063000 2063000 defendant Greneweye John husbandman 591693 591693 Greneweye, John, of Cheltenham, husbandman 2
4109201 2063546 2063546 defendant Harris William husbandman 591693 591693 Harris, William, of Cheltenham, husbandman 0
4139262 2074411 2074411 defendant Machyn Anthony gent 591693 591693 Machyn, Anthony, of Cheltenham, gent 1
4142677 2075607 2075607 defendant Farrender Richard   591693 591693 Farrender, Richard, of Cheltenham, butcher, administrators of 0
4142678 2075607 2075607 defendant Tuffley Geoffrey yeoman 591693 591693 (Tuffley, Geoffrey, of Cheltenham, yeoman 1
4163975 2082929 2082929 defendant Machyn Anthony gent 591693 591693 Machyn, Anthony, of Cheltenham, gent 1
4167531 2084138 2084138 defendant Farrender Richard (legal representative) 591693 591693 Farrender, Richard, of Cheltenham, butcher, executors of 0
4167532 2084138 2084138 defendant Tusley Geoffrey yeoman 591693 591693 (Tusley, Geoffrey, of Cheltenham, yeoman 1
4170047 2085017 2085017 defendant Pates William mercer 591693 591693 Pates, William, of Cheltenham, gent, mercer 0
4177690 2087673 2087673 defendant Maye alias Pereson John scrivener 591693 591693 Maye alias Pereson, John, of Cheltenham, scrivener 0
4177692 2087674 2087674 defendant Maye alias Pereson John scrivener 591693 591693 Maye alias Pereson, John, of Cheltenham, scrivener 0
4208092 2098389 2098389 defendant Grenewey John yeoman 591693 591693 Grenewey, John, of Cheltenham, yeoman 0
4211123 2099447 2099447 defendant Machyn Anthony gent 591693 591693 Machyn, Anthony, of Cheltenham, gent 0
4221391 2102981 2102981 defendant Tuffley Geoffrey yeoman 591693 591693 Tuffley, Geoffrey, of Cheltenham, yeoman 0
4221392 2102981 2102981 defendant Tuffley Alice widow 591693 591693 Alice his wife, formerly Alice Ferrenter, of Cheltenham, widow 1
4238750 2109173 2109173 defendant Tuffley Geoffrey yeoman 591693 591693 Tuffley, Geoffrey, of Cheltenham, yeoman 0
4238751 2109173 2109173 defendant Tuffley Alice widow 591693 591693 Alice his wife, formerly Alice Ferrenter, of Cheltenham, widow 1
4266415 2118412 2118412 defendant Machyn Thomas gent 591693 591693 Machyn, Thomas, of Cheltenham, gent 0
4304390 2131671 2131671 defendant Bick William yeoman 591693 591693 Bick, William, of Cheltenham, yeoman 3
4308861 2133248 2133248 defendant Higges Thomas (legal representative) 591693 591693 Higges, Thomas, of Cheltenham, yeoman, executrix of 0
4350374 2147393 2147393 defendant Pates William mercer 591693 591693 Pates, William, of Cheltenham, mercer 0
4394191 2162658 2162658 defendant Frenche Walter yeoman 591693 591693 Frenche, Walter, of Cheltenham, yeoman 1
4425544 2172816 2172816 plaintiff Mayel William   591693 591693 Mayel, William, of Cheltenham 0
4425547 2172816 2172816 defendant Chaliner Richard   591693 591693 Chaliner, Richard, of Cheltenham 1
4509692 2203514 2203514 plaintiff Audeley John   591693 591693 Audeley, John, of Cheltenham 0
4509693 2203514 2203514 defendant Persoun William   591693 591693 Persoun, William, of Cheltenham 0
4511875 2204163 2204163 plaintiff Bocher John   591693 591693 Bocher, John, of Cheltenham 0
4522714 2207440 2207440 defendant Souley William   591693 591693 Souley, William, of Cheltenham 5
4524844 2208110 2208110 defendant Webbe John shoemaker 591693 591693 Webbe, John, of Cheltenham, shoemaker 0
4546858 2214945 2214945 defendant Style Walter   591693 591693 Style, Walter, of Cheltenham 3
4550920 2216224 2216224 defendant Bocher William   591693 591693 Bocher, William, of Cheltenham 0
4550921 2216224 2216224 defendant Purce John   591693 591693 Purce, John, of Cheltenham 1
4551498 2216409 2216409 plaintiff Duskyn William   591693 591693 Duskyn, William, of Cheltenham 0
4556100 2217850 2217850 defendant Bocher William   591693 591693 Bocher, William, of Cheltenham 1
4567958 2221547 2221547 defendant Devenysshe Richard   591693 591693 Devenysshe, Richard, of Cheltenham 1
4595419 2229823 2229823 defendant Lardener John   591693 591693 Lardener, John, of Cheltenham 0
4606909 2233269 2233269 defendant atte Ferme John   591693 591693 atte Ferme, John, of Cheltenham 2
4638808 2242874 2242874 defendant Fyssher Nicholas   591693 591693 Fyssher, Nicholas, of Cheltenham 0
4650049 2246028 2246028 plaintiff Webbe John   591693 591693 Webbe, John, of Cheltenham 0
4686643 2261433 2261433 defendant Chaloner Walter chaloner or blanket maker 591693 591693 Chaloner, Walter, of cheltenham, chaloner or blanket maker 0
4702154 2266083 2266083 defendant Webbe Thomas   591693 591693 Webbe, Thomas, of Cheltenham, horse dealer 1
4704120 2266667 2266667 defendant Chaloner Walter chaloner 591693 591693 Chaloner, Walter, of Cheltenham, chaloner 1
4704121 2266667 2266667 defendant Berkesdene William husbandman 591693 591693 Berkesdene, William, of Cheltenham, husbandman 2
4717584 2270835 2270835 defendant Curriour John shoemaker 591693 591693 Curriour, John, of Cheltenham, shoemaker 1
4720612 2271779 2271779 defendant Cheltenham John yeoman 591693 591693 Cheltenham, John, of Cheltenham, yeoman 4
4721933 2272191 2272191 defendant Corsour Thomas husbandman 591693 591693 Corsour, Thomas, of Cheltenham, husbandman 0
4727144 2273749 2273749 defendant Chaloner Walter chaloner 591693 591693 Chaloner, Walter, of Cheltenham, chaloner 0
4727145 2273749 2273749 defendant Chaloner Thomas chaloner 591693 591693 Chaloner, Thomas, of Cheltenham, chaloner 1
4727952 2273986 2273986 defendant Chaloner Walter chaloner 591693 591693 Chaloner, Walter, of Cheltenham, chaloner 0
4731277 2274983 2274983 defendant Devenyssh Richard chapman 591693 591693 Devenyssh, Richard, of Cheltenham, chapman 0
4735038 2276106 2276106 defendant Hubard Thomas husbandman 591693 591693 Hubard, Thomas, of Cheltenham, husbandman 0
4738087 2277015 2277015 defendant Ursy Thomas butcher 591693 591693 Ursy, Thomas, of Cheltenham, butcher 2
4738088 2277015 2277015 defendant Chaloner Thomas husbandman 591693 591693 Chaloner, Thomas, of Cheltenham, husbandman 3
4739886 2277551 2277551 defendant Chaloner William chaloner 591693 591693 Chaloner, William, of Cheltenham, chaloner 1
4739887 2277551 2277551 defendant Dyer William dyer 591693 591693 Dyer, William, of Cheltenham, dyer 2
4744026 2278778 2278778 defendant Webbe Thomas shoemaker 591693 591693 Webbe, Thomas, of Cheltenham, shoemaker 1
4744027 2278778 2278778 defendant Dyer John dyer 591693 591693 Dyer, John, of Cheltenham, dyer 2
4753753 2281547 2281547 defendant Chaloner Thomas husbandman 591693 591693 Chaloner, Thomas, of Cheltenham, husbandman 3
4808255 2298760 2298760 defendant Anford Thomas husbandman 591693 591693 Anford, Thomas, of Cheltenham, husbandman 0
4809245 2299066 2299066 defendant Forke John drover 591693 591693 Forke, John, of Cheltenham, drover 0
4813637 2300371 2300371 defendant Devenyssh William husbandman 591693 591693 Devenyssh, William, of Cheltenham, husbandman 0
4813653 2300377 2300377 defendant Smyth John laborer 591693 591693 Smyth, John, of Cheltenham, laborer 0
4818326 2301814 2301814 defendant Pecher Walter   591693 591693 Pecher, Walter, of Cheltenham, mason 1
4819523 2302185 2302185 defendant Devenysh William fisher 591693 591693 Devenysh, William, of Cheltenham, fisher 0
4819524 2302185 2302185 defendant Mulleward Richard maltman 591693 591693 Mulleward, Richard, of Cheltenham, maltman 1
4821154 2302696 2302696 defendant Norton John chaplain 591693 591693 Norton, John, of Cheltenham, chaplain 0
4827874 2304772 2304772 defendant Mason John   591693 591693 Mason, John, of Cheltenham 2
4841560 2308894 2308894 defendant Westlond William husbandman 591693 591693 Westlond, William, of Cheltenham, husbandman 0
4841561 2308894 2308894 defendant Westlond John   591693 591693 Westlond, John, of Cheltenham, single man 1
4841562 2308894 2308894 defendant Westlond Robert husbandman 591693 591693 Westlond, Robert, of Cheltenham, husbandman 2
4844730 2309870 2309870 defendant Ricardes Walter husbandman 591693 591693 Ricardes, Walter, of Cheltenham, husbandman 0
4851228 2311832 2311832 defendant Devenys Thomas fishmonger 591693 591693 Devenys, Thomas, of Cheltenham, fishmonger 0
4896656 2325613 2325613 defendant Laweton Hugh yeoman 591693 591693 Laweton, Hugh, of Cheltenham, yeoman 2

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