names

11 rows where case_id = 2529444

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5581973 2529444 2529444 plaintiff Cutte John knight   Cutte, John, knight 0
5581974 2529444 2529444 defendant Wellys John gent 602719 602719 Wellys, John, of Denton, Oxon, gent 0
5581975 2529444 2529444 defendant Ogle Ralph esq 802290 802290 Ogle, Ralph, of Ogle, Northumb, esq 1
5581976 2529444 2529444 defendant Langtre Lambert gent 680102 680102 Langtre, Lambert, of Est Haddon, Nhants, gent 2
5581977 2529444 2529444 defendant Sayton John gent 611629 611629 Sayton, John, of Maydewell, Nhants, gent 3
5581978 2529444 2529444 defendant Fouke William gent 873253 873253 Fouke, William, of Brewode, Staffs, gent 4
5581979 2529444 2529444 defendant Lacy John gent 902578 902578 Lacy, John, of Cromwell, Yorks, gent 5
5581980 2529444 2529444 defendant Marton Thomas gent 625908 625908 Marton, Thomas, of Brasewell, Yorks, gent 6
5581981 2529444 2529444 defendant Gledell Thomas gent 902580 902580 Gledell, Thomas, of Berkyslond, Yorks, gent 7
5581982 2529444 2529444 defendant Stepneth John gent 586034 586034 Stepneth, John, of St Albans, Herts, gent 8
5581983 2529444 2529444 defendant Morys John, senior gent 821275 821275 Morys, John, senior, of Glapthorn, Nhants, gent 9

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