names

13 rows where case_id = 2366858

✎ 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
5034170 2366858 2366858 plaintiff Stapilton Brian knight   Stapilton, Brian, knight 0
5034171 2366858 2366858 defendant Clayton John yeoman 826896 826896 Clayton, John, of Stoppord, Cheshire, yeoman 0
5034172 2366858 2366858 defendant Clayton Christopher yeoman 837669 837669 Clayton, Christopher, of Glossop, Derbs, yeoman 1
5034173 2366858 2366858 defendant Clayton Robert yeoman 761440 761440 Clayton, Robert, of Glossop, yeoman 2
5034174 2366858 2366858 defendant Wherneby John yeoman 837670 837670 Wherneby, John, of Mellour, Derbs, yeoman 3
5034175 2366858 2366858 defendant Wherneby Henry yeoman 826897 826897 Wherneby, Henry, of Stoppord, yeoman 4
5034176 2366858 2366858 defendant Clayton John yeoman 826897 826897 Clayton, John, of Stoppord, yeoman 5
5034177 2366858 2366858 defendant Clayton Nicholas yeoman 761440 761440 Clayton, Nicholas, of Glossop, yeoman 6
5034178 2366858 2366858 defendant Clayton James yeoman 826897 826897 Clayton, James, of Stoppord, yeoman 7
5034179 2366858 2366858 defendant Stafford Christopher yeoman 761440 761440 Stafford, Christopher, of Glossop, yeoman 8
5034180 2366858 2366858 defendant Turnour Thomas yeoman 826897 826897 Turnour, Thomas, of Stoppord, yeoman 9
5034181 2366858 2366858 defendant Mottrovine Roger yeoman 826897 826897 Mottrovine, Roger, of Stoppord, yeoman 10
5034182 2366858 2366858 defendant del Shawe Mathew yeoman 837671 837671 del Shawe, Mathew, of Hudresfeld, 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);