names

271 rows where place_id = 588600

✎ 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
3595026 1866077 1866077 defendant Edwardys John yeoman 588600 588600 Edwardys, John, of Westbury, yeoman 0
3603166 1868654 1868654 defendant Goldwegge Geoffrey tailor 588600 588600 Goldwegge, Geoffrey, of Westbury, tailor 0
3608638 1870362 1870362 defendant Hampton Roger husbandman 588600 588600 Hampton, Roger, of Westbury, husbandman 0
3608640 1870363 1870363 defendant Hampton Roger husbandman 588600 588600 Hampton, Roger, of Westbury, husbandman 0
3624927 1875329 1875329 defendant Hasill Walter husbandman 588600 588600 Hasill, Walter, of Westbury, husbandman 0
3631814 1904757 1904757 plaintiff Gyttyns John, junior yeoman 588600 588600 Gyttyns, John, junior, of Westbury, yeoman 1
3640562 1907487 1907487 defendant Bettys Lewis miller 588600 588600 Bettys, Lewis, of Westbury, miller 0
3669684 1916458 1916458 defendant Stevyns Richard huswbandman 588600 588600 Stevyns, Richard, of Westbury, huswbandman 0
3684017 1921133 1921133 defendant Budde John husbandman 588600 588600 Budde, John, of Westbury, husbandman 0
3684018 1921133 1921133 defendant Peers Thomas husbandman 588600 588600 Peers, Thomas, of Westbury, husbandman 1
3687989 1922404 1922404 defendant Edwardys Edmund tucker 588600 588600 Edwardys, Edmund, of Westbury, tucker 0
3687990 1922404 1922404 defendant Busshop Thomas weaver 588600 588600 Busshop, Thomas, of Westbury, weaver 1
3687991 1922404 1922404 defendant Hyer Thomas tanner 588600 588600 Hyer, Thomas, of Westbury, tanner 2
3687992 1922404 1922404 defendant Facy Henry husbandman 588600 588600 Facy, Henry, of Westbury, husbandman 3
3687993 1922404 1922404 defendant Hoper Henry husbandman 588600 588600 Hoper, Henry, of Westbury, husbandman 4
3692760 1923925 1923925 defendant Alryge Ralph husbandman 588600 588600 Alryge, Ralph, of Westbury, husbandman 0
3693245 1924097 1924097 defendant Bysshop Thomas weaver 588600 588600 Bysshop, Thomas, of Westbury, weaver 0
3693965 1924315 1924315 defendant Bare alias Couke William yeoman 588600 588600 Bare alias Couke, William, of Westbury, yeoman 0
3694951 1924631 1924631 defendant Style William yeoman 588600 588600 Style, William, of Westbury, yeoman 0
3695868 1924943 1924943 defendant Ryder John husbandman 588600 588600 Ryder, John, of Westbury, husbandman 0
3710097 1929469 1929469 defendant Ryder John husbandman 588600 588600 Ryder, John, of Westbury, husbandman 0
3740567 1938906 1938906 defendant Ryder John husbandman 588600 588600 Ryder, John, of Westbury, husbandman 0
3751676 1942441 1942441 defendant Tacle Oliver dyer 588600 588600 Tacle, Oliver, of Westbury, dyer 1
3766006 1947032 1947032 defendant A Water John tanner 588600 588600 A Water, John, of Westbury under Plain, tanner 0
3808304 1960471 1960471 defendant Gawen William tucker 588600 588600 Gawen, William, of Westbury under Playne, tucker 0
3809267 1960781 1960781 defendant Bathe John, junior clothman 588600 588600 Bathe, John, junior, of Westbury, clothman 0
3819403 1963953 1963953 defendant Wod Arthur yeoman 588600 588600 Wod, Arthur, of Westbury, yeoman 0
3819404 1963953 1963953 defendant Hyewey Richard husbandman 588600 588600 Hyewey, Richard, of Westbury, husbandman 1
3832091 1967942 1967942 defendant Leche William, senior husbandman 588600 588600 Leche, William, senior, of Westbury, husbandman 0
3839898 1970413 1970413 defendant Yngolsby Richard gent 588600 588600 Yngolsby, Richard, of Westbury, gent 2
3845112 1972030 1972030 defendant Hadwych Richard husbandman 588600 588600 Hadwych, Richard, of Westbury, husbandman 0
3845113 1972030 1972030 defendant Colyer Thomas husbandman 588600 588600 Colyer, Thomas, of Westbury, husbandman 1
3857154 1975867 1975867 defendant Tanner Thomas yeoman 588600 588600 Tanner, Thomas, of Westbury, yeoman 0
3858218 1976226 1976226 defendant Walys Geoffrey tailor 588600 588600 Walys, Geoffrey, of Westbury, tailor 0
3876987 1982544 1982544 defendant Heynes Joan widow 588600 588600 Heynes, Joan, of Westbury, widow 0
3884493 1985086 1985086 defendant Herrys Nicholas tucker 588600 588600 Herrys, Nicholas, of Westbury, tucker 0
3884494 1985086 1985086 defendant Watley John husbandman 588600 588600 Watley, John, of Westbury, husbandman 1
3893205 1987965 1987965 defendant Wod Arthur husbandman 588600 588600 Wod, Arthur, of Westbury under Trym, husbandman 0
3900668 1990453 1990453 defendant Markys John clerk 588600 588600 Markys, John, of Westbury, clerk 1
3935984 2002353 2002353 defendant Bayly John yeoman 588600 588600 Bayly, John, of Westbury, yeoman 0
3935985 2002353 2002353 defendant Bayly Humphrey yeoman 588600 588600 Bayly, Humphrey, of Westbury, yeoman 1
3935986 2002353 2002353 defendant Bakhouse John husbandman 588600 588600 Bakhouse, John, of Westbury, husbandman 2
3951813 2007695 2007695 defendant Boultynge John husbandman 588600 588600 Boultynge, John, of Westbury, husbandman 0
4001538 2025328 2025328 defendant Hardwyche John husbandman 588600 588600 Hardwyche, John, of Westbury, husbandman 0
4004092 2026236 2026236 defendant Lovell Edmund husbandman 588600 588600 Lovell, Edmund, of Westbury, husbandman 0
4054780 2044097 2044097 defendant Lyngham John gent 588600 588600 Lyngham, John, of Westbury, gent 2
4081207 2053587 2053587 plaintiff Wheatacre Stephen   588600 588600 Wheatacre, Stephen, of Westbury, clothier, administrators of 0
4092562 2057646 2057646 defendant Adlam George clothier 588600 588600 Adlam, George, of Westbury, clothier 1
4096481 2059069 2059069 defendant Wallys Mathew yeoman or tailor 588600 588600 Wallys, Mathew, of Westbury, yeoman or tailor 0
4100085 2060361 2060361 defendant Goulde Thomas husbandman 588600 588600 Goulde, Thomas, of Westbury, husbandman 0
4100086 2060361 2060361 defendant Goulde Edward husbandman 588600 588600 Goulde, Edward, of Westbury, husbandman 1
4121020 2067807 2067807 defendant Yonge Christopher yeoman 588600 588600 Yonge, Christopher, of Westbury, yeoman 0
4121021 2067807 2067807 defendant Crumpe Robert yeoman 588600 588600 Crumpe, Robert, of Westbury, yeoman 1
4121028 2067809 2067809 defendant Yonge Christopher yeoman 588600 588600 Yonge, Christopher, of Westbury, yeoman 0
4121029 2067809 2067809 defendant Crumpe Robert yeoman 588600 588600 Crumpe, Robert, of Westbury, yeoman 1
4125653 2069458 2069458 defendant Punfeilde William husbandman 588600 588600 Punfeilde, William, of Westbury, husbandman 3
4146265 2076843 2076843 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury, gent 0
4153249 2079233 2079233 defendant Hill Adam clerk 588600 588600 Hill, Adam, of Westbury, clerk 1
4157740 2080778 2080778 defendant Braban Roger yeoman 588600 588600 Braban, Roger, of Westbury, yeoman 0
4167748 2084209 2084209 defendant Horne Thomas yeoman 588600 588600 Horne, Thomas, of Westbury, yeoman 0
4168786 2084575 2084575 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury, gent 0
4168788 2084576 2084576 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury, gent 0
4168865 2084600 2084600 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury, gent 0
4168867 2084601 2084601 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury, gent 0
4173056 2086032 2086032 defendant Whetacre John clothman 588600 588600 Whetacre, John, of Westbury, clothman 0
4174023 2086366 2086366 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury, gent 0
4174025 2086367 2086367 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury, gent 0
4178148 2087828 2087828 defendant Stephens Richard gent 588600 588600 Stephens, Richard, of Westbury, gent 0
4183532 2089722 2089722 defendant Presbury Thomas fisherman 588600 588600 Presbury, Thomas, of Westbury, fisherman 0
4187427 2091101 2091101 defendant Stokes Nicholas chapman 588600 588600 Stokes, Nicholas, of Westbury, chapman 0
4189465 2091811 2091811 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury, gent 0
4190195 2092076 2092076 defendant Whetacre John clothman 588600 588600 Whetacre, John, of Westbury under Playne, clothman 1
4204184 2097013 2097013 defendant Horne Thomas yeoman 588600 588600 Horne, Thomas, of Westbury, yeoman 0
4209897 2099022 2099022 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury under Playne, or of Swyndon, gent 0
4224343 2103998 2103998 defendant Phillipps John, senior husbandman 588600 588600 Phillipps, John, senior, of Westbury, husbandman 0
4232976 2107042 2107042 defendant Barnett Nicholas yeoman 588600 588600 Barnett, Nicholas, of Westbury, yeoman 1
4239015 2109265 2109265 defendant Bearsly Anthony haberdasher 588600 588600 Bearsly, Anthony, of Westbury, haberdasher 0
4247375 2112099 2112099 defendant Bowyer David husbandman 588600 588600 Bowyer, David, of Westbury, husbandman 2
4302736 2131074 2131074 defendant Elye William husbandman 588600 588600 Elye, William, of Westbury under Mendipp, husbandman 0
4313642 2134875 2134875 defendant Cleyton Thomas gent 588600 588600 Cleyton, Thomas, of Westbury, yeoman Rothero, John ap, of Llanvair Wadarnevair, Cardigan, gent 0
4330709 2140569 2140569 defendant Braban Adam husbandman 588600 588600 Braban, Adam, of Westbury, husbandman 2
4338302 2143140 2143140 defendant Purslowe Thomas gent 588600 588600 Purslowe, Thomas, of Westbury, gent 0
4338303 2143140 2143140 defendant Purslowe Edward gent 588600 588600 Purslowe, Edward, of Westbury, gent 1
4338304 2143140 2143140 defendant Boyer John husbandman 588600 588600 Boyer, John, of Westbury, husbandman 2
4338305 2143140 2143140 defendant Boyer Thomas husbandman 588600 588600 Boyer, Thomas, of Westbury, husbandman 3
4344816 2145467 2145467 defendant Yeanley William yeoman 588600 588600 Yeanley, William, of Westbury, yeoman 0
4344817 2145467 2145467 defendant Broxson Roger yeoman 588600 588600 Broxson, Roger, of Westbury, yeoman 1
4344818 2145467 2145467 defendant Speake Richard yeoman 588600 588600 Speake, Richard, of Westbury, yeoman 2
4344819 2145467 2145467 defendant Broxson James yeoman 588600 588600 Broxson, James, of Westbury, yeoman 3
4349185 2146975 2146975 defendant Stevens Richard gent 588600 588600 Stevens, Richard, of Westbury, gent 1
4355570 2149171 2149171 defendant Okeford William glover 588600 588600 Okeford, William, of Westbury, glover 0
4355571 2149171 2149171 defendant Dodymeade Edward fuller 588600 588600 Dodymeade, Edward, of Westbury, fuller 1
4355572 2149171 2149171 defendant Fourde John husbandman 588600 588600 Fourde, John, of Westbury, husbandman 2
4364543 2152377 2152377 defendant Wilkyns Thomas weaver 588600 588600 Wilkyns, Thomas, of Westbury, or of Overcourte, Brodley, weaver 0
4364544 2152377 2152377 defendant Drewe John yeoman 588600 588600 Drewe, John, of Westbury, yeoman 1
4377787 2157127 2157127 defendant Hardwyche John, senior yeoman 588600 588600 Hardwyche, John, senior, of Westbury, yeoman 1
4406512 2166742 2166742 defendant Rawlins or Rallinges William tanner 588600 588600 Rawlins or Rallinges, William, of Westbury under Playne, tanner 0
4406513 2166742 2166742 defendant Rawlins or Rallinges Richard   588600 588600 Rawlins or Rallinges, Richard, of Westbury under Playne, tanner, his son 1
4416716 2170095 2170095 defendant Wolmongere Roger le   588600 588600 Wolmongere, Roger le, of Westbury 0
4417428 2170335 2170335 defendant Sewy Simon   588600 588600 Sewy, Simon, of Westbury 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);