names

14 rows where case_id = 2197368

✎ 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
4489280 2197368 2197368 plaintiff Thomma John chaplain   Thomma, John, chaplain 0
4489281 2197368 2197368 defendant Webber Andrew     Webber, Andrew 0
4489282 2197368 2197368 defendant Nichol John     Nichol, John 1
4489283 2197368 2197368 defendant Wysa Roger     Wysa, Roger 2
4489284 2197368 2197368 defendant Wysa Alice   599163 599163 Wysa, Alice, of St Austell 3
4489285 2197368 2197368 defendant Ady Ralph   762588 762588 Ady, Ralph, of St Prove 4
4489286 2197368 2197368 defendant Berkle John     Berkle, John 5
4489287 2197368 2197368 defendant Hykka Treworgy John     Hykka Treworgy, John 6
4489288 2197368 2197368 defendant Ewanyter Alan     Ewanyter, Alan 7
4489289 2197368 2197368 defendant Restaurek Sibill formerly wife of John   Restaurek, Sibill, formerly wife of John 8
4489290 2197368 2197368 defendant Duke Hervy     Duke, Hervy 9
4489291 2197368 2197368 defendant Treuthgans John     Treuthgans, John 10
4489292 2197368 2197368 defendant Cuber John, senior     Cuber, John, senior 11
4489293 2197368 2197368 defendant Dour John     Dour, 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);