names

158 rows where place_id = 593513

✎ 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
3612192 1871456 1871456 defendant Wolf William clerk 593513 593513 Wolf, William, of Staunton, clerk 0
3612193 1871456 1871456 defendant Robyns John husbandman 593513 593513 Robyns, John, of Staunton, husbandman 1
3612194 1871456 1871456 defendant Robyns Stephen husdbandman 593513 593513 Robyns, Stephen, of Staunton, husdbandman 2
3612195 1871456 1871456 defendant Cartwrygh Roger husbandman 593513 593513 Cartwrygh, Roger, of Staunton, husbandman 3
3629840 1904185 1904185 defendant Wynter Thomas husbandman 593513 593513 Wynter, Thomas, of Staunton, husbandman 1
3629841 1904185 1904185 defendant Hykkes John husbandman 593513 593513 Hykkes, John, of Staunton, husbandman 2
3631619 1904704 1904704 defendant Smyth William husbandman 593513 593513 Smyth, William, of Staunton, husbandman 0
3637907 1906672 1906672 defendant Houseman John chaplain 593513 593513 Houseman, John, of Staunton, chaplain 0
3640970 1907616 1907616 defendant Piers Edmund yeoman 593513 593513 Piers, Edmund, of Staunton, yeoman 0
3640971 1907616 1907616 defendant Sampford Richard yeoman 593513 593513 Sampford, Richard, of Staunton, yeoman 1
3644296 1908642 1908642 defendant Phippes William yeoman 593513 593513 Phippes, William, of Staunton, yeoman 5
3644297 1908642 1908642 defendant Reynold John yeoman 593513 593513 Reynold, John, of Staunton, yeoman 6
3644298 1908642 1908642 defendant Zelye William yeoman 593513 593513 Zelye, William, of Staunton, yeoman 7
3644314 1908644 1908644 defendant Phippes William yeoman 593513 593513 Phippes, William, of Staunton, yeoman 1
3667355 1915727 1915727 defendant Ballod Robert yeoman 593513 593513 Ballod, Robert, of Staunton, yeoman 0
3683565 1920992 1920992 defendant Burthyn Thomas gent 593513 593513 Burthyn, Thomas, of Staunton, gent 0
3683566 1920992 1920992 defendant Swaddon Edward husbandman 593513 593513 Swaddon, Edward, of Staunton, husbandman 1
3683567 1920992 1920992 defendant Carpenter Robert husbandman 593513 593513 Carpenter, Robert, of Staunton, husbandman 2
3730921 1935898 1935898 defendant Wattys Richard husbandman 593513 593513 (Wattys, Richard, of Staunton, husbandman 1
3740954 1939031 1939031 defendant Glover John husbandman 593513 593513 Glover, John, of Staunton, husbandman 2
3740955 1939031 1939031 defendant Carpenter Richard husbandman 593513 593513 Carpenter, Richard, of Staunton, husbandman 3
3741912 1939336 1939336 defendant Fleccher William husbandman 593513 593513 Fleccher, William, of Staunton, husbandman 0
3741913 1939336 1939336 defendant Badlond Richard husbandman 593513 593513 Badlond, Richard, of Staunton, husbandman 1
3742108 1939400 1939400 defendant Elston John husbandman 593513 593513 Elston, John, of Staunton, husbandman 2
3811179 1961393 1961393 defendant Calton Stephen husbandman 593513 593513 Calton, Stephen, of Staunton under Bardon, husbandman 0
3829640 1967162 1967162 defendant Logge Henry yeoman 593513 593513 Logge, Henry, of Staunton, yeoman 0
3830043 1967291 1967291 defendant Deyn John clerk 593513 593513 Deyn, John, of Staunton, clerk 0
3837436 1969616 1969616 plaintiff Sneyde John   593513 593513 Sneyde, John, of Staunton 0
3848730 1973188 1973188 defendant Wylkys John, junior husbandman 593513 593513 Wylkys, John, junior, of Staunton, husbandman 2
3886021 1985575 1985575 plaintiff Sawyer Walter   593513 593513 Sawyer, Walter, of Staunton 2
3886567 1985758 1985758 plaintiff Button Thomas gent 593513 593513 Button, Thomas, of Staunton, gent 0
3892092 1987607 1987607 defendant Deane John chaplain 593513 593513 Deane, John, of Staunton, chaplain 0
3892093 1987607 1987607 defendant Parkynson Richard husbandman 593513 593513 Parkynson, Richard, of Staunton, husbandman 1
3892094 1987607 1987607 defendant Knyvesmythe Henry husbandman 593513 593513 Knyvesmythe, Henry, of Staunton, husbandman 2
3892095 1987607 1987607 defendant Turnpeny William husbandman 593513 593513 Turnpeny, William, of Staunton, husbandman 3
3897443 1989359 1989359 defendant Blakestaff John laborer 593513 593513 Blakestaff, John, of Staunton, laborer 0
3925203 1998740 1998740 defendant Badlande Roger husbandman 593513 593513 Badlande, Roger, of Staunton, husbandman 0
3925650 1998891 1998891 defendant Staunton Anthony gent 593513 593513 Staunton, Anthony, of Staunton, gent 0
3932790 2001271 2001271 defendant Eglyn John butcher 593513 593513 Eglyn, John, of Staunton, butcher 2
3932791 2001271 2001271 defendant Longe John butcher 593513 593513 Longe, John, of Staunton, butcher 3
3974158 2015529 2015529 defendant Wade John husbandman 593513 593513 Wade, John, of Staunton, husbandman 1
3974159 2015529 2015529 defendant Waden Thomas husbandman 593513 593513 Waden, Thomas, of Staunton, husbandman 2
3983780 2018976 2018976 plaintiff Staunton Robert esq 593513 593513 Staunton, Robert, of Staunton, esq 0
4003439 2025994 2025994 plaintiff Horton Thomas esq 593513 593513 Horton, Thomas, of Staunton, esq 0
4003440 2025994 2025994 defendant Bysshopp John husbandman 593513 593513 Bysshopp, John, of Staunton, husbandman 0
4025866 2033903 2033903 defendant Brayne Godytha widow 593513 593513 Brayne, Godytha, of Staunton, widow 1
4047358 2041513 2041513 plaintiff Staunton Robert esq 593513 593513 Staunton, Robert, of Staunton, esq 0
4071436 2050085 2050085 defendant Churcheman Richard clerk 593513 593513 Churcheman, Richard, of Staunton, clerk 0
4086397 2055413 2055413 defendant Banyster Wilfred esq 593513 593513 Banyster, Wilfred, of Staunton, esq 0
4099801 2060251 2060251 defendant Price Nicholas yeoman 593513 593513 Price, Nicholas, of Staunton, yeoman 0
4156950 2080509 2080509 defendant Prise John yeoman 593513 593513 Prise, John, of Staunton, yeoman 3
4166742 2083863 2083863 defendant Griffethe Thomas yeoman 593513 593513 Griffethe, Thomas, of Staunton, yeoman 1
4175820 2087019 2087019 defendant Harrys John yeoman 593513 593513 Harrys, John, of Staunton, yeoman 0
4176614 2087295 2087295 defendant Baskervyle Richard clerk 593513 593513 Baskervyle, Richard, of Staunton, clerk 0
4199698 2095443 2095443 defendant Gyll William   593513 593513 Gyll, William, of Staunton 1
4215999 2101089 2101089 defendant Walker William yeoman 593513 593513 Walker, William, of Staunton, yeoman 0
4219082 2102170 2102170 defendant Russell Lawrence   593513 593513 Russell, Lawrence, of Staunton, yeoman, son of David Russell 0
4244372 2111094 2111094 defendant Barston John tailor 593513 593513 Barston, John, of Staunton, tailor 0
4244373 2111094 2111094 defendant Gryndye William   593513 593513 Gryndye, William, of Staunton, mason 1
4244375 2111095 2111095 defendant Twynnynge Thomas husbandman 593513 593513 Twynnynge, Thomas, of Staunton, husbandman 0
4244376 2111095 2111095 defendant Twynnynge Roger husbandman 593513 593513 Twynnynge, Roger, of Staunton, husbandman 1
4276328 2121664 2121664 defendant Burge Edith spinster 593513 593513 Burge, Edith, of Staunton, spinster 0
4314860 2135311 2135311 defendant Prater Thomas gent 593513 593513 Prater, Thomas, of Staunton, gent 0
4314861 2135311 2135311 defendant Prater William gent 593513 593513 Prater, William, of Staunton, gent 1
4314862 2135311 2135311 defendant Stevens Thomas yeoman 593513 593513 Stevens, Thomas, of Staunton, yeoman 2
4323382 2138237 2138237 defendant Durham Thomas yeoman 593513 593513 Durham, Thomas, of Staunton, yeoman 1
4324375 2138549 2138549 defendant Horton William gent 593513 593513 Horton, William, of Staunton, gent 0
4324376 2138549 2138549 defendant Mathewe alias Ledington Thomas smith 593513 593513 Mathewe alias Ledington, Thomas, of Staunton, smith 1
4324377 2138549 2138549 defendant Mathewe alias Ledington Roland laborer 593513 593513 Mathewe alias Ledington, Roland, of Staunton, laborer 2
4324378 2138549 2138549 defendant Dyrram James laborer 593513 593513 Dyrram, James, of Staunton, laborer 3
4325991 2139066 2139066 defendant Peate Thomas yeoman 593513 593513 Peate, Thomas, of Staunton, yeoman 2
4388454 2160776 2160776 defendant Horton William gent 593513 593513 Horton, William, of Staunton, gent 1
4388457 2160777 2160777 defendant Horton William gent 593513 593513 Horton, William, of Staunton, gent 1
4388794 2160884 2160884 defendant Cole Thomas   593513 593513 Cole, Thomas, of Staunton, Glos husbandman 0
4390890 2161567 2161567 defendant Webbe William yeoman 593513 593513 Webbe, William, of Staunton, yeoman 1
4390891 2161567 2161567 defendant Cooke Richard yeoman 593513 593513 together with Cooke, Richard, of Staunton, yeoman 2
4419552 2171000 2171000 plaintiff Belgraunt Roger   593513 593513 Belgraunt, Roger, of Staunton 0
4462184 2188869 2188869 defendant Milner Robert   593513 593513 Milner, Robert, of Staunton, son of Robert 0
4475310 2192962 2192962 plaintiff Everdon John (legal representative) 593513 593513 Everdon, John, of Staunton Prior, clerk, executor of 0
4475312 2192962 2192962 defendant Everden John, senior   593513 593513 Everden, John, senior, of Staunton 0
4476923 2193441 2193441 defendant Staunton John   593513 593513 Staunton, John, of Staunton 0
4490995 2197879 2197879 defendant Ware John   593513 593513 Ware, John, of Staunton 0
4490996 2197879 2197879 defendant Horton John de   593513 593513 Horton, John de, of Staunton 1
4502628 2201404 2201404 plaintiff Mulward John   593513 593513 Mulward, John, of Staunton 0
4504670 2202003 2202003 defendant Staunton Ralph de esq 593513 593513 Staunton, Ralph de, of Staunton, esq 0
4505740 2202306 2202306 plaintiff Staunton John   593513 593513 Staunton, John, of Staunton 0
4520710 2206825 2206825 defendant Muleward Richard   593513 593513 Muleward, Richard, of Staunton 5
4536608 2211730 2211730 plaintiff Staunton John   593513 593513 Staunton, John, of Staunton 0
4564956 2220605 2220605 defendant Staunton Lawrence   593513 593513 Staunton, Lawrence, of Staunton 0
4569436 2222029 2222029 defendant Strode Richard   593513 593513 Strode, Richard, of Staunton 0
4580254 2225310 2225310 defendant Feythom Richard   593513 593513 Feythom, Richard, of Staunton 2
4589112 2227972 2227972 plaintiff Ledenham John   593513 593513 Ledenham, John, of Staunton 0
4613992 2235390 2235390 defendant Dobbes Thomas   593513 593513 Dobbes, Thomas, of Staunton 0
4625251 2238863 2238863 plaintiff Palmer Nicholas   593513 593513 Palmer, Nicholas, of Staunton 0
4625266 2238867 2238867 plaintiff Palmere Nicholas   593513 593513 Palmere, Nicholas, of Staunton 0
4630279 2240379 2240379 defendant Taylour Thomas   593513 593513 Taylour, Thomas, of Staunton 0
4644592 2244511 2244511 defendant Taillour William   593513 593513 Taillour, William, of Staunton 0
4646716 2245105 2245105 defendant Rubley Stephen   593513 593513 Rubley, Stephen, of Staunton 0
4649089 2245780 2245780 defendant Beere John   593513 593513 Beere, John, of Staunton 5
4680969 2259674 2259674 defendant Everard Walter husbandman 593513 593513 Everard, Walter, of Staunton, husbandman 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);