names

16 rows where case_id = 2331727

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4916689 2331727 2331727 plaintiff fitz Hugh William     fitz Hugh, William 0
4916690 2331727 2331727 defendant Burgh William   592628 592628 Burgh, William, of Thurleton 0
4916691 2331727 2331727 defendant Badle James   600139 600139 Badle, James, of Toft Monks 1
4916692 2331727 2331727 defendant Smyth John   821612 821612 Smyth, John, of Norton Subcours 2
4916693 2331727 2331727 defendant Hardy John   593308 593308 Hardy, John, of Redeham 3
4916694 2331727 2331727 defendant Smyth Adam   586965 586965 Smyth, Adam, of Hekyngham 4
4916695 2331727 2331727 defendant Wryght Richard   663008 663008 Wryght, Richard, of Dychyngham 5
4916696 2331727 2331727 defendant Reston Thomas   600139 600139 Reston, Thomas, of Toft Monks 6
4916697 2331727 2331727 defendant Wyrmegey William   821613 821613 Wyrmegey, William, of Wytteslyngham 7
4916698 2331727 2331727 defendant Hornyng Henry   592628 592628 Hornyng, Henry, of Thurleton 8
4916699 2331727 2331727 defendant Haton William   598804 598804 Haton, William, of Topcrofte 9
4916700 2331727 2331727 defendant Gryggys John   587076 587076 Gryggys, John, of Plumsted 10
4916701 2331727 2331727 defendant Laseblond John   593489 593489 Laseblond, John, of Gelyngham 11
4916702 2331727 2331727 defendant Smyth Richard   598815 598815 Smyth, Richard, of Norton Subcors 12
4916703 2331727 2331727 defendant Multon John yeoman 632608 632608 Multon, John, of Norton Subcors, Norf, yeoman 13
4916704 2331727 2331727 defendant all of Norfolk & all husbandman except the last man     all of Norfolk & all husbandman, except the last man 14

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