names

13 rows where case_id = 2417291

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5205236 2417291 2417291 plaintiff Grey Edmund knight   Grey, Edmund, knight 0
5205237 2417291 2417291 defendant Walshef William gent 771618 771618 Walshef, William, of Guncestre, gent 0
5205238 2417291 2417291 defendant Arneburgh Reginald gent 771616 771616 Arneburgh, Reginald, of Gunnecestre, gent 1
5205239 2417291 2417291 defendant Arneburgh John merchant 771616 771616 Arneburgh, John, of Gunnecestre, merchant 2
5205240 2417291 2417291 defendant Boterwyk of Huntingdon gent   Boterwyk, of Huntingdon, gent 3
5205241 2417291 2417291 defendant Ardyngton Robert draper 590039 590039 Ardyngton, Robert, of Huntyngdon, draper 4
5205242 2417291 2417291 defendant Congerton William draper 590039 590039 Congerton, William, of Huntyngdon, draper 5
5205243 2417291 2417291 defendant Ropesley John fishmonger 590039 590039 Ropesley, John, of Huntyngdon, fishmonger 6
5205244 2417291 2417291 defendant Dunhed Thomas fishmonger 590039 590039 Dunhed, Thomas, of Huntyngdon, fishmonger 7
5205245 2417291 2417291 defendant Moygne William jun, of Huntyngdon   Moygne, William, jun, of Huntyngdon 8
5205246 2417291 2417291 defendant Squyer Richard butcher 590039 590039 Squyer, Richard, of Huntyngdon, butcher 9
5205247 2417291 2417291 defendant Barre John husbandman 771616 771616 Barre, John, of Gunnecestre, husbandman 10
5205248 2417291 2417291 defendant Nowell Hobertus mercer 599063 599063 Nowell, Hobertus, of Huntingdon, mercer 11

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);