names

765 rows where place_id = 586102

✎ 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
3587944 1863880 1863880 defendant Pyke Robert courser 586102 586102 Pyke, Robert, of Hengham, courser 0
3587945 1863880 1863880 defendant Clerk Richard baker 586102 586102 Clerk, Richard, of Hengham, baker 1
3587946 1863880 1863880 defendant Halle Robert   586102 586102 Halle, Robert, of Hengham, hoop maker 2
3590774 1864753 1864753 defendant Melton Thomas laborer 586102 586102 Melton, Thomas, of Hengham, laborer 2
3591337 1864918 1864918 defendant Davy John yeoman 586102 586102 Davy, John, of Hengham, yeoman 0
3594989 1866062 1866062 defendant Salys Robert yeoman 586102 586102 Salys, Robert, of Hengham, yeoman 1
3599968 1867645 1867645 defendant Clerk Richard baker 586102 586102 Clerk, Richard, of Hengham, baker 1
3607262 1869935 1869935 defendant Clerke Richard baker 586102 586102 Clerke, Richard, of Hengham, baker 2
3608303 1870254 1870254 defendant Baldewyn John   586102 586102 Baldewyn, John, of Hengham, wax chandler 2
3613288 1871806 1871806 defendant Norman John   586102 586102 Norman, John, of Hengham, ash burner 0
3616029 1872648 1872648 defendant Hyll William butcher 586102 586102 Hyll, William, of Hengham, butcher 0
3616030 1872648 1872648 defendant Blaksale Robert   586102 586102 Blaksale, Robert, of Hengham. Husbandman 1
3617121 1872979 1872979 plaintiff Fel Thomas yeoman 586102 586102 Fel, Thomas, of Hengham, yeoman 0
3617122 1872979 1872979 defendant Ocley George tailor 586102 586102 Ocley, George, of Hengham, tailor 0
3631681 1904722 1904722 defendant Coke Seman shoemaker 586102 586102 Coke, Seman, of Hengham, shoemaker 0
3633645 1905333 1905333 plaintiff Lans or Laus Thomas   586102 586102 Lans or Laus, Thomas, of Hengham 0
3633646 1905333 1905333 defendant Browse William (legal representative) 586102 586102 Browse, William, of Hengham, thatcher, executors of 0
3635360 1905854 1905854 defendant Skyrbek Robert butcher 586102 586102 Skyrbek, Robert, of Hengham, butcher 0
3636530 1906219 1906219 defendant Dyver John husbandman 586102 586102 Dyver, John, of Hengham, husbandman 0
3637339 1906483 1906483 plaintiff Skerbek Robert   586102 586102 Skerbek, Robert, of Hengham 0
3639138 1907059 1907059 defendant Styflyn Alice widow 586102 586102 Styflyn, Alice, of Hengham, widow 3
3640502 1907462 1907462 defendant Andrewes Walter hardwareman 586102 586102 Andrewes, Walter, of Hengham, hardwareman 0
3647663 1909657 1909657 defendant Chylde Richard husbandman 586102 586102 Chylde, Richard, of Hengham, husbandman 1
3654364 1911626 1911626 defendant Fytlyng Bartholomew butcher 586102 586102 Fytlyng, Bartholomew, of Hengham, butcher 0
3654365 1911626 1911626 defendant Dele Robert butcher 586102 586102 Dele, Robert, of Hengham, butcher 1
3654565 1911689 1911689 defendant Rowse John husbandman 586102 586102 Rowse, John, of Hengham, husbandman 2
3656419 1912252 1912252 defendant More William mercer 586102 586102 More, William, of Hengham, mercer 3
3657457 1912592 1912592 defendant Sampyll John laborer 586102 586102 Sampyll, John, of Hengham, laborer 0
3657475 1912600 1912600 defendant Skyrbek Edmund husbandman 586102 586102 Skyrbek, Edmund, of Hengham, husbandman 0
3657482 1912601 1912601 defendant Rows John husbandman 586102 586102 Rows, John, of Hengham, husbandman 3
3657483 1912601 1912601 defendant Trewe Robert cobbler 586102 586102 Trewe, Robert, of Hengham, cobbler 4
3657484 1912601 1912601 defendant Aubry Robert   586102 586102 Aubry, Robert, of Hengham, shoe maker 5
3659743 1913300 1913300 defendant Baxster Stephen butcher 586102 586102 Baxster, Stephen, of Hengham, butcher 0
3667202 1915676 1915676 defendant Wodthorp Robert mercer 586102 586102 Wodthorp, Robert, of Hengham, mercer 0
3667372 1915733 1915733 plaintiff Wodcok Hugh (legal representative) 586102 586102 Wodcok, Hugh, of Hengham, executors of 0
3667375 1915733 1915733 defendant Beyll Robert butcher 586102 586102 Beyll, Robert, of Hengham, butcher 0
3667393 1915740 1915740 defendant Fytlyng Bartholomew butcher 586102 586102 Fytlyng, Bartholomew, of Hengham, butcher 0
3668027 1915939 1915939 defendant Pylgrym John butcher 586102 586102 Pylgrym, John, of Hengham, butcher 0
3672381 1917365 1917365 defendant Yongis Richard weaver 586102 586102 Yongis, Richard, of Hengham, weaver 2
3672382 1917365 1917365 defendant Baxster Stephen butcher 586102 586102 Baxster, Stephen, of Hengham, butcher 3
3672383 1917365 1917365 defendant Portman John, senior husbandman 586102 586102 Portman, John, senior, of Hengham, husbandman 4
3672384 1917365 1917365 defendant Dyver John husbandman 586102 586102 Dyver, John, of Hengham, husbandman 5
3674061 1917929 1917929 defendant Baxster Stephen butcher 586102 586102 Baxster, Stephen, of Hengham, butcher 0
3674063 1917929 1917929 defendant Lewes Thomas shoemaker 586102 586102 Lewes, Thomas, of Hengham, shoemaker 2
3674064 1917929 1917929 defendant Elyngham Robert (legal representative) 586102 586102 Elyngham, Robert, of Hengham, executors of 3
3674065 1917929 1917929 defendant Talwyn Richard husbandman 586102 586102 (Talwyn, Richard, of Hengham, husbandman 4
3674643 1918120 1918120 defendant Gysburgh Florence mercer 586102 586102 Gysburgh, Florence, of Hengham, mercer 1
3674645 1918120 1918120 defendant Awebery Robert shoemaker 586102 586102 Awebery, Robert, of Hengham, shoemaker 3
3677717 1919077 1919077 defendant Browst Robert tailor 586102 586102 Browst, Robert, of Hengham, tailor 0
3681316 1920245 1920245 defendant Mason William laborer 586102 586102 Mason, William, of Hengham, laborer 1
3683044 1920810 1920810 defendant Rouns John husbandman 586102 586102 Rouns, John, of Hengham, husbandman 0
3683045 1920810 1920810 defendant Rouns Geoffrey husbandman 586102 586102 Rouns, Geoffrey, of Hengham, husbandman 1
3683046 1920810 1920810 defendant Yonge Richard weaver 586102 586102 Yonge, Richard, of Hengham, weaver 2
3688415 1922533 1922533 defendant Belle Robert butcher 586102 586102 Belle, Robert, of Hengham, butcher 2
3688416 1922533 1922533 defendant Yonges Richard weaver 586102 586102 Yonges, Richard, of Hengham, weaver 3
3690772 1923280 1923280 defendant Cooke Seman shoemaker 586102 586102 Cooke, Seman, of Hengham, shoemaker 0
3690773 1923280 1923280 defendant Pylgryme John butcher 586102 586102 Pylgryme, John, of Hengham, butcher 1
3691666 1923554 1923554 defendant Pye John laborer 586102 586102 Pye, John, of Hengham, laborer 1
3691667 1923554 1923554 defendant Mallard John laborer 586102 586102 Mallard, John, of Hengham, laborer 2
3704969 1927847 1927847 defendant Uttyng John husbandman 586102 586102 Uttyng, John, of Hengham, husbandman 0
3704971 1927847 1927847 defendant Sancroft Edward innkeeper 586102 586102 Sancroft, Edward, of Hengham, innkeeper 2
3708673 1929012 1929012 defendant Fytlyng Bartholomew butcher 586102 586102 Fytlyng, Bartholomew, of Hengham, butcher 1
3711257 1929824 1929824 defendant Skyrbek Edmund yeoman 586102 586102 Skyrbek, Edmund, of Hengham, yeoman 0
3711837 1930016 1930016 defendant Gyffreys Nicholas husbandman 586102 586102 Gyffreys, Nicholas, of Hengham, husbandman 4
3711963 1930057 1930057 defendant Pylgryme John butcher 586102 586102 Pylgryme, John, of Hengham, butcher 0
3714569 1930854 1930854 defendant Norman John   586102 586102 Norman, John, of Hengham, ash burner 1
3718169 1931968 1931968 defendant Woodthorp John husbandman 586102 586102 Woodthorp, John, of Hengham, husbandman 3
3718976 1932215 1932215 defendant Sancroft Edward innkeeper 586102 586102 Sancroft, Edward, of Hengham, innkeeper 0
3726927 1934688 1934688 plaintiff Typsched Thomas (legal representative) 586102 586102 Typsched, Thomas, of Hengham, executor of 0
3728852 1935271 1935271 defendant Gisborn Florence mercer 586102 586102 Gisborn, Florence, of Hengham, mercer 1
3729013 1935322 1935322 defendant Revett John barker 586102 586102 Revett, John, of Hengham, barker 0
3729014 1935322 1935322 defendant Baxter Stephen butcher 586102 586102 Baxter, Stephen, of Hengham, butcher 1
3729797 1935577 1935577 defendant Bale Bartholomew husbandman 586102 586102 Bale, Bartholomew, of Hengham, husbandman 0
3732371 1936362 1936362 defendant Browse Robert tailor 586102 586102 Browse, Robert, of Hengham, tailor 0
3732523 1936402 1936402 defendant Portman John tanner 586102 586102 Portman, John, of Hengham, tanner 0
3732526 1936402 1936402 defendant Fyttelyng Bartholomew husbandman 586102 586102 Fyttelyng, Bartholomew, of Hengham, husbandman 3
3732979 1936536 1936536 defendant Florence John hardwareman 586102 586102 Florence, John, of Hengham, hardwareman 2
3740999 1939044 1939044 defendant Pylgryme John husbandman 586102 586102 Pylgryme, John, of Hengham, husbandman 1
3741632 1939253 1939253 defendant Parson John chapman 586102 586102 Parson, John, of Hengham, chapman 1
3741939 1939344 1939344 defendant Parson John husbandman 586102 586102 Parson, John, of Hengham, husbandman 0
3752184 1942611 1942611 defendant Skyrbek Robert butcher 586102 586102 Skyrbek, Robert, of Hengham, butcher 0
3754949 1943497 1943497 defendant Pylgryme Robert husbandman 586102 586102 Pylgryme, Robert, of Hengham, husbandman 1
3757824 1944424 1944424 defendant Kempe Richard butcher 586102 586102 Kempe, Richard, of Hengham, butcher 0
3757825 1944424 1944424 defendant Bawdewyn Robert husbandman 586102 586102 Bawdewyn, Robert, of Hengham, husbandman 1
3759405 1944930 1944930 defendant Hale William roper 586102 586102 Hale, William, of Hengham, roper 0
3759878 1945078 1945078 defendant Parson John mercer 586102 586102 Parson, John, of Hengham, mercer 1
3762515 1945920 1945920 defendant Nottyngham Robert husbandman 586102 586102 Nottyngham, Robert, of Hengham, husbandman 0
3763771 1946313 1946313 defendant Wodethorp Robert mercer 586102 586102 Wodethorp, Robert, of Hengham, mercer 1
3768796 1947890 1947890 defendant Skyrbek Robert butcher 586102 586102 Skyrbek, Robert, of Hengham, butcher 0
3781075 1951816 1951816 defendant Cooke Simon shoemaker 586102 586102 Cooke, Simon, of Hengham, shoemaker 0
3784164 1952828 1952828 defendant Legate Edmund innholder 586102 586102 Legate, Edmund, of Hengham, innholder 4
3785005 1953090 1953090 plaintiff More William mercer 586102 586102 More, William, of Hengham, mercer 0
3785006 1953090 1953090 defendant Kempe Richard butcher 586102 586102 Kempe, Richard, of Hengham, butcher 0
3785892 1953379 1953379 defendant Wodthorp Robert mercer 586102 586102 Wodthorp, Robert, of Hengham, mercer 0
3786035 1953424 1953424 defendant Wodthorp Robert mercer 586102 586102 Wodthorp, Robert, of Hengham, mercer 4
3793539 1955841 1955841 defendant Person John mercer 586102 586102 Person, John, of Hengham, mercer 4
3797809 1957213 1957213 defendant Coke Seman shoemaker 586102 586102 Coke, Seman, of Hengham, shoemaker 0
3797810 1957213 1957213 defendant Pylgryme John butcher 586102 586102 Pylgryme, John, of Hengham, butcher 1
3797822 1957215 1957215 defendant Lyster William yeoman 586102 586102 Lyster, William, of hengham, yeoman 2
3800662 1958120 1958120 defendant Legette Edmund innkeeper 586102 586102 Legette, Edmund, of Hengham, innkeeper 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);