names

202 rows where place_id = 596323

✎ 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
3624195 1875100 1875100 defendant Bunne Thomas shipman 596323 596323 Bunne, Thomas, of Cromer, shipman 0
3624196 1875100 1875100 defendant Robyns William shipman 596323 596323 Robyns, William, of Cromer, shipman 1
3644530 1908706 1908706 plaintiff Fen Ralph   596323 596323 Fen, Ralph, of Cromer 0
3654603 1911702 1911702 defendant Colman John   596323 596323 Colman, John, of Cromer, worsted weaver 0
3672179 1917297 1917297 defendant Mayson Margaret widow 596323 596323 Mayson, Margaret, of Cromer, widow 0
3675417 1918348 1918348 defendant Heyles Henry merchant 596323 596323 Heyles, Henry, of Cromer, merchant 1
3678538 1919346 1919346 plaintiff Mundys William (legal representative) 596323 596323 Mundys, William, of Cromer, executors of 0
3678540 1919346 1919346 defendant Parret Robert husbandman 596323 596323 Parret, Robert, of Cromer, husbandman 0
3678543 1919346 1919346 defendant Fyssheman John mariner 596323 596323 Fyssheman, John, of Cromer, mariner 3
3679037 1919516 1919516 defendant Hayles Henry mercer 596323 596323 Hayles, Henry, of Cromer, mercer 2
3680435 1919963 1919963 defendant Conyby John mariner 596323 596323 Conyby, John, of Cromer, mariner 1
3682151 1920525 1920525 plaintiff Stronge Alice widow 596323 596323 Stronge, Alice, of Cromer, widow 0
3691220 1923414 1923414 defendant Smyth Alice widow 596323 596323 (Smyth, Alice, of Cromer, widow 1
3691221 1923414 1923414 defendant Smyth James   596323 596323 Smyth, James, of Cromer 2
3693653 1924209 1924209 defendant Colbys Margaret widow 596323 596323 Colbys, Margaret, of Cromer, widow 2
3693738 1924237 1924237 plaintiff Mason Katherine (legal representative) 596323 596323 Mason, Katherine, of Cromer, executor of 0
3716973 1931595 1931595 defendant Broune Robert mariner 596323 596323 Broune, Robert, of Cromer, mariner 1
3716975 1931595 1931595 defendant Dewgles Edmund husbandman 596323 596323 Dewgles, Edmund, of Cromer, husbandman 3
3719261 1932310 1932310 defendant Haylys William mercer 596323 596323 Haylys, William, of Cromer, mercer 2
3719262 1932310 1932310 defendant Manyngham John mercer 596323 596323 Manyngham, John, of Cromer, mercer 3
3734918 1937159 1937159 defendant Tompson alias Barker John beer brewer 596323 596323 Tompson alias Barker, John, of Cromer, beer brewer 2
3747669 1941191 1941191 defendant Haylys Henry merchant 596323 596323 Haylys, Henry, of Cromer, merchant 0
3755810 1943771 1943771 defendant Haylys Henry merchant 596323 596323 Haylys, Henry, of Cromer, merchant 0
3766451 1947164 1947164 defendant Glover Thomas chapman 596323 596323 Glover, Thomas, of Cromer, chapman 1
3775927 1950221 1950221 plaintiff Brese Thomas   596323 596323 Brese, Thomas, of Cromer 0
3784161 1952828 1952828 defendant Halys William mercer 596323 596323 Halys, William, of Cromer, mercer 1
3797944 1957255 1957255 defendant Stalys John baker 596323 596323 Stalys, John, of Cromer, baker 0
3797946 1957255 1957255 defendant Causton or Canston Thomas yeoman 596323 596323 Causton or Canston, Thomas, of Cromer, yeoman 2
3797947 1957255 1957255 defendant Smyth John shoemaker 596323 596323 Smyth, John, of Cromer, shoemaker 3
3800665 1958120 1958120 defendant Halys William mercer 596323 596323 Halys, William, of Cromer, mercer 4
3800899 1958190 1958190 defendant Glover Thomas yeoman 596323 596323 Glover, Thomas, of Cromer, yeoman 0
3805824 1959762 1959762 defendant Glover Robert barber 596323 596323 Glover, Robert, of Cromer, barber 0
3807433 1960229 1960229 defendant Blomefeld John   596323 596323 Blomefeld, John, of Cromer, hook maker 1
3807438 1960230 1960230 defendant Blomefeld John   596323 596323 Blomefeld, John, of Cromer, hook maker 1
3826202 1966041 1966041 plaintiff Arnold William   596323 596323 Arnold, William, of Cromer 0
3826204 1966041 1966041 defendant Mannyngham John mercer 596323 596323 Mannyngham, John, of Cromer, mercer 1
3833281 1968336 1968336 defendant Estwyk William husbandman 596323 596323 Estwyk, William, of Cromer, husbandman 1
3834873 1968847 1968847 defendant Pope John   596323 596323 Pope, John, of Cromer, worsted weaver 3
3834878 1968848 1968848 defendant Pope John   596323 596323 Pope, John, of Cromer, worsted weaver 2
3835292 1968978 1968978 defendant Hixston John mariner 596323 596323 Hixston, John, of Cromer, mariner 3
3849367 1973400 1973400 defendant Halys William merchant 596323 596323 Halys, William, of Cromer, merchant 1
3851783 1974147 1974147 defendant Warde John husbandman 596323 596323 Warde, John, of Cromer, husbandman 0
3859763 1976766 1976766 plaintiff Colbek William cordwainer 596323 596323 Colbek, William, of Cromer, cordwainer 0
3861580 1977333 1977333 defendant Robyns Thomas gent 596323 596323 Robyns, Thomas, of Cromer, gent 1
3864269 1978242 1978242 defendant Haylys Henry mercer 596323 596323 Haylys, Henry, of Cromer, mercer 0
3873096 1981218 1981218 defendant Hawe James gent 596323 596323 Hawe, James, of Cromer, gent 0
3873098 1981219 1981219 defendant Hawe James gent 596323 596323 Hawe, James, of Cromer, gent 0
3874925 1981838 1981838 defendant Mannyngham John husbandman 596323 596323 Mannyngham, John, of Cromer, husbandman 2
3876954 1982532 1982532 plaintiff Hawe James gent 596323 596323 Hawe, James, of Cromer, gent 0
3879474 1983387 1983387 defendant Archer Clement mariner 596323 596323 Archer, Clement, of Cromer, mariner 0
3879475 1983387 1983387 defendant Newman Nicholas mariner 596323 596323 Newman, Nicholas, of Cromer, mariner 1
3879476 1983387 1983387 defendant Odams alias Rowland William (legal representative) 596323 596323 Odams alias Rowland, William,of Cromer, smith, administratrix of 2
3879477 1983387 1983387 defendant Odams alias Rowland Katherine widow 596323 596323 Odams alias Rowland, Katherine, of Cromer, widow 3
3884031 1984928 1984928 defendant Arnold William gent 596323 596323 Arnold, William, of Cromer, gent 1
3884652 1985139 1985139 defendant Anabyll Thomas baker 596323 596323 Anabyll, Thomas, of Cromer, baker 0
3896235 1988950 1988950 plaintiff Tolle Robert   596323 596323 Tolle, Robert, of Cromer 0
3896238 1988950 1988950 defendant Glover Robert mariner 596323 596323 Glover, Robert, of Cromer, mariner 2
3896240 1988950 1988950 defendant Hylders Richard mariner 596323 596323 Hylders, Richard, of Cromer, mariner 4
3898002 1989537 1989537 defendant Bretyngham James husbandman 596323 596323 Bretyngham, James, of Cromer, husbandman 0
3898004 1989538 1989538 defendant Bretyngham James husbandman 596323 596323 Bretyngham, James, of Cromer, husbandman 0
3898219 1989612 1989612 defendant Comfort John mariner 596323 596323 Comfort, John, of Cromer, mariner 0
3899551 1990065 1990065 defendant Comyng William mariner 596323 596323 Comyng, William, of Cromer, mariner 1
3899948 1990201 1990201 defendant Clerke Henry mariner 596323 596323 Clerke, Henry, of Cromer, mariner 1
3899950 1990201 1990201 defendant Blomfeld John barber 596323 596323 Blomfeld, John, of Cromer, barber 3
3908299 1993072 1993072 defendant Tompson Ralph shoemaker 596323 596323 Tompson, Ralph, of Cromer, shoemaker 2
3910424 1993802 1993802 defendant Hilders Richard mariner 596323 596323 Hilders, Richard, of Cromer, mariner 0
3917979 1996380 1996380 defendant Thompson Mathew shoemaker 596323 596323 Thompson, Mathew, of Cromer, shoemaker 0
3917982 1996381 1996381 defendant Thompson Mathew shoemaker 596323 596323 Thompson, Mathew, of Cromer, shoemaker 0
3918244 1996435 1996435 plaintiff Hill Anthony   596323 596323 Hill, Anthony, of Cromer 0
3919476 1996846 1996846 defendant Blomfeld John   596323 596323 Blomfeld, John, of Cromer, hook maker 1
3919477 1996846 1996846 defendant Bradfeld John mercer 596323 596323 Bradfeld, John, of Cromer, mercer 2
3919480 1996847 1996847 defendant Blomfeld John   596323 596323 Blomfeld, John, of Cromer, hook maker 1
3919481 1996847 1996847 defendant Bradfeld John mercer 596323 596323 Bradfeld, John, of Cromer, mercer 2
3941109 2004029 2004029 defendant Stubberd William   596323 596323 Stubberd, William, of Cromer, horse corser 0
3958186 2009935 2009935 defendant Bakon Henry mariner 596323 596323 Bakon, Henry, of Cromer, mariner 2
3958893 2010194 2010194 defendant Bresse Robert chapman 596323 596323 Bresse, Robert, of Cromer, chapman 0
3960458 2010756 2010756 defendant Bacon Henry merchant 596323 596323 Bacon, Henry, of Cromer, merchant 0
3960460 2010757 2010757 defendant Pratter William mariner 596323 596323 Pratter, William, of Cromer, mariner 0
3965050 2012380 2012380 defendant Arnolde William gent 596323 596323 Arnolde, William, of Cromer, gent 0
3965067 2012386 2012386 defendant Arnolde William gent 596323 596323 Arnolde, William, of Cromer, gent 0
3967069 2013109 2013109 defendant Vynycer Robert mariner 596323 596323 Vynycer, Robert, of Cromer, mariner 0
3969622 2013982 2013982 plaintiff Cowell George   596323 596323 Cowell, George, of Cromer 0
3984252 2019133 2019133 defendant Stoneham William husbandman 596323 596323 Stoneham, William, of Cromer, husbandman 2
3987216 2020174 2020174 plaintiff Wylde Walter   596323 596323 Wylde, Walter, of Cromer, shipwright 0
3987218 2020175 2020175 plaintiff Wylde Walter   596323 596323 Wylde, Walter, of Cromer, shipwright 0
3994425 2022760 2022760 defendant Comforte William husbandman 596323 596323 Comforte, William, of Cromer, husbandman 2
4006318 2027038 2027038 defendant Arnold Richard gent 596323 596323 Arnold, Richard, of Cromer, or of Davyes Inn, Middx, gent 0
4018642 2031400 2031400 defendant Arnold Richard gent 596323 596323 Arnold, Richard, of Cromer, gent 2
4026348 2034067 2034067 defendant Curteys Thomas mariner 596323 596323 Curteys, Thomas, of Cromer, mariner 6
4026349 2034067 2034067 defendant Fyssherman Clement tailor 596323 596323 Fyssherman, Clement, of Cromer, tailor 7
4026351 2034068 2034068 defendant Bacon William yeoman 596323 596323 Bacon, William, of Cromer, yeoman 0
4026982 2034302 2034302 defendant Arnold William gent 596323 596323 Arnold, William, of Cromer, gent 1
4026987 2034303 2034303 defendant Arnolde William gent 596323 596323 Arnolde, William, of Cromer, gent 1
4043339 2040085 2040085 defendant Fyssherman Clement tailor 596323 596323 Fyssherman, Clement, of Cromer, tailor 3
4055281 2044287 2044287 defendant Barnabye John husbandman 596323 596323 Barnabye, John, of Cromer, husbandman 2
4075259 2051455 2051455 defendant Arnold Richard gent 596323 596323 Arnold, Richard, of Cromer, gent 0
4075261 2051456 2051456 defendant Arnold William gent 596323 596323 Arnold, William, of Cromer, gent 0
4076824 2051998 2051998 defendant Payne Richard mariner 596323 596323 Payne, Richard, of Cromer, mariner 2
4079128 2052836 2052836 defendant Allen Thomas gent 596323 596323 (Allen, Thomas, of Cromer, gent 1
4079679 2053031 2053031 defendant Symycrofte Thomas husbandman 596323 596323 Symycrofte, Thomas, of Cromer, husbandman 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);