names

96 rows where place_id = 590845

✎ 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
3602488 1868439 1868439 defendant Hotte Robert carpenter 590845 590845 Hotte, Robert, of Gunton, carpenter 2
3655144 1911870 1911870 defendant Mychell Robert yeoman 590845 590845 Mychell, Robert, of Gunton, yeoman 0
3695350 1924770 1924770 defendant Rake George husbandman 590845 590845 Rake, George, of Gunton, husbandman 0
3722743 1933380 1933380 plaintiff Myghell Robert   590845 590845 Myghell, Robert, of Gunton 0
3738624 1938290 1938290 plaintiff Myghellys Robert   590845 590845 Myghellys, Robert, of Gunton 0
3752772 1942792 1942792 defendant Michell Robert yeoman 590845 590845 Michell, Robert, of Gunton, yeoman 0
3752919 1942840 1942840 defendant Alger Henry   590845 590845 Alger, Henry, of Gunton, wheelwright 0
3777157 1950607 1950607 defendant Begot Nicholas   590845 590845 Begot, Nicholas, of Gunton, mason 1
3790244 1954764 1954764 defendant Boty John husbandman 590845 590845 Boty, John, of Gunton, husbandman 3
3803902 1959133 1959133 defendant Alger Henry   590845 590845 Alger, Henry, of Gunton, wheelwright 0
3815413 1962737 1962737 defendant Durraunt Simon husbandman 590845 590845 Durraunt, Simon, of Gunton, husbandman 2
3852299 1974319 1974319 defendant Myghell Christopher   590845 590845 Myghell, Christopher, of Gunton, worsted weaver 2
3852303 1974320 1974320 defendant Myghell Christopher   590845 590845 Myghell, Christopher, of Gunton, worsted weaver 1
3858108 1976191 1976191 plaintiff Berney Ralph esq 590845 590845 Berney, Ralph, of Gunton, esq 0
3864888 1978458 1978458 defendant Mykylhyll John   590845 590845 Mykylhyll, John, of Gunton, worsted weaver 0
3867050 1979219 1979219 defendant Alger Henry husbandman 590845 590845 Alger, Henry, of Gunton, husbandman 0
3867051 1979219 1979219 defendant Mykelyng Adam husbandman 590845 590845 Mykelyng, Adam, of Gunton, husbandman 1
3867052 1979219 1979219 defendant Pygott Nicholas   590845 590845 Pygott, Nicholas, of Gunton, mason 2
3867054 1979220 1979220 defendant Alger Henry husbandman 590845 590845 Alger, Henry, of Gunton, husbandman 0
3867055 1979220 1979220 defendant Mykelyng Adam husbandman 590845 590845 Mykelyng, Adam, of Gunton, husbandman 1
3867056 1979220 1979220 defendant Pygott Nicholas   590845 590845 Pygott, Nicholas, of Gunton, mason 2
3876656 1982437 1982437 defendant Michell John   590845 590845 Michell, John, of Gunton, worsted weaver 0
3884104 1984953 1984953 defendant Herward Gregory gent 590845 590845 Herward, Gregory, of Gunton, gent 0
3899818 1990151 1990151 defendant Bull Simon husbandman 590845 590845 Bull, Simon, of Gunton, husbandman 0
3900282 1990325 1990325 defendant Bowde Simon gent 590845 590845 Bowde, Simon, of Gunton, gent 0
3905182 1991997 1991997 defendant Boll Simon husbandman 590845 590845 Boll, Simon, of Gunton, husbandman 0
3949025 2006725 2006725 defendant Fenne John gent 590845 590845 Fenne, John, of Gunton, gent 0
3950302 2007191 2007191 defendant Pynchebek John husbandman 590845 590845 Pynchebek, John, of Gunton, husbandman 1
3958899 2010195 2010195 defendant Tyler Henry miller 590845 590845 Tyler, Henry, of Gunton, miller 0
3968197 2013502 2013502 defendant Person William miller 590845 590845 Person, William, of Gunton, miller 0
3969082 2013800 2013800 defendant Hendry Martin husbandman 590845 590845 Hendry, Martin, of Gunton, husbandman 3
3985244 2019479 2019479 defendant Barney Martin esq 590845 590845 Barney, Martin, of Gunton, esq 0
3992038 2021917 2021917 defendant Sarjaunte Robert husbandman 590845 590845 (Sarjaunte, Robert, of Gunton, husbandman 2
3992693 2022137 2022137 defendant Barnye Martin esq 590845 590845 Barnye, Martin, of Gunton, esq 0
4020823 2032174 2032174 defendant Grene Stephen gent 590845 590845 Grene, Stephen, of Gunton, yeoman, servant to Robert Thorpe, gent 0
4111769 2064459 2064459 defendant Delve John tailor 590845 590845 Delve, John, of Gunton, tailor 2
4126859 2069899 2069899 defendant Rogers John husbandman 590845 590845 Rogers, John, of Gunton, husbandman 0
4126860 2069899 2069899 defendant Allen William husbandman 590845 590845 Allen, William, of Gunton, husbandman 1
4130734 2071302 2071302 defendant Rogers John husbandman 590845 590845 Rogers, John, of Gunton, husbandman 0
4130735 2071302 2071302 defendant Allen William husbandman 590845 590845 Allen, William, of Gunton, husbandman 1
4135943 2073188 2073188 defendant Sowgate Rogwer miller 590845 590845 Sowgate, Rogwer, of Gunton, miller 1
4142957 2075708 2075708 defendant Sowgate Roger yeoman 590845 590845 Sowgate, Roger, of Gunton, yeoman 0
4142958 2075708 2075708 defendant Sowgate John singleman 590845 590845 Sowgate, John, of Gunton, yeoman, singleman 1
4142960 2075709 2075709 defendant Payne John yeoman 590845 590845 Payne, John, of Gunton, yeoman 0
4142962 2075710 2075710 defendant Payne John yeoman 590845 590845 Payne, John, of Gunton, yeoman 0
4142963 2075710 2075710 defendant Jueler William yeoman 590845 590845 Jueler, William, of Gunton, yeoman 1
4148262 2077523 2077523 defendant Pynchbeck Winifred spinster 590845 590845 Pynchbeck, Winifred, of Gunton, spinster 3
4148267 2077524 2077524 defendant Pynchebecke Winifred spinster 590845 590845 Pynchebecke, Winifred, of Gunton, spinster 3
4148269 2077525 2077525 defendant Denbye Edward   590845 590845 Denbye, Edward, of Gunton, millwright 0
4148270 2077525 2077525 defendant Denbye Elizabeth widow 590845 590845 Elizabeth his wife, alias Elizabeth Tanner, of Gunton, widow 1
4152047 2078827 2078827 defendant Vowell William clerk 590845 590845 Vowell, William, of Gunton, clerk 0
4184155 2089955 2089955 defendant Payne John husbandman 590845 590845 Payne, John, of Gunton, husbandman 0
4184156 2089955 2089955 defendant Temple Erasmus warrener 590845 590845 Temple, Erasmus, of Gunton, warrener 1
4195932 2094130 2094130 defendant Sterne Thomas gent 590845 590845 Sterne, Thomas, of Gunton, gent 3
4200321 2095666 2095666 defendant Barney Martin esq 590845 590845 Barney, Martin, of Gunton, esq 1
4264076 2117636 2117636 defendant Payne John   590845 590845 Payne, John, of Gunton yeoman 1
4324124 2138473 2138473 defendant Payne John husbandman 590845 590845 Payne, John, of Gunton, husbandman 3
4385194 2159737 2159737 defendant Suggate Christian widow 590845 590845 Suggate, Christian, of Gunton, widow 3
4437290 2176411 2176411 defendant Lyoun John le   590845 590845 Lyoun, John le, of Gunton 1
4586274 2227125 2227125 defendant Balle Robert   590845 590845 Balle, Robert, of Gunton 0
4609384 2234035 2234035 plaintiff Bryghtwald William miller 590845 590845 Bryghtwald, William, of Gunton, miller 0
4678061 2258748 2258748 defendant Balle Robert yeoman 590845 590845 Balle, Robert, of Gunton, yeoman 0
4683081 2260325 2260325 plaintiff Palgrave Robert   590845 590845 Palgrave, Robert, of Gunton 0
4683086 2260326 2260326 plaintiff Palgrave Robert   590845 590845 Palgrave, Robert, of Gunton 0
4692438 2263153 2263153 defendant Coye Robert baker 590845 590845 Coye, Robert, of Gunton, baker 0
4717478 2270802 2270802 defendant Haylle John   590845 590845 Haylle, John, of Gunton, parson 1
4782043 2290385 2290385 defendant Palgrave Robert gent 590845 590845 Palgrave, Robert, of Gunton, gent 0
4818766 2301957 2301957 plaintiff Palgrave Robert   590845 590845 Palgrave, Robert, of Gunton 0
4821559 2302825 2302825 defendant Palgrave Robert gent 590845 590845 Palgrave, Robert, of Gunton, gent 0
4825078 2303885 2303885 defendant Palgrave Robert gent 590845 590845 Palgrave, Robert, of Gunton, gent 3
4835545 2307107 2307107 defendant Ryder John husbandman 590845 590845 Ryder, John, of Gunton, husbandman 0
4835546 2307107 2307107 defendant Kene John husbandman 590845 590845 Kene, John, of Gunton, husbandman 1
4835891 2307208 2307208 defendant Sweyn Henry clerk 590845 590845 Sweyn, Henry, of Gunton, formerly of Wychyngham St Mary, clerk 0
4839462 2308266 2308266 defendant Stywardesson John husbandman 590845 590845 Stywardesson, John, of Gunton, husbandman 1
4840063 2308442 2308442 defendant Sweyn Henry clerk 590845 590845 Sweyn, Henry, of Gunton, clerk 2
4874482 2318963 2318963 defendant Balle Thomas yeoman 590845 590845 Balle, Thomas, of Gunton, yeoman 1
4906657 2328669 2328669 defendant Palgrave Robert (legal representative) 590845 590845 Palgrave, Robert, of Gunton, executrix of 0
4906658 2328669 2328669 defendant Palgrave Margaret widow 590845 590845 Palgrave, Margaret, of Gunton, widow 1
4937647 2338150 2338150 defendant Palgrave Margaret widow 590845 590845 Palgrave, Margaret, of Gunton, widow 1
4938420 2338396 2338396 defendant Spylman Robert husbandman 590845 590845 Spylman, Robert, of Gunton, husbandman 1
4963049 2345856 2345856 defendant Palgrave Margaret widow 590845 590845 Palgrave, Margaret, of Gunton, widow 1
4963051 2345857 2345857 defendant Palgrave Robert (legal representative) 590845 590845 Palgrave, Robert, of Gunton, executrix of 0
4964098 2346173 2346173 defendant Spylman Robert husbandman 590845 590845 Spylman, Robert, of Gunton, husbandman 0
4995381 2355460 2355460 defendant Kene John yeoman 590845 590845 Kene, John, of Gunton, yeoman 3
5037835 2367943 2367943 defendant Fuller William clerk 590845 590845 Fuller, William, of Gunton, clerk 2
5040584 2368791 2368791 defendant Palgrave Margaret   590845 590845 Palgrave, Margaret, of Gunton, widow, formerly wife of Testator 2
5094649 2384848 2384848 defendant Spire Robert husbandman 590845 590845 Spire, Robert, of Gunton, husbandman 0
5118099 2391726 2391726 defendant Hare John husbandman 590845 590845 Hare, John, of Gunton, husbandman 8
5299183 2444739 2444739 defendant Mendham John carpenter 590845 590845 Mendham, John, of Gunton, carpenter 0
5379301 2469117 2469117 defendant Lawes John butcher 590845 590845 Lawes, John, of Gunton, butcher 4
5448888 2489559 2489559 defendant Blomvyle Richard gent 590845 590845 (Blomvyle, Richard, of Gunton, gent 1
5461091 2493261 2493261 defendant Blomvyle Richard gent 590845 590845 together with Blomvyle, Richard, of Gunton, gent 2
5491990 2502512 2502512 defendant Wynne William yeoman 590845 590845 Wynne, William, of Gunton, yeoman 0
5508412 2507502 2507502 defendant Welles Thomas clerk 590845 590845 Welles, Thomas, of Gunton, clerk 0
5511877 2508570 2508570 defendant Pykeryng Robert (legal representative) 590845 590845 Pykeryng, Robert, of Gunton, husbandman, executors of 4
5579679 2528726 2528726 defendant Mychell Robert yeoman 590845 590845 Mychell, Robert, of Gunton, yeoman 1

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