names

282 rows where place_id = 591089

✎ 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
3603298 1868705 1868705 defendant Carter Robert yeoman 591089 591089 Carter, Robert, of Malmesbury, yeoman 0
3603299 1868705 1868705 defendant Wassheborne John yeoman 591089 591089 Wassheborne, John, of Malmesbury, yeoman 1
3603300 1868705 1868705 defendant Rogers Stephen yeoman 591089 591089 Rogers, Stephen, of Malmesbury, yeoman 2
3608925 1870450 1870450 defendant Hille Robert chapman 591089 591089 Hille, Robert, of Malmesbury, chapman 1
3611080 1871141 1871141 defendant Fryce Alice widow 591089 591089 Fryce, Alice, of Malmesbury, widow 0
3615561 1872506 1872506 defendant Hill Robert yeoman 591089 591089 Hill, Robert, of Malmesbury, yeoman 1
3620315 1873934 1873934 defendant Mathewe John gent 591089 591089 Mathewe, John, of Malmesbury, gent 0
3622994 1874719 1874719 defendant Staffe Thomas yeoman 591089 591089 Staffe, Thomas, of Malmesbury, yeoman 0
3622995 1874719 1874719 defendant Webbe William chapman 591089 591089 Webbe, William, of Malmesbury, chapman 1
3647270 1909532 1909532 plaintiff Laurence William alderman 591089 591089 Laurence, William, of Malmesbury, alderman 0
3647274 1909533 1909533 plaintiff Laurence William alderman 591089 591089 Laurence, William, of Malmesbury, alderman 0
3651610 1910860 1910860 defendant Carter Robert husbandman 591089 591089 Carter, Robert, of Malmesbury, husbandman 2
3656213 1912190 1912190 plaintiff Camme Richard weaver 591089 591089 Camme, Richard, of Malmesbury, abbot of the Monastery of the Blessed Mary & St Aldelm, weaver 0
3656214 1912190 1912190 defendant Gytto Richard weaver 591089 591089 Gytto, Richard, of Malmesbury, weaver 0
3656215 1912191 1912191 plaintiff Camme Richard   591089 591089 Camme, Richard, of Malmesbury, abbot of the monastery of the Blessed Mary & St Aldhelm 0
3656216 1912191 1912191 defendant Gytte Richard weaver 591089 591089 Gytte, Richard, of Malmesbury, weaver 0
3670889 1916862 1916862 defendant Maleherbe John gent 591089 591089 Maleherbe, John, of Malmesbury, gent 0
3674889 1918176 1918176 defendant Benett Richard horner or butcher 591089 591089 Benett, Richard, of Malmesbury, horner or butcher 0
3677520 1919018 1919018 defendant Larder Robert gent 591089 591089 Larder, Robert, of Malmesbury, gent 0
3686979 1922094 1922094 defendant Laurence John gent 591089 591089 Laurence, John, of Malmesbury, gent 0
3693138 1924065 1924065 defendant Larder Robert gent 591089 591089 Larder, Robert, of Malmesbury, gent 0
3711185 1929803 1929803 defendant Cannor John tanner 591089 591089 Cannor, John, of Malmesbury, tanner 3
3714678 1930888 1930888 defendant Larder Robert gent 591089 591089 Larder, Robert, of Malmesbury, gent 0
3715286 1931069 1931069 defendant Pretty John tanner 591089 591089 Pretty, John, of Malmesbury, tanner 0
3715775 1931223 1931223 defendant Wethypoll Richard chaplain 591089 591089 Wethypoll, Richard, of Malmesbury, chaplain 0
3715776 1931223 1931223 defendant Pyrton John chaplain 591089 591089 Pyrton, John, of Malmesbury, chaplain 1
3744948 1940324 1940324 defendant Erle John husbandman 591089 591089 Erle, John, of Malmesbury, husbandman 1
3758789 1944738 1944738 defendant Barrowe William clerk 591089 591089 Barrowe, William, of Malmesbury, clerk 0
3775548 1950096 1950096 defendant Garesdon James cooper 591089 591089 Garesdon, James, of Malmesbury, cooper 0
3777186 1950617 1950617 defendant White Robert shoemaker 591089 591089 White, Robert, of Malmesbury, shoemaker 0
3784211 1952849 1952849 defendant Jonys Henry clothier 591089 591089 Jonys, Henry, of Malmesbury, clothier 0
3790393 1954813 1954813 defendant Gyttowe Richard weaver 591089 591089 Gyttowe, Richard, of Malmesbury, weaver 0
3800052 1957942 1957942 defendant Bolde William yeoman 591089 591089 Bolde, William, of Malmesbury, yeoman 0
3806628 1959973 1959973 defendant Gyttowe Richard weaver 591089 591089 Gyttowe, Richard, of Malmesbury, weaver 0
3808829 1960640 1960640 defendant Browne William husbandman 591089 591089 Browne, William, of Malmesbury, husbandman 1
3836194 1969233 1969233 defendant Stump William clothier 591089 591089 Stump, William, of Malmesbury, clothier 0
3853089 1974584 1974584 defendant Lawrence John gent 591089 591089 Lawrence, John, of Malmesbury, gent 0
3868290 1979635 1979635 defendant Awstyn Richard weaver 591089 591089 Awstyn, Richard, of Malmesbury, weaver 0
3895799 1988802 1988802 defendant Wyllyams Thomas husbandman 591089 591089 Wyllyams, Thomas, of Malmesbury, husbandman 0
3895800 1988802 1988802 defendant Myddelton John tanner 591089 591089 Myddelton, John, of Malmesbury, tanner 1
3896768 1989131 1989131 defendant Harrys Christopher weaver 591089 591089 Harrys, Christopher, of Malmesbury, weaver 1
3896770 1989131 1989131 defendant Raff Thomas shoemaker 591089 591089 Raff, Thomas, of Malmesbury, shoemaker 3
3901755 1990810 1990810 defendant Harrys Christopher weaver 591089 591089 Harrys, Christopher, of Malmesbury, weaver 1
3905933 1992268 1992268 defendant Forte Thomas   591089 591089 Forte, Thomas, of Malmesbury, yeoman, late bailiff of Kyngbrege hundred 2
3906661 1992520 1992520 defendant Selwyn William, junior yeoman 591089 591089 Selwyn, William, junior, of Malmesbury, yeoman 0
3914079 1995053 1995053 defendant Michell John weaver 591089 591089 Michell, John, of Malmesbury, weaver 0
3914080 1995053 1995053 defendant Spencer Grace widow 591089 591089 Spencer, Grace, of Malmesbury, widow 1
3914083 1995054 1995054 defendant Spencer Grace widow 591089 591089 Spencer, Grace, of Malmesbury, widow 1
3914481 1995184 1995184 plaintiff Canopp John (legal representative) 591089 591089 Canopp, John, of Malmesbury, tanner, executor of 0
3941512 2004171 2004171 defendant Longe John yeoman 591089 591089 Longe, John, of Malmesbury, yeoman 0
3955730 2009078 2009078 defendant Prety alias Underhyll John yeoman 591089 591089 Prety alias Underhyll, John, of Malmesbury, yeoman 1
3985299 2019499 2019499 defendant Stompe John gent 591089 591089 Stompe, John, of Malmesbury, gent 3
4005995 2026918 2026918 defendant Pytcher William yeoman 591089 591089 Pytcher, William, of Malmesbury, yeoman 1
4005996 2026918 2026918 defendant Pytcher Robert yeoman 591089 591089 Pytcher, Robert, of Malmesbury, yeoman 2
4140018 2074675 2074675 defendant Gwynn Davis innholder 591089 591089 Gwynn, Davis, of Malmesbury, innholder 0
4178087 2087805 2087805 defendant Gwynne David innholder 591089 591089 Gwynne, David, of Malmesbury, innholder 1
4178658 2088013 2088013 defendant Veysey John butcher 591089 591089 Veysey, John, of Malmesbury, butcher 0
4211865 2099699 2099699 defendant Gwynn David innholder 591089 591089 Gwynn, David, of Malmesbury, innholder 0
4233384 2107190 2107190 defendant Smythe Edward yeoman 591089 591089 Smythe, Edward, of Malmesbury, yeoman 0
4240237 2109707 2109707 defendant Staples Alexander (legal representative) 591089 591089 Staples, Alexander, of Malmesbury, gent, executrix of 0
4312290 2134435 2134435 defendant Abraham or Abram John yeoman 591089 591089 Abraham or Abram, John, of Malmesbury, yeoman 0
4316336 2135828 2135828 defendant Tashe Brian gent 591089 591089 Tashe, Brian, of Malmesbury, gent 0
4316337 2135828 2135828 defendant Reade Thomas gent 591089 591089 Reade, Thomas, of Malmesbury, or of Myntie, gent 1
4341212 2144197 2144197 defendant Hobbes Edmund clothier 591089 591089 Hobbes, Edmund, of Malmesbury, clothier 0
4341213 2144197 2144197 defendant Elkington Humphrey clothier 591089 591089 Elkington, Humphrey, of Malmesbury, clothier 1
4346215 2145929 2145929 defendant Elliatt John "haberdasher of hattes" 591089 591089 Elliatt, John, of Malmesbury, "haberdasher of hattes" 0
4349844 2147204 2147204 defendant Wase Effaell yeoman 591089 591089 Wase, Effaell, of Malmesbury, yeoman 0
4353321 2148386 2148386 defendant Roberts Margaret widow 591089 591089 Roberts, Margaret, of Malmesbury, widow 2
4373390 2155550 2155550 defendant Deane Henry shoemaker 591089 591089 Deane, Henry, of Malmesbury, shoemaker 1
4381730 2158568 2158568 defendant Staples Alexander (legal representative) 591089 591089 Staples, Alexander, of Malmesbury, gent, executrix of 0
4415378 2169705 2169705 plaintiff Hasard William   591089 591089 Hasard, William, of Malmesbury 0
4415380 2169706 2169706 plaintiff Hasard William   591089 591089 Hasard, William, of Malmesbury 0
4442992 2182770 2182770 plaintiff Camme William   591089 591089 Camme, William, of Malmesbury 0
4444843 2183360 2183360 plaintiff Cook John   591089 591089 Cook, John, of Malmesbury 0
4467214 2190418 2190418 defendant Pecok John   591089 591089 Pecok, John, of Malmesbury 1
4484028 2195697 2195697 defendant Leche John   591089 591089 Leche, John, of Malmesbury 0
4530045 2209687 2209687 plaintiff Neweman Robert   591089 591089 Neweman, Robert, of Malmesbury 0
4530072 2209693 2209693 defendant Frend Thomas   591089 591089 Frend, Thomas, of Malmesbury 4
4545417 2214489 2214489 defendant Bond Thomas   591089 591089 Bond, Thomas, of Malmesbury 0
4545538 2214527 2214527 defendant Frankeleyn Thomas   591089 591089 Frankeleyn, Thomas, of Malmesbury 0
4549098 2215654 2215654 defendant Hyway Thomas   591089 591089 Hyway, Thomas, of Malmesbury 0
4556672 2218019 2218019 defendant Gore John   591089 591089 Gore, John, of Malmesbury 1
4566651 2221142 2221142 defendant Morlegh John   591089 591089 Morlegh, John, of Malmesbury 0
4567306 2221330 2221330 plaintiff Tannere John   591089 591089 Tannere, John, of Malmesbury 0
4567308 2221331 2221331 plaintiff Tannere John   591089 591089 Tannere, John, of Malmesbury 0
4567310 2221332 2221332 plaintiff Tannere John   591089 591089 Tannere, John, of Malmesbury 0
4569709 2222110 2222110 defendant Nicol John   591089 591089 Nicol, John, of Malmesbury 1
4570556 2222364 2222364 defendant Gay Thomas   591089 591089 Gay, Thomas, of Malmesbury 0
4576997 2224314 2224314 defendant Hyweye Thomas   591089 591089 Hyweye, Thomas, of Malmesbury 0
4576999 2224315 2224315 defendant Hyweye Thomas   591089 591089 Hyweye, Thomas, of Malmesbury 0
4585236 2226806 2226806 plaintiff Gater John   591089 591089 Gater, John, of Malmesbury 2
4605376 2232832 2232832 defendant Heywey Thomas   591089 591089 Heywey, Thomas, of Malmesbury 0
4611482 2234654 2234654 defendant Danyell Richard   591089 591089 Danyell, Richard, of Malmesbury 0
4614221 2235460 2235460 defendant Gore John   591089 591089 Gore, John, of Malmesbury 0
4622801 2238109 2238109 defendant Bocher Richard   591089 591089 Bocher, Richard, of Malmesbury 0
4648177 2245530 2245530 defendant Colyn Geoffrey   591089 591089 Colyn, Geoffrey, of Malmesbury 0
4651490 2246470 2246470 defendant Hiweye Thomas husbandman 591089 591089 Hiweye, Thomas, of Malmesbury, husbandman 1
4651491 2246470 2246470 defendant Dalby John husbandman 591089 591089 Dalby, John, of Malmesbury, husbandman 2
4667195 2255472 2255472 defendant Henton John skinner 591089 591089 Henton, John, of Malmesbury, skinner 2
4669610 2256206 2256206 defendant Jones William chapman 591089 591089 Jones, William, of Malmesbury, chapman 0

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