names

13 rows where case_id = 2278729

✎ 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
4743834 2278729 2278729 plaintiff de la Pole William   794974 794974 de la Pole, William, of Suffolk, Earl 0
4743835 2278729 2278729 defendant Hume or Hunne Godfrey fisher 589509 589509 Hume or Hunne, Godfrey, of Aldeburgh, fisher 0
4743836 2278729 2278729 defendant Aldeth William fisher 589509 589509 Aldeth, William, of Aldeburgh, fisher 1
4743837 2278729 2278729 defendant Aldeth Semanus fisher 589509 589509 Aldeth, Semanus, of Aldeburgh, fisher 2
4743838 2278729 2278729 defendant Aldeth Robert fisher 589509 589509 Aldeth, Robert, of Aldeburgh, fisher 3
4743839 2278729 2278729 defendant Aldeth Richard fisher 589509 589509 Aldeth, Richard, of Aldeburgh, fisher 4
4743840 2278729 2278729 defendant Cros John fisher 589509 589509 Cros, John, of Aldeburgh, fisher 5
4743841 2278729 2278729 defendant Cros William fisher 589509 589509 Cros, William, of Aldeburgh, fisher 6
4743842 2278729 2278729 defendant Burgate John fisher 589509 589509 Burgate, John, of Aldeburgh, fisher 7
4743843 2278729 2278729 defendant Lynde Rogoer fisher 794977 794977 Lynde, Rogoer, of Aldeburh, fisher 8
4743844 2278729 2278729 defendant Charner William fisher 589509 589509 Charner, William, of Aldeburgh, fisher 9
4743845 2278729 2278729 defendant Crakeman Nicholas fisher 589509 589509 Crakeman, Nicholas, of Aldeburgh, fisher 10
4743846 2278729 2278729 defendant Jeve Thomas fisher 794978 794978 Jeve, Thomas, of Aldebrugh, fisher 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);