names

17 rows where place_id = 588054

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593198 1865503 1865503 defendant Assheby William esq 588054 588054 Assheby, William, of Lowesby, esq 0
3593202 1865504 1865504 defendant Assheby William esq 588054 588054 Assheby, William, of Lowesby, esq 0
4175390 2086860 2086860 defendant Asheby William   588054 588054 Asheby, William, of Lowesby, gent, his son 1
4351621 2147809 2147809 defendant Mather Richard gent 588054 588054 Mather, Richard, of Lowesby, gent 1
4605676 2232896 2232896 plaintiff Assheby Thomas   588054 588054 Assheby, Thomas, of Lowesby 0
4605678 2232897 2232897 plaintiff Assheby Thomas   588054 588054 Assheby, Thomas, of Lowesby 0
4605680 2232898 2232898 plaintiff Assheby Thomas   588054 588054 Assheby, Thomas, of Lowesby 0
4651896 2246530 2246530 plaintiff Assheby Thomas   588054 588054 Assheby, Thomas, of Lowesby 0
4692312 2263113 2263113 plaintiff Assheby Thomas   588054 588054 Assheby, Thomas, of Lowesby 0
4703602 2266504 2266504 defendant Shefeld William husbandman 588054 588054 Shefeld, William, of Lowesby, husbandman 3
4934231 2337095 2337095 plaintiff Assheby Thomas   588054 588054 Assheby, Thomas, of Lowesby 0
4959433 2344788 2344788 plaintiff Assheby Thomas, senior (legal representative) 588054 588054 Assheby, Thomas, senior, of Lowesby, executor of 0
4959438 2344789 2344789 plaintiff Assheby Thomas, senior (legal representative) 588054 588054 Assheby, Thomas, senior, of Lowesby, executor of 0
4986115 2352771 2352771 plaintiff Assheby Thomas   588054 588054 Assheby, Thomas, of Lowesby 2
5032157 2366280 2366280 plaintiff Assheby Thomas   588054 588054 Assheby, Thomas, of Lowesby 1
5235615 2425998 2425998 defendant Monke William carpenter 588054 588054 Monke, William, of Lowesby, carpenter 1
5296664 2444010 2444010 defendant Garland John butcher or glover 588054 588054 Garland, John, of Lowesby, butcher or glover 1

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