names

13 rows where case_id = 2351707

✎ 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
4982586 2351707 2351707 plaintiff Trethewy William     Trethewy, William 0
4982587 2351707 2351707 defendant Clouter John husbandman 625712 625712 Clouter, John, of St Clere, husbandman 0
4982588 2351707 2351707 defendant Clouter Robert husbandman 625712 625712 Clouter, Robert, of St Clere, husbandman 1
4982589 2351707 2351707 defendant Jon John husbandman 830388 830388 Jon, John, of Oppyslond, St Clere, husbandman 2
4982590 2351707 2351707 defendant Vele John husbandman 830389 830389 Vele, John, of Carcarek, husbandman 3
4982591 2351707 2351707 defendant Hamond Richard husbandman 625712 625712 Hamond, Richard, of St Clere, husbandman 4
4982592 2351707 2351707 defendant Grega John husbandman 625712 625712 Grega, John, of St Clere, husbandman 5
4982593 2351707 2351707 defendant Gilla John husbandman 625712 625712 Gilla, John, of St Clere, husbandman 6
4982594 2351707 2351707 defendant Grega Vincent husbandman 625712 625712 Grega, Vincent, of St Clere, husbandman 7
4982595 2351707 2351707 defendant Daryght Ralph husbandman 625712 625712 Daryght, Ralph, of St Clere, husbandman 8
4982596 2351707 2351707 defendant Dykyn Walter husbandman 625712 625712 Dykyn, Walter, of St Clere, husbandman 9
4982597 2351707 2351707 defendant Nicoll Isabel widow 625712 625712 Nicoll, Isabel, of St Clere, widow 10
4982598 2351707 2351707 defendant Warn Thomas tailor 625712 625712 Warn, Thomas, of St Clere, tailor 11

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