names

355 rows where place_id = 588371

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594279 1865848 1865848 defendant Strogill John (legal representative) 588371 588371 Strogill, John, of Stone, husbandman, executors of 0
3594280 1865848 1865848 defendant Hochyn Thomas husbandman 588371 588371 (Hochyn, Thomas, of Stone, husbandman 1
3594281 1865848 1865848 defendant Alen Thomas husbandman 588371 588371 Alen, Thomas, of Stone, husbandman 2
3615588 1872514 1872514 defendant Dewe Thomas husbandman 588371 588371 Dewe, Thomas, of Stone, husbandman 2
3625456 1875500 1875500 plaintiff Wilsher John gent 588371 588371 Wilsher, John, of Stone, gent 0
3640658 1907519 1907519 plaintiff Atkyn Thomas   588371 588371 Atkyn, Thomas, of Stone 0
3640661 1907520 1907520 plaintiff Atkyn Thomas   588371 588371 Atkyn, Thomas, of Stone 0
3640664 1907521 1907521 plaintiff Atkyn Thomas   588371 588371 Atkyn, Thomas, of Stone 0
3640899 1907597 1907597 defendant Bayli John husbandman 588371 588371 Bayli, John, of Stone, husbandman 0
3642684 1908158 1908158 defendant Harecourte Thomas yeoman 588371 588371 Harecourte, Thomas, of Stone, yeoman 0
3642685 1908158 1908158 defendant Manley Richard yeoman 588371 588371 Manley, Richard, of Stone, yeoman 1
3642686 1908158 1908158 defendant Morgan Lewis yeoman 588371 588371 Morgan, Lewis, of Stone, yeoman 2
3642687 1908158 1908158 defendant Handerson John yeoman 588371 588371 Handerson, John, of Stone, yeoman 3
3642688 1908158 1908158 defendant Coke John yeoman 588371 588371 Coke, John, of Stone, yeoman 4
3642704 1908163 1908163 defendant Sydney John gent 588371 588371 Sydney, John, of Stone, gent 0
3660266 1913472 1913472 defendant Rogers John yeoman 588371 588371 Rogers, John, of Stone, yeoman 0
3662413 1914156 1914156 defendant Robyns Humphrey baker 588371 588371 Robyns, Humphrey, of Stone, baker 0
3673033 1917574 1917574 defendant Onean Richard glover 588371 588371 Onean, Richard, of Stone, glover 1
3673617 1917779 1917779 defendant Pratte Robert husbandman 588371 588371 Pratte, Robert, of Stone, husbandman 0
3673618 1917779 1917779 defendant Wode Thomas husbandman 588371 588371 Wode, Thomas, of Stone, husbandman 1
3676465 1918684 1918684 defendant Venour Thomas, junior husbandman 588371 588371 Venour, Thomas, junior, of Stone, husbandman 0
3677233 1918925 1918925 defendant Fowler Thomas   588371 588371 Fowler, Thomas, of Stone, shepherd 1
3685912 1921751 1921751 defendant Grey William husbandman 588371 588371 Grey, William, of Stone, husbandman 2
3693783 1924253 1924253 defendant Sargeaunt John esq 588371 588371 Sargeaunt, John, of Stone, esq 0
3714530 1930841 1930841 defendant Yong Thomas hatmaker 588371 588371 Yong, Thomas, of Stone, hatmaker 0
3720290 1932624 1932624 defendant Warkman Thomas laborer 588371 588371 Warkman, Thomas, of Stone, laborer 2
3720291 1932624 1932624 defendant Heylwode John laborer 588371 588371 Heylwode, John, of Stone, laborer 3
3725590 1934295 1934295 defendant Launder John yeoman 588371 588371 Launder, John, of Stone, yeoman 0
3738255 1938178 1938178 defendant Hawkyns James yeoman 588371 588371 Hawkyns, James, of Stone, yeoman 0
3747979 1941286 1941286 defendant Burwasshe Nicholas husbandman 588371 588371 Burwasshe, Nicholas, of Stone, husbandman 0
3751745 1942462 1942462 defendant Cheyny William gent 588371 588371 Cheyny, William, of Stone, gent 0
3761043 1945456 1945456 defendant Clyff Henry barker 588371 588371 Clyff, Henry, of Stone, barker 0
3762716 1945979 1945979 defendant Hormelore Roger yeoman 588371 588371 Hormelore, Roger, of Stone, yeoman 0
3762717 1945979 1945979 defendant (not given) John churchwardens of Dolyttyll 588371 588371 Dolyttyll, John, of Stone, yeoman, churchwardens of Stone 1
3767326 1947425 1947425 defendant Borwysshe Nicholas husbandman 588371 588371 Borwysshe, Nicholas, of Stone, husbandman 2
3771424 1948754 1948754 defendant Colier James draper 588371 588371 Colier, James, of Stone, draper 0
3792496 1955512 1955512 plaintiff Barker Fulk gent 588371 588371 Barker, Fulk, of Stone, gent 0
3796168 1956668 1956668 defendant Halys Thomas husbandman 588371 588371 Halys, Thomas, of Stone, husbandman 0
3808683 1960596 1960596 defendant Harrys Robert clerk 588371 588371 Harrys, Robert, of Stone, clerk 0
3812048 1961678 1961678 plaintiff Colyer James draper 588371 588371 Colyer, James, of Stone, draper 0
3833463 1968397 1968397 defendant Atkyns Robert yeoman 588371 588371 Atkyns, Robert, of Stone, yeoman 0
3850094 1973625 1973625 defendant Browne Agnes widow 588371 588371 Browne, Agnes, of Stone, widow 0
3850095 1973625 1973625 defendant Morse William husbandman 588371 588371 Morse, William, of Stone, husbandman 1
3851272 1973996 1973996 defendant Colyer James draper 588371 588371 Colyer, James, of Stone, draper 1
3851277 1973997 1973997 defendant Colyer James draper 588371 588371 Colyer, James, of Stone, draper 1
3871325 1980660 1980660 defendant Clyffe Henry barker 588371 588371 Clyffe, Henry, of Stone, barker 2
3878057 1982905 1982905 defendant Woddall John tailor 588371 588371 Woddall, John, of Stone, tailor 0
3891002 1987253 1987253 defendant Johnson Thomas hatmaker 588371 588371 Johnson, Thomas, of Stone, hatmaker 0
3891003 1987253 1987253 defendant Wagge Alexander hatmaker 588371 588371 Wagge, Alexander, of Stone, hatmaker 1
3894763 1988455 1988455 defendant Glover William shoemaker 588371 588371 Glover, William, of Stone, shoemaker 1
3901321 1990666 1990666 plaintiff Colyar Thurstan (legal representative) 588371 588371 Colyar, Thurstan, of Stone, yeoman, executors of 0
3901936 1990875 1990875 defendant Vanner Richard husbandman 588371 588371 Vanner, Richard, of Stone, husbandman 0
3913169 1994739 1994739 defendant Goughe Mathew weaver 588371 588371 Goughe, Mathew, of Stone, weaver 0
3916544 1995908 1995908 defendant Camp or Camper Lawrence laborer 588371 588371 Camp or Camper, Lawrence, of Stone, laborer 0
3916545 1995908 1995908 defendant Blakeman Richard laborer 588371 588371 Blakeman, Richard, of Stone, laborer 1
3922572 1997865 1997865 defendant Vennor Richard husbandman 588371 588371 Vennor, Richard, of Stone, husbandman 0
3941373 2004123 2004123 defendant Moyse Thomas weaver 588371 588371 Moyse, Thomas, of Stone, weaver 1
3947549 2006213 2006213 defendant Gyttynes Richard gent 588371 588371 Gyttynes, Richard, of Stone, gent 0
3949859 2007027 2007027 defendant Dymmoke James butcher 588371 588371 Dymmoke, James, of Stone, butcher 2
3951274 2007512 2007512 defendant Mayhoe Thomas clothier 588371 588371 Mayhoe, Thomas, of Stone, clothier 0
3965824 2012660 2012660 defendant Gyttens Richard yeoman 588371 588371 Gyttens, Richard, of Stone, yeoman 0
3968098 2013467 2013467 defendant Walkeden Sampson yeoman 588371 588371 Walkeden, Sampson, of Stone, yeoman 0
3968099 2013467 2013467 defendant Robynson Peter carpenter 588371 588371 Robynson, Peter, of Stone, carpenter 1
3969618 2013980 2013980 defendant Nicolson William chapman 588371 588371 Nicolson, William, of Stone, chapman 3
3969619 2013980 2013980 defendant Gurton Gregory yeoman 588371 588371 Gurton, Gregory, of Stone, yeoman 4
3978240 2016972 2016972 defendant Nicolson William innholder 588371 588371 Nicolson, William, of Stone, innholder 0
3978241 2016972 2016972 defendant Collyar George gent 588371 588371 together with Collyar, George, of Stone, gent 1
3982692 2018579 2018579 defendant Plont Thomas butcher 588371 588371 Plont, Thomas, of Stone, butcher 0
3983088 2018725 2018725 defendant Bennett Thomasine widow 588371 588371 Bennett, Thomasine, of Stone, widow 1
3983090 2018725 2018725 defendant Dymmock James butcher 588371 588371 Dymmock, James, of Stone, butcher 3
3983091 2018725 2018725 defendant Webbe William shoemaker 588371 588371 Webbe, William, of Stone, shoemaker 4
4007237 2027367 2027367 defendant Bentley Thomas tailor 588371 588371 Bentley, Thomas, of Stone, tailor 3
4008834 2027922 2027922 defendant Dymock James butcher 588371 588371 Dymock, James, of Stone, butcher 0
4011429 2028864 2028864 defendant Browne William, senior innholder 588371 588371 Browne, William, senior, of Stone, innholder 0
4011430 2028864 2028864 defendant Dymock James butcher 588371 588371 Dymock, James, of Stone, butcher 1
4014758 2029989 2029989 defendant Dymmock James butcher 588371 588371 Dymmock, James, of Stone, butcher 0
4014759 2029989 2029989 defendant Whyte William butcher 588371 588371 Whyte, William, of Stone, butcher 1
4016055 2030437 2030437 defendant Shelley Ralph tanner 588371 588371 Shelley, Ralph, of Stone, tanner 0
4016056 2030437 2030437 defendant Collyer George gent 588371 588371 Collyer, George, of Stone, gent 1
4016057 2030437 2030437 defendant Gorton Gregory innholder 588371 588371 Gorton, Gregory, of Stone, innholder 2
4016060 2030438 2030438 defendant Shelley Ralph tanner 588371 588371 Shelley, Ralph, of Stone, tanner 0
4016061 2030438 2030438 defendant Collyer George gent 588371 588371 Collyer, George, of Stone, gent 1
4016062 2030438 2030438 defendant Gorton Gregory innholder 588371 588371 Gorton, Gregory, of Stone, innholder 2
4018829 2031465 2031465 defendant Clyff Geoffrey tanner 588371 588371 Clyff, Geoffrey, of Stone, tanner 1
4018830 2031466 2031466 plaintiff Walkeden Robert (legal representative) 588371 588371 Walkeden, Robert, of Stone, shoemaker, executors of 0
4018835 2031466 2031466 defendant White William butcher 588371 588371 White, William, of Stone, butcher 1
4021484 2032410 2032410 defendant Vaughan James husbandman 588371 588371 Vaughan, James, of Stone, husbandman 0
4021749 2032504 2032504 defendant Pott John yeoman 588371 588371 Pott, John, of Stone, yeoman 0
4021750 2032504 2032504 defendant Byngham Richard shoemaker 588371 588371 Byngham, Richard, of Stone, shoemaker 1
4027124 2034348 2034348 defendant Collyar George gent 588371 588371 Collyar, George, of Stone, gent 0
4028040 2034680 2034680 defendant Pott John yeoman 588371 588371 Pott, John, of Stone, yeoman 0
4034073 2036845 2036845 defendant Pyper William yeoman 588371 588371 Pyper, William, of Stone, yeoman 1
4041860 2039571 2039571 defendant Sackvylde John gent 588371 588371 Sackvylde, John, of Stone, gent 0
4041861 2039571 2039571 defendant Pyper William yeoman 588371 588371 Pyper, William, of Stone, yeoman 1
4041862 2039571 2039571 defendant Carpenter Robert yeoman 588371 588371 Carpenter, Robert, of Stone, yeoman 2
4043302 2040072 2040072 defendant Fynney Robert yeoman or tailor 588371 588371 Fynney, Robert, of Stone, yeoman or tailor 1
4043303 2040072 2040072 defendant Browne William yeoman 588371 588371 Browne, William, of Stone, yeoman 2
4043304 2040072 2040072 defendant Hawkyn William chapman 588371 588371 Hawkyn, William, of Stone, chapman 3
4048792 2042015 2042015 defendant Dymmock James butcher 588371 588371 Dymmock, James, of Stone, butcher 0
4048793 2042015 2042015 defendant White William butcher 588371 588371 White, William, of Stone, butcher 1

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