names

167 rows where place_id = 600182

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640099 1907349 1907349 defendant Tewe John husbandman 600182 600182 Tewe, John, of Dorston, husbandman 0
3656324 1912222 1912222 defendant Newport Thomas husbandman 600182 600182 Newport, Thomas, of Dorston, husbandman 1
3685635 1921663 1921663 defendant Water Lewis husbandman 600182 600182 Water, Lewis, of Dorston, husbandman 0
3685636 1921663 1921663 defendant Jamys John butcher 600182 600182 Jamys, John, of Dorston, butcher 1
3695196 1924719 1924719 defendant Partych William chaplain 600182 600182 Partych, William, of Dorston, chaplain 3
3700088 1926259 1926259 defendant Canell or Cavell William husbandman 600182 600182 Canell or Cavell, William, of Dorston, husbandman 1
3700619 1926441 1926441 defendant Partryche Robert husbandman 600182 600182 Partryche, Robert, of Dorston, husbandman 0
3700620 1926441 1926441 defendant Partriche Thomas chaplain 600182 600182 Partriche, Thomas, of Dorston, chaplain 1
3728650 1935197 1935197 defendant Taylor Jenn tailor 600182 600182 Taylor, Jenn, of Dorston, tailor 2
3729585 1935500 1935500 defendant Partryche Robert yeoman 600182 600182 Partryche, Robert, of Dorston, yeoman 0
3729586 1935500 1935500 defendant Partriche Thomas chaplain 600182 600182 Partriche, Thomas, of Dorston, chaplain 1
3744647 1940219 1940219 defendant Partriche Thomas clerk 600182 600182 Partriche, Thomas, of Dorston, clerk 0
3744648 1940219 1940219 defendant Partriche Robert husbandman 600182 600182 Partriche, Robert, of Dorston, husbandman, Boole, James, of Brompton, husbandman 1
3773842 1949531 1949531 defendant ap Howell William laborer 600182 600182 ap Howell, William, of Dorston, laborer 0
3773843 1949531 1949531 defendant Botcote Roger husbandman 600182 600182 Botcote, Roger, of Dorston, husbandman 1
3774995 1949915 1949915 defendant Partriche Robert yeoman 600182 600182 Partriche, Robert, of Dorston, yeoman 0
3774996 1949915 1949915 defendant Parteriche Thomas chaplain 600182 600182 Parteriche, Thomas, of Dorston, chaplain 1
3791532 1955191 1955191 defendant Partriche Robert yeoman 600182 600182 Partriche, Robert, of Dorston, yeoman 0
3791533 1955191 1955191 defendant Partriche Thomas clerk 600182 600182 Partriche, Thomas, of Dorston, clerk 1
3791534 1955191 1955191 defendant Lewes John husbandman 600182 600182 Lewes, John, of Dorston, husbandman 2
3830885 1967542 1967542 defendant Wynston Roger yeoman 600182 600182 Wynston, Roger, of Dorston, yeoman 0
3839973 1970430 1970430 defendant Botcotte Roger husbandman 600182 600182 Botcotte, Roger, of Dorston, husbandman 0
3870591 1980405 1980405 defendant Botkott Roger husbandman 600182 600182 Botkott, Roger, of Dorston, husbandman 1
3893582 1988078 1988078 defendant Partryche Thomas clerk 600182 600182 Partryche, Thomas, of Dorston, clerk 1
3893583 1988078 1988078 defendant Partryche Robert yeoman 600182 600182 Partryche, Robert, of Dorston, yeoman 2
3899142 1989920 1989920 defendant Partrygge Thomas, senior husbandman 600182 600182 Partrygge, Thomas, senior, of Dorston, husbandman 2
3899143 1989920 1989920 defendant Partrygge Thomas, junior husbandman 600182 600182 Partrygge, Thomas, junior, of Dorston, husbandman 3
3911523 1994171 1994171 defendant Botcote James husbandman 600182 600182 Botcote, James, of Dorston, husbandman 1
3932797 2001273 2001273 defendant Wyllyams John yeoman 600182 600182 Wyllyams, John, of Dorston, yeoman 0
3932798 2001273 2001273 defendant ap Rees Roger John husbandman 600182 600182 ap Rees, Roger John, of Dorston, husbandman 1
3932824 2001276 2001276 defendant ap Thomas Roger husbandman 600182 600182 ap Thomas, Roger, of Dorston, husbandman 18
3932828 2001276 2001276 defendant David Lewis husbandman 600182 600182 David, Lewis, of Dorston, husbandman 22
3932830 2001276 2001276 defendant ap Robert Partrige Thomas husbandman 600182 600182 ap Robert Partrige, Thomas, of Dorston, husbandman 24
3943498 2004843 2004843 defendant Hyggyn Howell ap Richard husbandman 600182 600182 Hyggyn, Howell ap Richard, of Dorston, husbandman 0
3943499 2004843 2004843 defendant Lloyd Henry weaver 600182 600182 Lloyd, Henry, of Dorston, weaver 1
3944699 2005244 2005244 defendant William Thomas husbandman 600182 600182 William, Thomas, of Dorston, husbandman 0
3950563 2007274 2007274 defendant Waters Thomas husbandman 600182 600182 Waters, Thomas, of Dorston, husbandman 12
3950581 2007275 2007275 defendant Waters Thomas David husbandman 600182 600182 Waters, Thomas David, of Dorston, husbandman 12
3964164 2012075 2012075 defendant Morgan Lewis William husbandman 600182 600182 Morgan, Lewis William, of Dorston, husbandman 0
3964165 2012075 2012075 defendant Apowell Watkin Thomas husbandman 600182 600182 together with Apowell, Watkin Thomas, of Dorston, husbandman 1
3964230 2012096 2012096 defendant Morgan Lewis William husbandman 600182 600182 Morgan, Lewis William, of Dorston, husbandman 0
3964231 2012096 2012096 defendant Apowell Watkin Thomas husbandman 600182 600182 together with Apowell, Watkin Thomas, of Dorston, husbandman 1
3977098 2016561 2016561 defendant Water Joan David widow 600182 600182 Water, Joan David, of Dorston, widow 0
3977099 2016561 2016561 defendant Water Thomas David husbandman 600182 600182 Water, Thomas David, of Dorston, husbandman 1
3977101 2016561 2016561 defendant Morgan Lewis William husbandman 600182 600182 Morgan, Lewis William, of Dorston, husbandman 3
3980054 2017628 2017628 defendant Water David husbandman 600182 600182 Water, David, of Dorston, husbandman 1
3988369 2020586 2020586 defendant Watkyn William husbandman 600182 600182 Watkyn, William, of Dorston, husbandman 0
3988370 2020586 2020586 defendant Waythe Watkin weaver 600182 600182 Waythe, Watkin, of Dorston, weaver 1
3999993 2024762 2024762 defendant ap Rosser Thomas husbandman 600182 600182 ap Rosser, Thomas, of Dorston, husbandman 0
4001059 2025154 2025154 defendant Myle Richard yeoman 600182 600182 Myle, Richard, of Dorston, husbandman, son of Miles David Gillam, of Dorston, yeoman 0
4003548 2026032 2026032 defendant Howell Katherine widow 600182 600182 Howell, Katherine, of Dorston, widow 0
4003552 2026034 2026034 defendant Howell John John husbandman 600182 600182 Howell, John John, of Dorston, husbandman 0
4003553 2026034 2026034 defendant Tyrrett John shoemaker 600182 600182 Tyrrett, John, of Dorston, shoemaker 1
4003554 2026034 2026034 defendant ap Rosser Jenkin butcher 600182 600182 ap Rosser, Jenkin, of Dorston, butcher 2
4017151 2030838 2030838 defendant Tayler John Thomas laborer 600182 600182 Tayler, John Thomas, of Dorston, laborer 0
4035124 2037240 2037240 plaintiff Hergest Roger yeoman 600182 600182 Hergest, Roger, of Dorston, yeoman 0
4035128 2037241 2037241 plaintiff Hergest Roger yeoman 600182 600182 Hergest, Roger, of Dorston, yeoman 0
4042488 2039783 2039783 defendant Gillam Gwenlliana widow 600182 600182 Gillam, Gwenlliana, of Dorston, widow 11
4042501 2039784 2039784 defendant Gillam Gwelliana widow 600182 600182 Gillam, Gwelliana, of Dorston, widow 11
4043591 2040169 2040169 defendant ap Rosser David yeoman 600182 600182 ap Rosser, David, of Dorston, yeoman 2
4043592 2040169 2040169 defendant ap John David yeoman 600182 600182 ap John, David, of Dorston, yeoman 3
4050459 2042592 2042592 defendant Rosser Jenkin yeoman 600182 600182 Rosser, Jenkin, of Dorston, yeoman 0
4065730 2048036 2048036 defendant Gough Robert John husbandman 600182 600182 together with Gough, Robert John, of Dorston, husbandman 1
4065731 2048036 2048036 defendant Jenkyn John husbandman 600182 600182 Jenkyn, John, of Dorston, husbandman 2
4065732 2048036 2048036 defendant ap John Robert husbandman 600182 600182 ap John, Robert, of Dorston, husbandman 3
4067027 2048504 2048504 defendant Water Thomas David husbandman 600182 600182 Water, Thomas David, of Dorston, husbandman 2
4072686 2050528 2050528 defendant verch Howell Katherine widow 600182 600182 verch Howell, Katherine, of Dorston, widow 6
4073762 2050906 2050906 defendant Bannor Thomas tucker 600182 600182 Bannor, Thomas, of Dorston, tucker 1
4080348 2053284 2053284 defendant Water Thomas David yeoman 600182 600182 Water, Thomas David, of Dorston, yeoman 0
4082844 2054165 2054165 defendant Water Thomas David gent 600182 600182 Water, Thomas David, of Dorston, gent 1
4082940 2054198 2054198 defendant Howell Watkin John yeoman 600182 600182 Howell, Watkin John, of Dorston, yeoman 0
4082941 2054198 2054198 defendant Taylor Watkin Thomas yeoman 600182 600182 Taylor, Watkin Thomas, of Dorston, yeoman 1
4082942 2054198 2054198 defendant Carver Howell John yeoman 600182 600182 Carver, Howell John, of Dorston, yeoman 2
4082943 2054198 2054198 defendant ap David John yeoman 600182 600182 ap David, John, of Dorston, yeoman 3
4084791 2054836 2054836 defendant Jones Robert yeoman 600182 600182 Jones, Robert, of Dorston, yeoman 1
4093852 2058124 2058124 defendant Jones Robert   600182 600182 Jones, Robert, of Dorston, yeoman, alias Robert ap Thomas, of Clyfford 1
4116141 2066066 2066066 defendant Water Thomas David yeoman 600182 600182 Water, Thomas David, of Dorston, yeoman 0
4116142 2066066 2066066 defendant Taylor Watkin Thomas yeoman 600182 600182 Taylor, Watkin Thomas, of Dorston, yeoman 1
4119576 2067290 2067290 defendant Gor Robert John husbandman 600182 600182 Gor, Robert John, of Dorston, husbandman 0
4119577 2067290 2067290 defendant Prosser Thomas husbandman 600182 600182 Prosser, Thomas, of Dorston, husbandman 1
4119587 2067294 2067294 defendant William John yeoman 600182 600182 William, John, of Dorston, yeoman 0
4119588 2067294 2067294 defendant Jenkyn Howell yeoman 600182 600182 Jenkyn, Howell, of Dorston, yeoman 1
4127003 2069949 2069949 defendant Walwyn George gent 600182 600182 Walwyn, George, of Dorston, gent 0
4127004 2069949 2069949 defendant Meycke John husbandman 600182 600182 Meycke, John, of Dorston, husbandman 1
4127005 2069949 2069949 defendant Bucher Thomas butcher 600182 600182 Bucher, Thomas, of Dorston, butcher 2
4127006 2069949 2069949 defendant Howell Watkin John husbandman 600182 600182 Howell, Watkin John, of Dorston, husbandman 3
4127007 2069949 2069949 defendant Gamyll Howell yeoman 600182 600182 Gamyll, Howell, of Dorston, yeoman 4
4138952 2074301 2074301 defendant Trenter Walter husbandman 600182 600182 Trenter, Walter, of Dorston, husbandman 1
4138953 2074301 2074301 defendant Lewys John husbandman 600182 600182 Lewys, John, of Dorston, husbandman 2
4138954 2074301 2074301 defendant Melynytche Jevan miller 600182 600182 Melynytche, Jevan, of Dorston, miller 3
4141081 2075040 2075040 defendant Mady Howell William yeoman 600182 600182 Mady, Howell William, of Dorston, yeoman 1
4142029 2075385 2075385 defendant Badcott Margaret widow 600182 600182 Badcott, Margaret, of Dorston, widow 2
4142529 2075556 2075556 defendant ap Richard John Thomas husbandman 600182 600182 ap Richard, John Thomas, of Dorston, husbandman 0
4143188 2075788 2075788 defendant Gamyll William yeoman 600182 600182 Gamyll, William, of Dorston, yeoman 0
4143189 2075788 2075788 defendant Hergest Roger gent 600182 600182 Hergest, Roger, of Dorston, gent 1
4143191 2075789 2075789 defendant Gannyll or Gamyll William yeoman 600182 600182 Gannyll or Gamyll, William, of Dorston, yeoman 0
4143192 2075789 2075789 defendant Hergest Roger gent 600182 600182 Hergest, Roger, of Dorston, gent 1
4147084 2077123 2077123 defendant ap Rosser David yeoman 600182 600182 ap Rosser, David, of Dorston, yeoman 0
4147085 2077123 2077123 defendant Watter Richard Thomas David yeoman 600182 600182 Watter, Richard Thomas David, of Dorston, yeoman, son of Thomas David Watter, of Dorston, yeoman 1
4153914 2079464 2079464 defendant William William John yeoman 600182 600182 William, William John, of Dorston, yeoman 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);