names

16 rows where case_id = 1903139

✎ 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
3626481 1903139 1903139 plaintiff Babyngton Thomas esq   Babyngton, Thomas, esq 0
3626482 1903139 1903139 plaintiff Cumberford Thomas esq   Cumberford, Thomas, esq 1
3626483 1903139 1903139 defendant Beamond James gent 596875 596875 Beamond, James, of Wylnale, gent 0
3626484 1903139 1903139 defendant Cradeley John yeoman 596876 596876 Cradeley, John, of Wednesbury, yeoman 1
3626485 1903139 1903139 defendant Gryffyth John laborer 596877 596877 Gryffyth, John, of Typton, laborer 2
3626486 1903139 1903139 defendant Carre George laborer 596877 596877 Carre, George, of Typton, laborer 3
3626487 1903139 1903139 defendant Melbourne Thomas laborer 596877 596877 Melbourne, Thomas, of Typton, laborer 4
3626488 1903139 1903139 defendant Hyggys Thomas laborer 596878 596878 Hyggys, Thomas, of Wylnall, laborer 5
3626489 1903139 1903139 defendant Chesshyre Richard laborer 596878 596878 Chesshyre, Richard, of Wylnall, laborer 6
3626490 1903139 1903139 defendant Hardman William laborer 596876 596876 Hardman, William, of Wednesbury, laborer 7
3626491 1903139 1903139 defendant Hoo John yeoman 596879 596879 Hoo, John, of Bradeley, yeoman 8
3626492 1903139 1903139 defendant Marston John laborer 596880 596880 Marston, John, of Bulston, laborer 9
3626493 1903139 1903139 defendant Marston Richard laborer 596880 596880 Marston, Richard, of Bulston, laborer 10
3626494 1903139 1903139 defendant Smyth Humphrey laborer 596878 596878 Smyth, Humphrey, of Wylnall, laborer 11
3626495 1903139 1903139 defendant Philyppys Robert laborer 596878 596878 Philyppys, Robert, of Wylnall, laborer 12
3626496 1903139 1903139 defendant Mercer John laborer 596876 596876 Mercer, John, of Wednesbury, laborer 13

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