names

71 rows where place_id = 586956

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590080 1864538 1864538 defendant Sparowe John husbandman 586956 586956 Sparowe, John, of Semer, husbandman 3
3602849 1868561 1868561 defendant Sparowe John husbandman 586956 586956 Sparowe, John, of Semer, husbandman 2
3710050 1929453 1929453 defendant Clovyer John   586956 586956 Clovyer, John, of Semer, lime burner 0
3710052 1929454 1929454 defendant Clovyer John   586956 586956 Clovyer, John, of Semer, lime burner 0
3710057 1929455 1929455 defendant Parker Henry husbandman 586956 586956 Parker, Henry, of Semer, husbandman 0
3710059 1929456 1929456 defendant Parker Henry husbandman 586956 586956 Parker, Henry, of Semer, husbandman 0
3723934 1933765 1933765 defendant Parker Henry yeoman 586956 586956 Parker, Henry, of Semer, yeoman 0
3724621 1933983 1933983 defendant Parker Henry husbandman 586956 586956 Parker, Henry, of Semer, husbandman 0
3732272 1936334 1936334 defendant Parker Henry husbandman 586956 586956 Parker, Henry, of Semer, husbandman 1
3732727 1936467 1936467 defendant Parker Henry husbandman 586956 586956 Parker, Henry, of Semer, husbandman 0
3755451 1943658 1943658 defendant Laysy John   586956 586956 Laysy, John, of Semer, lime burner 2
3759479 1944958 1944958 defendant Somander William chaplain 586956 586956 Somander, William, of Semer, chaplain 0
3766344 1947128 1947128 defendant Parker Henry yeoman 586956 586956 Parker, Henry, of Semer, yeoman 0
3768139 1947672 1947672 defendant Clovyar John   586956 586956 Clovyar, John, of Semer, lime burner 0
3777632 1950754 1950754 defendant Semonder William clerk 586956 586956 Semonder, William, of Semer, clerk 0
3777633 1950754 1950754 defendant Gyfford Henry laborer 586956 586956 Gyfford, Henry, of Semer, laborer 1
3777634 1950754 1950754 defendant Gyfford Martin laborer 586956 586956 Gyfford, Martin, of Semer, laborer 2
3788264 1954126 1954126 defendant Sompner William chaplain 586956 586956 Sompner, William, of Semer, chaplain 0
3803967 1959157 1959157 defendant Clovyer John   586956 586956 Clovyer, John, of Semer, lime burner 0
3806919 1960073 1960073 defendant Northorpe William gent 586956 586956 Northorpe, William, of Semer, gent 0
3808098 1960424 1960424 defendant Parker Henry husbandman 586956 586956 Parker, Henry, of Semer, husbandman 1
3873480 1981347 1981347 defendant Parker Henry husbandman 586956 586956 Parker, Henry, of Semer, husbandman 1
3897480 1989370 1989370 defendant Clarke John husbandman 586956 586956 Clarke, John, of Semer, husbandman 3
3899036 1989883 1989883 defendant Parker Henry husbandman 586956 586956 Parker, Henry, of Semer, husbandman 0
3903120 1991271 1991271 defendant Smyth Robert husbandman 586956 586956 Smyth, Robert, of Semer, husbandman 1
3917922 1996357 1996357 defendant Dyke Roger husbandman 586956 586956 Dyke, Roger, of Semer, husbandman 1
3976864 2016479 2016479 defendant Buckton William gent 586956 586956 Buckton, William, of Semer, gent 0
4332219 2141070 2141070 defendant Lylley Humphrey husbandman 586956 586956 Lylley, Humphrey, of Semer, husbandman 3
4340586 2143976 2143976 defendant Chaplyn William yeoman 586956 586956 Chaplyn, William, of Semer, yeoman 0
4404097 2165940 2165940 defendant Gaytes Edward esq 586956 586956 Gaytes, Edward, of Semer, esq 1
4483452 2195514 2195514 defendant Foweler Richard   586956 586956 Foweler, Richard, of Semer 0
4520812 2206851 2206851 plaintiff Foweler Richard   586956 586956 Foweler, Richard, of Semer 0
4544153 2214085 2214085 defendant Couper John   586956 586956 Couper, John, of Semer 0
4580346 2225333 2225333 defendant Darcy Thomas   586956 586956 Darcy, Thomas, of Semer 0
4624687 2238704 2238704 defendant Dunkan John   586956 586956 Dunkan, John, of Semer 1
4731270 2274980 2274980 defendant Howe Robert carter 586956 586956 Howe, Robert, of Semer, carter 0
5004437 2358193 2358193 defendant Halle John husbandman 586956 586956 Halle, John, of Semer, husbandman 2
5025064 2364229 2364229 defendant Halle John husbandman 586956 586956 Halle, John, of Semer, husbandman 3
5071749 2378042 2378042 defendant Wade Thomas butcher 586956 586956 Wade, Thomas, of Semer, butcher 0
5140322 2398276 2398276 defendant Chaundeler Simon husbandman 586956 586956 Chaundeler, Simon, of Semer, husbandman 0
5142219 2398846 2398846 defendant Gunne William laborer 586956 586956 Gunne, William, of Semer, laborer 1
5199866 2415712 2415712 defendant Gunne William laborer 586956 586956 Gunne, William, of Semer, laborer 1
5220155 2421602 2421602 defendant Cant Thomas husbandman 586956 586956 Cant, Thomas, of Semer, husbandman 0
5220156 2421602 2421602 defendant Westhous John husbandman 586956 586956 Westhous, John, of Semer, husbandman 1
5220157 2421602 2421602 defendant Westhous William husbandman 586956 586956 Westhous, William, of Semer, husbandman 2
5220158 2421602 2421602 defendant Mason Thomas husbandman 586956 586956 Mason, Thomas, of Semer, husbandman 3
5220159 2421602 2421602 defendant Hunter John husbandman 586956 586956 Hunter, John, of Semer, husbandman 4
5220160 2421602 2421602 defendant Arnald John husbandman 586956 586956 Arnald, John, of Semer, husbandman 5
5220163 2421602 2421602 defendant Yonge William panier man 586956 586956 Yonge, William, of Semer, panier man 8
5220164 2421602 2421602 defendant Oort Robert husbandman 586956 586956 Oort, Robert, of Semer, husbandman 9
5220165 2421602 2421602 defendant Kidde James tailor 586956 586956 Kidde, James, of Semer, tailor 10
5220182 2421604 2421604 defendant Warke John chaplain 586956 586956 Warke, John, of Semer, chaplain 0
5220188 2421604 2421604 defendant Butler John panier man 586956 586956 Butler, John, of Semer, panier man 6
5220189 2421604 2421604 defendant Kidde James tailor 586956 586956 Kidde, James, of Semer, tailor 7
5220195 2421605 2421605 defendant Rande Ralph butcher 586956 586956 Rande, Ralph, of Semer, butcher 3
5235979 2426106 2426106 defendant Bradehede John husbandman 586956 586956 Bradehede, John, of Semer, husbandman 0
5235980 2426106 2426106 defendant Squyer Robert husbandman 586956 586956 Squyer, Robert, of Semer, husbandman 1
5239878 2427240 2427240 defendant Warke John chaplain 586956 586956 Warke, John, of Semer, chaplain 0
5292487 2442800 2442800 defendant Dowe Robert husbandman 586956 586956 Dowe, Robert, of Semer, husbandman 0
5330804 2454284 2454284 defendant Halle John (legal representative) 586956 586956 Halle, John, of Semer, husbandman, executors of 5
5330805 2454284 2454284 defendant Dagler Nicholas husbandman 586956 586956 (Dagler, Nicholas, of Semer, husbandman 6
5408356 2477471 2477471 defendant Freman William laborer 586956 586956 Freman, William, of Semer, laborer 4
5436353 2485808 2485808 defendant Jenkynson Henry yeoman 586956 586956 Jenkynson, Henry, of Semer, yeoman 0
5451065 2490210 2490210 defendant Jenkynson Henry yeoman 586956 586956 Jenkynson, Henry, of Semer, yeoman 0
5451067 2490211 2490211 defendant Jenkynson Henry yeoman 586956 586956 Jenkynson, Henry, of Semer, yeoman 0
5489886 2501860 2501860 defendant Munnyng John yeoman 586956 586956 Munnyng, John, of Semer, yeoman 0
5530381 2514014 2514014 defendant Broke Robert laborer 586956 586956 Broke, Robert, of Semer, laborer 0
5560667 2523087 2523087 defendant Berryer William husbandman 586956 586956 Berryer, William, of Semer, husbandman 0
5560668 2523087 2523087 defendant Wakesfeld Richard husbandman 586956 586956 Wakesfeld, Richard, of Semer, husbandman 1
5560669 2523087 2523087 defendant Thomson Robert husbandman 586956 586956 Thomson, Robert, of Semer, husbandman 2
5560670 2523087 2523087 defendant Boys Robert yeoman 586956 586956 Boys, Robert, of Semer, yeoman 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);