names

15 rows where case_id = 2201207

✎ 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
4501942 2201207 2201207 plaintiff Mareys John     Mareys, John 0
4501943 2201207 2201207 defendant Stanford Henry     Stanford, Henry 0
4501944 2201207 2201207 defendant Martyn William     Martyn, William 1
4501945 2201207 2201207 defendant burgeys John, junior     burgeys, John, junior 2
4501946 2201207 2201207 defendant atte Assh John     atte Assh, John 3
4501947 2201207 2201207 defendant Compayn Roger     Compayn, Roger 4
4501948 2201207 2201207 defendant Coke Thomas   588600 588600 Coke, Thomas, of Westbury 5
4501949 2201207 2201207 defendant Bailly William, senior     Bailly, William, senior 6
4501950 2201207 2201207 defendant Bailly William, junior     Bailly, William, junior 7
4501951 2201207 2201207 defendant Gayle John     Gayle, John 8
4501952 2201207 2201207 defendant Atkyns Joh   662027 662027 Atkyns, Joh, of Bekynton 9
4501953 2201207 2201207 defendant Lenyng John     Lenyng, John 10
4501954 2201207 2201207 defendant Smyth John   763856 763856 Smyth, John, of Bradelegh 11
4501955 2201207 2201207 defendant Page John or Trowebrigge   Page, John, or Trowebrigge 12
4501956 2201207 2201207 defendant Godefrey Thomas     Godefrey, Thomas 13

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