names

15 rows where case_id = 2039510

✎ 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
4041675 2039510 2039510 plaintiff Northlegh Richard gent, attorney of the bench   Northlegh, Richard, gent, attorney of the bench 0
4041676 2039510 2039510 defendant Week Edmund gent 680699 680699 Week, Edmund, of Brodwoodkelley, gent 0
4041677 2039510 2039510 defendant Newcomb Alexander husbandman 586264 586264 Newcomb, Alexander, of North Lewe, husbandman 1
4041678 2039510 2039510 defendant Horrys Thomas yeoman 604921 604921 Horrys, Thomas, of Templeton, yeoman 2
4041679 2039510 2039510 defendant Leede Joan widow 654269 654269 Leede, Joan, of Bakyngton, widow 3
4041680 2039510 2039510 defendant Gytford Robert gent 680693 680693 Gytford, Robert, of Beaworthye, gent 4
4041681 2039510 2039510 defendant Yeom Humphrey gent 644102 644102 Yeom Humphrey, of Hewysshe, gent 5
4041682 2039510 2039510 defendant Strowbridge George gent 586443 586443 Strowbridge, George, of Colyton, gent 6
4041683 2039510 2039510 defendant Fletcher Thomas yeoman 612586 612586 Fletcher, Thomas, of Bekyngton, yeoman 7
4041684 2039510 2039510 defendant Moyes Michael yeoman 614309 614309 Moyes, Michael, of Idesley, yeoman 8
4041685 2039510 2039510 defendant Wadlond John husbandman 586264 586264 Wadlond, John, of North Lewe, husbandman 9
4041686 2039510 2039510 defendant Carwythan John gent 680700 680700 Carwythan, John, of St Giles in the Jeathe, gent 10
4041687 2039510 2039510 defendant Westlake David yeoman 680701 680701 Westlake, David, of Byrynstowe, yeoman 11
4041688 2039510 2039510 defendant Slowman Thomas yeoman 621746 621746 Slowman, Thomas, of Sampford Courtney, yeoman 12
4041689 2039510 2039510 defendant Lebbett Robert yeoman 597003 597003 Lebbett, Robert, of South Tawton, yeoman 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);