names

19 rows where case_id = 2183053

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4443866 2183053 2183053 plaintiff Chaworth William de     Chaworth, William de 0
4443867 2183053 2183053 defendant Shirland Simon parson of the church, in   Shirland, Simon, parson of the church, in 0
4443868 2183053 2183053 defendant Merlache Robert chaplain   Merlache, Robert, chaplain 1
4443869 2183053 2183053 defendant Bardolfes William chaplain   Bardolfes, William, chaplain 2
4443870 2183053 2183053 defendant Deye Roger   639667 639667 Deye, Roger, of Shirland 3
4443871 2183053 2183053 defendant William formerly parish clerk of Shirland     William, formerly parish clerk of Shirland 4
4443872 2183053 2183053 defendant Shirland John de son of Henry   Shirland, John de, son of Henry 5
4443873 2183053 2183053 defendant Clerk Henry butler   Clerk, Henry, butler 6
4443874 2183053 2183053 defendant Chaumberleyn John     Chaumberleyn, John 7
4443875 2183053 2183053 defendant Hunt William parker   Hunt, William, parker 8
4443876 2183053 2183053 defendant Hirne John in the     Hirne, John in the 9
4443877 2183053 2183053 defendant Freke Nicholas     Freke, Nicholas 10
4443878 2183053 2183053 defendant Preste Hugh     Preste, Hugh 11
4443879 2183053 2183053 defendant Flesshewer John   596006 596006 Flesshewer, John, of Hegham 12
4443880 2183053 2183053 defendant Keys John     Keys, John 13
4443881 2183053 2183053 defendant Haye robert   596006 596006 Haye, robert, of Hegham 14
4443882 2183053 2183053 defendant Watte John     Watte, John 15
4443883 2183053 2183053 defendant Thacker Robert     Thacker, Robert 16
4443884 2183053 2183053 defendant Shirland John son of Henry, son of Gilbert   Shirland, John, son of Henry, son of Gilbert 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);