names

26 rows where place_id = 665142

✎ 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
3832771 1968177 1968177 defendant (not given) Robert rector of Jones 665142 665142 Jones, Robert, of rector of Eton, Herefs 0
3975686 2016055 2016055 defendant Welshe Edward gent or mercer 665142 665142 Welshe, Edward, of Herefs, gent or mercer 0
3976467 2016344 2016344 defendant Apowell William clothier 665142 665142 Apowell, William, of Herefs, clothier 0
3985200 2019463 2019463 defendant Holt Thomas   665142 665142 Holt, Thomas, of Herefs, yeoman, administrators of 2
4023227 2033017 2033017 plaintiff Barkeley John gent 665142 665142 Barkeley, John, of Herefs, gent 0
4037039 2037912 2037912 defendant Flecher William bowyer 665142 665142 Flecher, William, of Herefs, bowyer 1
4173885 2086322 2086322 defendant Pytcher John gent 665142 665142 Pytcher, John, of Herefs, gent 3
4174660 2086606 2086606 defendant Stubbes Robert gent 665142 665142 Stubbes, Robert, of Herefs, gent 1
4184138 2089949 2089949 defendant Howells Fulk yeoman 665142 665142 Howells, Fulk, of Herefs, yeoman 0
4184142 2089950 2089950 defendant Howells Fulk yeoman 665142 665142 Howells, Fulk, of Herefs, yeoman 0
4188692 2091524 2091524 defendant Mason William clerk 665142 665142 Mason, William, of Herefs, clerk 1
4287432 2125557 2125557 defendant Boothe John gent 665142 665142 Boothe, John, of Herefs, or of Lyons Inn, Middx, gent 0
4381201 2158389 2158389 defendant (not given) Thomas vicar of Hullyn 665142 665142 Hullyn, Thomas, of vicar of Upton Bishop, Herefs, clerk 0
4548665 2215526 2215526 defendant Bernard Thomas   665142 665142 Bernard, Thomas, of Herefs 1
4680815 2259621 2259621 defendant Whyte William   665142 665142 Whyte, William, of Durham, Herefs, parson 0
4785516 2291491 2291491 defendant Baskervyle John   665142 665142 Baskervyle, John, of Herefs, knight, administrators of 3
4864234 2315790 2315790 defendant Elys Thomas gent 665142 665142 Elys, Thomas, of Herefs, gent 2
4864239 2315791 2315791 defendant Elys Thomas gent 665142 665142 Elys, Thomas, of Herefs, gent 2
4959015 2344663 2344663 defendant Skydmore James (legal representative) 665142 665142 Skydmore, James, of Herefs, esq, administrator of 0
5011625 2360256 2360256 defendant Godechyld Thomas chapman 665142 665142 Godechyld, Thomas, of Monmouth, Herefs, chapman 2
5011632 2360257 2360257 defendant Godechyld Thomas chapman 665142 665142 Godechyld, Thomas, of Monmouth, Herefs, chapman 2
5103133 2387340 2387340 plaintiff Bowyer Richard chaplain 665142 665142 Bowyer, Richard, of Herefs, chaplain 0
5296426 2443945 2443945 defendant Mordyford Richard husbandman 665142 665142 Mordyford, Richard, of Herefs, husbandman 1
5311848 2448570 2448570 plaintiff Affylon John yeoman 665142 665142 Affylon, John, of Herefs, yeoman 0
5315437 2449679 2449679 plaintiff Colyns John gent 665142 665142 Colyns, John, of Herefs, gent 0
5533744 2515103 2515103 defendant Whitney James esq 665142 665142 Whitney, James, of March of Wales, Herefs, esq 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);