names

61 rows where place_id = 599345

✎ 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
3636372 1906165 1906165 defendant Morsse Edward clothmaker 599345 599345 Morsse, Edward, of Stratford, Suff, clothmaker 2
3637109 1906405 1906405 defendant Smyth John clothier 599345 599345 Smyth, John, of Stratford, Suff, clothier 4
3694546 1924497 1924497 defendant Feryve Richard clerk 599345 599345 Feryve, Richard, of Stratford, Suff, clerk 2
3871750 1980787 1980787 defendant Dennam Edward clothmaker 599345 599345 Dennam, Edward, of Stratford, Suff, clothmaker 2
3910178 1993717 1993717 defendant Clerk John clothier 599345 599345 Clerk, John, of Stratford, Suff, clothier 3
3914984 1995363 1995363 defendant Mors Alice widow 599345 599345 Mors, Alice, of Stratford, Suff, widow 0
3914987 1995364 1995364 defendant Mors Alice widow 599345 599345 Mors, Alice, of Stratford, Suff, widow 0
3927750 1999620 1999620 defendant Barwicke John clothier 599345 599345 Barwicke, John, of Stratford, Suff, clothier 0
3927753 1999621 1999621 defendant Baswicke John clothier 599345 599345 Baswicke, John, of Stratford, Suff, clothier 0
3929535 2000227 2000227 defendant Mylles Adam clothier 599345 599345 Mylles, Adam, of Stratford, Suff, clothier 0
3937543 2002891 2002891 defendant Barwyck John clothier 599345 599345 Barwyck, John, of Stratford, Suff, clothier 0
3938092 2003074 2003074 defendant Coole Anthony   599345 599345 Coole, Anthony, of Stratford, Suff, cloth maker 0
3954289 2008575 2008575 defendant Barker alias Payne John weaver 599345 599345 Barker alias Payne, John, of Stratford, Suff, weaver 0
3955329 2008933 2008933 defendant Bogas Robert gent 599345 599345 Bogas, Robert, of Stratford, Suff, gent 0
3962103 2011326 2011326 defendant Wyles Robert yeoman 599345 599345 Wyles, Robert, of Stratford, Suff, yeoman 0
3992335 2022026 2022026 defendant Havens Robert merchant 599345 599345 Havens, Robert, of Stratford, Suff, merchant 0
3994078 2022632 2022632 defendant Uffette John clothier 599345 599345 Uffette, John, of Stratford, Suff, clothier 0
4000031 2024776 2024776 defendant Havens Robert merchant 599345 599345 Havens, Robert, of Stratford, Suff, merchant 0
4006891 2027241 2027241 plaintiff Lucas John gent 599345 599345 Lucas, John, of Stratford, Suff, gent 0
4006893 2027242 2027242 plaintiff Lucas John gent 599345 599345 Lucas, John, of Stratford, Suff, gent 0
4019392 2031669 2031669 defendant Uffett John clothier 599345 599345 Uffett, John, of Stratford, Suff, clothier 0
4182870 2089490 2089490 defendant Bogasse or Bogas Robert gent 599345 599345 Bogasse or Bogas, Robert, of Stratford, Suff, gent 0
4203382 2096732 2096732 defendant Smythe William gent 599345 599345 Smythe, William, of Stratford, Suff, attorney, gent 0
4205929 2097617 2097617 defendant Sympson Nicholas yeoman 599345 599345 Sympson, Nicholas, of Stratford, Suff, yeoman 1
4267964 2118911 2118911 defendant Collyns Thomas clothier 599345 599345 Collyns, Thomas, of Stratford, Suff, clothier 1
4357819 2149975 2149975 defendant Wylson Christopher clothier 599345 599345 Wylson, Christopher, of Stratford, Suff, clothier 0
4369199 2154048 2154048 defendant Havens Thomas clothier 599345 599345 Havens, Thomas, of Stratford, Suff, clothier 0
4401363 2165053 2165053 defendant Bragge Robert clothier 599345 599345 Bragge, Robert, of Stratford, Suff, clothier 0
4898401 2326156 2326156 defendant Hoo John yeoman 599345 599345 Hoo, John, of Stratford, Suff, yeoman 0
5043066 2369541 2369541 defendant Bukke John   599345 599345 Bukke, John, of Stratford, Suff, parson 0
5070191 2377578 2377578 defendant Lane John husbandman 599345 599345 Lane, John, of Stratford, Suff, husbandman 2
5145229 2399745 2399745 defendant Pryour Robert dyer 599345 599345 Pryour, Robert, of Stratford, Suff, dyer 2
5154916 2402596 2402596 defendant Pryour Robert dyer 599345 599345 Pryour, Robert, of Stratford, Suff, dyer 2
5165774 2405733 2405733 defendant Pryour Robert dyer 599345 599345 Pryour, Robert, of Stratford, Suff, dyer 2
5180228 2409956 2409956 defendant Priour Robert dyer 599345 599345 Priour, Robert, of Stratford, Suff, dyer 2
5312617 2448808 2448808 defendant Snowe John yeoman 599345 599345 Snowe, John, of Stratford, Suff, yeoman 0
5312621 2448809 2448809 defendant Snowe John yeoman 599345 599345 Snowe, John, of Stratford, Suff, yeoman 0
5331875 2454613 2454613 defendant Clerk John dyer 599345 599345 Clerk, John, of Stratford, Suff, dyer 2
5360807 2463409 2463409 defendant Lenehous William clothmaker 599345 599345 Lenehous, William, of Stratford, Suff, clothmaker 3
5360814 2463410 2463410 defendant Lenehous or Levehous William clothmaker 599345 599345 Lenehous or Levehous, William, of Stratford, Suff, clothmaker 4
5370839 2466468 2466468 defendant Chirchehawe John, junior   599345 599345 Chirchehawe, John, junior, of Stratford, Suff, cloth maker 2
5377019 2468405 2468405 defendant Mell Richard clothier 599345 599345 Mell, Richard, of Stratford, Suff, clothier 4
5377025 2468406 2468406 defendant Mell Richard clothier 599345 599345 Mell, Richard, of Stratford, Suff, clothier 4
5404636 2476399 2476399 defendant Nycoll Richard fuller 599345 599345 Nycoll, Richard, of Stratford, Suff, fuller 4
5416325 2479801 2479801 defendant Thorp William clothman 599345 599345 Thorp, William, of Stratford, Suff, clothman 1
5417783 2480242 2480242 defendant Nicoll Richard fuller 599345 599345 Nicoll, Richard, of Stratford, Suff, fuller 4
5433064 2484854 2484854 defendant Thorp William clothman 599345 599345 Thorp, William, of Stratford, Suff, clothman 1
5433090 2484862 2484862 defendant Thorp William clothman 599345 599345 Thorp, William, of Stratford, Suff, clothman 1
5437429 2486140 2486140 defendant Mell Richard clothier 599345 599345 Mell, Richard, of Stratford, Suff, clothier 2
5439118 2486623 2486623 defendant Leche John tanner 599345 599345 Leche, John, of Stratford, Suff, tanner 4
5450327 2489982 2489982 defendant (illegible) Roger fuller 599345 599345 _, Roger, of Stratford, Suff, fuller 3
5451829 2490424 2490424 defendant Mell Richard clothier 599345 599345 Mell, Richard, of Stratford, Suff, clothier 2
5452985 2490772 2490772 defendant Leche John tanner 599345 599345 Leche, John, of Stratford, Suff, tanner 3
5462478 2493681 2493681 defendant Nycoll Richard fuller 599345 599345 Nycoll, Richard, of Stratford, Suff, fuller 3
5464937 2494425 2494425 defendant Leche John tanner 599345 599345 Leche, John, of Stratford, Suff, tanner 3
5464943 2494426 2494426 defendant Leche John tanner 599345 599345 Leche, John, of Stratford, Suff, tanner 3
5474022 2497204 2497204 defendant Nicoll Richard fuller 599345 599345 Nicoll, Richard, of Stratford, Suff, fuller 1
5529539 2513737 2513737 defendant Woodhowes John clothmaker 599345 599345 Woodhowes, John, of Stratford, Suff, clothmaker 0
5532173 2514609 2514609 defendant Wodhous John clothmaker 599345 599345 Wodhous, John, of Stratford, Suff, clothmaker 0
5632454 2554186 2554186 defendant Stratford Richard gent 599345 599345 Stratford, Richard, of Stratford, Suff, gent 0
5632456 2554187 2554187 defendant Stratford Richard gent 599345 599345 Stratford, Richard, of Stratford, Suff, gent 0

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