names

27 rows where case_id = 1961336

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3810985 1961336 1961336 plaintiff Bydwell Richard treasurer of Lions Inn   Bydwell, Richard, treasurer of Lions Inn 0
3810986 1961336 1961336 defendant Fowell Thomas gent 607107 607107 Fowell, Thomas, of Plymouth, Devon, gent 0
3810987 1961336 1961336 defendant Trye Thomas esq 633142 633142 Trye, Thomas, of Calydon, Warks, esq 1
3810988 1961336 1961336 defendant Coryton Peter gent 633143 633143 Coryton, Peter, of Trentreke, Cornw, gent 2
3810989 1961336 1961336 defendant Hurte Thomas gent 633144 633144 Hurte, Thomas, of Asshebourn, Derbs, gent 3
3810990 1961336 1961336 defendant Cokayn Henry gent 633145 633145 Cokayn, Henry, of Kynwalmarshe, Derbs, gent 4
3810991 1961336 1961336 defendant Ive Richard gent 633146 633146 Ive, Richard, of West Kyngton, Wilts, gent 5
3810992 1961336 1961336 defendant Warre Thomas esq 633147 633147 Warre, Thomas, of Corypole, Soms, esq 6
3810993 1961336 1961336 defendant Cooke John esq 588262 588262 Cooke, John, of Otery St Mary, Devon, esq 7
3810994 1961336 1961336 defendant Verney Robert     Verney, Robert 8
3810995 1961336 1961336 defendant Webber Richard     Webber, Richard 9
3810996 1961336 1961336 defendant Holbeme John     Holbeme, John 10
3810997 1961336 1961336 defendant Whytehed William     Whytehed, William 11
3810998 1961336 1961336 defendant Hays Martin     Hays, Martin 12
3810999 1961336 1961336 defendant Tregodeck John     Tregodeck, John 13
3811000 1961336 1961336 defendant Tyacke John     Tyacke, John 14
3811001 1961336 1961336 defendant Asteley Thomas     Asteley, Thomas 15
3811002 1961336 1961336 defendant Tremayn Thomas     Tremayn, Thomas 16
3811003 1961336 1961336 defendant Denys Nicholas     Denys, Nicholas 17
3811004 1961336 1961336 defendant Paslowe William     Paslowe, William 18
3811005 1961336 1961336 defendant Faryndon Charles     Faryndon, Charles 19
3811006 1961336 1961336 defendant Copleston Charles     Copleston, Charles 20
3811007 1961336 1961336 defendant Wylcokys Adam     Wylcokys, Adam 21
3811008 1961336 1961336 defendant Hody William     Hody, William 22
3811009 1961336 1961336 defendant Eggecombe John     Eggecombe, John 23
3811010 1961336 1961336 defendant Yeo William     Yeo, William 24
3811011 1961336 1961336 defendant Smyth William     Smyth, William 25

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