names

28 rows where case_id = 2521390

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5554667 2521390 2521390 plaintiff Hobart James knight   Hobart, James, knight 0
5554668 2521390 2521390 defendant Busshy Miles gent 608898 608898 Busshy, Miles, of Sleford, Lincs, gent 0
5554669 2521390 2521390 defendant Husse John   612120 612120 Husse, John, of Sleford, knight 1
5554670 2521390 2521390 defendant Salven William     Salven, William 2
5554671 2521390 2521390 defendant Husse William     Husse, William 3
5554672 2521390 2521390 defendant Husse Robert     Husse, Robert 4
5554673 2521390 2521390 defendant Musgrave Edward     Musgrave, Edward 5
5554674 2521390 2521390 defendant Biron Nicholas     Biron, Nicholas 6
5554675 2521390 2521390 defendant Dunham John     Dunham, John 7
5554676 2521390 2521390 defendant Wymbyssh John     Wymbyssh, John 8
5554677 2521390 2521390 defendant Dilcok Henry     Dilcok, Henry 9
5554678 2521390 2521390 defendant Knyght Thomas     Knyght, Thomas 10
5554679 2521390 2521390 defendant Knyght John     Knyght, John 11
5554680 2521390 2521390 defendant Hampden Edmund     Hampden, Edmund 12
5554681 2521390 2521390 defendant Savell John     Savell, John 13
5554682 2521390 2521390 defendant Hasylwode John     Hasylwode, John 14
5554683 2521390 2521390 defendant Butler Thomas     Butler, Thomas 15
5554684 2521390 2521390 defendant Aston John     Aston, John 16
5554685 2521390 2521390 defendant Besteney John     Besteney, John 17
5554686 2521390 2521390 defendant Chamber William     Chamber, William 18
5554687 2521390 2521390 defendant Smyth William     Smyth, William 19
5554688 2521390 2521390 defendant Quasshe Andrew     Quasshe, Andrew 20
5554689 2521390 2521390 defendant West William     West, William 21
5554690 2521390 2521390 defendant Arundell John     Arundell, John 22
5554691 2521390 2521390 defendant Savage John     Savage, John 23
5554692 2521390 2521390 defendant Prowde John     Prowde, John 24
5554693 2521390 2521390 defendant Arundell Edmund (legal representative)   Arundell, Edmund, executrix of 25
5554694 2521390 2521390 defendant Arundell Joan     Arundell, Joan 26

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