names

13 rows where case_id = 2321074

✎ 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
4881356 2321074 2321074 plaintiff Wolley Roger     Wolley, Roger 0
4881357 2321074 2321074 defendant Bate John yeoman 588590 588590 Bate, John, of Assheburn, yeoman 0
4881358 2321074 2321074 defendant Shawe Ralph yeoman 758831 758831 Shawe, Ralph, of Estwayt, yeoman 1
4881359 2321074 2321074 defendant Donyngton Robert chaplain 593952 593952 Donyngton, Robert, of Tutbury, Staffs, chaplain 2
4881360 2321074 2321074 defendant Badley Stephen husbandman 794076 794076 Badley, Stephen, of Alastre, husbandman 3
4881361 2321074 2321074 defendant Neell John husbandman 589168 589168 Neell, John, of Tyknale, husbandman 4
4881362 2321074 2321074 defendant Trowell Thomas chapman 587136 587136 Trowell, Thomas, of Derby, chapman 5
4881363 2321074 2321074 defendant Flamstyd Robert husbandman 612713 612713 Flamstyd, Robert, of Halom, husbandman 6
4881364 2321074 2321074 defendant Montgomory John yeoman 665372 665372 Montgomory, John, of Mercaston, yeoman 7
4881365 2321074 2321074 defendant Cundy John (legal representative) 590512 590512 Cundy, John, of Welyngton, executors of 8
4881366 2321074 2321074 defendant Fuchon John carpenter 592147 592147 (Fuchon, John, of Neuton, Warks, carpenter 9
4881367 2321074 2321074 defendant Bekeswyke Nicholas (legal representative) 590512 590512 Bekeswyke, Nicholas, of Welyngton, husbandman, executrix of 10
4881368 2321074 2321074 defendant Bekeswyke Isabel widow 590512 590512 Bekeswyke, Isabel, of Welyngton, widow 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);