names

23 rows where case_id = 1930573

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3713653 1930573 1930573 plaintiff Arundell John   843451 843451 Arundell, John, of Lanhern, knight 0
3713654 1930573 1930573 plaintiff Eggecombe Peter knight   Eggecombe, Peter, knight 1
3713655 1930573 1930573 plaintiff Basset John knight   Basset, John, knight 2
3713656 1930573 1930573 plaintiff Restatek John esq   Restatek, John, esq 3
3713657 1930573 1930573 plaintiff Carmynowe John esq   Carmynowe, John, esq 4
3713658 1930573 1930573 plaintiff Pensond Thomas esq   Pensond, Thomas, esq 5
3713659 1930573 1930573 plaintiff Carnesewe William esq   Carnesewe, William, esq 6
3713660 1930573 1930573 plaintiff Langdon Robert esq   Langdon, Robert, esq 7
3713661 1930573 1930573 plaintiff Cavell Nicholas     Cavell, Nicholas 8
3713662 1930573 1930573 plaintiff Roche William     Roche, William 9
3713663 1930573 1930573 plaintiff Tredenek Christopher     Tredenek, Christopher 10
3713664 1930573 1930573 plaintiff Calwodley John     Calwodley, John 11
3713665 1930573 1930573 plaintiff Wydeslande John     Wydeslande, John 12
3713666 1930573 1930573 plaintiff Upcott Thomas     Upcott, Thomas 13
3713667 1930573 1930573 plaintiff Juell Thomas     Juell, Thomas 14
3713668 1930573 1930573 plaintiff Parson John     Parson, John 15
3713669 1930573 1930573 plaintiff Tynner Stephen     Tynner, Stephen 16
3713670 1930573 1930573 plaintiff Juell John     Juell, John 17
3713671 1930573 1930573 plaintiff Peers William     Peers, William 18
3713672 1930573 1930573 plaintiff Comer John     Comer, John 19
3713673 1930573 1930573 plaintiff Peers John     Peers, John 20
3713674 1930573 1930573 plaintiff Tredwen John     Tredwen, John 21
3713675 1930573 1930573 defendant Fairechild Harvy yeoman 606006 606006 Fairechild, Harvy, of St Cleder, yeoman 0

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