names

1,441 rows where place_id = 587015

✎ 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
3590245 1864593 1864593 defendant Boston Robert tailor 587015 587015 Boston, Robert, of St Albans, tailor 0
3591741 1865037 1865037 defendant Harryes William taverner 587015 587015 Harryes, William, of St Albans, taverner 0
3591743 1865038 1865038 defendant Harryes William taverner 587015 587015 Harryes, William, of St Albans, taverner 0
3591745 1865039 1865039 defendant Robyns Thomas yeoman 587015 587015 Robyns, Thomas, of St Albans, yeoman 0
3591747 1865040 1865040 defendant Robyns Thomas yeoman 587015 587015 Robyns, Thomas, of St Albans, yeoman 0
3592250 1865190 1865190 defendant Chaundeler Richard fuller 587015 587015 Chaundeler, Richard, of St Albans, fuller 2
3592251 1865190 1865190 defendant Gate John butcher 587015 587015 Gate, John, of St Albans, butcher 3
3592845 1865379 1865379 defendant Rosse John butcher 587015 587015 Rosse, John, of St Albans, butcher 0
3596312 1866475 1866475 defendant Cape John tenner 587015 587015 Cape, John, of St Albans, tenner 3
3596317 1866476 1866476 defendant Gape John tanner 587015 587015 Gape, John, of St Albans, tanner 3
3598188 1867064 1867064 plaintiff Smeth William esq 587015 587015 Smeth, William, of St Albans, esq 0
3598670 1867208 1867208 defendant Newych William smith 587015 587015 Newych, William, of St Albans, smith 0
3598671 1867208 1867208 defendant Skryvener Giles scrivener 587015 587015 Skryvener, Giles, of St Albans, scrivener 1
3599935 1867635 1867635 plaintiff Wattys John tanner 587015 587015 Wattys, John, of St Albans, tanner 0
3601327 1868082 1868082 defendant Depyng Robert innholder 587015 587015 Depyng, Robert, of St Albans, innholder 0
3601542 1868138 1868138 defendant Berebruer William beer brewer 587015 587015 Berebruer, William, of St Albans, beer brewer 1
3601543 1868138 1868138 defendant Smyth Thomas miller 587015 587015 Smyth, Thomas, of St Albans, miller 2
3601544 1868138 1868138 defendant Broke William tanner 587015 587015 Broke, William, of St Albans, tanner 3
3601548 1868139 1868139 defendant Berebruer William beer brewer 587015 587015 Berebruer, William, of St Albans, beer brewer 1
3601549 1868139 1868139 defendant Smyth Thomas miller 587015 587015 Smyth, Thomas, of St Albans, miller 2
3601550 1868139 1868139 defendant Broke William tanner 587015 587015 Broke, William, of St Albans, tanner 3
3601723 1868194 1868194 plaintiff Bayly alias Miller Thomas miller 587015 587015 Bayly alias Miller, Thomas, of St Albans, miller 0
3605276 1869316 1869316 defendant Rolfe Robert butcher 587015 587015 Rolfe, Robert, of St Albans, butcher 0
3607988 1870150 1870150 defendant Manne Edward fuller 587015 587015 Manne, Edward, of St Albans, fuller 0
3609001 1870472 1870472 plaintiff Westby William esq 587015 587015 Westby, William, of St Albans, esq 0
3609004 1870472 1870472 defendant Aderston John   587015 587015 Aderston, John, of St Albans 2
3609005 1870472 1870472 defendant Carter Thomas hosier 587015 587015 Carter, Thomas, of St Albans, hosier 3
3614813 1872287 1872287 defendant Hunston Thomas gent 587015 587015 Hunston, Thomas, of St Albans, gent 0
3614815 1872287 1872287 defendant Sterre John tailor 587015 587015 Sterre, John, of St Albans, tailor 2
3614826 1872289 1872289 defendant Sterre John tailor 587015 587015 Sterre, John, of St Albans, tailor 0
3616288 1872736 1872736 defendant Neubery Robert yeoman 587015 587015 Neubery, Robert, of St Albans, yeoman 0
3616289 1872736 1872736 defendant Clotheman Robert yeoman 587015 587015 Clotheman, Robert, of St Albans, yeoman 1
3616292 1872737 1872737 defendant Neubery Robert yeoman 587015 587015 Neubery, Robert, of St Albans, yeoman 0
3616293 1872737 1872737 defendant Clotheman Robert yeoman 587015 587015 Clotheman, Robert, of St Albans, yeoman 1
3618077 1873279 1873279 plaintiff Gomond William (legal representative) 587015 587015 Gomond, William, of St Albans, tailor, executors of 0
3618079 1873279 1873279 defendant Maynewaryng Peter gent 587015 587015 Maynewaryng, Peter, of St Albans, gent 0
3618080 1873279 1873279 defendant Leman Robert tailor 587015 587015 Leman, Robert, of St Albans, tailor 1
3618081 1873279 1873279 defendant Smyth Thomas smith 587015 587015 Smyth, Thomas, of St Albans, smith 2
3618091 1873281 1873281 defendant Wynshippe Thomas laborer 587015 587015 Wynshippe, Thomas, of St Albans, laborer 0
3618093 1873281 1873281 defendant Marten John sawyer 587015 587015 Marten, John, of St Albans, sawyer 2
3618746 1873483 1873483 defendant Hunston Thomas gent 587015 587015 Hunston, Thomas, of St Albans, gent 0
3618748 1873483 1873483 defendant Sterre John tailor 587015 587015 Sterre, John, of St Albans, tailor 2
3618760 1873485 1873485 defendant Sterre John tailor 587015 587015 Sterre, John, of St Albans, tailor 0
3618764 1873485 1873485 defendant Hunston Thomas gent 587015 587015 Hunston, Thomas, of St Albans, gent 4
3619254 1873624 1873624 defendant Fleccher William roper 587015 587015 Fleccher, William, of St Albans, roper 0
3619290 1873635 1873635 defendant Shawe Alice widow 587015 587015 Shawe, Alice, of St Albans, widow 0
3619933 1873808 1873808 defendant Ray John tailor 587015 587015 Ray, John, of St Albans, tailor 0
3620351 1873947 1873947 plaintiff Lemman Robert tailor 587015 587015 Lemman, Robert, of St Albans, tailor 0
3620899 1874099 1874099 defendant Grene John yeoman 587015 587015 (Grene, John, of St Albans, yeoman 1
3621749 1874342 1874342 defendant Barett William grocer 587015 587015 Barett, William, of St Albans, grocer 0
3621752 1874343 1874343 defendant Barett William grocer 587015 587015 Barett, William, of St Albans, grocer 0
3621755 1874344 1874344 defendant Barett William grocer 587015 587015 Barett, William, of St Albans, grocer 0
3621871 1874382 1874382 defendant Curteys William smith 587015 587015 Curteys, William, of St Albans, smith 2
3622622 1874604 1874604 defendant Cristemas William fuller 587015 587015 Cristemas, William, of St Albans, fuller 1
3623630 1874923 1874923 plaintiff Smeth William (legal representative) 587015 587015 Smeth, William, of St Albans, esq, executors of 0
3627816 1903560 1903560 defendant Hamlot John plumber 587015 587015 Hamlot, John, of St Albans, plumber 0
3627817 1903560 1903560 defendant Graye William plumber 587015 587015 Graye, William, of St Albans, plumber 1
3627818 1903560 1903560 defendant Briggys George tailor 587015 587015 Briggys, George, of St Albans, tailor 2
3632337 1904935 1904935 defendant Mosse William bricklayer 587015 587015 Mosse, William, of St Albans, bricklayer 0
3634366 1905546 1905546 defendant Percyvale Thomas husbandman 587015 587015 Percyvale, Thomas, of St Albans, husbandman 1
3636280 1906138 1906138 defendant Stepneth John gent 587015 587015 Stepneth, John, of St Albans, gent 0
3639031 1907029 1907029 defendant Lawley Elizabeth widow 587015 587015 Lawley, Elizabeth, of St Albans, widow 0
3639032 1907029 1907029 defendant Percyvale Thomas hostler 587015 587015 Percyvale, Thomas, of St Albans, hostler 1
3642180 1908003 1908003 defendant Wakefeld John butcher 587015 587015 Wakefeld, John, of St Albans, butcher 2
3642181 1908003 1908003 defendant Benet Thomas butcher 587015 587015 Benet, Thomas, of St Albans, butcher 3
3642185 1908004 1908004 defendant Wakefeld John butcher 587015 587015 Wakefeld, John, of St Albans, butcher 2
3642186 1908004 1908004 defendant Bennett Thomas butcher 587015 587015 Bennett, Thomas, of St Albans, butcher 3
3643319 1908336 1908336 defendant Danson George butcher 587015 587015 Danson, George, of St Albans, butcher 0
3643320 1908336 1908336 defendant Wanton Robert fisher 587015 587015 Wanton, Robert, of St Albans, fisher 1
3643321 1908336 1908336 defendant Barret William yeoman 587015 587015 Barret, William, of St Albans, yeoman 2
3649554 1910248 1910248 defendant Pycheley Edmund baker 587015 587015 Pycheley, Edmund, of St Albans, baker 0
3650076 1910391 1910391 defendant Sparkys Richard yeoman 587015 587015 Sparkys, Richard, of St Albans, yeoman 0
3651294 1910773 1910773 defendant Tapp Richard butcher 587015 587015 Tapp, Richard, of St Albans, butcher 0
3651295 1910773 1910773 defendant Everard William tanner 587015 587015 Everard, William, of St Albans, tanner 1
3651847 1910933 1910933 defendant Myller Richard fletcher or innkeeper 587015 587015 Myller, Richard, of St Albans, fletcher or innkeeper 0
3653781 1911440 1911440 defendant Cressy William gent 587015 587015 Cressy, William, of St Albans, gent 3
3655231 1911893 1911893 defendant Themer Regnald   587015 587015 Themer, Regnald, of St Albans, cord wainer 0
3655232 1911893 1911893 defendant Boston Robert tailor 587015 587015 Boston, Robert, of St Albans, tailor 1
3656038 1912141 1912141 defendant Whyte John plumber 587015 587015 Whyte, John, of St Albans, plumber 2
3657078 1912477 1912477 plaintiff Copcot Richard gent 587015 587015 Copcot, Richard, of St Albans, gent 0
3657080 1912478 1912478 plaintiff Copcot Richard gent 587015 587015 Copcot, Richard, of St Albans, gent 0
3658160 1912807 1912807 defendant (not given) Margaret prioress of Vernon 587015 587015 Vernon, Margaret, of St Albans, Dame Margaret & prioress of the priory of St Mary de pre 0
3659452 1913215 1913215 defendant Mychell Hugh miller 587015 587015 Mychell, Hugh, of St Albans, miller 0
3659454 1913215 1913215 defendant Hardyng Edmund weaver 587015 587015 Hardyng, Edmund, of St Albans, weaver 2
3659455 1913215 1913215 defendant Grubbe John miller 587015 587015 Grubbe, John, of St Albans, miller 3
3659456 1913215 1913215 defendant Gravener William tailor 587015 587015 Gravener, William, of St Albans, tailor 4
3660885 1913672 1913672 defendant Hampton Thomas yeoman 587015 587015 Hampton, Thomas, of St Albans, yeoman 0
3660886 1913672 1913672 defendant Peryent William gent 587015 587015 Peryent, William, of St Albans, gent 1
3660887 1913672 1913672 defendant Bell Julia widow 587015 587015 Bell, Julia, of St Albans, widow 2
3660889 1913672 1913672 defendant Halywell Henry   587015 587015 (Halywell, Henry, of St Albans, shoe maker 4
3661772 1913963 1913963 defendant Colyns Morris smith 587015 587015 Colyns, Morris, of St Albans, smith 6
3661796 1913971 1913971 defendant Bestney Henry gent 587015 587015 Bestney, Henry, of St Albans, gent 0
3661993 1914043 1914043 defendant Grene John   587015 587015 Grene, John, of St Albans 1
3664029 1914698 1914698 plaintiff Ramryge Thomas   587015 587015 Ramryge, Thomas, of St Albans, abbot of the Monastery 0
3669467 1916389 1916389 defendant Forster John tailor 587015 587015 Forster, John, of St Albans, tailor 0
3671665 1917125 1917125 defendant Baker alias Turnour Thomas yeoman 587015 587015 Baker alias Turnour, Thomas, of St Albans, yeoman 0
3671666 1917125 1917125 defendant Gresse Robert yeoman 587015 587015 Gresse, Robert, of St Albans, yeoman 1
3672922 1917543 1917543 defendant Porter Edward butcher 587015 587015 Porter, Edward, of St Albans, butcher 2
3673416 1917705 1917705 defendant Elys Richard gent 587015 587015 Elys, Richard, of St Albans, gent 0
3675147 1918256 1918256 defendant Forster John innholder 587015 587015 Forster, John, of St Albans, innholder 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);