names

33 rows where place_id = 590502

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601404 1868099 1868099 defendant Hyll William yeoman 590502 590502 Hyll, William, of Barfold, Suff, yeoman 0
3632402 1904952 1904952 defendant Markys John clothmaker 590502 590502 Markys, John, of Barfold, Suff, clothmaker 0
3637108 1906405 1906405 defendant Deye John clothier 590502 590502 Deye, John, of Barfold, Suff, clothier 3
3673474 1917727 1917727 defendant Brettene John clothman 590502 590502 Brettene, John, of Barfold, Suff, clothman 0
3673476 1917728 1917728 defendant Brettene John clothman 590502 590502 Brettene, John, of Barfold, Suff, clothman 0
3675883 1918494 1918494 defendant Hill William clothman 590502 590502 Hill, William, of Barfold, Suff, clothman 0
3685352 1921574 1921574 defendant Locke William clothmaker 590502 590502 Locke, William, of Barfold, Suff, clothmaker 0
3685358 1921575 1921575 defendant Loke William clothmaker 590502 590502 Loke, William, of Barfold, Suff, clothmaker 0
3697380 1925400 1925400 defendant Jepson Thomas smith 590502 590502 Jepson, Thomas, of Barfold, Suff, smith 0
3697386 1925401 1925401 defendant Jopsun Thomas smith 590502 590502 Jopsun, Thomas, of Barfold, Suff, smith 0
3709517 1929282 1929282 defendant Reynold Thomas, senior clothman 590502 590502 Reynold, Thomas, senior, of Barfold, Suff, clothman 0
3729394 1935441 1935441 defendant Peverell John clothier 590502 590502 Peverell, John, of Barfold, Suff, clothier 2
3731520 1936087 1936087 defendant Reynold Thomas clothier 590502 590502 Reynold, Thomas, of Barfold, Suff, clothier 0
3792353 1955469 1955469 defendant Reynoldys George clothier 590502 590502 Reynoldys, George, of Barfold, Suff, clothier 0
3817904 1963517 1963517 defendant Nordon John clothier 590502 590502 Nordon, John, of Barfold, Suff, clothier 0
3849216 1973349 1973349 defendant Gryson or Gryston John chapman 590502 590502 Gryson or Gryston, John, of Barfold, Suff, chapman 3
3869931 1980185 1980185 defendant Bradford William chapman 590502 590502 Bradford, William, of Barfold, Suff, chapman 3
3896251 1988954 1988954 defendant Hyll Simon yeoman 590502 590502 Hyll, Simon, of Barfold, Suff, yeoman 1
3896254 1988955 1988955 defendant Hyll Simon yeoman 590502 590502 Hyll, Simon, of Barfold, Suff, yeoman 1
3906358 1992412 1992412 plaintiff Markes John   590502 590502 Markes, John, of Barfold, Suff 0
3910177 1993717 1993717 defendant Sewell George clothier 590502 590502 Sewell, George, of Barfold, Suff, clothier 2
3912993 1994679 1994679 defendant Dennam Edward clothmaker 590502 590502 Dennam, Edward, of Barfold, Suff, clothmaker 0
3934690 2001898 2001898 defendant Batman Thomas   590502 590502 Batman, Thomas, of Barfold, Suff 0
3962659 2011526 2011526 defendant Symonde Philip   590502 590502 (Symonde, Philip, of Barfold, Suff, linen draper 1
3972370 2014909 2014909 defendant Smyth William sherman 590502 590502 Smyth, William, of Barfold, Suff, sherman 0
4012982 2029377 2029377 plaintiff Reynold John (legal representative) 590502 590502 Reynold, John, of Barfold, Suff, gent, executors of 0
4012986 2029378 2029378 plaintiff Reynold John (legal representative) 590502 590502 Reynold, John, of Barfold, Suff, or of Staple Inn, Middx, gent, executors of 0
4042288 2039723 2039723 defendant Anger William chapman 590502 590502 Anger, William, of Barfold, Suff, chapman 0
4101971 2061015 2061015 defendant Manser Anthony clothier 590502 590502 Manser, Anthony, of Barfold, Suff, clothier 0
4214723 2100655 2100655 defendant Lowes Thomas clothier 590502 590502 Lowes, Thomas, of Barfold, Suff, clothier 0
4341670 2144367 2144367 defendant Crayfoote Edward dyer 590502 590502 Crayfoote, Edward, of Barfold, Suff, dyer 0
4365340 2152668 2152668 defendant Crayfoote Edward dyer 590502 590502 Crayfoote, Edward, of Barfold, Suff, dyer 0
5594112 2533135 2533135 defendant Reynold Thomas clothman 590502 590502 Reynold, Thomas, of Barfold, Suff, clothman 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);