names

23 rows where case_id = 1930572

✎ 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
3713630 1930572 1930572 plaintiff Arundell John   843451 843451 Arundell, John, of Lanhern, knight 0
3713631 1930572 1930572 plaintiff Eggecombe Peter knight   Eggecombe, Peter, knight 1
3713632 1930572 1930572 plaintiff Basset John knight   Basset, John, knight 2
3713633 1930572 1930572 plaintiff Restatek John esq   Restatek, John, esq 3
3713634 1930572 1930572 plaintiff Carmynowe John esq   Carmynowe, John, esq 4
3713635 1930572 1930572 plaintiff Pensond Thomas esq   Pensond, Thomas, esq 5
3713636 1930572 1930572 plaintiff Carnesewe William esq   Carnesewe, William, esq 6
3713637 1930572 1930572 plaintiff Langdon Robert esq   Langdon, Robert, esq 7
3713638 1930572 1930572 plaintiff Cavell Nicholas     Cavell, Nicholas 8
3713639 1930572 1930572 plaintiff Roche William     Roche, William 9
3713640 1930572 1930572 plaintiff Tredenek Christopher     Tredenek, Christopher 10
3713641 1930572 1930572 plaintiff Calwodley John     Calwodley, John 11
3713642 1930572 1930572 plaintiff Wydeslande John     Wydeslande, John 12
3713643 1930572 1930572 plaintiff Upcott Thomas     Upcott, Thomas 13
3713644 1930572 1930572 plaintiff Juell Thomas     Juell, Thomas 14
3713645 1930572 1930572 plaintiff Parson John     Parson, John 15
3713646 1930572 1930572 plaintiff Tynner Stephen     Tynner, Stephen 16
3713647 1930572 1930572 plaintiff Juell John     Juell, John 17
3713648 1930572 1930572 plaintiff Peers William     Peers, William 18
3713649 1930572 1930572 plaintiff Comer John     Comer, John 19
3713650 1930572 1930572 plaintiff Peers John     Peers, John 20
3713651 1930572 1930572 plaintiff Tredwen John     Tredwen, John 21
3713652 1930572 1930572 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);