names

3,403 rows where place_id = 586134

✎ 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
3588007 1863902 1863902 plaintiff Baldry Thomas merchant 586134 586134 Baldry, Thomas, of Ipswich, merchant 0
3588008 1863902 1863902 plaintiff Dryver Thomas merchant 586134 586134 Dryver, Thomas, of Ipswich, merchant 1
3588628 1864086 1864086 defendant Hastyng John merchant 586134 586134 Hastyng, John, of Ipswich, merchant 0
3588631 1864087 1864087 defendant Hastyng Thomas yeoman 586134 586134 Hastyng, Thomas, of Ipswich, yeoman 1
3589097 1864238 1864238 defendant Bokkyng Edmund gent 586134 586134 Bokkyng, Edmund, of Ipswich, gent 0
3589619 1864395 1864395 defendant Osberne John clerk 586134 586134 Osberne, John, of Ipswich, clerk 0
3589736 1864429 1864429 defendant Buxton Alice widow 586134 586134 Buxton, Alice, of Ipswich, widow 0
3589737 1864429 1864429 defendant Hertford Thomas merchant 586134 586134 Hertford, Thomas, of Ipswich, merchant 1
3589740 1864430 1864430 defendant Harlewyn William yeoman 586134 586134 Harlewyn, William, of Ipswich, yeoman 0
3589741 1864430 1864430 defendant Phelipp Thomas yeoman 586134 586134 Phelipp, Thomas, of Ipswich, yeoman 1
3589951 1864496 1864496 defendant Godyng John chapman 586134 586134 Godyng, John, of Ipswich, chapman 1
3590184 1864569 1864569 defendant Blomvyle Robert yeoman 586134 586134 Blomvyle, Robert, of Ipswich, yeoman 0
3590793 1864760 1864760 defendant Woode Mathew butcher 586134 586134 Woode, Mathew, of Ipswich, butcher 0
3592253 1865191 1865191 defendant Dorman John hardwareman 586134 586134 Dorman, John, of Ipswich, hardwareman 0
3596274 1866464 1866464 defendant Hervy Robert baker 586134 586134 Hervy, Robert, of Ipswich, baker 0
3596275 1866464 1866464 defendant Smyth Thomas draper 586134 586134 Smyth, Thomas, of Ipswich, draper 1
3596720 1866608 1866608 defendant Gyler John tailor 586134 586134 Gyler, John, of Ipswich, tailor 2
3597045 1866699 1866699 defendant Herryson John beer brewer 586134 586134 Herryson, John, of Ipswich, beer brewer 0
3597046 1866699 1866699 defendant Ducheman Simon beer brewer 586134 586134 Ducheman, Simon, of Ipswich, beer brewer 1
3597379 1866801 1866801 defendant Redgrave William barker 586134 586134 Redgrave, William, of Ipswich, barker 3
3597432 1866815 1866815 defendant Redgrave William barker 586134 586134 Redgrave, William, of Ipswich, barker 2
3598317 1867102 1867102 defendant Cane or Cave Robert skinner 586134 586134 Cane or Cave, Robert, of Ipswich, skinner 0
3598320 1867102 1867102 defendant Bateman Simon (legal representative) 586134 586134 Bateman, Simon, of Ipswich, executrix of 3
3598321 1867102 1867102 defendant Bateman Elizabeth widow 586134 586134 Bateman, Elizabeth, of Ipswich, widow 4
3598608 1867190 1867190 defendant Kyrre John (legal representative) 586134 586134 Kyrre, John, of Ipswich, yeoman, administratrix of 4
3598609 1867190 1867190 defendant Kyrre Rose widow 586134 586134 Kyrre, Rose, of Ipswich, widow 5
3600514 1867810 1867810 plaintiff Wymbyll William (legal representative) 586134 586134 Wymbyll, William, of Ipswich, mercer, executors of 0
3600579 1867828 1867828 defendant Keche John yeoman 586134 586134 Keche, John, of Ipswich, yeoman 0
3600581 1867829 1867829 defendant Keche John yeoman 586134 586134 Keche, John, of Ipswich, yeoman 0
3600774 1867903 1867903 defendant Keche John yeoman 586134 586134 Keche, John, of Ipswich, yeoman 0
3600775 1867903 1867903 defendant Smyth Thomas draper 586134 586134 Smyth, Thomas, of Ipswich, draper 1
3600776 1867903 1867903 defendant Wapon John merchant 586134 586134 Wapon, John, of Ipswich, merchant 2
3601445 1868110 1868110 defendant Moysses John yeoman 586134 586134 Moysses, John, of Ipswich, yeoman 2
3601454 1868111 1868111 defendant Harvy William baker 586134 586134 Harvy, William, of Ipswich, baker 1
3601463 1868112 1868112 defendant Hervy Robert baker 586134 586134 Hervy, Robert, of Ipswich, baker 1
3602453 1868425 1868425 defendant Hervy Robert baker 586134 586134 Hervy, Robert, of Ipswich, baker 0
3602593 1868472 1868472 defendant Fastolff John gent 586134 586134 Fastolff, John, of Ipswich, gent 0
3603963 1868907 1868907 defendant Smyth Thomas draper 586134 586134 Smyth, Thomas, of Ipswich, draper 2
3603989 1868914 1868914 defendant Batell Thomas chapman 586134 586134 Batell, Thomas, of Ipswich, chapman 1
3604179 1868973 1868973 defendant Halle Robert sherman 586134 586134 Halle, Robert, of Ipswich, sherman 1
3604378 1869036 1869036 defendant Kyrre Rose (legal representative) 586134 586134 Kyrre, Rose, of Ipswich, administrator of 4
3605607 1869419 1869419 defendant Cotelere John merchant 586134 586134 Cotelere, John, of Ipswich, merchant 0
3605641 1869430 1869430 plaintiff Lacford Giles   586134 586134 Lacford, Giles, of Ipswich 0
3605645 1869431 1869431 plaintiff Lacford Giles   586134 586134 Lacford, Giles, of Ipswich 0
3605649 1869432 1869432 plaintiff Lacford Giles   586134 586134 Lacford, Giles, of Ipswich 0
3606846 1869807 1869807 defendant Bull William merchant 586134 586134 Bull, William, of Ipswich, merchant 4
3606969 1869841 1869841 defendant Fastolff John esq 586134 586134 Fastolff, John, of Ipswich, esq 1
3607071 1869877 1869877 plaintiff Purchet alias Candeler Nicholas chandler 586134 586134 Purchet alias Candeler, Nicholas, of Ipswich, chandler 0
3607528 1870012 1870012 defendant Cokkok Robert merchant 586134 586134 Cokkok, Robert, of Ipswich, merchant 0
3608981 1870467 1870467 defendant Pytte John husbandman 586134 586134 Pytte, John, of Ipswich, husbandman 1
3613317 1871814 1871814 defendant Candeler alias Purget Richard raffman 586134 586134 (Candeler alias Purget, Richard, of Ipswich, raffman 3
3613438 1871850 1871850 defendant Cloveer John glover 586134 586134 Cloveer, John, of Ipswich, glover 2
3614112 1872078 1872078 defendant Dryver Thomas mercer 586134 586134 Dryver, Thomas, of Ipswich, mercer 0
3614114 1872079 1872079 defendant Keche John yeoman 586134 586134 Keche, John, of Ipswich, yeoman 0
3615011 1872339 1872339 defendant Blumveld or Blumvyle Thomas merchant 586134 586134 Blumveld or Blumvyle, Thomas, of Ipswich, merchant 0
3615308 1872433 1872433 defendant Bulle William merchant 586134 586134 Bulle, William, of Ipswich, merchant 0
3615313 1872434 1872434 defendant Bulle William merchant 586134 586134 Bulle, William, of Ipswich, merchant 0
3615758 1872569 1872569 defendant Felowe William merchant 586134 586134 Felowe, William, of Ipswich, merchant 0
3615899 1872613 1872613 plaintiff Crausfen or Cransfen Richard merchant 586134 586134 Crausfen or Cransfen, Richard, of Ipswich, merchant 0
3615900 1872613 1872613 defendant Felawe William merchant 586134 586134 Felawe, William, of Ipswich, merchant 0
3616605 1872825 1872825 defendant Cutteler Johm mariner 586134 586134 Cutteler, Johm, of Ipswich, mariner 0
3616606 1872825 1872825 defendant Forgon John barker 586134 586134 Forgon, John, of Ipswich, barker 1
3617368 1873051 1873051 defendant Boolle William yeoman 586134 586134 Boolle, William, of Ipswich, yeoman 2
3617374 1873053 1873053 defendant Boolle William yeoman 586134 586134 Boolle, William, of Ipswich, yeoman 2
3618852 1873508 1873508 defendant Laster John, senior shoemaker 586134 586134 Laster, John, senior, of Ipswich, shoemaker 0
3619729 1873741 1873741 defendant Walton Thomas merchant 586134 586134 Walton, Thomas, of Ipswich, merchant 0
3620090 1873859 1873859 defendant Qwhyllter John merchant 586134 586134 Qwhyllter, John, of Ipswich, merchant 0
3620282 1873924 1873924 defendant Cranssen Richard merchant 586134 586134 Cranssen, Richard, of Ipswich, merchant 0
3620786 1874073 1874073 defendant Lunte John merchant 586134 586134 Lunte, John, of Ipswich, merchant 1
3621223 1874179 1874179 defendant Koche or Keche John husbandman 586134 586134 Koche or Keche, John, of Ipswich, husbandman 0
3622702 1874629 1874629 defendant Stannard Henry yeoman 586134 586134 Stannard, Henry, of Ipswich, yeoman 1
3622709 1874631 1874631 defendant Stannard Henry yeoman 586134 586134 Stannard, Henry, of Ipswich, yeoman 0
3623138 1874759 1874759 defendant Quylter John fuller or mariner 586134 586134 Quylter, John, of Ipswich, fuller or mariner 0
3623689 1874940 1874940 defendant Tymperley Roger gent 586134 586134 Tymperley, Roger, of Ipswich, gent 0
3626448 1903127 1903127 plaintiff Stannard Henry   586134 586134 Stannard, Henry, of Ipswich 1
3626684 1903191 1903191 defendant Howham William merchant of the staple 586134 586134 Howham, William, of Ipswich, or of Langham, Rutland, merchant of the staple 0
3626690 1903192 1903192 defendant Howham William merchant of the staple 586134 586134 Howham, William, of Ipswich, or of Langham, Rutland, merchant of the staple 0
3627925 1903587 1903587 defendant Goodwyn Robert merchant 586134 586134 Goodwyn, Robert, of Ipswich, merchant 0
3628789 1903881 1903881 defendant Osberne Alan merchant 586134 586134 Osberne, Alan, of Ipswich, merchant 0
3629661 1904130 1904130 defendant Batayle Thomas fuller 586134 586134 Batayle, Thomas, of Ipswich, fuller 0
3629662 1904130 1904130 defendant Batayle Hugh fuller 586134 586134 Batayle, Hugh, of Ipswich, fuller 1
3631080 1904546 1904546 plaintiff Fyn John singleman 586134 586134 Fyn, John, of Ipswich, singleman 0
3631289 1904601 1904601 plaintiff Gelgelt Edmund   586134 586134 Gelgelt, Edmund, of Ipswich 0
3631291 1904602 1904602 plaintiff Gelgelt Edmund   586134 586134 Gelgelt, Edmund, of Ipswich 0
3631298 1904602 1904602 defendant Harforth Thomas merchant 586134 586134 Harforth, Thomas, of Ipswich, merchant 6
3631302 1904602 1904602 defendant Reynold John clothmaker 586134 586134 Reynold, John, of Ipswich, clothmaker 10
3631303 1904602 1904602 defendant Brade John merchant 586134 586134 Brade, John, of Ipswich, merchant 11
3631312 1904603 1904603 plaintiff Gelgett Edmund   586134 586134 Gelgett, Edmund, of Ipswich 0
3631445 1904647 1904647 plaintiff Golgett Edmund   586134 586134 Golgett, Edmund, of Ipswich 0
3631805 1904755 1904755 plaintiff Gylys William   586134 586134 Gylys, William, of Ipswich 0
3631806 1904755 1904755 defendant Man John clothmaker 586134 586134 Man, John, of Ipswich, clothmaker 0
3631807 1904755 1904755 defendant Man Thomas mercer 586134 586134 Man, Thomas, of Ipswich, mercer 1
3631809 1904755 1904755 defendant Hert Alan mariner 586134 586134 Hert, Alan, of Ipswich, mariner 3
3632023 1904833 1904833 defendant Fastall George gent 586134 586134 Fastall, George, of Ipswich, gent 0
3632105 1904858 1904858 plaintiff Harvy Nicholas merchant 586134 586134 Harvy, Nicholas, of Ipswich, merchant 0
3632200 1904887 1904887 defendant Hill James merchant 586134 586134 Hill, James, of Ipswich, merchant 0
3632205 1904888 1904888 defendant Bennet William mercer 586134 586134 Bennet, William, of Ipswich, mercer 0
3632447 1904965 1904965 defendant Brown William, junior singleman 586134 586134 Brown, William, junior, of Ipswich, singleman 1
3633668 1905340 1905340 defendant Hayward Christopher clothmaker 586134 586134 Hayward, Christopher, of Ipswich, clothmaker 0
3634376 1905551 1905551 plaintiff Mawer Gregory clerk 586134 586134 Mawer, Gregory, of Ipswich, clerk 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);