names

13 rows where case_id = 2455997

✎ 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
5336540 2455997 2455997 plaintiff Hastyngges John esq, sheriff of Norf   Hastyngges, John, esq, sheriff of Norf 0
5336541 2455997 2455997 defendant Scarlet William gent 586130 586130 Scarlet, William, of Hoo, gent 0
5336542 2455997 2455997 defendant Codlyng Richard yeoman 586396 586396 Codlyng, Richard, of Yaxham, yeoman 1
5336543 2455997 2455997 defendant atte Parke Richard yeoman 586157 586157 atte Parke, Richard, of Mateshale, yeoman 2
5336544 2455997 2455997 defendant Leveryngton William, senior yeoman 586157 586157 Leveryngton, William, senior, of Mateshale, yeoman 3
5336545 2455997 2455997 defendant Lovegold William yeoman 586157 586157 Lovegold, William, of Mateshale, yeoman 4
5336546 2455997 2455997 defendant Pecher William yeoman 591136 591136 Pecher, William, of Mateshalebergh, yeoman 5
5336547 2455997 2455997 defendant Fulbourne Robert yeoman 592662 592662 Fulbourne, Robert, of Letton, yeoman 6
5336548 2455997 2455997 defendant Toftwod Robert yeoman 587172 587172 Toftwod, Robert, of Est Derham, yeoman 7
5336549 2455997 2455997 defendant Sadeler Thomas yeoman 587172 587172 Sadeler, Thomas, of Est Derham, yeoman 8
5336550 2455997 2455997 defendant Rysleye John esq 874887 874887 Rysleye, John, of Karbrook, esq 9
5336551 2455997 2455997 defendant Crosse John yeoman 874888 874888 Crosse, John, of Shopdam, yeoman 10
5336552 2455997 2455997 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);