names

14 rows where case_id = 1934387

✎ 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
3725935 1934387 1934387 plaintiff Suthwell Richard knight   Suthwell, Richard, knight, executor of 0
3725936 1934387 1934387 plaintiff Wutton William baron of the Exchequer   Wutton, William, baron of the Exchequer 1
3725937 1934387 1934387 defendant Lother Lancelot gent 618684 618684 Lother, Lancelot, of Holt, March of Wales, gent 0
3725938 1934387 1934387 defendant Langford John   592344 592344 Langford, John, of Holt, knight 1
3725939 1934387 1934387 defendant Lother John Cumber 618686 618686 Lother, John, of Soverby, Cumber 2
3725940 1934387 1934387 defendant Morres John gent 618687 618687 Morres, John, of Glapthorne, Nhants, gent 3
3725941 1934387 1934387 defendant Seynt John gent 585869 585869 Seynt, John, of London, gent 4
3725942 1934387 1934387 defendant Seynt Seynt John, of Fourhope, Herts, yeoman   Seynt, Seynt, John, of Fourhope, Herts, yeoman 5
3725943 1934387 1934387 defendant Bentley John shoemaker 586033 586033 Bentley, John, of Westminster, shoemaker 6
3725944 1934387 1934387 defendant Sandford Ralph gent 596968 596968 Sandford, Ralph, of Thorp Salven, Yorks, gent 7
3725945 1934387 1934387 defendant Salford Brian prebendary of Halton, Notts   Salford, Brian, prebendary of Halton, Notts 8
3725946 1934387 1934387 defendant Woodward William yeoman 618688 618688 Woodward, William, of Manyfeld Woodhous, Notts, yeoman 9
3725947 1934387 1934387 defendant Leyborn Robert gent 585869 585869 Leyborn, Robert, of London, gent 10
3725948 1934387 1934387 defendant Lowdon Christopher gent 618689 618689 Lowdon, Christopher, of Chaffehunute, Bucks, gent 11

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