names

31 rows where place_id = 677057

✎ 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
3970701 2014341 2014341 defendant Segger William clothier 677057 677057 Segger, William, of Beckles, or of Sudbury, Suff, clothier 3
4025297 2033708 2033708 plaintiff Brig Roger tailor 677057 677057 Brig, Roger, of Beckles, tailor 0
4032364 2036243 2036243 plaintiff Garnett Nicholas tailor 677057 677057 Garnett, Nicholas, of Beckles, tailor 0
4145408 2076551 2076551 defendant Call John grocer 677057 677057 Call, John, of Beckles, grocer 2
4149932 2078107 2078107 defendant Sewell Robert merchant 677057 677057 Sewell, Robert, of Beckles, merchant 0
4149933 2078107 2078107 defendant Gould Henry yeoman 677057 677057 Gould, Henry, of Beckles, yeoman 1
4162171 2082324 2082324 defendant Cale John grocer 677057 677057 Cale, John, of Beckles, grocer 0
4169004 2084652 2084652 defendant Sewell Robert draper 677057 677057 Sewell, Robert, of Beckles, draper 0
4191901 2092728 2092728 defendant Grene Thomas yeoman 677057 677057 Grene, Thomas, of Beckles, yeoman 0
4192553 2092958 2092958 defendant Hersant Michael   677057 677057 Hersant, Michael, of Beckles, yeoman, court holder 0
4198048 2094865 2094865 defendant Canne John yeoman 677057 677057 Canne, John, of Beckles, yeoman 1
4213413 2100209 2100209 defendant Blacklock Randolph yeoman 677057 677057 Blacklock, Randolph, of Beckles, yeoman 0
4279528 2122758 2122758 defendant Browne Edward gent 677057 677057 Browne, Edward, of Beckles, or of Barnards Inn, gent 0
4279529 2122758 2122758 defendant Lyncoln John yeoman 677057 677057 Lyncoln, John, of Beckles, or of Gislam, yeoman 1
4281062 2123274 2123274 defendant Bayspole Hubert singleman 677057 677057 Bayspole, Hubert, of Beckles, gent, or of Aldebie, singleman 3
4281865 2123563 2123563 defendant Thurston Simon singleman 677057 677057 Thurston, Simon, of Beckles, yeoman, singleman 1
4316988 2136055 2136055 defendant Gallarde Miles   677057 677057 Gallarde, Miles, of Beckles yeoman 1
4316989 2136055 2136055 defendant Reade Francis yeoman 677057 677057 Reade, Francis, of Beckles, yeoman 2
4316990 2136055 2136055 defendant Baspoole Hubert yeoman 677057 677057 Baspoole, Hubert, of Beckles, yeoman 3
4327941 2139669 2139669 defendant Murdock Robert chandler 677057 677057 Murdock, Robert, of Beckles, chandler 0
4327944 2139669 2139669 defendant Botteswayne Simon husbandman 677057 677057 Botteswayne, Simon, of Beckles, husbandman 3
4330758 2140588 2140588 defendant Chapman Robert yeoman 677057 677057 Chapman, Robert, of Beckles, yeoman 0
4330759 2140588 2140588 defendant Edward Nicholas yeoman 677057 677057 Edward, Nicholas, of Beckles, yeoman 1
4330760 2140588 2140588 defendant Lea John yeoman 677057 677057 Lea, John, of Beckles, yeoman 2
4343128 2144867 2144867 defendant Crafte Richard miller 677057 677057 Crafte, Richard, of Beckles, miller 2
4393515 2162432 2162432 defendant Calver Robert yeoman 677057 677057 Calver, Robert, of Beckles, yeoman 0
4394472 2162748 2162748 defendant Crane William yeoman 677057 677057 Crane, William, of Beckles, yeoman 0
4396853 2163517 2163517 defendant Lightfoote John blacksmith 677057 677057 Lightfoote, John, of Beckles, blacksmith 0
4400013 2164593 2164593 defendant Sponer Robert husbandman 677057 677057 Sponer, Robert, of Beckles, husbandman 0
4462613 2189001 2189001 defendant atte Rowe Richard   677057 677057 atte Rowe, Richard, of Beckles 0
4611136 2234547 2234547 defendant Rothe John   677057 677057 Rothe, John, of Beckles 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);