names

92 rows where place_id = 586752

✎ 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
3589530 1864362 1864362 defendant Prestgrave William yeoman 586752 586752 Prestgrave, William, of Gretton, yeoman 0
3612564 1871564 1871564 defendant Pykeryng John gent 586752 586752 Pykeryng, John, of Gretton, gent 0
3635825 1906005 1906005 defendant Burgh Richard clerk 586752 586752 Burgh, Richard, of Gretton, clerk 0
3635826 1906005 1906005 defendant Presgrave Robert yeoman 586752 586752 Presgrave, Robert, of Gretton, yeoman 1
3646086 1909174 1909174 defendant Crane John husbandman 586752 586752 Crane, John, of Gretton, husbandman 0
3665389 1915128 1915128 defendant Cokys Richard yeoman 586752 586752 Cokys, Richard, of Gretton, yeoman 0
3673483 1917731 1917731 defendant Hyckes Nicholas husbandman 586752 586752 Hyckes, Nicholas, of Gretton, husbandman 0
3698355 1925704 1925704 defendant Blakesley Robert husbandman 586752 586752 Blakesley, Robert, of Gretton, husbandman 3
3763781 1946317 1946317 defendant Pikeryng William husbandman 586752 586752 Pikeryng, William, of Gretton, husbandman 0
3771538 1948793 1948793 defendant Orton Thomas butcher 586752 586752 Orton, Thomas, of Gretton, butcher 0
3771539 1948793 1948793 defendant Drake John butcher 586752 586752 Drake, John, of Gretton, butcher 1
3777579 1950740 1950740 plaintiff Collet Henry   586752 586752 Collet, Henry, of Gretton 0
3785642 1953298 1953298 defendant Puttrell Robert yeoman 586752 586752 Puttrell, Robert, of Gretton, yeoman 1
3791945 1955328 1955328 defendant Crane John husbandman 586752 586752 Crane, John, of Gretton, husbandman 0
3793291 1955759 1955759 defendant Blakesley Robert husbandman 586752 586752 Blakesley, Robert, of Gretton, husbandman 0
3797732 1957189 1957189 defendant Derbye Ralph husbandman 586752 586752 Derbye, Ralph, of Gretton, husbandman 0
3798012 1957278 1957278 defendant Kempe Thomas husbandman 586752 586752 Kempe, Thomas, of Gretton, husbandman 0
3798013 1957278 1957278 defendant Derby Ralph husbandman 586752 586752 Derby, Ralph, of Gretton, husbandman 1
3799574 1957788 1957788 defendant Gudlefe William husbandman 586752 586752 Gudlefe, William, of Gretton, husbandman 0
3801931 1958503 1958503 defendant Crane John husbandman 586752 586752 Crane, John, of Gretton, husbandman 0
3809048 1960711 1960711 defendant Loverne Orwell laborer 586752 586752 Loverne, Orwell, of Gretton, laborer 0
3840061 1970461 1970461 defendant Irelond Oliver yeoman 586752 586752 Irelond, Oliver, of Gretton, yeoman 0
3855122 1975236 1975236 defendant Blakesley Robert husbandman 586752 586752 Blakesley, Robert, of Gretton, husbandman 0
3856857 1975772 1975772 defendant Puttrell Robert yeoman 586752 586752 Puttrell, Robert, of Gretton, yeoman 0
3865936 1978837 1978837 defendant Walker Thomas baker 586752 586752 Walker, Thomas, of Gretton, baker 2
3925033 1998689 1998689 defendant Rowlatt Robert husbandman 586752 586752 Rowlatt, Robert, of Gretton, husbandman 0
3958792 2010153 2010153 defendant Goodyere John weaver 586752 586752 Goodyere, John, of Gretton, weaver 0
3962209 2011364 2011364 defendant Walker Thomas baker 586752 586752 Walker, Thomas, of Gretton, baker 1
4017880 2031106 2031106 defendant Grenyng Thomas husbandman 586752 586752 Grenyng, Thomas, of Gretton, husbandman 1
4050492 2042603 2042603 defendant Blaxley Robert yeoman 586752 586752 Blaxley, Robert, of Gretton, yeoman 0
4056866 2044837 2044837 defendant Clenche George slater 586752 586752 Clenche, George, of Gretton, slater 0
4068041 2048875 2048875 defendant Coyfeld Thomas yeoman 586752 586752 Coyfeld, Thomas, of Gretton, yeoman 0
4070691 2049816 2049816 plaintiff Maydwell Lawrence yeoman 586752 586752 Maydwell, Lawrence, of Gretton, yeoman 0
4147055 2077114 2077114 defendant Whitwell Thomas yeoman 586752 586752 Whitwell, Thomas, of Gretton, yeoman 1
4157845 2080819 2080819 defendant Wyer William husbandman 586752 586752 Wyer, William, of Gretton, husbandman 0
4157847 2080820 2080820 defendant Wyer William husbandman 586752 586752 Wyer, William, of Gretton, husbandman 0
4238283 2109000 2109000 defendant Smythe Richard husbandman 586752 586752 Smythe, Richard, of Gretton, husbandman 0
4246722 2111882 2111882 defendant Smyth Richard husbandman 586752 586752 Smyth, Richard, of Gretton, husbandman 0
4281503 2123432 2123432 defendant Orton Thomas yeoman 586752 586752 Orton, Thomas, of Gretton, yeoman 1
4317098 2136095 2136095 defendant Peachey George Nhants, yeoman 586752 586752 Peachey George, of Gretton, Nhants, yeoman 0
4416080 2169913 2169913 defendant Freman Richard   586752 586752 Freman, Richard, of Gretton 0
4473680 2192411 2192411 defendant Farndon Thomas de   586752 586752 Farndon, Thomas de, of Gretton 1
4541048 2213108 2213108 defendant Wyntur Nicholas   586752 586752 Wyntur, Nicholas, of Gretton 0
4572536 2222945 2222945 plaintiff atte Welle Richard   586752 586752 atte Welle, Richard, of Gretton 3
4573058 2223109 2223109 defendant Ingelard John   586752 586752 Ingelard, John, of Gretton 2
4621920 2237835 2237835 defendant Bocher alias Stoke Thomas   586752 586752 Bocher alias Stoke, Thomas, of Gretton 2
4647721 2245392 2245392 plaintiff Smyth John   586752 586752 Smyth, John, of Gretton 0
4709664 2268388 2268388 defendant Dewale John husbandman 586752 586752 Dewale, John, of Gretton, husbandman 0
4709665 2268388 2268388 defendant Myntomor John husbandman 586752 586752 Myntomor, John, of Gretton, husbandman 1
4749741 2280403 2280403 defendant Gretton William gent 586752 586752 Gretton, William, of Gretton, gent 0
4754696 2281850 2281850 defendant Sauner John pardoner 586752 586752 Sauner, John, of Gretton, pardoner 0
4764421 2284860 2284860 defendant Whatton John laborer 586752 586752 Whatton, John, of Gretton, laborer 0
4774181 2287907 2287907 defendant Helpston Thomas husbandman 586752 586752 Helpston, Thomas, of Gretton, husbandman 1
4856951 2313552 2313552 defendant Teresholt Robert   586752 586752 Teresholt, Robert, of Gretton, mason 0
4875175 2319189 2319189 defendant Curteys John husbandman 586752 586752 Curteys, John, of Gretton, husbandman 0
4888816 2323293 2323293 defendant Kyrton Thomas yeoman 586752 586752 Kyrton, Thomas, of Gretton, yeoman 3
4890007 2323657 2323657 defendant Kyrton Thomas yeoman 586752 586752 Kyrton, Thomas, of Gretton, yeoman 3
4905504 2328319 2328319 defendant Drake John   586752 586752 Drake, John, of Gretton, "seweker" 0
5008258 2359305 2359305 defendant Colet Celia   586752 586752 Colet, Celia, of Gretton, widow, formerly wife of John Colet 0
5020909 2363012 2363012 defendant Milward Maurice husbandman 586752 586752 Milward, Maurice, of Gretton, husbandman 1
5038279 2368085 2368085 defendant Peresson Geoffrey   586752 586752 Peresson, Geoffrey, of Gretton, mason 2
5270923 2436590 2436590 defendant Norys John husbandman 586752 586752 Norys, John, of Gretton, husbandman 1
5270924 2436590 2436590 defendant Norys Thomas husbandman 586752 586752 Norys, Thomas, of Gretton, husbandman 2
5297053 2444133 2444133 defendant Sharp Roger yeoman 586752 586752 Sharp, Roger, of Gretton, yeoman 0
5316539 2450031 2450031 defendant Sharp Roger husbandman 586752 586752 Sharp, Roger, of Gretton, husbandman 1
5328235 2453520 2453520 defendant Sharp Roger yeoman 586752 586752 Sharp, Roger, of Gretton, yeoman 0
5336037 2455853 2455853 defendant Webster John husbandman 586752 586752 Webster, John, of Gretton, husbandman 4
5336656 2456033 2456033 defendant Jones Henry husbandman 586752 586752 Jones, Henry, of Gretton, husbandman 0
5344421 2458435 2458435 defendant Newenton John husbandman 586752 586752 Newenton, John, of Gretton, husbandman 0
5345486 2458760 2458760 defendant Jones Henry husbandman 586752 586752 Jones, Henry, of Gretton, husbandman 0
5348611 2459696 2459696 defendant Everodde William merchant 586752 586752 Everodde, William, of Gretton, merchant 0
5350416 2460252 2460252 defendant Derby Agnes widow 586752 586752 Derby, Agnes, of Gretton, widow 0
5375591 2467953 2467953 defendant Norrys Thomas husbandman 586752 586752 Norrys, Thomas, of Gretton, husbandman 1
5382367 2470015 2470015 defendant Payn John   586752 586752 Payn, John, of Gretton 1
5382368 2470015 2470015 defendant Eltham William husbandman 586752 586752 Eltham, William, of Gretton, husbandman 2
5391975 2472783 2472783 defendant Nor_ Thomas husbandman 586752 586752 Nor_, Thomas, of Gretton, husbandman 1
5405160 2476556 2476556 defendant Norrys Thomas husbandman 586752 586752 Norrys, Thomas, of Gretton, husbandman 1
5417981 2480304 2480304 defendant Norrys Thomas husbandman 586752 586752 Norrys, Thomas, of Gretton, husbandman 1
5441854 2487493 2487493 defendant Grevyng Thomas husbandman 586752 586752 Grevyng, Thomas, of Gretton, husbandman 1
5505820 2506742 2506742 defendant Goodyer William husbandman 586752 586752 Goodyer, William, of Gretton, husbandman 0
5511574 2508466 2508466 defendant Norys Thomas yeoman 586752 586752 Norys, Thomas, of Gretton, yeoman 0
5530284 2513981 2513981 defendant Swatton Humphrey husbandman 586752 586752 Swatton, Humphrey, of Gretton, husbandman 1
5530285 2513981 2513981 defendant Button William husbandman 586752 586752 Button, William, of Gretton, husbandman 2
5557774 2522223 2522223 defendant Teynton Thomas husbandman 586752 586752 Teynton, Thomas, of Gretton, husbandman 0
5579377 2528630 2528630 defendant Button William (legal representative) 586752 586752 Button, William, of Gretton, yeoman, executor of 0
5579378 2528630 2528630 defendant Button Henry yeoman 586752 586752 Button, Henry, of Gretton, yeoman 1
5581190 2529184 2529184 defendant Crane John husbandman 586752 586752 Crane, John, of Gretton, husbandman 0
5581746 2529370 2529370 defendant Blakesley Henry husbandman 586752 586752 Blakesley, Henry, of Gretton, husbandman 0
5581747 2529370 2529370 defendant Tyler John   586752 586752 Tyler, John, of Gretton miller 1
5595329 2533487 2533487 defendant Blakesley Henry husbandman 586752 586752 Blakesley, Henry, of Gretton, husbandman 0
5595330 2533487 2533487 defendant Tyller Clement husbandman 586752 586752 Tyller, Clement, of Gretton, husbandman 1
5609282 2537804 2537804 defendant ---ham (illegible) husbandman 586752 586752 ---ham, ---, of Gretton, husbandman 2

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