names

14 rows where case_id = 2555196

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5635930 2555196 2555196 plaintiff Wilford William (legal representative) 586036 586036 Wilford, William, of Exeter, executors of 0
5635931 2555196 2555196 plaintiff Reymond Thomas     (Reymond, Thomas 1
5635932 2555196 2555196 plaintiff Hulle Henry brother of William   Hulle, Henry, brother of William 2
5635933 2555196 2555196 plaintiff Sturt Peter     Sturt, Peter 3
5635934 2555196 2555196 plaintiff Cole John   821410 821410 Cole John, of Nytheway 4
5635935 2555196 2555196 plaintiff Cole John Margaret widow of William   Margaret his wife, widow of William 5
5635936 2555196 2555196 defendant Degher Mathew dyer 908151 908151 Degher, Mathew, of Aysshperton, dyer 0
5635937 2555196 2555196 defendant Degher Edmund dyer 585871 585871 Degher, Edmund, of Taunton, Soms, dyer 1
5635938 2555196 2555196 defendant Dybbe Richard dyer 908152 908152 Dybbe, Richard, of Nywton Busshel, dyer 2
5635939 2555196 2555196 defendant Degher Richard dyer 744693 744693 Degher, Richard, of Brydeport, Dorset, dyer 3
5635940 2555196 2555196 defendant Degher Nicholas dyer 759641 759641 Degher, Nicholas, of Tottenesse, dyer 4
5635941 2555196 2555196 defendant Degher Richard dyer 601047 601047 Degher, Richard, of Charnemouth, dyer 5
5635942 2555196 2555196 defendant Degher John dyer 766718 766718 Degher, John, of Axmynstre, dyer 6
5635943 2555196 2555196 defendant Wastel Nicholas dyer 587118 587118 Wastel, Nicholas, of Exilond, dyer 7

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