names

10 rows where case_id = 2231721

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4601591 2231721 2231721 plaintiff Walden Roger (legal representative) 604628 604628 Walden, Roger, of London, bishop, executors of 0
4601592 2231721 2231721 plaintiff Walden John esq   (Walden, John, esq 1
4601593 2231721 2231721 plaintiff Clyderowe Richard esq   Clyderowe, Richard, esq 2
4601594 2231721 2231721 plaintiff Bulcote William clerk   Bulcote, William, clerk 3
4601595 2231721 2231721 plaintiff Bernard John clerk   Bernard, John, clerk 4
4601596 2231721 2231721 plaintiff Wysebeche Thomas clerk   Wysebeche, Thomas, clerk 5
4601597 2231721 2231721 plaintiff Scot Richard clerk   Scot, Richard, clerk 6
4601598 2231721 2231721 defendant Bonet or Bovet John formerly farmer of Roger Walden, formerly bishop of London   Bonet or Bovet, John, formerly farmer of Roger Walden, formerly bishop of London, executors of 0
4601599 2231721 2231721 defendant Stoughton Thomas     (Stoughton, Thomas 1
4601600 2231721 2231721 defendant Stoughton Katherine     Katherine, his wife 2

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