names

14 rows where case_id = 2438998

✎ 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
5279110 2438998 2438998 plaintiff Bourchier Thomas Archbishop of Canterbury   Bourchier, Thomas, Archbishop of Canterbury 0
5279111 2438998 2438998 defendant Harper Robert gent 626624 626624 Harper, Robert, of Atherston, Warks, gent 0
5279112 2438998 2438998 defendant Chapman Richard chapman 603520 603520 Chapman, Richard, of Atherston, chapman 1
5279113 2438998 2438998 defendant Mychell William tiler 603520 603520 Mychell, William, of Atherston, tiler 2
5279114 2438998 2438998 defendant Reynold Joan widow 603520 603520 Reynold, Joan, of Atherston, widow 3
5279115 2438998 2438998 defendant Mychell Henry yeoman 603520 603520 Mychell, Henry, of Atherston, yeoman 4
5279116 2438998 2438998 defendant Vale Ralph barker 603520 603520 Vale, Ralph, of Atherston, barker 5
5279117 2438998 2438998 defendant Drayton John butcher 603520 603520 Drayton, John, of Atherston, butcher 6
5279118 2438998 2438998 defendant Nevewe Nicholas barker 603520 603520 Nevewe, Nicholas, of Atherston, barker 7
5279119 2438998 2438998 defendant Bonde Thomas baker 603520 603520 Bonde, Thomas, of Atherston, baker 8
5279120 2438998 2438998 defendant Saundre Thomas chaplain 867943 867943 Saundre, Thomas, of Mansetre, chaplain 9
5279121 2438998 2438998 defendant Cowehoppe Robert tailor 603520 603520 Cowehoppe, Robert, of Atherston, tailor 10
5279122 2438998 2438998 defendant Nytynghale John shoemaker 603520 603520 Nytynghale, John, of Atherston, shoemaker 11
5279123 2438998 2438998 defendant Fegyn John weaver 592257 592257 Fegyn, John, of Wytherley, weaver 12

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