names

5 rows where case_id = 2307220

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4835925 2307220 2307220 plaintiff Dunolm or Durham John prior of the cathedral church of St Cuthbert, in   Dunolm or Durham, John, prior of the cathedral church of St Cuthbert, in 0
4835926 2307220 2307220 defendant Gerver William yeoman 767344 767344 Gerver, William, of Kirkton in Holand, yeoman 0
4835927 2307220 2307220 defendant Goldyng Hugh husbandman 586504 586504 Goldyng, Hugh, of Frampton, husbandman 1
4835928 2307220 2307220 defendant (not given) John vicar of Baynton 586504 586504 Baynton, John, of Frampton, vicar of the parish church 2
4835929 2307220 2307220 defendant Baynton John yeoman 810158 810158 Baynton, John, of Gysborn, Yorks, yeoman 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);