names

14 rows where case_id = 2527046

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5574273 2527046 2527046 defendant Pygot John gent 787186 787186 Pygot, John, of Loughton, Bucks, gent 0
5574274 2527046 2527046 defendant Pygot John, junior gent 901734 901734 Pygot, John, junior, of Bechyngton, Bucks, gent 1
5574275 2527046 2527046 defendant Couke or Conke Thomas chaplain 586035 586035 Couke or Conke, Thomas, of Buckingham, chaplain 2
5574276 2527046 2527046 defendant Baxson John yeoman 586035 586035 Baxson, John, of Buckingham, yeoman 3
5574277 2527046 2527046 defendant Grey John gent 586035 586035 Grey, John, of Buckingham, gent 4
5574278 2527046 2527046 defendant Ingoldesby William yeoman 586035 586035 Ingoldesby, William, of Buckingham, yeoman 5
5574279 2527046 2527046 defendant Grenfeld George gent 586035 586035 Grenfeld, George, of Buckingham, gent 6
5574280 2527046 2527046 defendant Rowe Thomas yeoman 586035 586035 Rowe, Thomas, of Buckingham, yeoman 7
5574281 2527046 2527046 defendant Spyllysbury Thomas yeoman 586035 586035 Spyllysbury, Thomas, of Buckingham, yeoman 8
5574282 2527046 2527046 defendant More Thomas yeoman 586035 586035 More, Thomas, of Buckingham, yeoman 9
5574283 2527046 2527046 defendant Webbys Richard yeoman 586035 586035 Webbys, Richard, of Buckingham, yeoman 10
5574284 2527046 2527046 defendant Shorlard Henry yeoman 586035 586035 Shorlard, Henry, of Buckingham, yeoman 11
5574285 2527046 2527046 defendant Coke Thomas yeoman 586035 586035 Coke, Thomas, of Buckingham, yeoman 12
5574286 2527046 2527046 defendant Eghton Richard yeoman 586035 586035 Eghton, Richard, of Buckingham, yeoman 13

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