names

13 rows where case_id = 2222128

✎ 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
4569788 2222128 2222128 plaintiff White Richard     White, Richard 0
4569789 2222128 2222128 defendant Mynyot John esq   Mynyot, John, esq 0
4569790 2222128 2222128 defendant Randson Walter   597124 597124 Randson, Walter, of Waynflete 1
4569791 2222128 2222128 defendant Davy William     Davy, William 2
4569792 2222128 2222128 defendant Wythson William   764602 764602 Wythson, William, of Ingoldmeles 3
4569793 2222128 2222128 defendant Chesterfeld Robert     Chesterfeld, Robert 4
4569794 2222128 2222128 defendant Riby John   593375 593375 Riby, John, of Tenelby 5
4569795 2222128 2222128 defendant Rasyn Thomas chaplain   Rasyn, Thomas, chaplain 6
4569796 2222128 2222128 defendant Coke Alan     Coke, Alan 7
4569797 2222128 2222128 defendant Rome (illegible) chaplain 587969 587969 Rome, _, of Cotes, chaplain 8
4569798 2222128 2222128 defendant Dogode Robert chaplain   Dogode, Robert, chaplain 9
4569799 2222128 2222128 defendant Ingoldesby John de   589611 589611 Ingoldesby, John de, of Hekyngton 10
4569800 2222128 2222128 defendant Marche Richard   586846 586846 Marche, Richard, of Lincoln 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);