names

13 rows where case_id = 2354864

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4993268 2354864 2354864 plaintiff Duket Robert     Duket, Robert 0
4993269 2354864 2354864 defendant Hogeson Robert yeoman 831998 831998 Hogeson, Robert, of Bannesdale, yeoman 0
4993270 2354864 2354864 defendant Tomson Hoggeson John yeoman 831999 831999 Tomson Hoggeson, John, of Selfed, yeoman 1
4993271 2354864 2354864 defendant Cok Adam jun, of Strikland, yeoman   Cok, Adam, jun, of Strikland, yeoman 2
4993272 2354864 2354864 defendant Cok Thomas yeoman 635244 635244 Cok, Thomas, of Strikland, yeoman 3
4993273 2354864 2354864 defendant Frethebank John yeoman 626953 626953 Frethebank, John, of Kyllyngton, yeoman 4
4993274 2354864 2354864 defendant Richardson Wilkynson Thomas yeoman 670033 670033 Richardson Wilkynson, Thomas, of Sedbergh, Yorks, yeoman 5
4993275 2354864 2354864 defendant Whitwell Thomas yeoman 832000 832000 Whitwell, Thomas, of Lupton, Westmd, yeoman 6
4993276 2354864 2354864 defendant Aiera Roger yeoman 758170 758170 Aiera, Roger, of Kentmere, yeoman 7
4993277 2354864 2354864 defendant Porter John yeoman 753729 753729 Porter, John, of Kirkeby in Kendale, yeoman 8
4993278 2354864 2354864 defendant Walton John yeoman 615779 615779 Walton, John, of Kirkby in Kendale, yeoman 9
4993279 2354864 2354864 defendant Warde Richard yeoman 614978 614978 Warde, Richard, of Kirkby Stephen, yeoman 10
4993280 2354864 2354864 defendant Stevenson William yeoman 635244 635244 Stevenson, William, of Strikland, yeoman 11

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