names

48 rows where place_id = 590631

✎ 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
3601847 1868233 1868233 defendant Frape John husbandman 590631 590631 Frape, John, of Wesbury, husbandman 4
3713581 1930557 1930557 defendant Hyet Richard husbandman 590631 590631 Hyet, Richard, of Wesbury, husbandman 0
3934926 2001985 2001985 defendant Wyntyll William yeoman 590631 590631 Wyntyll, William, of Wesbury, yeoman 0
3957373 2009644 2009644 defendant Symson Anthony tailor 590631 590631 Symson, Anthony, of Wesbury, tailor 0
3960055 2010616 2010616 defendant Elberton Thomas gent 590631 590631 Elberton, Thomas, of Wesbury, gent 0
3960056 2010616 2010616 defendant Beanam William esq 590631 590631 Beanam, William, of Wesbury, esq 1
3960057 2010616 2010616 defendant Trobridge William yeoman 590631 590631 Trobridge, William, of Wesbury, yeoman 2
3960058 2010616 2010616 defendant Packer John tanner 590631 590631 Packer, John, of Wesbury, tanner 3
3960059 2010616 2010616 defendant Wyther John yeoman 590631 590631 Wyther, John, of Wesbury, yeoman 4
3960060 2010616 2010616 defendant Morraunt Edmund yeoman 590631 590631 Morraunt, Edmund, of Wesbury, yeoman 5
3960126 2010646 2010646 defendant Baylye William yeoman 590631 590631 Baylye, William, of Wesbury, yeoman 0
3960128 2010647 2010647 defendant Nurthe Richard yeoman 590631 590631 Nurthe, Richard, of Wesbury, yeoman 0
3960129 2010647 2010647 defendant Holsted Richard yeoman 590631 590631 Holsted, Richard, of Wesbury, yeoman 1
3963431 2011813 2011813 defendant Master John chapman 590631 590631 Master, John, of Wesbury, chapman 0
3963432 2011813 2011813 defendant Braban James husbandman 590631 590631 Braban, James, of Wesbury, husbandman 1
3968037 2013450 2013450 defendant Aleberton Thomas gent 590631 590631 Aleberton, Thomas, of Wesbury, gent 0
3968038 2013450 2013450 defendant Mowsell John yeoman 590631 590631 Mowsell, John, of Wesbury, yeoman 1
3968039 2013450 2013450 defendant Aleberton Robert laborer 590631 590631 Aleberton, Robert, of Wesbury, laborer 2
3968040 2013450 2013450 defendant Drewes Robert laborer 590631 590631 Drewes, Robert, of Wesbury, laborer 3
4011984 2029015 2029015 defendant Whyte Giles mercer 590631 590631 Whyte, Giles, of Wesbury, mercer 0
4047162 2041431 2041431 defendant Yonge Christopher yeoman 590631 590631 Yonge, Christopher, of Wesbury, yeoman 0
4138353 2074080 2074080 defendant Ayleberton John yeoman 590631 590631 Ayleberton, John, of Wesbury, yeoman 0
4159493 2081387 2081387 defendant Will Nicholas tanner 590631 590631 Will, Nicholas, of Wesbury, tanner 0
4159497 2081389 2081389 defendant Wills Nicholas tanner 590631 590631 Wills, Nicholas, of Wesbury, tanner 0
4159498 2081389 2081389 defendant Coxe alias Whytington Margaret spinster 590631 590631 Coxe alias Whytington, Margaret, of Wesbury, spinster 1
4167868 2084247 2084247 defendant Younge Christopher yeoman 590631 590631 Younge, Christopher, of Wesbury, yeoman 2
4179158 2088185 2088185 defendant Elberton John, senior gent 590631 590631 Elberton, John, senior, of Wesbury, gent 0
4214836 2100691 2100691 defendant Phillipps John, senior husbandman 590631 590631 Phillipps, John, senior, of Wesbury, husbandman 0
4214837 2100691 2100691 defendant Phillipps John, junior husbandman 590631 590631 Phillipps, John, junior, of Wesbury, husbandman 1
4301709 2130718 2130718 defendant Phillipps John, junior yeoman 590631 590631 Phillipps, John, junior, of Wesbury, yeoman 2
4310332 2133768 2133768 defendant Braban Adam yeoman 590631 590631 Braban, Adam, of Wesbury, yeoman 0
4318761 2136674 2136674 defendant Cowlston John yeoman 590631 590631 Cowlston, John, of Wesbury, yeoman 1
4334103 2141685 2141685 defendant Lloyd Reginald yeoman 590631 590631 Lloyd, Reginald, of Wesbury, yeoman 3
4374936 2156095 2156095 defendant Presberye Adam   590631 590631 Presberye, Adam, of Wesbury, sailor 0
4389670 2161175 2161175 defendant Willys Nicholas tanner 590631 590631 Willys, Nicholas, of Wesbury, tanner 1
4411477 2168429 2168429 defendant Bushe Walter yeoman 590631 590631 Bushe, Walter, of Wesbury, or of Parkers Neede, yeoman 0
4512350 2204304 2204304 defendant Broke Richard   590631 590631 Broke, Richard, of Wesbury 1
4512352 2204305 2204305 defendant Staure Richard   590631 590631 Staure, Richard, of Wesbury 0
4883798 2321840 2321840 defendant Hulle Robert husbandman 590631 590631 Hulle, Robert, of Wesbury, husbandman 0
4890082 2323676 2323676 defendant Aure Nicholas yeoman 590631 590631 Aure, Nicholas, of Wesbury, yeoman 4
4966807 2346996 2346996 defendant atte Hille William drover 590631 590631 atte Hille, William, of Wesbury, drover 1
5311811 2448559 2448559 defendant Shere William weaver 590631 590631 Shere, William, of Wesbury, or of Oxonhold, weaver 2
5527651 2513227 2513227 defendant Rokke William husbandman 590631 590631 Rokke, William, of Wesbury, husbandman 2
5555762 2521675 2521675 defendant ap Guyllym Thomas gent 590631 590631 ap Guyllym, Thomas, of Wesbury, gent 0
5572892 2526623 2526623 defendant Tylar John mercer 590631 590631 Tylar, John, of Wesbury, mercer 0
5580406 2528956 2528956 defendant Launder Ralph husbandman 590631 590631 Launder, Ralph, of Wesbury, husbandman 1
5621847 2550743 2550743 plaintiff Thame John   590631 590631 Thame, John, of Wesbury 0
5621849 2550744 2550744 plaintiff Thame John   590631 590631 Thame, John, of Wesbury 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);