names

91 rows where place_id = 676568

✎ 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
4023259 2033026 2033026 plaintiff Barker Thomas tailor 676568 676568 Barker, Thomas, of Wiltshire, tailor 0
4039897 2038891 2038891 defendant Fookes Thomas (legal representative) 676568 676568 Fookes, Thomas, of Wiltshire, gent, executors of 0
4099747 2060232 2060232 defendant Berbewood Thomas gent 676568 676568 Berbewood, Thomas, of Wiltshire, gent 1
4137483 2073754 2073754 defendant Hall Thomas gent 676568 676568 Hall, Thomas, of Wiltshire, gent 0
4341916 2144451 2144451 defendant Sadler Henry esq 676568 676568 Sadler, Henry, of Wiltshire, esq 0
4355975 2149307 2149307 defendant Thynne Henry esq 676568 676568 Thynne, Henry, of Wiltshire, esq 1
4413053 2168954 2168954 plaintiff atte Borwe Walter   676568 676568 atte Borwe, Walter, of Wiltshire 0
4413054 2168954 2168954 defendant Ryvers Richard de merchant 676568 676568 Ryvers, Richard de, of Wiltshire, merchant 0
4422688 2171952 2171952 plaintiff Farendon Robert de merchant 676568 676568 Farendon, Robert de, of Wiltshire, merchant 0
4427332 2173384 2173384 plaintiff Russel Henry merchant 676568 676568 Russel, Henry, of Wiltshire, merchant 0
4427333 2173384 2173384 plaintiff Farendon Robert de merchant 676568 676568 Farendon, Robert de, of Wiltshire, merchant 1
4430821 2174398 2174398 plaintiff atte Gorwe Walter merchant 676568 676568 atte Gorwe, Walter, of Wiltshire, merchant 0
4430822 2174398 2174398 defendant Ryvers Richard de merchant 676568 676568 Ryvers, Richard de, of Wiltshire, merchant 0
4442787 2182700 2182700 defendant Heyte Walter   676568 676568 Heyte, Walter, of Wiltshire 0
4443675 2182989 2182989 defendant Wytteney Thomas   676568 676568 Wytteney, Thomas, of Wiltshire 1
4444910 2183380 2183380 defendant Lancastre John   676568 676568 Lancastre, John, of Wiltshire, shield bearer 0
4444913 2183381 2183381 defendant Lancastre Roger   676568 676568 Lancastre, Roger, of Wiltshire, 0
4448288 2184384 2184384 defendant Gowyn John   676568 676568 Gowyn, John, of Wiltshire 0
4448309 2184393 2184393 defendant Raundes John   676568 676568 Raundes, John, of Wiltshire 0
4451130 2185320 2185320 defendant Lone or Love John   676568 676568 Lone or Love, John, of Wiltshire 2
4452869 2185908 2185908 defendant Wake Thomas   676568 676568 Wake, Thomas, of Wiltshire, knight 4
4480507 2194566 2194566 defendant Auncell William   676568 676568 Auncell, William, of Wiltshire 0
4498884 2200286 2200286 defendant Priour Richard   676568 676568 Priour, Richard, of Wiltshire 1
4499657 2200530 2200530 defendant Bolde John   676568 676568 Bolde, John, of Wiltshire 3
4502444 2201345 2201345 defendant Pille John   676568 676568 Pille, John, of Wiltshire 0
4512530 2204359 2204359 defendant Cobbam John esq 676568 676568 Cobbam, John, of Wiltshire, esq 2
4512714 2204410 2204410 defendant Mounford Thomas   676568 676568 Mounford, Thomas, of Wiltshire 0
4519143 2206339 2206339 defendant Male John   676568 676568 Male, John, of Wiltshire 0
4519551 2206475 2206475 defendant Cauntelowe John   676568 676568 Cauntelowe, John, of Wiltshire 0
4538983 2212459 2212459 defendant Mounford Thomas   676568 676568 Mounford, Thomas, of Wiltshire 0
4541603 2213268 2213268 defendant Cauntelo John   676568 676568 Cauntelo, John, of Wiltshire 2
4544609 2214228 2214228 defendant Russell Thomas esq 676568 676568 Russell, Thomas, of Wiltshire, esq 0
4551644 2216459 2216459 defendant Blount John   676568 676568 Blount, John, of Wiltshire, knight 0
4551835 2216520 2216520 defendant Giffard Walter   676568 676568 Giffard, Walter, of Wiltshire 2
4552406 2216706 2216706 defendant Tourhand Hugh   676568 676568 Tourhand, Hugh, of Wiltshire 0
4561800 2219625 2219625 defendant Cleve John   676568 676568 Cleve, John, of Wiltshire 0
4562964 2219987 2219987 defendant Hereward John   676568 676568 Hereward, John, of Wiltshire 0
4569722 2222114 2222114 defendant Yevelton Robert   676568 676568 Yevelton, Robert, of Wiltshire, knight 1
4569819 2222133 2222133 defendant Yevelton Robert   676568 676568 Yevelton, Robert, of Wiltshire, knight 1
4571899 2222788 2222788 defendant Rasyn John   676568 676568 Rasyn, John, of Wiltshire 7
4572087 2222828 2222828 defendant Bechampton Nicholas   676568 676568 Bechampton, Nicholas, of Wiltshire 6
4575798 2223932 2223932 defendant Cheselden Robert   676568 676568 Cheselden, Robert, of Wiltshire 1
4581451 2225663 2225663 defendant Waryn John   676568 676568 Waryn, John, of Wiltshire 9
4581903 2225787 2225787 defendant Thorp Henry   676568 676568 Thorp, Henry, of Wiltshire 0
4581906 2225788 2225788 defendant Thorp Henry   676568 676568 Thorp, Henry, of Wiltshire 0
4595335 2229793 2229793 defendant Cheyne John esq 676568 676568 Cheyne, John, of Wiltshire, esq 0
4595346 2229795 2229795 defendant Cheyne John esq 676568 676568 Cheyne, John, of Wiltshire, esq 0
4605315 2232820 2232820 defendant Rasyn John   676568 676568 Rasyn, John, of Wiltshire 9
4605326 2232821 2232821 defendant Rasyn John   676568 676568 Rasyn, John, of Wiltshire 9
4606057 2233010 2233010 defendant Forster Stephen   676568 676568 Forster, Stephen, of Wiltshire 0
4612371 2234940 2234940 defendant Beauchamp Walter esq 676568 676568 Beauchamp, Walter, of Wiltshire, esq 0
4612743 2235052 2235052 defendant Duke William   676568 676568 Duke, William, of Wiltshire 0
4612744 2235052 2235052 defendant Duke John   676568 676568 Duke, John, of Wiltshire 1
4613540 2235252 2235252 defendant Hewey Thomas draper 676568 676568 Hewey, Thomas, of Wiltshire, draper 5
4614519 2235547 2235547 defendant Rodon William   676568 676568 Rodon, William, of Wiltshire 0
4617683 2236531 2236531 defendant Bolmer John   676568 676568 Bolmer, John, of Wiltshire 10
4619729 2237158 2237158 defendant Hock John clerk 676568 676568 Hock, John, of Wiltshire, clerk 1
4619733 2237159 2237159 defendant Hook John clerk 676568 676568 Hook, John, of Wiltshire, clerk 1
4620135 2237277 2237277 defendant Holgrave William   676568 676568 Holgrave, William, of Wiltshire 0
4623879 2238446 2238446 defendant Rous John esq 676568 676568 Rous, John, of Wiltshire, esq 0
4627894 2239655 2239655 defendant Holgrave William   676568 676568 Holgrave, William, of Wiltshire 0
4631165 2240647 2240647 defendant Fowes Lawrence clerk 676568 676568 Fowes, Lawrence, of Wiltshire, clerk 0
4640040 2243213 2243213 defendant Hewey Thomas   676568 676568 Hewey, Thomas, of Wiltshire 3
4645568 2244772 2244772 defendant Hatte William   676568 676568 Hatte, William, of Wiltshire 0
4647247 2245250 2245250 plaintiff Salman Robert   676568 676568 Salman, Robert, of Wiltshire 0
4672671 2257094 2257094 defendant Pakyn William husbandman 676568 676568 Pakyn, William, of Wiltshire, husbandman 2
4716322 2270417 2270417 defendant Byddesden Nicholas clerk 676568 676568 Byddesden, Nicholas, of Wiltshire, clerk 0
4718438 2271106 2271106 defendant Bremelham John husbandman 676568 676568 Bremelham, John, of Wiltshire, husbandman 0
4727203 2273768 2273768 plaintiff Pykot William   676568 676568 Pykot, William, of Wiltshire 2
4756755 2282477 2282477 plaintiff Best Robert   676568 676568 Best, Robert, of Wiltshire 0
4835123 2306984 2306984 plaintiff Darell William esq 676568 676568 Darell, William, of Wiltshire, esq 0
4914744 2331128 2331128 plaintiff Darell William esq 676568 676568 Darell, William, of Wiltshire, esq 0
4927698 2335097 2335097 plaintiff Saundres John gent 676568 676568 Saundres, John, of Wiltshire, gent 0
4987658 2353270 2353270 plaintiff Draper John   676568 676568 Draper, John, of Wiltshire 1
5124482 2393623 2393623 defendant (illegible) (illegible) skinner 676568 676568 ---, ---, of Wiltshire, skinner 0
5127682 2394579 2394579 plaintiff Carrewe Nicholas   676568 676568 Carrewe, Nicholas, of Wiltshire, King's Eschaetor 0
5128934 2394947 2394947 defendant Shete Thomas chapman 676568 676568 Shete, Thomas, of Wiltshire, chapman 0
5136684 2397254 2397254 plaintiff Pakenham Hugh   676568 676568 Pakenham, Hugh, of Wiltshire, sheriff 0
5136690 2397255 2397255 plaintiff Pakenham Hugh   676568 676568 Pakenham, Hugh, of Wiltshire, sheriff 0
5271747 2436837 2436837 defendant Hethe Thomas chapman 676568 676568 Hethe, Thomas, of Wiltshire, chapman 0
5373791 2467397 2467397 plaintiff Mompesson John esq & sheriff 676568 676568 Mompesson, John, of Wiltshire, esq & sheriff 0
5383298 2470299 2470299 defendant York John gent 676568 676568 York, John, of Wiltshire, gent 0
5390763 2472422 2472422 defendant Darell George (legal representative) 676568 676568 Darell, George, of Wiltshire, knight, executrix of 3
5418723 2480524 2480524 defendant Sturmy Agnes   676568 676568 Sturmy, Agnes, of Wiltshire, widow, formerly wife of William Sturmy 0
5441158 2487268 2487268 defendant Hawekyns John chapman 676568 676568 Hawekyns, John, of Wiltshire, chapman 0
5448730 2489514 2489514 defendant Charleton John gent 676568 676568 Charleton, John, of Wiltshire, gent 4
5451378 2490288 2490288 defendant Str_ Agnes widow & formerly wife of William 676568 676568 Str_, Agnes, of Wiltshire, widow & formerly wife of William 0
5454177 2491147 2491147 defendant Charleton John gent 676568 676568 Charleton, John, of Wiltshire, gent 4
5454769 2491349 2491349 defendant Brynmore John chaplain 676568 676568 Brynmore, John, of Wiltshire, chaplain 2
5613653 2548046 2548046 plaintiff Daunteseye John   676568 676568 Daunteseye, John, of Wiltshire, formerly sheriff 0
5619020 2549795 2549795 defendant Hakeford John   676568 676568 Hakeford, John, of Wiltshire 0

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