names

15 rows where case_id = 2172152

✎ 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
4423338 2172152 2172152 plaintiff Golde John   587327 587327 Golde, John, of Eton 0
4423339 2172152 2172152 defendant Chapeleyn John, senior   587327 587327 Chapeleyn, John, senior, of Eton 0
4423340 2172152 2172152 defendant Chapeleyn Joan     Joan, his wife 1
4423341 2172152 2172152 defendant John son of the same John     John, son of the same John 2
4423342 2172152 2172152 defendant Walter John chaplain   Walter, John, chaplain 3
4423343 2172152 2172152 defendant (not given) Nicholas his brother   Nicholas, his brother 4
4423344 2172152 2172152 defendant Barre William     Barre, William 5
4423345 2172152 2172152 defendant Waryn William   587327 587327 Waryn, William, of Eton 6
4423346 2172152 2172152 defendant Teyl John     Teyl, John 7
4423347 2172152 2172152 defendant Baa Thomas le   754837 754837 Baa, Thomas le, of Wiboldeston 8
4423348 2172152 2172152 defendant Karon Thomas de Wyboldeston   Karon, Thomas, de Wyboldeston 9
4423349 2172152 2172152 defendant Stockyng William dyer   Stockyng, William, dyer 10
4423350 2172152 2172152 defendant atte Halle John     atte Halle, John 11
4423351 2172152 2172152 defendant Sacomb Geoffrey     Sacomb, Geoffrey 12
4423352 2172152 2172152 defendant Bateman Thoams   754838 754838 Bateman, Thoams, of Wilboldeston 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);