names

13 rows where case_id = 2330334

✎ 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
4912250 2330334 2330334 plaintiff Byron John knight   Byron, John, knight 0
4912251 2330334 2330334 defendant Kay John gent 679719 679719 Kay, John, of Wodsome, gent 0
4912252 2330334 2330334 defendant Kay Thomas gent 593199 593199 Kay, Thomas, of Almondbury, gent 1
4912253 2330334 2330334 defendant Marler Robert   593199 593199 Marler, Robert, of Almondbury, servant 2
4912254 2330334 2330334 defendant Kay Peter yeoman 593199 593199 Kay, Peter, of Almondbury, yeoman 3
4912255 2330334 2330334 defendant Kay Richard yeoman 648821 648821 Kay, Richard, of Thurstonland, yeoman 4
4912256 2330334 2330334 defendant Storres John yeoman 820916 820916 Storres, John, of Storres, yeoman 5
4912257 2330334 2330334 defendant Storres Thomas yeoman 820916 820916 Storres, Thomas, of Storres, yeoman 6
4912258 2330334 2330334 defendant Kay James yeoman 641372 641372 Kay, James, of Penyston, yeoman 7
4912259 2330334 2330334 defendant Jenkynson John yeoman 641372 641372 Jenkynson, John, of Penyston, yeoman 8
4912260 2330334 2330334 defendant Norton Thomas yeoman 598218 598218 Norton, Thomas, of Stanley, yeoman 9
4912261 2330334 2330334 defendant Kechyn Robert yeoman 615206 615206 Kechyn, Robert, of Ardeslawe, yeoman 10
4912262 2330334 2330334 defendant Walton John yeoman 641372 641372 Walton, John, of Penyston, 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);