names

242 rows where place_id = 586845

✎ 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
3589792 1864448 1864448 plaintiff Castell John   586845 586845 Castell, John, of Stony Stratford 0
3595835 1866334 1866334 defendant Castell John mercer 586845 586845 Castell, John, of Stony Stratford, mercer 0
3602635 1868487 1868487 plaintiff Castell John   586845 586845 Castell, John, of Stony Stratford 0
3603314 1868709 1868709 defendant Hole John butcher 586845 586845 Hole, John, of Stony Stratford, butcher 0
3603673 1868817 1868817 defendant Blakeman Stephen cordwainer 586845 586845 Blakeman, Stephen, of Stony Stratford, cordwainer 0
3603675 1868818 1868818 defendant Blakeman Stephen cordwainer 586845 586845 Blakeman, Stephen, of Stony Stratford, cordwainer 0
3615105 1872370 1872370 plaintiff Castell John   586845 586845 Castell, John, of Stony Stratford 0
3621514 1874270 1874270 defendant Castell John   586845 586845 Castell, John, of Stony Stratford, Bucks mercer 0
3628486 1903779 1903779 defendant Langley Richard gent 586845 586845 Langley, Richard, of Stony Stratford, gent 0
3628487 1903779 1903779 defendant Rokis Henry draper 586845 586845 Rokis, Henry, of Stony Stratford, draper 1
3633913 1905417 1905417 defendant Barton Henry yeoman 586845 586845 Barton, Henry, of Stony Stratford, yeoman 0
3633915 1905418 1905418 defendant Barton Henry yeoman 586845 586845 Barton, Henry, of Stony Stratford, yeoman 0
3634788 1905680 1905680 defendant Cuddesden William butcher 586845 586845 Cuddesden, William, of Stony Stratford, butcher 0
3634789 1905680 1905680 defendant Alchyn John yeoman 586845 586845 Alchyn, John, of Stony Stratford, yeoman 1
3638488 1906855 1906855 defendant Vaughan William yeoman 586845 586845 Vaughan, William, of Stony Stratford, yeoman 0
3647477 1909601 1909601 defendant Swayne Philip yeoman 586845 586845 Swayne, Philip, of Stony Stratford, yeoman 0
3647478 1909601 1909601 defendant Chapell Thomas yeoman 586845 586845 Chapell, Thomas, of Stony Stratford, yeoman 1
3647479 1909601 1909601 defendant Forest Thomas shoemaker 586845 586845 Forest, Thomas, of Stony Stratford, shoemaker 2
3647480 1909601 1909601 defendant Barton Richard yeoman 586845 586845 Barton, Richard, of Stony Stratford, yeoman 3
3647481 1909601 1909601 defendant Grene Thomas pulter 586845 586845 Grene, Thomas, of Stony Stratford, pulter 4
3647482 1909601 1909601 defendant Derby John glover 586845 586845 Derby, John, of Stony Stratford, glover 5
3647484 1909602 1909602 defendant Rydgate William pewterer 586845 586845 Rydgate, William, of Stony Stratford, pewterer 0
3663934 1914661 1914661 defendant Colenson Richard mercer 586845 586845 Colenson, Richard, of Stony Stratford, mercer 0
3663979 1914677 1914677 plaintiff Colynson Richard   586845 586845 Colynson, Richard, of Stony Stratford, wool winder 1
3672957 1917554 1917554 defendant Twene Walter innholder 586845 586845 Twene, Walter, of Stony Stratford, innholder 0
3707395 1928604 1928604 defendant Cuddesden William butcher 586845 586845 Cuddesden, William, of Stony Stratford, butcher 0
3727726 1934941 1934941 defendant Wylson Robert smith 586845 586845 Wylson, Robert, of Stony Stratford, smith 0
3732953 1936529 1936529 defendant Cuddesdon William butcher 586845 586845 Cuddesdon, William, of Stony Stratford, butcher 0
3739153 1938457 1938457 defendant Cuddesdon William butcher 586845 586845 Cuddesdon, William, of Stony Stratford, butcher 0
3739155 1938457 1938457 defendant Clyff or Olyff Peter butcher 586845 586845 Clyff or Olyff, Peter, of Stony Stratford, butcher 2
3759645 1945005 1945005 defendant Pollyng Nicholas currier 586845 586845 Pollyng, Nicholas, of Stony Stratford, currier 0
3759647 1945006 1945006 defendant Pollyng Nicholas laborer 586845 586845 Pollyng, Nicholas, of Stony Stratford, laborer 0
3759649 1945007 1945007 defendant Pollyng Nicholas laborer 586845 586845 Pollyng, Nicholas, of Stony Stratford, laborer 0
3769346 1948069 1948069 defendant Godesdon William butcher 586845 586845 Godesdon, William, of Stony Stratford, butcher 0
3769347 1948069 1948069 defendant Godesdon John butcher 586845 586845 Godesdon, John, of Stony Stratford, butcher 1
3772259 1949010 1949010 defendant Coodesden William butcher 586845 586845 Coodesden, William, of Stony Stratford, butcher 0
3784734 1953015 1953015 defendant Woodcroft William tailor 586845 586845 Woodcroft, William, of Stony Stratford, tailor 0
3787386 1953848 1953848 defendant Dawes Richard butcher 586845 586845 Dawes, Richard, of Stony Stratford, butcher 0
3836829 1969421 1969421 defendant Dawys Richard yeoman 586845 586845 Dawys, Richard, of Stony Stratford, yeoman 0
3839899 1970413 1970413 defendant Moll Robert baker 586845 586845 Moll, Robert, of Stony Stratford, baker 3
3856125 1975536 1975536 defendant Dansey William, junior mercer 586845 586845 Dansey, William, junior, of Stony Stratford, mercer 1
3861355 1977265 1977265 defendant Bradburne Henry butcher 586845 586845 Bradburne, Henry, of Stony Stratford, butcher 0
3878659 1983110 1983110 defendant Maltby Thomas butcher 586845 586845 Maltby, Thomas, of Stony Stratford, butcher 0
3880179 1983625 1983625 defendant Durrant Thomas innholder 586845 586845 Durrant, Thomas, of Stony Stratford, innholder 0
3880180 1983625 1983625 defendant Boughey Thomas mercer 586845 586845 Boughey, Thomas, of Stony Stratford, mercer 1
3880181 1983625 1983625 defendant Gardyner Edmund shoemaker 586845 586845 Gardyner, Edmund, of Stony Stratford, shoemaker 2
3880182 1983625 1983625 defendant Cuddesden John butcher 586845 586845 Cuddesden, John, of Stony Stratford, butcher 3
3880183 1983625 1983625 defendant Dey Henry mercer 586845 586845 Dey, Henry, of Stony Stratford, mercer 4
3888055 1986259 1986259 defendant Parkyns Richard yeoman 586845 586845 Parkyns, Richard, of Stony Stratford, yeoman 0
3905975 1992285 1992285 defendant Troughton Richard yeoman 586845 586845 Troughton, Richard, of Stony Stratford, yeoman 0
3924137 1998383 1998383 defendant Coddesdon John butcher 586845 586845 Coddesdon, John, of Stony Stratford, butcher 1
3925798 1998946 1998946 defendant Garland William yeoman 586845 586845 Garland, William, of Stony Stratford, yeoman 1
3936766 2002624 2002624 defendant Smyth Clement   586845 586845 Smyth, Clement, of Stony Stratford, inn holder 0
3954631 2008685 2008685 defendant Antock William baker 586845 586845 Antock, William, of Stony Stratford, baker 0
3971743 2014679 2014679 defendant Johnson James butcher 586845 586845 Johnson, James, of Stony Stratford, butcher 0
3977737 2016783 2016783 defendant Hewes William yeoman 586845 586845 Hewes, William, of Stony Stratford, yeoman 0
4027952 2034646 2034646 defendant Thorp Adam mercer 586845 586845 Thorp, Adam, of Stony Stratford, mercer 4
4049189 2042156 2042156 defendant Bugham John yeoman 586845 586845 Bugham, John, of Stony Stratford, yeoman 3
4049190 2042156 2042156 defendant Handbrydge John yeoman 586845 586845 Handbrydge, John, of Stony Stratford, yeoman 4
4049195 2042157 2042157 defendant Bourham John yeoman 586845 586845 Bourham, John, of Stony Stratford, yeoman 3
4049196 2042157 2042157 defendant Hanbrydge John   586845 586845 Hanbrydge, John, of Stony Stratford 4
4059404 2045756 2045756 defendant Blayton William miller 586845 586845 Blayton, William, of Stony Stratford, miller 0
4059405 2045756 2045756 defendant A Borowe Richard   586845 586845 A Borowe, Richard, of Stony Stratford, mason 1
4063193 2047133 2047133 defendant Lucas Robert innholder 586845 586845 Lucas, Robert, of Stony Stratford, innholder 1
4066818 2048433 2048433 defendant Madocke Edward innholder 586845 586845 Madocke, Edward, of Stony Stratford, innholder 0
4070774 2049843 2049843 defendant Thorpe Adam yeoman 586845 586845 Thorpe, Adam, of Stony Stratford, yeoman 0
4070778 2049845 2049845 defendant Vawse or Vance George gent 586845 586845 Vawse or Vance, George, of Stony Stratford, innkeeper, gent 0
4094450 2058354 2058354 defendant Wakefelde William butcher 586845 586845 Wakefelde, William, of Stony Stratford, butcher 0
4126826 2069885 2069885 defendant Carne Thomas yeoman 586845 586845 Carne, Thomas, of Stony Stratford, yeoman 0
4212144 2099795 2099795 defendant Vause or Vanse Hasting gent 586845 586845 Vause or Vanse, Hasting, of Stony Stratford, gent 2
4216665 2101322 2101322 defendant Hiblethwaite Robert yeoman 586845 586845 Hiblethwaite, Robert, of Stony Stratford, yeoman 1
4216770 2101361 2101361 defendant Nicholas William yeoman 586845 586845 Nicholas, William, of Stony Stratford, yeoman 0
4219742 2102409 2102409 defendant Nashe John mercer 586845 586845 Nashe, John, of Stony Stratford, mercer 1
4219753 2102412 2102412 defendant Nashe John mercer 586845 586845 Nashe, John, of Stony Stratford, mercer 1
4297148 2129080 2129080 defendant Broughe Robert gent 586845 586845 Broughe, Robert, of Stony Stratford, gent 0
4304457 2131699 2131699 defendant Carles Tutcher gent 586845 586845 Carles, Tutcher, of Stony Stratford, gent 0
4304458 2131699 2131699 defendant Carles Richard gent 586845 586845 Carles, Richard, of Stony Stratford, gent 1
4305537 2132069 2132069 defendant Hull Francis butcher 586845 586845 Hull, Francis, of Stony Stratford, butcher 1
4315730 2135611 2135611 defendant Waterhouse Charles gent 586845 586845 Waterhouse, Charles, of Stony Stratford, gent 0
4316598 2135923 2135923 defendant Heacoke Robert baker 586845 586845 Heacoke, Robert, of Stony Stratford, baker 3
4323494 2138278 2138278 defendant Hull Francis butcher 586845 586845 Hull, Francis, of Stony Stratford, butcher 0
4330601 2140529 2140529 defendant Baron Henry clerk 586845 586845 Baron, Henry, of Stony Stratford, clerk 0
4330602 2140529 2140529 defendant Hull John butcher 586845 586845 Hull, John, of Stony Stratford, butcher 1
4330603 2140529 2140529 defendant Michill Abraham chapman 586845 586845 Michill, Abraham, of Stony Stratford, chapman 2
4354017 2148632 2148632 defendant Tilcocke Thomas hosteler 586845 586845 Tilcocke, Thomas, of Stony Stratford, hosteler 2
4355287 2149069 2149069 defendant Nicholas William butcher 586845 586845 Nicholas, William, of Stony Stratford, butcher 0
4399480 2164412 2164412 defendant Waterhous Charles gent 586845 586845 Waterhous, Charles, of Stony Stratford, gent 0
4399482 2164413 2164413 defendant Waterhous or Waterhowse Charles gent 586845 586845 Waterhous or Waterhowse, Charles, of Stony Stratford, gent 0
4473784 2192444 2192444 plaintiff Dataile William   586845 586845 Dataile, William, of Stony Stratford 0
4519324 2206402 2206402 plaintiff Edy William   586845 586845 Edy, William, of Stony Stratford 0
4533213 2210647 2210647 plaintiff Berell John   586845 586845 Berell, John, of Stony Stratford 1
4533214 2210647 2210647 defendant Hay John   586845 586845 Hay, John, of Stony Stratford 0
4540863 2213047 2213047 defendant Anktell John   586845 586845 (Anktell, John, of Stony Stratford 1
4586078 2227071 2227071 defendant Burell John   586845 586845 Burell, John, of Stony Stratford 1
4586079 2227071 2227071 defendant Dolyvere Robert   586845 586845 Dolyvere, Robert, of Stony Stratford 2
4617083 2236351 2236351 defendant Edy William   586845 586845 Edy, William, of Stony Stratford 1
4620054 2237255 2237255 defendant Taillour William   586845 586845 Taillour, William, of Stony Stratford 2
4631915 2240867 2240867 defendant Brasyer John   586845 586845 Brasyer, John, of Stony Stratford 0
4633248 2241268 2241268 defendant Erbury Robert   586845 586845 Erbury, Robert, of Stony Stratford 0
4634696 2241701 2241701 defendant Copride John   586845 586845 Copride, John, of Stony Stratford 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);