names

139 rows where place_id = 587237

✎ 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
3590868 1864775 1864775 defendant Attewater John butcher 587237 587237 Attewater, John, of Colbroke, butcher 1
3600131 1867693 1867693 defendant Nanger Richard butcher 587237 587237 Nanger, Richard, of Colbroke, butcher 0
3602004 1868287 1868287 defendant Beracre Henry butcher 587237 587237 Beracre, Henry, of Colbroke, butcher 0
3605302 1869322 1869322 defendant Barryng John yeoman 587237 587237 Barryng, John, of Colbroke, yeoman 2
3612123 1871434 1871434 defendant Lugger Stephen husbandman 587237 587237 Lugger, Stephen, of Colbroke, Plympton Prior, husbandman 3
3612124 1871434 1871434 defendant Langman John husbandman 587237 587237 Langman, John, of Colbroke, Plympton Prior, husbandman 4
3612125 1871434 1871434 defendant Brokyng William husbandman 587237 587237 Brokyng, William, of Colbroke, Plympton Prior, husbandman 5
3612126 1871434 1871434 defendant Brokyng John husbandman 587237 587237 Brokyng, John, of Colbroke, Plympton Prior, husbandman 6
3612127 1871434 1871434 defendant Robyn John tanner 587237 587237 Robyn, John, of Colbroke, Plympton Prior, tanner 7
3612505 1871542 1871542 defendant Seymour Walter cordwainer 587237 587237 Seymour, Walter, of Colbroke, cordwainer 8
3631604 1904699 1904699 defendant Baraker John husbandman 587237 587237 Baraker, John, of Colbroke, husbandman 0
3635785 1905993 1905993 defendant Adams Nicholas innholder 587237 587237 Adams, Nicholas, of Colbroke, innholder 0
3654367 1911627 1911627 defendant Anger or Auger Robert butcher 587237 587237 Anger or Auger, Robert, of Colbroke, butcher 0
3661769 1913963 1913963 defendant Pytteney Richard smith 587237 587237 Pytteney, Richard, of Colbroke, smith 3
3677242 1918928 1918928 defendant Cowper Thomas butcher 587237 587237 Cowper, Thomas, of Colbroke, butcher 0
3677243 1918928 1918928 defendant Trotte Richard butcher 587237 587237 Trotte, Richard, of Colbroke, butcher 1
3679505 1919660 1919660 defendant Weston Robert innholder 587237 587237 Weston, Robert, of Colbroke, innholder 1
3700282 1926325 1926325 defendant Trotte Richard butcher 587237 587237 Trotte, Richard, of Colbroke, butcher 1
3701797 1926812 1926812 defendant Cowper Thomas butcher 587237 587237 Cowper, Thomas, of Colbroke, butcher 0
3716456 1931440 1931440 defendant Lymelyar William laborer 587237 587237 Lymelyar, William, of Colbroke, laborer 0
3728540 1935176 1935176 defendant Cowper Thomas butcher 587237 587237 Cowper, Thomas, of Colbroke, butcher 0
3728542 1935177 1935177 defendant Dewepont William tailor 587237 587237 Dewepont, William, of Colbroke, tailor 0
3730316 1935714 1935714 plaintiff Boterell John   587237 587237 Boterell, John, of Colbroke, yeoman, administrators of 0
3734025 1936889 1936889 defendant Estbroke William husbandman 587237 587237 Estbroke, William, of Colbroke, husbandman 0
3741376 1939171 1939171 defendant Escote Philip yeoman 587237 587237 Escote, Philip, of Colbroke, yeoman 3
3752286 1942637 1942637 defendant Pyke Robert tailor 587237 587237 Pyke, Robert, of Colbroke, tailor 3
3765703 1946939 1946939 defendant Wakeham Walter butcher 587237 587237 Wakeham, Walter, of Colbroke, butcher 2
3768963 1947945 1947945 defendant Pyke Robert tailor 587237 587237 Pyke, Robert, of Colbroke, tailor 3
3780289 1951565 1951565 defendant Trott Richard butcher 587237 587237 Trott, Richard, of Colbroke, butcher 0
3782091 1952152 1952152 defendant Walker Richard glover 587237 587237 Walker, Richard, of Colbroke, glover 2
3782097 1952153 1952153 defendant Walker Richard glover 587237 587237 Walker, Richard, of Colbroke, glover 2
3786761 1953655 1953655 defendant Pyke Robert tailor 587237 587237 Pyke, Robert, of Colbroke, tailor 3
3795496 1956472 1956472 defendant Tayllour William butcher 587237 587237 Tayllour, William, of Colbroke, butcher 0
3800295 1958013 1958013 defendant Pytney Richard smith 587237 587237 Pytney, Richard, of Colbroke, smith 1
3802679 1958732 1958732 defendant Pyke Robert tailor 587237 587237 Pyke, Robert, of Colbroke, tailor 3
3814265 1962369 1962369 defendant Orpy William baker 587237 587237 Orpy, William, of Colbroke, baker 1
3861087 1977191 1977191 defendant Hoke John miller 587237 587237 Hoke, John, of Colbroke, miller 0
3873143 1981234 1981234 defendant Payne John chaplain 587237 587237 Payne, John, of Colbroke, chaplain 0
3888045 1986254 1986254 defendant Borough Thomas husbandman 587237 587237 Borough, Thomas, of Colbroke, husbandman 0
3889841 1986842 1986842 defendant Westwaye William husbandman 587237 587237 Westwaye, William, of Colbroke, husbandman 0
3911826 1994279 1994279 defendant Buttysford William husbandman 587237 587237 Buttysford, William, of Colbroke, husbandman 0
3911827 1994279 1994279 defendant Buttysford Edmund husbandman 587237 587237 Buttysford, Edmund, of Colbroke, husbandman 1
3922281 1997763 1997763 defendant Estbroke Robert husbandman 587237 587237 Estbroke, Robert, of Colbroke, husbandman 0
3956523 2009348 2009348 defendant Reve Robert husbandman 587237 587237 Reve, Robert, of Colbroke, husbandman 0
3956524 2009348 2009348 defendant Nethercote Henry husbandman 587237 587237 Nethercote, Henry, of Colbroke, husbandman 1
3975583 2016026 2016026 defendant Seger William husbandman 587237 587237 Seger, William, of Colbroke, husbandman 0
3986434 2019891 2019891 plaintiff Westway Elias   587237 587237 Westway, Elias, of Colbroke 0
3986437 2019892 2019892 plaintiff Westway Elias   587237 587237 Westway, Elias, of Colbroke 0
4027697 2034554 2034554 defendant Westway Elias husbandman 587237 587237 Westway, Elias, of Colbroke, husbandman 0
4035089 2037231 2037231 plaintiff Herbert William esq 587237 587237 Herbert, William, of Colbroke, esq 0
4043273 2040064 2040064 defendant Bowser John gent 587237 587237 Bowser, John, of Colbroke, gent 1
4044028 2040314 2040314 defendant Bowser John gent 587237 587237 Bowser, John, of Colbroke, gent 1
4044524 2040494 2040494 plaintiff Redinge Henry (legal representative) 587237 587237 Redinge, Henry, of Colbroke, executrix of 0
4065591 2047984 2047984 defendant Holland James (legal representative) 587237 587237 Holland, James, of Colbroke, innholder, executors of 0
4065718 2048033 2048033 plaintiff Herbert William esq 587237 587237 Herbert, William, of Colbroke, esq 0
4291786 2127137 2127137 defendant Kempe John yeoman 587237 587237 Kempe, John, of Colbroke, yeoman 1
4485679 2196228 2196228 defendant Bonamour Adam fuller 587237 587237 Bonamour, Adam, of Colbroke, fuller 0
4600397 2231349 2231349 defendant Baker John   587237 587237 Baker, John, of Colbroke 6
4618239 2236713 2236713 plaintiff Wyot Richard   587237 587237 Wyot, Richard, of Colbroke 2
4627091 2239423 2239423 defendant Pays Thomas   587237 587237 Pays, Thomas, of Colbroke 0
4652794 2246807 2246807 defendant Baker John   587237 587237 Baker, John, of Colbroke 0
4683170 2260353 2260353 defendant Hugge Roger husbandman 587237 587237 Hugge, Roger, of Colbroke, husbandman 0
4753654 2281514 2281514 defendant Duchesman Liberty cobbler 587237 587237 Duchesman, Liberty, of Colbroke, cobbler 0
4779405 2289542 2289542 defendant Fennycombe Lawrence husbandman 587237 587237 Fennycombe, Lawrence, of Colbroke, husbandman 2
4779410 2289543 2289543 defendant Fennycombe Lawrence husbandman 587237 587237 Fennycombe, Lawrence, of Colbroke, husbandman 1
4785385 2291445 2291445 defendant Bagot Richard husbandman 587237 587237 Bagot, Richard, of Colbroke, husbandman 0
4792902 2293867 2293867 defendant Bagote Richard husbandman 587237 587237 Bagote, Richard, of Colbroke, husbandman 1
4801791 2296742 2296742 defendant Clower William   587237 587237 Clower, William, of Colbroke, collar maker 0
4896292 2325503 2325503 defendant Boston john husbandman 587237 587237 Boston, john, of Colbroke, husbandman 0
4897100 2325748 2325748 defendant del Fordde John husbandman 587237 587237 del Fordde, John, of Colbroke, husbandman 1
4955924 2343738 2343738 defendant Londe John butcher 587237 587237 Londe, John, of Colbroke, butcher 0
4960529 2345118 2345118 defendant Fouler Henry laborer 587237 587237 Fouler, Henry, of Colbroke, laborer 2
4969789 2347909 2347909 defendant Hertylpole John yeoman 587237 587237 Hertylpole, John, of Colbroke, yeoman 0
4972116 2348599 2348599 defendant Hertilpole John ostler 587237 587237 Hertilpole, John, of Colbroke, ostler 0
4990566 2354086 2354086 defendant Laurence John   587237 587237 Laurence, John, of Colbroke 0
4999387 2356687 2356687 plaintiff Laurence John   587237 587237 Laurence, John, of Colbroke 0
5008523 2359389 2359389 defendant Hertilpole John hostiler & draper 587237 587237 Hertilpole, John, of Colbroke, hostiler & draper 0
5008530 2359391 2359391 defendant Hertylpole John hosteler alias draper 587237 587237 Hertylpole, John, of Colbroke, hosteler alias draper 2
5008534 2359392 2359392 defendant Hertilpole John hosteller 587237 587237 Hertilpole, John, of Colbroke, hosteller 2
5034463 2366939 2366939 defendant Bostone John yeoman 587237 587237 Bostone, John, of Colbroke, yeoman 0
5049812 2371572 2371572 defendant Boston John yeoman 587237 587237 Boston, John, of Colbroke, yeoman 1
5074961 2379018 2379018 defendant Ferrour or Smith John smith 587237 587237 Ferrour or Smith, John, of Colbroke, smith 0
5075304 2379109 2379109 defendant Hertelpole John gent 587237 587237 Hertelpole, John, of Colbroke, gent 0
5090649 2383648 2383648 defendant Barrakyr William hosier 587237 587237 Barrakyr, William, of Colbroke, hosier 0
5090651 2383649 2383649 defendant Barrakyr William hosier 587237 587237 Barrakyr, William, of Colbroke, hosier 0
5126796 2394310 2394310 defendant Hertilpole John gent 587237 587237 Hertilpole, John, of Colbroke, gent 2
5127135 2394412 2394412 defendant Hertilpole John gent 587237 587237 Hertilpole, John, of Colbroke, gent 2
5153769 2402263 2402263 defendant Kyngwyll atte Thorn Thomas husbandman 587237 587237 Kyngwyll atte Thorn, Thomas, of Colbroke, husbandman 0
5168341 2406457 2406457 defendant Parker Robert baker 587237 587237 Parker, Robert, of Colbroke, baker 3
5171059 2407259 2407259 defendant Kyngwyll atte Thorn Thomas husbandman 587237 587237 Kyngwyll atte Thorn, Thomas, of Colbroke, husbandman 0
5179580 2409762 2409762 defendant Pagynton William butcher 587237 587237 Pagynton, William, of Colbroke, butcher 1
5207071 2417806 2417806 defendant Parker Robert baker 587237 587237 Parker, Robert, of Colbroke, baker 0
5218038 2421012 2421012 defendant Pakutton William butcher 587237 587237 Pakutton, William, of Colbroke, butcher 0
5220498 2421690 2421690 defendant Bereacre John husbandman 587237 587237 Bereacre, John, of Colbroke, husbandman 2
5221731 2422053 2422053 defendant Wattys Henry yeoman 587237 587237 Wattys, Henry, of Colbroke, yeoman 0
5230515 2424541 2424541 defendant Copleston Philip gent 587237 587237 Copleston, Philip, of Colbroke, gent 1
5237315 2426497 2426497 defendant Pree Richard gent 587237 587237 Pree, Richard, of Colbroke, gent 2
5249375 2429933 2429933 defendant Trolly John miller 587237 587237 Trolly, John, of Colbroke, miller 3
5252173 2430792 2430792 defendant Broun Thomas laborer 587237 587237 Broun, Thomas, of Colbroke, laborer 0
5263287 2434263 2434263 defendant Algore John butcher 587237 587237 Algore, John, of Colbroke, butcher 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);