names

12 rows where case_id = 2008576

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3954290 2008576 2008576 plaintiff Lakyn Miles gent   Lakyn, Miles, gent 0
3954291 2008576 2008576 defendant Fryer Nicholas clothier 659906 659906 Fryer, Nicholas, of Est Bergholt, Suff, clothier 0
3954292 2008576 2008576 defendant Clarke James butcher 591076 591076 Clarke, James, of Est Bergholt, laborer Labborn aloas Labie, Thomas, of Est Bergholt, butcher 1
3954293 2008576 2008576 defendant Fawcon Thomas clother 586402 586402 Fawcon, Thomas, of Hadley, Suff, clother 2
3954294 2008576 2008576 defendant Swynborn Henry clothier 585947 585947 Swynborn, Henry, of Hadley, clothier 3
3954295 2008576 2008576 defendant Sharle John clothier 651719 651719 Sharle, John, of Nayland, Suff, clothier 4
3954296 2008576 2008576 defendant Smyth john yeoman 659908 659908 Smyth, john, of Reddeswell, Essex, yeoman 5
3954297 2008576 2008576 defendant Swallowe William baker 659909 659909 Swallowe, William, of Chellmesford, Essex, baker 6
3954298 2008576 2008576 defendant Debney George clothier 586470 586470 Debney, George, of Colchester, clothier 7
3954299 2008576 2008576 defendant Whyney Robert gent 585869 585869 Whyney, Robert, of London, gent 8
3954300 2008576 2008576 defendant Webbe Roger husbandman 659910 659910 Webbe, Roger, of Long Whyttenham, Berks, husbandman 9
3954301 2008576 2008576 defendant Launce John, senior husbandman 659911 659911 Launce, John, senior, of Estdowne, Devon, husbandman 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);