names

13 rows where case_id = 2229126

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4593002 2229126 2229126 plaintiff Overton Thomas clerk   Overton, Thomas, clerk, executors of 0
4593003 2229126 2229126 plaintiff Tibbay John, sen clerk   (Tibbay, John, sen, clerk 1
4593004 2229126 2229126 plaintiff Selby William clerk   Selby, William, clerk 2
4593005 2229126 2229126 plaintiff Everdon John clerk   Everdon, John, clerk 3
4593006 2229126 2229126 plaintiff Hesill William     Hesill, William 4
4593007 2229126 2229126 plaintiff Bys Edmunds     Bys, Edmunds 5
4593008 2229126 2229126 plaintiff Syewe Gervase chaplain   Syewe, Gervase, chaplain 6
4593009 2229126 2229126 plaintiff Messagere John chaplain   Messagere, John, chaplain 7
4593010 2229126 2229126 plaintiff Saureby John     together with Saureby, John 8
4593011 2229126 2229126 defendant Thorp John de clerk   Thorp, John de, clerk 0
4593012 2229126 2229126 defendant Bohum John de   623296 623296 Bohum, John de, of Midherst, knight 1
4593013 2229126 2229126 defendant Kirkeby Thomas de   769212 769212 Kirkeby, Thomas de, of East Bedfont, Middx 2
4593014 2229126 2229126 defendant Draper William clerk   Draper, William, clerk 3

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