names

97 rows where place_id = 585863

✎ 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
3587383 1863695 1863695 defendant Fysshecok Robert clothmaker 585863 585863 Fysshecok, Robert, of Bedynden, clothmaker 0
3595342 1866175 1866175 defendant Colyer Richard clothmaker 585863 585863 Colyer, Richard, of Bedynden, clothmaker 0
3595345 1866176 1866176 defendant Colyer Richard clothmaker 585863 585863 Colyer, Richard, of Bedynden, clothmaker 0
3595348 1866177 1866177 defendant Fysshecok Robert clothmaker 585863 585863 Fysshecok, Robert, of Bedynden, clothmaker 0
3597693 1866904 1866904 defendant Premer James laborer 585863 585863 Premer, James, of Bedynden, laborer 1
3597767 1866920 1866920 defendant Colyar Richard clothmaker 585863 585863 Colyar, Richard, of Bedynden, clothmaker 1
3603678 1868819 1868819 defendant Taillour William husbandman 585863 585863 Taillour, William, of Bedynden, husbandman 0
3608311 1870257 1870257 defendant Jurden William clothmaker 585863 585863 Jurden, William, of Bedynden, clothmaker 0
3618286 1873347 1873347 defendant Colear Richard clothmaker 585863 585863 Colear, Richard, of Bedynden, clothmaker 1
3620802 1874076 1874076 defendant Coliar Richard clothman 585863 585863 Coliar, Richard, of Bedynden, clothman 0
3622667 1874619 1874619 defendant Morley John draper 585863 585863 Morley, John, of Bedynden, draper 1
3623310 1874817 1874817 defendant Pette John clothmaker 585863 585863 Pette, John, of Bedynden, clothmaker 0
3624327 1875142 1875142 defendant Pellond John clothmaker 585863 585863 Pellond, John, of Bedynden, clothmaker 3
3624334 1875145 1875145 plaintiff Taylour Thomas   585863 585863 Taylour, Thomas, of Bedynden 0
3625600 1875539 1875539 defendant Bone William husbandman 585863 585863 Bone, William, of Bedynden, husbandman 0
3625601 1875539 1875539 defendant Dogett John wheeler 585863 585863 Dogett, John, of Bedynden, wheeler 1
3634487 1905587 1905587 plaintiff Meryell Henry   585863 585863 Meryell, Henry, of Bedynden 0
3638196 1906764 1906764 defendant Taylour Alice widow 585863 585863 Taylour, Alice, of Bedynden, widow 0
3646913 1909433 1909433 defendant French John laborer 585863 585863 French, John, of Bedynden, laborer 0
3646914 1909433 1909433 defendant Beald John carpenter 585863 585863 Beald, John, of Bedynden, carpenter 1
3664720 1914917 1914917 defendant Meraill Henry yeoman 585863 585863 Meraill, Henry, of Bedynden, yeoman 3
3664721 1914917 1914917 defendant French William yeoman 585863 585863 French, William, of Bedynden, yeoman 4
3667889 1915897 1915897 defendant Edynden James fuller 585863 585863 Edynden, James, of Bedynden, fuller 0
3677220 1918920 1918920 plaintiff Lechynden John   585863 585863 Lechynden, John, of Bedynden, cloth maker 0
3688137 1922441 1922441 defendant Horden John wheeler 585863 585863 Horden, John, of Bedynden, wheeler 2
3692188 1923724 1923724 defendant Lilly Thomas yeoman 585863 585863 Lilly, Thomas, of Bedynden, yeoman 0
3692189 1923724 1923724 defendant Andrewe Stephen laborer 585863 585863 Andrewe, Stephen, of Bedynden, laborer 1
3692190 1923724 1923724 defendant Brekynden Robert laborer 585863 585863 Brekynden, Robert, of Bedynden, laborer 2
3692191 1923724 1923724 defendant Sym John laborer 585863 585863 Sym, John, of Bedynden, laborer 3
3703867 1927487 1927487 defendant A Crouche Roger butcher 585863 585863 A Crouche, Roger, of Bedynden, butcher 0
3709378 1929231 1929231 defendant Morlen John butcher 585863 585863 Morlen, John, of Bedynden, butcher 0
3718484 1932059 1932059 defendant Stace Thomas yeoman 585863 585863 Stace, Thomas, of Bedynden, yeoman 4
3726255 1934478 1934478 defendant Brekenden Stephen yeoman 585863 585863 Brekenden, Stephen, of Bedynden, yeoman 0
3758288 1944587 1944587 defendant Bresenden Thomas husbandman 585863 585863 Bresenden, Thomas, of Bedynden, husbandman 2
3766682 1947241 1947241 plaintiff Mayny John gent 585863 585863 Mayny, John, of Bedynden, gent 0
3766687 1947242 1947242 plaintiff Mayny John gent 585863 585863 Mayny, John, of Bedynden, gent 0
3779045 1951169 1951169 defendant Tayllour Robert yeoman 585863 585863 Tayllour, Robert, of Bedynden, yeoman 0
3856589 1975687 1975687 defendant Meyney John gent 585863 585863 Meyney, John, of Bedynden, gent 0
4542919 2213678 2213678 defendant Spyser John   585863 585863 Spyser, John, of Bedynden 3
4576549 2224175 2224175 defendant Capell Stephen   585863 585863 Capell, Stephen, of Bedynden 4
4669669 2256216 2256216 defendant Bethyston Lawrence gent 585863 585863 Bethyston, Lawrence, of Bedynden, gent 0
4669670 2256216 2256216 defendant Wytherynden Henry barber 585863 585863 Wytherynden, Henry, of Bedynden, barber 1
4669671 2256216 2256216 defendant Stevene Thomas carpenter 585863 585863 Stevene, Thomas, of Bedynden, carpenter 2
4669672 2256216 2256216 defendant Bourne John laborer 585863 585863 Bourne, John, of Bedynden, laborer 3
4678827 2258982 2258982 defendant Elys Alan husbandman 585863 585863 Elys, Alan, of Bedynden, husbandman 1
4689528 2262282 2262282 defendant Roger Richard laborer 585863 585863 Roger, Richard, of Bedynden, laborer 0
4703646 2266518 2266518 defendant Elys Alan husbandman 585863 585863 Elys, Alan, of Bedynden, husbandman 1
4727497 2273843 2273843 defendant Elys Alan husbandman 585863 585863 Elys, Alan, of Bedynden, husbandman 0
4727614 2273877 2273877 defendant Elys Alan husbandman 585863 585863 Elys, Alan, of Bedynden, husbandman 1
4727620 2273878 2273878 defendant Elys Alan husbandman 585863 585863 Elys, Alan, of Bedynden, husbandman 1
4730924 2274869 2274869 defendant Pencrovne Thomas husbandman 585863 585863 Pencrovne, Thomas, of Bedynden, husbandman 0
4774422 2287983 2287983 defendant Ricard Richard laborer 585863 585863 Ricard, Richard, of Bedynden, laborer 1
4783745 2290938 2290938 defendant Odierne Thomas husbandman 585863 585863 Odierne, Thomas, of Bedynden, husbandman 1
4906824 2328718 2328718 defendant Igoldyngden William husbandman 585863 585863 Igoldyngden, William, of Bedynden, husbandman 0
4933041 2336723 2336723 defendant Harry Thomas hosier 585863 585863 Harry, Thomas, of Bedynden, hosier 2
4948819 2341613 2341613 defendant Ketelysden Stephen laborer 585863 585863 Ketelysden, Stephen, of Bedynden, laborer 0
4962075 2345563 2345563 defendant Gebon William husbandman 585863 585863 Gebon, William, of Bedynden, husbandman 1
4969950 2347960 2347960 defendant Quynchaunt John fuller 585863 585863 Quynchaunt, John, of Bedynden, fuller 0
5075562 2379189 2379189 plaintiff Amyot William (legal representative) 585863 585863 Amyot, William, of Bedynden, executors of 0
5084800 2381959 2381959 defendant Edynden William husbandman 585863 585863 Edynden, William, of Bedynden, husbandman 1
5084801 2381959 2381959 defendant Edynden John, senior husbandman 585863 585863 Edynden, John, senior, of Bedynden, husbandman 2
5084802 2381959 2381959 defendant Edynden John, junior laborer 585863 585863 Edynden, John, junior, of Bedynden, laborer 3
5267147 2435483 2435483 defendant Elys Richard fuller 585863 585863 Elys, Richard, of Bedynden, fuller 1
5308884 2447699 2447699 defendant Brekynden James smith 585863 585863 Brekynden, James, of Bedynden, smith 1
5358495 2462713 2462713 defendant Brekynden John laborer 585863 585863 Brekynden, John, of Bedynden, laborer 0
5358497 2462714 2462714 defendant Brekynden Walter laborer 585863 585863 Brekynden, Walter, of Bedynden, laborer 0
5361483 2463614 2463614 defendant Gebon John husbandman 585863 585863 Gebon, John, of Bedynden, husbandman 2
5377460 2468533 2468533 defendant Materas Thomas butcher 585863 585863 Materas, Thomas, of Bedynden, butcher 2
5399486 2474932 2474932 defendant Taillour Walter husbandman 585863 585863 Taillour, Walter, of Bedynden, husbandman 0
5427288 2483106 2483106 defendant Taillour Walter husbandman 585863 585863 (Taillour, Walter, of Bedynden, husbandman 1
5427292 2483107 2483107 defendant Taillour Walter husbandman 585863 585863 (Taillour, Walter, of Bedynden, husbandman 1
5427297 2483108 2483108 defendant Taillour Walter husbandman 585863 585863 together with Taillour, Walter, of Bedynden, husbandman 2
5445114 2488426 2488426 defendant Taylour Walter husbandman 585863 585863 (Taylour, Walter, of Bedynden, husbandman 1
5494719 2503309 2503309 defendant Bone Robert laborer 585863 585863 Bone, Robert, of Bedynden, laborer 2
5509354 2507776 2507776 defendant Brekynden John husbandman 585863 585863 Brekynden, John, of Bedynden, husbandman 3
5515312 2509635 2509635 defendant Colyer Richard clothmaker 585863 585863 Colyer, Richard, of Bedynden, clothmaker 0
5526802 2512951 2512951 defendant Tailloure William yeoman 585863 585863 Tailloure, William, of Bedynden, yeoman 0
5526806 2512952 2512952 defendant Tayloure William yeoman 585863 585863 Tayloure, William, of Bedynden, yeoman 0
5533432 2515008 2515008 defendant Best John clothier 585863 585863 Best, John, of Bedynden, clothier 0
5534107 2515204 2515204 defendant Byshop Thomas potter 585863 585863 Byshop, Thomas, of Bedynden, potter 0
5536943 2516041 2516041 defendant Wilcok Thomas husbansdman 585863 585863 Wilcok, Thomas, of Bedynden, husbansdman 3
5536944 2516041 2516041 defendant Wilcok Edward husbansdman 585863 585863 Wilcok, Edward, of Bedynden, husbansdman 4
5538592 2516551 2516551 defendant Bysshoppe Thomas husbandman 585863 585863 Bysshoppe, Thomas, of Bedynden, husbandman 0
5538593 2516551 2516551 defendant Bysshoppe John clothmaker 585863 585863 Bysshoppe, John, of Bedynden, clothmaker 1
5539539 2516842 2516842 defendant Henton John laborer 585863 585863 Henton, John, of Bedynden, laborer 0
5539540 2516842 2516842 defendant Bunce John laborer 585863 585863 Bunce, John, of Bedynden, laborer 1
5547766 2519362 2519362 defendant Best John clothier 585863 585863 Best, John, of Bedynden, clothier 0
5547767 2519362 2519362 defendant Colyer Richard clothier 585863 585863 Colyer, Richard, of Bedynden, clothier 1
5552312 2520725 2520725 defendant Fysschecok Robert clothmaker 585863 585863 Fysschecok, Robert, of Bedynden, clothmaker 0
5553406 2521038 2521038 defendant Wode Martin weaver 585863 585863 Wode, Martin, of Bedynden, weaver 0
5558278 2522372 2522372 defendant Frensshe William clothmaker 585863 585863 Frensshe, William, of Bedynden, clothmaker 0
5559827 2522833 2522833 defendant Fysschkok Robert clothmaker 585863 585863 Fysschkok, Robert, of Bedynden, clothmaker 0
5559829 2522834 2522834 defendant Patynden William clothmaker 585863 585863 Patynden, William, of Bedynden, clothmaker 0
5560869 2523151 2523151 defendant Mendeham John tailor 585863 585863 Mendeham, John, of Bedynden, tailor 0
5566955 2524930 2524930 defendant Fysshcok Robert yeoman 585863 585863 Fysshcok, Robert, of Bedynden, yeoman 0
5575333 2527374 2527374 defendant Joce Robert clothmaker 585863 585863 Joce, Robert, of Bedynden, clothmaker 3
5590690 2532061 2532061 defendant Joce Robert clothmkaer 585863 585863 Joce, Robert, of Bedynden, clothmkaer 1

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