names

348 rows where place_id = 587460

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591475 1864959 1864959 defendant Scalder John grocer 587460 587460 Scalder, John, of Sudbury, Suff, grocer 0
3594097 1865795 1865795 defendant Jacobe William, junior chapman 587460 587460 Jacobe, William, junior, of Sudbury, Suff, chapman 0
3602541 1868456 1868456 defendant Machyn Thomas clothman 587460 587460 Machyn, Thomas, of Sudbury, Suff, clothman 0
3603948 1868904 1868904 plaintiff Folour John mercer 587460 587460 Folour, John, of Sudbury, Suff, mercer 0
3604436 1869055 1869055 defendant Haynes Robert butcher 587460 587460 Haynes, Robert, of Sudbury, Suff, butcher 1
3612836 1871664 1871664 defendant Pykenham Thomas clothier 587460 587460 Pykenham, Thomas, of Sudbury, Suff, clothier 0
3613437 1871850 1871850 defendant Wallon james clothmaker 587460 587460 Wallon, james, of Sudbury, Suff, clothmaker 1
3613845 1871985 1871985 defendant Crochon William chapman 587460 587460 Crochon, William, of Sudbury, Suff, chapman 0
3619954 1873816 1873816 defendant Dasshe John husbandman 587460 587460 Dasshe, John, of Sudbury, Suff, husbandman 0
3624905 1875324 1875324 defendant Berty Michael merchant of Florence 587460 587460 Berty, Michael, of Sudbury, Suff, merchant of Florence 0
3625513 1875519 1875519 defendant Maldon Thomas mercer 587460 587460 Maldon, Thomas, of Sudbury, Suff, mercer 0
3628441 1903763 1903763 defendant Parson John mercer 587460 587460 Parson, John, of Sudbury, Suff, mercer 0
3642136 1907989 1907989 defendant Gybloum or Gybloon William clothmaker 587460 587460 Gybloum or Gybloon, William, of Sudbury, Suff, clothmaker 0
3642473 1908089 1908089 defendant Parson John mercer 587460 587460 Parson, John, of Sudbury, Suff, mercer 0
3642475 1908090 1908090 defendant Roberde John mercer 587460 587460 Roberde, John, of Sudbury, Suff, mercer 0
3642492 1908095 1908095 defendant Parson John mercer 587460 587460 Parson, John, of Sudbury, Suff, mercer 1
3656719 1912355 1912355 defendant Heron William merchant 587460 587460 Heron, William, of Sudbury, Suff, merchant 0
3659044 1913092 1913092 plaintiff Fytches John traveller or ferryman 587460 587460 Fytches, John, of Sudbury, Suff, traveller or ferryman 0
3659140 1913115 1913115 defendant Chepe Henry mercer 587460 587460 Chepe, Henry, of Sudbury, Suff, mercer 4
3682208 1920539 1920539 defendant Froste John smith 587460 587460 Froste, John, of Sudbury, Suff, smith 2
3685353 1921574 1921574 defendant Carvar Thomas chapman 587460 587460 Carvar, Thomas, of Sudbury, Suff, chapman 1
3690878 1923311 1923311 defendant Gybloon William clothmaker 587460 587460 Gybloon, William, of Sudbury, Suff, clothmaker 0
3695309 1924757 1924757 plaintiff Pope William   587460 587460 Pope, William, of Sudbury, Suff 1
3727335 1934824 1934824 plaintiff Waren alias Baker John grocer 587460 587460 Waren alias Baker, John, of Sudbury, Suff, grocer 0
3727353 1934830 1934830 plaintiff Waren John grocer 587460 587460 Waren, John, of Sudbury, Suff, grocer 0
3737382 1937928 1937928 defendant Myst Thomas clothier 587460 587460 Myst, Thomas, of Sudbury, Suff, clothier 0
3744455 1940168 1940168 defendant Strache Edward chapman 587460 587460 Strache, Edward, of Sudbury, Suff, chapman 2
3753930 1943178 1943178 plaintiff Stevenson Thomas   587460 587460 Stevenson, Thomas, of Sudbury, Suff 0
3766277 1947102 1947102 defendant Colman Robert tailor 587460 587460 Colman, Robert, of Sudbury, Suff, tailor 1
3781154 1951842 1951842 defendant Joyse John carpenter 587460 587460 Joyse, John, of Sudbury, Suff, carpenter 2
3793867 1955949 1955949 defendant Bukkell John husbandman 587460 587460 Bukkell, John, of Sudbury, Suff, husbandman 0
3801060 1958247 1958247 plaintiff Mayn John shoemaker 587460 587460 Mayn, John, of Sudbury, Suff, shoemaker 0
3803065 1958861 1958861 defendant Fuller Thomas gent 587460 587460 Fuller, Thomas, of Sudbury, Suff, gent 1
3817463 1963374 1963374 defendant Wolftone Thomas chapman 587460 587460 Wolftone, Thomas, of Sudbury, Suff, chapman 3
3826590 1966165 1966165 defendant Lokke William clothier 587460 587460 (Lokke, William, of Sudbury, Suff, clothier 2
3829419 1967089 1967089 defendant Bur William shoemaker 587460 587460 Bur, William, of Sudbury, Suff, shoemaker 0
3830228 1967346 1967346 defendant Newland John chapman 587460 587460 Newland, John, of Sudbury, Suff, chapman 4
3831843 1967855 1967855 defendant Fullour Thomas yeoman 587460 587460 Fullour, Thomas, of Sudbury, Suff, yeoman 0
3831882 1967864 1967864 defendant Fuller William draper 587460 587460 Fuller, William, of Sudbury, Suff, draper 2
3849214 1973349 1973349 defendant Lock William chapman 587460 587460 Lock, William, of Sudbury, Suff, chapman 1
3854050 1974902 1974902 defendant Loke William clothier 587460 587460 Loke, William, of Sudbury, Suff, clothier 0
3854238 1974962 1974962 defendant Eden Richard clerk 587460 587460 Eden, Richard, of Sudbury, Suff, clerk 1
3854244 1974963 1974963 defendant Eden Richard clerk 587460 587460 Eden, Richard, of Sudbury, Suff, clerk 1
3855548 1975378 1975378 defendant Elys Thomas yeoman 587460 587460 Elys, Thomas, of Sudbury, Suff, yeoman 0
3855727 1975426 1975426 defendant Hunt George chapman 587460 587460 Hunt, George, of Sudbury, Suff, chapman 0
3857950 1976130 1976130 defendant Fuller William draper 587460 587460 Fuller, William, of Sudbury, Suff, draper 0
3858771 1976419 1976419 defendant Lokke William clothier 587460 587460 Lokke, William, of Sudbury, Suff, clothier 0
3869651 1980092 1980092 defendant Elys Thomas yeoman 587460 587460 Elys, Thomas, of Sudbury, Suff, yeoman 0
3869663 1980096 1980096 defendant Elys Thomas yeoman 587460 587460 Elys, Thomas, of Sudbury, Suff, yeoman 0
3871751 1980787 1980787 defendant Strache Edward chapman 587460 587460 Strache, Edward, of Sudbury, Suff, chapman 3
3874936 1981840 1981840 defendant Locke William chapman 587460 587460 Locke, William, of Sudbury, Suff, chapman 4
3882288 1984335 1984335 defendant Merrellys John clothier 587460 587460 Merrellys, John, of Sudbury, Suff, clothier 2
3883345 1984695 1984695 defendant Smyth William chapman 587460 587460 Smyth, William, of Sudbury, Suff, chapman 0
3893047 1987922 1987922 defendant Brett Thomas clothier 587460 587460 Brett, Thomas, of Sudbury, Suff, clothier 0
3893086 1987934 1987934 defendant Pomfrett William yeoman 587460 587460 Pomfrett, William, of Sudbury, Suff, yeoman 0
3894955 1988521 1988521 defendant Tayler Maurice clothier 587460 587460 Tayler, Maurice, of Sudbury, Suff, clothier 0
3899881 1990173 1990173 defendant Vaghan Geoffrey yeoman 587460 587460 Vaghan, Geoffrey, of Sudbury, Suff, yeoman 0
3904451 1991734 1991734 defendant Fuller William draper 587460 587460 Fuller, William, of Sudbury, Suff, draper 0
3905891 1992253 1992253 defendant Rogell William draper 587460 587460 Rogell, William, of Sudbury, Suff, draper 1
3936247 2002450 2002450 defendant Ball James   587460 587460 Ball, James, of Sudbury, Suff, cloth maker 0
3938863 2003339 2003339 defendant Brackett John grocer 587460 587460 Brackett, John, of Sudbury, Suff, grocer 0
3940063 2003693 2003693 defendant Cole William merchant 587460 587460 Cole, William, of Sudbury, Suff, merchant 3
3940820 2003935 2003935 defendant Beest John grocer 587460 587460 Beest, John, of Sudbury, Suff, grocer 2
3941359 2004117 2004117 defendant Best John grocer 587460 587460 Best, John, of Sudbury, Suff, grocer 0
3953220 2008192 2008192 defendant Wyllett Thomas clothier 587460 587460 Wyllett, Thomas, of Sudbury, Suff, clothier 0
3953494 2008294 2008294 defendant Rule John husbandman 587460 587460 Rule, John, of Sudbury, Suff, husbandman 0
3954041 2008484 2008484 defendant Barker Richard butcher 587460 587460 Barker, Richard, of Sudbury, Suff, butcher 0
3960349 2010716 2010716 defendant Cole John gent 587460 587460 Cole, John, of Sudbury, Suff, gent 0
3964566 2012210 2012210 defendant Cole William mercer 587460 587460 Cole, William, of Sudbury, Suff, mercer 0
3969670 2013997 2013997 defendant Holton William clothier 587460 587460 Holton, William, of Sudbury, Suff, clothier 0
3972508 2014962 2014962 plaintiff Gardyner William   587460 587460 Gardyner, William, of Sudbury, Suff, linen draper 0
3978994 2017242 2017242 defendant Alynston George chapman 587460 587460 Alynston, George, of Sudbury, Suff, chapman 0
4005034 2026585 2026585 defendant Harvy Robert chapman or merchant 587460 587460 Harvy, Robert, of Sudbury, Suff, chapman or merchant 0
4015334 2030177 2030177 defendant Goldyng Thomas clothier 587460 587460 Goldyng, Thomas, of Sudbury, Suff, clothier 3
4015436 2030217 2030217 plaintiff Smyth William clothier 587460 587460 Smyth, William, of Sudbury, Suff, clothier 0
4018085 2031186 2031186 defendant Best John chapman 587460 587460 Best, John, of Sudbury, Suff, chapman 1
4029262 2035112 2035112 defendant Willett Thomas yeoman 587460 587460 Willett, Thomas, of Sudbury, Suff, yeoman 0
4030636 2035619 2035619 defendant Whitinge William clothier 587460 587460 Whitinge, William, of Sudbury, Suff, clothier 0
4030639 2035620 2035620 defendant Whytynge William clothier 587460 587460 Whytynge, William, of Sudbury, Suff, clothier 0
4030644 2035622 2035622 defendant Whitinge William clothier 587460 587460 Whitinge, William, of Sudbury, Suff, clothier 0
4030647 2035623 2035623 defendant Whitinge William clothier 587460 587460 Whitinge, William, of Sudbury, Suff, clothier 0
4047869 2041683 2041683 defendant Rusham alias Barbour Thomas yeoman 587460 587460 Rusham alias Barbour, Thomas, of Sudbury, Suff, yeoman 3
4051006 2042801 2042801 defendant Beaste John yeoman 587460 587460 Beaste, John, of Sudbury, Suff, yeoman 3
4051011 2042802 2042802 defendant Beaste John yeoman 587460 587460 Beaste, John, of Sudbury, Suff, yeoman 3
4115965 2065998 2065998 defendant Eliott John shoemaker 587460 587460 Eliott, John, of Sudbury, Suff, shoemaker 1
4127412 2070093 2070093 defendant Godfrey Thomas chapman 587460 587460 Godfrey, Thomas, of Sudbury, Suff, chapman 0
4135227 2072918 2072918 defendant Cole William mercer 587460 587460 Cole, William, of Sudbury, Suff, mercer 0
4174824 2086663 2086663 plaintiff Frende Richard clothier 587460 587460 Frende, Richard, of Sudbury, Suff, clothier 0
4175342 2086844 2086844 defendant Garrard William butcher 587460 587460 Garrard, William, of Sudbury, Suff, butcher 0
4181986 2089181 2089181 defendant Bore Thomas clothier 587460 587460 Bore, Thomas, of Sudbury, Suff, clothier 0
4185024 2090271 2090271 defendant Grene Thomas clothier 587460 587460 Grene, Thomas, of Sudbury, Suff, clothier 1
4187115 2090984 2090984 defendant Willet Thomas clothier 587460 587460 Willet, Thomas, of Sudbury, Suff, clothier 1
4193356 2093244 2093244 defendant Frynd Richard clothier 587460 587460 Frynd, Richard, of Sudbury, Suff, clothier 0
4198584 2095062 2095062 defendant Garrard William butcher 587460 587460 Garrard, William, of Sudbury, Suff, butcher 0
4228429 2105424 2105424 defendant Palmer William chapman 587460 587460 Palmer, William, of Sudbury, Suff, chapman 1
4232425 2106847 2106847 defendant Fulthrop John clerk 587460 587460 Fulthrop, John, of Sudbury, Suff, clerk 2
4245536 2111482 2111482 defendant Palmer William chapman 587460 587460 Palmer, William, of Sudbury, Suff, chapman 1
4254484 2114489 2114489 defendant Godfrey Thomas chapman 587460 587460 Godfrey, Thomas, of Sudbury, Suff, chapman 1
4254487 2114490 2114490 defendant Godfrey Thomas chapman 587460 587460 Godfrey, Thomas, of Sudbury, Suff, chapman 1
4272258 2120292 2120292 defendant Seeley Thomas draper 587460 587460 Seeley, Thomas, of Sudbury, Suff, draper 0

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