names

17 rows where place_id = 614944

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3706340 1928270 1928270 defendant Thorpe alias Spycer William clothier 614944 614944 Thorpe alias Spycer, William, of Kyngeswood, Wilts, clothier 0
3882265 1984326 1984326 defendant Grevyll Robert gent 614944 614944 Grevyll, Robert, of Kyngeswood, Wilts, gent 0
3882482 1984404 1984404 defendant Grevell Robert gent 614944 614944 Grevell, Robert, of Kyngeswood, Wilts, gent 0
3882485 1984405 1984405 defendant Grevell Robert gent 614944 614944 Grevell, Robert, of Kyngeswood, Wilts, gent 0
3929137 2000084 2000084 plaintiff Brygges John clothier 614944 614944 Brygges, John, of Kyngeswood, Wilts, clothier 0
4066181 2048198 2048198 plaintiff Hodges Thomas (legal representative) 614944 614944 Hodges, Thomas, of Kyngeswood, Wilts, gent, executor of 0
4066184 2048199 2048199 plaintiff Hodges Thomas (legal representative) 614944 614944 Hodges, Thomas, of Kyngeswood, Wilts, gent, executor of 0
4133572 2072339 2072339 defendant Barrett Thomas yeoman 614944 614944 Barrett, Thomas, of Kyngeswood, Wilts, yeoman 1
4158916 2081187 2081187 defendant Deele Richard tanner 614944 614944 Deele, Richard, of Kyngeswood, Wilts, tanner 0
4206287 2097747 2097747 defendant Barrett Thomas yeoman 614944 614944 Barrett, Thomas, of Kyngeswood, Wilts, yeoman 0
4212813 2100016 2100016 defendant Webbe Nicholas clothier 614944 614944 Webbe, Nicholas, of Kyngeswood, Wilts, clothier 2
4278275 2122340 2122340 defendant Spearte Richard gent 614944 614944 Spearte, Richard, of Kyngeswood, Wilts, gent 0
4311471 2134157 2134157 defendant Cobbe William butcher 614944 614944 Cobbe, William, of Kyngeswood, Wilts, butcher 0
4320715 2137340 2137340 defendant Hamlyn William weaver 614944 614944 Hamlyn, William, of Kyngeswood, Wilts, weaver 0
4404192 2165972 2165972 defendant Webbe Edmund yeoman 614944 614944 Webbe, Edmund, of Kyngeswood, Wilts, yeoman 0
4404194 2165973 2165973 defendant Webbe Edmund yeoman 614944 614944 Webbe, Edmund, of Kyngeswood, Wilts, yeoman 0
4407381 2167030 2167030 defendant Hamlyn William fuller 614944 614944 Hamlyn, William, of Kyngeswood, Wilts, fuller 0

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