names

12 rows where case_id = 2231020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4599361 2231020 2231020 plaintiff Sturmer Henry     Sturmer, Henry 0
4599362 2231020 2231020 defendant Coupere Thomas     Coupere, Thomas 0
4599363 2231020 2231020 defendant Fullere Geoffrey     Fullere, Geoffrey 1
4599364 2231020 2231020 defendant Hacon John     Hacon, John 2
4599365 2231020 2231020 defendant Scowe Walter   773332 773332 Scowe, Walter, of Tuppecroft 3
4599366 2231020 2231020 defendant Willy John   591135 591135 Willy, John, of Dokkyng 4
4599367 2231020 2231020 defendant Taillour Geoffrey     Taillour, Geoffrey 5
4599368 2231020 2231020 defendant Reppele John     Reppele, John 6
4599369 2231020 2231020 defendant Arnald Nicholas   592185 592185 Arnald, Nicholas, of Sheryngham 7
4599370 2231020 2231020 defendant Beles William   768866 768866 Beles, William, of Suthfeld 8
4599371 2231020 2231020 defendant Rowehefd Richard fisher   Rowehefd, Richard, fisher 9
4599372 2231020 2231020 defendant Smyth Robert     Smyth, Robert 10

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