names

179 rows where place_id = 588292

✎ 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
3594013 1865766 1865766 defendant Roper Robert merchant 588292 588292 Roper, Robert, of Colompton, merchant 0
3602919 1868576 1868576 defendant Sutter Nicholas horner 588292 588292 Sutter, Nicholas, of Colompton, horner 0
3632927 1905115 1905115 plaintiff Huntyngdon William (legal representative) 588292 588292 Huntyngdon, William, of Colompton, executors of 0
3653122 1911307 1911307 defendant Robert alias Daly John yeoman 588292 588292 Robert alias Daly, John, of Colompton, yeoman 0
3671057 1916915 1916915 defendant Rapgent John husbandman 588292 588292 Rapgent, John, of Colompton, husbandman 1
3678423 1919306 1919306 plaintiff More William (legal representative) 588292 588292 More, William, of Colompton, gent, executors of 0
3691130 1923388 1923388 defendant Hancok John (legal representative) 588292 588292 Hancok, John, of Colompton, executrix of 0
3691131 1923388 1923388 defendant Hancok Joan widow 588292 588292 Hancok, Joan, of Colompton, widow 1
3694596 1924512 1924512 defendant Cayleway John esq 588292 588292 Cayleway, John, of Colompton, esq 0
3705575 1928025 1928025 defendant Wescote Joan widow 588292 588292 Wescote, Joan, of Colompton, widow 1
3705576 1928025 1928025 defendant Frany Robert mercer 588292 588292 Frany, Robert, of Colompton, mercer 2
3705577 1928025 1928025 defendant Robyns John husbandman 588292 588292 Robyns, John, of Colompton, husbandman 3
3710187 1929501 1929501 defendant Robyns John husbandman 588292 588292 Robyns, John, of Colompton, husbandman 0
3710188 1929501 1929501 defendant Harward Henry carpenter 588292 588292 Harward, Henry, of Colompton, carpenter 1
3719810 1932458 1932458 defendant Trotte Thomas tanner 588292 588292 Trotte, Thomas, of Colompton, tanner 0
3719812 1932459 1932459 defendant Trotte Thomas tanner 588292 588292 Trotte, Thomas, of Colompton, tanner 0
3735915 1937473 1937473 defendant Hancoke Joan widow 588292 588292 Hancoke, Joan, of Colompton, widow 0
3737890 1938071 1938071 defendant Pytt John weaver 588292 588292 Pytt, John, of Colompton, weaver 0
3737891 1938071 1938071 defendant Facy Robert, junior merchant 588292 588292 Facy, Robert, junior, of Colompton, merchant 1
3737892 1938071 1938071 defendant Keffe or Kesse Benedict merchant 588292 588292 Keffe or Kesse, Benedict, of Colompton, merchant 2
3737893 1938071 1938071 defendant Myller Richard shoemaker 588292 588292 Myller, Richard, of Colompton, shoemaker 3
3746446 1940808 1940808 defendant Frank John butcher 588292 588292 Frank, John, of Colompton, butcher 0
3807874 1960348 1960348 defendant Whyte John weaver 588292 588292 Whyte, John, of Colompton, weaver 0
3807875 1960348 1960348 defendant Thorne Henry carrier 588292 588292 Thorne, Henry, of Colompton, carrier 1
3816324 1963013 1963013 defendant Hancok John widow 588292 588292 Hancok, John, of Colompton, widow 1
3824551 1965552 1965552 defendant Mogrygge John husbandman 588292 588292 Mogrygge, John, of Colompton, husbandman 1
3826832 1966241 1966241 defendant Snell William tanner 588292 588292 Snell, William, of Colompton, tanner 1
3826868 1966253 1966253 defendant Drewe Henry husbandman 588292 588292 Drewe, Henry, of Colompton, husbandman 0
3835067 1968908 1968908 defendant Layne Thomasine widow 588292 588292 Layne, Thomasine, of Colompton, widow 1
3836886 1969435 1969435 defendant Turnour William yeoman 588292 588292 Turnour, William, of Colompton, yeoman 0
3842342 1971142 1971142 defendant Hethefeld William husbandman 588292 588292 Hethefeld, William, of Colompton, husbandman 0
3843792 1971594 1971594 defendant Franke John butcher 588292 588292 Franke, John, of Colompton, butcher 0
3850483 1973738 1973738 defendant Jenyng Henry husbandman 588292 588292 Jenyng, Henry, of Colompton, husbandman 0
3851399 1974036 1974036 defendant Kayne Thomasine widow 588292 588292 Kayne, Thomasine, of Colompton, widow 1
3853465 1974709 1974709 defendant Paule John dyer 588292 588292 Paule, John, of Colompton, dyer 0
3859869 1976805 1976805 defendant Drewe Henry husbandman 588292 588292 Drewe, Henry, of Colompton, husbandman 0
3860612 1977042 1977042 defendant Frank John butcher 588292 588292 Frank, John, of Colompton, butcher 0
3861719 1977383 1977383 defendant More John gent 588292 588292 More, John, of Colompton, gent 0
3877146 1982597 1982597 defendant Carsewell John gent 588292 588292 Carsewell, John, of Colompton, gent 0
3877406 1982689 1982689 defendant More John gent 588292 588292 More, John, of Colompton, gent 0
3880422 1983707 1983707 defendant More John gent 588292 588292 More, John, of Colompton, gent 0
3906518 1992472 1992472 defendant Ayre Thomas merchant 588292 588292 Ayre, Thomas, of Colompton, merchant 0
3917906 1996351 1996351 defendant Burrowe Robert merchant 588292 588292 Burrowe, Robert, of Colompton, merchant 0
3918453 1996501 1996501 defendant Burrowe Robert yeoman 588292 588292 Burrowe, Robert, of Colompton, yeoman 0
3921781 1997630 1997630 defendant More John gent 588292 588292 More, John, of Colompton, gent 0
3923413 1998137 1998137 defendant Facy Henry butcher 588292 588292 Facy, Henry, of Colompton, butcher 0
3924260 1998422 1998422 defendant Sanford Bartholomew yeoman 588292 588292 Sanford, Bartholomew, of Colompton, yeoman 0
3924261 1998422 1998422 defendant Potham John yeoman 588292 588292 Potham, John, of Colompton, yeoman 1
3924262 1998422 1998422 defendant Potham Matilda spinster 588292 588292 Potham, Matilda, of Colompton, spinster 2
3924557 1998529 1998529 defendant Eyer Joan widow 588292 588292 Eyer, Joan, of Colompton, widow 0
3939280 2003443 2003443 defendant Welye John joiner 588292 588292 Welye, John, of Colompton, joiner 0
3952130 2007817 2007817 defendant Baxster John husbandman 588292 588292 Baxster, John, of Colompton, husbandman 0
3955659 2009053 2009053 plaintiff Menesye or Mevesey Thomas yeoman 588292 588292 Menesye or Mevesey, Thomas, of Colompton, yeoman 0
3955660 2009053 2009053 defendant Ball William yeoman 588292 588292 Ball, William, of Colompton, yeoman 0
3955661 2009054 2009054 plaintiff Menesye or Mevesey Thomas yeoman 588292 588292 Menesye or Mevesey, Thomas, of Colompton, yeoman 0
3955662 2009054 2009054 defendant Ball William yeoman 588292 588292 Ball, William, of Colompton, yeoman 0
3972140 2014816 2014816 defendant Lake George tucker 588292 588292 Lake, George, of Colompton, tucker 0
3972749 2015041 2015041 defendant Dawe John yeoman 588292 588292 Dawe, John, of Colompton, yeoman 0
3982412 2018482 2018482 defendant Maye Robert husbandman 588292 588292 Maye, Robert, of Colompton, husbandman 0
3985216 2019469 2019469 plaintiff Turnor Philip   588292 588292 Turnor, Philip, of Colompton 0
3989172 2020865 2020865 plaintiff Bagtor George   588292 588292 Bagtor, George, of Colompton 0
3989175 2020866 2020866 plaintiff Bagtor John   588292 588292 Bagtor, John, of Colompton 0
3992993 2022242 2022242 defendant Samford Bartholomew yeoman 588292 588292 Samford, Bartholomew, of Colompton, yeoman 9
4004986 2026565 2026565 plaintiff Kayleway Simon merchant 588292 588292 Kayleway, Simon, of Colompton, merchant 0
4007364 2027414 2027414 defendant Palmer Nicholas (legal representative) 588292 588292 Palmer, Nicholas, of Colompton, husbandman, executrix of 0
4007365 2027414 2027414 defendant Palmer Margery widow 588292 588292 Palmer, Margery, of Colompton, widow 1
4007370 2027416 2027416 defendant Palmer Nicholas (legal representative) 588292 588292 Palmer, Nicholas, of Colompton, husbandman, executrix of 0
4007371 2027416 2027416 defendant Palmer Margery widow 588292 588292 Palmer, Margery, of Colompton, widow 1
4008009 2027627 2027627 defendant Palmer Nicholas (legal representative) 588292 588292 Palmer, Nicholas, of Colompton, husbandman, executrix of 0
4008010 2027627 2027627 defendant Palmer Margery widow 588292 588292 Palmer, Margery, of Colompton, widow 1
4022695 2032839 2032839 plaintiff Atking Henry clothier 588292 588292 Atking, Henry, of Colompton, clothier 0
4022696 2032839 2032839 defendant Troke Henry merchant 588292 588292 Troke, Henry, of Colompton, merchant 0
4022897 2032915 2032915 plaintiff Bagtor John weaver 588292 588292 Bagtor, John, of Colompton, weaver 0
4026217 2034025 2034025 plaintiff Bury Thomas baker 588292 588292 Bury, Thomas, of Colompton, baker 0
4026219 2034026 2034026 plaintiff Bury Thomas baker 588292 588292 Bury, Thomas, of Colompton, baker 0
4031697 2036001 2036001 defendant Tye Edward gent 588292 588292 Tye, Edward, of Colompton, or of Longforde, Devon, gent 0
4032524 2036279 2036279 defendant Sampford Bartholomew gent 588292 588292 Sampford, Bartholomew, of Colompton, gent 0
4032570 2036298 2036298 defendant Sampford Bartholomew gent 588292 588292 Sampford, Bartholomew, of Colompton, gent 0
4038711 2038480 2038480 plaintiff Levermore John   588292 588292 Levermore, John, of Colompton 0
4038712 2038480 2038480 defendant Truslade William yeoman 588292 588292 Truslade, William, of Colompton, yeoman 0
4040050 2038941 2038941 defendant Cole John husbandman 588292 588292 Cole, John, of Colompton, husbandman 1
4040302 2039038 2039038 defendant Vyse Richard husbandman 588292 588292 Vyse, Richard, of Colompton, husbandman 0
4042155 2039680 2039680 plaintiff Page William (legal representative) 588292 588292 Page, William, of Colompton, gent, executors of 0
4042159 2039681 2039681 plaintiff Page William (legal representative) 588292 588292 Page, William, of Colompton, gent, executors of 0
4042162 2039681 2039681 defendant Slee John husbandman 588292 588292 Slee, John, of Colompton, husbandman 0
4046100 2041044 2041044 defendant Edgebastian Thomas (legal representative) 588292 588292 Edgebastian, Thomas, of Colompton, yeoman, executors of 0
4046101 2041044 2041044 defendant Edgebastian alias Parker Margaret spinster 588292 588292 (Edgebastian alias Parker, Margaret, of Colompton, spinster 1
4046102 2041044 2041044 defendant Edgebastian alias Crakland Thomas   588292 588292 Edgebastian alias Crakland, Thomas, of Colompton, groom 2
4046104 2041045 2041045 defendant Edgebastian Thomas (legal representative) 588292 588292 Edgebastian, Thomas, of Colompton, yeoman, executors of 0
4046105 2041045 2041045 defendant Edgebastian alias Parker Margaret spinster 588292 588292 (Edgebastian alias Parker, Margaret, of Colompton, spinster 1
4046106 2041045 2041045 defendant Edgebastian alias Crakland Thomas   588292 588292 Edgebastian alias Crakland, Thomas, of Colompton, groom 2
4047977 2041722 2041722 defendant Tybbes John fuller 588292 588292 Tybbes, John, of Colompton, fuller 0
4054405 2043964 2043964 defendant Hake Lawrence husbandman 588292 588292 Hake, Lawrence, of Colompton, husbandman 1
4080503 2053340 2053340 defendant Cole John yeoman 588292 588292 Cole, John, of Colompton, yeoman 0
4080504 2053340 2053340 defendant Edmond George yeoman 588292 588292 Edmond, George, of Colompton, yeoman 1
4080505 2053340 2053340 defendant Townsend William yeoman 588292 588292 Townsend, William, of Colompton, yeoman 2
4093936 2058156 2058156 defendant Swayne Robert merchant 588292 588292 Swayne, Robert, of Colompton, merchant 0
4108183 2063193 2063193 defendant Rockebacke Tobias yeoman 588292 588292 Rockebacke, Tobias, of Colompton, yeoman 2
4114997 2065653 2065653 plaintiff Tyllard Lawrence   588292 588292 Tyllard, Lawrence, of Colompton 0
4115003 2065655 2065655 plaintiff Tyllarde Lawrence   588292 588292 Tyllarde, Lawrence, of Colompton 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);