names

97 rows where place_id = 594960

✎ 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
3618275 1873343 1873343 plaintiff Gryggys William   594960 594960 Gryggys, William, of Hoxne 0
3618277 1873344 1873344 plaintiff Gryggys William   594960 594960 Gryggys, William, of Hoxne 0
3618279 1873345 1873345 plaintiff Gryggys William   594960 594960 Gryggys, William, of Hoxne 0
3640131 1907359 1907359 defendant Hatole Nicholas yeoman 594960 594960 Hatole, Nicholas, of Hoxne, yeoman 1
3653790 1911443 1911443 defendant Hatcle Nicholas yeoman 594960 594960 Hatcle, Nicholas, of Hoxne, yeoman 1
3678845 1919451 1919451 plaintiff Cantrell Ralph   594960 594960 Cantrell, Ralph, of Hoxne, notary public 1
3751441 1942368 1942368 plaintiff Dowe Bartholomew   594960 594960 Dowe, Bartholomew, of Hoxne 2
3776908 1950518 1950518 plaintiff Cantrell Ralph gent 594960 594960 Cantrell, Ralph, of Hoxne, gent 0
3838893 1970091 1970091 defendant Smyth Margaret widow 594960 594960 Smyth, Margaret, of Hoxne, widow 2
3876051 1982243 1982243 defendant Mundesforth John yeoman 594960 594960 Mundesforth, John, of Hoxne, yeoman 1
3910500 1993830 1993830 plaintiff Thurston John (legal representative) 594960 594960 Thurston, John, of Hoxne, executor of William Corbold, of Occolte, executor of 0
3919342 1996800 1996800 plaintiff Lacy Richard yeoman 594960 594960 Lacy, Richard, of Hoxne, yeoman 0
3922250 1997753 1997753 plaintiff Remchyng John gent 594960 594960 Remchyng, John, of Hoxne, gent 0
3924322 1998442 1998442 defendant Barker Peter yeoman 594960 594960 Barker, Peter, of Hoxne, yeoman 0
3973268 2015224 2015224 plaintiff Grene William husbandman 594960 594960 Grene, William, of Hoxne, husbandman 0
3973269 2015224 2015224 defendant Lacy Stephen gent 594960 594960 Lacy, Stephen, of Hoxne, gent 0
3976515 2016361 2016361 defendant Clarke Marharet widow 594960 594960 Clarke, Marharet, of Hoxne, widow 0
3976554 2016374 2016374 defendant Pickeren James   594960 594960 Pickeren, James, of Hoxne, surgeon 0
3976555 2016374 2016374 defendant Gislingham George tailor 594960 594960 Gislingham, George, of Hoxne, tailor 1
4008693 2027871 2027871 defendant Dyxe Augustine yeoman 594960 594960 Dyxe, Augustine, of Hoxne, yeoman 0
4040762 2039190 2039190 plaintiff Morffew Benedoict weaver 594960 594960 Morffew, Benedoict, of Hoxne, weaver 0
4040763 2039190 2039190 defendant Sherwood John, senior yeoman 594960 594960 Sherwood, John, senior, of Hoxne, yeoman 0
4092053 2057453 2057453 defendant Gislingham George tailor 594960 594960 Gislingham, George, of Hoxne, tailor 0
4092055 2057454 2057454 defendant Gislingham John yeoman 594960 594960 Gislingham, John, of Hoxne, yeoman 0
4106811 2062730 2062730 defendant Sadd George tailor 594960 594960 Sadd, George, of Hoxne, or of Stradbroke, tailor 0
4124423 2069030 2069030 defendant Sadd Gregory husbandman 594960 594960 Sadd, Gregory, of Hoxne, husbandman 1
4130756 2071311 2071311 defendant Gaym Godfrey yeoman 594960 594960 Gaym, Godfrey, of Hoxne, yeoman 0
4235377 2107941 2107941 defendant Kewe John tanner 594960 594960 Kewe, John, of Hoxne, tanner 1
4238848 2109209 2109209 defendant Goslinge John   594960 594960 Goslinge, John, of Hoxne, yeoman, scholar 2
4239626 2109488 2109488 defendant Mallynge John yeoman 594960 594960 Mallynge, John, of Hoxne, yeoman 0
4240546 2109821 2109821 defendant Kewe John tanner 594960 594960 Kewe, John, of Hoxne, tanner 0
4240549 2109821 2109821 defendant Payne Thomas butcher 594960 594960 Payne, Thomas, of Hoxne, butcher 3
4241881 2110276 2110276 defendant Yonge Prudence spinster 594960 594960 Yonge, Prudence, of Hoxne, spinster 3
4241914 2110286 2110286 defendant Yonge Prudence spinster 594960 594960 Yonge, Prudence, of Hoxne, spinster 3
4247318 2112078 2112078 defendant Payne Thomas butcher 594960 594960 Payne, Thomas, of Hoxne, butcher 2
4247933 2112293 2112293 defendant Mallynge John yeoman 594960 594960 Mallynge, John, of Hoxne, yeoman 0
4260810 2116580 2116580 defendant Gislingham Margaret widow 594960 594960 Gislingham, Margaret, of Hoxne, widow 3
4274081 2120878 2120878 defendant Payne Thomas butcher 594960 594960 Payne, Thomas, of Hoxne, butcher 0
4277446 2122034 2122034 defendant Gyslingham Nicholas yeoman 594960 594960 Gyslingham, Nicholas, of Hoxne, yeoman 0
4277447 2122034 2122034 defendant Mawelinge Isaac yeoman 594960 594960 Mawelinge, Isaac, of Hoxne, yeoman 1
4277582 2122082 2122082 defendant Gascowe or Gastowe Henry yeoman 594960 594960 Gascowe or Gastowe, Henry, of Hoxne, yeoman 1
4278154 2122295 2122295 defendant Saunderson Robert yeoman 594960 594960 Saunderson, Robert, of Hoxne, or of Denham, Suff, yeoman 0
4279117 2122626 2122626 defendant Sneace or Snesse William yeoman 594960 594960 Sneace or Snesse, William, of Hoxne, yeoman 0
4282484 2123774 2123774 defendant Sarrett Roger clerk 594960 594960 Sarrett, Roger, of Hoxne, or of Ockley, clerk 0
4282485 2123774 2123774 defendant Gislingham Margaret widow 594960 594960 Gislingham, Margaret, of Hoxne, widow 1
4285695 2124934 2124934 defendant Clarke John mercer 594960 594960 Clarke, John, of Hoxne, mercer 1
4303411 2131322 2131322 defendant Sanderson Robert yeoman 594960 594960 Sanderson, Robert, of Hoxne, yeoman 0
4304476 2131703 2131703 defendant Sanderson Robert yeoman 594960 594960 Sanderson, Robert, of Hoxne, yeoman 1
4307675 2132824 2132824 defendant Thurstone John, junior gent 594960 594960 Thurstone, John, junior, of Hoxne, gent 0
4310799 2133920 2133920 defendant Goslinge Robert tailor 594960 594960 Goslinge, Robert, of Hoxne, tailor 2
4325673 2138965 2138965 defendant Whytinge Walter yeoman 594960 594960 Whytinge, Walter, of Hoxne, yeoman 0
4325675 2138965 2138965 defendant Sanderson Robert yeoman 594960 594960 Sanderson, Robert, of Hoxne, yeoman 2
4325712 2138976 2138976 defendant Wright John husbandman 594960 594960 Wright, John, of Hoxne, husbandman 2
4326131 2139108 2139108 defendant Gislingham Nicholas yeoman 594960 594960 Gislingham, Nicholas, of Hoxne, yeoman 2
4326940 2139342 2139342 defendant Sanderson Robert yeoman 594960 594960 Sanderson, Robert, of Hoxne, yeoman 0
4326941 2139342 2139342 defendant Jewell Robert baker 594960 594960 Jewell, Robert, of Hoxne, baker 1
4327751 2139607 2139607 defendant Kewe John tanner 594960 594960 Kewe, John, of Hoxne, tanner 2
4327759 2139609 2139609 defendant Manby John tailor 594960 594960 Manby, John, of Hoxne, tailor 0
4327828 2139629 2139629 defendant Kewe John tanner 594960 594960 Kewe, John, of Hoxne, tanner 0
4332860 2141273 2141273 defendant Payne Thomas butcher 594960 594960 Payne, Thomas, of Hoxne, butcher 2
4334016 2141657 2141657 defendant Payne Thomas butcher 594960 594960 Payne, Thomas, of Hoxne, butcher 1
4337531 2142866 2142866 defendant Snease or Sneace William yeoman 594960 594960 Snease or Sneace, William, of Hoxne, yeoman 0
4352443 2148094 2148094 defendant Beamonde Henry   594960 594960 Beamonde, Henry, of Hoxne, linen weaver 2
4352444 2148094 2148094 defendant Lynsey Edward, senior husbandman 594960 594960 Lynsey, Edward, senior, of Hoxne, husbandman 3
4376546 2156680 2156680 defendant Lynsye Edward husbandman 594960 594960 together with Lynsye, Edward, of Hoxne, husbandman 1
4376548 2156681 2156681 defendant Lynsye Edward, senior husbandman 594960 594960 Lynsye, Edward, senior, of Hoxne, husbandman 0
4376551 2156682 2156682 defendant Beamond Henry   594960 594960 Beamond, Henry, of Hoxne, linen draper 0
4386991 2160305 2160305 defendant Tyler John yeoman 594960 594960 Tyler, John, of Hoxne, yeoman 0
4388780 2160880 2160880 defendant Goslyn Robert tailor 594960 594960 Goslyn, Robert, of Hoxne, tailor 1
4388781 2160880 2160880 defendant Peyne Thomas butcher 594960 594960 Peyne, Thomas, of Hoxne, butcher 2
4388782 2160880 2160880 defendant Baylye Mark husbandman 594960 594960 Baylye, Mark, of Hoxne, husbandman 3
4389894 2161243 2161243 defendant Dryver James drover 594960 594960 Dryver, James, of Hoxne, drover 2
4391542 2161783 2161783 defendant Fuller John yeoman 594960 594960 Fuller, John, of Hoxne, yeoman 3
4393604 2162464 2162464 defendant Thurston John gent 594960 594960 Thurston, John, of Hoxne, gent 1
4397806 2163844 2163844 defendant Kydman Richard husbandman 594960 594960 Kydman, Richard, of Hoxne, husbandman 0
4406910 2166876 2166876 defendant Fuller John yeoman 594960 594960 Fuller, John, of Hoxne, yeoman 1
4406911 2166876 2166876 defendant Lawter Nicholas cooper 594960 594960 Lawter, Nicholas, of Hoxne, cooper 2
4406912 2166876 2166876 defendant Jowell Robert husbandman 594960 594960 Jowell, Robert, of Hoxne, husbandman 3
4493297 2198608 2198608 defendant Thurston Thomas   594960 594960 Thurston, Thomas, of Hoxne 0
4498682 2200224 2200224 defendant Thruston Thomas   594960 594960 Thruston, Thomas, of Hoxne 1
4528806 2209293 2209293 defendant Harre John   594960 594960 Harre, John, of Hoxne 1
4555488 2217648 2217648 defendant Seman William   594960 594960 Seman, William, of Hoxne 2
4566740 2221171 2221171 defendant Barton John   594960 594960 Barton, John, of Hoxne, vicar 0
4569886 2222150 2222150 defendant Drury Roger   594960 594960 Drury, Roger, of Hoxne 2
4628688 2239897 2239897 defendant Blount Peter   594960 594960 Blount, Peter, of Hoxne 0
4656673 2247982 2247982 defendant Mannyng Thomas laborer 594960 594960 Mannyng, Thomas, of Hoxne, laborer 2
4712138 2269107 2269107 defendant Halle Walter   594960 594960 Halle, Walter, of Hoxne, vicar 3
4746315 2279418 2279418 defendant Stonham Thomas butcher 594960 594960 Stonham, Thomas, of Hoxne, butcher 0
4822054 2302974 2302974 defendant Wryght John husbandman 594960 594960 Wryght, John, of Hoxne, husbandman 0
4822055 2302974 2302974 defendant Everard Henry husbandman 594960 594960 Everard, Henry, of Hoxne, husbandman 1
4850730 2311681 2311681 defendant Corbald Nicholas tanner 594960 594960 Corbald, Nicholas, of Hoxne, tanner 0
5063285 2375550 2375550 defendant Pope John husbandman 594960 594960 Pope, John, of Hoxne, husbandman 0
5063286 2375550 2375550 defendant Wyot Edmund husbandman 594960 594960 Wyot, Edmund, of Hoxne, husbandman 1
5180291 2409974 2409974 plaintiff Bradfeld Henry   594960 594960 Bradfeld, Henry, of Hoxne 0
5202331 2416445 2416445 plaintiff Bradfeld Henry   594960 594960 Bradfeld, Henry, of Hoxne 0
5554632 2521384 2521384 defendant Smyth John yeoman 594960 594960 Smyth, John, of Hoxne, yeoman 7
5562855 2523725 2523725 defendant Cade John husbandman 594960 594960 Cade, John, of Hoxne, 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);