names

245 rows where place_id = 587904

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592776 1865352 1865352 defendant Cobold William butcher 587904 587904 Cobold, William, of Lowestoft, butcher 2
3606616 1869742 1869742 defendant Steyngate Richard mariner 587904 587904 Steyngate, Richard, of Lowestoft, mariner 2
3618555 1873427 1873427 defendant Bury Robert baker 587904 587904 Bury, Robert, of Lowestoft, baker 1
3622716 1874633 1874633 defendant Weston Robert husbandman 587904 587904 Weston, Robert, of Lowestoft, husbandman 1
3622720 1874634 1874634 defendant Saxmendham John mariner 587904 587904 Saxmendham, John, of Lowestoft, mariner 0
3627284 1903380 1903380 defendant Higham John yeoman 587904 587904 Higham, John, of Lowestoft, yeoman 0
3629289 1904021 1904021 defendant Murdok Robert yeoman 587904 587904 Murdok, Robert, of Lowestoft, yeoman 0
3637334 1906480 1906480 defendant Browtte John husbandman 587904 587904 Browtte, John, of Lowestoft, husbandman 0
3640602 1907502 1907502 defendant Monkey John tailor 587904 587904 Monkey, John, of Lowestoft, tailor 0
3642227 1908017 1908017 defendant Calver John carpenter 587904 587904 Calver, John, of Lowestoft, carpenter 0
3645255 1908923 1908923 defendant Higham John yeoman 587904 587904 Higham, John, of Lowestoft, yeoman 1
3646237 1909214 1909214 plaintiff Holme John yeoman 587904 587904 Holme, John, of Lowestoft, yeoman 2
3657802 1912692 1912692 plaintiff Dene Ralph   587904 587904 Dene, Ralph, of Lowestoft 0
3660192 1913449 1913449 plaintiff Hatclyff Nicholas   587904 587904 Hatclyff, Nicholas, of Lowestoft 0
3661173 1913771 1913771 plaintiff Joto William (legal representative) 587904 587904 Joto, William, of Lowestoft, executors of 0
3692380 1923791 1923791 plaintiff Jetour John, junior   587904 587904 Jetour, John, junior, of Lowestoft 0
3709175 1929166 1929166 defendant Ovye or Obye Theodore husbandman 587904 587904 Ovye or Obye, Theodore, of Lowestoft, husbandman 0
3709176 1929166 1929166 defendant Ovy or Oby Thomas butcher 587904 587904 Ovy or Oby, Thomas, of Lowestoft, butcher 1
3709177 1929166 1929166 defendant Annot Thomas   587904 587904 Annot, Thomas, of Lowestoft, shipwright 2
3709178 1929166 1929166 defendant James Richard shoemaker 587904 587904 James, Richard, of Lowestoft, shoemaker 3
3709179 1929166 1929166 defendant Botsweyn John mariner 587904 587904 Botsweyn, John, of Lowestoft, mariner 4
3709644 1929325 1929325 defendant Den Ralph yeoman 587904 587904 Den, Ralph, of Lowestoft, yeoman 0
3717916 1931904 1931904 defendant Skarlet Richard yeoman 587904 587904 Skarlet, Richard, of Lowestoft, yeoman 0
3719210 1932294 1932294 defendant Dene Ralph tailor 587904 587904 Dene, Ralph, of Lowestoft, tailor 2
3719215 1932295 1932295 defendant Palmer John gent 587904 587904 Palmer, John, of Lowestoft, gent 1
3719253 1932308 1932308 defendant Lyncolne John miller 587904 587904 Lyncolne, John, of Lowestoft, miller 0
3720776 1932788 1932788 defendant Dene Ralph draper 587904 587904 Dene, Ralph, of Lowestoft, draper 0
3730553 1935792 1935792 defendant Dene Ralph draper 587904 587904 Dene, Ralph, of Lowestoft, draper 0
3738627 1938290 1938290 defendant Sellyng Richard yeoman 587904 587904 Sellyng, Richard, of Lowestoft, yeoman 2
3739001 1938404 1938404 defendant Arnold John laborer 587904 587904 Arnold, John, of Lowestoft, laborer 0
3749693 1941815 1941815 defendant Sparowe John (legal representative) 587904 587904 Sparowe, John, of Lowestoft, yeoman, executor of 1
3749694 1941815 1941815 defendant Everard John merchant 587904 587904 Everard, John, of Lowestoft, merchant 2
3758011 1944489 1944489 defendant Holleys Thomas baker 587904 587904 Holleys, Thomas, of Lowestoft, baker 0
3760714 1945350 1945350 defendant Landesfeld Richard merchant 587904 587904 Landesfeld, Richard, of Lowestoft, merchant 2
3764738 1946635 1946635 defendant Lobbys Geoffrey yeoman 587904 587904 (Lobbys, Geoffrey, of Lowestoft, yeoman 1
3764739 1946635 1946635 defendant Everard John merchant 587904 587904 Everard, John, of Lowestoft, merchant 2
3794926 1956280 1956280 defendant Rowyth John beer brewer 587904 587904 Rowyth, John, of Lowestoft, beer brewer 2
3845747 1972218 1972218 defendant Dene Joan widow 587904 587904 Dene, Joan, of Lowestoft, widow 2
3848305 1973042 1973042 defendant Besfeld Thomas mariner 587904 587904 Besfeld, Thomas, of Lowestoft, mariner 0
3848463 1973100 1973100 defendant Gare Robert merchant 587904 587904 Gare, Robert, of Lowestoft, merchant 0
3848464 1973100 1973100 defendant Wyllot Robert merchant 587904 587904 Wyllot, Robert, of Lowestoft, merchant 1
3866131 1978902 1978902 plaintiff Payn Gregory   587904 587904 Payn, Gregory, of Lowestoft 0
3871327 1980661 1980661 defendant Davy Richard butcher 587904 587904 Davy, Richard, of Lowestoft, butcher 0
3875051 1981884 1981884 defendant Shottysham Nicholas baker 587904 587904 Shottysham, Nicholas, of Lowestoft, baker 1
3875481 1982042 1982042 defendant Davy Richard butcher 587904 587904 Davy, Richard, of Lowestoft, butcher 0
3875482 1982042 1982042 defendant Burgatt James tailor 587904 587904 Burgatt, James, of Lowestoft, tailor 1
3880142 1983612 1983612 plaintiff Payne Gregory gent 587904 587904 Payne, Gregory, of Lowestoft, gent 0
3880846 1983863 1983863 defendant Broun Thomas yeoman 587904 587904 Broun, Thomas, of Lowestoft, yeoman 0
3898375 1989669 1989669 plaintiff Annott Thomas   587904 587904 Annott, Thomas, of Lowestoft 0
3900307 1990335 1990335 plaintiff Burges Thomas merchant 587904 587904 Burges, Thomas, of Lowestoft, merchant 0
3912204 1994409 1994409 defendant Drury Edward singleman or merchant 587904 587904 Drury, Edward, of Lowestoft, singleman or merchant 0
3912603 1994547 1994547 defendant Botolff John gent 587904 587904 Botolff, John, of Lowestoft, gent 0
3919597 1996885 1996885 defendant Davy Thomas butcher 587904 587904 Davy, Thomas, of Lowestoft, butcher 0
3924271 1998425 1998425 defendant Gylbank Etheldred widow 587904 587904 Gylbank, Etheldred, of Lowestoft, widow 1
3927318 1999477 1999477 defendant Befylde Thomas merchant 587904 587904 Befylde, Thomas, of Lowestoft, merchant 0
3932586 2001189 2001189 defendant Hawnce William butcher 587904 587904 Hawnce, William, of Lowestoft, butcher 0
3934805 2001940 2001940 defendant Payne Gregory gent 587904 587904 Payne, Gregory, of Lowestoft, gent 0
3935156 2002067 2002067 defendant Crawer Thomas merchant 587904 587904 Crawer, Thomas, of Lowestoft, merchant 1
3935168 2002072 2002072 plaintiff Jettor James merchant 587904 587904 Jettor, James, of Lowestoft, merchant 0
3935874 2002311 2002311 defendant Jervys William mariner 587904 587904 Jervys, William, of Lowestoft, mariner 0
3936015 2002363 2002363 defendant Sellyng Richard yeoman 587904 587904 Sellyng, Richard, of Lowestoft, yeoman 0
3937611 2002910 2002910 defendant Wulward Richard carpenter 587904 587904 Wulward, Richard, of Lowestoft, carpenter 0
3938644 2003266 2003266 defendant Robson Lawrence mainer 587904 587904 Robson, Lawrence, of Lowestoft, mainer 0
3939979 2003670 2003670 plaintiff Skerlett Richard (legal representative) 587904 587904 Skerlett, Richard, of Lowestoft, merchant, administrator of 0
3939982 2003671 2003671 plaintiff Skerlett Robert merchant 587904 587904 Skerlett, Robert, of Lowestoft, merchant 0
3939984 2003671 2003671 defendant Harryson alias Lucas John   587904 587904 Harryson alias Lucas, John, of Lowestoft, cord wainer 1
3942168 2004400 2004400 defendant Sellyng John yeoman 587904 587904 Sellyng, John, of Lowestoft, yeoman 0
3958037 2009878 2009878 plaintiff Rante Roger baker 587904 587904 Rante, Roger, of Lowestoft, baker 0
3959135 2010281 2010281 defendant Woode John mariner 587904 587904 Woode, John, of Lowestoft, mariner 0
3965261 2012464 2012464 defendant Nestlyn William butcher 587904 587904 Nestlyn, William, of Lowestoft, butcher 0
3973665 2015362 2015362 defendant Brewer Robert merchant 587904 587904 Brewer, Robert, of Lowestoft, merchant 0
3974766 2015739 2015739 defendant Nestlyn William butcher 587904 587904 Nestlyn, William, of Lowestoft, butcher 0
3982931 2018675 2018675 plaintiff Skarlet Robert (legal representative) 587904 587904 Skarlet, Robert, of Lowestoft, merchant, executors of 0
4041169 2039332 2039332 defendant Drawer Richard merchant 587904 587904 Drawer, Richard, of Lowestoft, merchant 0
4127960 2070290 2070290 defendant Doo Robert yeoman 587904 587904 Doo, Robert, of Lowestoft, or of Thrandeston, yeoman 0
4135887 2073166 2073166 defendant Hoo alias Howse John gent 587904 587904 Hoo alias Howse, John, of Lowestoft, gent 0
4234877 2107751 2107751 defendant Nicholl James (legal representative) 587904 587904 Nicholl, James, of Lowestoft, sailor, executors of 0
4247188 2112036 2112036 defendant Bever Ezechial husbandman 587904 587904 Bever, Ezechial, of Lowestoft, husbandman 0
4250976 2113307 2113307 defendant Lyttle John   587904 587904 Lyttle, John, of Lowestoft, sailor 0
4258431 2115786 2115786 defendant Yongeman John husbandman 587904 587904 Yongeman, John, of Lowestoft, husbandman 1
4281214 2123338 2123338 defendant Goddard John husbandman 587904 587904 Goddard, John, of of Lowestoft, husbandman 1
4281964 2123592 2123592 defendant Gislingham Joan widow 587904 587904 Gislingham, Joan, of Lowestoft, widow 1
4283381 2124093 2124093 defendant Stamford Christopher husbandman 587904 587904 Stamford, Christopher, of Lowestoft, husbandman 0
4283382 2124093 2124093 defendant Kerbill or Kerbibb Edmund gent 587904 587904 Kerbill or Kerbibb, Edmund, of Lowestoft, gent 1
4321263 2137529 2137529 defendant Nashe Israel chapman 587904 587904 Nashe, Israel, of Lowestoft, grocer, chapman 1
4327760 2139609 2139609 defendant Bedingfeld John gent 587904 587904 Bedingfeld, John, of Lowestoft, gent 1
4327761 2139609 2139609 defendant Coppinge Thomas tanner 587904 587904 Coppinge, Thomas, of Lowestoft, tanner 2
4336740 2142579 2142579 defendant Fulwoode Mathew yeoman 587904 587904 Fulwoode, Mathew, of Lowestoft, yeoman 0
4336741 2142579 2142579 defendant Frenche Christiana widow 587904 587904 Frenche, Christiana, of Lowestoft, widow 1
4337703 2142932 2142932 defendant Launde John cooper 587904 587904 Launde, John, of Lowestoft, cooper 0
4353969 2148614 2148614 defendant Seaman John   587904 587904 Seaman, John, of Lowestoft, yeoman, administrators of 1
4353970 2148614 2148614 defendant Spratt Thomas baker 587904 587904 (Spratt, Thomas, of Lowestoft, baker 2
4353971 2148614 2148614 defendant Girlinge Robert yeoman 587904 587904 Girlinge, Robert, of Lowestoft, yeoman 3
4356289 2149425 2149425 defendant Clarke Thomas husbandman 587904 587904 Clarke, Thomas, of Lowestoft, husbandman 1
4356290 2149425 2149425 defendant Barrett John miller 587904 587904 Barrett, John, of Lowestoft, miller 2
4372761 2155333 2155333 defendant Blenerhassett Thomas esq 587904 587904 Blenerhassett, Thomas, of Lowestoft, esq 0
4375931 2156454 2156454 defendant Fifeld George cordwainer 587904 587904 Fifeld, George, of Lowestoft, cordwainer 0
4378108 2157239 2157239 defendant Seaman John   587904 587904 Seaman, John, of Lowestoft, yeoman, administrators of 0
4378109 2157239 2157239 defendant Spratt Thomas baker 587904 587904 (Spratt, Thomas, of Lowestoft, baker 1
4378110 2157239 2157239 defendant Girlinge Robert yeoman 587904 587904 Girlinge, Robert, of Lowestoft, yeoman 2

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