names

127 rows where place_id = 586833

✎ 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
3589761 1864437 1864437 defendant Badcok Thomas yeoman 586833 586833 Badcok, Thomas, of South Brent, yeoman 0
3589762 1864437 1864437 defendant Badcok John yeoman 586833 586833 Badcok, John, of South Brent, yeoman 1
3628871 1903905 1903905 defendant Godynche Thomas butcher 586833 586833 Godynche, Thomas, of South Brent, butcher 1
3628874 1903906 1903906 defendant Godynche Thomas butcher 586833 586833 Godynche, Thomas, of South Brent, butcher 1
3634117 1905468 1905468 defendant Tayllour Stephen tucker 586833 586833 Tayllour, Stephen, of South Brent, tucker 0
3636769 1906293 1906293 defendant Rede Thomas yeoman 586833 586833 Rede, Thomas, of South Brent, yeoman 1
3650248 1910449 1910449 defendant Gyllyng Nicholas husbandman 586833 586833 Gyllyng, Nicholas, of South Brent, husbandman 0
3658864 1913026 1913026 defendant Saunder William yeoman 586833 586833 Saunder, William, of South Brent, yeoman 0
3659815 1913324 1913324 defendant Saunders William yeoman 586833 586833 Saunders, William, of South Brent, yeoman 0
3675444 1918358 1918358 defendant Symons Walter butcher 586833 586833 Symons, Walter, of South Brent, butcher 0
3682092 1920509 1920509 defendant Symondys Walter butcher 586833 586833 Symondys, Walter, of South Brent, butcher 0
3690355 1923146 1923146 defendant Yeoland John, junior butcher 586833 586833 Yeoland, John, junior, of South Brent, butcher 0
3711815 1930010 1930010 defendant Symons William butcher 586833 586833 Symons, William, of South Brent, butcher 0
3711816 1930010 1930010 defendant Godynche Thomas butcher 586833 586833 Godynche, Thomas, of South Brent, butcher 1
3720104 1932564 1932564 defendant Thorne John husbandman 586833 586833 Thorne, John, of South Brent, husbandman 0
3722704 1933368 1933368 defendant Stydston Henry husbandman 586833 586833 Stydston, Henry, of South Brent, husbandman 2
3723951 1933772 1933772 defendant Mace Marion widow 586833 586833 Mace, Marion, of South Brent, widow 0
3738554 1938266 1938266 defendant Sytdston Henry husbandman 586833 586833 Sytdston, Henry, of South Brent, husbandman 2
3741465 1939198 1939198 defendant Adam Margaret widow 586833 586833 Adam, Margaret, of South Brent, widow 4
3787155 1953773 1953773 defendant Simon William husbandman 586833 586833 Simon, William, of South Brent, husbandman 0
3787156 1953773 1953773 defendant Yeoland Henry husbandman 586833 586833 Yeoland, Henry, of South Brent, husbandman 1
3788146 1954088 1954088 defendant Keser John thatcher 586833 586833 Keser, John, of South Brent, thatcher 0
3793238 1955745 1955745 defendant Dynghurst John gent 586833 586833 Dynghurst, John, of South Brent, gent 0
3808410 1960507 1960507 defendant Saunder William husbandman 586833 586833 Saunder, William, of South Brent, husbandman 0
3808411 1960507 1960507 defendant Tabbe John husbandman 586833 586833 Tabbe, John, of South Brent, husbandman 1
3808412 1960507 1960507 defendant Honwyll John husbandman 586833 586833 Honwyll, John, of South Brent, husbandman 2
3808413 1960507 1960507 defendant Wheke Peter husbandman 586833 586833 Wheke, Peter, of South Brent, husbandman 3
3808414 1960507 1960507 defendant Saunder John husbandman 586833 586833 Saunder, John, of South Brent, husbandman 4
3820805 1964398 1964398 defendant Simon William husbandman 586833 586833 Simon, William, of South Brent, husbandman 0
3820807 1964399 1964399 defendant Symon William husbandman 586833 586833 Symon, William, of South Brent, husbandman 0
3838270 1969886 1969886 defendant Dynhurst John yeoman 586833 586833 Dynhurst, John, of South Brent, yeoman 0
3858890 1976461 1976461 defendant Badcok Margery widow 586833 586833 Badcok, Margery, of South Brent, widow 0
3867999 1979530 1979530 defendant Bastard John husbandman 586833 586833 Bastard, John, of South Brent, husbandman 0
3878243 1982972 1982972 defendant Honywell John tucker 586833 586833 Honywell, John, of South Brent, tucker 0
3885846 1985522 1985522 defendant Foxford Robert tanner 586833 586833 Foxford, Robert, of South Brent, tanner 0
3889715 1986796 1986796 defendant Foxford Robert innholder 586833 586833 Foxford, Robert, of South Brent, innholder 0
3950231 2007167 2007167 defendant Veremouth John husbandman 586833 586833 Veremouth, John, of South Brent, husbandman 0
3953848 2008416 2008416 defendant Webbe John husbandman 586833 586833 Webbe, John, of South Brent, husbandman 0
3969152 2013819 2013819 plaintiff Colston Walter   586833 586833 Colston, Walter, of South Brent 1
3975271 2015920 2015920 defendant Lonscombe Paschall husbandman 586833 586833 Lonscombe, Paschall, of South Brent, husbandman 0
3986786 2020015 2020015 defendant Norracott Roger husbandman 586833 586833 Norracott, Roger, of South Brent, husbandman 0
3988841 2020755 2020755 defendant Mydlam Robert yeoman 586833 586833 Mydlam, Robert, of South Brent, yeoman 0
3988842 2020755 2020755 defendant Father William husbandman 586833 586833 Father, William, of South Brent, husbandman 1
3988844 2020756 2020756 defendant Mydlam or Mydlane Robert yeoman 586833 586833 Mydlam or Mydlane, Robert, of South Brent, yeoman 0
3988845 2020756 2020756 defendant Father William husbandman 586833 586833 Father, William, of South Brent, husbandman 1
4020577 2032087 2032087 defendant Harrys alias Mychell John tucker 586833 586833 Harrys alias Mychell, John, of South Brent, tucker 1
4026727 2034204 2034204 defendant Adams Thomas husbandman 586833 586833 Adams, Thomas, of South Brent, husbandman 0
4026729 2034205 2034205 defendant Bonnell Roger husbandman 586833 586833 Bonnell, Roger, of South Brent, husbandman 0
4029062 2035037 2035037 defendant Flete John yeoman 586833 586833 Flete, John, of South Brent, yeoman 2
4038094 2038266 2038266 defendant Foster William husbandman 586833 586833 Foster, William, of South Brent, husbandman 1
4038095 2038266 2038266 defendant Thorne Walter husbandman 586833 586833 Thorne, Walter, of South Brent, husbandman 2
4048164 2041780 2041780 defendant Nayler John husbandman 586833 586833 Nayler, John, of South Brent, husbandman 0
4054367 2043952 2043952 defendant Parson John   586833 586833 Parson, John, of South Brent, "sleamaker" or sleigh maker 1
4057974 2045231 2045231 defendant Syme Joan widow 586833 586833 Syme, Joan, of South Brent, widow 0
4085417 2055060 2055060 defendant Somersett John gent 586833 586833 Somersett, John, of South Brent, gent 2
4085711 2055160 2055160 defendant Nelne Richard husbandman or yeoman 586833 586833 Nelne, Richard, of South Brent, husbandman or yeoman 1
4090435 2056861 2056861 defendant Somerset John gent 586833 586833 Somerset, John, of South Brent, gent 0
4090436 2056861 2056861 defendant Mydnam Robert husbandman 586833 586833 Mydnam, Robert, of South Brent, husbandman 1
4125304 2069335 2069335 defendant Somersett John gent 586833 586833 Somersett, John, of South Brent, gent 0
4126930 2069925 2069925 defendant Elsworthie Adam yeoman 586833 586833 Elsworthie, Adam, of South Brent, yeoman 0
4150414 2078274 2078274 defendant Dyker William husbandman 586833 586833 Dyker, William, of South Brent, husbandman 1
4150523 2078316 2078316 defendant Elsworthy Adam yeoman 586833 586833 Elsworthy, Adam, of South Brent, yeoman 0
4190337 2092140 2092140 defendant Cooke William husbandman 586833 586833 Cooke, William, of South Brent, husbandman 1
4190338 2092140 2092140 defendant Elsworthie Adam husbandman 586833 586833 Elsworthie, Adam, of South Brent, husbandman 2
4198837 2095150 2095150 defendant Quycke Richard yeoman 586833 586833 Quycke, Richard, of South Brent, yeoman 0
4202749 2096506 2096506 defendant Pethybridge George husbandman 586833 586833 Pethybridge George, of South Brent, husbandman 0
4213847 2100363 2100363 defendant Maddicke John husbandman 586833 586833 Maddicke, John, of South Brent, husbandman 0
4286068 2125073 2125073 defendant Colles Humphrey husbandman 586833 586833 Colles, Humphrey, of South Brent, husbandman 0
4288138 2125808 2125808 defendant Rogers Thomas husbandman 586833 586833 Rogers, Thomas, of South Brent, husbandman 0
4288140 2125809 2125809 defendant Tutton Gilbert husbandman 586833 586833 Tutton, Gilbert, of South Brent, husbandman 0
4288142 2125810 2125810 defendant Tutton Gilbert husbandman 586833 586833 Tutton, Gilbert, of South Brent, husbandman 0
4301235 2130553 2130553 defendant Tutton Gilbert husbandman 586833 586833 Tutton, Gilbert, of South Brent, husbandman 0
4303502 2131353 2131353 defendant Buncker Anthony fuller 586833 586833 Buncker, Anthony, of South Brent, fuller 0
4306994 2132588 2132588 defendant Colles Humphrey butcher 586833 586833 Colles, Humphrey, of South Brent, butcher 0
4308023 2132952 2132952 defendant Dynghurste William yeoman 586833 586833 Dynghurste, William, of South Brent, yeoman 0
4308597 2133157 2133157 defendant Tutton Gilbert husbandman 586833 586833 Tutton, Gilbert, of South Brent, husbandman 0
4308598 2133157 2133157 defendant Rogers Thomas husbandman 586833 586833 Rogers, Thomas, of South Brent, husbandman 1
4308824 2133235 2133235 defendant Lane John fuller 586833 586833 Lane, John, of South Brent, fuller 0
4387834 2160566 2160566 defendant Goulde Richard husbandman 586833 586833 Goulde, Richard, of South Brent, husbandman 0
4387837 2160566 2160566 defendant Dando Ellen widow 586833 586833 Dando, Ellen, of South Brent, widow 3
4410166 2168002 2168002 defendant Tutton Gilbert husbandman 586833 586833 Tutton, Gilbert, of South Brent, husbandman 2
4459287 2187952 2187952 defendant Carpenter John   586833 586833 Carpenter, John, of South Brent 0
4470912 2191554 2191554 defendant Pedul Thomas   586833 586833 Pedul, Thomas, of South Brent, vicar 0
4531340 2210078 2210078 defendant Grove Robert   586833 586833 Grove, Robert, of South Brent 0
4559908 2219053 2219053 defendant Bolgon John   586833 586833 Bolgon, John, of South Brent 0
4707886 2267836 2267836 defendant Burton Thomas husbandman 586833 586833 Burton, Thomas, of South Brent, husbandman 2
4784352 2291106 2291106 defendant Maron William laborer 586833 586833 Maron, William, of South Brent, laborer 1
4825930 2304141 2304141 defendant Banewell John chapman 586833 586833 Banewell, John, of South Brent, chapman 1
4875852 2319412 2319412 defendant Maron William husbandman 586833 586833 Maron, William, of South Brent, husbandman 0
4890219 2323711 2323711 defendant Galyon John husbandman 586833 586833 Galyon, John, of South Brent, husbandman 0
4908782 2329297 2329297 defendant Lynyne John husbandman 586833 586833 Lynyne, John, of south Brent, husbandman 2
4997435 2356082 2356082 defendant Roggers Robert gent 586833 586833 Roggers, Robert, of South Brent, gent 0
5030184 2365697 2365697 defendant Seyntbarbe Thomas esq 586833 586833 Seyntbarbe, Thomas, of South Brent, esq 0
5038383 2368115 2368115 defendant Laffell John   586833 586833 Laffell, John, of South Brent 0
5042687 2369419 2369419 defendant Vele Walter tailor 586833 586833 Vele, Walter, of South Brent, tailor 2
5046116 2370466 2370466 defendant Northcote Richard husbandman 586833 586833 Northcote, Richard, of South Brent, husbandman 2
5054963 2373046 2373046 defendant Elwell William husbandman 586833 586833 Elwell, William, of South Brent, husbandman 1
5073995 2378709 2378709 defendant Laufull or Lanfull William husbandman 586833 586833 Laufull or Lanfull, William, of South Brent, husbandman 0
5083932 2381697 2381697 defendant Spurne John husbandman 586833 586833 Spurne, John, of South Brent, husbandman 1
5084659 2381927 2381927 defendant Taillour Richard laborer 586833 586833 Taillour, Richard, of South Brent, laborer 3

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