names

10 rows where case_id = 2245123

✎ 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
4646774 2245123 2245123 plaintiff Reynold Thomas (legal representative) 590794 590794 Reynold, Thomas, of Stondon, executors of (Reynold, Joan, formerly wife of Thomas 0
4646775 2245123 2245123 plaintiff Reynold William son of Thomas   Reynold, William, son of Thomas 1
4646776 2245123 2245123 defendant Burre Richard   590564 590564 Burre, Richard, of Suthwold 0
4646777 2245123 2245123 defendant Fullere Hugh   590564 590564 Fullere, Hugh, of Suthwold 1
4646778 2245123 2245123 defendant Reynold John   593064 593064 Reynold, John, of Blakemore 2
4646779 2245123 2245123 defendant Gybbe William   593064 593064 Gybbe, William, of Blakemore 3
4646780 2245123 2245123 defendant Wolff Robert     Wolff, Robert 4
4646781 2245123 2245123 defendant White John   593064 593064 White, John, of Blakemore 5
4646782 2245123 2245123 defendant Goldhand William   595934 595934 Goldhand, William, of Suthweld 6
4646783 2245123 2245123 defendant Morice John   764573 764573 Morice, John, of Dudyngherst 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);