names

476 rows where place_id = 593796

✎ 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
3613347 1871820 1871820 defendant Walshale Thomas innholder 593796 593796 Walshale, Thomas, of Salisbury, Wilts, innholder 0
3654351 1911622 1911622 defendant Bartylmew John mercer 593796 593796 Bartylmew, John, of Salisbury, Wilts, mercer 0
3654588 1911698 1911698 defendant Johns David   593796 593796 Johns, David, of Salisbury, Wilts, cloth maker 0
3657264 1912532 1912532 defendant Gawen Edmund gent 593796 593796 Gawen, Edmund, of Salisbury, Wilts, gent 0
3657708 1912661 1912661 defendant Gawyen Edmund gent 593796 593796 Gawyen, Edmund, of Salisbury, Wilts, gent 0
3657710 1912662 1912662 defendant Gawyen Edmund gent 593796 593796 Gawyen, Edmund, of Salisbury, Wilts, gent 0
3658700 1912974 1912974 defendant Crandon Thomas   593796 593796 Crandon, Thomas, of Salisbury, Wilts, gent & of St Cross, within Winchester, Hants 0
3661027 1913723 1913723 defendant Hope Richard   593796 593796 Hope, Richard, of Salisbury, Wilts, King's crown valet 0
3661029 1913724 1913724 defendant Hope Richard   593796 593796 Hope, Richard, of Salisbury, Wilts, King's Crown valet 0
3661035 1913726 1913726 defendant Hampton John gent 593796 593796 Hampton, John, of Salisbury, Wilts, gent 1
3661040 1913727 1913727 defendant Hampton John gent 593796 593796 Hampton, John, of Salisbury, Wilts, gent 1
3661974 1914037 1914037 defendant Crandon Thomas vintner 593796 593796 Crandon, Thomas, of Salisbury, Wilts, vintner 0
3665042 1915013 1915013 defendant Glys Roger   593796 593796 Glys, Roger, of Salisbury, Wilts, bell founder 0
3891928 1987553 1987553 defendant Sutton Henry innholder 593796 593796 Sutton, Henry, of Salisbury, Wilts, innholder 0
3892396 1987709 1987709 defendant Sutton Henry vintner 593796 593796 Sutton, Henry, of Salisbury, Wilts, vintner 0
3926461 1999181 1999181 defendant Woodshawe Thomas gent 593796 593796 Woodshawe, Thomas, of Salisbury, Wilts, gent 0
3926667 1999252 1999252 defendant Mounslowe Fulco clothier 593796 593796 Mounslowe, Fulco, of Salisbury, Wilts, clothier 0
3928830 1999979 1999979 defendant Fell Richard tailor 593796 593796 Fell, Richard, of Salisbury, Wilts, tailor 3
3929734 2000283 2000283 defendant Wythear Robert   593796 593796 Wythear, Robert, of Salisbury, Wilts, glover, son & heir of Nicholas Wythear, deceased 0
3932029 2001013 2001013 defendant Russell Christopher   593796 593796 Russell, Christopher, of Salisbury, Wilts, gold refiner 1
3932246 2001091 2001091 defendant Johns Robert gent & late petty captain under Captain Comas 593796 593796 Johns, Robert, of Salisbury, Wilts, gent & late petty captain under Captain Comas 1
3935292 2002115 2002115 defendant Fox Edmund gent 593796 593796 Fox, Edmund, of Salisbury, Wilts, gent 0
3935294 2002116 2002116 defendant Fox Edmund gent 593796 593796 Fox, Edmund, of Salisbury, Wilts, gent 0
3936040 2002374 2002374 defendant Parry Henry clerk 593796 593796 Parry, Henry, of Salisbury, Wilts, clerk 0
3936508 2002535 2002535 defendant Holwaye John, junior baker 593796 593796 Holwaye, John, junior, of Salisbury, Wilts, baker 0
3936650 2002585 2002585 plaintiff Maylyer James merchant 593796 593796 Maylyer, James, of Salisbury, Wilts, merchant 0
3936867 2002664 2002664 defendant Geydon John barber surgeon 593796 593796 Geydon, John, of Salisbury, Wilts, barber surgeon 0
3937786 2002969 2002969 defendant Parry Henry clerk & Chancellor of the Cathedral Church 593796 593796 Parry, Henry, of Salisbury, Wilts, clerk & Chancellor of the Cathedral Church 0
3938416 2003193 2003193 defendant Pern Robert yeoman 593796 593796 Pern, Robert, of Salisbury, Wilts, yeoman 0
3938421 2003194 2003194 defendant Peryn Robert yeoman 593796 593796 Peryn, Robert, of Salisbury, Wilts, yeoman 0
3938785 2003311 2003311 defendant Powyll John gent 593796 593796 Powyll, John, of Salisbury, Wilts, gent 0
3939513 2003519 2003519 defendant Webbe John merchant 593796 593796 Webbe, John, of Salisbury, Wilts, merchant 2
3941289 2004092 2004092 defendant Brown Edward gent 593796 593796 Brown, Edward, of Salisbury, Wilts, gent 1
3943019 2004674 2004674 defendant Elton Thomas chapman 593796 593796 Elton, Thomas, of Salisbury, Wilts, chapman 0
3974797 2015749 2015749 defendant Lynche John gent 593796 593796 Lynche, John, of Salisbury, Wilts, gent 0
4027668 2034545 2034545 defendant Ayer Christopher yeoman 593796 593796 Ayer, Christopher, of Salisbury, Wilts, yeoman 0
4077913 2052403 2052403 defendant Beckyngham Henry gent 593796 593796 Beckyngham, Henry, of Salisbury, Wilts, gent 1
4150177 2078196 2078196 defendant Ellyott Richard haberdasher 593796 593796 Ellyott, Richard, of Salisbury, Wilts, haberdasher 0
4254344 2114449 2114449 defendant Moore Richard yeoman 593796 593796 Moore, Richard, of Salisbury, Wilts, yeoman 0
4267781 2118857 2118857 defendant Bennett John clerk 593796 593796 Bennett, John, of Salisbury, Wilts, clerk 0
4337616 2142904 2142904 defendant ap Robert Richard skinner 593796 593796 ap Robert, Richard, of Salisbury, Wilts, skinner 0
4427330 2173383 2173383 plaintiff Russel Henry merchant 593796 593796 Russel, Henry, of Salisbury, Wilts, merchant 0
4547329 2215097 2215097 defendant Favent John   593796 593796 Favent, John, of Salisbury, Wilts 0
4547332 2215098 2215098 defendant Fovent John   593796 593796 Fovent, John, of Salisbury, Wilts 0
4547335 2215099 2215099 defendant Fovent John   593796 593796 Fovent, John, of Salisbury, Wilts 0
4668231 2255776 2255776 defendant Walker William haulier 593796 593796 Walker, William, of Salisbury, Wilts, haulier 1
4668372 2255819 2255819 defendant Goldepyn John woolmonger 593796 593796 Goldepyn, John, of Salisbury, Wilts, woolmonger 2
4673387 2257315 2257315 defendant Stodeley Thomas husbandman 593796 593796 Stodeley, Thomas, of Salisbury, Wilts, husbandman 2
4674467 2257624 2257624 defendant Filde Thomas merchant 593796 593796 Filde, Thomas, of Salisbury, Wilts, merchant 1
4676039 2258117 2258117 defendant Smyth William weaver 593796 593796 Smyth, William, of Salisbury, Wilts, weaver 1
4676881 2258387 2258387 defendant Bristowe aias Kyllyngworth William fisher 593796 593796 Bristowe aias Kyllyngworth, William, of Salisbury, Wilts, fisher 4
4678395 2258849 2258849 defendant Acastre Thomas   593796 593796 Acastre, Thomas, of Salisbury, Wilts, bow maker 2
4682197 2260053 2260053 defendant Mate John chapman 593796 593796 Mate, John, of Salisbury, Wilts, chapman 4
4682816 2260243 2260243 defendant Gryffyn John draper 593796 593796 (Gryffyn, John, of Salisbury, Wilts, draper 1
4683180 2260355 2260355 defendant Cornyssh John fuller 593796 593796 Cornyssh, John, of Salisbury, Wilts, fuller 3
4683376 2260401 2260401 defendant Dene John chaplain 593796 593796 Dene, John, of Salisbury, Wilts, chaplain 0
4686271 2261309 2261309 plaintiff Shirle Walter merchant 593796 593796 Shirle, Walter, of Salisbury, Wilts, merchant, on his own account 0
4686847 2261499 2261499 plaintiff Spencer John ostler 593796 593796 Spencer, John, of Salisbury, Wilts, ostler 0
4686860 2261502 2261502 defendant Cloterygge Stephen dyer 593796 593796 Cloterygge, Stephen, of Salisbury, Wilts, dyer 3
4687243 2261616 2261616 defendant Deye Placitus merchant 593796 593796 Deye, Placitus, of Salisbury, Wilts, merchant 1
4687533 2261691 2261691 defendant Lone or Love John   593796 593796 Lone or Love, John, of Salisbury, Wilts, leche 2
4687540 2261692 2261692 defendant Love John   593796 593796 Love, John, of Salisbury, Wilts, leach 2
4688504 2261968 2261968 defendant Notyngham Thomas taverner 593796 593796 Notyngham, Thomas, of Salisbury, Wilts, taverner 3
4692587 2263199 2263199 defendant Bray John fishmonger 593796 593796 Bray, John, of Salisbury, Wilts, fishmonger 0
4692784 2263255 2263255 defendant Bottenham John merchant 593796 593796 Bottenham, John, of Salisbury, Wilts, merchant 3
4694080 2263650 2263650 defendant Golpyn John   593796 593796 Golpyn, John, of Salisbury, Wilts, wool monger 0
4694092 2263653 2263653 defendant Golapyn John   593796 593796 Golapyn, John, of Salisbury, Wilts, wool monger 0
4694557 2263793 2263793 defendant Melbury Nicholas merchant 593796 593796 Melbury, Nicholas, of Salisbury, Wilts, merchant 0
4694561 2263794 2263794 defendant Melbury Nicholas merchant 593796 593796 Melbury, Nicholas, of Salisbury, Wilts, merchant 0
4694630 2263817 2263817 defendant Brystowe William fishmonger 593796 593796 Brystowe, William, of Salisbury, Wilts, fishmonger 0
4695733 2264147 2264147 defendant Croppe John skinner 593796 593796 Croppe, John, of Salisbury, Wilts, skinner 1
4696089 2264259 2264259 defendant russe John yeoman 593796 593796 russe, John, of Salisbury, Wilts, yeoman 1
4696091 2264259 2264259 defendant Balle Thomas barber 593796 593796 Balle, Thomas, of Salisbury, Wilts, barber 3
4696239 2264308 2264308 defendant Perquyn John dyer 593796 593796 Perquyn, John, of Salisbury, Wilts, dyer 0
4696876 2264503 2264503 defendant Pakyn William yeoman 593796 593796 Pakyn, William, of Salisbury, Wilts, yeoman 0
4696878 2264504 2264504 defendant Palyn William yeoman 593796 593796 Palyn, William, of Salisbury, Wilts, yeoman 0
4697549 2264722 2264722 defendant Alisaundre William gent 593796 593796 (Alisaundre, William, of Salisbury, Wilts, gent 3
4697915 2264839 2264839 defendant Mason Thomas merchant 593796 593796 Mason, Thomas, of Salisbury, Wilts, merchant 1
4697919 2264840 2264840 defendant Castelton Thomas merchant 593796 593796 Castelton, Thomas, of Salisbury, Wilts, merchant 0
4698034 2264873 2264873 defendant Pydes Thomas   593796 593796 Pydes, Thomas, of Salisbury, Wilts, shoe maker 3
4698711 2265078 2265078 defendant Prangnayll William dubber 593796 593796 Prangnayll, William, of Salisbury, Wilts, dubber 1
4699266 2265236 2265236 defendant Vicaries John yeoman 593796 593796 Vicaries, John, of Salisbury, Wilts, yeoman 0
4700745 2265633 2265633 defendant Coke William merchant 593796 593796 Coke, William, of Salisbury, Wilts, merchant 1
4700908 2265687 2265687 defendant Bettenam John mercer 593796 593796 Bettenam, John, of Salisbury, Wilts, mercer 0
4700910 2265688 2265688 defendant Bottenam John husbandman 593796 593796 Bottenam, John, of Salisbury, Wilts, husbandman 0
4703729 2266545 2266545 defendant Puddyng John taverner 593796 593796 Puddyng, John, of Salisbury, Wilts, taverner 1
4706898 2267538 2267538 defendant Mille Richard towker or fuller of cloth 593796 593796 Mille, Richard, of Salisbury, Wilts, towker or fuller of cloth 1
4706903 2267539 2267539 defendant Mille Richard towker or fuller of cloth 593796 593796 Mille, Richard, of Salisbury, Wilts, towker or fuller of cloth 1
4708622 2268071 2268071 defendant Gryffyn John draper 593796 593796 Gryffyn, John, of Salisbury, Wilts, draper 1
4708644 2268079 2268079 defendant Glasier John chandler 593796 593796 Glasier, John, of Salisbury, Wilts, chandler 0
4708648 2268081 2268081 defendant Glasyer John chandler 593796 593796 Glasyer, John, of Salisbury, Wilts, chandler 0
4708650 2268082 2268082 defendant Barbour Peter   593796 593796 Barbour, Peter, of Salisbury, Wilts, brass worker 0
4711059 2268811 2268811 defendant Clerk John taverner 593796 593796 Clerk, John, of Salisbury, Wilts, taverner 2
4712168 2269116 2269116 defendant Caundell John carrier 593796 593796 Caundell, John, of Salisbury, Wilts, carrier 1
4713658 2269595 2269595 defendant Snayth Nicholas tailor 593796 593796 Snayth, Nicholas, of Salisbury, Wilts, tailor 0
4713660 2269596 2269596 defendant Snayth Nicholas tailor 593796 593796 Snayth, Nicholas, of Salisbury, Wilts, tailor 0
4714069 2269729 2269729 defendant Pedwell John clerk 593796 593796 Pedwell, John, of Salisbury, Wilts, clerk 0
4715974 2270309 2270309 defendant Parqwyn John dyer 593796 593796 Parqwyn, John, of Salisbury, Wilts, dyer 1
4717437 2270790 2270790 defendant Wylly William dyer 593796 593796 Wylly, William, of Salisbury, Wilts, dyer 0
4718670 2271178 2271178 defendant Belgrave Peter mercer 593796 593796 Belgrave, Peter, of Salisbury, Wilts, mercer 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);