names

17 rows where case_id = 2191326

✎ 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
4470176 2191326 2191326 plaintiff Brerdyng Thomas     Brerdyng, Thomas 0
4470177 2191326 2191326 defendant Daulton John     Daulton, John 0
4470178 2191326 2191326 defendant atte Gate William     atte Gate, William 1
4470179 2191326 2191326 defendant Boothe John     Boothe, John 2
4470180 2191326 2191326 defendant Nywe John     Nywe, John 3
4470181 2191326 2191326 defendant of Brading   weaver   of Brading, weaver 4
4470182 2191326 2191326 defendant Webbe George   760442 760442 Webbe, George, of Brerdynges 5
4470183 2191326 2191326 defendant Nywe William   760443 760443 Nywe, William, of Sandham 6
4470184 2191326 2191326 defendant Stanle William     Stanle, William 7
4470185 2191326 2191326 defendant Russell John   760444 760444 Russell, John, of Shenclyng or Shanklin 8
4470186 2191326 2191326 defendant Warenner Richard   760445 760445 Warenner, Richard, of Bienstede 9
4470187 2191326 2191326 defendant Baylly John   587004 587004 Baylly, John, of Preston 10
4470188 2191326 2191326 defendant Houbrond Adam     Houbrond, Adam 11
4470189 2191326 2191326 defendant Raulyn Thomas     Raulyn, Thomas 12
4470190 2191326 2191326 defendant Wynterver Richard     Wynterver, Richard 13
4470191 2191326 2191326 defendant Taillour Richard   760446 760446 Taillour, Richard, of the Ryde 14
4470192 2191326 2191326 defendant Tylye Richard of the Ryde, junior     Tylye, Richard of the Ryde, junior 15

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