names

20 rows where case_id = 2547676

✎ 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
5612556 2547676 2547676 plaintiff Cavendyshh John de knight   Cavendyshh, John de, knight 0
5612557 2547676 2547676 plaintiff atte Hook Thomas     atte Hook, Thomas 1
5612558 2547676 2547676 plaintiff Kedyngton Robert de     Kedyngton, Robert de 2
5612559 2547676 2547676 plaintiff Peek John   594907 594907 Peek, John, of Cavendyssh 3
5612560 2547676 2547676 defendant (not given)   abbot of Tilteye   Tilteye, abbot of 0
5612561 2547676 2547676 defendant (not given)   prior of Ixworth   Ixworth, prior of 1
5612562 2547676 2547676 defendant Puk-- John de     Puk--, John de 2
5612563 2547676 2547676 defendant Sudbury John de     Sudbury, John de 3
5612564 2547676 2547676 defendant Hovel Robert     Hovel, Robert 4
5612565 2547676 2547676 defendant Gurnay Edmund     Gurnay, Edmund 5
5612566 2547676 2547676 defendant Ingelthorp William parson of the church, in   Ingelthorp, William, parson of the church, in 6
5612567 2547676 2547676 defendant B-- William     B--, William 7
5612568 2547676 2547676 defendant Holkham John     Holkham, John 8
5612569 2547676 2547676 defendant Gernoun Nicholas knight   Gernoun, Nicholas, knight 9
5612570 2547676 2547676 defendant Wyngefeld William knight   Wyngefeld, William, knight 10
5612571 2547676 2547676 defendant Rudham William clerk   Rudham, William, clerk 11
5612572 2547676 2547676 defendant Derham William vicar of the church, in   Derham, William, vicar of the church, in 12
5612573 2547676 2547676 defendant Pyshale John clerk   Pyshale, John, clerk 13
5612574 2547676 2547676 defendant Wolferston Roger de     Wolferston, Roger de 14
5612575 2547676 2547676 defendant Cakestrete John de     Cakestrete, John de 15

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