names

16 rows where place_id = 593351

✎ 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
3611447 1871257 1871257 defendant Whitacre William husbandman 593351 593351 Whitacre, William, of Hakynton, husbandman 1
3611455 1871257 1871257 defendant Elnore John laborer 593351 593351 Elnore, John, of Hakynton, laborer 9
3622018 1874427 1874427 defendant Wattys Richard husbandman 593351 593351 Wattys, Richard, of Hakynton, husbandman 4
3857653 1976030 1976030 defendant Bolton Thomas husbandman 593351 593351 Bolton, Thomas, of Hakynton, husbandman 1
3858855 1976450 1976450 defendant Bolton Thomas husbandman 593351 593351 Bolton, Thomas, of Hakynton, husbandman 1
4489075 2197302 2197302 plaintiff Hagh Robert   593351 593351 Hagh, Robert, of Hakynton 2
4505533 2202265 2202265 defendant Tent John de (legal representative) 593351 593351 Tent, John de, of Hakynton, parson, executors of 0
4633400 2241301 2241301 defendant Hawe Richard (legal representative) 593351 593351 Hawe, Richard, of Hakynton, executors of 2
4658854 2248640 2248640 defendant Warde John farmer 593351 593351 Warde, John, of Hakynton, farmer 4
4681448 2259815 2259815 defendant Martyn William laborer 593351 593351 Martyn, William, of Hakynton, laborer 0
4796506 2295065 2295065 defendant Belsyre John husbandman 593351 593351 Belsyre, John, of Hakynton, husbandman 1
5366169 2465082 2465082 defendant Marley Richard husbandman 593351 593351 Marley, Richard, of Hakynton, husbandman 4
5369064 2465922 2465922 defendant Lambard John husbandman 593351 593351 Lambard, John, of Hakynton, husbandman 0
5401019 2475353 2475353 defendant Elnore Robert husbandman 593351 593351 Elnore, Robert, of Hakynton, husbandman 6
5478607 2498631 2498631 defendant Marley Richard husbandman 593351 593351 Marley, Richard, of Hakynton, husbandman 0
5618854 2549735 2549735 plaintiff Neuwenham Henry   593351 593351 Neuwenham, Henry, of Hakynton, vicar 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);