names

12 rows where case_id = 2322701

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4886694 2322701 2322701 plaintiff Vycars Thomas     Vycars, Thomas 0
4886695 2322701 2322701 defendant Westmorland William yeoman 817458 817458 Westmorland, William, of Knok, yeoman 0
4886696 2322701 2322701 defendant Westmorland John yeoman 817459 817459 Westmorland, John, of Evenwod, Durham, yeoman 1
4886697 2322701 2322701 defendant Huchonson John yeoman 817460 817460 Huchonson, John, of Kyllyrby, Durham, yeoman 2
4886698 2322701 2322701 defendant Matheweson Thomas yeoman 600493 600493 Matheweson, Thomas, of Bolton, yeoman 3
4886699 2322701 2322701 defendant Cleseby John yeoman 600493 600493 Cleseby, John, of Bolton, yeoman 4
4886700 2322701 2322701 defendant Soureby Richard yeoman 781694 781694 together with Soureby, Richard, of Temple Soureby, yeoman 5
4886701 2322701 2322701 defendant Soureby Ralph yeoman 592999 592999 Soureby, Ralph, of Merton, yeoman 6
4886702 2322701 2322701 defendant Mowebray William yeoman 817461 817461 Mowebray, William, of Kings Meuburn or Menburn Regis, yeoman 7
4886703 2322701 2322701 defendant Shiphirdson William yeoman 817462 817462 Shiphirdson, William, of Mekyl Askeby, yeoman 8
4886704 2322701 2322701 defendant Ry Robert yeoman 817458 817458 Ry, Robert, of Knok, yeoman 9
4886705 2322701 2322701 defendant Strykeland John yeoman 600493 600493 Strykeland, John, of Bolton, yeoman 10

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);