names

37 rows where place_id = 610267

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3682739 1920701 1920701 defendant Fetherstonhaugh William yeoman 610267 610267 Fetherstonhaugh, William, of Hameryngham, yeoman 2
3703772 1927460 1927460 defendant Fethersnow alias Fetherstonhaugh William yeoman 610267 610267 Fethersnow alias Fetherstonhaugh, William, of Hameryngham, yeoman 0
3733338 1936658 1936658 defendant Fethersnowe William yeoman 610267 610267 Fethersnowe, William, of Hameryngham, yeoman 0
3747270 1941067 1941067 defendant Fethersnowe William yeoman 610267 610267 Fethersnowe, William, of Hameryngham, yeoman 0
3761577 1945636 1945636 defendant Jakeson Robert husbandman 610267 610267 Jakeson, Robert, of Hameryngham, husbandman 0
3761578 1945636 1945636 defendant Pape William husbandman 610267 610267 Pape, William, of Hameryngham, husbandman 1
3761579 1945636 1945636 defendant Kyme Richard husbandman 610267 610267 Kyme, Richard, of Hameryngham, husbandman 2
3761580 1945636 1945636 defendant Kyme John husbandman 610267 610267 Kyme, John, of Hameryngham, husbandman 3
3761581 1945636 1945636 defendant Slayman William husbandman 610267 610267 Slayman, William, of Hameryngham, husbandman 4
3826911 1966267 1966267 defendant Fetherstonhalgh William yeoman 610267 610267 Fetherstonhalgh, William, of Hameryngham, yeoman 0
3826912 1966267 1966267 defendant Fetherstonhalgh Lionel husbandman 610267 610267 Fetherstonhalgh, Lionel, of Hameryngham, husbandman 1
3836721 1969386 1969386 defendant Bellowe John gent 610267 610267 Bellowe, John, of Hameryngham, gent 0
3849840 1973535 1973535 defendant Fetherstonehawgh William husbandman 610267 610267 Fetherstonehawgh, William, of Hameryngham, husbandman 0
3849841 1973535 1973535 defendant Fetherstonehawgh Lionel husbandman 610267 610267 Fetherstonehawgh, Lionel, of Hameryngham, husbandman 1
3853845 1974834 1974834 defendant Fetherstonehalgh Lionel husbandman 610267 610267 Fetherstonehalgh, Lionel, of Hameryngham, husbandman 0
3868235 1979611 1979611 defendant Fetherstonhalgh Lionel husbandman 610267 610267 Fetherstonhalgh, Lionel, of Hameryngham, husbandman 0
3881908 1984204 1984204 defendant Bellowe John gent 610267 610267 Bellowe, John, of Hameryngham, gent 0
3939360 2003467 2003467 defendant Staymond William husbandman 610267 610267 Staymond, William, of Hameryngham, husbandman 2
3983860 2018999 2018999 plaintiff Stephenson Gregory husbandman 610267 610267 Stephenson, Gregory, of Hameryngham, husbandman 0
4535655 2211426 2211426 defendant Lange Robert   610267 610267 Lange, Robert, of Hameryngham 2
4634887 2241761 2241761 defendant Waterman Edmund   610267 610267 Waterman, Edmund, of Hameryngham 0
4634888 2241761 2241761 defendant Bossed_ William   610267 610267 Bossed_, William, of Hameryngham 1
4660374 2249072 2249072 defendant Waterman Edmund husbandman 610267 610267 Waterman, Edmund, of Hameryngham, husbandman 2
4674495 2257635 2257635 defendant Pynder William husbandman 610267 610267 Pynder, William, of Hameryngham, husbandman 1
4694257 2263703 2263703 defendant atte Park Thomas husbandman 610267 610267 atte Park, Thomas, of Hameryngham, husbandman 3
4879456 2320503 2320503 defendant Ratheby Thomas husbandman 610267 610267 Ratheby, Thomas, of Hameryngham, husbandman 0
5012163 2360405 2360405 defendant Derman John   610267 610267 Derman, John, of Hameryngham, parson 0
5021446 2363181 2363181 defendant Tasker Richard husbandman 610267 610267 Tasker, Richard, of Hameryngham, husbandman 3
5021447 2363181 2363181 defendant Raytheby Thomas husbandman 610267 610267 Raytheby, Thomas, of Hameryngham, husbandman 4
5052986 2372488 2372488 defendant Darman John clerk 610267 610267 Darman, John, of Hameryngham, clerk 0
5101381 2386816 2386816 defendant Maydenwell John husbandman 610267 610267 Maydenwell, John, of Hameryngham, husbandman 2
5194631 2414163 2414163 plaintiff Ratheby Thomas   610267 610267 Ratheby, Thomas, of Hameryngham 0
5254554 2431546 2431546 defendant Kyme John   610267 610267 Kyme, John, of Hameryngham 0
5254555 2431546 2431546 defendant Ingclesse of Ingcleffe Thomas husbandman 610267 610267 Ingclesse of Ingcleffe, Thomas, of Hameryngham, husbandman 1
5254556 2431546 2431546 defendant Dunthorp William husbandman 610267 610267 Dunthorp, William, of Hameryngham, husbandman 2
5635191 2554982 2554982 defendant Elred Nicholas   610267 610267 Elred, Nicholas, of Hameryngham 5
5635218 2554987 2554987 defendant Elred Nicholas   610267 610267 Elred, Nicholas, of Hameryngham 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);