names

14 rows where place_id = 690261

✎ 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
4084162 2054611 2054611 defendant Gybbes Simon clerk 690261 690261 Gybbes, Simon, of Brampton, Nhants, clerk 1
4222937 2103511 2103511 defendant Hatton William   690261 690261 Hatton, William, of Brampton, Nhants, knight 0
4246561 2111824 2111824 defendant Norwich Charles esq 690261 690261 Norwich, Charles, of Brampton, Nhants, esq 0
4263920 2117592 2117592 defendant Norwiche Charles esq 690261 690261 Norwiche, Charles, of Brampton, Nhants, esq 0
4296927 2129001 2129001 defendant Norwiche Charles esq 690261 690261 Norwiche, Charles, of Brampton, Nhants, esq 0
4368123 2153654 2153654 defendant Norwiche or Norrydge Charles esq 690261 690261 Norwiche or Norrydge, Charles, of Brampton, Nhants, esq 0
4994839 2355310 2355310 defendant Malory William chapman 690261 690261 Malory, William, of Brampton, Nhants, chapman 0
5001405 2357298 2357298 defendant Ketyn William gent 690261 690261 Ketyn, William, of Brampton, Nhants, gent 1
5016169 2361614 2361614 defendant Smyth John clerk 690261 690261 Smyth, John, of Brampton, Nhants, clerk 0
5107047 2388492 2388492 defendant Carlele Richard yeoman 690261 690261 Carlele, Richard, of Brampton, Nhants, yeoman 1
5237874 2426660 2426660 defendant Boyvyld Hugh esq 690261 690261 Boyvyld, Hugh, of Brampton, Nhants, esq 3
5237879 2426661 2426661 defendant Boyvyld Hugh esq 690261 690261 Boyvyld, Hugh, of Brampton, Nhants, esq 3
5364056 2464416 2464416 defendant Dyngull John husbandman 690261 690261 Dyngull, John, of Brampton, Nhants, husbandman 0
5556462 2521863 2521863 defendant Reve William yeoman 690261 690261 Reve, William, of Brampton, Nhants, yeoman 1

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