names

17 rows where case_id = 2354254

✎ 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
4991191 2354254 2354254 plaintiff Clyfford Thomas knight   Clyfford, Thomas, knight 0
4991192 2354254 2354254 defendant (not given) Thomas prior of Botson 600493 600493 Botson, Thomas, of Bolton, prior of the church of the BM 0
4991193 2354254 2354254 defendant Salley Thomas another brother, and canon of the same priory   Salley, Thomas, another brother, and canon of the same priory 1
4991194 2354254 2354254 defendant Thorp Christopher another brother   Thorp, Christopher, another brother 2
4991195 2354254 2354254 defendant Kay Nicholas canon in the same priory   Kay, Nicholas, canon in the same priory 3
4991196 2354254 2354254 defendant Bank Richard yeoman 831642 831642 Bank, Richard, of Thorescrosse, yeoman 4
4991197 2354254 2354254 defendant Fyncheden John chaplain 831643 831643 Fyncheden, John, of Weglesworth, chaplain 5
4991198 2354254 2354254 defendant Cokson Richard chaplain 586422 586422 Cokson, Richard, of Lynton, chaplain 6
4991199 2354254 2354254 defendant Colyer Henry yeoman 831644 831644 Colyer, Henry, of Nederdall, yeoman 7
4991200 2354254 2354254 defendant Colyer Richard of Nederdall yeoman   Colyer, Richard of Nederdall, yeoman 8
4991201 2354254 2354254 defendant Menewyth William yeoman 831645 831645 Menewyth, William, of Menewyth, yeoman 9
4991202 2354254 2354254 defendant Watson William yeoman 600493 600493 Watson, William, of Bolton, yeoman 10
4991203 2354254 2354254 defendant Falbergh Robert, sen yeoman 625853 625853 Falbergh, Robert, sen, of Berden, yeoman 11
4991204 2354254 2354254 defendant Falbergh Robert jun, of Berden, yeoman   Falbergh, Robert, jun, of Berden, yeoman 12
4991205 2354254 2354254 defendant Cokker William yeoman 625853 625853 Cokker, William, of Berden, yeoman 13
4991206 2354254 2354254 defendant Cokker Robert yeoman 831644 831644 Cokker, Robert, of Nederdall, yeoman 14
4991207 2354254 2354254 defendant Thropeland William yeoman 591949 591949 Thropeland, William, of Thorp, 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);