names

157 rows where place_id = 588148

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593518 1865606 1865606 defendant Haydon Edward mercer 588148 588148 Haydon, Edward, of Watford, Herts, mercer 0
3598934 1867295 1867295 defendant Starkey John gent 588148 588148 (Starkey, John, of Watford, Herts, gent 1
3600233 1867720 1867720 defendant Brodbent William innholder 588148 588148 Brodbent, William, of Watford, Herts, innholder 2
3603082 1868630 1868630 defendant Haydon William gent 588148 588148 Haydon, William, of Watford, Herts, gent 0
3603088 1868631 1868631 defendant Hyll Roger husbandman 588148 588148 Hyll, Roger, of Watford, Herts, husbandman 3
3609492 1870631 1870631 defendant Haydon William gent 588148 588148 Haydon, William, of Watford, Herts, gent 0
3614335 1872138 1872138 defendant Carter Richard glover 588148 588148 Carter, Richard, of Watford, Herts, glover 1
3614602 1872216 1872216 defendant Starke John yeoman 588148 588148 Starke, John, of Watford, Herts, yeoman 0
3614644 1872231 1872231 defendant Dereker Richard miller 588148 588148 Dereker, Richard, of Watford, Herts, miller 0
3614811 1872286 1872286 defendant Heydon William gent 588148 588148 Heydon, William, of Watford, Herts, gent 0
3615788 1872579 1872579 defendant Starky Peter yeoman 588148 588148 Starky, Peter, of Watford, Herts, yeoman 1
3628305 1903715 1903715 defendant Johnson William clothier 588148 588148 Johnson, William, of Watford, Herts, clothier 3
3679095 1919528 1919528 defendant Hunt John miller 588148 588148 Hunt, John, of Watford, Herts, miller 2
3692468 1923826 1923826 defendant Johnson William dyer 588148 588148 Johnson, William, of Watford, Herts, dyer 1
3708920 1929081 1929081 defendant Browne John yeoman 588148 588148 Browne, John, of Watford, Herts, yeoman 1
3723552 1933638 1933638 defendant Gelly John gent 588148 588148 Gelly, John, of Watford, Herts, gent 0
3786152 1953461 1953461 defendant Waren John yeoman 588148 588148 Waren, John, of Watford, Herts, yeoman 1
3820587 1964324 1964324 defendant Bedell William gent 588148 588148 Bedell, William, of Watford, Herts, gent 0
3860749 1977087 1977087 defendant Brown John fuller 588148 588148 Brown, John, of Watford, Herts, fuller 0
3878834 1983173 1983173 defendant Kene William gent 588148 588148 Kene, William, of Watford, Herts, gent 0
3880188 1983627 1983627 defendant Sare John, senior miller 588148 588148 Sare, John, senior, of Watford, Herts, miller 0
3900978 1990556 1990556 defendant Dutton Thomas weaver 588148 588148 Dutton, Thomas, of Watford, Herts, weaver 0
3904494 1991750 1991750 defendant Heydon Henry gent 588148 588148 Heydon, Henry, of Watford, Herts, gent 0
3916828 1995993 1995993 defendant Dance William esq 588148 588148 Dance, William, of Watford, Herts, esq 0
3941901 2004303 2004303 defendant More Thomas (legal representative) 588148 588148 More, Thomas, of Watford, Herts, executrix of 0
3949773 2006998 2006998 defendant Wayne Richard yeoman 588148 588148 Wayne, Richard, of Watford, Herts, yeoman 2
3949778 2006999 2006999 defendant Wayne Richard yeoman 588148 588148 Wayne, Richard, of Watford, Herts, yeoman 2
3952133 2007818 2007818 defendant Wenman Henry gent 588148 588148 Wenman, Henry, of Watford, Herts, gent 0
3957478 2009679 2009679 defendant Foster Robert yeoman 588148 588148 Foster, Robert, of Watford, Herts, yeoman 0
3957481 2009680 2009680 defendant Foster Robert yeoman 588148 588148 Foster, Robert, of Watford, Herts, yeoman 0
3972113 2014807 2014807 defendant Gillam Henry yeoman 588148 588148 Gillam, Henry, of Watford, Herts, yeoman 0
3972115 2014808 2014808 defendant Warren William yeoman 588148 588148 Warren, William, of Watford, Herts, yeoman 0
3987749 2020367 2020367 defendant Byrche Richard yeoman 588148 588148 Byrche, Richard, of Watford, Herts, yeoman 0
3995812 2023251 2023251 defendant Paver James gent 588148 588148 Paver, James, of Watford, Herts, gent 1
3998489 2024197 2024197 defendant Fynche William yeoman 588148 588148 Fynche, William, of Watford, Herts, yeoman 0
4002927 2025816 2025816 defendant Dell Henry husbandman 588148 588148 Dell, Henry, of Watford, Herts, husbandman 0
4002929 2025817 2025817 defendant Dell Henry husbandman 588148 588148 Dell, Henry, of Watford, Herts, husbandman 0
4023012 2032950 2032950 plaintiff Baldwyn John (legal representative) 588148 588148 Baldwyn, John, of Watford, Herts, yeoman, executors of 0
4023015 2032951 2032951 plaintiff Baldwyn John (legal representative) 588148 588148 Baldwyn, John, of Watford, Herts, yeoman, executors of 0
4038644 2038459 2038459 defendant Cuppage or Cuppaye Richard gent 588148 588148 (Cuppage or Cuppaye, Richard, of Watford, Herts, gent 1
4062455 2046862 2046862 defendant Longe Alexander yeoman 588148 588148 Longe, Alexander, of Watford, Herts, yeoman 2
4065456 2047935 2047935 plaintiff Haydon John gent 588148 588148 Haydon, John, of Watford, Herts, gent 1
4121800 2068095 2068095 defendant Borne Walter chapman 588148 588148 Borne, Walter, of Watford, Herts, chapman 2
4178864 2088085 2088085 defendant Carnock Seth gent 588148 588148 Carnock, Seth, of Watford, Herts, gent 0
4216047 2101107 2101107 defendant Stepneth Paul gent 588148 588148 Stepneth, Paul, of Watford, Herts, gent 0
4246993 2111970 2111970 defendant Meade Precilla yeoman 588148 588148 Meade, Precilla, of Watford, Herts, yeoman 1
4251953 2113643 2113643 defendant Stepneth Paul gent 588148 588148 Stepneth, Paul, of Watford, Herts, gent 0
4269881 2119517 2119517 defendant Bateman Robert innholder 588148 588148 Bateman, Robert, of Watford, Herts, innholder 2
4271620 2120091 2120091 defendant Meade Precilla yeoman 588148 588148 Meade, Precilla, of Watford, Herts, yeoman 1
4278350 2122367 2122367 defendant White William husbandman 588148 588148 White, William, of Watford, Herts, husbandman 0
4300076 2130123 2130123 defendant Nightingale David gent 588148 588148 Nightingale, David, of Watford, Herts, or of Kingston on Thames, Surrey, gent 0
4308921 2133272 2133272 defendant Balden Simon yeoman 588148 588148 Balden, Simon, of Watford, Herts, yeoman 0
4324217 2138501 2138501 defendant Heydon John chapman 588148 588148 Heydon, John, of Watford, Herts, chapman 1
4335452 2142128 2142128 defendant Hawtry Richard husbandman 588148 588148 Hawtry, Richard, of Watford, Herts, husbandman 1
4340009 2143772 2143772 defendant Alexander Michael   588148 588148 Alexander, Michael, of Watford, Herts, surgeon 0
4345458 2145683 2145683 defendant Longe William chapman 588148 588148 Longe, William, of Watford, Herts, chapman 1
4345512 2145700 2145700 defendant Bratherton William butcher 588148 588148 Bratherton, William, of Watford, Herts, butcher 0
4676680 2258324 2258324 defendant Cheyn John husbandman 588148 588148 Cheyn, John, of Watford, Herts, husbandman 0
4701930 2266009 2266009 defendant Cheyn John husbandman 588148 588148 Cheyn, John, of Watford, Herts, husbandman 0
4724183 2272857 2272857 defendant Olyve Thomas butcher 588148 588148 Olyve, Thomas, of Watford, Herts, butcher 0
4747529 2279782 2279782 defendant Curteys William (legal representative) 588148 588148 Curteys, William, of Watford, Herts, esq, executrix of 3
4843443 2309466 2309466 defendant Croweche Thomas   588148 588148 Croweche, Thomas, of Watford, Herts, meal man 0
4872935 2318489 2318489 defendant Cressall William ostler 588148 588148 Cressall, William, of Watford, Herts, ostler 2
4882000 2321270 2321270 defendant Cressall William ostler 588148 588148 Cressall, William, of Watford, Herts, ostler 0
4882006 2321271 2321271 defendant Cressall William ostler 588148 588148 Cressall, William, of Watford, Herts, ostler 0
4889168 2323399 2323399 defendant Purdon Peter tanner 588148 588148 Purdon, Peter, of Watford, Herts, tanner 0
4906145 2328512 2328512 defendant Holtyng John husbandman 588148 588148 Holtyng, John, of Watford, Herts, husbandman 1
4910700 2329855 2329855 defendant Parmenter Nicholas milner 588148 588148 Parmenter, Nicholas, of Watford, Herts, milner 0
4914027 2330897 2330897 defendant Grandon Thomas husbandman 588148 588148 Grandon, Thomas, of Watford, Herts, husbandman 0
4914912 2331173 2331173 defendant Lynby Henry gent 588148 588148 Lynby, Henry, of Watford, Herts, gent 1
4941691 2339422 2339422 defendant Troutebek John esq 588148 588148 Troutebek, John, of Watford, Herts, esq 1
4992914 2354761 2354761 defendant Olyve John tanner 588148 588148 Olyve, John, of Watford, Herts, tanner 1
4993077 2354813 2354813 defendant Watersall William tanner 588148 588148 Watersall, William, of Watford, Herts, tanner 3
5002195 2357547 2357547 defendant Kytter Roger husbandman 588148 588148 Kytter, Roger, of Watford, Herts, husbandman 0
5002217 2357553 2357553 defendant Kytter Roger husbandman 588148 588148 Kytter, Roger, of Watford, Herts, husbandman 0
5003722 2357981 2357981 defendant Trom Ralph husbandman 588148 588148 Trom, Ralph, of Watford, Herts, husbandman 0
5003726 2357981 2357981 defendant Bocher John butcher 588148 588148 Bocher, John, of Watford, Herts, butcher 4
5006473 2358790 2358790 defendant Cheyne John yeoman 588148 588148 Cheyne, John, of Watford, Herts, yeoman 1
5028355 2365176 2365176 defendant Reynold John skinner 588148 588148 Reynold, John, of Watford, Herts, skinner 1
5028360 2365177 2365177 defendant Reynold John skinner 588148 588148 Reynold, John, of Watford, Herts, skinner 1
5031674 2366128 2366128 defendant Kennesley John butcher 588148 588148 Kennesley, John, of Watford, Herts, butcher 0
5043229 2369595 2369595 defendant Crishale William yeoman 588148 588148 Crishale, William, of Watford, Herts, yeoman 3
5043394 2369647 2369647 defendant Waterfall William tanner 588148 588148 Waterfall, William, of Watford, Herts, tanner 0
5076692 2379527 2379527 defendant Clyve John tanner 588148 588148 Clyve, John, of Watford, Herts, tanner 0
5076694 2379528 2379528 defendant Clyve John tanner 588148 588148 Clyve, John, of Watford, Herts, tanner 0
5087359 2382685 2382685 defendant Davy William tanner 588148 588148 Davy, William, of Watford, Herts, tanner 0
5088507 2383015 2383015 defendant Pavor or Pavoy Richard gent 588148 588148 Pavor or Pavoy, Richard, of Watford, Herts, gent 0
5088510 2383016 2383016 defendant Pavor Richard gent 588148 588148 Pavor, Richard, of Watford, Herts, gent 0
5103768 2387524 2387524 plaintiff Browne John mealman 588148 588148 Browne, John, of Watford, Herts, mealman 0
5103770 2387525 2387525 plaintiff Browne John mealman 588148 588148 Browne, John, of Watford, Herts, mealman 0
5104737 2387824 2387824 defendant Waterwall William barker 588148 588148 Waterwall, William,of Watford, Herts, barker 0
5105529 2388064 2388064 defendant Reynold John skinner 588148 588148 Reynold, John,of Watford, Herts, skinner 0
5106847 2388430 2388430 defendant Meleman John, senior husbandman 588148 588148 Meleman, John, senior, of Watford, Herts, husbandman 0
5108614 2388953 2388953 defendant Halygode John   588148 588148 Halygode, John, of Watford, Herts, servant 0
5116011 2391110 2391110 defendant Clyff or Olyff John tanner 588148 588148 Clyff or Olyff, John, of Watford, Herts, tanner 0
5118281 2391781 2391781 defendant Landrok John yeoman 588148 588148 Landrok, John, of Watford, Herts, yeoman 1
5118285 2391782 2391782 defendant Laverok Robert yeoman 588148 588148 Laverok, Robert, of Watford, Herts, yeoman 1
5142662 2398980 2398980 defendant Grendon Thomas husbandman 588148 588148 Grendon, Thomas, of Watford, Herts,husbandman 0
5146874 2400225 2400225 defendant Waterwell William baker 588148 588148 Waterwell, William, of Watford, Herts, baker 0
5152255 2401790 2401790 defendant Mappulton Roger   588148 588148 Mappulton, Roger, of Watford, Herts, mason 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);