names

19 rows where case_id = 2197217

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4488797 2197217 2197217 plaintiff Swynbourne Thomas knight   Swynbourne, Thomas, knight 0
4488798 2197217 2197217 defendant Shotwode John   628945 628945 Shotwode, John, of Brabourne 0
4488799 2197217 2197217 defendant Pankill John     Pankill, John 1
4488800 2197217 2197217 defendant Hethe Alan de   588582 588582 with Hethe, Alan de, of Godmersham 2
4488801 2197217 2197217 defendant Neel John     Neel, John 3
4488802 2197217 2197217 defendant Doul Thomas   600587 600587 Doul, Thomas, of Petham 4
4488803 2197217 2197217 defendant Andrewe William   586724 586724 Andrewe, William, of Waltham 5
4488804 2197217 2197217 defendant Slepere William   593913 593913 Slepere, William, of sTellyng 6
4488805 2197217 2197217 defendant Dad Bartholomew   593913 593913 Dad, Bartholomew, of Stellyng, junior 7
4488806 2197217 2197217 defendant Schotwode Thomas   593913 593913 Schotwode, Thomas, of Stellyng 8
4488807 2197217 2197217 defendant Knyte John   658022 658022 Knyte, John, of Lymynge, senior 9
4488808 2197217 2197217 defendant Knyte John   658022 658022 Knyte, John, of Lymynge, junior 10
4488809 2197217 2197217 defendant Havyfeld Simon     Havyfeld, Simon 11
4488810 2197217 2197217 defendant Pette Thomas clerk   Pette, Thomas, clerk 12
4488811 2197217 2197217 defendant atte Bere Anastachus     atte Bere, Anastachus 13
4488812 2197217 2197217 defendant Hamon Richard     Hamon, Richard 14
4488813 2197217 2197217 defendant Wyght Richard   600587 600587 Wyght, Richard, of Petham 15
4488814 2197217 2197217 defendant Mot William   586175 586175 Mot, William, of Canterbury 16
4488815 2197217 2197217 defendant Coupere Guy maltmaker 586175 586175 Coupere, Guy, of Canterbury, maltmaker 17

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