names

14 rows where case_id = 2381616

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5083659 2381616 2381616 plaintiff FitzHugh William gent 842133 842133 FitzHugh, William, of Begery, gent 0
5083660 2381616 2381616 defendant Malyns John gent 844425 844425 Malyns, John, of Ravenesden, Beds, gent 0
5083661 2381616 2381616 defendant Bulle William husbandman 621639 621639 Bulle, William, of Temysford, Beds, husbandman 1
5083662 2381616 2381616 defendant Abbot Robert husbandman 799125 799125 Abbot, Robert, of Ronhale, Beds, husbandman 2
5083663 2381616 2381616 defendant Gostewyk John husbandman 844426 844426 Gostewyk, John, of Welyton, Beds, husbandman 3
5083664 2381616 2381616 defendant Coke John husbandman 784863 784863 Coke, John, of Welyton, husbandman 4
5083665 2381616 2381616 defendant Smyth Thomas husbandman 844427 844427 Smyth,Thomas,of Wylden, Bed, husbandman 5
5083666 2381616 2381616 defendant Elyot William husbandman 779215 779215 Elyot, William, of Goldyngton, Beds, husbandman 6
5083667 2381616 2381616 defendant atte Wode William husbandman 607762 607762 atte Wode,William, of Clyfton,Beds, husbandman 7
5083668 2381616 2381616 defendant Glove William husbandman 844428 844428 Glove, William, of Sowthele, beds, husbandman 8
5083669 2381616 2381616 defendant Smyth John husbandman 598750 598750 Smyth, John, of Wylden, husbandman 9
5083670 2381616 2381616 defendant Richard William husbandman 597990 597990 Richard, William, of Roxton, Beds, husbandman 10
5083671 2381616 2381616 defendant Forster Richard husbandman 844429 844429 Forster, Richard, of Keyso, Beds, husbandman 11
5083672 2381616 2381616 defendant Chaumberleyn Thomas husbandman 626770 626770 Chaumberleyn, Thomas, of Eton, Beds, husbandman 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);