names

13 rows where case_id = 2455996

✎ 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
5336527 2455996 2455996 plaintiff Hastyngges John esq, sheriff of Norf   Hastyngges, John, esq, sheriff of Norf 0
5336528 2455996 2455996 defendant Scarlet William gent 586130 586130 Scarlet, William, of Hoo, gent 0
5336529 2455996 2455996 defendant Codlyng Richard yeoman 586396 586396 Codlyng, Richard, of Yaxham, yeoman 1
5336530 2455996 2455996 defendant atte Parke Richard yeoman 586157 586157 atte Parke, Richard, of Mateshale, yeoman 2
5336531 2455996 2455996 defendant Leveryngton William, senior yeoman 586157 586157 Leveryngton, William, senior, of Mateshale, yeoman 3
5336532 2455996 2455996 defendant Lovegold William yeoman 586157 586157 Lovegold, William, of Mateshale, yeoman 4
5336533 2455996 2455996 defendant Pecher William yeoman 591136 591136 Pecher, William, of Mateshalebergh, yeoman 5
5336534 2455996 2455996 defendant Fulbourne Robert yeoman 592662 592662 Fulbourne, Robert, of Letton, yeoman 6
5336535 2455996 2455996 defendant Toftwod Robert yeoman 587172 587172 Toftwod, Robert, of Est Derham, yeoman 7
5336536 2455996 2455996 defendant Sadeler Thomas yeoman 587172 587172 Sadeler, Thomas, of Est Derham, yeoman 8
5336537 2455996 2455996 defendant Rysleye John esq 874887 874887 Rysleye, John, of Karbrook, esq 9
5336538 2455996 2455996 defendant Crosse John yeoman 874888 874888 Crosse, John, of Shopdam, yeoman 10
5336539 2455996 2455996 defendant Raven John yeoman 586043 586043 Raven, John, of Reymerston, 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);