names

536 rows where place_id = 586059

✎ 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
3587828 1863839 1863839 defendant Wolmer Thomas butcher 586059 586059 Wolmer, Thomas, of Ware, butcher 1
3589104 1864240 1864240 defendant Kellame William smith 586059 586059 Kellame, William, of Ware, smith 0
3589105 1864240 1864240 defendant Beverley William yeoman 586059 586059 Beverley, William, of Ware, yeoman 1
3589106 1864240 1864240 defendant Warmoy William yeoman 586059 586059 Warmoy, William, of Ware, yeoman 2
3589107 1864240 1864240 defendant Rande John yeoman 586059 586059 Rande, John, of Ware, yeoman 3
3591477 1864960 1864960 defendant Stanys Thomas miller 586059 586059 Stanys, Thomas, of Ware, miller 0
3591484 1864963 1864963 defendant Wattys John husbandman 586059 586059 Wattys, John, of Ware, husbandman 0
3598646 1867200 1867200 defendant Wodleff Richard fisher 586059 586059 Wodleff, Richard, of Ware, fisher 1
3598648 1867200 1867200 defendant Basyngborne Thomas husbandman 586059 586059 Basyngborne, Thomas, of Ware, husbandman 3
3599219 1867396 1867396 defendant Bygge John miller 586059 586059 Bygge, John, of Ware, miller 1
3605559 1869406 1869406 defendant Masse William mercer 586059 586059 Masse, William, of Ware, mercer 0
3605562 1869406 1869406 defendant Saunder Alexander butcher 586059 586059 Saunder, Alexander, of Ware, butcher 3
3613650 1871915 1871915 defendant Abdale John yeoman 586059 586059 Abdale, John, of Ware, yeoman 0
3613651 1871915 1871915 defendant Norman William yeoman 586059 586059 Norman, William, of Ware, yeoman 1
3613653 1871916 1871916 defendant Abdorll John yeoman 586059 586059 Abdorll, John, of Ware, yeoman 0
3613654 1871916 1871916 defendant Norman William yeoman 586059 586059 Norman, William, of Ware, yeoman 1
3618860 1873511 1873511 defendant Shurley Thomas barber 586059 586059 Shurley, Thomas, of Ware, barber 1
3622020 1874428 1874428 defendant Nowell John innholder 586059 586059 Nowell, John, of Ware, innholder 0
3629837 1904184 1904184 defendant Yong Thomas innholder 586059 586059 Yong, Thomas, of Ware, innholder 0
3636907 1906335 1906335 defendant Pillye Henry mercer 586059 586059 Pillye, Henry, of Ware, mercer 0
3637420 1906509 1906509 plaintiff Smyth Henry   586059 586059 Smyth, Henry, of Ware 0
3638788 1906951 1906951 defendant Hanford John innholder 586059 586059 Hanford, John, of Ware, innholder 0
3643896 1908522 1908522 defendant Rookes Gilbert gent 586059 586059 Rookes, Gilbert, of Ware, gent 0
3643897 1908522 1908522 defendant Matson Alice widow 586059 586059 Matson, Alice, of Ware, widow 1
3643899 1908522 1908522 defendant Bargayn Nicholas husbandman 586059 586059 Bargayn, Nicholas, of Ware, husbandman 3
3645390 1908966 1908966 defendant Archer John courser 586059 586059 Archer, John, of Ware, courser 2
3650726 1910593 1910593 plaintiff Sherley Richard (legal representative) 586059 586059 Sherley, Richard, of Ware, executors of 0
3650730 1910593 1910593 defendant Kyng Robert husbandman 586059 586059 Kyng, Robert, of Ware, husbandman 2
3653035 1911279 1911279 plaintiff Whyte Thomas cooper 586059 586059 Whyte, Thomas, of Ware, cooper 0
3658006 1912756 1912756 defendant Abbot John butcher 586059 586059 Abbot, John, of Ware, butcher 2
3660352 1913499 1913499 defendant Matson William   586059 586059 Matson, William, of Ware, tallow chandler 0
3663310 1914449 1914449 defendant Galawey Christopher smith 586059 586059 Galawey, Christopher, of Ware, smith 0
3663323 1914452 1914452 defendant Dawnnell Nicholas dyer 586059 586059 Dawnnell, Nicholas, of Ware, dyer 1
3671272 1916989 1916989 defendant Abbot John butcher 586059 586059 Abbot, John, of Ware, butcher 0
3676333 1918641 1918641 defendant Archer Thomas courser 586059 586059 Archer, Thomas, of Ware, courser 0
3677491 1919009 1919009 defendant Shyngylton Robert courser 586059 586059 Shyngylton, Robert, of Ware, courser 1
3679129 1919540 1919540 defendant Stoker Robert maltman 586059 586059 Stoker, Robert, of Ware, maltman 2
3680309 1919918 1919918 defendant Byrsley Roger (legal representative) 586059 586059 Byrsley, Roger, of Ware, executors of 0
3680310 1919918 1919918 defendant Noke William barber 586059 586059 (Noke, William, of Ware, barber 1
3685865 1921738 1921738 defendant Habat John yeoman 586059 586059 Habat, John, of Ware, yeoman 1
3685918 1921753 1921753 plaintiff Beryk John hosteler 586059 586059 Beryk, John, of Ware, hosteler 0
3690984 1923343 1923343 defendant Fowle Thomas shoemaker 586059 586059 Fowle, Thomas, of Ware, shoemaker 0
3700053 1926248 1926248 defendant Holmested John maltman 586059 586059 Holmested, John, of Ware, maltman 4
3702505 1927050 1927050 defendant Kay Ralph innholder 586059 586059 Kay, Ralph, of Ware, innholder 0
3703660 1927425 1927425 defendant Martyn John yeoman 586059 586059 Martyn, John, of Ware, yeoman 0
3714932 1930964 1930964 defendant Shepard Robert cooper 586059 586059 Shepard, Robert, of Ware, cooper 1
3714934 1930965 1930965 defendant Johnson John smith 586059 586059 Johnson, John, of Ware, smith 0
3721005 1932866 1932866 defendant Fawkener alias Cotyse William shoemaker 586059 586059 Fawkener alias Cotyse, William, of Ware, shoemaker 0
3722204 1933204 1933204 plaintiff Marsshe John tanner 586059 586059 Marsshe, John, of Ware, tanner 0
3723321 1933565 1933565 defendant Dunnell Nicholas dyer 586059 586059 Dunnell, Nicholas, of Ware, dyer 1
3723322 1933565 1933565 defendant Platte Thomas smith 586059 586059 Platte, Thomas, of Ware, smith 2
3723323 1933565 1933565 defendant Smyth alias Jonson John smith 586059 586059 Smyth alias Jonson, John, of Ware, smith 3
3724070 1933814 1933814 defendant Matson William (legal representative) 586059 586059 Matson, William, of Ware, tallow chandler, executrix of 0
3724071 1933814 1933814 defendant Matson Margaret widow 586059 586059 Matson, Margaret, of Ware, widow 1
3732081 1936268 1936268 defendant Jukeley or Inkeley James glover 586059 586059 Jukeley or Inkeley, James, of Ware, glover 0
3738076 1938126 1938126 defendant Matson William (legal representative) 586059 586059 Matson, William, of Ware, chandler, executors of 0
3745965 1940645 1940645 defendant Smyth Charles clerk 586059 586059 Smyth, Charles, of Ware, clerk 1
3746817 1940924 1940924 plaintiff Crosse Robert yeoman 586059 586059 Crosse, Robert, of Ware, yeoman 0
3750890 1942201 1942201 defendant Hornemede Thomas innholder 586059 586059 Hornemede, Thomas, of Ware, innholder 0
3756984 1944163 1944163 defendant Abbott John butcher 586059 586059 Abbott, John, of Ware, butcher 0
3757377 1944288 1944288 plaintiff Beryk John hosteler 586059 586059 Beryk, John, of Ware, hosteler 0
3758765 1944729 1944729 defendant Olmested John maltman 586059 586059 Olmested, John, of Ware, maltman 0
3764017 1946389 1946389 defendant Capper Thomas   586059 586059 Capper, Thomas, of Ware, cook 0
3764018 1946389 1946389 defendant Purse Thomas innholder 586059 586059 Purse, Thomas, of Ware, innholder 1
3764473 1946551 1946551 defendant Spencer Henry carpenter 586059 586059 Spencer, Henry, of Ware, carpenter 0
3764474 1946551 1946551 defendant Wylson Robert yeoman 586059 586059 Wylson, Robert, of Ware, yeoman 1
3764715 1946627 1946627 defendant Abdall John draper 586059 586059 Abdall, John, of Ware, draper 2
3765258 1946799 1946799 defendant Sharpe John cordwainer 586059 586059 Sharpe, John, of Ware, cordwainer 0
3765901 1947000 1947000 defendant Hormede Thomas husbandman 586059 586059 Hormede, Thomas, of Ware, husbandman 0
3770743 1948536 1948536 defendant Storer John hosteler 586059 586059 Storer, John, of Ware, hosteler 0
3773931 1949563 1949563 defendant Purse Thomas husbandman 586059 586059 Purse, Thomas, of Ware, husbandman 0
3775352 1950031 1950031 plaintiff Beryk John hosteler 586059 586059 Beryk, John, of Ware, hosteler 0
3775999 1950237 1950237 defendant Danyell William carpenter 586059 586059 Danyell, William, of Ware, carpenter 0
3776191 1950299 1950299 defendant Thurgood Geoffrey husbandman 586059 586059 Thurgood, Geoffrey, of Ware, husbandman 0
3782452 1952253 1952253 defendant Stephenson George laborer 586059 586059 Stephenson, George, of Ware, laborer 4
3782465 1952259 1952259 plaintiff Huchyn Simon (legal representative) 586059 586059 Huchyn, Simon, of Ware, executors of 0
3782469 1952260 1952260 plaintiff Huchyn Simon (legal representative) 586059 586059 Huchyn, Simon, of Ware, executors of 0
3789451 1954527 1954527 defendant Broun Richard carpenter 586059 586059 Broun, Richard, of Ware, carpenter 0
3789453 1954528 1954528 defendant Broun Richard carpenter 586059 586059 Broun, Richard, of Ware, carpenter 0
3789871 1954658 1954658 defendant Hagard Simon yeoman 586059 586059 Hagard, Simon, of Ware, yeoman 0
3791685 1955245 1955245 defendant Atkynson Edward butcher 586059 586059 Atkynson, Edward, of Ware, butcher 0
3791686 1955245 1955245 defendant Dawton John laborer 586059 586059 Dawton, John, of Ware, laborer 1
3791687 1955245 1955245 defendant Johnson John smith 586059 586059 Johnson, John, of Ware, smith 2
3791763 1955267 1955267 defendant Hormede Thomas innholder 586059 586059 Hormede, Thomas, of Ware, innholder 0
3791764 1955267 1955267 defendant Danyell Thomas carpenter 586059 586059 Danyell, Thomas, of Ware, carpenter 1
3791766 1955267 1955267 defendant Broun Richard carpenter 586059 586059 Broun, Richard, of Ware, carpenter 3
3792559 1955530 1955530 defendant Hagar Simon yeoman 586059 586059 Hagar, Simon, of Ware, yeoman 2
3792849 1955614 1955614 defendant Danyell William carpenter 586059 586059 Danyell, William, of Ware, carpenter 0
3793342 1955779 1955779 defendant Abbott John butcher 586059 586059 Abbott, John, of Ware, butcher 0
3798008 1957276 1957276 defendant Abbott John butcher 586059 586059 Abbott, John, of Ware, butcher 0
3798721 1957513 1957513 defendant Braughyng Richard gent 586059 586059 Braughyng, Richard, of Ware, gent 0
3798722 1957513 1957513 defendant Swan John innholder 586059 586059 Swan, John, of Ware, innholder 1
3799057 1957614 1957614 defendant Key Ralph innholder 586059 586059 Key, Ralph, of Ware, innholder 1
3799059 1957614 1957614 defendant Platt Thomas smith 586059 586059 Platt, Thomas, of Ware, smith 3
3799060 1957614 1957614 defendant Cranffeld John, senior pewterer 586059 586059 Cranffeld, John, senior, of Ware, pewterer 4
3803128 1958879 1958879 plaintiff Pygrym Thomas   586059 586059 Pygrym, Thomas, of Ware 0
3803129 1958879 1958879 defendant Matson William (legal representative) 586059 586059 Matson, William, of Ware, tallow chandler, executors of 0
3803130 1958879 1958879 defendant Bucland Roger   586059 586059 (Bucland, Roger, of Ware, tallow chandler 1
3807386 1960218 1960218 defendant Marshe John innholder 586059 586059 Marshe, John, of Ware, innholder 0
3810702 1961246 1961246 defendant Hornclyff William mercer 586059 586059 Hornclyff, William, of Ware, mercer 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);