names

13 rows where case_id = 2272277

✎ 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
4722232 2272277 2272277 plaintiff Clyfford John knight   Clyfford, John, knight 0
4722233 2272277 2272277 defendant Shakespere Alan yeoman 778002 778002 Shakespere, Alan, of Amotbrig, yeoman 0
4722234 2272277 2272277 defendant Armete Robert yeoman 778002 778002 Armete, Robert, of Amotbrig, yeoman 1
4722235 2272277 2272277 defendant Wison John yeoman 778002 778002 Wison, John, of Amotbrig, yeoman 2
4722236 2272277 2272277 defendant Thomlynson John yeoman 791128 791128 Thomlynson, John, of Dolphanby, yeoman 3
4722237 2272277 2272277 defendant Dyfford Thomas, sen butcher 588851 588851 Dyfford, Thomas, sen, of Moreland, butcher 4
4722238 2272277 2272277 defendant Dyfford Thomas jun, of Moreland, yeoman   Dyfford, Thomas, jun, of Moreland, yeoman 5
4722239 2272277 2272277 defendant Holbatch Thomas husbandman 588851 588851 Holbatch, Thomas, of Moreland, husbandman 6
4722240 2272277 2272277 defendant Smyth Thomas yeoman 600493 600493 Smyth, Thomas, of Bolton, yeoman 7
4722241 2272277 2272277 defendant Lynck Robert miller 600493 600493 Lynck, Robert, of Bolton, miller 8
4722242 2272277 2272277 defendant Hogesson John husbandman 600493 600493 Hogesson, John, of Bolton, husbandman 9
4722243 2272277 2272277 defendant Hirde John husbandman 791129 791129 Hirde, John, of Clyburn, husbandman 10
4722244 2272277 2272277 defendant Cady Thomas husbandman 600493 600493 Cady, Thomas, of Bolton, husbandman 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);