names

17 rows where case_id = 2446397

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5304671 2446397 2446397 plaintiff Husey William     Husey, William 0
5304672 2446397 2446397 plaintiff Thornburgh Leonard     Thornburgh, Leonard 1
5304673 2446397 2446397 plaintiff Paynell William     Paynell, William 2
5304674 2446397 2446397 plaintiff Tamworth John     Tamworth, John 3
5304675 2446397 2446397 defendant Stykeney Robert yeoman 589231 589231 Stykeney, Robert, of Hemyngby, yeoman 0
5304676 2446397 2446397 defendant Ren_ll Thomas yeoman 871040 871040 Ren_ll, Thomas, of Higham, Derbyshire, yeoman 1
5304677 2446397 2446397 defendant Weston Thomas yeoman 623010 623010 Weston, Thomas, of Higham, Derbs, yeoman 2
5304678 2446397 2446397 defendant Smyth W_     Smyth, W_ 3
5304679 2446397 2446397 defendant Smyth Robert     Smyth, Robert 4
5304680 2446397 2446397 defendant Spykyng Simon     Spykyng, Simon 5
5304681 2446397 2446397 defendant Coppy Robert husbandman   Coppy, Robert, husbandman 6
5304682 2446397 2446397 defendant Smyth William     Smyth, William 7
5304683 2446397 2446397 defendant Spykyng William     Spykyng, William 8
5304684 2446397 2446397 defendant Shitw_ John     Shitw_, John 9
5304685 2446397 2446397 defendant Faldyngworth Thomas     Faldyngworth, Thomas 10
5304686 2446397 2446397 defendant Faldyngworth John     Faldyngworth, John 11
5304687 2446397 2446397 defendant the rest of Hemyngby Lincs husbandman   the rest of Hemyngby, Lincs, husbandman 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);