names

302 rows where place_id = 590405

✎ 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
3601115 1868011 1868011 defendant Ecclys John gent 590405 590405 Ecclys, John, of Martham, gent 0
3603413 1868739 1868739 defendant Maynard Robert husbandman 590405 590405 Maynard, Robert, of Martham, husbandman 2
3604313 1869013 1869013 defendant Ecclys Robert gent 590405 590405 Ecclys, Robert, of Martham, gent 1
3606958 1869839 1869839 defendant Cheseman Nicholas husbandman 590405 590405 Cheseman, Nicholas, of Martham, husbandman 0
3613092 1871746 1871746 defendant Maynard Robert husbandman 590405 590405 Maynard, Robert, of Martham, husbandman 0
3628691 1903848 1903848 defendant Stannowe Roger husbandman 590405 590405 Stannowe, Roger, of Martham, husbandman 0
3628693 1903848 1903848 defendant Gedge William husbandman 590405 590405 Gedge, William, of Martham, husbandman 2
3667870 1915893 1915893 defendant Cubyt Robert   590405 590405 Cubyt, Robert, of Martham, worsted weaver 0
3669274 1916328 1916328 defendant Carkeham John carpenter 590405 590405 Carkeham, John, of Martham, carpenter 0
3674098 1917939 1917939 defendant Galle Thomas butcher 590405 590405 Galle, Thomas, of Martham, butcher 1
3674622 1918113 1918113 defendant Cokkys Nicholas husbandman 590405 590405 Cokkys, Nicholas, of Martham, husbandman 4
3674627 1918115 1918115 defendant Cokkys Nicholas yeoman 590405 590405 Cokkys, Nicholas, of Martham, yeoman 0
3678725 1919413 1919413 defendant Sewall Thomas smith 590405 590405 Sewall, Thomas, of Martham, smith 0
3687811 1922353 1922353 defendant Mamyge John   590405 590405 Mamyge, John, of Martham, worsted weaver 0
3687812 1922353 1922353 defendant Gybbys Andrew husbandman 590405 590405 Gybbys, Andrew, of Martham, husbandman 1
3688018 1922413 1922413 defendant Colvyle John gent 590405 590405 Colvyle, John, of Martham, gent 0
3691215 1923413 1923413 defendant Richers John (legal representative) 590405 590405 Richers, John, of Martham, yeoman, executor of 2
3698708 1925812 1925812 defendant Cubyte Richard   590405 590405 Cubyte, Richard, of Martham, worsted weaver 0
3703233 1927282 1927282 defendant Dryver Robert   590405 590405 Dryver, Robert, of Martham, worsted weaver 1
3704998 1927856 1927856 defendant Sewall Thomas smith 590405 590405 Sewall, Thomas, of Martham, smith 2
3705900 1928128 1928128 defendant Rychers William yeoman 590405 590405 Rychers, William, of Martham, yeoman 0
3715191 1931043 1931043 defendant Stanhough Roger yeoman 590405 590405 Stanhough, Roger, of Martham, yeoman 2
3719611 1932400 1932400 defendant Belle Robert butcher 590405 590405 Belle, Robert, of Martham, butcher 0
3719617 1932403 1932403 defendant Rygold Peter cooper 590405 590405 Rygold, Peter, of Martham, cooper 0
3720158 1932582 1932582 defendant Colvyle John gent 590405 590405 Colvyle, John, of Martham, gent 0
3720658 1932750 1932750 defendant Sewall Thomas smith 590405 590405 Sewall, Thomas, of Martham, smith 0
3726610 1934583 1934583 defendant Carman Robert yeoman 590405 590405 Carman, Robert, of Martham, yeoman 0
3736755 1937746 1937746 defendant Colvyle John gent 590405 590405 Colvyle, John, of Martham, gent 0
3736943 1937803 1937803 defendant Colvile John gent 590405 590405 Colvile, John, of Martham, gent 2
3736949 1937804 1937804 defendant Colvile John gent 590405 590405 Colvile, John, of Martham, gent 2
3748858 1941580 1941580 defendant Rychars William yeoman 590405 590405 Rychars, William, of Martham, yeoman 0
3756392 1943970 1943970 defendant Colvyle John gent 590405 590405 Colvyle, John, of Martham, gent 2
3761571 1945633 1945633 defendant Loveden or Loueden John husbandman 590405 590405 Loveden or Loueden, John, of Martham, husbandman 0
3762367 1945872 1945872 plaintiff Gedge William husbandman 590405 590405 Gedge, William, of Martham, husbandman 0
3762368 1945872 1945872 defendant Stanhowe Roger husbandman 590405 590405 Stanhowe, Roger, of Martham, husbandman 0
3762382 1945878 1945878 defendant Stutte or Scutte John laborer 590405 590405 Stutte or Scutte, John, of Martham, laborer 0
3770786 1948551 1948551 defendant Rygold Peter capper 590405 590405 Rygold, Peter, of Martham, capper 0
3777010 1950556 1950556 defendant Grymvyll John yeoman 590405 590405 Grymvyll, John, of Martham, yeoman 1
3779788 1951410 1951410 defendant Colvyle John gent 590405 590405 Colvyle, John, of Martham, gent 3
3780742 1951712 1951712 defendant Belle Robert butcher 590405 590405 Belle, Robert, of Martham, butcher 0
3783303 1952529 1952529 defendant Cok James chaplain 590405 590405 Cok, James, of Martham, chaplain 0
3783307 1952530 1952530 defendant Stanhowe Roger yeoman 590405 590405 Stanhowe, Roger, of Martham, yeoman 2
3794195 1956056 1956056 defendant Wygat Thomas butcher 590405 590405 Wygat, Thomas, of Martham, butcher 2
3798457 1957418 1957418 defendant Wygote John husbandman 590405 590405 Wygote, John, of Martham, husbandman 0
3806728 1960003 1960003 defendant Cubite Robert   590405 590405 Cubite, Robert, of Martham, worsted weaver 1
3812327 1961748 1961748 defendant Stannowe Roger yeoman 590405 590405 Stannowe, Roger, of Martham, yeoman 0
3815254 1962687 1962687 defendant Andros Robert yeoman 590405 590405 Andros, Robert, of Martham, yeoman 0
3817242 1963305 1963305 defendant Colvile John gent 590405 590405 Colvile, John,of Martham, gent 3
3817254 1963307 1963307 defendant Colvile John gent 590405 590405 (Colvile, John, of Martham, gent 3
3818295 1963629 1963629 defendant Carman Robert husbandman 590405 590405 Carman, Robert, of Martham, husbandman 0
3818296 1963629 1963629 defendant Yoxhele William husbandman 590405 590405 Yoxhele, William, of Martham, husbandman 1
3848861 1973234 1973234 defendant Cubyt Robert husbandman 590405 590405 Cubyt, Robert, of Martham, husbandman 2
3849790 1973521 1973521 defendant Taylour Robert engraver 590405 590405 Taylour, Robert, of Martham, engraver 3
3855631 1975400 1975400 defendant Howseby John husbandman 590405 590405 Howseby, John, of Martham, husbandman 3
3855632 1975400 1975400 defendant Ballard Thomas husbandman 590405 590405 Ballard, Thomas, of Martham, husbandman 4
3855634 1975401 1975401 defendant Willyams Robert carpenter 590405 590405 Willyams, Robert, of Martham, carpenter 0
3855635 1975401 1975401 defendant Lounde Robert fuller 590405 590405 Lounde, Robert, of Martham, fuller 1
3855636 1975401 1975401 defendant Howsby John husbandman 590405 590405 Howsby, John, of Martham, husbandman 2
3856995 1975821 1975821 defendant Roberdys John husbandman 590405 590405 Roberdys, John, of Martham, husbandman 3
3857411 1975952 1975952 defendant Colvyle John gent 590405 590405 Colvyle, John, of Martham, gent 2
3864064 1978165 1978165 defendant Colvell John gent 590405 590405 Colvell, John, of Martham, gent 2
3870239 1980295 1980295 defendant Tailler Robert husbandman 590405 590405 Tailler, Robert, of Martham, husbandman 0
3873440 1981332 1981332 defendant White William clerk 590405 590405 White, William, of Martham, clerk 0
3877223 1982623 1982623 defendant Grymbyle John yeoman 590405 590405 Grymbyle, John, of Martham, yeoman 0
3877226 1982624 1982624 defendant Grymble Robert yeoman 590405 590405 Grymble, Robert, of Martham, yeoman 1
3878712 1983129 1983129 defendant Colvyle John gent 590405 590405 Colvyle, John, of Martham, gent 0
3884026 1984927 1984927 defendant Colvell John gent 590405 590405 Colvell, John, of Martham, gent 1
3889849 1986845 1986845 defendant Kevyt Robert yeoman 590405 590405 Kevyt, Robert, of Martham, yeoman 2
3893229 1987971 1987971 defendant Eche Thomas husbandman 590405 590405 Eche, Thomas, of Martham, husbandman 0
3895659 1988752 1988752 defendant Mosoby John husbandman 590405 590405 Mosoby, John, of Martham, husbandman 1
3904449 1991733 1991733 defendant Hethe John husbandman 590405 590405 Hethe, John, of Martham, husbandman 2
3911037 1994018 1994018 defendant Moresby John husbandman 590405 590405 Moresby, John, of Martham, husbandman 0
3911038 1994018 1994018 defendant Hethe John husbandman 590405 590405 Hethe, John, of Martham, husbandman 1
3923666 1998228 1998228 defendant Bloffeld Thomas husbandman 590405 590405 Bloffeld, Thomas, of Martham, husbandman 0
3923667 1998228 1998228 defendant Warne John husbandman 590405 590405 Warne, John, of Martham, husbandman 1
3923730 1998245 1998245 defendant Morseby John husbandman 590405 590405 Morseby, John, of Martham, husbandman 1
3924807 1998615 1998615 defendant Tytyng Nicholas husbandman 590405 590405 Tytyng, Nicholas, of Martham, husbandman 0
3924833 1998624 1998624 defendant Tytyng Nicholas husbandman 590405 590405 Tytyng, Nicholas, of Martham, husbandman 0
3924834 1998624 1998624 defendant Hothe Richard husbandman 590405 590405 Hothe, Richard, of Martham, husbandman 1
3940887 2003957 2003957 defendant Robardys John husbandman 590405 590405 Robardys, John, of Martham, husbandman 0
3949549 2006915 2006915 defendant Myllys Robert husbandman 590405 590405 Myllys, Robert, of Martham, husbandman 0
3969077 2013799 2013799 defendant Tongate Walter yeoman 590405 590405 Tongate, Walter, of Martham, yeoman 5
4018792 2031453 2031453 defendant Stanton Robert yeoman 590405 590405 Stanton, Robert, of Martham, yeoman 0
4018793 2031453 2031453 defendant Wrentham Thomas husbandman 590405 590405 Wrentham, Thomas, of Martham, husbandman 1
4018794 2031453 2031453 defendant Evett John husbandman or butcher 590405 590405 Evett, John, of Martham, husbandman or butcher 2
4021669 2032478 2032478 defendant Edon Thomas yeoman 590405 590405 Edon, Thomas, of Martham, yeoman 0
4051769 2043052 2043052 defendant Stanton Robert yeoman 590405 590405 Stanton, Robert, of Martham, yeoman 0
4061453 2046495 2046495 defendant Tylson John tailor 590405 590405 Tylson, John, of Martham, tailor 1
4072099 2050320 2050320 defendant Pettawe Robert cordwainer 590405 590405 Pettawe, Robert, of Martham, cordwainer 0
4075319 2051475 2051475 defendant Pette Robert cordwainer 590405 590405 Pette, Robert, of Martham, cordwainer 0
4075320 2051475 2051475 defendant Beckett John, senior husbandman 590405 590405 Beckett, John, senior, of Martham, husbandman 1
4075434 2051515 2051515 defendant Bennet henry gent 590405 590405 Bennet, henry, of Martham, gent 3
4076683 2051944 2051944 defendant Pyle Thomas yeoman 590405 590405 Pyle, Thomas, of Martham, yeoman 9
4081975 2053854 2053854 defendant Stanton Robert yeoman 590405 590405 Stanton, Robert, of Martham, yeoman 0
4107590 2062998 2062998 defendant Tylson John tailor 590405 590405 Tylson, John, of Martham, tailor 0
4111514 2064363 2064363 defendant Eden Leonard husbandman 590405 590405 Eden, Leonard, of Martham, husbandman 1
4113008 2064920 2064920 defendant Saver- Joan widow 590405 590405 Saver-, Joan, of Martham, widow 3
4132345 2071882 2071882 defendant Rollesbie Samuel husbandman 590405 590405 Rollesbie, Samuel, of Martham, or of Flegge Bastwicke, husbandman 0
4139924 2074645 2074645 defendant Burton Thomas butcher 590405 590405 Burton, Thomas, of Martham, butcher 0
4139927 2074645 2074645 defendant Bessey Henry yeoman 590405 590405 Bessey, Henry, of Martham, yeoman 3

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