names

13 rows where case_id = 2398979

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5142647 2398979 2398979 plaintiff Wydeslade John, senior protonotary of the Bench   Wydeslade, John, senior, protonotary of the Bench, on his own account 0
5142648 2398979 2398979 defendant Morton John (legal representative) 852435 852435 Morton, John, of Ilfradycombe or Ilfracombe, clerk & parson, executors of 0
5142649 2398979 2398979 defendant Spyre John yeoman 586036 586036 (Spyre, John, of Exeter, yeoman 1
5142650 2398979 2398979 defendant Dobbe Richard yeoman 586036 586036 Dobbe, Richard, of Exeter, yeoman 2
5142651 2398979 2398979 defendant Ryton John goldsmith 586036 586036 Ryton, John, of Exeter, goldsmith 3
5142652 2398979 2398979 defendant Luffyntote William yeoman 586036 586036 Luffyntote, William, of Exeter, yeoman 4
5142653 2398979 2398979 defendant Andrewes Thomas capenter 586036 586036 Andrewes, Thomas, of Exeter, capenter 5
5142654 2398979 2398979 defendant Hayman Robert (legal representative) 852436 852436 Hayman, Robert, of Bokelond bruer, vicar, executor of 6
5142655 2398979 2398979 defendant Estecombe John husbandman 598270 598270 Estecombe, John, of Bokelond brewer, husbandman 7
5142656 2398979 2398979 defendant Denys Henry (legal representative) 768844 768844 Denys, Henry, of Boklond bruer, gent, , executor of Robert Hayman, vicar, executors of 8
5142657 2398979 2398979 defendant Denys Christine widow & formerly wife of Testator   (Denys, Christine, widow & formerly wife of Testator 9
5142658 2398979 2398979 defendant Denys Richard gent 585869 585869 Denys, Richard, of London, gent 10
5142659 2398979 2398979 defendant Michell John gent 598270 598270 Michell, John, of Bokelond bruer, gent 11

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