names

15 rows where case_id = 2172191

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4423457 2172191 2172191 plaintiff Grey Roger de knight   Grey, Roger de, knight 0
4423458 2172191 2172191 defendant Chapeleyn John, senior   587327 587327 Chapeleyn, John, senior, of Eton 0
4423459 2172191 2172191 defendant Chapeleyn Joan     Joan, his wife 1
4423460 2172191 2172191 defendant John son of the same John     John, son of the same John 2
4423461 2172191 2172191 defendant Walter John chaplain   Walter, John, chaplain 3
4423462 2172191 2172191 defendant (not given) Nicholas his brother   Nicholas, his brother 4
4423463 2172191 2172191 defendant Barre William     Barre, William 5
4423464 2172191 2172191 defendant Waryn William   587327 587327 Waryn, William, of Eton 6
4423465 2172191 2172191 defendant Teyl John     Teyl, John 7
4423466 2172191 2172191 defendant Baa Thomas le   754837 754837 Baa, Thomas le, of Wiboldeston 8
4423467 2172191 2172191 defendant Karon Thomas de Wyboldeston   Karon, Thomas, de Wyboldeston 9
4423468 2172191 2172191 defendant Stockyng William de dyer   Stockyng, William de, dyer 10
4423469 2172191 2172191 defendant atte Halle John     atte Halle, John 11
4423470 2172191 2172191 defendant Sacombe Geoffrey     Sacombe, Geoffrey 12
4423471 2172191 2172191 defendant Bateman Thomas de Wiboldeston or Wyboston     Bateman, Thomas de Wiboldeston or Wyboston 13

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