names

82 rows where place_id = 593659

✎ 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
3612819 1871658 1871658 defendant Cook William clothman 593659 593659 Cook, William, of Long Melford, Suff, clothman 1
3625233 1875427 1875427 defendant Clopton William esq 593659 593659 Clopton, William, of Long Melford, Suff, esq 0
3713320 1930478 1930478 defendant Smyth Thomas clothmaker 593659 593659 Smyth, Thomas, of Long Melford, Suff, clothmaker 0
3722231 1933211 1933211 plaintiff Martyn Roger esq 593659 593659 Martyn, Roger, of Long Melford, Suff, esq 0
3733037 1936554 1936554 defendant Symkyn William yeoman 593659 593659 Symkyn, William, of Long Melford, Suff, yeoman 0
3754778 1943451 1943451 defendant Davy Thomas yeoman 593659 593659 Davy, Thomas, of Long Melford, Suff, yeoman 0
3754780 1943452 1943452 defendant Davy Thomas yeoman 593659 593659 Davy, Thomas, of Long Melford, Suff, yeoman 0
3779087 1951185 1951185 defendant Bukke Robert gent 593659 593659 (Bukke, Robert, of Long Melford, Suff, gent 3
3780036 1951481 1951481 plaintiff Maire William clothman 593659 593659 Maire, William, of Long Melford, Suff, clothman 1
3795082 1956328 1956328 defendant Maryon Thomas clothman 593659 593659 Maryon, Thomas, of Long Melford, Suff, clothman 0
3797107 1956977 1956977 defendant Gager John clothmaker 593659 593659 Gager, John, of Long Melford, Suff, clothmaker 0
3799575 1957789 1957789 plaintiff Johnson William   593659 593659 Johnson, William, of Long Melford, Suff 0
3803071 1958863 1958863 defendant Bukke John gent 593659 593659 Bukke, John, of Long Melford, Suff, gent 2
3803078 1958865 1958865 defendant Bukke John gent 593659 593659 Bukke, John, of Long Melford, Suff, gent 1
3849215 1973349 1973349 defendant Dawson Robert husbandman 593659 593659 Dawson, Robert, of Long Melford, Suff, husbandman 2
3858956 1976488 1976488 plaintiff Bures Robert esq 593659 593659 Bures, Robert, of Long Melford, Suff, esq 0
3862234 1977554 1977554 plaintiff Grome William weaver 593659 593659 Grome, William, of Long Melford, Suff, weaver 0
3878418 1983028 1983028 defendant Cawston Robert husbandman 593659 593659 Cawston, Robert, of Long Melford, Suff, husbandman 0
3883152 1984626 1984626 defendant Penyngton Francis widow 593659 593659 Penyngton, Francis, of Long Melford, Suff, widow 1
3887553 1986088 1986088 defendant Hunwyk William grocer 593659 593659 Hunwyk, William, of Long Melford, Suff, grocer 0
3924848 1998629 1998629 defendant Lowe William clothman 593659 593659 Lowe, William, of Long Melford, Suff, clothman 0
3931276 2000752 2000752 defendant Malet Henry clerk 593659 593659 Malet, Henry, of Long Melford, suff, clerk 0
3936227 2002443 2002443 defendant Smyth Roger clothier 593659 593659 Smyth, Roger, of Long Melford, Suff, clothier 0
3972931 2015106 2015106 defendant Buckley William yeoman 593659 593659 Buckley, William, of Long Melford, Suff, yeoman 2
3994190 2022676 2022676 plaintiff Clopton Francis esq 593659 593659 Clopton, Francis, of Long Melford, Suff, esq 0
3994906 2022930 2022930 defendant Sponer Geoffrey butcher 593659 593659 Sponer, Geoffrey, of Long Melford, Suff, butcher 0
4020023 2031892 2031892 defendant Sponer Geoffrey chapman 593659 593659 Sponer, Geoffrey, of Long Melford, Suff, chapman 1
4045885 2040976 2040976 defendant Hatche Thomas clothier 593659 593659 Hatche, Thomas, of Long Melford, Suff, clothier 0
4218302 2101899 2101899 defendant Ellis Thomas clerk 593659 593659 Ellis, Thomas, of Long Melford, Suff, clerk 1
4247898 2112279 2112279 defendant Gilbore Thomas clothier 593659 593659 Gilbore, Thomas, of Long Melford, Suff, clothier 1
4253366 2114116 2114116 defendant Grosar John chapman 593659 593659 Grosar, John, of Long Melford, Suff, chapman 1
4266604 2118476 2118476 defendant Groser John chapman 593659 593659 Groser, John, of Long Melford, Suff, chapman 1
4267155 2118654 2118654 defendant Frende John husbandman 593659 593659 Frende, John, of Long Melford, Suff, husbandman 0
4267921 2118905 2118905 defendant Wyldbore Thomas clothier 593659 593659 Wyldbore, Thomas, of Long Melford, Suff, clothier 1
4267941 2118908 2118908 defendant Cryssall John clothier 593659 593659 Cryssall, John, of Long Melford, Suff, clothier 0
4284977 2124676 2124676 defendant Grocer John mercer 593659 593659 Grocer, John, of Long Melford, Suff, mercer 2
4292105 2127249 2127249 defendant Kynge John dyer 593659 593659 Kynge, John, of Long Melford, Suff, dyer 3
4298431 2129542 2129542 defendant Dyke Francis gent 593659 593659 Dyke, Francis, of Long Melford, Suff, or of Pentlowe, Essex, gent 0
4299169 2129801 2129801 defendant Crysall Peter clothier 593659 593659 Crysall, Peter, of Long Melford, Suff, clothier 2
4333666 2141539 2141539 defendant Kinge John clothier 593659 593659 Kinge, John, of Long Melford, Suff, clothier 0
4334797 2141907 2141907 defendant Dick or Dyke Francis gent 593659 593659 Dick or Dyke, Francis, of Long Melford, Suff, gent 0
4336438 2142478 2142478 defendant Wilbore William clothier 593659 593659 Wilbore, William, of Long Melford, Suff, clothier 1
4358134 2150087 2150087 defendant Dick or Dike Francis gent 593659 593659 Dick or Dike, Francis, of Long Melford, Suff, gent 0
4382608 2158891 2158891 defendant Creswell John clothier 593659 593659 Creswell, John, of Long Melford, Suff, clothier 2
4382613 2158892 2158892 defendant Wilbore Thomas clothier 593659 593659 Wilbore, Thomas, of Long Melford, Suff, clothier 2
4603413 2232256 2232256 defendant Bakere John   593659 593659 Bakere, John, of Long Melford, Suff 0
4861079 2314821 2314821 defendant Plumme Thomas yeoman 593659 593659 Plumme, Thomas, of Long Melford, Suff, yeoman 3
4929520 2335647 2335647 defendant Tiptot John fuller 593659 593659 Tiptot, John, of Long Melford, Suff, fuller 1
4968653 2347593 2347593 defendant Hervy Walter fuller 593659 593659 Hervy, Walter, of Long Melford, Suff, fuller 0
4968656 2347594 2347594 defendant Hervy Walter fuller 593659 593659 Hervy, Walter, of Long Melford, Suff, fuller 0
4990553 2354081 2354081 defendant Brokhole Richard fuller 593659 593659 (Brokhole, Richard, of Long Melford, Suff, fuller 1
5002953 2357766 2357766 defendant Bonour Thomas chapman 593659 593659 Bonour, Thomas, of Long Melford, Suff, chapman 3
5047471 2370863 2370863 defendant Hewet John carpenter 593659 593659 Hewet, John, of Long Melford, Suff, carpenter 0
5047473 2370864 2370864 defendant Hewet John carpenter 593659 593659 Hewet, John, of Long Melford, Suff, carpenter 0
5125513 2393948 2393948 defendant Fuller John dyer 593659 593659 Fuller, John, of Long Melford, Suff, dyer 0
5131412 2395676 2395676 defendant Martyn Lawrence merchant 593659 593659 Martyn, Lawrence, of Long Melford, suff, merchant 1
5134406 2396558 2396558 defendant Fuller John dyer 593659 593659 Fuller, John, of Long Melford, Suff, dyer 0
5182321 2410583 2410583 defendant Barker Gilbert weaver 593659 593659 Barker, Gilbert, of Long Melford, Suff, weaver 0
5184067 2411075 2411075 defendant Tryklowe Robert   593659 593659 Tryklowe, Robert, of Long Melford, Suff, cloth man 1
5203327 2416736 2416736 defendant Barker Gilbert weaver 593659 593659 Barker, Gilbert, of Long Melford, Suff, weaver 0
5204133 2416962 2416962 defendant Tryklowe Robert   593659 593659 Tryklowe, Robert, of Long Melford, Suff, cloth man 1
5204137 2416963 2416963 defendant Tryklowe Robert   593659 593659 Tryklowe, Robert, of Long Melford, Suff, cloth man 1
5244615 2428608 2428608 defendant Smyth Thomas dyer 593659 593659 Smyth, Thomas, of Long Melford, Suff, dyer 0
5244618 2428609 2428609 defendant Smyth Thomas dyer 593659 593659 Smyth, Thomas, of Long Melford, Suff, dyer 0
5331874 2454613 2454613 defendant Hille Thomas clothmaker 593659 593659 Hille, Thomas, of Long Melford, Suff, clothmaker 1
5355429 2461772 2461772 defendant Carre Edmund esq 593659 593659 Carre, Edmund, of Long Melford, Suff, esq 0
5357832 2462521 2462521 defendant Kerre Edmund clothman 593659 593659 Kerre, Edmund, of Long Melford, Suff, clothman 0
5365933 2465000 2465000 defendant Yong Richard fuller 593659 593659 Yong, Richard, of Long Melford, Suff, fuller 0
5365935 2465001 2465001 defendant Yong Richard fuller 593659 593659 Yong, Richard, of Long Melford, Suff, fuller 0
5375433 2467903 2467903 defendant Fulby Robert chapman 593659 593659 Fulby, Robert, of Long Melford, Suff, chapman 1
5376032 2468097 2468097 defendant Rogger Robert sheerman 593659 593659 Rogger, Robert, of Long Melford, Suff, sheerman 0
5382443 2470037 2470037 defendant Fylby Robert chapman 593659 593659 Fylby, Robert, of Long Melford, Suff, chapman 1
5392363 2472900 2472900 defendant Crerbek Andrew gent 593659 593659 Crerbek, Andrew, of Long Melford, Suff, gent 0
5405409 2476626 2476626 defendant Clerbrok Andrew gent 593659 593659 Clerbrok, Andrew, of Long Melford, Suff, gent 0
5418465 2480448 2480448 defendant Clerbek Andrew gent 593659 593659 Clerbek, Andrew, of Long Melford, Suff, gent 0
5532968 2514853 2514853 defendant Bery James clothmaker 593659 593659 Bery, James, of Long Melford, Suff, clothmaker 3
5547123 2519166 2519166 defendant Waryn Richard dyer 593659 593659 Waryn, Richard, of Long Melford, Suff, dyer 4
5583328 2529857 2529857 defendant Abury James clothman 593659 593659 Abury, James, of Long Melford, Suff, clothman 0
5601187 2535262 2535262 defendant Cowper Lawrence yeoman 593659 593659 Cowper, Lawrence, of Long Melford, Suff, yeoman 0
5605980 2536759 2536759 defendant Clopton William, junior esq 593659 593659 Clopton, William, junior, of Long Melford, Suff, esq 0
5605982 2536760 2536760 defendant Clopton William, junior esq 593659 593659 Clopton, William, junior, of Long Melford, Suff, esq 0
5609321 2537817 2537817 defendant Fulby Robert chapman 593659 593659 Fulby, Robert, of Long Melford, Suff, chapman 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);