names

24 rows where case_id = 2228334

✎ 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
4590294 2228334 2228334 plaintiff Mallom William de     Mallom, William de 0
4590295 2228334 2228334 defendant Pety William     Pety, William 0
4590296 2228334 2228334 defendant Wetyr Robert     Wetyr, Robert 1
4590297 2228334 2228334 defendant Southeby Godfrey     Southeby, Godfrey 2
4590298 2228334 2228334 defendant Dene John shoemaker   Dene, John, shoemaker 3
4590299 2228334 2228334 defendant Dene Helen     Helen, his wife 4
4590300 2228334 2228334 defendant Basse Robert     Basse, Robert 5
4590301 2228334 2228334 defendant Clerk William   772560 772560 Clerk, William, of Munkton 6
4590302 2228334 2228334 defendant Litster John     Litster, John 7
4590303 2228334 2228334 defendant Taillour William   606673 606673 Taillour, William, of Hull, clerk, son of John 8
4590304 2228334 2228334 defendant Flewath Robert de Kytechyn, Thomas de   Flewath, Robert de, Kytechyn, Thomas de 9
4590305 2228334 2228334 defendant Poklyngton Robert de chaplain   Poklyngton, Robert de, chaplain 10
4590306 2228334 2228334 defendant Sandall John de     Sandall, John de 11
4590307 2228334 2228334 defendant God John chaplain   God, John, chaplain 12
4590308 2228334 2228334 defendant Driffeld William cosour or horse dealer   Driffeld, William, cosour or horse dealer 13
4590309 2228334 2228334 defendant Bell Agnes     Bell, Agnes 14
4590310 2228334 2228334 defendant Pyrler John     Pyrler, John 15
4590311 2228334 2228334 defendant Crosseby Thomas de     Crosseby, Thomas de 16
4590312 2228334 2228334 defendant Crosseby William de     Crosseby, William de 17
4590313 2228334 2228334 defendant Judson Robert     Judson, Robert 18
4590314 2228334 2228334 defendant Pyper Adam     Pyper, Adam 19
4590315 2228334 2228334 defendant Taillour Robert     Taillour, Robert 20
4590316 2228334 2228334 defendant Southwayt John     Southwayt, John 21
4590317 2228334 2228334 defendant Heton John de tanner   together with Heton, John de, tanner 22

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