names

11 rows where case_id = 1909213

✎ 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
3646224 1909213 1909213 plaintiff Hoddisdon John (legal representative)   Hoddisdon, John, executor of 0
3646225 1909213 1909213 plaintiff Hoddisdon William     Hoddisdon, William 1
3646226 1909213 1909213 defendant Nicoll Richard (legal representative)   Nicoll, Richard, executors of 0
3646227 1909213 1909213 defendant Heydon John husbandman 596638 596638 (Heydon, John, of South Mymmes, husbandman 1
3646228 1909213 1909213 defendant Marram Robert husbandman 601611 601611 Marram, Robert, of Barton, Beds, husbandman 2
3646229 1909213 1909213 defendant Nicoll Richard collier 601612 601612 Nicoll, Richard, of Smales, Hendon, collier 3
3646230 1909213 1909213 defendant Olyvaunt Roger collier 596708 596708 Olyvaunt, Roger, of Chepyng Barnet, Herts, collier 4
3646231 1909213 1909213 defendant Idull Oliver (legal representative)   Idull, Oliver, executors of 5
3646232 1909213 1909213 defendant Mershe John yeoman 601613 601613 (Mershe, John, of Gladwyn Strete, Hendon, yeoman 6
3646233 1909213 1909213 defendant Hichcok Henry (legal representative)   Hichcok, Henry, executors of 7
3646234 1909213 1909213 defendant Fynch Richard yeoman 591026 591026 (Fynch, Richard, of Magna Busshey, Herts, yeoman 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);