names

619 rows where place_id = 586034

✎ 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
3587746 1863813 1863813 defendant Hethenesse Thomas yeoman 586034 586034 Hethenesse, Thomas, of St Albans, Herts, yeoman 2
3588146 1863943 1863943 defendant Couper Roger stockfishmonger 586034 586034 Couper, Roger, of St Albans, Herts, stockfishmonger 0
3589152 1864248 1864248 defendant Rolffe John butcher 586034 586034 Rolffe, John, of St Albans, Herts, butcher 0
3594526 1865918 1865918 defendant Knolton Henry innholder 586034 586034 Knolton, Henry, of St Albans, Herts, innholder 1
3594531 1865919 1865919 defendant Knolton Henry innholder 586034 586034 Knolton, Henry, of St Albans, Herts, innholder 1
3596066 1866399 1866399 plaintiff Nunny John (legal representative) 586034 586034 Nunny, John, of St Albans, Herts, executors of 0
3596311 1866475 1866475 defendant Carter William chapman 586034 586034 Carter, William, of St Albans, Herts, chapman 2
3596316 1866476 1866476 defendant Carter William chapman 586034 586034 Carter, William, of St Albans, Herts, chapman 2
3596818 1866639 1866639 defendant Harrys William gent 586034 586034 Harrys, William, of St Albans, Herts, gent 0
3596820 1866640 1866640 defendant Harrys William gent 586034 586034 Harrys, William, of St Albans, Herts, gent 0
3601045 1867994 1867994 defendant Wodell Thomas esq 586034 586034 Wodell, Thomas, of St Albans, Herts, esq 1
3601541 1868138 1868138 defendant Harrys Richard innholder 586034 586034 Harrys, Richard, of St Albans, Herts, innholder 0
3601547 1868139 1868139 defendant Harrys Richard innholder 586034 586034 Harrys, Richard, of St Albans, Herts, innholder 0
3602547 1868459 1868459 defendant Taverner John barker 586034 586034 Taverner, John, of St Albans, Herts, barker 0
3603087 1868631 1868631 defendant Adam Mathew mercer 586034 586034 Adam, Mathew, of St Albans, Herts, mercer 2
3604389 1869039 1869039 defendant Hyde Robert tailor 586034 586034 Hyde, Robert, of St Albans, Herts, tailor 1
3604394 1869040 1869040 defendant Hyde Robert tailor 586034 586034 Hyde, Robert, of St Albans, Herts, tailor 1
3604843 1869181 1869181 defendant Wrennok John chapman 586034 586034 Wrennok, John, of St Albans, Herts, chapman 2
3604860 1869186 1869186 defendant Wrennok John chapman 586034 586034 Wrennok, John, of St Albans, Herts, chapman 0
3606685 1869765 1869765 defendant Gape John tanner 586034 586034 Gape, John, of St Albans, Herts, tanner 1
3606687 1869766 1869766 defendant Gape John tanner 586034 586034 Gape, John, of St Albans, Herts, tanner 0
3606904 1869823 1869823 defendant Newebery John gent 586034 586034 (Newebery, John, of St Albans, Herts, gent 3
3607211 1869920 1869920 defendant Thorp William chapman 586034 586034 Thorp, William, of St Albans, Herts, chapman 0
3611351 1871222 1871222 defendant Sparke Robert husbandman 586034 586034 Sparke, Robert, of St Albans, Herts, husbandman 1
3612500 1871542 1871542 defendant Carewey John tailor 586034 586034 Carewey, John, of St Albans, Herts, tailor 3
3616517 1872803 1872803 defendant Cutberd William dyer 586034 586034 Cutberd, William, of St Albans, Herts, dyer 0
3617577 1873119 1873119 defendant Cutbert Robert dyer 586034 586034 Cutbert, Robert, of St Albans, Herts, dyer 4
3618664 1873464 1873464 defendant Hunston Thomas gent 586034 586034 (Hunston, Thomas, of St Albans, Herts, gent 1
3618736 1873481 1873481 defendant Curteys William smith 586034 586034 Curteys, William, of St Albans, Herts, smith 2
3621283 1874197 1874197 defendant Nortriche Thomas yeoman 586034 586034 (Nortriche, Thomas, of St Albans, Herts, yeoman 1
3621286 1874198 1874198 defendant Nortriche Thomas yeoman 586034 586034 (Nortriche, Thomas, of St Albans, Herts, yeoman 1
3621870 1874382 1874382 defendant (not given) John vicar of Fauler 586034 586034 Fauler, John, of St Albans, Herts, vicar of St Andrew 1
3622280 1874503 1874503 defendant Walton William yeoman 586034 586034 Walton, William, of St Albans, Herts, yeoman 0
3623432 1874862 1874862 defendant Carter William yeoman 586034 586034 Carter, William, of St Albans, Herts, yeoman 1
3631016 1904522 1904522 defendant Chyvall Edmund gent 586034 586034 Chyvall, Edmund, of St Albans, Herts, gent 1
3631019 1904523 1904523 defendant Chyvall Edmund gent 586034 586034 Chyvall, Edmund, of St Albans, Herts, gent 1
3634365 1905546 1905546 defendant Harrys Richard yeoman 586034 586034 Harrys, Richard, of St Albans, Herts, yeoman 0
3640329 1907407 1907407 defendant Stepney John gent 586034 586034 Stepney, John, of St Albans, Herts, gent 1
3642179 1908003 1908003 defendant Porter John butcher 586034 586034 Porter, John, of St Albans, Herts, butcher 1
3642184 1908004 1908004 defendant Porter John butcher 586034 586034 Porter, John, of St Albans, Herts, butcher 1
3642188 1908005 1908005 defendant Gramet William tanner 586034 586034 Gramet, William, of St Albans, Herts, tanner 0
3650717 1910588 1910588 defendant Lee John   586034 586034 Lee, John, of St Albans, Herts, freemason 0
3650719 1910589 1910589 defendant Lee John   586034 586034 Lee, John, of St Albans, Herts, freemason 0
3651058 1910697 1910697 defendant Somer Stephen yeoman 586034 586034 Somer, Stephen, of St Albans, Herts, yeoman 1
3653911 1911489 1911489 plaintiff (not given) Richard gent 586034 586034 [vacat], Richard, of St Albans, Herts, gent 0
3657128 1912493 1912493 defendant Walden Thomas butcher 586034 586034 Walden, Thomas, of St Albans, Herts, butcher 0
3661992 1914043 1914043 defendant Rogers Thomas yeoman 586034 586034 Rogers, Thomas, of St Albans, Herts, yeoman 0
3661995 1914044 1914044 defendant Rogerts Thomas yeoman 586034 586034 Rogerts, Thomas, of St Albans, Herts, yeoman 0
3661996 1914044 1914044 defendant Grene John yeoman 586034 586034 Grene, John, of St Albans, Herts, yeoman 1
3667954 1915917 1915917 defendant Ferrys Thomas gent 586034 586034 Ferrys, Thomas, of St Albans, Herts, gent 0
3668498 1916102 1916102 defendant Wantowne Thomas   586034 586034 Wantowne, Thomas, of St Albans, Herts, tallow chandler 3
3670649 1916782 1916782 defendant White John plumber 586034 586034 White, John, of St Albans, Herts, plumber 3
3672399 1917370 1917370 defendant Elys Richard yeoman 586034 586034 Elys, Richard, of St Albans, Herts, yeoman 2
3675149 1918257 1918257 defendant Foster John innholder 586034 586034 Foster, John, of St Albans, Herts, innholder 0
3699388 1926029 1926029 defendant Bayly Thomas miller 586034 586034 Bayly, Thomas, of St Albans, Herts, miller 0
3708868 1929065 1929065 defendant Jane Thomas gent 586034 586034 Jane, Thomas, of St Albans, Herts, gent 1
3723472 1933608 1933608 defendant Jane Thomas gent 586034 586034 Jane, Thomas, of St Albans, Herts, gent 0
3725211 1934172 1934172 defendant Kent William mercer 586034 586034 Kent, William, of St Albans, Herts, mercer 3
3732230 1936318 1936318 defendant Haryngton William gent 586034 586034 Haryngton, William, of St Albans, Herts, gent 1
3736794 1937758 1937758 plaintiff Kent William mercer 586034 586034 Kent, William, of St Albans, Herts, mercer 0
3739287 1938503 1938503 defendant Jane Thomas gent 586034 586034 Jane, Thomas, of St Albans, Herts, gent 0
3745919 1940630 1940630 defendant Long Robert gent 586034 586034 Long, Robert, of St Albans, Herts, gent 0
3750286 1942006 1942006 defendant Long Robert gent 586034 586034 Long, Robert, of St Albans, Herts, gent 0
3752880 1942823 1942823 defendant Tatersham Richard schoolmaster 586034 586034 Tatersham, Richard, of St Albans, Herts, schoolmaster 0
3755852 1943781 1943781 defendant Longe Robert gent 586034 586034 Longe, Robert, of St Albans, Herts, gent 0
3757704 1944390 1944390 defendant Tetessall Richard gent 586034 586034 Tetessall, Richard, of St Albans, Herts, gent 1
3757742 1944403 1944403 defendant Byllyngton Thomas esq 586034 586034 Byllyngton, Thomas, of St Albans, Herts, esq 2
3761501 1945607 1945607 defendant Peers Nicholas yeoman 586034 586034 Peers, Nicholas, of St Albans, Herts, yeoman 2
3778519 1950999 1950999 defendant Walton Thomas tanner 586034 586034 Walton, Thomas, of St Albans, Herts, tanner 0
3783261 1952517 1952517 defendant Bocher William husbandman 586034 586034 Bocher, William, of St Albans, Herts, husbandman 0
3784047 1952791 1952791 defendant Coke Francis yeoman 586034 586034 Coke, Francis, of St Albans, Herts, yeoman 0
3786464 1953557 1953557 defendant Bereth John draper 586034 586034 Bereth, John, of St Albans, Herts, draper 0
3791530 1955190 1955190 defendant Longe Robert gent 586034 586034 Longe, Robert, of St Albans, Herts, gent 0
3791802 1955281 1955281 defendant Waren Thomas gent 586034 586034 Waren, Thomas, of St Albans, Herts, gent 0
3792688 1955567 1955567 defendant Longe Robert gent 586034 586034 Longe, Robert, of St Albans, Herts, gent 0
3795584 1956503 1956503 defendant Walton Thomas tanner 586034 586034 Walton, Thomas, of St Albans, Herts, tanner 0
3797689 1957174 1957174 defendant Astry Richard   586034 586034 Astry, Richard, of St Albans, Herts, yeomabn 0
3799604 1957799 1957799 defendant Grene Thomas clerk 586034 586034 Grene, Thomas, of St Albans, Herts, clerk 0
3803635 1959051 1959051 defendant Cade Thomas clerk 586034 586034 Cade, Thomas, of St Albans, Herts, clerk 0
3807795 1960322 1960322 defendant Robyns Thomas yeoman 586034 586034 Robyns, Thomas, of St Albans, Herts, yeoman 1
3809236 1960769 1960769 defendant Long Robert gent 586034 586034 Long, Robert, of St Albans, Herts, gent 0
3809242 1960771 1960771 plaintiff Bate George pewterer 586034 586034 Bate, George, of St Albans, Herts, pewterer 0
3810537 1961193 1961193 defendant Rollis Robert yeoman 586034 586034 Rollis, Robert, of St Albans, Herts, yeoman 0
3812150 1961712 1961712 defendant Tatersall Richard gent 586034 586034 Tatersall, Richard, of St Albans, Herts, gent 1
3818593 1963718 1963718 defendant Tatersall Richard gent 586034 586034 Tatersall, Richard, of St Albans, Herts, gent 0
3825414 1965800 1965800 defendant Robyns Thomas yeoman 586034 586034 Robyns, Thomas, of St Albans, Herts, yeoman 0
3831637 1967791 1967791 defendant Herde Robert haberdasher 586034 586034 Herde, Robert, of St Albans, Herts, haberdasher 0
3831641 1967792 1967792 defendant Herd Robert haberdasher 586034 586034 Herd, Robert, of St Albans, Herts, haberdasher 2
3831953 1967891 1967891 defendant Baugh alias Waters Richard stationer 586034 586034 Baugh alias Waters, Richard, of St Albans, Herts, stationer 0
3833057 1968263 1968263 defendant Genyn John   586034 586034 Genyn, John, of St Albans, Herts 0
3842092 1971079 1971079 defendant Rose Andrew baker 586034 586034 Rose, Andrew, of St Albans, Herts, baker 3
3842096 1971080 1971080 defendant Rose Andrew baker 586034 586034 Rose, Andrew, of St Albans, Herts, baker 2
3842100 1971081 1971081 defendant Rose Andrew baker 586034 586034 Rose, Andrew, of St Albans, Herts, baker 2
3843967 1971653 1971653 defendant Clerke John innholder 586034 586034 Clerke, John, of St Albans, Herts, innholder 0
3843969 1971654 1971654 defendant Clerke John innholder 586034 586034 Clerke, John, of St Albans, Herts, innholder 0
3847198 1972681 1972681 defendant Warren William innholder 586034 586034 Warren, William, of St Albans, Herts, innholder 1
3847201 1972682 1972682 defendant Stevynson Ralph innholder 586034 586034 Stevynson, Ralph, of St Albans, Herts, innholder 0
3850343 1973696 1973696 defendant Cade Thomas clerk 586034 586034 Cade, Thomas, of St Albans, Herts, clerk 0
3850467 1973734 1973734 defendant Mudwyn William yeoman 586034 586034 Mudwyn, William, of St Albans, Herts, yeoman 0
3850470 1973735 1973735 defendant Mudwyn William yeoman 586034 586034 Mudwyn, William, of St Albans, Herts, yeoman 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);