names

15 rows where case_id = 2225312

✎ 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
4580260 2225312 2225312 plaintiff Danyell John     Danyell, John 0
4580261 2225312 2225312 plaintiff Danyell Walter     Danyell, Walter 1
4580262 2225312 2225312 plaintiff Brasyere Robert     Brasyere, Robert 2
4580263 2225312 2225312 plaintiff Dunston Robert     Dunston, Robert 3
4580264 2225312 2225312 defendant Frostell Nicholas   587786 587786 Frostell, Nicholas, of Rynglond 0
4580265 2225312 2225312 defendant Easton Thomas the parish priest, in   Easton, Thomas, the parish priest, in 1
4580266 2225312 2225312 defendant Fullere Henry     Fullere, Henry 2
4580267 2225312 2225312 defendant atte More John   587786 587786 atte More, John, of Rynglond 3
4580268 2225312 2225312 defendant Rybald Reginald     Rybald, Reginald 4
4580269 2225312 2225312 defendant Shote William     Shote, William 5
4580270 2225312 2225312 defendant Seman John   586572 586572 Seman, John, of Berford 6
4580271 2225312 2225312 defendant Smyth Thomas   587283 587283 Smyth, Thomas, of Honyngham 7
4580272 2225312 2225312 defendant Tylman Robert     Tylman, Robert 8
4580273 2225312 2225312 defendant Denne Richard   588406 588406 Denne, Richard, of Colton 9
4580274 2225312 2225312 defendant Lyve Robert   587283 587283 Lyve, Robert, of Honyngham 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);