names

18 rows where place_id = 590999

✎ 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
3602963 1868591 1868591 defendant Ferre William clerk 590999 590999 Ferre, William, of Milcote, Warks, clerk 0
3633251 1905216 1905216 defendant Grevyle Edward   590999 590999 Grevyle, Edward, of Milcote, Warks, and of King's household, knight 0
3633253 1905217 1905217 defendant Grevyle Edward   590999 590999 Grevyle, Edward, of Milcote, Warks, knight, and of Queen's household 0
3708881 1929068 1929068 defendant Grevile Edward   590999 590999 Grevile, Edward, of Milcote, Warks, knight 0
3720742 1932777 1932777 defendant Grevill Edward   590999 590999 Grevill, Edward, of Milcote, Warks, knight 0
3739086 1938435 1938435 defendant Grevill Edward   590999 590999 Grevill, Edward, of Milcote, Warks, knight 0
3739088 1938436 1938436 defendant Grevill Edward   590999 590999 Grevill, Edward, of Milcote, Warks, knight 0
3792048 1955365 1955365 defendant Grevell John esq 590999 590999 Grevell, John, of Milcote, Warks, esq 1
3818945 1963823 1963823 defendant Grevyle John esq 590999 590999 Grevyle, John, of Milcote, Warks, esq 1
3851911 1974191 1974191 defendant Grevyle Fulk esq 590999 590999 Grevyle, Fulk, of Milcote, Warks, esq 0
3872200 1980931 1980931 defendant Grevile Edward (legal representative) 590999 590999 Grevile, Edward, of Milcote, Warks, knight, administrator of 0
3878362 1983010 1983010 defendant Grevyle John esq 590999 590999 Grevyle, John, of Milcote, Warks, esq 1
5530348 2514002 2514002 defendant Grevell or Grenell John esq 590999 590999 Grevell or Grenell, John, of Milcote, Warks, esq 0
5540261 2517082 2517082 defendant Grevyle John esq 590999 590999 Grevyle, John, of Milcote, Warks, esq 0
5540298 2517095 2517095 defendant Grevyle John esq 590999 590999 Grevyle, John, of Milcote, Warks, or of Drayton, Oxon, esq 0
5540871 2517273 2517273 defendant Blake William yeoman 590999 590999 Blake, William, of Milcote, Warks, yeoman 4
5540994 2517309 2517309 defendant Grevyle John esq 590999 590999 Grevyle, John,of Milcote, Warks, esq 0
5546216 2518885 2518885 defendant Gryvell John esq 590999 590999 Gryvell, John, of Milcote, Warks, esq 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);