names

16 rows where place_id = 617865

✎ 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
3721631 1933063 1933063 defendant Ascue Christopher esq 617865 617865 Ascue, Christopher, of Assheby, Lincs, esq 0
3820593 1964326 1964326 defendant Delalond William gent 617865 617865 Delalond, William, of Assheby, Lincs, gent 2
3897671 1989430 1989430 defendant Bossewell Thomas gent 617865 617865 Bossewell, Thomas, of Assheby, Lincs, gent 0
3913089 1994708 1994708 defendant Askewe Christopher esq 617865 617865 Askewe, Christopher, of Assheby, Lincs, esq 0
3916596 1995927 1995927 defendant Askewe Elizabeth widow 617865 617865 Askewe, Elizabeth, of Assheby, Lincs, widow 0
3924888 1998642 1998642 defendant Askewe Christopher esq 617865 617865 Askewe, Christopher, of Assheby, Lincs, esq 0
3928248 1999783 1999783 defendant Ayscoughe Richard gent 617865 617865 Ayscoughe, Richard, of Assheby, Lincs, gent 0
3934997 2002009 2002009 defendant Sandon William esq 617865 617865 Sandon, William, of Assheby, Lincs, esq 0
3934999 2002010 2002010 defendant Sandon William esq 617865 617865 Sandon, William, of Assheby, Lincs, esq 0
3942886 2004622 2004622 defendant Askeugh Christopher gent 617865 617865 Askeugh, Christopher, of Assheby, Lincs, gent 0
3976677 2016417 2016417 defendant Grene Philip yeoman 617865 617865 Grene, Philip, of Assheby, Lincs, yeoman 7
3976699 2016418 2016418 defendant Meares Lawrence esq 617865 617865 (Meares, Lawrence, of Assheby, Lincs, esq 13
4740033 2277599 2277599 defendant Thymolby Thomas esq 617865 617865 Thymolby, Thomas, of Assheby, Lincs, esq 0
5087982 2382860 2382860 defendant Garewell John husbandman 617865 617865 Garewell, John, of Assheby, Lincs, husbandman 3
5222933 2422421 2422421 defendant Trane or Trave John yeoman 617865 617865 Trane or Trave, John, of Assheby, Lincs, yeoman 2
5267588 2435623 2435623 defendant Sanden William gent 617865 617865 Sanden, William, of Assheby, Lincs, gent 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);