names

9 rows where case_id = 2050048

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4071332 2050048 2050048 plaintiff Morrys William     Morrys, William 0
4071333 2050048 2050048 defendant Austen John yeoman 687458 687458 Austen, John, of Normacote, yeoman 0
4071334 2050048 2050048 defendant Stepleton William gent 687459 687459 Stepleton, William, of Lyttylwood, gent 1
4071335 2050048 2050048 defendant Hare Richard dyer 587516 587516 Hare, Richard, of Stafford, dyer 2
4071336 2050048 2050048 defendant Parker Thomas husbandman 591774 591774 Parker, Thomas, of Coton, husbandman 3
4071337 2050048 2050048 defendant Buckland William yeoman 588371 588371 Buckland, William, of Stone, yeoman 4
4071338 2050048 2050048 defendant Henne James husbandman 586406 586406 Henne, James, of Hopton, husbandman 5
4071339 2050048 2050048 defendant Rowley Richard tailor 687460 687460 Rowley, Richard, of Woodcote, Salop, tailor 6
4071340 2050048 2050048 defendant Skellhorne John saddler 613131 613131 Skellhorne, John, of Newport, Salop, saddler 7

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