names

159 rows where place_id = 586938

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590035 1864523 1864523 defendant Marler William mercer 586938 586938 Marler, William, of Thornham, mercer 0
3590037 1864524 1864524 defendant Sparham Thomas yeoman 586938 586938 Sparham, Thomas, of Thornham, yeoman 0
3600582 1867830 1867830 plaintiff Wyseman Simon esq 586938 586938 Wyseman, Simon, of Thornham, esq 0
3636359 1906163 1906163 defendant Seman Peter husbandman 586938 586938 Seman, Peter, of Thornham, husbandman 2
3640080 1907343 1907343 defendant Dunche John, junior husbandman 586938 586938 Dunche, John, junior, of Thornham, husbandman 3
3701422 1926691 1926691 defendant Hoker Richard mariner 586938 586938 Hoker, Richard, of Thornham, mariner 1
3726938 1934692 1934692 defendant Wyseman William clerk 586938 586938 Wyseman, William, of Thornham, clerk 0
3729925 1935615 1935615 plaintiff Myller John   586938 586938 Myller, John, of Thornham 2
3735425 1937317 1937317 defendant Porter Alice widow 586938 586938 Porter, Alice, of Thornham, widow 1
3742569 1939547 1939547 defendant Wyseman William clerk 586938 586938 Wyseman, William, of Thornham, clerk 0
3757464 1944305 1944305 plaintiff Miller John   586938 586938 Miller, John, of Thornham 2
3757915 1944459 1944459 defendant Hoker Richard mariner 586938 586938 Hoker, Richard, of Thornham, mariner 0
3769276 1948044 1948044 defendant Pokyll John husbandman 586938 586938 Pokyll, John, of Thornham, husbandman 3
3783951 1952758 1952758 defendant Meryall William carpenter 586938 586938 Meryall, William, of Thornham, carpenter 0
3810457 1961164 1961164 defendant Bridde Thomas (legal representative) 586938 586938 Bridde, Thomas, of Thornham, husbandman, executors of 0
3810458 1961164 1961164 defendant Wygenale alias Glasewright John   586938 586938 (Wygenale alias Glasewright, John, of Thornham, glass wright 1
3821815 1964712 1964712 defendant Baker William   586938 586938 Baker, William, of Thornham, shepherd 1
3838748 1970046 1970046 defendant Baker John   586938 586938 Baker, John, of Thornham, shepherd 1
3856205 1975560 1975560 defendant Sayer William husbandman 586938 586938 Sayer, William, of Thornham, husbandman 1
3862248 1977558 1977558 defendant Barker John   586938 586938 Barker, John, of Thornham, shepherd 2
3912819 1994620 1994620 defendant Kyng John husbandman 586938 586938 Kyng, John, of Thornham, husbandman 0
3928728 1999945 1999945 defendant (not given) Lawrence vicar of Sowthwyk 586938 586938 Sowthwyk, Lawrence, of Thornham, clerk & vicar of Holme 0
3928729 1999945 1999945 defendant Dyxson John yeoman 586938 586938 Dyxson, John, of Thornham, yeoman 1
3949525 2006906 2006906 defendant Stone John yeoman 586938 586938 Stone, John, of Thornham, yeoman 0
3960207 2010670 2010670 defendant Stone John yeoman 586938 586938 Stone, John, of Thornham, yeoman 0
3963559 2011863 2011863 plaintiff Yonge William (legal representative) 586938 586938 Yonge, William, of Thornham, executors of 0
3971719 2014669 2014669 defendant Houghton John mariner 586938 586938 Houghton, John, of Thornham, mariner 1
3982800 2018621 2018621 defendant Farrour John tailor 586938 586938 Farrour, John, of Thornham, tailor 1
3989750 2021077 2021077 defendant Foxe Thomas laborer 586938 586938 Foxe, Thomas, of Thornham, laborer 2
3994656 2022841 2022841 defendant Stone John yeoman 586938 586938 Stone, John, of Thornham, yeoman 0
3995823 2023254 2023254 defendant Alleyne Anthony husbandman 586938 586938 Alleyne, Anthony, of Thornham, husbandman 0
4004400 2026353 2026353 defendant Bryde John knacker 586938 586938 Bryde, John, of Thornham, knacker 1
4014115 2029778 2029778 plaintiff Savage John tailor 586938 586938 Savage, John, of Thornham, tailor 0
4016599 2030642 2030642 defendant Goodwyn Valentine merchant 586938 586938 Goodwyn, Valentine, of Thornham, merchant 0
4021771 2032515 2032515 plaintiff Akars Robert husbandman 586938 586938 Akars, Robert, of Thornham, husbandman 0
4021775 2032516 2032516 defendant Meriell John   586938 586938 Meriell, John, of Thornham, mason 1
4036842 2037860 2037860 defendant Goodwyn Valentine gent 586938 586938 Goodwyn, Valentine, of Thornham, gent 0
4060294 2046081 2046081 defendant Goodwyn Valentine gent 586938 586938 Goodwyn, Valentine, of Thornham, gent 0
4115794 2065933 2065933 defendant Goodwyn Valentine gent 586938 586938 Goodwyn, Valentine, of Thornham, gent 0
4123390 2068669 2068669 defendant Larke Walter yeoman 586938 586938 Larke, Walter, of Thornham, yeoman 0
4150826 2078421 2078421 defendant Smyth Edmund husbandman 586938 586938 Smyth, Edmund, of Thornham, husbandman 0
4150827 2078421 2078421 defendant Oliver Edward yeoman 586938 586938 Oliver, Edward, of Thornham, yeoman 1
4150828 2078421 2078421 defendant Smyth Humphrey draper 586938 586938 Smyth, Humphrey, of Thornham, draper 2
4174916 2086692 2086692 defendant Thred Alexander husbandman 586938 586938 Thred, Alexander, of Thornham, husbandman 1
4213807 2100347 2100347 defendant Olyver Edward yeoman 586938 586938 Olyver, Edward, of Thornham, yeoman 0
4222140 2103235 2103235 defendant Wilson William clerk 586938 586938 Wilson, William, of Thornham, clerk 0
4229933 2105951 2105951 defendant Goodwyn Valentine gent 586938 586938 Goodwyn, Valentine, of Thornham, gent 0
4242576 2110511 2110511 defendant Tubbing Arthur yeoman 586938 586938 Tubbing, Arthur, of Thornham, yeoman 1
4242581 2110512 2110512 defendant Tubbyng Arthur yeoman 586938 586938 Tubbyng, Arthur, of Thornham, yeoman 1
4248914 2112622 2112622 defendant Young Richard yeoman 586938 586938 Young, Richard, of Thornham, yeoman 1
4248917 2112623 2112623 defendant Yong Richard yeoman 586938 586938 Yong, Richard, of Thornham, yeoman 1
4249741 2112896 2112896 defendant Yonge Richard, senior   586938 586938 Yonge, Richard, senior, of Thornham, sailor 0
4249742 2112896 2112896 defendant Yonge Richard, junior yeoman 586938 586938 Yonge, Richard, junior, of Thornham, yeoman 1
4249743 2112896 2112896 defendant Yonge Thomas husbandman 586938 586938 Yonge, Thomas, of Thornham, husbandman 2
4261306 2116748 2116748 defendant Taylor alias Pursore Thomas yeoman 586938 586938 Taylor alias Pursore, Thomas, of Thornham, yeoman 0
4282487 2123775 2123775 defendant Tubbing Arthur mercer 586938 586938 Tubbing, Arthur, of Thornham, mercer 0
4286907 2125371 2125371 defendant Albert Valentine husbandman 586938 586938 Albert, Valentine, of Thornham, husbandman 0
4286908 2125371 2125371 defendant Albert Margaret widow 586938 586938 Albert, Margaret, of Thornham, widow 1
4286909 2125371 2125371 defendant Burton Thomas husbandman 586938 586938 Burton Thomas, of Thornham, husbandman 2
4288098 2125792 2125792 defendant Olyver Edward yeoman 586938 586938 Olyver, Edward, of Thornham, yeoman 0
4288099 2125792 2125792 defendant Alberd Margaret widow 586938 586938 Alberd, Margaret, of Thornham, widow 1
4288100 2125792 2125792 defendant Alberd Valentine husbandman 586938 586938 Alberd, Valentine, of Thornham, husbandman 2
4288740 2126030 2126030 defendant Wylson William clerk 586938 586938 Wylson, William, of Thornham, clerk 0
4302208 2130887 2130887 defendant Toftwood Thomas gent 586938 586938 Toftwood, Thomas, of Thornham, or of Melles, Suff, gent 1
4331708 2140902 2140902 defendant Goodwyn Valentine gent 586938 586938 Goodwyn, Valentine, of Thornham, gent 3
4382635 2158898 2158898 defendant Yonge Richard (legal representative) 586938 586938 Yonge, Richard, of Thornham, yeoman, executrix of 3
4394679 2162808 2162808 defendant Olyver Edward yeoman 586938 586938 Olyver, Edward, of Thornham, yeoman 0
4438835 2181437 2181437 defendant Powen alan   586938 586938 Powen, alan, of Thornham 3
4469994 2191279 2191279 defendant Byngyl Thomas   586938 586938 Byngyl, Thomas, of Thornham 6
4470809 2191524 2191524 defendant Byngel John   586938 586938 Byngel, John, of Thornham 0
4543159 2213742 2213742 defendant Wylly John   586938 586938 Wylly, John, of Thornham 0
4557472 2218273 2218273 plaintiff Blyant Simon   586938 586938 Blyant, Simon, of Thornham 1
4558065 2218456 2218456 plaintiff Leyre Agnes   586938 586938 Leyre, Agnes, of Thornham 0
4571265 2222584 2222584 defendant Willy John   586938 586938 Willy, John, of Thornham 1
4598523 2230774 2230774 defendant Bailleston Henry   586938 586938 Bailleston, Henry, of Thornham 0
4598527 2230775 2230775 defendant Bailleston Henry   586938 586938 Bailleston, Henry, of Thornham 0
4600886 2231501 2231501 defendant Tanne John   586938 586938 Tanne, John, of Thornham, cook 4
4602451 2231988 2231988 defendant Baileston Henry   586938 586938 Baileston, Henry, of Thornham 0
4627144 2239440 2239440 plaintiff Reve Thomas   586938 586938 Reve, Thomas, of Thornham 0
4666774 2255337 2255337 defendant Herman John   586938 586938 Herman, John, of Thornham, shepherd 0
4698365 2264967 2264967 plaintiff Joye Thomas   586938 586938 Joye, Thomas, of Thornham 2
4704075 2266652 2266652 defendant Braunche Gilbert husbandman 586938 586938 Braunche, Gilbert, of Thornham, husbandman 0
4725857 2273374 2273374 plaintiff Godale John   586938 586938 Godale, John, of Thornham 0
4739217 2277358 2277358 defendant Plumsted William (legal representative) 586938 586938 Plumsted, William, of Thornham, gent, executors of 0
4740815 2277829 2277829 defendant Styflyn John cooper 586938 586938 Styflyn, John, of Thornham, cooper 6
4754050 2281648 2281648 defendant Plumpstede William (legal representative) 586938 586938 Plumpstede, William, of Thornham, gent, executors of 0
4759151 2283207 2283207 defendant Pyx Robert farmer 586938 586938 Pyx, Robert, of Thornham, farmer 2
4759155 2283208 2283208 defendant Pyx Richard farmer 586938 586938 Pyx, Richard, of Thornham, farmer 0
4763977 2284726 2284726 defendant Godeale John yeoman 586938 586938 Godeale, John, of Thornham, yeoman 1
4767008 2285669 2285669 defendant Bake John baker 586938 586938 Bake, John, of Thornham, baker 3
4777776 2289042 2289042 defendant Combe John laborer 586938 586938 Combe, John, of Thornham, laborer 2
4804353 2297548 2297548 plaintiff Bleant Simon   586938 586938 Bleant, Simon, of Thornham 0
4838870 2308087 2308087 defendant Betes Thomas yeoman 586938 586938 Betes, Thomas, of Thornham, yeoman 2
4893548 2324684 2324684 defendant Scot Martin husbandman 586938 586938 Scot, Martin, of Thornham, husbandman 0
4893549 2324684 2324684 defendant Julyon John husbandman 586938 586938 Julyon, John, of Thornham, husbandman 1
4968056 2347391 2347391 defendant Crombe Isabel widow 586938 586938 Crombe, Isabel, of Thornham, widow 1
5012050 2360371 2360371 defendant Edy Robert butcher 586938 586938 Edy, Robert, of Thornham, butcher 11
5025195 2364263 2364263 defendant Bedyll Henry   586938 586938 Bedyll, Henry, of Thornham, tile maker 3
5027106 2364798 2364798 defendant Jokyn Walter mercer 586938 586938 Jokyn, Walter, of Thornham, mercer 0
5076930 2379594 2379594 defendant Morkyn John husbandman 586938 586938 Morkyn, John, of Thornham, husbandman 0

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