names

342 rows where place_id = 587871

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592701 1865331 1865331 defendant Baker Thomas husbandman 587871 587871 Baker, Thomas, of Waltham Holy Cross, husbandman 0
3595175 1866123 1866123 defendant Fraser William dyer 587871 587871 Fraser, William, of Waltham Holy Cross, dyer 0
3595177 1866124 1866124 defendant Freser William dyer 587871 587871 Freser, William, of Waltham Holy Cross, dyer 0
3595739 1866298 1866298 defendant FitzJohn Thomas brewer 587871 587871 FitzJohn, Thomas, of Waltham Holy Cross, brewer 0
3596284 1866468 1866468 defendant Fyssher John husbandman 587871 587871 Fyssher, John, of Waltham Holy Cross, husbandman 0
3600840 1867927 1867927 defendant Love or Lone John husbandman 587871 587871 Love or Lone, John, of Waltham Holy Cross, husbandman 0
3602054 1868303 1868303 defendant Wegyn John husbandman 587871 587871 Wegyn, John, of Waltham Holy Cross, husbandman 0
3603033 1868616 1868616 defendant Duren Richard yeoman 587871 587871 Duren, Richard, of Waltham Holy Cross, yeoman 0
3603037 1868618 1868618 defendant Reede Thomas butcher 587871 587871 Reede, Thomas, of Waltham Holy Cross, butcher 0
3603038 1868618 1868618 defendant Gylys Thomas butcher 587871 587871 Gylys, Thomas, of Waltham Holy Cross, butcher 1
3604591 1869099 1869099 defendant Barre Richard   587871 587871 Barre, Richard, of Waltham Holy Cross, basket maker 0
3604592 1869099 1869099 defendant Duren Richard clerk 587871 587871 Duren, Richard, of Waltham Holy Cross, clerk 1
3604594 1869100 1869100 defendant Forthe Nicholas draper 587871 587871 Forthe, Nicholas, of Waltham Holy Cross, draper 0
3607352 1869960 1869960 defendant Wygyn John husbandman 587871 587871 Wygyn, John, of Waltham Holy Cross, husbandman 0
3612451 1871525 1871525 defendant Seman John yeoman 587871 587871 Seman, John, of Waltham Holy Cross, yeoman 1
3612452 1871525 1871525 defendant Bland William tailor 587871 587871 Bland, William, of Waltham Holy Cross, tailor 2
3615545 1872502 1872502 defendant Hewet Richard carpenter 587871 587871 Hewet, Richard, of Waltham Holy Cross, carpenter 0
3615642 1872535 1872535 defendant Hewet Richard carpenter 587871 587871 Hewet, Richard, of Waltham Holy Cross, carpenter 0
3617443 1873077 1873077 defendant Bryght Walter, senior butcher 587871 587871 Bryght, Walter, senior, of Waltham Holy Cross, butcher 0
3617444 1873077 1873077 defendant Huet Richard carpenter 587871 587871 Huet, Richard, of Waltham Holy Cross, carpenter 1
3617445 1873077 1873077 defendant Gernell or Gervell Henry tanner 587871 587871 Gernell or Gervell, Henry, of Waltham Holy Cross, tanner 2
3617446 1873077 1873077 defendant Grove William husbandman 587871 587871 Grove, William, of Waltham Holy Cross, husbandman 3
3617447 1873077 1873077 defendant Herris Katherine widow 587871 587871 Herris, Katherine, of Waltham Holy Cross, widow 4
3622766 1874650 1874650 defendant Bryght Walter, senior butcher 587871 587871 Bryght, Walter, senior, of Waltham Holy Cross, butcher 2
3622767 1874650 1874650 defendant Bryght Walter, junior butcher 587871 587871 Bryght, Walter, junior, of Waltham Holy Cross, butcher 3
3630114 1904267 1904267 defendant Elys John fuller 587871 587871 Elys, John, of Waltham Holy Cross, fuller 0
3630116 1904267 1904267 defendant Fuller Edward fuller 587871 587871 Fuller, Edward, of Waltham Holy Cross, fuller 2
3634106 1905463 1905463 defendant Newman Thomas yeoman 587871 587871 Newman, Thomas, of Waltham Holy Cross, yeoman 0
3634107 1905463 1905463 defendant Archer John yeoman 587871 587871 Archer, John, of Waltham Holy Cross, yeoman 1
3639873 1907283 1907283 defendant Sawdry Thomas husbandman 587871 587871 Sawdry, Thomas, of Waltham Holy Cross, husbandman 0
3639874 1907283 1907283 defendant Rose John husbandman 587871 587871 Rose, John, of Waltham Holy Cross, husbandman 1
3661912 1914016 1914016 defendant Archer John yeoman 587871 587871 Archer, John, of Waltham Holy Cross, yeoman 0
3679242 1919573 1919573 defendant Rede Henry yeoman 587871 587871 Rede, Henry, of Waltham Holy Cross, yeoman 2
3679261 1919576 1919576 defendant Smyth Thomas yeoman 587871 587871 Smyth, Thomas, of Waltham Holy Cross, yeoman 2
3684549 1921301 1921301 defendant Wallenger Richard yeoman 587871 587871 Wallenger, Richard, of Waltham Holy Cross, yeoman 0
3684995 1921445 1921445 defendant Brigges John husbandman 587871 587871 Brigges, John, of Waltham Holy Cross, husbandman 0
3693405 1924153 1924153 defendant Cutbert Thomas husbandman 587871 587871 Cutbert, Thomas, of Waltham Holy Cross, husbandman 0
3707580 1928666 1928666 defendant Cutbert Thomas husbandman 587871 587871 Cutbert, Thomas, of Waltham Holy Cross, husbandman 0
3718718 1932132 1932132 defendant Smyth Thomas brewer 587871 587871 Smyth, Thomas, of Waltham Holy Cross, brewer 0
3718722 1932133 1932133 defendant Smyth Thomas brewer 587871 587871 Smyth, Thomas, of Waltham Holy Cross, brewer 0
3722071 1933164 1933164 defendant Sawtre Thomas, senior husbandman 587871 587871 Sawtre, Thomas, senior, of Waltham Holy Cross, husbandman 8
3722072 1933164 1933164 defendant Warbek John laborer 587871 587871 Warbek, John, of Waltham Holy Cross, laborer 9
3755091 1943540 1943540 defendant Clendon Thomas carpenter 587871 587871 Clendon, Thomas, of Waltham Holy Cross, carpenter 0
3755092 1943540 1943540 defendant Andro John laborer 587871 587871 Andro, John, of Waltham Holy Cross, laborer 1
3760193 1945190 1945190 defendant Archer John yeoman 587871 587871 Archer, John, of Waltham Holy Cross, yeoman 0
3762041 1945772 1945772 defendant Gore Robert husbandman 587871 587871 Gore, Robert, of Waltham Holy Cross, husbandman 0
3762042 1945772 1945772 defendant Hert John husbandman 587871 587871 Hert, John, of Waltham Holy Cross, husbandman 1
3762052 1945774 1945774 defendant Sawtre Thomas, senior husbandman 587871 587871 Sawtre, Thomas, senior, of Waltham Holy Cross, husbandman 0
3762053 1945774 1945774 defendant Sawtre Robert, junior husbandman 587871 587871 Sawtre, Robert, junior, of Waltham Holy Cross, husbandman 1
3776304 1950335 1950335 defendant Sawdry Thomas husbandman 587871 587871 Sawdry, Thomas, of Waltham Holy Cross, husbandman 0
3780263 1951556 1951556 defendant Lee Edward smith 587871 587871 Lee, Edward, of Waltham Holy Cross, Herts, pulter, son of Lee, John, of Kyngis Norton, Worcs, smith 0
3780265 1951557 1951557 defendant Lee Edward smith 587871 587871 Lee, Edward, of Waltham Holy Cross, Herts, pulter, son of Lee, John, of Kyngis Norton, Worcs, smith 0
3782359 1952236 1952236 defendant Sawtre Robert   587871 587871 Sawtre, Robert, of Waltham Holy Cross 0
3786006 1953417 1953417 plaintiff Grevys Thomas   587871 587871 Grevys, Thomas, of Waltham Holy Cross 2
3795396 1956431 1956431 defendant Hurlebot Thomas brewer 587871 587871 Hurlebot, Thomas, of Waltham Holy Cross, brewer 0
3805116 1959542 1959542 defendant Glynne John   587871 587871 Glynne, John, of Waltham Holy Cross, ale brewer 0
3845889 1972270 1972270 defendant Dymesdall Richard husbandman 587871 587871 Dymesdall, Richard, of Waltham Holy Cross, husbandman 0
3845891 1972271 1972271 defendant Stephyn William husbandman 587871 587871 Stephyn, William, of Waltham Holy Cross, husbandman 0
3845892 1972271 1972271 defendant Dymesdall Richard husbandman 587871 587871 Dymesdall, Richard, of Waltham Holy Cross, husbandman 1
3845896 1972273 1972273 defendant Stephyn William husbandman 587871 587871 Stephyn, William, of Waltham Holy Cross, husbandman 0
3845897 1972273 1972273 defendant Dymysdale Richard husbandman 587871 587871 Dymysdale, Richard, of Waltham Holy Cross, husbandman 1
3855241 1975272 1975272 defendant Tytyng John sherman 587871 587871 Tytyng, John, of Waltham Holy Cross, sherman 2
3867243 1979281 1979281 defendant Eveloke John butcher 587871 587871 Eveloke, John, of Waltham Holy Cross, butcher 0
3867244 1979281 1979281 defendant Dudley John butcher 587871 587871 Dudley, John, of Waltham Holy Cross, butcher 1
3869485 1980036 1980036 defendant Stephyn William husbandman 587871 587871 Stephyn, William, of Waltham Holy Cross, husbandman 0
3869486 1980036 1980036 defendant Dymesdall Richard husbandman 587871 587871 Dymesdall, Richard, of Waltham Holy Cross, husbandman 1
3869488 1980037 1980037 defendant Stephyn William husbandman 587871 587871 Stephyn, William, of Waltham Holy Cross, husbandman 0
3869489 1980037 1980037 defendant Dymesdall Richard husbandman 587871 587871 Dymesdall, Richard, of Waltham Holy Cross, husbandman 1
3875712 1982125 1982125 defendant Ayllerd Richard tanner 587871 587871 Ayllerd, Richard, of Waltham Holy Cross, tanner 0
3887192 1985981 1985981 defendant Dudley John butcher 587871 587871 Dudley, John, of Waltham Holy Cross, butcher 1
3891636 1987457 1987457 defendant Rede Thomas yeoman 587871 587871 Rede, Thomas, of Waltham Holy Cross, yeoman 0
3891637 1987457 1987457 defendant Snowdon Robert shoemaker 587871 587871 Snowdon, Robert, of Waltham Holy Cross, shoemaker 1
3891986 1987570 1987570 defendant Fletcher Thomas butcher 587871 587871 Fletcher, Thomas, of Waltham Holy Cross, butcher 0
3899889 1990177 1990177 defendant Rytche Peter clothmaker 587871 587871 Rytche, Peter, of Waltham Holy Cross, clothmaker 0
3911572 1994188 1994188 defendant Harkey Henry laborer 587871 587871 Harkey, Henry, of Waltham Holy Cross, laborer 0
3912725 1994589 1994589 defendant Hylle William   587871 587871 Hylle, William, of Waltham Holy Cross, brick maker 3
3956485 2009333 2009333 defendant Wryght George yeoman 587871 587871 (Wryght, George, of Waltham Holy Cross, yeoman 1
3956868 2009472 2009472 defendant Abraham Richard husbandman 587871 587871 Abraham, Richard, of Waltham Holy Cross, husbandman 0
3962020 2011299 2011299 defendant Hodge William yeoman 587871 587871 Hodge, William, of Waltham Holy Cross, or of Newport, yeoman 0
3962750 2011558 2011558 defendant Rogers John yeoman 587871 587871 Rogers, John, of Waltham Holy Cross, yeoman 0
3982248 2018418 2018418 plaintiff Rygby John gent 587871 587871 Rygby, John, of Waltham Holy Cross, gent 0
4080578 2053368 2053368 plaintiff Waterer Richard yeoman 587871 587871 Waterer, Richard, of Waltham Holy Cross, yeoman 0
4180024 2088490 2088490 defendant Butcher alias Hayes John yeoman 587871 587871 Butcher alias Hayes, John, of Waltham Holy Cross, yeoman 0
4291485 2127028 2127028 defendant Dymsdale John yeoman 587871 587871 Dymsdale, John, of Waltham Holy Cross, yeoman 0
4291487 2127029 2127029 defendant Dynsdale John yeoman 587871 587871 Dynsdale, John, of Waltham Holy Cross, yeoman 0
4349443 2147069 2147069 defendant Harryson William (legal representative) 587871 587871 Harryson, William, of Waltham Holy Cross, yeoman, executrix of 0
4365014 2152542 2152542 defendant Adams alias Tanner John yeoman 587871 587871 Adams alias Tanner, John, of Waltham Holy Cross, yeoman 0
4373525 2155599 2155599 defendant Harryson Joan widow 587871 587871 Harryson, Joan, of Waltham Holy Cross, widow 1
4434749 2175633 2175633 defendant Lord John le   587871 587871 Lord, John le, of Waltham Holy Cross 1
4437330 2176423 2176423 defendant Smyth Bartholomew le   587871 587871 Smyth, Bartholomew le, of Waltham Holy Cross 0
4461030 2188524 2188524 defendant who vouched Langrith William   587871 587871 who vouched Langrith, William, of Waltham Holy Cross, son of Bartholomew 4
4502195 2201284 2201284 defendant Cokke John   587871 587871 Cokke, John, of Waltham Holy Cross 3
4507176 2202712 2202712 defendant Doune John   587871 587871 Doune, John, of Waltham Holy Cross 0
4507178 2202713 2202713 defendant Masoun Richard   587871 587871 Masoun, Richard, of Waltham Holy Cross 0
4539795 2212708 2212708 defendant Doune John   587871 587871 Doune, John, of Waltham Holy Cross 0
4568610 2221763 2221763 defendant Baker Anthony   587871 587871 Baker, Anthony, of Waltham Holy Cross 0
4568786 2221821 2221821 defendant Frank John   587871 587871 Frank, John, of Waltham Holy Cross 0
4570434 2222324 2222324 defendant Kyngesley John   587871 587871 Kyngesley, John, of Waltham Holy Cross 0
4575973 2223979 2223979 defendant Bregge John   587871 587871 Bregge, John, of Waltham Holy Cross 0
4592449 2228991 2228991 defendant Bubbe Robert   587871 587871 Bubbe, Robert, of Waltham Holy Cross 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);