names

125 rows where place_id = 589247

✎ 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
3597004 1866689 1866689 defendant Abery John mercer 589247 589247 Abery, John, of Eye, Suff, mercer 3
3605138 1869271 1869271 defendant Cullyng Richard carpenter 589247 589247 Cullyng, Richard, of Eye, Suff, carpenter 0
3618672 1873467 1873467 defendant Frende John   589247 589247 Frende, John, of Eye, Suff, point maker 0
3627612 1903497 1903497 defendant Newton William yeoman 589247 589247 Newton, William, of Eye, Suff, yeoman 0
3651504 1910831 1910831 defendant Goldyng Edward yeoman 589247 589247 Goldyng, Edward, of Eye, Suff, yeoman 0
3661101 1913747 1913747 defendant Whytyngham Robert yeoman 589247 589247 (Whytyngham, Robert, of Eye, Suff, yeoman 1
3661114 1913751 1913751 defendant Whytyngham Robert yeoman 589247 589247 (Whytyngham, Robert, of Eye, Suff, yeoman 1
3687238 1922187 1922187 defendant Everyngton Humphrey gent 589247 589247 Everyngton, Humphrey, of Eye, Suff, gent 2
3687243 1922188 1922188 defendant Everyngton Humphrey gent 589247 589247 Everyngton, Humphrey, of Eye, Suff, gent 2
3790832 1954960 1954960 defendant Same Edward husbandman 589247 589247 Same, Edward, of Eye, Suff, husbandman 0
3806619 1959970 1959970 defendant Seham Edward tailor 589247 589247 Seham, Edward, of Eye, Suff, tailor 2
3809448 1960838 1960838 defendant Fermer Thomas yeoman 589247 589247 Fermer, Thomas, of Eye, Suff, yeoman 0
3824257 1965461 1965461 defendant Saham Edward tailor 589247 589247 Saham, Edward, of Eye, Suff, tailor 2
3824262 1965462 1965462 defendant Saham Edward tailor 589247 589247 Saham, Edward, of Eye, Suff, tailor 2
3856237 1975572 1975572 plaintiff Wodward John (legal representative) 589247 589247 Wodward, John, of Eye, Suff, mercer, executrix of 0
3857591 1976007 1976007 defendant Harlyng Robert grocer 589247 589247 Harlyng, Robert, of Eye, Suff, grocer 1
3871310 1980655 1980655 defendant Harlyng Robert grocer 589247 589247 Harlyng, Robert, of Eye, Suff, grocer 0
3874094 1981557 1981557 defendant Wodward Agnes widow 589247 589247 Wodward, Agnes, of Eye, Suff, widow 0
3875245 1981961 1981961 defendant Wylkynson Christopher yeoman 589247 589247 Wylkynson, Christopher, of Eye, Suff, yeoman 0
3876052 1982243 1982243 defendant Semon Augustine yeoman 589247 589247 Semon, Augustine, of Eye, Suff, yeoman 2
3876141 1982268 1982268 defendant Goldyng Edward yeoman 589247 589247 Goldyng, Edward, of Eye, Suff, yeoman 1
3884045 1984934 1984934 plaintiff Woodward John (legal representative) 589247 589247 Woodward, John, of Eye, Suff, mercer, executrix of 0
3885047 1985260 1985260 defendant Harlyng Robert husbandman 589247 589247 Harlyng, Robert, of Eye, Suff, husbandman 0
3885049 1985261 1985261 defendant Busbye John chapman 589247 589247 Busbye, John, of Eye, Suff, chapman 0
3885058 1985264 1985264 defendant Busby John chapman 589247 589247 Busby, John, of Eye, Suff, chapman 2
3890239 1986980 1986980 plaintiff Herryng William yeoman 589247 589247 Herryng, William, of Eye, Suff, yeoman 0
3928002 1999703 1999703 defendant Cossey Robert husbandman 589247 589247 Cossey, Robert, of Eye, Suff, husbandman 0
3932647 2001214 2001214 defendant Dyxe John husbandman 589247 589247 Dyxe, John, of Eye, Suff, husbandman 0
3937911 2003011 2003011 defendant Cutler Nicholas esq 589247 589247 Cutler, Nicholas, of Eye, Suff, esq 0
3947871 2006319 2006319 defendant Bate John gent 589247 589247 Bate, John, of Eye, Suff, gent 1
3954088 2008503 2008503 plaintiff Knevett Nicholas   589247 589247 Knevett, Nicholas, of Eye, Suff 0
3962016 2011298 2011298 defendant Gyslyngham John yeoman 589247 589247 Gyslyngham, John, of Eye, Suff, yeoman 0
3965457 2012533 2012533 plaintiff Bawdwall Simon   589247 589247 Bawdwall, Simon, of Eye, Suff 0
3971952 2014748 2014748 plaintiff Folkerd William (legal representative) 589247 589247 Folkerd, William, of Eye, Suff, executrix of 0
3985784 2019678 2019678 defendant Gyslyngham John yeoman 589247 589247 Gyslyngham, John, of Eye, Suff, yeoman 1
3992020 2021912 2021912 defendant Gyssyng Nicholas butcher 589247 589247 Gyssyng, Nicholas, of Eye, Suff, butcher 0
3993038 2022259 2022259 defendant Mallowes John glover 589247 589247 Mallowes, John, of Eye, Suff, glover 0
4014289 2029840 2029840 defendant Turrold William gent 589247 589247 Turrold, William, of Eye, Suff, gent 1
4016941 2030760 2030760 defendant Self Anthony yeoman 589247 589247 Self, Anthony, of Eye, Suff, yeoman 0
4016943 2030761 2030761 defendant Thrower John yeoman 589247 589247 Thrower, John, of Eye, Suff, yeoman 0
4019649 2031754 2031754 defendant Knappe Thomas butcher 589247 589247 Knappe, Thomas, of Eye, Suff, butcher 2
4024821 2033558 2033558 defendant Fen John clothier 589247 589247 Fen, John, of Eye, Suff, clothier 2
4024825 2033559 2033559 defendant Fane John clothier 589247 589247 Fane, John, of Eye, Suff, clothier 2
4026094 2033980 2033980 defendant Ludman William gent 589247 589247 Ludman, William, of Eye, Suff, gent 1
4026099 2033981 2033981 defendant Ludman William gent 589247 589247 Ludman, William, of Eye, Suff, gent 1
4033761 2036726 2036726 defendant Brounyng Robert yeoman 589247 589247 Brounyng, Robert, of Eye, Suff, yeoman 1
4033767 2036727 2036727 defendant Brounyng Robert yeoman 589247 589247 Brounyng, Robert, of Eye, Suff, yeoman 1
4044871 2040617 2040617 defendant Gissinge Nicholas butcher 589247 589247 Gissinge, Nicholas, of Eye, Suff, butcher 0
4044873 2040618 2040618 defendant Gyssinge Nicholas butcher 589247 589247 Gyssinge, Nicholas, of Eye, Suff, butcher 0
4067091 2048529 2048529 defendant Heyton William saddler 589247 589247 Heyton, William, of Eye, Suff, saddler 0
4070529 2049753 2049753 defendant Fuller Robert tailor 589247 589247 Fuller, Robert, of Eye, Suff, tailor 0
4074638 2051232 2051232 defendant Love Nicholas thatcher 589247 589247 Love, Nicholas, of Eye, Suff, thatcher 0
4088090 2056038 2056038 defendant Cutler Charles esq 589247 589247 Cutler, Charles, of Eye, Suff, esq 0
4092427 2057594 2057594 defendant Knyvett Humphrey yeoman 589247 589247 Knyvett, Humphrey, of Eye, Suff, yeoman 0
4093488 2057986 2057986 defendant Cutler Charles esq 589247 589247 Cutler, Charles, of Eye, Suff, esq 0
4131049 2071421 2071421 defendant Westmell William yeoman 589247 589247 Westmell, William, of Eye, Suff, yeoman 0
4149954 2078115 2078115 defendant Knevet Humphrey   589247 589247 Knevet, Humphrey, of Eye, Suff, woollen draper 0
4161694 2082156 2082156 defendant Evered Nicholas, senior gent 589247 589247 Evered, Nicholas, senior, of Eye, Suff, gent 0
4198779 2095134 2095134 defendant Gyrlingham John yeoman 589247 589247 Gyrlingham, John, of Eye, Suff, yeoman 0
4222706 2103433 2103433 defendant Cutler Nicholas gent 589247 589247 Cutler, Nicholas, of Eye, Suff, gent 0
4222708 2103434 2103434 defendant Cutler Nicholas gent 589247 589247 Cutler, Nicholas, of Eye, Suff, gent 0
4248096 2112349 2112349 defendant Cutler Nicholas gent 589247 589247 Cutler, Nicholas, of Eye, Suff, gent 0
4248098 2112350 2112350 defendant Cutler Nicholas gent 589247 589247 Cutler, Nicholas, of Eye, Suff, gent 0
4281932 2123582 2123582 defendant Cutler Nicholas gent 589247 589247 Cutler, Nicholas, of Eye, Suff, gent 0
4291480 2127026 2127026 defendant Cutler Nicholas gent 589247 589247 Cutler, Nicholas, of Eye, Suff, gent 0
4291483 2127027 2127027 defendant Cutler Nicholas gent 589247 589247 Cutler, Nicholas, of Eye, Suff, gent 0
4291493 2127031 2127031 defendant Throwar John yeoman 589247 589247 Throwar, John, of Eye, Suff, yeoman 0
4304008 2131532 2131532 defendant Palmer James yeoman 589247 589247 Palmer, James, of Eye, Suff, yeoman 0
4307639 2132810 2132810 defendant Knevett Humphrey   589247 589247 Knevett, Humphrey, of Eye, Suff, woollen draper 2
4307848 2132886 2132886 defendant Clarke Henry chapman 589247 589247 Clarke, Henry, of Eye, Suff, chapman 1
4329240 2140092 2140092 defendant Cutler Nicholas gent 589247 589247 Cutler, Nicholas, of Eye, Suff, gent 1
4340859 2144075 2144075 defendant Spinke John yeoman 589247 589247 Spinke, John, of Eye, Suff, yeoman 3
4347777 2146470 2146470 defendant Rushe Thomas yeoman 589247 589247 Rushe, Thomas, of Eye, Suff, yeoman 0
4356909 2149648 2149648 defendant Bitteringe William gent 589247 589247 Bitteringe, William, of Eye, Suff, gent 0
4356911 2149649 2149649 defendant Bitteringe John gent 589247 589247 Bitteringe, John, of Eye, Suff, gent 0
4386082 2160028 2160028 defendant Carter Thomas yeoman 589247 589247 Carter, Thomas, of Eye, Suff, yeoman 1
4387257 2160386 2160386 defendant Smythe Simon shoemaker 589247 589247 Smythe, Simon, of Eye, Suff, shoemaker 0
4388600 2160826 2160826 defendant Reynolds Thomas   589247 589247 Reynolds, Thomas, of Eye, Suff, felt maker 3
4391248 2161691 2161691 defendant Honing Henry gent 589247 589247 Honing, Henry, of Eye, Suff, gent 0
4398491 2164074 2164074 defendant Bittryng John gent 589247 589247 Bittryng, John, of Eye, Suff, gent 3
4404298 2166008 2166008 defendant Pechell George clerk 589247 589247 (Pechell, George, of Eye, Suff, clerk 3
4492246 2198256 2198256 defendant Drewery Edmund   589247 589247 Drewery, Edmund, of Eye, Suff, vicar 0
4492264 2198260 2198260 defendant Drewery Edmund   589247 589247 Drewery, Edmund, of Eye, Suff, vicar 0
4653612 2247058 2247058 defendant Spycer Thomas yeoman 589247 589247 Spycer, Thomas, of Eye, Suff, yeoman 4
4683705 2260504 2260504 defendant Seford Adam   589247 589247 Seford, Adam, of Eye, Suff, shee drover 1
4793448 2294059 2294059 defendant Cook Robert yeoman 589247 589247 Cook, Robert, of Eye, Suff, yeoman 0
4922177 2333349 2333349 defendant Ball John husbandman 589247 589247 Ball, John, of Eye, Suff, husbandman 2
4958263 2344440 2344440 defendant Plumstede Robert smith 589247 589247 Plumstede, Robert, of Eye, Suff, smith 1
5025639 2364408 2364408 defendant Deve John spicer 589247 589247 Deve, John, of Eye, Suff, spicer 0
5090437 2383581 2383581 defendant Herbert Robert yeoman 589247 589247 Herbert, Robert, of Eye, Suff, yeoman 1
5118849 2391946 2391946 defendant Grey Agnes widow 589247 589247 Grey, Agnes, of Eye, Suff, widow 2
5118861 2391948 2391948 defendant Grey Agnes widow 589247 589247 Grey, Agnes, of Eye, Suff, widow 3
5240885 2427538 2427538 defendant Debenham John hosier 589247 589247 Debenham, John, of Eye, Suff, hosier 3
5290593 2442251 2442251 defendant Herberd Robert dyer 589247 589247 Herberd, Robert, of Eye, Suff, dyer 1
5293306 2443024 2443024 defendant Hamond John husbandman 589247 589247 Hamond, John, of Eye, Suff, husbandman 2
5293312 2443025 2443025 defendant Hamond John husbandman 589247 589247 Hamond, John, of Eye, Suff, husbandman 2
5347411 2459354 2459354 defendant Bondes Thomas chapman 589247 589247 Bondes, Thomas, of Eye, Suff, chapman 2
5381870 2469870 2469870 defendant Raweton Richard yeoman 589247 589247 Raweton, Richard, of Eye, Suff, yeoman 1
5384360 2470614 2470614 defendant Bondys Thomas   589247 589247 Bondys, Thomas, of Eye, Suff, tallow chandler 1
5390002 2472201 2472201 defendant Raweton Richard yeoman 589247 589247 Raweton, Richard, of Eye, Suff, yeoman 1

Next page

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);