names

212 rows where place_id = 593634

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612659 1871600 1871600 defendant Thorney Thomas miller 593634 593634 Thorney, Thomas, of Berkeley, miller 0
3637008 1906372 1906372 defendant Laurence William gent 593634 593634 Laurence, William, of Berkeley, gent 0
3648994 1910074 1910074 defendant Holcroft Hugh yeoman 593634 593634 Holcroft, Hugh, of Berkeley, yeoman 4
3656018 1912136 1912136 defendant Johnson William walker 593634 593634 Johnson, William, of Berkeley, walker 0
3656019 1912136 1912136 defendant Sevage Thomas husbandman 593634 593634 Sevage, Thomas, of Berkeley, husbandman 1
3668380 1916058 1916058 defendant Cornoke Maurice husbandman 593634 593634 Cornoke, Maurice, of Berkeley, husbandman 2
3668383 1916059 1916059 defendant Cornoke Maurice husbandman 593634 593634 Cornoke, Maurice, of Berkeley, husbandman 1
3668385 1916060 1916060 defendant Cornose Maurice husbandman 593634 593634 Cornose, Maurice, of Berkeley, husbandman 0
3676918 1918819 1918819 defendant Smyth John butcher 593634 593634 Smyth, John, of Berkeley, butcher 0
3714564 1930853 1930853 defendant Smyth John butcher 593634 593634 Smyth, John, of Berkeley, butcher 2
3734212 1936941 1936941 defendant Parker Thomas weaver 593634 593634 Parker, Thomas, of Berkeley, weaver 0
3809120 1960736 1960736 defendant Lenny John husbandman 593634 593634 Lenny, John, of Berkeley, husbandman 0
3809121 1960736 1960736 defendant Baker John husbandman 593634 593634 Baker, John, of Berkeley, husbandman 1
3809628 1960898 1960898 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
3831354 1967694 1967694 defendant Clutterbuke William husbandman 593634 593634 Clutterbuke, William, of Berkeley, husbandman 0
3838782 1970057 1970057 defendant Sutton John innholder 593634 593634 Sutton, John, of Berkeley, innholder 0
3846763 1972540 1972540 defendant Cluterbuke William husbandman 593634 593634 Cluterbuke, William, of Berkeley, husbandman 0
3897128 1989257 1989257 plaintiff Welshe Richard (legal representative) 593634 593634 Welshe, Richard, of Berkeley, gent, executor of 0
3897131 1989258 1989258 plaintiff Welshe Richard (legal representative) 593634 593634 Welshe, Richard, of Berkeley, gent, executor of 0
3897134 1989259 1989259 plaintiff Welshe Richard (legal representative) 593634 593634 Welshe, Richard, of Berkeley, gent, executor of 0
3897137 1989260 1989260 plaintiff Welshe Richard (legal representative) 593634 593634 Welshe, Richard, of Berkeley, gent, executor of 0
3897140 1989261 1989261 plaintiff Welshe Richard (legal representative) 593634 593634 Welshe, Richard, of Berkeley, gent, executor of 0
3897143 1989262 1989262 plaintiff Welshe Richard (legal representative) 593634 593634 Welshe, Richard, of Berkeley, gent, executor of 0
3897146 1989263 1989263 plaintiff Welshe Richard (legal representative) 593634 593634 Welshe, Richard, of Berkeley, gent, executor of 0
3897149 1989264 1989264 plaintiff Welshe Richard (legal representative) 593634 593634 Welshe, Richard, of Berkeley, gent, executor of 0
3979695 2017491 2017491 defendant Gryffyn Richard yeoman 593634 593634 Gryffyn, Richard, of Berkeley, yeoman 1
4169530 2084846 2084846 defendant Bowlton Thomas innholder 593634 593634 Bowlton, Thomas, of Berkeley, innholder 0
4169531 2084846 2084846 defendant Teyfan or Teysan James husbandman 593634 593634 Teyfan or Teysan, James, of Berkeley, husbandman 1
4369663 2154204 2154204 defendant Lawrence James gent 593634 593634 Lawrence, James, of Berkeley, gent 0
4369678 2154210 2154210 defendant Bower William yeoman 593634 593634 Bower, William, of Berkeley, yeoman 0
4398954 2164233 2164233 defendant Atkyns William yeoman 593634 593634 Atkyns, William, of Berkeley, yeoman 0
4468011 2190666 2190666 defendant Pattare William   593634 593634 Pattare, William, of Berkeley 1
4468847 2190932 2190932 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4468849 2190933 2190933 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4511440 2204021 2204021 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4511443 2204022 2204022 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4511446 2204023 2204023 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4511448 2204024 2204024 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4511450 2204025 2204025 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4511452 2204026 2204026 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4574443 2223536 2223536 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4574445 2223537 2223537 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4607488 2233453 2233453 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4610917 2234487 2234487 defendant Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4630150 2240341 2240341 defendant Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4636909 2242356 2242356 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4636911 2242357 2242357 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4636916 2242358 2242358 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4653763 2247096 2247096 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4653783 2247097 2247097 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4653786 2247098 2247098 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4727466 2273833 2273833 defendant Trebell John mainer 593634 593634 Trebell, John, of Berkeley, mainer 3
4745533 2279205 2279205 defendant Timbrell John   593634 593634 Timbrell, John, of Berkeley, vicar 0
4751849 2281034 2281034 defendant Sparwe John husbandman 593634 593634 Sparwe, John, of Berkeley, husbandman 3
4754616 2281827 2281827 defendant Warde Richard clerk 593634 593634 Warde, Richard, of Berkeley, clerk 0
4754618 2281827 2281827 defendant Astour Richard tanner 593634 593634 Astour, Richard, of Berkeley, tanner 2
4771111 2286947 2286947 defendant Hoper Walter   593634 593634 Hoper, Walter, of Berkeley, hoop maker 1
4772596 2287398 2287398 defendant Warde Richard clerk 593634 593634 Warde, Richard, of Berkeley, clerk 2
4774759 2288097 2288097 defendant Giton Richard yeoman 593634 593634 Giton, Richard, of Berkeley, yeoman 0
4780387 2289864 2289864 defendant de Berkeley James esq 593634 593634 de Berkeley, James, of Berkeley, esq 0
4783426 2290834 2290834 defendant Ecton Richard yeoman 593634 593634 Ecton, Richard, of Berkeley, yeoman 0
4790105 2292982 2292982 defendant Oldeman John brewer 593634 593634 Oldeman, John, of Berkeley, brewer 0
4790106 2292982 2292982 defendant Pakker Adam packer 593634 593634 Pakker, Adam, of Berkeley, packer 1
4803338 2297236 2297236 defendant Doby William mariner 593634 593634 Doby, William, of Berkeley, mariner 0
4803340 2297236 2297236 defendant russell Thomas husbandman 593634 593634 russell, Thomas, of Berkeley, husbandman 2
4803698 2297339 2297339 defendant Oldelond John husbandman 593634 593634 Oldelond, John, of Berkeley, husbandman 0
4810111 2299314 2299314 defendant Mayew alias Mayhowe John dyer & husbandman 593634 593634 Mayew alias Mayhowe, John, of Berkeley, dyer & husbandman 0
4817281 2301497 2301497 defendant Trebole John merchant 593634 593634 Trebole, John, of Berkeley, merchant 0
4827363 2304605 2304605 defendant Trebele John merchant 593634 593634 Trebele, John, of Berkeley, merchant 0
4831309 2305823 2305823 defendant Bruton William yeoman 593634 593634 Bruton, William, of Berkeley, yeoman 0
4832942 2306323 2306323 plaintiff Chapman Adam   593634 593634 Chapman, Adam, of Berkeley 0
4838311 2307898 2307898 defendant Berkeley James   593634 593634 Berkeley, James, of Berkeley, lord & knight 0
4845452 2310090 2310090 defendant Berkeley James   593634 593634 Berkeley, James, of Berkeley, knight 0
4854160 2312710 2312710 defendant Packer Thomas chapman 593634 593634 Packer, Thomas, of Berkeley, chapman 1
4863630 2315595 2315595 defendant Whithed John waterman 593634 593634 Whithed, John, of Berkeley, waterman 1
4865182 2316086 2316086 defendant Russell Thomas singleman 593634 593634 Russell, Thomas, of Berkeley, singleman 0
4872400 2318330 2318330 defendant Taylour John boatman 593634 593634 Taylour, John, of Berkeley, boatman 0
4872667 2318402 2318402 defendant Russell Thomas laborer 593634 593634 Russell, Thomas, of Berkeley, laborer 0
4873751 2318728 2318728 defendant Trebell John chaplain 593634 593634 Trebell, John, of Berkeley, chaplain 0
4875378 2319255 2319255 defendant atte Welle John husbandman 593634 593634 atte Welle, John, of Berkeley, husbandman 2
4878364 2320180 2320180 defendant Wylkyns John husbandman 593634 593634 (Wylkyns, John, of Berkeley, husbandman 1
4882040 2321283 2321283 defendant Packer Thomas chapman 593634 593634 Packer, Thomas, of Berkeley, chapman 0
4882207 2321339 2321339 defendant Berkeley James   593634 593634 Berkeley, James, of Berkeley, knight 0
4882217 2321344 2321344 defendant Berkeley James   593634 593634 Berkeley, James, of Berkeley, knight 0
4890156 2323694 2323694 defendant Clyfford Thomas merchant 593634 593634 Clyfford, Thomas, of Berkeley, merchant 0
4894341 2324910 2324910 defendant Browederer Richard embroiderer 593634 593634 Browederer, Richard, of Berkeley, embroiderer 1
4895013 2325107 2325107 defendant Berkeley James   593634 593634 Berkeley, James, of Berkeley, knight 0
4902800 2327494 2327494 defendant Clyfford Thomas merchant 593634 593634 Clyfford, Thomas, of Berkeley, merchant 0
4902802 2327495 2327495 defendant Clyfford Thomas merchant 593634 593634 Clyfford, Thomas, of Berkeley, merchant 0
4910397 2329768 2329768 defendant Ranes John chaplain 593634 593634 Ranes, John, of Berkeley, chaplain 1
4915154 2331247 2331247 defendant Clyfford Thomas merchant 593634 593634 Clyfford, Thomas, of Berkeley, merchant 3
4915159 2331248 2331248 defendant Clyfford Thomas merchant 593634 593634 Clyfford, Thomas, of Berkeley, merchant 3
4929113 2335526 2335526 defendant Strange Robert husbandman 593634 593634 Strange, Robert, of Berkeley, husbandman 0
4932564 2336580 2336580 defendant Grevell John, junior gent 593634 593634 Grevell, John, junior, of Berkeley, gent 0
4932565 2336580 2336580 defendant Berkeley James   593634 593634 with Berkeley, James, of Berkeley, knight 1
4932566 2336580 2336580 defendant Boys William yeoman 593634 593634 Boys, William, of Berkeley, yeoman 2
4932567 2336580 2336580 defendant Everard Thomas yeoman 593634 593634 Everard, Thomas, of Berkeley, yeoman 3
4932568 2336580 2336580 defendant Lee Richard yeoman 593634 593634 Lee, Richard, of Berkeley, yeoman 4
4932569 2336580 2336580 defendant Barbour John yeoman 593634 593634 Barbour, John, of Berkeley, yeoman 5
4932570 2336580 2336580 defendant de Foreste John yeoman 593634 593634 de Foreste, John, of Berkeley, yeoman 6

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