names

12 rows where case_id = 2464552

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5364482 2464552 2464552 plaintiff Andrewe Richard Master & clerk   Andrewe, Richard, Master & clerk 0
5364483 2464552 2464552 plaintiff Warde William chaplain   (Warde, William, chaplain 1
5364484 2464552 2464552 plaintiff Fyfeld Henry     Fyfeld, Henry 2
5364485 2464552 2464552 plaintiff Rosedale William chaplain   Rosedale, William, chaplain 3
5364486 2464552 2464552 plaintiff Latemere Richard Notary Public   Latemere, Richard, Notary Public 4
5364487 2464552 2464552 plaintiff Lovell John     Lovell, John 5
5364488 2464552 2464552 defendant Wilburfosse Robert gent 591199 591199 Wilburfosse, Robert, of Poklyngton, gent 0
5364489 2464552 2464552 defendant Davy Robert gent 626053 626053 Davy, Robert, of Helagh, gent 1
5364490 2464552 2464552 defendant Wanton Robert (legal representative) 591199 591199 Wanton, Robert, of Poklyngton, gent, executors of 2
5364491 2464552 2464552 defendant Wanton Isabel widow 591199 591199 (Wanton, Isabel, of Poklyngton, widow 3
5364492 2464552 2464552 defendant Doweman George chaplain 591199 591199 Doweman, George, of Poklyngton, chaplain 4
5364493 2464552 2464552 defendant Doweman William husbandman 591199 591199 Doweman, William, of Poklyngton, husbandman 5

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