names

16 rows where case_id = 2454579

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5331742 2454579 2454579 plaintiff Bysshop John gent 585936 585936 Bysshop, John, of Norwich, gent 0
5331743 2454579 2454579 defendant Reynold Richard chapman 586117 586117 Reynold, Richard, of Coventry, chapman 0
5331744 2454579 2454579 defendant Fox Robert husbandman 753077 753077 Fox, Robert, of Brynyngham, husbandman 1
5331745 2454579 2454579 defendant Edmondys Robert husbandman 586820 586820 Edmondys, Robert, of Swanton Abbot, husbandman 2
5331746 2454579 2454579 defendant Pye Richard   587499 587499 Pye, Richard, of Hardwyk, wright 3
5331747 2454579 2454579 defendant Fewealyn William husbandman 594501 594501 Fewealyn, William, of Harple, husbandman 4
5331748 2454579 2454579 defendant Goldsmyth Robert husbandman 586559 586559 Goldsmyth, Robert, of Topcroft, husbandman 5
5331749 2454579 2454579 defendant Reppys Agnes widow 625457 625457 Reppys, Agnes, of Heryngflete, Suff, widow 6
5331750 2454579 2454579 defendant Collowe Thomas   874297 874297 together with Collowe, Thomas, of Long Strattonm husbandman 7
5331751 2454579 2454579 defendant Fysshe Robert baker 587592 587592 Fysshe, Robert, of Hempton, baker 8
5331752 2454579 2454579 defendant Hole Edmund yeoman 591189 591189 Hole, Edmund, of Dunton, yeoman 9
5331753 2454579 2454579 defendant Spynke John husbandman 842570 842570 Spynke, John, of Saxlyngham juxta Langham, husbandman 10
5331754 2454579 2454579 defendant Coket John husbandman 758493 758493 Coket, John, of Swynesthorp, husbandman 11
5331755 2454579 2454579 defendant Est John clerk 592497 592497 Est, John, of Marston, clerk 12
5331756 2454579 2454579 defendant Ilberd Geoffrey clerk 593572 593572 Ilberd, Geoffrey, of Dylham, clerk 13
5331757 2454579 2454579 defendant Byrcham John baker 587201 587201 Byrcham, John, of Sharyngton, baker 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);