names

6 rows where case_id = 2338558

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4938899 2338558 2338558 plaintiff Cok William     Cok, William 0
4938900 2338558 2338558 defendant Carpenter Thomas husbandman 824855 824855 Carpenter, Thomas, of Mulford Bishops, husbandman 0
4938901 2338558 2338558 defendant Pershore Richard saddler 586859 586859 Pershore, Richard, of Salisbury, saddler 1
4938902 2338558 2338558 defendant Carter Thomas clothier 820259 820259 Carter, Thomas, of Tangle, Hants, clothier 2
4938903 2338558 2338558 defendant Hancok John   596321 596321 Hancok, John, of Romsey, Hants, "forbour" 3
4938904 2338558 2338558 defendant Sonnyng William weaver 586859 586859 Sonnyng, William, of Salisbury, weaver 4

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