names

10 rows where place_id = 695684

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597028 1866694 1866694 defendant Peverell Thomas clothmaker 695684 695684 Peverell, Thomas, of Est Bergholte, Suff, clothmaker 2
3947171 2006076 2006076 defendant Mark John (legal representative) 695684 695684 Mark, John, of Est Bergholte, Suff, clothier, executor of 0
3976927 2016493 2016493 defendant Cole William clothier 695684 695684 Cole, William, of Est Bergholte, Suff, clothier 12
4110725 2064094 2064094 defendant Jervys Thomas gent 695684 695684 Jervys, Thomas, of East Bergholte, Suff, gent 1
4198937 2095185 2095185 defendant Baker William clothier 695684 695684 Baker, William, of East Bergholte, Suff, clothier 0
4198941 2095186 2095186 defendant Clarke Robert clothier 695684 695684 Clarke, Robert, of East Bergholte, Suff, clothier 0
4211791 2099677 2099677 defendant Manser Anthony clothier 695684 695684 Manser, Anthony, of Est Bergholte, Suff, clothier 2
4813794 2300425 2300425 defendant Hamstede John yeoman 695684 695684 Hamstede, John, of East Bergholte, Suff, yeoman 0
4813796 2300426 2300426 defendant Hamstede John yeoman 695684 695684 Hamstede, John, of East Bergholte, Suff, yeoman 0
5483722 2500081 2500081 defendant Peverell William, senior clothmaker 695684 695684 Peverell, William, senior, of Est Bergholte, Suff, clothmaker 2

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