names

672 rows where place_id = 586912

✎ 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
3589968 1864503 1864503 defendant Waryn Richard fuller 586912 586912 Waryn, Richard, of Melford, fuller 0
3589969 1864503 1864503 defendant Swyft John butcher 586912 586912 Swyft, John, of Melford, butcher 1
3589970 1864503 1864503 defendant Swyft Thomas butcher 586912 586912 Swyft, Thomas, of Melford, butcher 2
3590085 1864539 1864539 defendant Chaundeler Henry husbandman 586912 586912 Chaundeler, Henry, of Melford, husbandman 3
3591595 1864995 1864995 plaintiff Elys Thomas (legal representative) 586912 586912 Elys, Thomas, of Melford, clothmaker, executors of 0
3593383 1865563 1865563 plaintiff Hell John clothmaker 586912 586912 Hell, John, of Melford, clothmaker 0
3593385 1865563 1865563 defendant Robert John, junior fuller 586912 586912 Robert, John, junior, of Melford, fuller 1
3602855 1868562 1868562 defendant Spenar John yeoman 586912 586912 Spenar, John, of Melford, yeoman 2
3602858 1868562 1868562 defendant Waryn Richard fuller 586912 586912 Waryn, Richard, of Melford, fuller 5
3604093 1868946 1868946 defendant Fulby Robert fuller 586912 586912 Fulby, Robert, of Melford, fuller 4
3606733 1869782 1869782 defendant Halle Thomas smith 586912 586912 Halle, Thomas, of Melford, smith 2
3607198 1869917 1869917 defendant Wareyn Richard fuller 586912 586912 Wareyn, Richard, of Melford, fuller 1
3623806 1874977 1874977 defendant Renet or Revet Robert smith 586912 586912 Renet or Revet, Robert, of Melford, smith 2
3623810 1874978 1874978 defendant Renet or Revet Robert smith 586912 586912 Renet or Revet, Robert, of Melford, smith 2
3624204 1875103 1875103 defendant Sherman Joyce dyer 586912 586912 Sherman, Joyce, of Melford, dyer 1
3625966 1902979 1902979 defendant Smyth William butcher 586912 586912 Smyth, William, of Melford, butcher 0
3625974 1902981 1902981 defendant Germyn Agnes widow 586912 586912 Germyn, Agnes, of Melford, widow 1
3625975 1902981 1902981 defendant Alby Margaret spinster 586912 586912 Alby, Margaret, of Melford, spinster 2
3626733 1903207 1903207 plaintiff Barker John (legal representative) 586912 586912 Barker, John, of Melford, executor of 0
3627667 1903514 1903514 defendant Ty William weaver 586912 586912 Ty, William, of Melford, weaver 1
3628792 1903882 1903882 defendant Tye William husbandman 586912 586912 Tye, William, of Melford, husbandman 0
3628795 1903882 1903882 defendant Syday Walter barber 586912 586912 Syday, Walter, of Melford, barber 3
3634339 1905538 1905538 plaintiff Martyn Roger   586912 586912 Martyn, Roger, of Melford 0
3637495 1906537 1906537 defendant Hoo William husbandman 586912 586912 Hoo, William, of Melford, husbandman 0
3637758 1906624 1906624 defendant Plumbe John husbandman 586912 586912 Plumbe, John, of Melford, husbandman 4
3642658 1908149 1908149 plaintiff Chestur John yeoman 586912 586912 Chestur, John, of Melford, yeoman 0
3645129 1908883 1908883 defendant Huchyn Robert husbandman 586912 586912 Huchyn, Robert, of Melford, husbandman 0
3645496 1908993 1908993 defendant Kyng William   586912 586912 Kyng, William, of Melford, "carmaker" 0
3647930 1909751 1909751 plaintiff Martyn Roger esq 586912 586912 Martyn, Roger, of Melford, esq 0
3647931 1909751 1909751 defendant Tye William weaver 586912 586912 Tye, William, of Melford, weaver 0
3647932 1909751 1909751 defendant Tye Robert weaver 586912 586912 Tye, Robert, of Melford, weaver 1
3647933 1909751 1909751 defendant Bury Robert fuller 586912 586912 Bury, Robert, of Melford, fuller 2
3647934 1909751 1909751 defendant Danyell Robert fuller 586912 586912 Danyell, Robert, of Melford, fuller 3
3649927 1910343 1910343 defendant Gangeor Richard fuller 586912 586912 Gangeor, Richard, of Melford, fuller 0
3649928 1910343 1910343 defendant Bury James fuller 586912 586912 Bury, James, of Melford, fuller 1
3657325 1912551 1912551 defendant Hudson Robert   586912 586912 Hudson, Robert, of Melford, shoe maker 2
3657326 1912551 1912551 defendant Adryon John   586912 586912 Adryon, John, of Melford, shoe maker 3
3657331 1912552 1912552 defendant Hudson Robert   586912 586912 Hudson, Robert, of Melford, shoe maker 2
3657332 1912552 1912552 defendant Adryon John   586912 586912 Adryon, John, of Melford, shoe maker 3
3657909 1912724 1912724 defendant Tye William weaver 586912 586912 Tye, William, of Melford, weaver 0
3658285 1912847 1912847 plaintiff Elys Giles   586912 586912 Elys, Giles, of Melford, cloth maker 0
3662702 1914253 1914253 defendant Vesey Thomas   586912 586912 Vesey, Thomas, of Melford, tile maker 0
3662703 1914253 1914253 defendant Bocy Henry   586912 586912 Bocy, Henry, of Melford, tile maker 1
3662704 1914253 1914253 defendant Alysaunder Robert   586912 586912 Alysaunder, Robert, of Melford, tile maker 2
3665276 1915092 1915092 defendant Gyppys Roger husbandman 586912 586912 Gyppys, Roger, of Melford, husbandman 0
3666899 1915589 1915589 defendant Tye William   586912 586912 Tye, William, of Melford, cloth maker 1
3667703 1915844 1915844 defendant Fesy alias Veyse Thomas   586912 586912 Fesy alias Veyse, Thomas, of Melford, tile maker 5
3667898 1915900 1915900 defendant Potter Roger butcher 586912 586912 Potter, Roger, of Melford, butcher 0
3674054 1917927 1917927 defendant Spenser John carrier 586912 586912 Spenser, John, of Melford, carrier 0
3674056 1917927 1917927 defendant Gauger Robert clothier 586912 586912 Gauger, Robert, of Melford, clothier 2
3678037 1919175 1919175 plaintiff Martyn Richard (legal representative) 586912 586912 Martyn, Richard, of Melford, executor of 0
3680174 1919871 1919871 defendant Potter Roger butcher 586912 586912 Potter, Roger, of Melford, butcher 0
3681615 1920344 1920344 plaintiff Smyth Thomas   586912 586912 Smyth, Thomas, of Melford 0
3687722 1922328 1922328 defendant Symkyn William innholder 586912 586912 Symkyn, William, of Melford, innholder 0
3694390 1924451 1924451 defendant Potter Roger butcher 586912 586912 Potter, Roger, of Melford, butcher 0
3694787 1924577 1924577 defendant Gyppys Roger husbandman 586912 586912 Gyppys, Roger, of Melford, husbandman 1
3696400 1925099 1925099 defendant Marchall William fuller 586912 586912 Marchall, William, of Melford, fuller 0
3696401 1925099 1925099 defendant Barlyston Edmund dyer 586912 586912 Barlyston, Edmund, of Melford, dyer 1
3696889 1925249 1925249 defendant Barneston Edward   586912 586912 Barneston, Edward, of Melford, wood setter 1
3702705 1927118 1927118 defendant Symkyn William innholder 586912 586912 Symkyn, William, of Melford, innholder 0
3705099 1927885 1927885 defendant Gawgeour Richard clothmaker 586912 586912 Gawgeour, Richard, of Melford, clothmaker 0
3706083 1928195 1928195 defendant Hynnys William butcher 586912 586912 Hynnys, William, of Melford, butcher 0
3706237 1928239 1928239 defendant Johnson alias Pyper William thatcher 586912 586912 Johnson alias Pyper, William, of Melford, thatcher 0
3708351 1928906 1928906 defendant Potter Roger butcher 586912 586912 Potter, Roger, of Melford, butcher 0
3722236 1933212 1933212 plaintiff Martyn Roger esq 586912 586912 Martyn, Roger, of Melford, esq 0
3722631 1933338 1933338 defendant Marchall William maltman 586912 586912 Marchall, William, of Melford, maltman 0
3722635 1933339 1933339 defendant Marchall William maltman 586912 586912 Marchall, William, of Melford, maltman 0
3731888 1936204 1936204 defendant Johnson alias Scott Thomas husbandman 586912 586912 Johnson alias Scott, Thomas, of Melford, husbandman 2
3731893 1936206 1936206 defendant Pratt Thomas husbandman 586912 586912 Pratt, Thomas, of Melford, husbandman 0
3731897 1936207 1936207 defendant Rykkys William mercer 586912 586912 Rykkys, William, of Melford, mercer 0
3732032 1936251 1936251 defendant Symkyn William innholder 586912 586912 Symkyn, William, of Melford, innholder 2
3733244 1936631 1936631 defendant Walys James husbandman 586912 586912 Walys, James, of Melford, husbandman 1
3733383 1936676 1936676 plaintiff Dyke John yeoman 586912 586912 Dyke, John, of Melford, yeoman 0
3733385 1936677 1936677 plaintiff Dyke John yeoman 586912 586912 Dyke, John, of Melford, yeoman 0
3733423 1936691 1936691 defendant Breklond Alexander laborer 586912 586912 Breklond, Alexander, of Melford, laborer 0
3734449 1937019 1937019 defendant Ganne or Gaune James husbandman 586912 586912 Ganne or Gaune, James, of Melford, husbandman 0
3734450 1937019 1937019 defendant Colman Robert clothman 586912 586912 Colman, Robert, of Melford, clothman 1
3734451 1937019 1937019 defendant Marchall William clothman 586912 586912 Marchall, William, of Melford, clothman 2
3734452 1937019 1937019 defendant Myssyng of Myffyng Thomas tiler 586912 586912 Myssyng of Myffyng, Thomas, of Melford, tiler 3
3734608 1937072 1937072 defendant Marshall William maltman 586912 586912 Marshall, William, of Melford, maltman 0
3734609 1937072 1937072 defendant Packe John husbandman 586912 586912 Packe, John, of Melford, husbandman 1
3737501 1937970 1937970 defendant Spryng Thomas clothmaker 586912 586912 Spryng, Thomas, of Melford, clothmaker 0
3741170 1939100 1939100 defendant Marchall William husbandman 586912 586912 Marchall, William, of Melford, husbandman 0
3741204 1939107 1939107 plaintiff Smyth John clothmaker 586912 586912 Smyth, John, of Melford, clothmaker 0
3741205 1939107 1939107 defendant Cokkok Thomas husbandman 586912 586912 Cokkok, Thomas, of Melford, husbandman 0
3741206 1939107 1939107 defendant Packe John husbandman 586912 586912 Packe, John, of Melford, husbandman 1
3742405 1939496 1939496 defendant Kendall John   586912 586912 Kendall, John, of Melford, rough mason 0
3742407 1939497 1939497 defendant Kendall Thomas   586912 586912 Kendall, Thomas, of Melford, rough mason 0
3746560 1940839 1940839 defendant Marshall William fuller 586912 586912 Marshall, William, of Melford, fuller 0
3750695 1942142 1942142 defendant Barker Thomas miller 586912 586912 Barker, Thomas, of Melford, miller 0
3750718 1942149 1942149 plaintiff Martyn Richard (legal representative) 586912 586912 Martyn, Richard, of Melford, executor of 0
3756966 1944156 1944156 defendant Cowper John husbandman 586912 586912 Cowper, John, of Melford, husbandman 2
3759469 1944956 1944956 defendant Davy Thomas husbandman 586912 586912 Davy, Thomas, of Melford, husbandman 0
3759470 1944956 1944956 defendant Burton Thomas husbandman 586912 586912 Burton, Thomas, of Melford, husbandman 1
3759471 1944956 1944956 defendant Stakewood Roger husbandman 586912 586912 Stakewood, Roger, of Melford, husbandman 2
3759751 1945042 1945042 defendant Asselott John butcher 586912 586912 Asselott, John, of Melford, butcher 0
3760634 1945326 1945326 defendant Humfrey John tailor 586912 586912 Humfrey, John, of Melford, tailor 0
3760635 1945326 1945326 defendant Shepe Roger   586912 586912 Shepe, Roger, of Melford, wheelwright 1
3760639 1945328 1945328 plaintiff Davy Thomas   586912 586912 Davy, Thomas, of Melford 0
3763531 1946229 1946229 defendant Davy Thomas pedder 586912 586912 Davy, Thomas, of Melford, pedder 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);