names

20 rows where case_id = 2186380

✎ 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
4454340 2186380 2186380 plaintiff Lymynour Henry     Lymynour, Henry 0
4454341 2186380 2186380 defendant Crowe John     Crowe, John 0
4454342 2186380 2186380 defendant Bron John     Bron, John 1
4454343 2186380 2186380 defendant Taillour Lucas   585936 585936 Taillour, Lucas, of Norwich 2
4454344 2186380 2186380 defendant Lyster Reginald   585936 585936 Lyster, Reginald, of Norwich 3
4454345 2186380 2186380 defendant Dankyn Alexander   612631 612631 Dankyn, Alexander, of Hemyngham 4
4454346 2186380 2186380 defendant Plomer Thomas     Plomer, Thomas 5
4454347 2186380 2186380 defendant ryngware John   588821 588821 ryngware, John, of buxton 6
4454348 2186380 2186380 defendant Annot Roger     Annot, Roger 7
4454349 2186380 2186380 defendant Note Thomas     Note, Thomas 8
4454350 2186380 2186380 defendant Smyth William   588126 588126 Smyth, William, of North Walsham 9
4454351 2186380 2186380 defendant rylyng John     rylyng, John 10
4454352 2186380 2186380 defendant Alfeld John     Alfeld, John 11
4454353 2186380 2186380 defendant Cobbe Hugh     Cobbe, Hugh 12
4454354 2186380 2186380 defendant Baxster John   758491 758491 Baxster, John, of South Walshm 13
4454355 2186380 2186380 defendant Wolman Adam     Wolman, Adam 14
4454356 2186380 2186380 defendant atte Hill Adam   591949 591949 atte Hill, Adam, of Thorp 15
4454357 2186380 2186380 defendant Rose Thomas     Rose, Thomas 16
4454358 2186380 2186380 defendant Colt John     Colt, John 17
4454359 2186380 2186380 defendant Beeston John de   585936 585936 Beeston, John de, of Norwich 18

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