names

17 rows where place_id = 600069

✎ 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
3639563 1907183 1907183 defendant Prater John husbandman 600069 600069 Prater, John, of Hedyngton, husbandman 0
3649484 1910227 1910227 defendant Hoper Thomas husbandman 600069 600069 Hoper, Thomas, of Hedyngton, husbandman 0
3777273 1950638 1950638 plaintiff Chylde Thomas   600069 600069 Chylde, Thomas, of Hedyngton 0
4121231 2067888 2067888 defendant Turner Richard husbandman 600069 600069 Turner, Richard, of Hedyngton, husbandman 1
4133004 2072134 2072134 defendant Browne Francis clerk 600069 600069 Browne, Francis, of Hedyngton, clerk 0
4278673 2122474 2122474 defendant Townsyn John yeoman 600069 600069 Townsyn, John, of Hedyngton, yeoman 1
4451802 2185540 2185540 plaintiff Houchones William   600069 600069 Houchones, William, of Hedyngton 0
4451804 2185541 2185541 plaintiff Houchones William   600069 600069 Houchones, William, of Hedyngton 0
4595207 2229750 2229750 plaintiff Wormenhale John   600069 600069 Wormenhale, John, of Hedyngton, vicar 1
4641089 2243485 2243485 defendant Monk William   600069 600069 Monk, William, of Hedyngton 3
4641090 2243485 2243485 defendant Enford John   600069 600069 Enford, John, of Hedyngton 4
4881548 2321130 2321130 defendant Watkyns William gent 600069 600069 Watkyns, William, of Hedyngton, gent 0
4971794 2348490 2348490 defendant Toft Thomas laborer 600069 600069 Toft, Thomas, of Hedyngton, laborer 3
4989095 2353675 2353675 defendant Bonepas John chaplain 600069 600069 Bonepas, John, of Hedyngton, chaplain 0
5278989 2438964 2438964 defendant Temple John husbandman 600069 600069 Temple, John, of Hedyngton, husbandman 0
5491697 2502411 2502411 defendant Ewegele William husbandman 600069 600069 Ewegele, William, of Hedyngton, husbandman 0
5509681 2507861 2507861 defendant Watkyns Agnes (legal representative) 600069 600069 Watkyns, Agnes, of Hedyngton, administratrix of Watkyns, Robert, of Hedyngton, gent, executor of 4

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