names

145 rows where place_id = 596792

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626198 1903052 1903052 defendant FitzWilliam Thomas gent 596792 596792 FitzWilliam, Thomas, of Horncastell, gent 0
3675908 1918501 1918501 defendant Newell Henry chaplain 596792 596792 Newell, Henry, of Horncastell, chaplain 0
3681428 1920278 1920278 defendant Barowes Ralph gent 596792 596792 Barowes, Ralph, of Horncastell, gent 0
3681430 1920279 1920279 defendant Bullok John yeoman 596792 596792 Bullok, John, of Horncastell, yeoman 0
3681432 1920280 1920280 defendant West James yeoman 596792 596792 West, James, of Horncastell, yeoman 0
3681434 1920281 1920281 defendant West James yeoman 596792 596792 West, James, of Horncastell, yeoman 0
3686039 1921793 1921793 defendant Goodwyn John   596792 596792 Goodwyn, John, of Horncastell, fish driver 0
3686731 1922005 1922005 plaintiff Bullok John   596792 596792 Bullok, John, of Horncastell 0
3703820 1927474 1927474 defendant Cooke John tanner 596792 596792 Cooke, John, of Horncastell, tanner 0
3711594 1929935 1929935 defendant Kyrke Richard tanner 596792 596792 Kyrke, Richard, of Horncastell, tanner 0
3714034 1930688 1930688 defendant Barwys Ralph yeoman of the king 596792 596792 Barwys, Ralph, of Horncastell, yeoman of the king 0
3715644 1931181 1931181 defendant Fayerbarne Thomas miller 596792 596792 Fayerbarne, Thomas, of Horncastell, miller 1
3722147 1933189 1933189 defendant Pasley William mercer 596792 596792 Pasley, William, of Horncastell, mercer 0
3736638 1937710 1937710 defendant Barwys Ralph   596792 596792 Barwys, Ralph, of Horncastell, yeoman, king's coroner 0
3781557 1951967 1951967 defendant Bosse Alexander glover 596792 596792 Bosse, Alexander, of Horncastell, glover 0
3782988 1952428 1952428 defendant Poye John husbandman 596792 596792 Poye, John, of Horncastell, husbandman 0
3787793 1953971 1953971 defendant Wytton Richard dyer 596792 596792 Wytton, Richard, of Horncastell, dyer 0
3830944 1967561 1967561 defendant Wiberd Gilbert butcher 596792 596792 Wiberd, Gilbert, of Horncastell, butcher 0
3833805 1968505 1968505 plaintiff Madynwell John   596792 596792 Madynwell, John, of Horncastell 0
3838516 1969971 1969971 defendant Wryght Robert carpenter 596792 596792 Wryght, Robert, of Horncastell, carpenter 0
3844181 1971730 1971730 defendant Wright Robert carpenter 596792 596792 Wright, Robert, of Horncastell, carpenter 0
3849839 1973535 1973535 plaintiff Madynwell John   596792 596792 Madynwell, John, of Horncastell 0
3850368 1973704 1973704 defendant Bullok John (legal representative) 596792 596792 Bullok, John, of Horncastell, draper, administrator of Wylkynson, Thomas, of Horncastell, executors of 0
3861886 1977435 1977435 defendant Wylberd Gilbert   596792 596792 Wylberd, Gilbert, of Horncastell, butcher, administrators of 0
3861887 1977435 1977435 defendant Wylberd Anne widow 596792 596792 (Wylberd, Anne, of Horncastell, widow 1
3862372 1977606 1977606 defendant Benson John draper 596792 596792 Benson, John, of Horncastell, draper 0
3862373 1977606 1977606 defendant Cowper Edward saddler 596792 596792 Cowper, Edward, of Horncastell, saddler 1
3878880 1983187 1983187 defendant Barker John blacksmith 596792 596792 Barker, John, of Horncastell, blacksmith 0
3878881 1983187 1983187 defendant Long Thomas butcher 596792 596792 Long, Thomas, of Horncastell, butcher 1
3882093 1984268 1984268 plaintiff Stephanson Thomas gent 596792 596792 Stephanson, Thomas, of Horncastell, gent 0
3882094 1984268 1984268 defendant Lovell Oliver yeoman 596792 596792 Lovell, Oliver, of Horncastell, yeoman 0
3888328 1986359 1986359 defendant Fitzwilliam Thomas gent 596792 596792 Fitzwilliam, Thomas, of Horncastell, gent 1
3901207 1990629 1990629 defendant Coke Richard butcher 596792 596792 Coke, Richard, of Horncastell, butcher 0
3922928 1997973 1997973 plaintiff Scrop Robert   596792 596792 Scrop, Robert, of Horncastell 0
3925255 1998757 1998757 defendant FitzWilliam Thomas yeoman 596792 596792 (FitzWilliam, Thomas, of Horncastell, yeoman 4
3931864 2000956 2000956 defendant Sergiante William glover 596792 596792 Sergiante, William, of Horncastell, glover 0
3951086 2007446 2007446 defendant Coulton Cuthbert glover 596792 596792 Coulton, Cuthbert, of Horncastell, glover 0
3951087 2007446 2007446 defendant Enderby Ralph glover 596792 596792 Enderby, Ralph, of Horncastell, glover 1
3963152 2011712 2011712 defendant Kyrke Richard husbandman 596792 596792 Kyrke, Richard, of Horncastell, husbandman 0
3978063 2016903 2016903 defendant Stevenson John gent 596792 596792 Stevenson, John, of Horncastell, gent 0
4049625 2042304 2042304 defendant Pecocke William yeoman 596792 596792 Pecocke, William, of Horncastell, yeoman 0
4056227 2044612 2044612 defendant Tesshe Lancelot gent 596792 596792 Tesshe, Lancelot, of Horncastell, gent 0
4059723 2045872 2045872 defendant Rathbecke Dorothy widow 596792 596792 Rathbecke, Dorothy, of Horncastell, widow 1
4064718 2047671 2047671 plaintiff Hamerton Gregory   596792 596792 Hamerton, Gregory, of Horncastell, woollen draper 0
4086357 2055396 2055396 defendant Tesshe Lancelot gent 596792 596792 Tesshe, Lancelot, of Horncastell, gent 0
4086359 2055396 2055396 defendant Shake Robert yeoman 596792 596792 Shake, Robert, of Horncastell, yeoman 2
4089420 2056502 2056502 defendant Thompson William yeoman 596792 596792 Thompson, William, of Horncastell, yeoman 3
4097317 2059358 2059358 defendant Elsey George mercer 596792 596792 Elsey, George, of Horncastell, mercer 1
4105026 2062071 2062071 defendant Bones Thomas tinker 596792 596792 Bones, Thomas, of Horncastell, or of Connysbye, tinker 0
4108032 2063147 2063147 defendant Morton William (legal representative) 596792 596792 Morton, William, of Horncastell, tailor, administratrix of 0
4108033 2063147 2063147 defendant Morton Katherine widow 596792 596792 Morton, Katherine, of Horncastell, widow 1
4120972 2067790 2067790 defendant Hamerton Gregoty draper 596792 596792 Hamerton, Gregoty, of Horncastell, draper 0
4124057 2068903 2068903 defendant Salmon Bartholomew yeoman 596792 596792 Salmon, Bartholomew, of Horncastell, yeoman 0
4124059 2068904 2068904 defendant Salmon Bartholomew yeoman 596792 596792 Salmon, Bartholomew, of Horncastell, yeoman 0
4125702 2069474 2069474 defendant Hamerton George   596792 596792 Hamerton, George, of Horncastell, woollen draper 0
4125703 2069474 2069474 defendant Hamerton John tanner 596792 596792 Hamerton, John, of Horncastell, tanner 1
4129985 2071028 2071028 defendant Metcalfe Michael yeoman 596792 596792 Metcalfe, Michael, of Horncastell, yeoman 1
4132885 2072090 2072090 defendant Neale John tanner 596792 596792 Neale, John, of Horncastell, tanner 2
4132891 2072091 2072091 defendant Neale John tanner 596792 596792 Neale, John, of Horncastell, tanner 2
4132897 2072092 2072092 defendant Neale John tanner 596792 596792 Neale, John, of Horncastell, tanner 2
4132903 2072093 2072093 defendant Neale John tanner 596792 596792 Neale, John, of Horncastell, tanner 2
4137389 2073721 2073721 defendant Hamerton George draper 596792 596792 Hamerton, George, of Horncastell, draper 1
4170214 2085079 2085079 defendant Sherwyn John yeoman 596792 596792 Sherwyn, John, of Horncastell, yeoman 1
4178229 2087860 2087860 defendant Hamerton Gregory draper 596792 596792 Hamerton, Gregory, of Horncastell, draper 0
4181793 2089113 2089113 defendant Robson William   596792 596792 Robson, William, of Horncastell, wheelwright 1
4187501 2091127 2091127 defendant Elvyn Thomas yeoman 596792 596792 Elvyn, Thomas, of Horncastell, yeoman 0
4188513 2091456 2091456 defendant Tasshe Lancelot yeoman 596792 596792 Tasshe, Lancelot, of Horncastell, yeoman 0
4198248 2094935 2094935 defendant Hamerton Gregory draper 596792 596792 Hamerton, Gregory, of Horncastell, draper 1
4215752 2101006 2101006 defendant Fulshawe William yeoman 596792 596792 Fulshawe, William, of Horncastell, yeoman 0
4232587 2106900 2106900 defendant Blaysdun or Playsdon Richard yeoman 596792 596792 Blaysdun or Playsdon, Richard, of Horncastell, yeoman 1
4234622 2107656 2107656 defendant Ashton James Master of Arts 596792 596792 Ashton, James, of Horncastell, gent, or of Clare Hall, Cambridge, Master of Arts 1
4236713 2108414 2108414 defendant Surflete Roland dyer 596792 596792 Surflete, Roland, of Horncastell, dyer 1
4238664 2109140 2109140 defendant Freston Robert draper 596792 596792 Freston, Robert, of Horncastell, draper 1
4238698 2109153 2109153 defendant Smythe Richard butcher 596792 596792 Smythe, Richard, of Horncastell, butcher 1
4245297 2111409 2111409 defendant Surflette Roland dyer 596792 596792 Surflette, Roland, of Horncastell, dyer 1
4246689 2111869 2111869 defendant Darbie Robert (legal representative) 596792 596792 Darbie, Robert, of Horncastell, mercer, administratrix of 3
4246690 2111869 2111869 defendant Darbie Mary widow 596792 596792 Darbie, Mary, of Horncastell, widow 4
4250277 2113073 2113073 defendant Elsaye George yeoman 596792 596792 Elsaye, George, of horncastell, yeoman 0
4250712 2113215 2113215 defendant Walker Oswald glover 596792 596792 Walker, Oswald, of Horncastell, glover 1
4272561 2120400 2120400 defendant Ellvyn Thomas yeoman 596792 596792 Ellvyn, Thomas, of Horncastell, yeoman 0
4295301 2128404 2128404 defendant Kirke Roger mercer 596792 596792 Kirke, Roger, of Horncastell, yeoman, mercer 0
4360177 2150803 2150803 defendant Johnson John innholder 596792 596792 Johnson, John, of Horncastell, innholder 0
4505259 2202176 2202176 plaintiff Smyth John   596792 596792 Smyth, John, of Horncastell 0
4512199 2204260 2204260 defendant Marum John de   596792 596792 Marum, John de, of Horncastell 1
4512200 2204260 2204260 defendant Goldsmyth Adam   596792 596792 Goldsmyth, Adam, of Horncastell 2
4610387 2234327 2234327 defendant Baxster Stephen   596792 596792 Baxster, Stephen, of Horncastell 1
4626927 2239368 2239368 defendant Tyler John butcher 596792 596792 Tyler, John, of Horncastell, butcher 0
4662530 2249749 2249749 defendant Weston John husbandman 596792 596792 Weston, John, of Horncastell, husbandman 0
4719274 2271376 2271376 defendant Stanes William woolman 596792 596792 Stanes, William, of Horncastell, woolman 0
4771989 2287214 2287214 defendant Grene John   596792 596792 Grene, John, of Horncastell 1
4797399 2295358 2295358 defendant Smyth John smith 596792 596792 Smyth, John, of Horncastell, smith 5
4797410 2295359 2295359 defendant Smyth John smith 596792 596792 Smyth, John, of Horncastell, smith 5
4815974 2301088 2301088 defendant Gunne Thomas   596792 596792 Gunne, Thomas, of Horncastell, mason 0
4819063 2302046 2302046 defendant Grene John vintner 596792 596792 Grene, John, of Horncastell, vintner 1
4825306 2303957 2303957 defendant Freston William shoemaker 596792 596792 Freston, William, of Horncastell, shoemaker 0
4833893 2306609 2306609 defendant Fauconer John butcher 596792 596792 Fauconer, John, of Horncastell, butcher 1
4834872 2306910 2306910 defendant Hotoft William chapman 596792 596792 Hotoft, William, of Horncastell, chapman 1
4839119 2308164 2308164 defendant Gedge Thomas, sen husbandman 596792 596792 Gedge, Thomas, sen, of Horncastell, husbandman 2
4852262 2312132 2312132 defendant Hotoft William chapman 596792 596792 Hotoft, William, of Horncastell, chapman 1
4865734 2316248 2316248 defendant Chapman John chapman 596792 596792 Chapman, John, of Horncastell, chapman 2

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