names

15 rows where place_id = 629489

✎ 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
3746934 1940960 1940960 defendant Hepey Robert (legal representative) 629489 629489 Hepey, Robert, of Sutton, Kent, yeoman, executors of 0
3788613 1954242 1954242 plaintiff Stafford Henry esq 629489 629489 Stafford, Henry, of Sutton, Kent, esq 0
3869491 1980038 1980038 defendant Ketelwell Robert yeoman 629489 629489 Ketelwell, Robert, of Sutton, Kent, yeoman 0
3899636 1990097 1990097 defendant Strodyll Robert clerk 629489 629489 Strodyll, Robert, of Sutton, Kent, clerk 0
3913610 1994890 1994890 defendant Strodyll Robert clerk 629489 629489 Strodyll, Robert, of Sutton, Kent, clerk 0
3940798 2003929 2003929 plaintiff Strooddell Robert (legal representative) 629489 629489 Strooddell, Robert, of Sutton, Kent, priest & vicar, executors of 0
3947647 2006239 2006239 defendant Cokeson Richard gent 629489 629489 Cokeson, Richard, of Sutton, Kent, gent 0
4100010 2060331 2060331 defendant Rawlyns Nicholas yeoman 629489 629489 Rawlyns, Nicholas, of Sutton, Kent, yeoman 0
4393118 2162306 2162306 defendant Sharpe Robert gent 629489 629489 Sharpe, Robert, of Sutton, Kent, gent 0
4632248 2240971 2240971 defendant Clifford William esq 629489 629489 Clifford, William, of Sutton, Kent, esq 1
4632251 2240972 2240972 defendant Clifford William esq 629489 629489 Clifford, William, of Sutton, Kent, esq 1
4656059 2247775 2247775 defendant Estre Thomas husbandman 629489 629489 Estre, Thomas, of Sutton, Kent, husbandman 9
4951199 2342341 2342341 defendant atte Parke Robert draper 629489 629489 atte Parke, Robert, of Sutton, Kent, draper 0
5324582 2452431 2452431 defendant Parke William draper 629489 629489 Parke, William, of Sutton, Kent, draper 0
5324598 2452433 2452433 defendant Parke William draper 629489 629489 Parke, William, of Sutton, Kent, draper 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);