names

9 rows where case_id = 2412871

✎ 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
5190186 2412871 2412871 plaintiff Leyre Margery (legal representative) 586180 586180 Leyre, Margery, of Bury St Edmunds, widow, formerly executrix of William Leyr, of Bury St Edmunds, mason, executors of 0
5190187 2412871 2412871 plaintiff Odeham William draper   (Odeham, William, draper 1
5190188 2412871 2412871 plaintiff Watton Agnes daughter of Margery Leyre   Watton, Agnes, daughter of Margery Leyre 2
5190189 2412871 2412871 defendant Dekene John (legal representative) 586134 586134 Dekene, John, of Ipswich, merchant, executor of 0
5190190 2412871 2412871 defendant Bromley John clerk 586134 586134 Bromley, John, of Ipswich, clerk 1
5190191 2412871 2412871 defendant Motte John (legal representative) 590961 590961 Motte, John, of Bildeston, merchant, executors of 2
5190192 2412871 2412871 defendant Whitop William yeoman 590961 590961 (Whitop, William, of Bildeston, yeoman 3
5190193 2412871 2412871 defendant Whitop Agnes formerly wife of John Motte, of Bildeston   Agnes, his wife, formerly wife of John Motte, of Bildeston 4
5190194 2412871 2412871 defendant Motte John   857676 857676 Motte, John, of Lon 5

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