names

8 rows where case_id = 2447954

✎ 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
5309755 2447954 2447954 plaintiff Tebald John chaplain   Tebald, John, chaplain 0
5309756 2447954 2447954 defendant Camell William clerk 678778 678778 Camell, William, of Ereth, Kent, clerk 0
5309757 2447954 2447954 defendant Nasyng William husbandman 588196 588196 Nasyng, William, of North Crey, Kent, husbandman 1
5309758 2447954 2447954 defendant Crue John husbandman 871737 871737 Crue, John, of Hastynges, Kent , husbandman 2
5309759 2447954 2447954 defendant Crue Alice formerly wife of Stephen Dyer alias Reynold, of Roberdesbrigge, in Saleherst, Kent, dyer   Alice, his wife, formerly wife of Stephen Dyer alias Reynold, of Roberdesbrigge, in Saleherst, Kent, dyer 3
5309760 2447954 2447954 defendant Partryke John chaplain 854786 854786 Partryke, John, of Suthfeld, Norf, chaplain 4
5309761 2447954 2447954 defendant Partryke Robert administrator or   Partryke, Robert, administrator or administratrix of 5
5309762 2447954 2447954 defendant Partryke Joan widow 768866 768866 Partryke, Joan, of Suthfeld, widow 6

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