names

14 rows where place_id = 763523

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4496526 2199587 2199587 defendant Redhed John   763523 763523 Redhed, John, of Cicestre or Chichester 4
4498053 2200037 2200037 defendant Herchull John dyer 763523 763523 Herchull, John, of Cicestre, dyer 0
4498055 2200038 2200038 defendant Herthul John dyger 763523 763523 Herthul, John, of Cicestre, dyger 0
4532821 2210536 2210536 defendant Smoulyng John   763523 763523 Smoulyng, John, of Cicestre 0
4547234 2215067 2215067 defendant atte Welle Thomas   763523 763523 atte Welle, Thomas, of Cicestre 0
4548252 2215394 2215394 defendant Judewyn John   763523 763523 Judewyn, John, of Cicestre 0
4563699 2220212 2220212 defendant Gugge John haulier 763523 763523 Gugge, John, of Cicestre, haulier 0
4615021 2235709 2235709 defendant Manston Peter sadler 763523 763523 Manston, Peter, of Cicestre, sadler 0
4618724 2236863 2236863 plaintiff Hebbe John (legal representative) 763523 763523 Hebbe, John, of Cicestre, executor of 0
4619842 2237182 2237182 defendant Tracy Thomas chapman 763523 763523 Tracy, Thomas, of Cicestre, chapman 1
4619944 2237218 2237218 defendant Tracy Thomas chapman 763523 763523 Tracy, Thomas, of Cicestre, chapman 1
4621805 2237805 2237805 plaintiff Ledyerde Thomas   763523 763523 Ledyerde, Thomas, of Cicestre 0
5072880 2378374 2378374 defendant Puggemore John yeoman 763523 763523 Puggemore, John, of Cicestre or Cirencester, yeoman 2
5610061 2546854 2546854 defendant Fornour William   763523 763523 Fornour, William, of Cicestre or Chichester, parson of the church of St Olam or St Olave 0

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