names

13 rows where case_id = 2472606

✎ 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
5391349 2472606 2472606 plaintiff Pelham William     Pelham, William 0
5391350 2472606 2472606 defendant Morley William gent 589579 589579 Morley, William, of Glynde, gent 0
5391351 2472606 2472606 defendant Cobham Reginald gent 882127 882127 Cobham, Reginald, of Edinbrigge, Kent, gent 1
5391352 2472606 2472606 defendant West John yeoman 589579 589579 West, John, of Glynde, yeoman 2
5391353 2472606 2472606 defendant Hose Richard yeoman 882128 882128 Hose, Richard, of Maryffeld, yeoman 3
5391354 2472606 2472606 defendant Rouland John tanner 587875 587875 Rouland, John, of Brasted, Kent, tanner 4
5391355 2472606 2472606 defendant Russh Henry yeoman 882127 882127 Russh, Henry, of Edinbrigge, Kent, yeoman 5
5391356 2472606 2472606 defendant Brok John yeoman 882129 882129 Brok, John, of Edinbrigge, yeoman 6
5391357 2472606 2472606 defendant Godfrey John yeoman 622118 622118 Godfrey, John, of Lamberhurst, yeoman 7
5391358 2472606 2472606 defendant Boteler Richard husbandman 791965 791965 Boteler, Richard, of Chidyngston, Kent, husbandman 8
5391359 2472606 2472606 defendant Thomson John cutler 587374 587374 Thomson, John, of Lewes, cutler 9
5391360 2472606 2472606 defendant Pylcher John, junior yeoman 616267 616267 Pylcher, John, junior, of Herfeld, yeoman 10
5391361 2472606 2472606 defendant Grantham David yeoman 633973 633973 Grantham, David, of Rotherfeld, yeoman 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);