names

14 rows where case_id = 2498658

✎ 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
5478713 2498658 2498658 plaintiff Brampton Thomas     Brampton, Thomas 0
5478714 2498658 2498658 defendant Glove John yeoman 588136 588136 Glove, John, of New Bokenham, yeoman 0
5478715 2498658 2498658 defendant Platfote Walter husbandman 590846 590846 Platfote, Walter, of Shipdam, husbandman 1
5478716 2498658 2498658 defendant Barker John husbandman 589247 589247 Barker, John, of Eye, Suff, husbandman 2
5478717 2498658 2498658 defendant Wyllys William yeoman 671846 671846 Wyllys, William, of Cleye juxta Mare, yeoman 3
5478718 2498658 2498658 defendant Wattys Robert husbandman 586471 586471 Wattys, Robert, of Aylesham, husbandman 4
5478719 2498658 2498658 defendant Hunne John husbandman 637154 637154 Hunne, John, of Wodbrige, Suff, husbandman 5
5478720 2498658 2498658 defendant Richardis Thomas husbandman 588583 588583 Richardis, Thomas, of Caston, husbandman 6
5478721 2498658 2498658 defendant Mony Edmund husbandman 587201 587201 Mony, Edmund, of Sharyngton, husbandman 7
5478722 2498658 2498658 defendant Hachet Richard   588926 588926 Hachet, Richard, of North Elmham, shepherd 8
5478723 2498658 2498658 defendant Molett Richard tailor 586157 586157 Molett, Richard, of Mateshale, tailor 9
5478724 2498658 2498658 defendant Collowe Thomas   586364 586364 Collowe, Thomas, of Long Stratton, yeoman, administrators of 10
5478725 2498658 2498658 defendant Lyne John yeoman 785823 785823 (Lyne, John, of Intewode, yeoman 11
5478726 2498658 2498658 defendant Payn John yeoman 586170 586170 Payn, John, of Tybenham, yeoman 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);