names

6 rows where case_id = 1914106

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3662238 1914106 1914106 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662239 1914106 1914106 defendant Hillersden John gent 605586 605586 Hillersden, John, of Tondon, Lincs, gent 0
3662240 1914106 1914106 defendant Mexe John   605587 605587 Mexe, John, of the premonstratensian Abbey of Newston, Lincs 1
3662241 1914106 1914106 defendant Hertwell John gent 605588 605588 Hertwell, John, of Tonnyng, Nhants, gent 2
3662242 1914106 1914106 defendant Whenecot Richard   605589 605589 Whenecot, Richard, of the Benedictine Order of St Andrew the Apostle, Tywardreth Priory, chief monk or Proctor 3
3662243 1914106 1914106 defendant Jacob Walter yeoman of the Guard at the King's Hospice   Jacob, Walter, yeoman of the Guard at the King's Hospice 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);