names

28 rows where case_id = 2249787

✎ 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
4662662 2249787 2249787 plaintiff Fresthorp Saloman     Fresthorp, Saloman 0
4662663 2249787 2249787 plaintiff Harburgh Henry clerk   Harburgh, Henry, clerk 1
4662664 2249787 2249787 plaintiff Martyn John     Martyn, John 2
4662665 2249787 2249787 plaintiff Tyrell Richard   779600 779600 Tyrell, Richard, of Ronceby 3
4662666 2249787 2249787 defendant (not given)   abbot of Wardon Abbey   Wardon Abbey, abbot of 0
4662667 2249787 2249787 defendant (not given)   prior of Chekesend Priory   Chekesend Priory, prior of 1
4662668 2249787 2249787 defendant (not given)   prior of Beaulieu Priory   Beaulieu Priory, prior of 2
4662669 2249787 2249787 defendant (not given)   prior of Lantony Priory   Lantony Priory, prior of 3
4662670 2249787 2249787 defendant St John Hospital Bedford priory of   St John Hospital, Bedford, priory of 4
4662671 2249787 2249787 defendant Grey Reginald   765930 765930 Grey, Reginald, of Ruthyn, knight 5
4662672 2249787 2249787 defendant Wenlok Thomas     Wenlok, Thomas 6
4662673 2249787 2249787 defendant Braybrok Gerard knight   Braybrok, Gerard, knight 7
4662674 2249787 2249787 defendant Hamelyn Ralph     Hamelyn, Ralph 8
4662675 2249787 2249787 defendant Felmebrigge Simon     Felmebrigge, Simon 9
4662676 2249787 2249787 defendant Corveyser Katherine     Corveyser, Katherine 10
4662677 2249787 2249787 defendant Risseby John     Risseby, John 11
4662678 2249787 2249787 defendant Westynton William     Westynton, William 12
4662679 2249787 2249787 defendant Fyssh John     Fyssh, John 13
4662680 2249787 2249787 defendant Northern John chaplain   Northern, John, chaplain 14
4662681 2249787 2249787 defendant Calt Alan     Calt, Alan 15
4662682 2249787 2249787 defendant Webbe John     Webbe, John 16
4662683 2249787 2249787 defendant Ploughwryght John     Ploughwryght, John 17
4662684 2249787 2249787 defendant Smyth William     Smyth, William 18
4662685 2249787 2249787 defendant Fyndell Hugh     Fyndell, Hugh 19
4662686 2249787 2249787 defendant Alnthorp Richard     Alnthorp, Richard 20
4662687 2249787 2249787 defendant Folt John     Folt, John 21
4662688 2249787 2249787 defendant Maldon John     Maldon, John 22
4662689 2249787 2249787 defendant Bocher William     Bocher, William 23

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