names

468 rows where place_id = 604018

✎ 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
3654378 1911631 1911631 defendant Lough Ambrose   604018 604018 Lough, Ambrose, of Colchester, Essex, cloth maker 0
3654381 1911632 1911632 defendant Lough Ambrose   604018 604018 Lough, Ambrose, of Colchester, Essex, cloth maker 0
3656581 1912313 1912313 defendant Bettys John pewterer 604018 604018 Bettys, John, of Colchester, Essex, pewterer 2
3657648 1912651 1912651 defendant Rokewode Robert yeoman 604018 604018 Rokewode, Robert, of Colchester, Essex, yeoman 3
3657933 1912732 1912732 defendant Richold Richard clothman 604018 604018 Richold, Richard, of Colchester, Essex, clothman 0
3658174 1912812 1912812 defendant Patche John smith 604018 604018 Patche, John, of Colchester, Essex, smith 1
3659261 1913152 1913152 defendant Speryn John upholster 604018 604018 (Speryn, John, of Colchester, Essex, upholster 1
3659446 1913214 1913214 defendant Spysall Robert yeoman 604018 604018 Spysall, Robert, of Colchester, Essex, yeoman 0
3660419 1913517 1913517 defendant Dyster Simons yeoman 604018 604018 Dyster, Simons, of Colchester, Essex, yeoman 0
3664938 1914978 1914978 defendant Johnson Thomas   604018 604018 Johnson, Thomas, of Colchester, Essex, cork maker 0
3664943 1914980 1914980 defendant Johnson Thomas   604018 604018 Johnson, Thomas, of Colchester, Essex, cork maker 0
3825200 1965747 1965747 defendant Audley Thomas esq 604018 604018 Audley, Thomas, of Colchester, Essex, esq 0
3927078 1999395 1999395 plaintiff Abell William yeoman 604018 604018 Abell, William, of Colchester, Essex, yeoman 0
3927084 1999396 1999396 plaintiff Abell William yeoman 604018 604018 Abell, William, of Colchester, Essex, yeoman 0
3927262 1999454 1999454 defendant Denes Robert clothier 604018 604018 Denes, Robert, of Colchester, Essex, clothier 0
3927701 1999602 1999602 plaintiff Baker Robert yeoman 604018 604018 Baker, Robert, of Colchester, Essex, yeoman 0
3927768 1999626 1999626 defendant Clerke Benedict clothier & Alderman 604018 604018 Clerke, Benedict, of Colchester, Essex, clothier & Alderman 0
3927770 1999627 1999627 defendant Plumpton George yeoman 604018 604018 Plumpton, George, of Colchester, Essex, yeoman 0
3928283 1999795 1999795 defendant Harvy alias Harty John gent 604018 604018 Harvy alias Harty, John, of Colchester, Essex, gent 0
3933966 2001662 2001662 defendant Sympson Alan   604018 604018 Sympson, Alan, of Colchester, Essex 0
3934928 2001986 2001986 defendant Balborowe Jerome gent 604018 604018 Balborowe, Jerome, of Colchester, Essex, gent 0
3935074 2002038 2002038 defendant Paynter John clothier 604018 604018 Paynter, John, of Colchester, Essex, clothier 1
3936658 2002587 2002587 defendant Danyell William yeoman 604018 604018 Danyell, William, of Colchester, Essex, yeoman 2
3936917 2002680 2002680 defendant Gylberd Jerome gent 604018 604018 Gylberd, Jerome, of Colchester, Essex, gent 0
3937279 2002802 2002802 defendant Beckett William clothier 604018 604018 Beckett, William, of Colchester, Essex, clothier 0
3939567 2003536 2003536 defendant Harvy John gent 604018 604018 Harvy, John, of Colchester, Essex, gent 1
3940579 2003858 2003858 defendant Cole Edward merchant 604018 604018 Cole, Edward, of Colchester, Essex, merchant 0
3941619 2004210 2004210 defendant Nuthake Thomas, junior clothier 604018 604018 Nuthake, Thomas, junior, of Colchester, Essex, clothier 0
4067268 2048592 2048592 defendant Webbe Edward yeoman 604018 604018 Webbe, Edward, of Colchester, Essex, yeoman 0
4092607 2057664 2057664 defendant Webbe Edward tailor 604018 604018 Webbe, Edward, of Colchester, Essex, tailor 0
4277222 2121966 2121966 defendant Jolly Robert carrier 604018 604018 Jolly, Robert, of Colchester, Essex, carrier 0
4366029 2152889 2152889 defendant Bowler Richard bellfounder 604018 604018 (Bowler, Richard, of Colchester, Essex, bellfounder 1
4437958 2181191 2181191 defendant Deyns John dyer 604018 604018 Deyns, John, of Colchester, Essex, dyer 3
4437966 2181192 2181192 defendant Deyne John dyer 604018 604018 Deyne, John, of Colchester, Essex, dyer 3
4506854 2202613 2202613 defendant Hereward John goldsmith 604018 604018 Hereward, John, of Colchester, Essex, goldsmith 0
4506857 2202614 2202614 defendant Hereward John goldsmith 604018 604018 Hereward, John, of Colchester, Essex, goldsmith 0
4527945 2209018 2209018 defendant Dalanyr Godfrey   604018 604018 Dalanyr, Godfrey, of Colchester, Essex 3
4527979 2209031 2209031 defendant Godeston Thomas esq 604018 604018 Godeston, Thomas, of Colchester, Essex, esq 0
4569712 2222111 2222111 defendant Coford William   604018 604018 Coford, William, of Colchester, Essex 0
4620935 2237530 2237530 plaintiff Kentyssh alias Porter Thomas draper 604018 604018 Kentyssh alias Porter, Thomas, of Colchester, Essex, draper 0
4628390 2239805 2239805 defendant Broun Thomas   604018 604018 Broun, Thomas, of Colchester, Essex 1
4672170 2256942 2256942 defendant Bethe John gent 604018 604018 Bethe, John, of Colchester, Essex, gent 0
4678050 2258744 2258744 defendant Smyth Geoffrey smith 604018 604018 Smyth, Geoffrey, of Colchester, Essex, smith 0
4679765 2259286 2259286 defendant Dawys John husbandman 604018 604018 Dawys, John, of Colchester, Essex, husbandman 2
4679993 2259344 2259344 defendant Bryd Richard mercer 604018 604018 Bryd, Richard, of Colchester, Essex, mercer 3
4688089 2261844 2261844 defendant Petirburgh Richard butcher 604018 604018 Petirburgh, Richard, of Colchester, Essex, butcher 3
4689198 2262180 2262180 defendant Saney John husbandman 604018 604018 Saney, John, of Colchester, Essex, husbandman 0
4695943 2264217 2264217 defendant Lely Roger merchant 604018 604018 Lely, Roger, of Colchester, Essex, merchant 0
4697068 2264563 2264563 defendant Beche John gent 604018 604018 Beche, John, of Colchester, Essex, gent 0
4697211 2264607 2264607 defendant Gyllyot William draper 604018 604018 Gyllyot, William, of Colchester, Essex, draper 0
4715112 2270052 2270052 defendant Wynton Thomas merchant 604018 604018 Wynton, Thomas, of Colchester, Essex, merchant 0
4717452 2270796 2270796 defendant Stokes Thomas esq 604018 604018 Stokes, Thomas, of Colchester, Essex, esq 1
4718032 2270979 2270979 defendant Woderove Philip brewer 604018 604018 Woderove, Philip, of Colchester, Essex, brewer 0
4720621 2271782 2271782 defendant Brandon John grocer 604018 604018 Brandon, John, of Colchester, Essex, grocer 0
4720625 2271783 2271783 defendant Brandon John grocer 604018 604018 Brandon, John, of Colchester, Essex, grocer 0
4722944 2272490 2272490 defendant Wilmot John   604018 604018 Wilmot, John, of Colchester, Essex 3
4723121 2272542 2272542 defendant Bosse Henry husbandman 604018 604018 Bosse, Henry, of Colchester, Essex, husbandman 0
4723127 2272544 2272544 defendant Bosse Henry husbandman 604018 604018 Bosse, Henry, of Colchester, Essex, husbandman 0
4724618 2272999 2272999 defendant Wysman John chandler 604018 604018 Wysman, John, of Colchester, Essex, chandler 1
4725471 2273257 2273257 defendant Archer Thomas skinner 604018 604018 Archer, Thomas, of Colchester, Essex, skinner 2
4726836 2273662 2273662 defendant Kypax Richard chaplain 604018 604018 Kypax, Richard, of Colchester, Essex, chaplain 2
4728250 2274080 2274080 defendant Reynold John   604018 604018 Reynold, John, of Colchester, Essex, brass worker 0
4734254 2275889 2275889 defendant Clerk Simon fuller 604018 604018 Clerk, Simon, of Colchester, Essex, fuller 1
4734484 2275951 2275951 defendant Bosse Thomas grocer 604018 604018 Bosse, Thomas, of Colchester, Essex, merchant, formerly of London, grocer 0
4736080 2276425 2276425 defendant Pykarde William chapman 604018 604018 Pykarde, William, of Colchester, Essex, chapman 0
4736523 2276552 2276552 defendant Grey John husbandman 604018 604018 Grey, John, of Colchester, Essex, husbandman 0
4738661 2277181 2277181 defendant Abraham John husbandman 604018 604018 Abraham, John, of Colchester, Essex, husbandman 0
4740326 2277681 2277681 defendant Kent Gilbert dyer 604018 604018 Kent, Gilbert, of Colchester, Essex, dyer 0
4741163 2277919 2277919 defendant Porter Thomas milner 604018 604018 Porter, Thomas, of Colchester, Essex, milner 2
4741206 2277925 2277925 defendant Porter Thomas milner 604018 604018 Porter, Thomas, of Colchester, Essex, milner 2
4744699 2278967 2278967 defendant Hegge Thomas chapman 604018 604018 Hegge, Thomas, of Colchester, Essex, chapman 3
4745181 2279096 2279096 defendant Wryght John clerk 604018 604018 Wryght, John, of Colchester, Essex, clerk 0
4750976 2280768 2280768 defendant Hoberd William, senior husbandman 604018 604018 Hoberd, William, senior, of Colchester, Essex, husbandman 0
4750977 2280768 2280768 defendant Hoberd William, junior fuller 604018 604018 Hoberd, William, junior, of Colchester, Essex, fuller 1
4750995 2280772 2280772 defendant Hoberd William, senior husbandman 604018 604018 Hoberd, William, senior, of Colchester, Essex, husbandman 0
4751221 2280834 2280834 defendant Craton John chapman 604018 604018 Craton, John, of Colchester, Essex, chapman 0
4752919 2281307 2281307 defendant Gosse John merer 604018 604018 Gosse, John, of Colchester, Essex, merer 0
4754915 2281917 2281917 defendant Cheyne Robert   604018 604018 Cheyne, Robert, of Colchester, Essex, wool man 0
4755192 2282011 2282011 defendant Segrave John   604018 604018 Segrave, John, of Colchester, Essex, wool man 1
4755726 2282175 2282175 defendant Spencer John pewterer 604018 604018 Spencer, John, of Colchester, Essex, pewterer 1
4758938 2283150 2283150 defendant Bocher William butcher 604018 604018 Bocher, William, of Colchester, Essex, butcher 0
4760155 2283523 2283523 defendant Packe Peter fuller 604018 604018 Packe, Peter, of Colchester, Essex, fuller 0
4760156 2283523 2283523 defendant Rodland William fuller 604018 604018 Rodland, William, of Colchester, Essex, fuller 1
4762370 2284212 2284212 defendant Swanton John yeoman 604018 604018 Swanton, John, of Colchester, Essex, yeoman 2
4765801 2285304 2285304 defendant Kent Gilbert dyer 604018 604018 Kent, Gilbert, of Colchester, Essex, dyer 0
4767364 2285781 2285781 defendant Cheyne Robert   604018 604018 Cheyne, Robert, of Colchester, Essex, wool man 0
4802406 2296944 2296944 defendant Werkwode John   604018 604018 Werkwode, John, of Colchester, Essex, wood man or woad man 0
4804839 2297714 2297714 defendant Smyth Thomas sheerman 604018 604018 Smyth, Thomas, of Colchester, Essex, sheerman 1
4806260 2298166 2298166 defendant Bocher William butcher 604018 604018 Bocher, William, of Colchester, Essex, butcher 1
4806268 2298167 2298167 defendant Bocher William butcher 604018 604018 Bocher, William, of Colchester, Essex, butcher 1
4810143 2299324 2299324 defendant Bryttevyle John gent 604018 604018 Bryttevyle, John, of Colchester, Essex, gent 2
4812203 2299931 2299931 defendant Hayll Richard dyer 604018 604018 Hayll, Richard, of Colchester, Essex, dyer 0
4812556 2300043 2300043 defendant Carter John chapman 604018 604018 Carter, John, of Colchester, Essex, formerly of Lavenham, Suff, chapman 2
4814336 2300591 2300591 defendant Bosse Thomas merchant 604018 604018 Bosse, Thomas, of Colchester, Essex, merchant 0
4816658 2301305 2301305 defendant Benyrth William dyer 604018 604018 Benyrth, William, of Colchester, Essex, dyer 0
4816661 2301306 2301306 defendant Benyrth William weaver 604018 604018 Benyrth, William, of Colchester, Essex, weaver 0
4821717 2302865 2302865 defendant Reynold John   604018 604018 Reynold, John, of Colchester, Essex, brass worker 4
4824055 2303599 2303599 defendant Rust Adam smith 604018 604018 Rust, Adam, of Colchester, Essex, smith 0
4826972 2304476 2304476 defendant Norton Robert chapman 604018 604018 Norton, Robert, of Colchester, Essex, chapman 2
4831562 2305905 2305905 defendant Merssh Thomas merchant 604018 604018 Merssh, Thomas, of Colchester, Essex, merchant 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);