names

16 rows where case_id = 2197008

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4488135 2197008 2197008 plaintiff Stafford Edmund     Stafford, Edmund 0
4488136 2197008 2197008 plaintiff Osmond William     Osmond, William 1
4488137 2197008 2197008 plaintiff Rotour Nicholas chaplain   Rotour, Nicholas, chaplain, on their own account 2
4488138 2197008 2197008 defendant Wodegrym Edmund   586224 586224 Wodegrym, Edmund, of Grendon 0
4488139 2197008 2197008 defendant Gydymon William   586224 586224 Gydymon, William, of Grendon 1
4488140 2197008 2197008 defendant Eydole Thomas     Eydole, Thomas 2
4488141 2197008 2197008 defendant Scotte Henry     Scotte, Henry 3
4488142 2197008 2197008 defendant Scotte William   600765 600765 Scotte, William, of Wetton 4
4488143 2197008 2197008 defendant Jakkeson John   761522 761522 with Jakkeson, John, of Boterton 5
4488144 2197008 2197008 defendant Thomkynson John     Thomkynson, John 6
4488145 2197008 2197008 defendant del Coor William     del Coor, William 7
4488146 2197008 2197008 defendant Nichol William     Nichol, William 8
4488147 2197008 2197008 defendant Dyke John     Dyke, John 9
4488148 2197008 2197008 defendant atte Sherd Robert     atte Sherd, Robert 10
4488149 2197008 2197008 defendant Geffeesson Thomas   587278 587278 Geffeesson, Thomas, of Calton 11
4488150 2197008 2197008 defendant Moseley Henry     Moseley, Henry 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);