names

12 rows where case_id = 2549499

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5618165 2549499 2549499 plaintiff Mascell John     Mascell, John, on his own account 0
5618166 2549499 2549499 defendant Hadley Nicholas   588924 588924 Hadley, Nicholas, of Farnham, parson 0
5618167 2549499 2549499 defendant Mustom Robert chaplain 585869 585869 Mustom, Robert, of London, chaplain 1
5618168 2549499 2549499 defendant Parrok John   586201 586201 Parrok, John, of Spryngfeld, parson 2
5618169 2549499 2549499 defendant Notyngham John shoemaker 585869 585869 Notyngham, John, of London, shoemaker 3
5618170 2549499 2549499 defendant Bassyngbourn Thomas de knight   Bassyngbourn, Thomas de, knight, executors of 4
5618171 2549499 2549499 defendant Befford Alexander     (Befford, Alexander 5
5618172 2549499 2549499 defendant Befford Beatrice     Beatrice, his wife 6
5618173 2549499 2549499 defendant Preston Richard (legal representative)   Preston, Richard, executrix of 7
5618174 2549499 2549499 defendant Preston Alice formerly wife of Richard   Preston, Alice, formerly wife of Richard 8
5618175 2549499 2549499 defendant Chamberlayn Richard (legal representative) 906353 906353 Chamberlayn, Richard, of Horkslee, executrix of 9
5618176 2549499 2549499 defendant Chamberlayn Agnes formerly wife of Richard   Chamberlayn, Agnes, formerly wife of Richard 10

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