names

36 rows where place_id = 655100

✎ 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
3934929 2001986 2001986 defendant Radbard William clerk 655100 655100 Radbard, William, of Somerton, Soms, clerk 1
3934931 2001986 2001986 defendant Worth Humphrey gent 655100 655100 Worth, Humphrey, of Somerton, Soms, gent 3
3952964 2008105 2008105 defendant Pollard Thomas chapman 655100 655100 Pollard, Thomas, of Somerton, Soms, chapman 0
3955516 2008999 2008999 defendant Deane William mercer 655100 655100 Deane, William, of Somerton, Soms, yeoman, or of Eston Bassett, Wilts, mercer 0
3974870 2015775 2015775 plaintiff Hodges James gent 655100 655100 Hodges, James, of Somerton, Soms, gent 0
4005193 2026634 2026634 defendant Crane Thomas husbandman 655100 655100 Crane, Thomas, of Somerton, Soms, husbandman 0
4031963 2036098 2036098 defendant Ely John gent 655100 655100 Ely, John, of Somerton, Soms, gent 0
4035476 2037362 2037362 plaintiff Hodges James gent 655100 655100 Hodges, James, of Somerton, Soms, gent 0
4084535 2054745 2054745 defendant Busshell Humphrey clerk 655100 655100 Busshell, Humphrey, of Somerton, Soms, clerk 2
4113476 2065096 2065096 defendant Norrington Roger husbandman 655100 655100 Norrington, Roger, of Somerton, Soms, husbandman 0
4147427 2077241 2077241 defendant Marshall John husbandman 655100 655100 Marshall, John, of Somerton, Soms, husbandman 1
4200939 2095886 2095886 defendant Marshall John, senior husbandman 655100 655100 Marshall, John, senior, of Somerton, Soms, husbandman 0
4233694 2107308 2107308 defendant Hurde Peter yeoman 655100 655100 Hurde, Peter, of Somerton, Soms, yeoman 0
4302907 2131140 2131140 defendant Wourth Hugh gent 655100 655100 Wourth, Hugh, of Somerton, Soms, gent 2
4329679 2140221 2140221 defendant Bushopp John innholder 655100 655100 Bushopp, John, of Somerton, Soms, innholder 3
4372752 2155331 2155331 defendant Stronde or Stroude Robert gent 655100 655100 Stronde or Stroude, Robert, of Somerton, Soms, gent 1
4394711 2162817 2162817 defendant Strowde Robert gent 655100 655100 Strowde, Robert, of Somerton, Soms, gent 1
4398390 2164043 2164043 defendant Ely James gent 655100 655100 Ely, James, of Somerton, Soms, gent 2
4694736 2263849 2263849 defendant Dygon Richard chapman 655100 655100 Dygon, Richard, of Somerton, Soms, chapman 0
4739111 2277322 2277322 defendant Lylle John chapman 655100 655100 Lylle, John, of Somerton, Soms, chapman 3
4824936 2303834 2303834 defendant Beauchamp Thomas   655100 655100 Beauchamp, Thomas, of Somerton, Soms, knight 2
4889288 2323435 2323435 defendant Kene Reginald chapman 655100 655100 Kene, Reginald, of Somerton, Soms, chapman 0
4991228 2354261 2354261 defendant Kene Reginald chapman 655100 655100 Kene, Reginald, of Somerton, Soms, chapman 0
5364413 2464533 2464533 defendant Stafforde John chapman 655100 655100 Stafforde, John, of Somerton, Soms, chapman 0
5364420 2464534 2464534 defendant Stafforde John chapman 655100 655100 Stafforde, John, of Somerton, Soms, chapman 0
5367230 2465401 2465401 defendant Irlond Richard yeoman 655100 655100 Irlond, Richard, of Somerton, Soms, yeoman 0
5372576 2467022 2467022 defendant Erland alias Irland Richard yeoman 655100 655100 Erland alias Irland, Richard, of Somerton, Soms, yeoman 0
5398006 2474498 2474498 defendant Irlond Richard yeoman 655100 655100 Irlond, Richard, of Somerton, Soms, yeoman 1
5411091 2478276 2478276 defendant Irlond Richard yeoman 655100 655100 Irlond, Richard, of Somerton, Soms, yeoman 1
5411095 2478277 2478277 defendant Irlond Richard yeoman 655100 655100 Irlond, Richard, of Somerton, Soms, yeoman 1
5431674 2484436 2484436 defendant Sheperd Thomas yeoman 655100 655100 Sheperd, Thomas, of Somerton, Soms, yeoman 0
5431678 2484437 2484437 defendant Sheperd Thomas yeoman 655100 655100 Sheperd, Thomas, of Somerton, Soms, yeoman 0
5443758 2488057 2488057 defendant Irlond Richard yeoman 655100 655100 Irlond, Richard, of Somerton, Soms, yeoman 1
5460419 2493058 2493058 defendant Sheperd Thomas yeoman 655100 655100 Sheperd, Thomas, of Somerton, Soms, yeoman 0
5460420 2493058 2493058 defendant Yrlond Richard yeoman 655100 655100 Yrlond, Richard, of Somerton, Soms, yeoman 1
5478066 2498463 2498463 defendant Porter John gent 655100 655100 Porter, John, of Somerton, Soms, gent 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);