names

14 rows where case_id = 2226197

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4583280 2226197 2226197 plaintiff (not given)   abbot of Fountains abbey   Fountains abbey, abbot of 0
4583281 2226197 2226197 defendant Wenslay John   771898 771898 Wenslay, John, of Ayerlagh 0
4583282 2226197 2226197 defendant Henryman John   771899 771899 Henryman, John, of Lyttonedale 1
4583283 2226197 2226197 defendant Marton John   771900 771900 Marton, John, of Nether Bordelay 2
4583284 2226197 2226197 defendant Diconson Thomas   771900 771900 Diconson, Thomas, of Nether Bordelay 3
4583285 2226197 2226197 defendant Jakson John   771900 771900 Jakson, John, of Nether Bordelay 4
4583286 2226197 2226197 defendant Cokson Thomas   771900 771900 Cokson, Thomas, of Nether Bordelay 5
4583287 2226197 2226197 defendant Dandysson John   587278 587278 Dandysson, John, of Calton 6
4583288 2226197 2226197 defendant del Myre William   771403 771403 del Myre, William, of Conyngston 7
4583289 2226197 2226197 defendant Wryght Walter de   771403 771403 Wryght, Walter de, of Conyngston 8
4583290 2226197 2226197 defendant Lambard William   771901 771901 Lambard, William, of Thresshefeld 9
4583291 2226197 2226197 defendant Lange Richard   771902 771902 Lange, Richard, of East Bolton 10
4583292 2226197 2226197 defendant Sharowe John   587266 587266 Sharowe, John, of Rypon 11
4583293 2226197 2226197 defendant Cumyn William   587266 587266 Cumyn, William, of Rypon 12

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