names

23 rows where place_id = 596926

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626654 1903186 1903186 defendant Smyth John clerk 596926 596926 Smyth, John, of Brokhole, clerk 0
3676725 1918754 1918754 defendant Knyght John   596926 596926 Knyght, John, of Brokhole, woolman, administrators of 0
3680989 1920133 1920133 defendant Knyght John (legal representative) 596926 596926 Knyght, John, of Brokhole, yeoman, executors of 1
3720977 1932857 1932857 defendant Skypton Robert yeoman 596926 596926 (Skypton, Robert, of Brokhole, yeoman 1
3770523 1948464 1948464 defendant Dyxwell John gent 596926 596926 Dyxwell, John, of Brokhole, gent 0
4449151 2184680 2184680 defendant Waldyng John   596926 596926 Waldyng, John, of Brokhole 0
4449152 2184680 2184680 defendant Lord John   596926 596926 Lord, John, of Brokhole 1
4454242 2186345 2186345 defendant Lucy Warin   596926 596926 Lucy, Warin, of Brokhole, knight 0
4461008 2188516 2188516 defendant Smyth John clerk 596926 596926 Smyth, John, of Brokhole, clerk 0
4461010 2188517 2188517 defendant Smyth John chaplain 596926 596926 Smyth, John, of Brokhole, chaplain 0
4527870 2208993 2208993 plaintiff Lucyen Warren   596926 596926 Lucyen, Warren, of Brokhole, knight 0
4527871 2208993 2208993 plaintiff Sprygy Katherine   596926 596926 Sprygy, Katherine, of Brokhole 1
4558531 2218619 2218619 plaintiff Lutyen Warin   596926 596926 Lutyen, Warin, of Brokhole, knight 0
4558532 2218619 2218619 plaintiff Spriggy Katherine   596926 596926 Spriggy, Katherine, of Brokhole 1
4618048 2236654 2236654 defendant Spryggy Katherine   596926 596926 Spryggy, Katherine, of Brokhole 1
4930378 2335900 2335900 defendant Andrewe John husbandman 596926 596926 Andrewe, John, of Brokhole, husbandman 0
4931711 2336305 2336305 defendant Newenham Thomas gent 596926 596926 Newenham, Thomas, of Brokhole, executors of (Catesby, Robert, of Newenham, Nhants, gent 0
5032869 2366498 2366498 defendant Andreu John husbandman 596926 596926 Andreu, John, of Brokhole, husbandman 0
5578654 2528390 2528390 defendant Knyght Agnes widow 596926 596926 Knyght, Agnes, of Brokhole, widow 2
5585942 2530656 2530656 defendant Smyth John clerk 596926 596926 Smyth, John, of Brokhole, clerk 0
5585943 2530656 2530656 defendant Smyth Thomas husbandman 596926 596926 Smyth, Thomas, of Brokhole, husbandman 1
5585944 2530656 2530656 defendant Smyth Robert husbandman 596926 596926 Smyth, Robert, of Brokhole, husbandman 2
5585951 2530659 2530659 defendant Grene Philip   596926 596926 Grene, Philip, of Brokhole, shepherd 0

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