names

503 rows where place_id = 586172

✎ 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
3588078 1863921 1863921 defendant Lorkyn John butcher 586172 586172 Lorkyn, John, of Hertford, butcher 0
3588080 1863921 1863921 defendant Alysaunder John butcher 586172 586172 Alysaunder, John, of Hertford, butcher 2
3588737 1864121 1864121 defendant Kydnowe Thomas yeoman 586172 586172 Kydnowe, Thomas, of Hertford, yeoman 0
3588738 1864121 1864121 defendant Ponde John mercer 586172 586172 Ponde, John, of Hertford, mercer 1
3591663 1865011 1865011 defendant Carter Thomas husbandman 586172 586172 Carter, Thomas, of Hertford, husbandman 3
3591668 1865012 1865012 defendant Carter Thomas husbandman 586172 586172 Carter, Thomas, of Hertford, husbandman 3
3591673 1865013 1865013 defendant Carter Thomas husbandman 586172 586172 Carter, Thomas, of Hertford, husbandman 3
3595067 1866090 1866090 defendant Bull Richard mercer 586172 586172 Bull, Richard, of Hertford, gent, or of London, mercer 0
3598248 1867082 1867082 defendant Wolmer John yeoman 586172 586172 Wolmer, John, of Hertford, yeoman 0
3599218 1867396 1867396 defendant Bruse John yeoman 586172 586172 Bruse, John, of Hertford, yeoman 0
3599220 1867396 1867396 defendant Balthorpe Thomas vintner 586172 586172 Balthorpe, Thomas, of Hertford, vintner 2
3599222 1867397 1867397 defendant Clerke Thomas yeoman 586172 586172 Clerke, Thomas, of Hertford, yeoman 0
3602430 1868419 1868419 defendant Mighell Robert butcher 586172 586172 Mighell, Robert, of Hertford, butcher 0
3602431 1868419 1868419 defendant Bigge John miller 586172 586172 Bigge, John, of Hertford, miller 1
3607481 1870000 1870000 defendant Lorkyn John butcher 586172 586172 Lorkyn, John, of Hertford, butcher 0
3616106 1872675 1872675 defendant Averell William, junior yeoman or tailor 586172 586172 Averell, William, junior, of Hertford, yeoman or tailor 0
3618880 1873515 1873515 defendant Bull Richard gent 586172 586172 Bull, Richard, of Hertford, gent 3
3618917 1873526 1873526 defendant Clerk William innholder 586172 586172 Clerk, William, of hertford, innholder 1
3625419 1875487 1875487 defendant Bigge John farmer of Standon mill 586172 586172 Bigge, John, of Hertford, yeoman, farmer of Standon mill 0
3625422 1875488 1875488 defendant Bigge John farmer of Staundon mill 586172 586172 Bigge, John, of Hertford, yeoman, farmer of Staundon mill 0
3625425 1875489 1875489 defendant Bigge John farmer of Staundon mill 586172 586172 Bigge, John, of Hertford, yeoman, farmer of Staundon mill 0
3626963 1903289 1903289 plaintiff Bedell William esq 586172 586172 Bedell, William, of Hertford, esq 0
3626965 1903290 1903290 plaintiff Bedell William esq 586172 586172 Bedell, William, of Hertford, esq 0
3626967 1903291 1903291 plaintiff Bedell William esq 586172 586172 Bedell, William, of Hertford, esq 0
3630919 1904490 1904490 defendant Bell Thomas clerk 586172 586172 Bell, Thomas, of Hertford, clerk 0
3630920 1904490 1904490 defendant Jakson John tailor 586172 586172 Jakson, John, of Hertford, tailor 1
3630921 1904490 1904490 defendant Bell Richard husbandman 586172 586172 Bell, Richard, of Hertford, husbandman 2
3634696 1905646 1905646 defendant Chester William glover 586172 586172 Chester, William, of Hertford, glover 0
3634697 1905646 1905646 defendant Thomlynson Thomas tailor 586172 586172 Thomlynson, Thomas, of Hertford, tailor 1
3639495 1907157 1907157 defendant Pylle Henry chapman 586172 586172 Pylle, Henry, of Hertford, chapman 1
3640981 1907619 1907619 defendant Dysborough Edmund butcher 586172 586172 Dysborough, Edmund, of Hertford, butcher 0
3640985 1907621 1907621 plaintiff Bargener Nicholas   586172 586172 Bargener, Nicholas, of Hertford, mill wright 0
3643990 1908552 1908552 defendant Gough John yeoman 586172 586172 Gough, John, of Hertford, yeoman 3
3650731 1910593 1910593 defendant Lorkyn Robert butcher 586172 586172 Lorkyn, Robert, of Hertford, butcher 3
3650916 1910655 1910655 defendant Gough John yeoman 586172 586172 Gough, John, of Hertford, yeoman 0
3650918 1910656 1910656 defendant Gough John yeoman 586172 586172 Gough, John, of Hertford, yeoman 0
3656899 1912415 1912415 defendant Chester William glover 586172 586172 Chester( William, of Hertford, glover 0
3658001 1912756 1912756 plaintiff Draper Richard (legal representative) 586172 586172 Draper, Richard, of Hertford, executors of 0
3658372 1912867 1912867 defendant Hunt John yeoman 586172 586172 Hunt, John, of Hertford, yeoman 1
3658889 1913037 1913037 defendant Strode Thomas weaver 586172 586172 Strode, Thomas, of Hertford, weaver 0
3659621 1913267 1913267 defendant Nevell Richard tanner 586172 586172 Nevell, Richard, of Hertford, tanner 0
3670900 1916865 1916865 plaintiff Cammeswell John   586172 586172 Cammeswell, John, of Hertford 0
3671274 1916989 1916989 defendant Bolte Thomas butcher 586172 586172 Bolte, Thomas, of Hertford, butcher 2
3673253 1917649 1917649 plaintiff Elmesley William draper 586172 586172 Elmesley, William, of Hertford, draper 0
3673256 1917650 1917650 plaintiff Elmesley William draper 586172 586172 Elmesley, William, of Hertford, draper 0
3674970 1918203 1918203 defendant Fraunceys John miller 586172 586172 Fraunceys, John, of Hertford, miller 1
3676273 1918625 1918625 defendant Lorkyn John butcher 586172 586172 Lorkyn, John, of Hertford, butcher 2
3677492 1919009 1919009 defendant Lorkyn John butcher 586172 586172 Lorkyn, John, of Hertford, butcher 2
3678604 1919367 1919367 plaintiff Mynours William gent 586172 586172 Mynours, William, of Hertford, gent 0
3678910 1919473 1919473 defendant Abbot Richard laborer 586172 586172 Abbot, Richard, of Hertford, laborer 1
3685867 1921738 1921738 defendant Sevell William yeoman 586172 586172 Sevell, William, of Hertford, yeoman 3
3689221 1922795 1922795 plaintiff Emmysley William tailor 586172 586172 Emmysley, William, of Hertford, tailor 0
3690833 1923298 1923298 defendant Rawlyn Richard butcher 586172 586172 Rawlyn, Richard, of Hertford, butcher 0
3692073 1923690 1923690 defendant Raulyn Richard butcher 586172 586172 Raulyn, Richard, of Hertford, butcher 2
3692484 1923831 1923831 defendant Plumbe Richard yeoman 586172 586172 Plumbe, Richard, of Hertford, yeoman 0
3692549 1923857 1923857 defendant Saunder John   586172 586172 Saunder, John, of Hertford, tallow chandler 0
3705789 1928092 1928092 plaintiff Hemsley alias Emmysleye William draper or tailor 586172 586172 Hemsley alias Emmysleye, William, of Hertford, draper or tailor 0
3706361 1928279 1928279 defendant Colyour John laborer 586172 586172 Colyour, John, of Hertford, laborer 1
3712296 1930161 1930161 defendant Rawlyn Richard butcher 586172 586172 Rawlyn, Richard, of Hertford, butcher 0
3718728 1932135 1932135 defendant Leysse Richard maltman 586172 586172 Leysse, Richard, of Hertford, maltman 0
3721004 1932866 1932866 plaintiff Kelyng Robert tanner 586172 586172 Kelyng, Robert, of Hertford, tanner 0
3722986 1933454 1933454 defendant Chestur William glover 586172 586172 Chestur, William, of Hertford, glover 0
3723324 1933565 1933565 defendant Emen Thomas smith 586172 586172 Emen, Thomas, of Hertford, smith 4
3733538 1936734 1936734 defendant Abraham John   586172 586172 Abraham, John, of Hertford, basket maker 3
3735002 1937183 1937183 plaintiff Gunnysley William   586172 586172 Gunnysley, William, of Hertford 0
3736209 1937568 1937568 defendant Sewall William weaver 586172 586172 Sewall, William, of Hertford, weaver 1
3744156 1940072 1940072 defendant Chestur William glover 586172 586172 Chestur, William, of Hertford, glover 1
3744821 1940279 1940279 defendant Sewell Joan widow 586172 586172 Sewell, Joan, of Hertford, widow 0
3744822 1940279 1940279 defendant Sewell William laborer 586172 586172 Sewell, William, of Hertford, laborer 1
3744977 1940336 1940336 plaintiff Boll John mercer 586172 586172 Boll, John, of Hertford, mercer 0
3744978 1940336 1940336 defendant Bull Charles gent 586172 586172 Bull, Charles, of Hertford, gent 0
3747286 1941073 1941073 defendant Sewell William weaver 586172 586172 Sewell, William, of Hertford, weaver 0
3747287 1941073 1941073 defendant Sewell Joan widow 586172 586172 Sewell, Joan, of Hertford, widow 1
3747288 1941073 1941073 defendant Peche John smith 586172 586172 Peche, John, of Hertford, smith 2
3748239 1941376 1941376 defendant Chester William glover 586172 586172 Chester, William, of Hertford, glover 0
3748241 1941377 1941377 defendant Chester William glover 586172 586172 Chester, William, of Hertford, glover 0
3756040 1943844 1943844 defendant Chester William glover 586172 586172 Chester, William, of Hertford, glover 0
3757341 1944275 1944275 defendant Sewell Joan widow 586172 586172 Sewell, Joan, of Hertford, widow 0
3757342 1944275 1944275 defendant Sewell William laborer 586172 586172 Sewell, William, of Hertford, laborer 1
3757573 1944348 1944348 plaintiff Boll John mercer 586172 586172 Boll, John, of Hertford, mercer 0
3757574 1944348 1944348 defendant Bull Charles gent 586172 586172 Bull, Charles, of Hertford, gent 0
3759139 1944846 1944846 defendant Saunder John   586172 586172 Saunder, John, of Hertford, tallow chandler 0
3761069 1945463 1945463 defendant Sewell William weaver 586172 586172 Sewell, William, of Hertford, weaver 0
3761070 1945463 1945463 defendant Sewell Joan widow 586172 586172 Sewell, Joan, of Hertford, widow 1
3761071 1945463 1945463 defendant Peche John smith 586172 586172 Peche, John, of Hertford, smith 2
3762255 1945839 1945839 defendant Lorkyn John butcher 586172 586172 Lorkyn, John, of Hertford, butcher 0
3762256 1945839 1945839 defendant Lorkyn Agnes widow 586172 586172 Lorkyn, Agnes, of Hertford, widow 1
3765600 1946906 1946906 defendant Sayer George yeoman 586172 586172 Sayer, George, of Hertford, yeoman 0
3765601 1946906 1946906 defendant Hunt James husbandman 586172 586172 Hunt, James, of Hertford, husbandman 1
3765602 1946906 1946906 defendant Newman Roger husbandman 586172 586172 Newman, Roger, of Hertford, husbandman 2
3773447 1949408 1949408 defendant Bolle John mercer 586172 586172 Bolle, John, of Hertford, mercer 0
3773448 1949408 1949408 defendant Bolle Julia widow 586172 586172 Bolle, Julia, of Hertford, widow 1
3774131 1949621 1949621 defendant Elmysley William yeoman 586172 586172 Elmysley, William, of Hertford, yeoman 0
3774133 1949621 1949621 defendant Archer Thomas yeoman 586172 586172 Archer, Thomas, of Hertford, yeoman 2
3774134 1949621 1949621 defendant Heynes Robert laborer 586172 586172 Heynes, Robert, of Hertford, laborer 3
3777165 1950610 1950610 defendant Philypp thomas butcher 586172 586172 Philypp, thomas, of Hertford, butcher 1
3781360 1951913 1951913 defendant Hobbys William miller 586172 586172 Hobbys, William, of Hertford, miller 0
3793627 1955868 1955868 defendant Alysaunder John yeoman 586172 586172 Alysaunder, John, of Hertford, yeoman 2
3796437 1956757 1956757 plaintiff Elmesley alias Hemmesley William draper 586172 586172 Elmesley alias Hemmesley, William, of Hertford, draper 0
3796488 1956773 1956773 defendant Bratofte Joan widow 586172 586172 Bratofte, Joan, of Hertford, widow 1

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);