names

15 rows where case_id = 2512732

✎ 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
5526058 2512732 2512732 plaintiff Hobart James     Hobart, James 0
5526059 2512732 2512732 defendant Greneweye John gent 588557 588557 Greneweye, John, of Tyverton, gent 0
5526060 2512732 2512732 defendant Rogers John gent 586262 586262 Rogers, John, of Kyrton, gent 1
5526061 2512732 2512732 defendant Palmer William gent 586378 586378 Palmer, William, of Tavestoke, gent 2
5526062 2512732 2512732 defendant Bryan Nowell gent 610505 610505 Bryan, Nowell, of Otterey St Mary, gent 3
5526063 2512732 2512732 defendant Solyng John yeoman 591181 591181 Solyng, John, of Stokyngham, yeoman 4
5526064 2512732 2512732 defendant Rondell John yeoman 591181 591181 Rondell, John, of Stokyngham, yeoman 5
5526065 2512732 2512732 defendant Benet John   610505 610505 Benet, John, of Otterey St Mary, hat maker 6
5526066 2512732 2512732 defendant Jago Martin yeoman 599723 599723 Jago, Martin, of Plympton, yeoman 7
5526067 2512732 2512732 defendant Baldewyn William yeoman 599723 599723 Baldewyn, William, of Plympton, yeoman 8
5526068 2512732 2512732 defendant Adam Nicholas yeoman 896404 896404 Adam, Nicholas, of Nymot Tray, yeoman 9
5526069 2512732 2512732 defendant Warner Richard yeoman 896405 896405 Warner, Richard, of Deane Priors, yeoman 10
5526070 2512732 2512732 defendant Hylle Philip yeoman 896406 896406 Hylle, Philip, of Baydecombe, yeoman 11
5526071 2512732 2512732 defendant Bonfessor Richard yeoman 610505 610505 Bonfessor, Richard, of Otterey St Mary, yeoman 12
5526072 2512732 2512732 defendant Coland William yeoman 733059 733059 Coland, William, of Nymet Rowland, 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);