names

154 rows where place_id = 586682

✎ 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
3589361 1864314 1864314 defendant Sharp Edmund yeoman 586682 586682 Sharp, Edmund, of Mylton, yeoman 0
3614140 1872088 1872088 defendant Rope William husbandman 586682 586682 Rope, William, of Mylton, husbandman 0
3625862 1902941 1902941 defendant Pope Mathew yeoman 586682 586682 Pope, Mathew, of Mylton, yeoman 3
3625930 1902966 1902966 defendant Maynerd Thomas yeoman 586682 586682 Maynerd, Thomas, of Mylton, yeoman 1
3649719 1910283 1910283 defendant Hankyn or Haukyn Nicholas husbandman 586682 586682 Hankyn or Haukyn, Nicholas, of Mylton, husbandman 2
3682236 1920542 1920542 defendant Cowper alias Mylyon Thomas husbandman or cooper 586682 586682 Cowper alias Mylyon, Thomas, of Mylton, husbandman or cooper 0
3682237 1920542 1920542 defendant Bedale John husbandman 586682 586682 Bedale, John, of Mylton, husbandman 1
3687566 1922285 1922285 defendant Burfeld Robert mariner 586682 586682 Burfeld, Robert, of Mylton, mariner 4
3705269 1927934 1927934 defendant Pope Robert husbandman 586682 586682 Pope, Robert, of Mylton, husbandman 2
3705413 1927978 1927978 defendant Clement Richard esq 586682 586682 Clement, Richard, of Mylton, esq 0
3705554 1928019 1928019 defendant Segburgh Richard yeoman 586682 586682 Segburgh, Richard, of Mylton, yeoman 0
3715997 1931287 1931287 defendant Browne William husbandman 586682 586682 Browne, William, of Mylton, husbandman 0
3716843 1931556 1931556 defendant Benet John husbandman 586682 586682 Benet, John, of Mylton, husbandman 0
3731649 1936126 1936126 defendant Maynerd John tanner 586682 586682 Maynerd, John, of Mylton, tanner 0
3739600 1938599 1938599 defendant Shawell Richard husbandman 586682 586682 Shawell, Richard, of Mylton under Whichewood, husbandman 0
3739601 1938599 1938599 defendant Hiet John husbandman 586682 586682 Hiet, John, of Mylton under Whichewood, husbandman 1
3752281 1942636 1942636 defendant Robyn Roger butcher 586682 586682 Robyn, Roger, of Mylton, butcher 0
3754803 1943460 1943460 plaintiff Tyler William   586682 586682 Tyler, William, of Mylton, senior 0
3762020 1945767 1945767 defendant Marshefeld John husbandman 586682 586682 Marshefeld, John, of Mylton, husbandman 1
3774568 1949771 1949771 defendant Hyll Thomas husbandman 586682 586682 Hyll, Thomas, of Mylton, husbandman 1
3774572 1949772 1949772 defendant Hyll Thomas husbandman 586682 586682 Hyll, Thomas, of Mylton, husbandman 1
3785477 1953247 1953247 defendant Baker Richard husbandman 586682 586682 Baker, Richard, of Mylton, husbandman 2
3789971 1954689 1954689 defendant Benett William yeoman 586682 586682 Benett, William, of Mylton, yeoman 0
3796352 1956723 1956723 defendant Wellys John husbandman 586682 586682 Wellys, John, of Mylton, husbandman 1
3801178 1958289 1958289 defendant Parker Oliver smith 586682 586682 Parker, Oliver, of Mylton, smith 0
3805868 1959775 1959775 defendant A Bery Thomas husbandman 586682 586682 A Bery, Thomas, of Mylton, husbandman 0
3812852 1961918 1961918 defendant Dychebourn John husbandman 586682 586682 Dychebourn, John, of Mylton, husbandman 0
3820505 1964296 1964296 defendant Robyns Richard husbandman 586682 586682 Robyns, Richard, of Mylton Abbot, husbandman 1
3843675 1971552 1971552 defendant Draper John husbandman 586682 586682 Draper, John, of Mylton, husbandman 1
3849949 1973571 1973571 defendant Dawby Sephen husbandman 586682 586682 Dawby, Sephen, of Mylton, husbandman 2
3859725 1976753 1976753 defendant Draper John husbandman 586682 586682 Draper, John, of Mylton, husbandman 1
3865306 1978606 1978606 defendant Cole Edmund husbandman 586682 586682 Cole, Edmund, of Mylton, husbandman 0
3866291 1978957 1978957 defendant Ledsam William butcher 586682 586682 Ledsam, William, of Mylton, butcher 0
3887505 1986075 1986075 defendant Grene John yeoman 586682 586682 Grene, John, of Mylton, yeoman 0
3891018 1987260 1987260 plaintiff Jones Edward yeoman 586682 586682 Jones, Edward, of Mylton, yeoman 0
3897153 1989265 1989265 defendant Pope Peter innholder 586682 586682 Pope, Peter, of Mylton, innholder 0
3909821 1993594 1993594 defendant Tylcok John husbandman 586682 586682 Tylcok, John, of Mylton, husbandman 1
3911924 1994312 1994312 defendant Wyngate John innholder 586682 586682 Wyngate, John, of Mylton, innholder 1
3922394 1997807 1997807 defendant Egerley Robert gent 586682 586682 Egerley, Robert, of Mylton, gent 0
3930107 2000416 2000416 defendant Howse Thomas husbandman 586682 586682 Howse, Thomas, of Mylton, husbandman 0
3956169 2009230 2009230 defendant Edwardes John laborer 586682 586682 Edwardes, John, of Mylton, laborer 0
3956170 2009230 2009230 defendant Bennett Nicholas innholder 586682 586682 Bennett, Nicholas, of Mylton, innholder 1
3957261 2009603 2009603 defendant Hyngston Richard husbandman 586682 586682 Hyngston, Richard, of Mylton, husbandman 6
3957262 2009603 2009603 defendant Hyngston John husbandman 586682 586682 Hyngston, John, of Mylton, husbandman 7
3957263 2009603 2009603 defendant Lovell Robert laborer 586682 586682 Lovell, Robert, of Mylton, laborer 8
3960885 2010905 2010905 defendant Hennage Christopher gent 586682 586682 Hennage, Christopher, of Mylton, gent 0
3976077 2016201 2016201 defendant Lake Richard tanner 586682 586682 Lake, Richard, of Mylton, tanner 0
3978338 2017007 2017007 defendant Clement alias Smyth John husbandman 586682 586682 Clement alias Smyth, John, of Mylton, husbandman 0
3987818 2020389 2020389 plaintiff Adlyngton Henry   586682 586682 Adlyngton, Henry, of Mylton 0
3996915 2023663 2023663 defendant Hall John gent 586682 586682 Hall, John, of Mylton, gent 0
4008036 2027638 2027638 defendant Tylsley Thomas yeoman 586682 586682 Tylsley, Thomas, of Mylton, yeoman 1
4036558 2037759 2037759 defendant ap Jevan William yeoman 586682 586682 ap Jevan, William, of Mylton, yeoman 0
4037213 2037972 2037972 defendant Assheberye Richard gent 586682 586682 Assheberye, Richard, of Mylton, gent 0
4038224 2038305 2038305 defendant Quyer Henry widow 586682 586682 Quyer, Henry, of Mylton, yeoman, servant to Dame Elizabeth Tregunwell, of Mylton, widow 1
4045445 2040821 2040821 defendant Wambewell John gent 586682 586682 Wambewell, John, of Mylton, gent 0
4049111 2042127 2042127 defendant Ashebury Richard gent 586682 586682 Ashebury, Richard, of Mylton, gent 0
4083309 2054314 2054314 defendant Marten Thomas gent 586682 586682 Marten, Thomas, of Mylton, gent 1
4100689 2060568 2060568 defendant Halle Walter glover 586682 586682 Halle, Walter, of Mylton, glover 0
4104192 2061773 2061773 defendant Berde Walter yeoman 586682 586682 Berde, Walter, of Mylton, yeoman 0
4104194 2061774 2061774 defendant Berde Walter yeoman 586682 586682 Berde, Walter, of Mylton, yeoman 0
4109850 2063782 2063782 defendant Rowe Henry yeoman 586682 586682 Rowe, Henry, of Mylton, yeoman 0
4109853 2063783 2063783 defendant Rowe Henry yeoman 586682 586682 Rowe, Henry, of Mylton, yeoman 0
4116645 2066247 2066247 defendant Tregonwell John esq 586682 586682 Tregonwell, John, of Mylton, esq 0
4122472 2068347 2068347 defendant Meade John butcher or victualer 586682 586682 Meade, John, of Mylton, butcher or victualer 0
4124643 2069110 2069110 defendant Heyward Nicholas tailor 586682 586682 Heyward, Nicholas, of Mylton, tailor 2
4124705 2069130 2069130 defendant Meade John yeoman 586682 586682 Meade, John, of Mylton, yeoman 0
4126399 2069731 2069731 defendant Mere Stephen husbandman 586682 586682 Mere, Stephen, of Mylton, husbandman 1
4126955 2069933 2069933 defendant Meade John butcher 586682 586682 Meade, John, of Mylton, butcher 0
4128755 2070580 2070580 defendant Sole Richard yeoman 586682 586682 Sole, Richard, of Mylton, yeoman 0
4133659 2072371 2072371 defendant Londman John husbandman 586682 586682 Londman, John, of Mylton, husbandman 0
4152677 2079048 2079048 defendant Meade John yeoman 586682 586682 Meade, John, of Mylton, yeoman 1
4156793 2080454 2080454 defendant Stoyte Henry tanner 586682 586682 Stoyte, Henry, of Mylton, tanner 0
4165923 2083580 2083580 defendant Spatchehurst Henry yeoman 586682 586682 Spatchehurst, Henry, of Mylton, yeoman 0
4166575 2083805 2083805 defendant Chammen William butcher 586682 586682 Chammen, William, of Mylton, butcher 0
4166576 2083805 2083805 defendant Pytman John yeoman 586682 586682 Pytman, John, of Mylton, yeoman 1
4167966 2084281 2084281 defendant Thursfyld William husbandman 586682 586682 Thursfyld, William, of Mylton, husbandman 0
4174233 2086444 2086444 defendant Tregonwell John esq 586682 586682 Tregonwell, John, of Mylton, esq 0
4179885 2088441 2088441 defendant Bank George husbandman 586682 586682 Bank, George, of Mylton, husbandman 0
4198166 2094904 2094904 defendant Morrys Edmund blacksmith 586682 586682 Morrys, Edmund, of Mylton, blacksmith 1
4199667 2095435 2095435 defendant Welsted Francis gent 586682 586682 Welsted, Francis, of Mylton, gent 1
4199668 2095435 2095435 defendant Welsted William gent 586682 586682 Welsted, William, of Mylton, gent 2
4203276 2096691 2096691 defendant Tregonwell John esq 586682 586682 Tregonwell, John, of Mylton, esq 0
4204655 2097176 2097176 defendant Tregonwell John esq 586682 586682 Tregonwell, John, of Mylton, esq 0
4206012 2097648 2097648 defendant Meade John yeoman 586682 586682 Meade, John, of Mylton, yeoman 0
4211160 2099460 2099460 defendant Whytwood John shoemaker 586682 586682 Whytwood, John, of Mylton, shoemaker 0
4211161 2099460 2099460 defendant Graye Nicholas yeoman 586682 586682 Graye, Nicholas, of Mylton, yeoman 1
4213762 2100329 2100329 defendant Gyll John yeoman 586682 586682 Gyll, John, of Mylton, yeoman 0
4216958 2101425 2101425 defendant Jones George yeoman 586682 586682 Jones, George, of Mylton, yeoman 1
4233119 2107091 2107091 defendant Stephens Freman tanner 586682 586682 Stephens, Freman, of Mylton, tanner 0
4234937 2107769 2107769 defendant Pennye Stephen yeoman 586682 586682 Pennye, Stephen, of Mylton, yeoman 2
4253433 2114139 2114139 defendant Payre John yeoman 586682 586682 Payre, John, of Mylton, yeoman 1
4285625 2124911 2124911 defendant Florence Edward gent 586682 586682 Florence, Edward, of Mylton, gent 0
4287233 2125492 2125492 defendant Shepparde Thomas cutler 586682 586682 Shepparde, Thomas, of Mylton, cutler 0
4288831 2126059 2126059 defendant Preston Anne esq 586682 586682 Preston, Anne, of Mylton, esq 0
4291591 2127071 2127071 defendant Berde Walter yeoman 586682 586682 Berde, Walter, of Mylton, yeoman 0
4291593 2127071 2127071 defendant Grey William victualer 586682 586682 Grey, William, of Mylton, victualer 2
4302238 2130898 2130898 defendant Godwyn William gent 586682 586682 Godwyn, William, of Mylton, gent 0
4302345 2130939 2130939 defendant Styckland John husbandman 586682 586682 Styckland, John, of Mylton, husbandman 0
4302403 2130961 2130961 defendant Lake John tanner 586682 586682 Lake, John, of Mylton, tanner 1
4304253 2131623 2131623 defendant Creke John husbandman 586682 586682 Creke, John, of Mylton, husbandman 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);