names

13 rows where case_id = 2365606

✎ 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
5029851 2365606 2365606 plaintiff Par Thomas knight   Par, Thomas, knight 0
5029852 2365606 2365606 defendant (not given)   abbot of Coverham Abbey   Coverham Abbey, abbot of 0
5029853 2365606 2365606 defendant Skyrtenbek Robert monk   Skyrtenbek, Robert, monk 1
5029854 2365606 2365606 defendant Grenhode Henry yeoman 670985 670985 Grenhode, Henry, of Coverham, yeoman 2
5029855 2365606 2365606 defendant Bland William gent 837158 837158 Bland, William, of Skelbank in Sedbergh, gent 3
5029856 2365606 2365606 defendant de Boure Edmund yeoman 837159 837159 de Boure, Edmund, of Stanehall in Sedbergh, yeoman 4
5029857 2365606 2365606 defendant Hebilthwayte Richard yeoman 628360 628360 Hebilthwayte, Richard, of Sedbergh, yeoman 5
5029858 2365606 2365606 defendant Bland Thomas son of Bland, Henry, of Sedbergh, yeoman   Bland, Thomas, son of Bland, Henry, of Sedbergh, yeoman 6
5029859 2365606 2365606 defendant de Baynbryg Thomas son of de Baynbryg, Roger, of Sedbergh, yeoman   de Baynbryg, Thomas, son of de Baynbryg, Roger, of Sedbergh, yeoman 7
5029860 2365606 2365606 defendant Attekynson Richard son of Attekynson, John, of Sedbergh, yeoman   Attekynson, Richard, son of Attekynson, John, of Sedbergh, yeoman 8
5029861 2365606 2365606 defendant Attekynson Henry son of Attekynson, John, of Sedbergh, yeoman   Attekynson, Henry, son of Attekynson, John, of Sedbergh, yeoman 9
5029862 2365606 2365606 defendant Grenhode Roand yeoman 647722 647722 Grenhode, Roand, of Dent, yeoman 10
5029863 2365606 2365606 defendant Whyrygge Richard yeoman 628360 628360 Whyrygge, Richard, of Sedbergh, yeoman 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);