names

19 rows where case_id = 2228908

✎ 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
4592169 2228908 2228908 plaintiff Neweman Richard (legal representative)   Neweman, Richard, executors of 0
4592170 2228908 2228908 plaintiff Snechelyng William     (Snechelyng, William 1
4592171 2228908 2228908 plaintiff Bret Thomas     Bret, Thomas 2
4592172 2228908 2228908 plaintiff Streyte John     Streyte, John 3
4592173 2228908 2228908 plaintiff Streyte Alice     Alice, his wife 4
4592174 2228908 2228908 defendant Bateford William     Bateford, William 0
4592175 2228908 2228908 defendant Smyth Reginald     Smyth, Reginald 1
4592176 2228908 2228908 defendant Durable John     Durable, John 2
4592177 2228908 2228908 defendant Lance John     Lance, John 3
4592178 2228908 2228908 defendant Penne William     Penne, William 4
4592179 2228908 2228908 defendant Hoper Richard   771145 771145 Hoper, Richard, of Cammell 5
4592180 2228908 2228908 defendant Spert Philip     Spert, Philip 6
4592181 2228908 2228908 defendant Hukker Philip     Hukker, Philip 7
4592182 2228908 2228908 defendant Mulward Thomas   588317 588317 Mulward, Thomas, of Colyford 8
4592183 2228908 2228908 defendant Berne John     together with Berne, John 9
4592184 2228908 2228908 defendant Dygon Richard     Dygon, Richard 10
4592185 2228908 2228908 defendant Broun John     Broun, John 11
4592186 2228908 2228908 defendant Squerell John     Squerell, John 12
4592187 2228908 2228908 defendant Mulward Edward   772704 772704 Mulward, Edward, of Bradepol 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);