names

6 rows where case_id = 2315443

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4863120 2315443 2315443 plaintiff Drask Nicholas fishmonger 585869 585869 Drask, Nicholas, of London, fishmonger 0
4863121 2315443 2315443 defendant Sampson John esq 592959 592959 Sampson, John, of Plymmouth, Devon, esq 0
4863122 2315443 2315443 defendant Fyssher Thomas chapman 586958 586958 Fyssher, Thomas, of Gloucester, chapman 1
4863123 2315443 2315443 defendant Strenesham or Strevesham John fishmonger 585869 585869 Strenesham or Strevesham, John, of London, fishmonger 2
4863124 2315443 2315443 defendant atte Burgh John esq 805491 805491 atte Burgh, John, of North Charteford, Hants, esq 3
4863125 2315443 2315443 defendant More Richard smith 761628 761628 More, Richard, of Berkhamstede, Herts, smith 4

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