names

5 rows where case_id = 2323562

✎ 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
4889669 2323562 2323562 plaintiff atte Hall John   591949 591949 atte Hall, John, of Thorp 0
4889670 2323562 2323562 defendant atte Hall Agnes (legal representative) 597124 597124 atte Hall, Agnes, of Waynflete, executrix of atte Hall, John, junior, of Waynflete, executor of atte Halle, Walter, of Waynflete, executors of 0
4889671 2323562 2323562 defendant Goldsmyth John merchant 607106 607106 (Goldsmyth, John, of Melton Mowbray, Leics, merchant 1
4889672 2323562 2323562 defendant Goldsmyth Francis chaplain 587205 587205 Goldsmyth, Francis, of Grantham, chaplain 2
4889673 2323562 2323562 defendant Goldsmyth Mark merchant 587205 587205 Goldsmyth, Mark, of Grantham, merchant 3

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