names

16 rows where case_id = 2331726

✎ 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
4916673 2331726 2331726 plaintiff fitz Hugh William     fitz Hugh, William 0
4916674 2331726 2331726 defendant Burgh William   821609 821609 Burgh, William, of Th--- 0
4916675 2331726 2331726 defendant Badle James   821610 821610 Badle, James, of Monks Toft 1
4916676 2331726 2331726 defendant Smyth John   598815 598815 Smyth, John, of Norton Subcors 2
4916677 2331726 2331726 defendant Hardy John   593308 593308 Hardy, John, of Redeham 3
4916678 2331726 2331726 defendant Smyth Adam   586965 586965 Smyth, Adam, of Hekyngham 4
4916679 2331726 2331726 defendant Wryght Richard   663008 663008 Wryght, Richard, of Dychyngham 5
4916680 2331726 2331726 defendant Reston Thomas   821610 821610 Reston, Thomas, of Monks Toft 6
4916681 2331726 2331726 defendant Wyrmegey William   821611 821611 Wyrmegey, William, of Wyttelyngham 7
4916682 2331726 2331726 defendant Hornyng Henry   592628 592628 Hornyng, Henry, of Thurleton 8
4916683 2331726 2331726 defendant Haton William   598804 598804 Haton, William, of Topcrofte 9
4916684 2331726 2331726 defendant Gryggys John   629588 629588 Gryggys, John, of Plumstede 10
4916685 2331726 2331726 defendant Lasebond John   593489 593489 Lasebond, John, of Gelyngham 11
4916686 2331726 2331726 defendant Smyth Richard   598815 598815 Smyth, Richard, of Norton Subcors 12
4916687 2331726 2331726 defendant Multon John yeoman 598815 598815 Multon, John, of Norton Subcors, yeoman 13
4916688 2331726 2331726 defendant all places in Norfolk & each a husbandman but the last     all places in Norfolk & each a husbandman, but the last 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);