names

12 rows where case_id = 2044982

✎ 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
4057255 2044982 2044982 plaintiff Bulman Thomas (legal representative)   Bulman, Thomas, executors of 0
4057256 2044982 2044982 plaintiff Christofer Robert     (Christofer, Robert 1
4057257 2044982 2044982 plaintiff Christofer Elizabeth widow of Thomas   Elizabeth his wife, widow of Thomas 2
4057258 2044982 2044982 defendant Thomas John yeoman 587019 587019 Thomas, John, of Crambroke, Kent, yeoman 0
4057259 2044982 2044982 defendant Browne Henry esq 674055 674055 Browne, Henry, of Henley, Surrey, esq 1
4057260 2044982 2044982 defendant Lyse Robert yeoman 591562 591562 Lyse, Robert, of Lewes, Sussex, yeoman 2
4057261 2044982 2044982 defendant Phillippes Ralph tailor 591941 591941 Phillippes, Ralph, of Melton, Kent, tailor 3
4057262 2044982 2044982 defendant Lover John yeoman 684229 684229 Lover, John, of Fakeham, Sussex, yeoman 4
4057263 2044982 2044982 defendant Austyn Stephen yeoman 684230 684230 Austyn, Stephen, of Gowdhurste, Kent, yeoman 5
4057264 2044982 2044982 defendant Willard Thomas yeoman 684231 684231 Willard, Thomas, of Hadeley, Sussex, yeoman 6
4057265 2044982 2044982 defendant Willyams Henry tailor 585951 585951 Willyams, Henry, of Winchester, tailor 7
4057266 2044982 2044982 defendant Newporte Robert gent 684232 684232 Newporte, Robert, of Heyse, Kent, gent 8

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