names

43 rows where place_id = 588968

✎ 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
3596142 1866421 1866421 defendant Hawken Robert shoemaker 588968 588968 Hawken, Robert, of Blythburgh, shoemaker 1
3645478 1908989 1908989 defendant Colett Thomas mercer 588968 588968 Colett, Thomas, of Blythburgh, mercer 0
3654445 1911651 1911651 defendant Brown Henry butcher 588968 588968 Brown, Henry, of Blythburgh, butcher 1
3667989 1915927 1915927 defendant Swan John painter 588968 588968 Swan, John, of Blythburgh, painter 0
3728165 1935071 1935071 defendant Woodward John glover 588968 588968 Woodward, John, of Blythburgh, glover 0
3752617 1942749 1942749 defendant Bekett William yeoman 588968 588968 Bekett, William, of Blythburgh, yeoman 0
3787285 1953816 1953816 plaintiff Swanne John   588968 588968 Swanne, John, of Blythburgh 1
3802537 1958691 1958691 defendant Hapton John painter 588968 588968 Hapton, John, of Blythburgh, painter 0
3816862 1963179 1963179 defendant Base Valentine baker 588968 588968 Base, Valentine, of Blythburgh, baker 0
3826562 1966154 1966154 defendant Barker Peter shoemaker 588968 588968 Barker, Peter, of Blythburgh, shoemaker 0
3826563 1966154 1966154 defendant Barker Robert shoemaker 588968 588968 Barker, Robert, of Blythburgh, shoemaker 1
3832767 1968175 1968175 defendant Martyn Thomas butcher 588968 588968 Martyn, Thomas, of Blythburgh, butcher 0
3836322 1969268 1969268 defendant Fyske William mercer 588968 588968 Fyske, William, of Blythburgh, mercer 0
3837338 1969588 1969588 defendant Fox William painter 588968 588968 Fox, William, of Blythburgh, painter 0
3839365 1970234 1970234 defendant Hopton John painter 588968 588968 Hopton, John, of Blythburgh, painter 0
3848381 1973071 1973071 defendant Hubbard John butcher 588968 588968 Hubbard, John, of Blythburgh, butcher 1
3853524 1974727 1974727 defendant Fox William painter 588968 588968 Fox, William, of Blythburgh, painter 0
3853616 1974759 1974759 defendant Baker alias Barker Peter shoemaker 588968 588968 Baker alias Barker, Peter, of Blythburgh, shoemaker 1
3854843 1975160 1975160 defendant Barker Peter cordwainer 588968 588968 Barker, Peter, of Blythburgh, cordwainer 1
3875992 1982222 1982222 defendant Hobard William painter 588968 588968 Hobard, William, of Blythburgh, painter 0
3882247 1984320 1984320 defendant Collett Thomas yeoman 588968 588968 Collett, Thomas, of Blythburgh, yeoman 2
3913707 1994925 1994925 defendant Broun Robert husbandman 588968 588968 Broun, Robert, of Blythburgh, husbandman 0
3960462 2010758 2010758 defendant Goodwyn Thomas innholder 588968 588968 Goodwyn, Thomas, of Blythburgh, innholder 0
3960464 2010759 2010759 defendant Woodward Peter mercer 588968 588968 Woodward, Peter, of Blythburgh, mercer 0
3971455 2014575 2014575 defendant Glensford Robert tailor 588968 588968 Glensford, Robert, of Blythburgh, tailor 0
3985421 2019545 2019545 defendant Johnson Thomas husbandman 588968 588968 Johnson, Thomas, of Blythburgh, husbandman 1
4001625 2025361 2025361 defendant Canon alias Irysshe Richard yeoman 588968 588968 Canon alias Irysshe, Richard, of Blythburgh, yeoman 0
4032822 2036393 2036393 defendant Lyngwood Anthony yeoman 588968 588968 Lyngwood, Anthony, of Blythburgh, yeoman 0
4039281 2038678 2038678 defendant Pyknett Robert innholder 588968 588968 Pyknett, Robert, of Blythburgh, innholder 1
4039285 2038679 2038679 defendant Pyknett Robert innholder 588968 588968 Pyknett, Robert, of Blythburgh, innholder 1
4049683 2042324 2042324 defendant Bissett Thomas yeoman 588968 588968 Bissett, Thomas, of Blythburgh, yeoman 1
4763840 2284684 2284684 plaintiff Haldeye Thomas   588968 588968 Haldeye, Thomas, of Blythburgh, prior 0
4833789 2306576 2306576 plaintiff Cokk John   588968 588968 Cokk, John, of Blythburgh 0
4833791 2306577 2306577 plaintiff Cokk John   588968 588968 Cokk, John, of Blythburgh 0
4838363 2307913 2307913 plaintiff Glover John   588968 588968 Glover, John, of Blythburgh 0
4860792 2314736 2314736 plaintiff Cokk John   588968 588968 Cokk, John, of Blythburgh, 0
4907602 2328942 2328942 defendant (illegible) Robert dyer 588968 588968 ----, Robert, of Blythburgh, dyer 2
4945514 2340576 2340576 defendant Maydon Roger yeoman 588968 588968 Maydon, Roger, of Blythburgh, yeoman 0
5019557 2362607 2362607 defendant Wulcy John yeoman 588968 588968 Wulcy, John, of Blythburgh, yeoman 0
5026811 2364714 2364714 defendant Neweman William glover 588968 588968 Neweman, William, of Blythburgh, glover 1
5264633 2434693 2434693 plaintiff Skuttyng William   588968 588968 Skuttyng, William, of Blythburgh 0
5376955 2468388 2468388 plaintiff Sompton or Newton John   588968 588968 Sompton or Newton, John, of Blythburgh, prior 0
5594180 2533157 2533157 plaintiff Barett John   588968 588968 Barett, John, of Blythburgh 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);