names

31 rows where place_id = 591643

✎ 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
3605074 1869253 1869253 defendant Man Walter chapman 591643 591643 Man, Walter, of Naylond, Suff, chapman 0
3693255 1924100 1924100 defendant Cowper Robert clothmaker 591643 591643 Cowper, Robert, of Naylond, Suff, clothmaker 0
3721619 1933061 1933061 defendant Hamond John (legal representative) 591643 591643 Hamond, John, of Naylond, Suff, gent, executrix of 0
3726106 1934428 1934428 defendant Haymond John gent 591643 591643 Haymond, John, of Naylond, Suff, gent 3
3869924 1980184 1980184 defendant Rutter Christopher clothier 591643 591643 Rutter, Christopher, of Naylond, Suff, clothier 2
3869944 1980187 1980187 defendant Strond Robert clothman 591643 591643 Strond, Robert, of Naylond, Suff, clothman 4
3886092 1985599 1985599 defendant Abbys James clothier 591643 591643 Abbys, James, of Naylond, Suff, clothier 1
3902825 1991178 1991178 defendant Holton Edward clothier 591643 591643 Holton, Edward, of Naylond, Suff, clothier 0
3902827 1991179 1991179 defendant Holton Edward clothier 591643 591643 Holton, Edward, of Naylond, Suff, clothier 0
3910315 1993767 1993767 defendant Lyngwood John clothmaker 591643 591643 Lyngwood, John, of Naylond, Suff, clothmaker 1
3928926 2000012 2000012 defendant Longe Richard   591643 591643 Longe, Richard, of Naylond, Suff, cloth man 0
3940218 2003746 2003746 defendant Brydgys William clothier 591643 591643 Brydgys, William, of Naylond, Suff, clothier 0
3959629 2010461 2010461 defendant Rosse Edward gent 591643 591643 Rosse, Edward, of Naylond, Suff, gent 0
3975916 2016140 2016140 defendant Sharle or Sharleye John clothier 591643 591643 Sharle or Sharleye, John, of Naylond, Suff, clothier 2
3976930 2016493 2016493 defendant Abbs John merchant 591643 591643 Abbs, John, of Naylond, Suff, merchant 15
3987479 2020269 2020269 defendant Mawlt John clothier 591643 591643 Mawlt, John, of Naylond, Suff, clothier 1
4014949 2030062 2030062 defendant Abbes John grocer 591643 591643 Abbes, John, of Naylond, Suff, grocer 0
4111420 2064331 2064331 defendant Warbyngton Charles tailor 591643 591643 Warbyngton, Charles, of Naylond, Suff, tailor 0
4247897 2112279 2112279 defendant Muns John clothier 591643 591643 Muns, John, of Naylond, Suff, clothier 0
4378407 2157350 2157350 defendant Hare William yeoman 591643 591643 Hare, William, of Naylond, Suff, yeoman 0
5365751 2464945 2464945 defendant Cosyn Robert   591643 591643 Cosyn, Robert, of Naylond, Suff, cork maker 0
5397099 2474255 2474255 defendant Hyde John   591643 591643 Hyde, John, of Naylond, Suff, cloth maker 1
5410300 2478033 2478033 defendant Hyde John clothmaker 591643 591643 Hyde, John, of Naylond, Suff, clothmaker 1
5424133 2482180 2482180 defendant Hyde John clothmaker 591643 591643 Hyde, John, of Naylond, Suff, clothmaker 1
5489574 2501763 2501763 defendant Smyth James painter 591643 591643 Smyth, James, of Naylond, Suff, painter 0
5489579 2501764 2501764 defendant Smyth James painter 591643 591643 Smyth, James, of Naylond, Suff, painter 0
5527871 2513285 2513285 defendant Arblaster Thomas gent 591643 591643 Arblaster, Thomas, of Naylond, Suff, gent 2
5528840 2513542 2513542 defendant Arblaster Thomas clothier 591643 591643 Arblaster, Thomas, of Naylond, Suff, clothier 1
5528845 2513543 2513543 defendant Arblaster Thomas clothier 591643 591643 Arblaster, Thomas, of Naylond, Suff, clothier 2
5532956 2514851 2514851 defendant Austen Thomas   591643 591643 Austen, Thomas, of Naylond, Suff, cloth maker 0
5577386 2527985 2527985 plaintiff Werburton Thomas   591643 591643 Werburton, Thomas, of Naylond, Suff, tallow chandler 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);