names

179 rows where place_id = 592662

✎ 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
3608441 1870300 1870300 defendant Fulburne John, senior yeoman 592662 592662 Fulburne, John, senior, of Letton, yeoman 0
3608442 1870300 1870300 defendant Beamond Richard husbandman 592662 592662 Beamond, Richard, of Letton, husbandman 1
3618109 1873287 1873287 defendant Frewen Richard husbandman 592662 592662 Frewen, Richard, of Letton, husbandman 0
3618110 1873287 1873287 defendant A Mere John husbandman 592662 592662 A Mere, John, of Letton, husbandman 1
3620659 1874040 1874040 defendant Stapulton Robert husbandman 592662 592662 Stapulton, Robert, of Letton, husbandman 3
3718581 1932088 1932088 defendant Sturges John gent 592662 592662 Sturges, John, of Letton, gent 0
3722461 1933285 1933285 defendant Hagthorp Richard husbandman 592662 592662 Hagthorp, Richard, of Letton, husbandman 0
3723763 1933708 1933708 defendant Grene Richard husbandman 592662 592662 Grene, Richard, of Letton, husbandman 3
3732633 1936437 1936437 defendant Hagthorp John chaplain 592662 592662 Hagthorp, John, of Letton, chaplain 0
3732635 1936438 1936438 defendant Hagthorp John chaplain 592662 592662 Hagthorp, John, of Letton, chaplain 0
3734887 1937151 1937151 defendant Haggethorp Richard yeoman 592662 592662 Haggethorp, Richard, of Letton, yeoman 1
3737790 1938040 1938040 defendant Foulbourn William husbandman 592662 592662 Foulbourn, William, of Letton, husbandman 0
3738229 1938171 1938171 defendant Hagthorp Richard husbandman 592662 592662 Hagthorp, Richard, of Letton, husbandman 0
3743610 1939878 1939878 defendant Creme George (legal representative) 592662 592662 Creme, George, of Letton, husbandman, executrix of 0
3743611 1939878 1939878 defendant Creme Alice widow 592662 592662 Creme, Alice, of Letton, widow 1
3764284 1946488 1946488 defendant Hagthorp John clerk 592662 592662 Hagthorp, John, of Letton, clerk 0
3771587 1948813 1948813 plaintiff Taylour John   592662 592662 Taylour, John, of Letton 0
3771589 1948813 1948813 defendant Beamond Thomas husbandman 592662 592662 Beamond, Thomas, of Letton, husbandman 0
3771590 1948813 1948813 defendant Hagthorp Richard husbandman 592662 592662 Hagthorp, Richard, of Letton, husbandman 1
3773404 1949391 1949391 defendant Agthorp Richard husbandman 592662 592662 Agthorp, Richard, of Letton, husbandman 0
3778259 1950911 1950911 plaintiff Creme Alice widow 592662 592662 Creme, Alice, of Letton, widow 0
3778261 1950911 1950911 defendant Gaunte John husbandman 592662 592662 Gaunte, John, of Letton, husbandman 1
3780204 1951534 1951534 defendant Tayllour John husbandman 592662 592662 Tayllour, John, of Letton, husbandman 0
3780205 1951534 1951534 defendant Beamond Thomas husbandman 592662 592662 Beamond, Thomas, of Letton, husbandman 1
3780206 1951534 1951534 defendant Gaunte John husbandman 592662 592662 Gaunte, John, of Letton, husbandman 2
3782259 1952205 1952205 defendant Haggethorpe John clerk 592662 592662 Haggethorpe, John, of Letton, clerk 0
3789191 1954433 1954433 defendant Hagthorpe Richard husbandman 592662 592662 Hagthorpe, Richard, of Letton, husbandman 0
3789296 1954471 1954471 defendant Bemonde Thomas husbandman 592662 592662 Bemonde, Thomas, of Letton, husbandman 0
3810228 1961093 1961093 defendant Hill Robert   592662 592662 Hill, Robert, of Letton 0
3819909 1964106 1964106 defendant Hendry Robert yeoman 592662 592662 Hendry, Robert, of Letton, yeoman 1
3826708 1966203 1966203 defendant Kyrwoode Thomas husbandman 592662 592662 Kyrwoode, Thomas, of Letton, husbandman 0
3832343 1968032 1968032 defendant Aythorp John clerk 592662 592662 Aythorp, John, of Letton, clerk 3
3834641 1968769 1968769 defendant Beamond Thomas husbandman 592662 592662 Beamond, Thomas, of Letton, husbandman 0
3834642 1968769 1968769 defendant Halle Hugh weaver 592662 592662 Halle, Hugh, of Letton, weaver 1
3834643 1968769 1968769 defendant Gawnce John husbandman 592662 592662 Gawnce, John, of Letton, husbandman 2
3841215 1970831 1970831 defendant Kerewood Thomas husbandman 592662 592662 Kerewood, Thomas, of Letton, husbandman 0
3844109 1971706 1971706 defendant Fulburn George   592662 592662 Fulburn, George, of Letton, worsted weaver 2
3846700 1972523 1972523 defendant Brampton William gent 592662 592662 Brampton, William, of Letton, gent 1
3847075 1972637 1972637 defendant Fulbourn George husbandman 592662 592662 Fulbourn, George, of Letton, husbandman 1
3847490 1972779 1972779 defendant Fulbourn George   592662 592662 Fulbourn, George, of Letton, worsted weaver 0
3851761 1974140 1974140 defendant Fulbourn George   592662 592662 Fulbourn, George, of Letton, worsted weaver 0
3857907 1976113 1976113 defendant Kerewood Thomas husbandman 592662 592662 Kerewood, Thomas, of Letton, husbandman 0
3861617 1977346 1977346 plaintiff Fulburn George   592662 592662 Fulburn, George, of Letton 0
3865647 1978730 1978730 defendant Beamond Thomas husbandman 592662 592662 Beamond, Thomas, of Letton, husbandman 0
3865648 1978730 1978730 defendant Hall Hugh weaver 592662 592662 Hall, Hugh, of Letton, weaver 1
3865649 1978730 1978730 defendant Gawnce John husbandman 592662 592662 Gawnce, John, of Letton, husbandman 2
3889832 1986839 1986839 defendant Lylwall Philip, senior yeoman 592662 592662 Lylwall, Philip, senior, of Letton, yeoman 0
3896159 1988918 1988918 defendant Hookys John husbandman 592662 592662 Hookys, John, of Letton, husbandman 5
3899882 1990174 1990174 plaintiff Brampton William esq 592662 592662 Brampton, William, of Letton, esq 0
3899885 1990175 1990175 defendant Smethe Robert yeoman 592662 592662 Smethe, Robert, of Letton, yeoman 0
3902853 1991188 1991188 defendant Brampton William, junior gent 592662 592662 Brampton, William, junior, of Letton, gent 0
3907159 1992685 1992685 defendant Brampton William esq 592662 592662 Brampton, William, of Letton, esq 0
3921446 1997516 1997516 defendant Melyn James husbandman 592662 592662 Melyn, James, of Letton, husbandman 0
3937277 2002801 2002801 defendant Brampton William esq 592662 592662 Brampton, William, of Letton, esq 0
3939553 2003531 2003531 defendant Hughes John butcher 592662 592662 Hughes, John, of Letton, butcher 0
3939554 2003531 2003531 defendant Hughes Richard butcher 592662 592662 Hughes, Richard, of Letton, butcher 1
3956955 2009499 2009499 defendant Parr Hugh clerk 592662 592662 Parr, Hugh, of Letton, clerk 3
3958627 2010090 2010090 defendant Skerse Robert husbandman 592662 592662 Skerse, Robert, of Letton, husbandman 0
3958629 2010091 2010091 defendant Brownne William husbandman 592662 592662 Brownne, William, of Letton, husbandman 0
3958631 2010092 2010092 defendant Levy Robert yeoman 592662 592662 Levy, Robert, of Letton, yeoman 0
3958633 2010093 2010093 defendant Ryngbell Stephen husbandman 592662 592662 Ryngbell, Stephen, of Letton, husbandman 0
3986158 2019821 2019821 defendant Kyrwood Walter yeoman 592662 592662 Kyrwood, Walter, of Letton, yeoman 0
3986159 2019821 2019821 defendant Harper David yeoman 592662 592662 Harper, David, of Letton, yeoman 1
3986160 2019821 2019821 defendant Knight William yeoman 592662 592662 Knight, William, of Letton, yeoman 2
3986161 2019821 2019821 defendant Pytt Hugh yeoman 592662 592662 Pytt, Hugh, of Letton, yeoman 3
3986162 2019821 2019821 defendant A More Jenkin yeoman 592662 592662 A More, Jenkin, of Letton, yeoman 4
4015042 2030075 2030075 defendant Ranson or Rauson Robert husbandman 592662 592662 Ranson or Rauson, Robert, of Letton, husbandman 3
4032440 2036252 2036252 defendant Brayne Hugh yeoman 592662 592662 Brayne, Hugh, of Letton, yeoman 16
4032460 2036253 2036253 defendant Brayne Hugh yeoman 592662 592662 Brayne, Hugh, of Letton, yeoman 18
4038978 2038561 2038561 defendant Ryngbell Stephen husbandman 592662 592662 Ryngbell, Stephen, of Letton, husbandman 1
4048716 2041984 2041984 defendant Ryngebell Stephen husbandman 592662 592662 Ryngebell, Stephen, of Letton, husbandman 0
4048724 2041988 2041988 defendant Ringebell Stephen husbandman 592662 592662 Ringebell, Stephen, of Letton, husbandman 0
4054134 2043865 2043865 defendant Hewes John yeoman 592662 592662 Hewes, John, of Letton, yeoman 2
4066953 2048478 2048478 defendant Mellyn James, junior husbandman 592662 592662 Mellyn, James, junior, of Letton, husbandman 0
4067873 2048820 2048820 defendant Kyrwood Walter yeoman 592662 592662 Kyrwood, Walter, of Letton, yeoman 0
4076684 2051944 2051944 defendant Rawson Robert yeoman 592662 592662 Rawson, Robert, of Letton, yeoman 10
4076685 2051944 2051944 defendant Davy Nicholas clerk 592662 592662 Davy, Nicholas, of Letton, clerk 11
4077136 2052105 2052105 defendant Danyell Roger glover 592662 592662 Danyell, Roger, of Letton, glover 0
4077143 2052108 2052108 defendant Danyell Roger glover 592662 592662 Danyell, Roger, of Letton, glover 1
4077918 2052405 2052405 plaintiff Stringham Hugh tailor 592662 592662 Stringham, Hugh, of Letton, tailor 0
4077920 2052406 2052406 plaintiff Stringham Hugh tailor 592662 592662 Stringham, Hugh, of Letton, tailor 0
4080675 2053400 2053400 defendant Ford Robert yeoman 592662 592662 Ford, Robert, of Letton, yeoman 1
4081310 2053626 2053626 defendant Holland Thomas husbandman 592662 592662 Holland, Thomas, of Letton, husbandman 0
4081311 2053626 2053626 defendant Holland Richard husbandman 592662 592662 Holland, Richard, of Letton, husbandman 1
4082399 2054013 2054013 defendant Forde Robert yeoman 592662 592662 Forde, Robert, of Letton, yeoman 1
4087292 2055746 2055746 defendant Drake Stephen yeoman 592662 592662 Drake, Stephen, of Letton, yeoman 0
4087591 2055856 2055856 defendant Barnes William   592662 592662 Barnes, William, of Letton, mason 1
4087592 2055856 2055856 defendant Barnes Robert laborer 592662 592662 Barnes, Robert, of Letton, laborer 2
4115462 2065817 2065817 defendant Garrard George tailor 592662 592662 Garrard, George, of Letton, tailor 2
4130051 2071054 2071054 defendant Kyrrowde Thomas husbandman 592662 592662 Kyrrowde, Thomas, of Letton, husbandman 0
4130052 2071054 2071054 defendant Kyrrowde Walter husbandman 592662 592662 Kyrrowde, Walter, of Letton, husbandman 1
4139578 2074517 2074517 defendant Thorpe William yeoman 592662 592662 Thorpe, William, of Letton, yeoman 1
4142344 2075499 2075499 defendant Wellyngton John yeoman 592662 592662 Wellyngton, John, of Letton, yeoman 0
4143896 2076029 2076029 defendant Bearnes Robert laborer 592662 592662 Bearnes, Robert, of Letton, laborer 2
4144510 2076241 2076241 defendant Lylwall John husbandman 592662 592662 Lylwall, John, of Letton, husbandman 2
4165421 2083409 2083409 defendant Love Robert husbandman 592662 592662 Love, Robert, of Letton, husbandman 0
4189129 2091689 2091689 defendant Leve Robert husbandman 592662 592662 together with Leve, Robert, of Letton, husbandman 1
4209389 2098837 2098837 defendant Taylor John husbandman 592662 592662 Taylor, John, of Letton, husbandman 2
4210861 2099357 2099357 defendant Tylle Anthony husbandman 592662 592662 Tylle, Anthony, of Letton, husbandman 1
4227935 2105254 2105254 defendant Sturges Francis (legal representative) 592662 592662 Sturges, Francis, of Letton, esq, executors of 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);