names

31 rows where case_id = 2529445

✎ 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
5581984 2529445 2529445 plaintiff Cutte John knight, under treasurer   Cutte, John, knight, under treasurer 0
5581985 2529445 2529445 plaintiff Dudley Edmund esq   Dudley, Edmund, esq 1
5581986 2529445 2529445 defendant Fortescu Adrian   632816 632816 Fortescu, Adrian, of Stonor, Oxon, knight 0
5581987 2529445 2529445 defendant Fortescu John esq 902581 902581 Fortescu, John, of Ponesbury, Herts, esq 1
5581988 2529445 2529445 defendant Olyver John chaplain 900866 900866 Olyver, John, of Cherdlynch, Soms, chaplain 2
5581989 2529445 2529445 defendant Tayllour William yeoman 902582 902582 Tayllour, William, of Lydyard Bishop, Soms, yeoman 3
5581990 2529445 2529445 defendant Williams Thomas gent 902583 902583 Williams, Thomas, of Gyllouth, Herefs, gent 4
5581991 2529445 2529445 defendant Stancombe John gent 900865 900865 Stancombe, John, of Wynston, Glos, gent 5
5581992 2529445 2529445 defendant Querell David     Querell, David 6
5581993 2529445 2529445 defendant Percy Leonard     Percy, Leonard 7
5581994 2529445 2529445 defendant Bridge John     Bridge, John 8
5581995 2529445 2529445 defendant Brydge Roger     Brydge, Roger 9
5581996 2529445 2529445 defendant ap Redyth John     ap Redyth, John 10
5581997 2529445 2529445 defendant Appowell Morgan     Appowell, Morgan 11
5581998 2529445 2529445 defendant Sayton John     Sayton, John 12
5581999 2529445 2529445 defendant Mynskyp Edward     Mynskyp, Edward 13
5582000 2529445 2529445 defendant Wolff William     Wolff, William 14
5582001 2529445 2529445 defendant Stacy John     Stacy, John 15
5582002 2529445 2529445 defendant Percy Walter     Percy, Walter 16
5582003 2529445 2529445 defendant Rudyng Humphrey     Rudyng, Humphrey 17
5582004 2529445 2529445 defendant Gower Francis     Gower, Francis 18
5582005 2529445 2529445 defendant Godman George     Godman, George 19
5582006 2529445 2529445 defendant Rotherey Christopher     Rotherey, Christopher 20
5582007 2529445 2529445 defendant Herryson Richard     Herryson, Richard 21
5582008 2529445 2529445 defendant Hillys William     Hillys, William 22
5582009 2529445 2529445 defendant Hyllys Thomas     Hyllys, Thomas 23
5582010 2529445 2529445 defendant Waltar Robert     Waltar, Robert 24
5582011 2529445 2529445 defendant Stepneth John     Stepneth, John 25
5582012 2529445 2529445 defendant Goodyere Richard     Goodyere, Richard 26
5582013 2529445 2529445 defendant Bagotte Lewis     Bagotte, Lewis 27
5582014 2529445 2529445 defendant Bedolff John     Bedolff, John 28

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