names

2,497 rows where place_id = 586470

✎ 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
3588805 1864145 1864145 defendant Bawede John dyer 586470 586470 Bawede, John, of Colchester, dyer 0
3590211 1864580 1864580 defendant Vertu or Verton John, junior (legal representative) 586470 586470 Vertu or Verton, John, junior, of Colchester, clothmaker, executors of 1
3590212 1864580 1864580 defendant Cristemasse Thomas clothmaker 586470 586470 (Cristemasse, Thomas, of Colchester, clothmaker 2
3590213 1864580 1864580 defendant Breton John gent 586470 586470 Breton, John, of Colchester, gent 3
3591335 1864917 1864917 defendant Lalleford Thomas yeoman 586470 586470 Lalleford, Thomas, of Colchester, yeoman 0
3591451 1864953 1864953 defendant Honyngton Edmund gent 586470 586470 Honyngton, Edmund, of Colchester, gent 0
3591455 1864954 1864954 defendant Honyngton Edmund gent 586470 586470 Honyngton, Edmund, of Colchester, gent 0
3592024 1865119 1865119 defendant Straton alias Craton John (legal representative) 586470 586470 Straton alias Craton, John, of Colchester, dyer, administratrix of 4
3592025 1865119 1865119 defendant Straton Margery widow 586470 586470 Straton, Margery, of Colchester, widow 5
3592616 1865306 1865306 defendant Bawede John dyer 586470 586470 Bawede, John, of Colchester, dyer 0
3592620 1865306 1865306 defendant Carter John fishmonger 586470 586470 Carter, John, of Colchester, fishmonger 4
3593491 1865598 1865598 plaintiff Heynes Richard gent 586470 586470 Heynes, Richard, of Colchester, gent 0
3593497 1865599 1865599 plaintiff Heynys Richard gent 586470 586470 Heynys, Richard, of Colchester, gent 0
3594799 1866000 1866000 defendant Bawde John dyer 586470 586470 Bawde, John, of Colchester, dyer 0
3594801 1866001 1866001 defendant Bawde William dyer 586470 586470 Bawde, William, of Colchester, dyer 0
3595147 1866113 1866113 defendant Smyth Thomas clothmaker 586470 586470 Smyth, Thomas, of Colchester, clothmaker 1
3596073 1866400 1866400 defendant Willys Thomas pointer 586470 586470 Willys, Thomas, of Colchester, pointer 0
3601026 1867988 1867988 defendant Beshop John husbandman 586470 586470 Beshop, John, of Colchester, husbandman 0
3601118 1868012 1868012 defendant Ody William mariner 586470 586470 Ody, William, of Colchester, mariner 1
3601929 1868259 1868259 defendant Bacon Richard hosier 586470 586470 Bacon, Richard, of Colchester, hosier 0
3602328 1868391 1868391 defendant Bonde William   586470 586470 Bonde, William, of Colchester, yeoman, bailiff of Wevynhoo, Essex 0
3602815 1868550 1868550 defendant Damyon John mariner 586470 586470 Damyon, John, of Colchester, mariner 0
3603260 1868692 1868692 defendant Barker Robert clothmaker 586470 586470 Barker, Robert, of Colchester, clothmaker 0
3603731 1868837 1868837 defendant Wynkfeld John esq 586470 586470 Wynkfeld, John, of Colchester, esq 0
3603955 1868905 1868905 defendant Slegge Robert clothmaker 586470 586470 Slegge, Robert, of Colchester, clothmaker 2
3603967 1868908 1868908 defendant Slegge Robert   586470 586470 Slegge, Robert, of Colchester, cork maker 2
3603972 1868909 1868909 defendant Slegge Robert   586470 586470 Slegge, Robert, of Colchester, cork maker 2
3603987 1868914 1868914 plaintiff Forde John merchant 586470 586470 Forde, John, of Colchester, merchant 0
3604803 1869168 1869168 defendant atte Vyne John Baker clothman 586470 586470 atte Vyne, John Baker, of Colchester, clothman 0
3605377 1869349 1869349 defendant Reynold John capper 586470 586470 Reynold, John, of Colchester, capper 0
3605378 1869349 1869349 defendant Gouthe Ambrose saddler 586470 586470 Gouthe, Ambrose, of Colchester, saddler 1
3606144 1869590 1869590 defendant Fuller William chapman 586470 586470 Fuller, William, of Colchester, chapman 0
3606854 1869809 1869809 defendant Herde Elizabeth widow 586470 586470 Herde, Elizabeth, of Colchester, widow 3
3606968 1869841 1869841 defendant Pepyr Richard yeoman 586470 586470 Pepyr, Richard, of Colchester, yeoman 0
3607235 1869928 1869928 plaintiff Rede Mathew   586470 586470 Rede, Mathew, of Colchester 1
3609111 1870508 1870508 defendant Bawde John clothmaker 586470 586470 Bawde, John, of Colchester, clothmaker 0
3609115 1870509 1870509 defendant Bawde John clothmaker 586470 586470 Bawde, John, of Colchester, clothmaker 0
3609119 1870510 1870510 defendant Bawde John clothmaker 586470 586470 Bawde, John, of Colchester, clothmaker 0
3610142 1870836 1870836 defendant Smalpece John clothmaker 586470 586470 Smalpece, John, of Colchester, clothmaker 0
3616424 1872771 1872771 defendant Ecton John clothman 586470 586470 Ecton, John, of Colchester, clothman 0
3616426 1872772 1872772 defendant Ecton John clothman 586470 586470 Ecton, John, of Colchester, clothman 0
3616532 1872807 1872807 defendant Gybbys Elias yeoman 586470 586470 Gybbys, Elias, of Colchester, yeoman 0
3617784 1873186 1873186 defendant Barker Robert clothmaker 586470 586470 Barker, Robert, of Colchester, clothmaker 0
3618863 1873511 1873511 defendant Reynold John brewer 586470 586470 Reynold, John, of Colchester, brewer 4
3619616 1873705 1873705 defendant Parke John innholder 586470 586470 Parke, John, of Colchester, innholder 0
3620083 1873856 1873856 defendant Bryche or Byrche John yeoman 586470 586470 Bryche or Byrche, John, of Colchester, yeoman 0
3625468 1875504 1875504 defendant Lamberd John   586470 586470 Lamberd, John, of Colchester, tallow chandler 1
3626761 1903217 1903217 defendant Barlowe Robert mercer 586470 586470 Barlowe, Robert, of Colchester, mercer 0
3628790 1903881 1903881 defendant Hamond Christopher merchant 586470 586470 Hamond, Christopher, of Colchester, merchant 1
3628794 1903882 1903882 defendant Hamond Christopher merchant 586470 586470 Hamond, Christopher, of Colchester, merchant 2
3629213 1904005 1904005 defendant Aylston John sherman 586470 586470 Aylston, John, of Colchester, sherman 0
3629214 1904005 1904005 defendant Rolff Simon (legal representative) 586470 586470 Rolff, Simon, of Colchester, miller, executors of 1
3629292 1904023 1904023 plaintiff Cowbrige Robert (legal representative) 586470 586470 Cowbrige, Robert, of Colchester, clothmaker, executors of 0
3629298 1904024 1904024 plaintiff Cowbrige Robert (legal representative) 586470 586470 Cowbrige, Robert, of Colchester, clothmaker, executors of 0
3630837 1904465 1904465 defendant Rede Mathew sherman 586470 586470 Rede, Mathew, of Colchester, sherman 0
3631434 1904644 1904644 defendant Denham Robert clothmaker 586470 586470 Denham, Robert, of Colchester, clothmaker 0
3636283 1906139 1906139 defendant Sabryght John saddler 586470 586470 Sabryght, John, of Colchester, saddler 1
3640884 1907593 1907593 defendant Pysehale Robert innholder 586470 586470 Pysehale, Robert, of Colchester, innholder 2
3642801 1908196 1908196 defendant Sterlyng John fuller 586470 586470 Sterlyng, John, of Colchester, fuller 1
3642923 1908240 1908240 defendant Humfrey Thomas shoemaker 586470 586470 Humfrey, Thomas, of Colchester, shoemaker 0
3643363 1908352 1908352 plaintiff Crisemas Thomas merchant 586470 586470 Crisemas, Thomas, of Colchester, merchant 0
3643367 1908352 1908352 defendant Darnelowe John (legal representative) 586470 586470 Darnelowe, John, of Colchester, yeoman, administratrix of 3
3643368 1908352 1908352 defendant Darnelowe Margaret widow 586470 586470 Darnelowe, Margaret, of Colchester, widow 4
3643371 1908354 1908354 plaintiff Cristemas Thomas   586470 586470 Cristemas, Thomas, of Colchester 0
3643377 1908355 1908355 plaintiff Cristemas Thomas   586470 586470 Cristemas, Thomas, of Colchester 0
3643379 1908356 1908356 plaintiff Cristmas Thomas merchant 586470 586470 Cristmas, Thomas, of Colchester, merchant 0
3643426 1908370 1908370 defendant Kendale John yeoman 586470 586470 Kendale, John, of Colchester, yeoman 1
3643921 1908530 1908530 defendant Lowth Ambrose chapman 586470 586470 Lowth, Ambrose, of Colchester, chapman 2
3643925 1908531 1908531 defendant Lowth Ambrose chapman 586470 586470 Lowth, Ambrose, of Colchester, chapman 2
3645119 1908879 1908879 defendant Cloveld Margaret   586470 586470 Cloveld, Margaret, of Colchester, widow, formerly Payn, Margaret 1
3645687 1909055 1909055 plaintiff Hamond Christopher merchant of the staple 586470 586470 Hamond, Christopher, of Colchester, merchant of the staple 0
3645843 1909104 1909104 defendant Otewell Thomas yeoman 586470 586470 Otewell, Thomas, of Colchester, yeoman 1
3645845 1909104 1909104 defendant Bardfyld John yeoman 586470 586470 Bardfyld, John, of Colchester, yeoman 3
3646956 1909447 1909447 defendant Wayne John clerk 586470 586470 Wayne, John, of Colchester, clerk 0
3648841 1910026 1910026 plaintiff Pak Richard weaver 586470 586470 Pak, Richard, of Colchester, weaver 0
3649898 1910332 1910332 defendant Crystmas John yeoman 586470 586470 Crystmas, John, of Colchester, yeoman 0
3651708 1910890 1910890 defendant Lowthe Ambrose merchant 586470 586470 Lowthe, Ambrose, of Colchester, merchant 2
3656582 1912313 1912313 defendant Berwyke Giles pewterer 586470 586470 Berwyke, Giles, of Colchester, pewterer 3
3659262 1913152 1913152 defendant Mekyn John   586470 586470 Mekyn, John, of Colchester, apothecary 2
3665035 1915011 1915011 defendant Walle Richard yeoman 586470 586470 Walle, Richard, of Colchester, yeoman 0
3665606 1915193 1915193 plaintiff Stoke John   586470 586470 Stoke, John, of Colchester, Abbot of the Monastery of St John Baptist 0
3668991 1916233 1916233 defendant Dounyng Robert yeoman 586470 586470 Dounyng, Robert, of Colchester, yeoman 0
3672218 1917311 1917311 plaintiff Cristmas John, junior merchant 586470 586470 Cristmas, John, junior, of Colchester, merchant 0
3672506 1917403 1917403 defendant Lake William gent 586470 586470 Lake, William, of Colchester, gent 0
3672698 1917463 1917463 defendant Godfrey James beer brewer 586470 586470 Godfrey, James, of Colchester, beer brewer 3
3674413 1918042 1918042 defendant Wright Robert carrier 586470 586470 Wright, Robert, of Colchester, carrier 0
3674414 1918042 1918042 defendant Stefen Mathew husbandman 586470 586470 Stefen, Mathew, of Colchester, husbandman 1
3675748 1918449 1918449 defendant Frances Robert butcher 586470 586470 Frances, Robert, of Colchester, butcher 0
3677773 1919096 1919096 defendant Salman Thomas clothmaker 586470 586470 Salman, Thomas, of Colchester, clothmaker 2
3678505 1919335 1919335 defendant Rechold Richard clothman 586470 586470 Rechold, Richard, of Colchester, clothman 1
3678992 1919500 1919500 defendant Rychold Richard clothier 586470 586470 Rychold, Richard, of Colchester, clothier 0
3678993 1919500 1919500 defendant Harve Richard clothmaker 586470 586470 Harve, Richard, of Colchester, clothmaker 1
3678994 1919500 1919500 defendant Lond Thomas clothmaker 586470 586470 Lond, Thomas, of Colchester, clothmaker 2
3680044 1919821 1919821 defendant Baker Thomas clothmaker 586470 586470 Baker, Thomas, of Colchester, clothmaker 2
3680048 1919822 1919822 defendant Baker Thomas clothmaker 586470 586470 Baker, Thomas, of Colchester, clothmaker 2
3681194 1920200 1920200 defendant Burton John yeoman 586470 586470 Burton, John, of Colchester, yeoman 3
3681355 1920257 1920257 defendant Breton John draper 586470 586470 Breton, John, of Colchester, draper 2
3682026 1920485 1920485 defendant Smalpese John yeoman 586470 586470 Smalpese, John, of Colchester, yeoman 0
3683516 1920976 1920976 defendant Broke Thomas grocer 586470 586470 Broke, Thomas, of Colchester, grocer 0
3683926 1921106 1921106 defendant Otwell Thomas yeoman 586470 586470 Otwell, Thomas, of Colchester, yeoman 1

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