names

33 rows where case_id = 1977283

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation

id ▼ case_id role surname forename occupation place_id raw_segment seq
3861399 1977283 1977283 plaintiff (not given) Thomas abbot of Ford Abbey   Ford Abbey, Thomas, abbot of 0
3861400 1977283 1977283 defendant Smyth John clerk 601694 601694 Smyth, John, of Northam, clerk 0
3861401 1977283 1977283 defendant Wescote Sebastian chaplain 641410 641410 Wescote, Sebastian, of Chymlegh, chaplain 1
3861402 1977283 1977283 defendant Machyn William chaplain 608836 608836 Machyn, William, of Sele Monks, chaplain 2
3861403 1977283 1977283 defendant Bolehed Robert chaplain 591749 591749 Bolehed, Robert, of South Molton, chaplain 3
3861404 1977283 1977283 defendant Shaper John chaplain 603671 603671 Shaper, John, of Highamton, chaplain 4
3861405 1977283 1977283 defendant Chubbe Walter chaplain 641411 641411 Chubbe, Walter, of Mary Hyghbury, chaplain 5
3861406 1977283 1977283 defendant Tracy Thomas chaplain 641412 641412 Tracy, Thomas, of Langkey, chaplain 6
3861407 1977283 1977283 defendant Estmonde Richard chaplain 641413 641413 Estmonde, Richard, of Alryngton, chaplain 7
3861408 1977283 1977283 defendant Hony Peter chaplain 641414 641414 Hony, Peter, of Goodley, chaplain 8
3861409 1977283 1977283 defendant Countclyff John chaplain 641415 641415 Countclyff, John, of Kentysbere, chaplain 9
3861410 1977283 1977283 defendant Wode Walter chaplain 641416 641416 Wode, Walter, of Frydelstoke, chaplain 10
3861411 1977283 1977283 defendant Greer Thomas     Greer, Thomas 11
3861412 1977283 1977283 defendant Pynde John     Pynde, John 12
3861413 1977283 1977283 defendant Warren Richard     Warren, Richard 13
3861414 1977283 1977283 defendant Gray Robert     Gray, Robert 14
3861415 1977283 1977283 defendant Yorcombe Roger     Yorcombe, Roger 15
3861416 1977283 1977283 defendant Buller Richard     Buller, Richard 16
3861417 1977283 1977283 defendant Hogge Thomas     Hogge, Thomas 17
3861418 1977283 1977283 defendant Lutton Robert     Lutton, Robert 18
3861419 1977283 1977283 defendant Wutton John     Wutton, John 19
3861420 1977283 1977283 defendant Payne John     Payne, John 20
3861421 1977283 1977283 defendant Laverton John     Laverton, John 21
3861422 1977283 1977283 defendant Bowden Thomas     Bowden, Thomas 22
3861423 1977283 1977283 defendant Croke Nicholas     Croke, Nicholas 23
3861424 1977283 1977283 defendant Swettman John     Swettman, John 24
3861425 1977283 1977283 defendant Luxston henry     Luxston, henry 25
3861426 1977283 1977283 defendant Combe Henry     Combe, Henry 26
3861427 1977283 1977283 defendant Croft John     Croft, John 27
3861428 1977283 1977283 defendant Stawford John     Stawford, John 28
3861429 1977283 1977283 defendant Hyckes John     Hyckes, John 29
3861430 1977283 1977283 defendant Newcombe John     Newcombe, John 30
3861431 1977283 1977283 defendant Richard Benedict et al     Richard, Benedict et al 31

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