names

13 rows where case_id = 2554604

✎ 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
5633949 2554604 2554604 plaintiff Tottington Alexander Bishop of Norwich   Tottington, Alexander, Bishop of Norwich, executors of 0
5633950 2554604 2554604 plaintiff Dallyng Thomas clerk   (Dallyng, Thomas, clerk 1
5633951 2554604 2554604 plaintiff Bernham William clerk   Bernham, William, clerk 2
5633952 2554604 2554604 plaintiff Thornham John clerk   Thornham, John, clerk 3
5633953 2554604 2554604 plaintiff Oldhalle Edmund esq   Oldhalle, Edmund, esq 4
5633954 2554604 2554604 plaintiff Paston William     Paston, William 5
5633955 2554604 2554604 defendant (not given) Adam vicar of Stanburne 779808 779808 Stanburne, Adam, of Walpool, vicar of Reveshale 0
5633956 2554604 2554604 defendant Gowthfeld Thomas   586306 586306 Gowthfeld, Thomas, of Ixworth, parson of Fersfeld 1
5633957 2554604 2554604 defendant (not given) Robert vicar of Baly 766360 766360 Baly, Robert, of Barwe, vicar of Dockyng 2
5633958 2554604 2554604 defendant Cok Walter procurator for Hugh Deye, parson of Thymelthorp   Cok, Walter, procurator for Hugh Deye, parson of Thymelthorp 3
5633959 2554604 2554604 defendant Hoppe John parson of Reydon, Redenhale   Hoppe, John, parson of Reydon, Redenhale 4
5633960 2554604 2554604 defendant Covyn John parson of Gasthorp   Covyn, John, parson of Gasthorp 5
5633961 2554604 2554604 defendant Storme Robert vicar of Parva Ryburgh   Storme, Robert, vicar of Parva Ryburgh 6

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