names

13 rows where case_id = 1904017

✎ 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
3629253 1904017 1904017 plaintiff Courtenay Katherine Countess of Devon   Courtenay, Katherine, Countess of Devon 0
3629254 1904017 1904017 defendant Cole Thomas gent 587161 587161 Cole, Thomas, of Cornewode, gent 0
3629255 1904017 1904017 defendant Crabbe Richard clerk 597633 597633 Crabbe, Richard, of Stawe, clerk 1
3629256 1904017 1904017 defendant Urseke or Viseke Thomas husbandman 597633 597633 Urseke or Viseke, Thomas, of Stawe, husbandman 2
3629257 1904017 1904017 defendant Newcombe Henry husbandman 597633 597633 Newcombe, Henry, of Stawe, husbandman 3
3629258 1904017 1904017 defendant Elycote Roger husbandman 597634 597634 Elycote, Roger, of Ekysborne, husbandman 4
3629259 1904017 1904017 defendant Bobyche William yeoman 597635 597635 Bobyche, William, of Brodewode, yeoman 5
3629260 1904017 1904017 defendant Bobyche William husbandman 597635 597635 Bobyche, William, of Brodewode, husbandman 6
3629261 1904017 1904017 defendant Wey Richard clerk 597636 597636 Wey, Richard, of Yengerlegh, clerk 7
3629262 1904017 1904017 defendant Wescote John stainer 597636 597636 Wescote, John, of Yengerlegh, stainer 8
3629263 1904017 1904017 defendant Browne William yeoman 597633 597633 Browne, William, of Stawe, yeoman 9
3629264 1904017 1904017 defendant Northcote John husbandman 597637 597637 Northcote, John, of Yexborne, husbandman 10
3629265 1904017 1904017 defendant Lyner Paul husbandman 597637 597637 Lyner, Paul, of Yexborne, husbandman 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);