names

14 rows where case_id = 2334112

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4924531 2334112 2334112 plaintiff Norwych William, junior     Norwych, William, junior, on his own account 0
4924532 2334112 2334112 defendant Miller Richard miller 591756 591756 Miller, Richard, of Dunston, miller 0
4924533 2334112 2334112 defendant Holtman Katherine of Bynham widow   with Holtman, Katherine of Bynham, widow 1
4924534 2334112 2334112 defendant Fyssher Richard husbandman 592443 592443 Fyssher, Richard, of Surlyngham, husbandman 2
4924535 2334112 2334112 defendant Belsted Robert husbandman 598982 598982 Belsted, Robert, of Mulverton, husbandman 3
4924536 2334112 2334112 defendant Geyst Thomas clerk 586158 586158 with Geyst, Thomas, of Shuldham, clerk 4
4924537 2334112 2334112 defendant Takon Adam butcher 822860 822860 Takon, Adam, of Little Walsybnham, butcher 5
4924538 2334112 2334112 defendant Wyghton William pedder 655131 655131 Wyghton, William, of Canston, pedder 6
4924539 2334112 2334112 defendant Davy John tanner 585933 585933 Davy, John, of Great Yarmouth, tanner 7
4924540 2334112 2334112 defendant Covehithe John merchant 585933 585933 Covehithe, John, of Great Yarmouth, merchant 8
4924541 2334112 2334112 defendant Boneryth John chaplain 586365 586365 Boneryth, John, of Wymondham, chaplain 9
4924542 2334112 2334112 defendant Joye John (legal representative)   Joye, John, executor of 10
4924543 2334112 2334112 defendant Marleburgh William   822861 822861 Marleburgh, William, of Kymbyrle, vicar 11
4924544 2334112 2334112 defendant Burgh William chaplain 588486 588486 Burgh, William, of Wynterton, chaplain 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);