names

32 rows where case_id = 1944301

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
3757424 1944301 1944301 plaintiff Bidwell Richard treasurer of Leons Inn   Bidwell, Richard, treasurer of Leons Inn 0
3757425 1944301 1944301 defendant Kyrkeham Nicholas esq 585929 585929 Kyrkeham, Nicholas, of St Clement Danes, esq 0
3757426 1944301 1944301 defendant Goodyere Richard gent 585929 585929 Goodyere, Richard, of St Clement Danes, gent 1
3757427 1944301 1944301 defendant Bree William     Bree, William 2
3757428 1944301 1944301 defendant Waldem Richard     Waldem, Richard 3
3757429 1944301 1944301 defendant Tayllard Thomas     Tayllard, Thomas 4
3757430 1944301 1944301 defendant Kelke Thomas     Kelke, Thomas 5
3757431 1944301 1944301 defendant Trye Thomas     Trye, Thomas 6
3757432 1944301 1944301 defendant Denys John     Denys, John 7
3757433 1944301 1944301 defendant Constable Thomas     Constable, Thomas 8
3757434 1944301 1944301 defendant Beare John     Beare, John 9
3757435 1944301 1944301 defendant Betson William     Betson, William 10
3757436 1944301 1944301 defendant Martham William     Martham, William 11
3757437 1944301 1944301 defendant Bagger Thomas     Bagger, Thomas 12
3757438 1944301 1944301 defendant Battishill John     Battishill, John 13
3757439 1944301 1944301 defendant Charnote Henry     Charnote, Henry 14
3757440 1944301 1944301 defendant Bovy John     Bovy, John 15
3757441 1944301 1944301 defendant Walron William     Walron, William 16
3757442 1944301 1944301 defendant Cooke William     Cooke, William 17
3757443 1944301 1944301 defendant Heywode William     Heywode, William 18
3757444 1944301 1944301 defendant Pole German     Pole, German 19
3757445 1944301 1944301 defendant Gifford John     Gifford, John 20
3757446 1944301 1944301 defendant Coblegh John     Coblegh, John 21
3757447 1944301 1944301 defendant Hurte Thomas     Hurte, Thomas 22
3757448 1944301 1944301 defendant Ascugh William     Ascugh, William 23
3757449 1944301 1944301 defendant Vernay Robert     Vernay, Robert 24
3757450 1944301 1944301 defendant Cokayne Henry     Cokayne, Henry 25
3757451 1944301 1944301 defendant Coke John     Coke, John 26
3757452 1944301 1944301 defendant Coryton Peter     Coryton, Peter 27
3757453 1944301 1944301 defendant Peynter John     Peynter, John 28
3757454 1944301 1944301 defendant Eggecombe John     Eggecombe, John 29
3757455 1944301 1944301 defendant Tregodek John     Tregodek, John 30

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