names

14 rows where case_id = 2188852

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4462118 2188852 2188852 plaintiff Sutton John     Sutton, John, on his own account 0
4462119 2188852 2188852 defendant Dunstaple Philip   594880 594880 Dunstaple, Philip, of Wynton 0
4462120 2188852 2188852 defendant Bucher William   758525 758525 Bucher, William, of Haylyng 1
4462121 2188852 2188852 defendant Wetham Thomas   624085 624085 Wetham, Thomas, of Dorset 2
4462122 2188852 2188852 defendant Tutty John     Tutty, John 3
4462123 2188852 2188852 defendant Stake Robert     Stake, Robert 4
4462124 2188852 2188852 defendant Stake John     Stake, John 5
4462125 2188852 2188852 defendant Kyng John     Kyng, John 6
4462126 2188852 2188852 defendant Philipes Thomas     Philipes, Thomas 7
4462127 2188852 2188852 defendant Hascombe William     Hascombe, William 8
4462128 2188852 2188852 defendant Trill Peter     Trill, Peter 9
4462129 2188852 2188852 defendant Kyng Ralph le     Kyng, Ralph le 10
4462130 2188852 2188852 defendant Pilche William     Pilche, William 11
4462131 2188852 2188852 defendant Donnyng John     Donnyng, John 12

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