names

27 rows where place_id = 589902

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599173 1867377 1867377 defendant Pykerell Robert baker 589902 589902 Pykerell, Robert, of Stowmarket, Suff, baker 3
3659101 1913105 1913105 defendant Veer Richard yeoman 589902 589902 Veer, Richard, of Stowmarket, Suff, yeoman 2
3673141 1917611 1917611 defendant Harvy alias Porter Henry yeoman or bailiff 589902 589902 Harvy alias Porter, Henry, of Stowmarket, Suff, yeoman or bailiff 1
3684700 1921347 1921347 defendant Beste Robert grocer 589902 589902 Beste, Robert, of Stowmarket, Suff, grocer 0
3685354 1921574 1921574 defendant Thorpp William clothman 589902 589902 Thorpp, William, of Stowmarket, Suff, clothman 2
3685360 1921575 1921575 defendant Thorp William clothmaker 589902 589902 Thorp, William, of Stowmarket, Suff, clothmaker 2
3685466 1921606 1921606 defendant Rosser Robert clothmaker 589902 589902 Rosser, Robert, of Stowmarket, Suff, clothmaker 0
3685720 1921692 1921692 defendant Cockys William yeoman 589902 589902 Cockys, William, of Stowmarket, Suff, yeoman 1
3723962 1933776 1933776 defendant Cok William yeoman 589902 589902 Cok, William, of Stowmarket, Suff, yeoman 0
3771341 1948727 1948727 defendant Smyth John smith 589902 589902 (Smyth, John, of Stowmarket, Suff, smith 3
3793207 1955733 1955733 defendant Warburton William yeoman 589902 589902 Warburton, William, of Stowmarket, Suff, yeoman 3
3806331 1959895 1959895 defendant Campyon John husbandman 589902 589902 Campyon, John, of Stowmarket, Suff, husbandman 2
3806336 1959896 1959896 defendant Campyon John husbandman 589902 589902 Campyon, John, of Stowmarket, Suff, husbandman 2
3806341 1959898 1959898 defendant Turner Richard chapman 589902 589902 Turner, Richard, of Stowmarket, Suff, chapman 0
3826763 1966224 1966224 defendant Symond Robert clothmaker 589902 589902 Symond, Robert, of Stowmarket, Suff, clothmaker 0
3826768 1966225 1966225 defendant Symond Robert clothmaker 589902 589902 Symond, Robert, of Stowmarket, Suff, clothmaker 0
3874003 1981528 1981528 defendant Wage John yeoman 589902 589902 Wage, John, of Stowmarket, Suff, yeoman 0
3909380 1993437 1993437 defendant Tyrrell John gent 589902 589902 Tyrrell, John, of Stowmarket, Suff, gent 1
4003671 2026080 2026080 defendant Barton John, junior chapman 589902 589902 Barton, John, junior, of Stowmarket, Suff, chapman 0
4993959 2355066 2355066 defendant Asshewelle John skinner 589902 589902 Asshewelle, John, of Stowmarket, Suff, skinner 0
5246774 2429219 2429219 defendant Hotofte Ribert esq 589902 589902 Hotofte, Ribert, of Stowmarket, Suff, esq 0
5331699 2454569 2454569 defendant Smyth William yeoman 589902 589902 Smyth, William, of Stowmarket, Suff, yeoman 0
5366033 2465034 2465034 defendant Edgore John   589902 589902 Edgore, John, of Stowmarket, Suff, girdle maker 0
5385385 2470897 2470897 defendant Edgore John yeoman 589902 589902 Edgore, John, of Stowmarket, Suff, yeoman 0
5386884 2471311 2471311 defendant Gynne John pedler 589902 589902 Gynne, John, of Stowmarket, Suff, pedler 3
5396680 2474140 2474140 defendant George John yeoman 589902 589902 George, John, of Stowmarket, Suff,yeoman 0
5584946 2530367 2530367 defendant Tyrell James esq 589902 589902 Tyrell, James, of Stowmarket, Suff, esq 3

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