names

13 rows where case_id = 2421309

✎ 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
5219068 2421309 2421309 plaintiff Hardbene John     Hardbene, John 0
5219069 2421309 2421309 defendant Clerk Thomas husbandman 588071 588071 Clerk, Thomas, of Multon, husbandman 0
5219070 2421309 2421309 defendant Cleymond William husbandman 586504 586504 Cleymond, William, of Frampton, husbandman 1
5219071 2421309 2421309 defendant Thukyll William gent 598887 598887 Thukyll, William, of Torkesey, gent 2
5219072 2421309 2421309 defendant Glover Richard husbandman 588071 588071 Glover, Richard, of Multon, husbandman 3
5219073 2421309 2421309 defendant Thory William son of Thory, William, of Ingoldmels, husbandman   Thory, William, son of Thory, William, of Ingoldmels, husbandman 4
5219074 2421309 2421309 defendant Arnowe William husbandman 780326 780326 Arnowe, William, of Burgh in le Merssh, husbandman 5
5219075 2421309 2421309 defendant Hudson John husandman 589796 589796 Hudson, John, of Leek, husandman 6
5219076 2421309 2421309 defendant Bysshop Thomas husbandman 817621 817621 Bysshop, Thomas, of Thorp juxta Waynflet, husbandman 7
5219077 2421309 2421309 defendant Bugge Thomas husbandman 650415 650415 Bugge, Thomas, of Parva Grymesby, husbandman 8
5219078 2421309 2421309 defendant Flaket William (legal representative) 588422 588422 Flaket, William, of Croyland, executors of 9
5219079 2421309 2421309 defendant Body John fisher 588422 588422 (Body, John, of Croyland, fisher 10
5219080 2421309 2421309 defendant Nutkyn John fisher 588422 588422 Nutkyn, John, of Croyland, fisher 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);