names

58 rows where place_id = 586204

✎ 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
3588160 1863949 1863949 defendant Wellys Thomas baker 586204 586204 Wellys, Thomas, of Bengeworth, baker 0
3650156 1910419 1910419 defendant Wythley William cordwainer 586204 586204 Wythley, William, of Bengeworth, cordwainer 0
3650157 1910419 1910419 defendant Whyte David cordwainer 586204 586204 Whyte, David, of Bengeworth, cordwainer 1
3650158 1910419 1910419 defendant Dyer William dyer 586204 586204 Dyer, William, of Bengeworth, dyer 2
3660792 1913640 1913640 defendant Hommyng Henry   586204 586204 Hommyng, Henry, of Bengeworth, wool winder 4
3687871 1922369 1922369 defendant Wytheley William cordwainer 586204 586204 Wytheley, William, of Bengeworth, cordwainer 2
3713031 1930400 1930400 defendant Payne William dyer 586204 586204 Payne, William, of Bengeworth, dyer 2
3716968 1931594 1931594 defendant Nycollys Nicholas weaver 586204 586204 Nycollys, Nicholas, of Bengeworth, weaver 1
3728473 1935155 1935155 defendant Hemmyng Henry   586204 586204 Hemmyng, Henry, of Bengeworth, wool winder 1
3728474 1935155 1935155 defendant Couper William walker 586204 586204 Couper, William, of Bengeworth, walker 2
3728475 1935155 1935155 defendant Gotysley John walker 586204 586204 Gotysley, John, of Bengeworth, walker 3
3791904 1955313 1955313 defendant Cowper William fuller 586204 586204 Cowper, William, of Bengeworth, fuller 0
3791905 1955313 1955313 defendant Symondys John smith 586204 586204 Symondys, John, of Bengeworth, smith 1
3791906 1955313 1955313 defendant Nycollys Nicholas weaver 586204 586204 Nycollys, Nicholas, of Bengeworth, weaver 2
3829021 1966959 1966959 defendant Cropthorne Richard   586204 586204 Cropthorne, Richard, of Bengeworth, wool winder 3
3883904 1984887 1984887 defendant None Thomas fuller 586204 586204 None, Thomas, of Bengeworth, fuller 0
3904346 1991702 1991702 plaintiff Haye Thomas   586204 586204 Haye, Thomas, of Bengeworth 0
3952490 2007939 2007939 defendant Yekyns Hugh yeoman 586204 586204 Yekyns, Hugh, of Bengeworth, yeoman 2
4001953 2025477 2025477 plaintiff Harward Roger yeoman 586204 586204 Harward, Roger, of Bengeworth, yeoman 0
4208441 2098502 2098502 defendant Baylyes Walter woolman 586204 586204 Baylyes, Walter, of Bengeworth, woolman 0
4301014 2130466 2130466 defendant Brantley John   586204 586204 Brantley, John, of Bengeworth, yeoman, bachelor 0
4455728 2186803 2186803 plaintiff Morten Henry   586204 586204 Morten, Henry, of Bengeworth 0
4487548 2196823 2196823 defendant Dier Henry   586204 586204 Dier, Henry, of Bengeworth 0
4494337 2198921 2198921 defendant Beauchamp John   586204 586204 Beauchamp, John, of Bengeworth 0
4521927 2207196 2207196 defendant Heryng Robert   586204 586204 Heryng, Robert, of Bengeworth 4
4559863 2219035 2219035 defendant Dyer William   586204 586204 Dyer, William, of Bengeworth 0
4634149 2241524 2241524 defendant Reve Thomas   586204 586204 Reve, Thomas, of Bengeworth 1
4641072 2243479 2243479 defendant Dyer Thomas   586204 586204 Dyer, Thomas, of Bengeworth 0
4661195 2249327 2249327 plaintiff Dyer Thomas   586204 586204 Dyer, Thomas, of Bengeworth 0
4661715 2249504 2249504 defendant Heuster Thomas yeoman 586204 586204 Heuster, Thomas, of Bengeworth, yeoman 0
4702459 2266179 2266179 defendant Dier Thomas   586204 586204 Dier, Thomas, of Bengeworth, wood man 1
4743086 2278499 2278499 defendant atte Wod John laborer 586204 586204 atte Wod, John, of Bengeworth, laborer 0
4780268 2289830 2289830 defendant Colwiche Adam chapman 586204 586204 Colwiche, Adam, of Bengeworth, chapman 0
4814830 2300750 2300750 defendant Chalner Richard husbandman 586204 586204 Chalner, Richard, of Bengeworth, husbandman 3
4814835 2300750 2300750 defendant Plommer John husbandman 586204 586204 Plommer, John, of Bengeworth, husbandman 8
4814841 2300751 2300751 defendant Hancokes John husbandman 586204 586204 Hancokes, John, of Bengeworth, husbandman 4
4840544 2308583 2308583 defendant Chaloner Richard chaloner 586204 586204 Chaloner, Richard, of Bengeworth, chaloner 0
4846338 2310362 2310362 defendant Doraunt Robert husbandman 586204 586204 Doraunt, Robert, of Bengeworth, husbandman 0
4846339 2310362 2310362 defendant Malet John husbandman 586204 586204 Malet, John, of Bengeworth, husbandman 1
4863384 2315516 2315516 defendant Dyer Thomas husbandman 586204 586204 Dyer, Thomas, of Bengeworth, husbandman 0
4875052 2319148 2319148 defendant Chaloner Richard chaloner or blanket maker 586204 586204 Chaloner, Richard, of Bengeworth, chaloner or blanket maker 0
4906771 2328699 2328699 defendant Fermour John husbandman 586204 586204 Fermour, John, of Bengeworth, husbandman 4
4981543 2351391 2351391 defendant Dyer Thomas dyer 586204 586204 Dyer, Thomas, of Bengeworth, dyer 0
5020475 2362877 2362877 defendant Warner John laborer 586204 586204 Warner, John, of Bengeworth, laborer 0
5073279 2378495 2378495 defendant Dyer Thomas yeoman 586204 586204 Dyer, Thomas, of Bengeworth, yeoman 0
5141387 2398601 2398601 defendant Walker Robert husbandman 586204 586204 Walker, Robert, of Bengeworth, husbandman 9
5162544 2404770 2404770 defendant Walker Robert husbandman 586204 586204 Walker, Robert, of Bengeworth, husbandman 10
5176535 2408824 2408824 defendant Walker Robert husbandman 586204 586204 Walker, Robert, of Bengeworth, husbandman 9
5230952 2424661 2424661 defendant Magot William husbandman 586204 586204 Magot, William, of Bengeworth, husbandman 0
5418301 2480400 2480400 defendant Trentham Thomas chapman 586204 586204 Trentham, Thomas, of Bengeworth, chapman 4
5481681 2499453 2499453 defendant Wellys Thomas baker 586204 586204 Wellys, Thomas, of Bengeworth, baker 0
5531725 2514460 2514460 defendant Fulber John tanner 586204 586204 Fulber, John, of Bengeworth, tanner 0
5531727 2514461 2514461 defendant Fuller John tanner 586204 586204 Fuller, John, of Bengeworth, tanner 0
5566640 2524837 2524837 defendant Prosset or Proffet Thomas husbandman 586204 586204 Prosset or Proffet, Thomas, of Bengeworth, husbandman 1
5577852 2528144 2528144 defendant Phelps Edward husbandman 586204 586204 Phelps, Edward, of Bengeworth, husbandman 0
5590195 2531906 2531906 defendant Phylyps Edward husbandman 586204 586204 Phylyps, Edward, of Bengeworth, husbandman 2
5614522 2548339 2548339 defendant Parkare John dyer 586204 586204 Parkare, John, of Bengeworth, dyer 0
5637009 2555522 2555522 defendant Hobbes Richard husbandman 586204 586204 Hobbes, Richard, of Bengeworth, husbandman 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);