names

27 rows where case_id = 1982051

✎ 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
3875507 1982051 1982051 plaintiff (not given) John abbot of Forde Abbey   Forde Abbey, John, abbot of 0
3875508 1982051 1982051 defendant Smyth John clerk 601694 601694 Smyth, John, of Northam, clerk 0
3875509 1982051 1982051 defendant Wescote Sebastian chaplain 641410 641410 Wescote, Sebastian, of Chymlegh, chaplain 1
3875510 1982051 1982051 defendant Machyn William chaplain 608836 608836 Machyn, William, of Sele Monks, chaplain 2
3875511 1982051 1982051 defendant Bolehed Robert clerk 591749 591749 Bolehed, Robert, of South Molton, clerk 3
3875512 1982051 1982051 defendant Shaper John chaplain 632318 632318 Shaper, John, of Highampton, chaplain 4
3875513 1982051 1982051 defendant Chubbe Walter chaplain 641411 641411 Chubbe, Walter, of Mary Hyghbury, chaplain 5
3875514 1982051 1982051 defendant Tracy Thomas chaplain 641412 641412 Tracy, Thomas, of Langkey, chaplain 6
3875515 1982051 1982051 defendant Estmonde Richard chaplain 641413 641413 Estmonde, Richard, of Alryngton, chaplain 7
3875516 1982051 1982051 defendant Hony Peter     Hony, Peter 8
3875517 1982051 1982051 defendant Countclyff John     Countclyff, John 9
3875518 1982051 1982051 defendant Wode Walter     Wode, Walter 10
3875519 1982051 1982051 defendant Greer Thomas     Greer, Thomas 11
3875520 1982051 1982051 defendant Pynde John     Pynde, John 12
3875521 1982051 1982051 defendant Warren Richard     Warren, Richard 13
3875522 1982051 1982051 defendant Gray Robert     Gray, Robert 14
3875523 1982051 1982051 defendant Yorcom Roger     Yorcom, Roger 15
3875524 1982051 1982051 defendant Buller Richard     Buller, Richard 16
3875525 1982051 1982051 defendant Hogge Thomas     Hogge, Thomas 17
3875526 1982051 1982051 defendant Lutton Robert     Lutton, Robert 18
3875527 1982051 1982051 defendant Wutton John     Wutton, John 19
3875528 1982051 1982051 defendant Payne John     Payne, John 20
3875529 1982051 1982051 defendant Laverton John     Laverton, John 21
3875530 1982051 1982051 defendant Bowdon Thomas     Bowdon, Thomas 22
3875531 1982051 1982051 defendant Croke Nicholas     Croke, Nicholas 23
3875532 1982051 1982051 defendant Swettman John     Swettman, John 24
3875533 1982051 1982051 defendant Luxston Henry et al     Luxston, Henry et al 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);