names

6 rows where case_id = 2528936

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5580347 2528936 2528936 plaintiff Byllynge Lawrence     Byllynge, Lawrence 0
5580348 2528936 2528936 defendant Rowndale Thomas shoemaker 902387 902387 Rowndale, Thomas, of Asshborne, shoemaker 0
5580349 2528936 2528936 defendant Shemeld Thomas husbandman 590406 590406 Shemeld, Thomas, of Dronfeld, husbandman 1
5580350 2528936 2528936 defendant Yobyn of Derby pouch maker   Yobyn, of Derby, pouch maker 2
5580351 2528936 2528936 defendant Goyte Elizabeth widow 601413 601413 Goyte, Elizabeth, of Bealper, widow 3
5580352 2528936 2528936 defendant Sandeacre Walter   902388 902388 Sandeacre, Walter, of Horyston, scythe grinder 4

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