names

5 rows where case_id = 2403822

✎ 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
5159248 2403822 2403822 plaintiff Rolleston Roger (legal representative) 586070 586070 Rolleston, Roger, of Beverley, esq, formerly executor of Robert Rolleston, of Beverley, clerk, formerly parson of Warton, Lancs, executor of 0
5159249 2403822 2403822 plaintiff Smyth John chaplain 586070 586070 Smyth, John, of Beverley, chaplain 1
5159250 2403822 2403822 defendant Wynlaton William clerk & parson 854515 854515 Wynlaton, William, of Ellewyk, in the Durham bishopric, clerk & parson 0
5159251 2403822 2403822 defendant Mason William yeoman 854516 854516 Mason, William, of Kerrneford, Lancs, yeoman 1
5159252 2403822 2403822 defendant Robynson William yeoman 600220 600220 Robynson, William, of Hoton, Lancs, yeoman 2

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