names

231 rows where place_id = 590062

✎ 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
3589830 1864460 1864460 defendant Chaunceler Alexander (legal representative) 590062 590062 Chaunceler, Alexander, of Glastonbury, merchant, executors of 1
3589834 1864461 1864461 defendant Chaunceler Alexander (legal representative) 590062 590062 Chaunceler, Alexander, of Glastonbury, merchant, executors of 1
3590488 1864670 1864670 defendant Aleyn John, senior (legal representative) 590062 590062 Aleyn, John, senior, of Glastonbury, mercer, executrix of 0
3594581 1865937 1865937 plaintiff Lancok Julia (legal representative) 590062 590062 Lancok, Julia, of Glastonbury, widow, executrix of Lancok, William, of Glastonbury, executor of 0
3599751 1867566 1867566 defendant James Henry glover 590062 590062 James, Henry, of Glastonbury, glover 0
3604531 1869082 1869082 defendant Wykeham Thomas   590062 590062 Wykeham, Thomas, of Glastonbury, franklin 0
3611969 1871403 1871403 defendant Morse Thomas yeoman 590062 590062 Morse, Thomas, of Glastonbury, yeoman 6
3646588 1909337 1909337 defendant Wyche Thomas clothier 590062 590062 Wyche, Thomas, of Glastonbury, clothier 0
3654196 1911573 1911573 defendant Bartlet William mercer 590062 590062 Bartlet, William, of Glastonbury, mercer 0
3654947 1911809 1911809 plaintiff Beere Richard   590062 590062 Beere, Richard, of Glastonbury, abbot of the monastery of St Mary 0
3673607 1917775 1917775 defendant Gorges William gent 590062 590062 Gorges, William, of Glastonbury, gent 0
3682524 1920637 1920637 defendant Gorges William gent 590062 590062 Gorges, William, of Glastonbury, gent 0
3686286 1921865 1921865 defendant Hochyn William husbandman 590062 590062 Hochyn, William, of Glastonbury, husbandman 0
3914998 1995369 1995369 defendant Crede William chaplain 590062 590062 Crede, William, of Glastonbury, chaplain 0
3920820 1997309 1997309 defendant Jentyll John smith 590062 590062 Jentyll, John, of Glastonbury, smith 2
3943330 2004786 2004786 defendant Mannyng John yeoman or gent 590062 590062 Mannyng, John, of Glastonbury, yeoman or gent 0
3948035 2006378 2006378 defendant Wylshyre Owen yeoman 590062 590062 Wylshyre, Owen, of Glastonbury, yeoman 0
3958722 2010125 2010125 defendant Acourte John butcher 590062 590062 Acourte, John, of Glastonbury, butcher 0
3961679 2011186 2011186 defendant Rode Thomas butcher 590062 590062 Rode, Thomas, of Glastonbury, butcher 0
3961680 2011186 2011186 defendant Courte John, junior butcher 590062 590062 Courte, John, junior, of Glastonbury, butcher 1
3968307 2013546 2013546 plaintiff Charnocke Thomas gent 590062 590062 Charnocke, Thomas, of Glastonbury, gent 0
3969435 2013916 2013916 defendant Hellacre William yeoman 590062 590062 Hellacre, William, of Glastonbury, yeoman 0
3975395 2015960 2015960 defendant Holleker William Soms, chapman 590062 590062 Holleker William, of Glastonbury, Soms, chapman 0
3976212 2016245 2016245 defendant Holmes Osmund yeoman 590062 590062 Holmes, Osmund, of Glastonbury, yeoman 0
3980844 2017911 2017911 defendant Whytehere Henry tanner 590062 590062 Whytehere, Henry, of Glastonbury, tanner 0
3986676 2019975 2019975 defendant Broderybbe John miller 590062 590062 Broderybbe, John, of Glastonbury, miller 0
3995356 2023081 2023081 defendant Holmes Simon yeoman 590062 590062 Holmes, Simon, of Glastonbury, yeoman 0
3995358 2023082 2023082 defendant Holmes Simon yeoman 590062 590062 Holmes, Simon, of Glastonbury, yeoman 0
3999751 2024669 2024669 defendant Westley William yeoman 590062 590062 Westley, William, of Glastonbury, yeoman 0
4001915 2025461 2025461 defendant Powell Nicholas clerk 590062 590062 Powell, Nicholas, of Glastonbury, or of Sutton, Soms, clerk 0
4009606 2028206 2028206 defendant Myller Thomas yeoman 590062 590062 Myller, Thomas, of Glastonbury, yeoman 3
4010879 2028667 2028667 defendant Coke Robert husbandman 590062 590062 Coke, Robert, of Glastonbury, husbandman 0
4010880 2028667 2028667 defendant Holmes Simon clothier 590062 590062 Holmes, Simon, of Glastonbury, clothier 1
4011167 2028762 2028762 defendant Golde Richard   590062 590062 Golde, Richard, of Glastonbury, yeoman, woollen draper 0
4011169 2028763 2028763 defendant Hillard John weaver 590062 590062 Hillard, John, of Glastonbury, weaver 0
4016239 2030507 2030507 defendant Brempton Thomas husbandman 590062 590062 Brempton, Thomas, of Glastonbury, husbandman 0
4016241 2030508 2030508 defendant Coxe William husbandman 590062 590062 Coxe, William, of Glastonbury, husbandman 0
4025410 2033745 2033745 defendant Bodye Nicholas tailor 590062 590062 Bodye, Nicholas, of Glastonbury, tailor 0
4031975 2036102 2036102 defendant Burge Hugh husbandman 590062 590062 Burge, Hugh, of Glastonbury, husbandman 0
4035667 2037435 2037435 plaintiff Holmes Osmund   590062 590062 Holmes, Osmund, of Glastonbury 0
4070107 2049598 2049598 defendant Brodrippe John miller 590062 590062 Brodrippe, John, of Glastonbury, miller 0
4083195 2054277 2054277 defendant Michell John yeoman 590062 590062 Michell, John, of Glastonbury, yeoman 1
4095160 2058595 2058595 defendant Goulle William carpenter 590062 590062 Goulle, William, of Glastonbury, carpenter 1
4096443 2059056 2059056 defendant Gould William yeoman 590062 590062 Gould, William, of Glastonbury, yeoman 0
4101821 2060962 2060962 defendant Parker John husbandman 590062 590062 Parker, John, of Glastonbury, husbandman 0
4110086 2063872 2063872 defendant Westley William yeoman 590062 590062 Westley, William, of Glastonbury, yeoman 0
4113480 2065098 2065098 defendant Allyn Thomas gent 590062 590062 Allyn, Thomas, of Glastonbury, gent 0
4123516 2068714 2068714 defendant Preston Edward gent 590062 590062 Preston, Edward, of Glastonbury, or of Crickette Thomas, gent 1
4125055 2069249 2069249 defendant Christover Thomas beer brewer 590062 590062 Christover, Thomas, of Glastonbury, beer brewer 0
4125057 2069250 2069250 defendant Clowtinge Robert yeoman 590062 590062 Clowtinge, Robert, of Glastonbury, yeoman 0
4125652 2069458 2069458 defendant Pole William husbandman 590062 590062 Pole, William, of Glastonbury, husbandman 2
4130703 2071291 2071291 defendant Goulde Richard vintner 590062 590062 Goulde, Richard, of Glastonbury, vintner 0
4131288 2071511 2071511 defendant Goulde William baker 590062 590062 Goulde, William, of Glastonbury, baker 0
4131289 2071511 2071511 defendant Gould Richard innholder 590062 590062 Gould, Richard, of Glastonbury, innholder 1
4131290 2071511 2071511 defendant Pulman Walter weaver 590062 590062 Pulman, Walter, of Glastonbury, weaver 2
4137363 2073713 2073713 defendant Thompson Robert yeoman 590062 590062 Thompson, Robert, of Glastonbury, yeoman 0
4138625 2074181 2074181 defendant Tompson Robert yeoman 590062 590062 Tompson, Robert, of Glastonbury, yeoman 0
4149051 2077789 2077789 defendant Gyll John husbandman 590062 590062 Gyll, John, of Glastonbury, or of Tyntenhull, husbandman 1
4149052 2077789 2077789 defendant Holmes Alexander husbandman 590062 590062 Holmes, Alexander, of Glastonbury, husbandman 2
4151837 2078755 2078755 defendant Warner William yeoman 590062 590062 Warner, William, of Glastonbury, yeoman 0
4154380 2079623 2079623 defendant Golde Richard vintner 590062 590062 Golde, Richard, of Glastonbury, vintner 0
4155047 2079857 2079857 defendant Goulde William baker 590062 590062 Goulde, William, of Glastonbury, baker 0
4155048 2079857 2079857 defendant Goulde Richard innholder 590062 590062 Goulde, Richard, of Glastonbury, innholder 1
4155049 2079857 2079857 defendant Pulman Walter weaver 590062 590062 Pulman, Walter, of Glastonbury, weaver 2
4155322 2079954 2079954 defendant Dawes John yeoman 590062 590062 Dawes, John, of Glastonbury, yeoman 1
4157795 2080799 2080799 defendant Hutchens Richard husbandman 590062 590062 Hutchens, Richard, of Glastonbury, husbandman 0
4161114 2081961 2081961 defendant Pestor Thomas yeoman 590062 590062 Pestor, Thomas, of Glastonbury, yeoman 3
4163909 2082904 2082904 defendant Ruddock John yeoman 590062 590062 Ruddock, John, of Glastonbury, yeoman 1
4163910 2082904 2082904 defendant Walton Tristram fletcher 590062 590062 Walton, Tristram, of Glastonbury, fletcher 2
4165381 2083398 2083398 defendant Powys George gent 590062 590062 Powys, George, of Glastonbury, gent 0
4174072 2086385 2086385 defendant Holmes Alexander husbandman 590062 590062 Holmes, Alexander, of Glastonbury, husbandman 0
4176868 2087377 2087377 defendant Dawes John yeoman 590062 590062 Dawes, John, of Glastonbury, yeoman 0
4194282 2093547 2093547 defendant Goold William yeoman 590062 590062 Goold, William, of Glastonbury, yeoman 0
4196480 2094312 2094312 defendant Hatche William yeoman 590062 590062 Hatche, William, of Glastonbury, yeoman 1
4196858 2094450 2094450 defendant Pester Thomas yeoman 590062 590062 Pester, Thomas, of Glastonbury, yeoman 0
4197273 2094599 2094599 defendant Carye Thomas yeoman 590062 590062 Carye, Thomas, of Glastonbury, yeoman 0
4197274 2094599 2094599 defendant Vayle John tanner 590062 590062 Vayle, John, of Glastonbury, tanner 1
4208412 2098490 2098490 defendant Chepman John joiner 590062 590062 Chepman, John, of Glastonbury, joiner 1
4210326 2099166 2099166 defendant Thompson Robert yeoman 590062 590062 Thompson, Robert, of Glastonbury, yeoman 0
4211505 2099581 2099581 defendant Hatche William   590062 590062 Hatche, William, of Glastonbury, linen draper 1
4243954 2110960 2110960 defendant Ford Thomas baker 590062 590062 Ford, Thomas, of Glastonbury, baker 0
4243955 2110960 2110960 defendant Dynham Robert yeoman 590062 590062 Dynham, Robert, of Glastonbury, yeoman 1
4243956 2110960 2110960 defendant Tompkyn Thomas yeoman 590062 590062 Tompkyn, Thomas, of Glastonbury, yeoman 2
4250381 2113109 2113109 defendant Ludwell John tucker 590062 590062 Ludwell, John, of Glastonbury, tucker 1
4276134 2121599 2121599 defendant Radcocke Thomas tailor 590062 590062 Radcocke, Thomas, of Glastonbury, tailor 1
4282472 2123771 2123771 defendant Weaver William weaver 590062 590062 Weaver, William, of Glastonbury, weaver 0
4283693 2124206 2124206 defendant Harvie Robert husbandman 590062 590062 Harvie, Robert, of Glastonbury, husbandman 0
4287934 2125731 2125731 defendant Allen Thomas husbandman 590062 590062 Allen, Thomas, of Glastonbury, husbandman 1
4290271 2126571 2126571 defendant Cocke William   590062 590062 Cocke, William, of Glastonbury, mason 2
4291243 2126937 2126937 defendant Weaver William weaver 590062 590062 Weaver, William, of Glastonbury, weaver 0
4291856 2127163 2127163 defendant Overton Nicholas yeoman 590062 590062 Overton, Nicholas, of Glastonbury, yeoman 0
4291857 2127163 2127163 defendant Overton John laborer 590062 590062 Overton, John, of Glastonbury, laborer 1
4291858 2127163 2127163 defendant Overton Thomas laborer 590062 590062 together with Overton, Thomas, of Glastonbury, laborer 2
4301035 2130474 2130474 defendant Hatch Henry yeoman 590062 590062 Hatch, Henry, of Glastonbury, yeoman 0
4301036 2130474 2130474 defendant Ewens Andrew husbandman 590062 590062 Ewens, Andrew, of Glastonbury, husbandman 1
4301828 2130762 2130762 defendant Markes William smith 590062 590062 Markes, William, of Glastonbury, smith 0
4302101 2130858 2130858 defendant Tompson George gent 590062 590062 Tompson, George, of Glastonbury, gent 0
4302102 2130858 2130858 defendant Kaynes William yeoman 590062 590062 Kaynes, William, of Glastonbury, yeoman 1
4308822 2133234 2133234 defendant Overston Nicholas yeoman 590062 590062 Overston, Nicholas, of Glastonbury, yeoman 0
4309172 2133363 2133363 defendant Croke Henry husbandman 590062 590062 Croke, Henry, of Glastonbury, husbandman 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);