names

32 rows where place_id = 645681

✎ 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
3886839 1985860 1985860 defendant Tanner Henry mercer 645681 645681 Tanner, Henry, of Berkeley, Glos, mercer 1
3971443 2014572 2014572 plaintiff Ellys Edward yeoman 645681 645681 Ellys, Edward, of Berkeley, Glos, yeoman 0
3979694 2017491 2017491 defendant James William yeoman 645681 645681 James, William, of Berkeley, Glos, yeoman 0
4883443 2321744 2321744 defendant Donell William yeoman 645681 645681 Donell, William, of Berkeley, Glos, yeoman 0
4885438 2322331 2322331 defendant Berkeley James   645681 645681 Berkeley, James, of Berkeley, Glos, knight, Lord Berkeley 0
4887089 2322803 2322803 defendant Berkeley James   645681 645681 Berkeley, James, of Berkeley, Glos, knight, Lord Berkeley 0
4889116 2323386 2323386 defendant Donall William yeoman 645681 645681 Donall, William, of Berkeley, Glos, yeoman 0
4903339 2327654 2327654 defendant Berkeley James   645681 645681 Berkeley, James, of Berkeley, Glos, knight 0
4906159 2328517 2328517 defendant Berkeley James   645681 645681 Berkeley, James, of Berkeley, Glos, knight 0
4980368 2351071 2351071 defendant Mayowe John dyer 645681 645681 Mayowe, John, of Berkeley, Glos, dyer 2
5013625 2360827 2360827 defendant Dyer Joohn dyer 645681 645681 Dyer, Joohn, of Berkeley, Glos, dyer 0
5037064 2367709 2367709 defendant ap Rys Richard gent 645681 645681 ap Rys, Richard, of Berkeley, Glos, gent 0
5061402 2374996 2374996 defendant Chapman David chapman 645681 645681 Chapman, David, of Berkeley, Glos, chapman 2
5072112 2378149 2378149 defendant Tesyn Thomas husbandman 645681 645681 Tesyn, Thomas, of Berkeley, Glos, husbandman 0
5080139 2380546 2380546 defendant Barkeley James   645681 645681 Barkeley, James, of Berkeley, Glos, knight 0
5091067 2383783 2383783 defendant Berkeley William   645681 645681 Berkeley, William, of Berkeley, Glos, knight 0
5111836 2389852 2389852 defendant Pensy or Peusy Robert clerk 645681 645681 Pensy or Peusy, Robert, of Berkeley, Glos, clerk 1
5115671 2391011 2391011 defendant Thorp John gent 645681 645681 (Thorp, John, of Berkeley, Glos, gent 1
5115823 2391053 2391053 defendant Bateyne or Batyn Robert chaplain 645681 645681 Bateyne or Batyn, Robert, of Berkeley, Glos, or of Bristol, chaplain 0
5214807 2420051 2420051 defendant Berkeley Thomas, senior gent 645681 645681 Berkeley, Thomas, senior, of Berkeley, Glos, gent 0
5215247 2420188 2420188 defendant Berkeley James   645681 645681 Berkeley, James, of Berkeley, Glos, Lord Berkeley 0
5223623 2422596 2422596 defendant Bowezere William dyer 645681 645681 Bowezere, William, of Berkeley, Glos, dyer 0
5223953 2422689 2422689 defendant Anstell or Austell John clerk 645681 645681 Anstell or Austell, John, of Berkeley, Glos, or of Camerleton, clerk 0
5224226 2422756 2422756 defendant Anstell or Austell John clerk 645681 645681 Anstell or Austell, John, of Berkeley, Glos, or of Camelerton, Soms, clerk 0
5226340 2423371 2423371 defendant Berkeley Thomas gent 645681 645681 Berkeley, Thomas, of Berkeley, Glos, gent 0
5228626 2423980 2423980 defendant Berkeley James   645681 645681 Berkeley, James, of Berkeley, Glos, knight 0
5228631 2423981 2423981 defendant Berkeley James   645681 645681 Berkeley, James, of Berkeley, Glos, knight 0
5228636 2423982 2423982 defendant Berkeley James   645681 645681 Berkeley, James, of Berkeley, Glos, knight, Lord Berkeley 0
5243204 2428213 2428213 defendant Poyntz John esq 645681 645681 Poyntz, John, of Berkeley, Glos, esq 0
5344052 2458318 2458318 defendant Berkeley William   645681 645681 Berkeley, William, of Berkeley, Glos, knight, Lord Berkeley 0
5566255 2524728 2524728 defendant Shutwell John husbandman 645681 645681 Shutwell, John, of Berkeley, Glos, husbandman 2
5567076 2524954 2524954 defendant Berkeley James esq 645681 645681 Berkeley, James, of Berkeley, Glos, esq 7

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