names

17 rows where case_id = 2300140

✎ 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
4812865 2300140 2300140 plaintiff Haryngton Thomas     Haryngton, Thomas 0
4812866 2300140 2300140 defendant Roklay Robert esq 806110 806110 Roklay, Robert, of Rollay, esq 0
4812867 2300140 2300140 defendant Worsburgh John gent 592288 592288 Worsburgh, John, of Worsburgh, gent 1
4812868 2300140 2300140 defendant Birton Richard yeoman 596683 596683 Birton, Richard, of Berton, yeoman 2
4812869 2300140 2300140 defendant Calthorn Robert yeoman 769260 769260 Calthorn, Robert, of Wysburgh, yeoman 3
4812870 2300140 2300140 defendant Senyour Robert yeoman 596683 596683 Senyour, Robert, of Berton, yeoman 4
4812871 2300140 2300140 defendant Baude Thomas yeoman 806111 806111 Baude, Thomas, of Roklay, yeoman 5
4812872 2300140 2300140 defendant Slake John yeoman 767436 767436 Slake, John, of Berneslay, yeoman 6
4812873 2300140 2300140 defendant Hymmesworth John yeoman 592288 592288 Hymmesworth, John, of Worsburgh, yeoman 7
4812874 2300140 2300140 defendant Mokeson William yeoman 592288 592288 Mokeson, William, of Worsburgh, yeoman 8
4812875 2300140 2300140 defendant Elyson Henry yeoman 806111 806111 Elyson, Henry, of Roklay, yeoman 9
4812876 2300140 2300140 defendant Redsere John yeoman 806112 806112 Redsere, John, of Oxspryng, yeoman 10
4812877 2300140 2300140 defendant Wordsyworth William yeoman 586016 586016 Wordsyworth, William, of Denby, yeoman 11
4812878 2300140 2300140 defendant Jenkynson John yeoman 586016 586016 Jenkynson, John, of Denby, yeoman 12
4812879 2300140 2300140 defendant Roklay Robert yeoman 765795 765795 Roklay, Robert, of Byllynglay, yeoman 13
4812880 2300140 2300140 defendant Wade John yeoman 592288 592288 Wade, John, of Worsburgh, yeoman 14
4812881 2300140 2300140 defendant Prest John yeoman 806113 806113 Prest, John, of Bernyslay, yeoman 15

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