names

288 rows where place_id = 587550

✎ 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
3591716 1865028 1865028 defendant Cullyng Richard carpenter 587550 587550 Cullyng, Richard, of Eye, carpenter 0
3592585 1865298 1865298 defendant Sulyard John, junior (legal representative) 587550 587550 Sulyard, John, junior, of Eye, knight, executrix of 0
3592589 1865299 1865299 defendant Wythe John yeoman 587550 587550 Wythe, John, of Eye, yeoman 0
3592592 1865300 1865300 defendant Sulyard John, junior (legal representative) 587550 587550 Sulyard, John, junior, of Eye, knight, executrix of 0
3592596 1865301 1865301 defendant Wythe John yeoman 587550 587550 Wythe, John, of Eye, yeoman 0
3597005 1866689 1866689 defendant Wace Peter mercer 587550 587550 Wace, Peter, of Eye, mercer 4
3597039 1866698 1866698 defendant Grey Richard yeoman 587550 587550 Grey, Richard, of Eye, yeoman 0
3600767 1867900 1867900 defendant Grey Richard yeoman 587550 587550 Grey, Richard, of Eye, yeoman 0
3600768 1867900 1867900 defendant Grey Thomas yeoman 587550 587550 Grey, Thomas, of Eye, yeoman 1
3603262 1868692 1868692 defendant Lee John husbandman 587550 587550 Lee, John, of Eye, husbandman 2
3603383 1868730 1868730 defendant Lauerans William husbandman 587550 587550 Lauerans, William, of Eye, husbandman 1
3604516 1869076 1869076 defendant More George tailor 587550 587550 More, George, of Eye, tailor 0
3604518 1869077 1869077 defendant More George tailor 587550 587550 More, George, of Eye, tailor 0
3606108 1869578 1869578 defendant Dunston Geoffrey yeoman 587550 587550 Dunston, Geoffrey, of Eye, yeoman 3
3606113 1869579 1869579 defendant Dunston Geoffrey yeoman 587550 587550 Dunston, Geoffrey, of Eye, yeoman 3
3610431 1870923 1870923 defendant Cultyrman Adrian smith 587550 587550 Cultyrman, Adrian, of Eye, smith 0
3610432 1870923 1870923 defendant Clame William smith 587550 587550 Clame, William, of Eye, smith 1
3610433 1870923 1870923 defendant Fox Robert smith 587550 587550 Fox, Robert, of Eye, smith 2
3610435 1870924 1870924 defendant Cultyrman Adrian smith 587550 587550 Cultyrman, Adrian, of Eye, smith 0
3610436 1870924 1870924 defendant Clane or Clave William smith 587550 587550 Clane or Clave, William, of Eye, smith 1
3610437 1870924 1870924 defendant Fox Robert smith 587550 587550 Fox, Robert, of Eye, smith 2
3610439 1870925 1870925 defendant Cultyrman Adrian smith 587550 587550 Cultyrman, Adrian, of Eye, smith 0
3610440 1870925 1870925 defendant Clane William smith 587550 587550 Clane, William, of Eye, smith 1
3610441 1870925 1870925 defendant Fox Robert smith 587550 587550 Fox, Robert, of Eye, smith 2
3610634 1870994 1870994 defendant Eyer Thomas gent 587550 587550 Eyer, Thomas, of Eye, gent 0
3610937 1871094 1871094 defendant Praty William laborer 587550 587550 Praty, William, of Eye, laborer 0
3610938 1871094 1871094 defendant More George tailor 587550 587550 More, George, of Eye, tailor 1
3610939 1871094 1871094 defendant Whitfeld Anthony barber 587550 587550 Whitfeld, Anthony, of Eye, barber 2
3610940 1871094 1871094 defendant Dobbys Robert shoemaker 587550 587550 Dobbys, Robert, of Eye, shoemaker 3
3610942 1871094 1871094 defendant Eyer Thomas gent 587550 587550 Eyer, Thomas, of Eye, gent 5
3611972 1871405 1871405 defendant Eyre Thomes gent 587550 587550 Eyre, Thomes, of Eye, gent 0
3618671 1873467 1873467 plaintiff Hawekyn Thomas   587550 587550 Hawekyn, Thomas, of Eye 0
3618673 1873467 1873467 defendant Polyte Thomas husbandman 587550 587550 Polyte, Thomas, of Eye, husbandman 1
3618674 1873467 1873467 defendant Peper Thomas husbandman 587550 587550 Peper, Thomas, of Eye, husbandman 2
3625738 1875588 1875588 defendant Lee John yeoman 587550 587550 Lee, John, of Eye, yeoman 1
3626151 1903042 1903042 plaintiff Annyell Margaret (legal representative) 587550 587550 Annyell, Margaret, of Eye, widow, executor of 0
3626401 1903115 1903115 plaintiff Aunyell Margaret (legal representative) 587550 587550 Aunyell, Margaret, of Eye, widow, executor of 0
3636053 1906069 1906069 plaintiff Praty John (legal representative) 587550 587550 Praty, John, of Eye, smith, executors of 0
3636056 1906070 1906070 plaintiff Praty John (legal representative) 587550 587550 Praty, John, of Eye, smith, executors of 0
3658463 1912899 1912899 plaintiff Eyer Thomas (legal representative) 587550 587550 Eyer, Thomas, of Eye, gent, executrix of 0
3659380 1913194 1913194 plaintiff Goldyng Edward   587550 587550 Goldyng, Edward, of Eye 0
3661102 1913747 1913747 defendant Mason Thomas husbandman 587550 587550 Mason, Thomas, of Eye, husbandman 2
3661115 1913751 1913751 defendant Mason Thomas husbandman 587550 587550 Mason, Thomas, of Eye, husbandman 2
3664765 1914928 1914928 plaintiff Seman William (legal representative) 587550 587550 Seman, William, of Eye, executors of 0
3669476 1916392 1916392 defendant Harold Simon laborer 587550 587550 Harold, Simon, of Eye, laborer 3
3669478 1916393 1916393 defendant Mason Thomas husbandman 587550 587550 Mason, Thomas, of Eye, husbandman 0
3669482 1916394 1916394 defendant Seman Simon mercer 587550 587550 Seman, Simon, of Eye, mercer 2
3675601 1918404 1918404 defendant Hervy John smith 587550 587550 Hervy, John, of Eye, smith 1
3681376 1920262 1920262 plaintiff Skutte Thomas draper 587550 587550 Skutte, Thomas, of Eye, draper 0
3683787 1921065 1921065 plaintiff Whetyngham Robert   587550 587550 Whetyngham, Robert, of Eye 0
3684198 1921194 1921194 defendant Whetyngham Robert yeman 587550 587550 Whetyngham, Robert, of Eye, yeman 1
3696787 1925221 1925221 plaintiff Mason Thomas   587550 587550 Mason, Thomas, of Eye 1
3710447 1929585 1929585 defendant Alee William butcher 587550 587550 Alee, William, of Eye, butcher 2
3725066 1934126 1934126 defendant Busby Robert barber 587550 587550 Busby, Robert, of Eye, barber 0
3735737 1937415 1937415 defendant Rede John yeoman 587550 587550 Rede, John, of Eye, or of Bury St Edmunds, yeoman 0
3738861 1938360 1938360 defendant Mappe Roger yeoman 587550 587550 Mappe, Roger, of Eye, yeoman 1
3779676 1951378 1951378 defendant Curtes Thomas shoemaker 587550 587550 Curtes, Thomas, of Eye, shoemaker 0
3780787 1951726 1951726 defendant Turrold John pedder 587550 587550 Turrold, John, of Eye, pedder 0
3780788 1951726 1951726 defendant Maykyn Richard pedder 587550 587550 Maykyn, Richard, of Eye, pedder 1
3784573 1952963 1952963 plaintiff Medowe John   587550 587550 Medowe, John, of Eye 0
3786671 1953625 1953625 defendant Torole Richard husbandman 587550 587550 Torole, Richard, of Eye, husbandman 0
3787210 1953792 1953792 defendant Busbye Robert   587550 587550 Busbye, Robert, of Eye, surgeon 0
3788772 1954293 1954293 defendant Goldyng John husbandman 587550 587550 Goldyng, John, of Eye, husbandman 4
3790241 1954764 1954764 defendant Thrower Robert husbandman 587550 587550 Thrower, Robert, of Eye, husbandman 0
3802950 1958819 1958819 defendant Joyner Thomas husbandman 587550 587550 Joyner, Thomas, of Eye, husbandman 0
3805618 1959701 1959701 plaintiff Thurketyll Richard clerk 587550 587550 Thurketyll, Richard, of Eye, clerk 0
3805619 1959701 1959701 plaintiff Ocley Thomas clerk 587550 587550 Ocley, Thomas, of Eye, clerk 1
3809449 1960838 1960838 defendant Parmenter Thomas yeoman 587550 587550 Parmenter, Thomas, of Eye, yeoman 1
3810323 1961120 1961120 defendant Rowe William turner 587550 587550 Rowe, William, of Eye, turner 2
3812417 1961774 1961774 defendant Thurketyll Robert clerk 587550 587550 Thurketyll, Robert, of Eye, clerk 0
3812418 1961774 1961774 defendant Wace Thomas yeoman 587550 587550 Wace, Thomas, of Eye, yeoman 1
3821633 1964650 1964650 plaintiff Seman Simon (legal representative) 587550 587550 Seman, Simon, of Eye, executor of 0
3821634 1964650 1964650 plaintiff Seman Augustine   587550 587550 Seman, Augustine, of Eye 1
3824034 1965393 1965393 defendant Thrower Richard (legal representative) 587550 587550 Thrower, Richard, of Eye, executor of 3
3825034 1965703 1965703 defendant Wace Thomas yeoman 587550 587550 (Wace, Thomas, of Eye, yeoman 1
3833516 1968414 1968414 plaintiff London Robert   587550 587550 London, Robert, of Eye 2
3837289 1969570 1969570 plaintiff Whetyngham Robert   587550 587550 Whetyngham, Robert, of Eye 2
3845244 1972074 1972074 defendant Thurston Nicholas yeoman 587550 587550 Thurston, Nicholas, of Eye, yeoman 0
3852020 1974223 1974223 defendant Mason Thomas yeoman 587550 587550 Mason, Thomas, of Eye, yeoman 0
3854605 1975085 1975085 plaintiff Torold Simon (legal representative) 587550 587550 Torold, Simon, of Eye, yeoman, executor of 0
3854607 1975085 1975085 defendant Heryng William yeoman 587550 587550 Heryng, William,of Eye, yeoman 0
3860740 1977084 1977084 plaintiff Waller William husbandman 587550 587550 Waller, William, of Eye, husbandman 1
3862695 1977717 1977717 defendant Waller William husbandman 587550 587550 Waller, William, of Eye, husbandman 0
3890237 1986979 1986979 plaintiff Herryng William   587550 587550 Herryng, William, of Eye 0
3898185 1989599 1989599 plaintiff Goldyng Christiane widow 587550 587550 (Goldyng, Christiane, of Eye, widow 1
3906327 1992402 1992402 defendant Crowe John yeoman 587550 587550 Crowe, John, of Eye, yeoman 2
3908656 1993190 1993190 plaintiff Rosyer Thomas (legal representative) 587550 587550 Rosyer, Thomas, of Eye, tanner, executor of 0
3908660 1993190 1993190 defendant Balles Anthony shoemaker 587550 587550 Balles, Anthony, of Eye, shoemaker 2
3910999 1994004 1994004 plaintiff Wace Thomas (legal representative) 587550 587550 Wace, Thomas, of Eye, executors of 0
3911002 1994004 1994004 defendant Knevet Humphrey tailor 587550 587550 Knevet, Humphrey, of Eye, tailor 0
3919497 1996852 1996852 defendant Wodward Agnes widow 587550 587550 Wodward, Agnes, of Eye, widow 0
3920935 1997348 1997348 defendant Thirkettyll John tailor 587550 587550 (Thirkettyll, John, of Eye, tailor 1
3932995 2001330 2001330 plaintiff Gislingham John yeoman 587550 587550 Gislingham, John, of Eye, yeoman 0
3932996 2001330 2001330 plaintiff Alen William yeoman 587550 587550 Alen, William, of Eye, yeoman 1
3938165 2003103 2003103 defendant Coffey John yeoman 587550 587550 Coffey, John, of Eye, yeoman 0
3951905 2007728 2007728 defendant Manbye William fishmonger 587550 587550 Manbye, William, of Eye, fishmonger 2
3951909 2007729 2007729 defendant Manbye William fishmonger 587550 587550 Manbye, William, of Eye, fishmonger 2
3956952 2009499 2009499 defendant Blunt John esq 587550 587550 Blunt, John, of Eye, esq 0
3958586 2010074 2010074 defendant Blunt John esq 587550 587550 Blunt, John, of Eye, esq 0
3958588 2010075 2010075 defendant Blunt John esq 587550 587550 Blunt, John, of Eye, esq 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);