names

288 rows where place_id = 594426

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616103 1872674 1872674 defendant Baret Henry maltman 594426 594426 Baret, Henry, of Benyngton, maltman 2
3631859 1904774 1904774 defendant Parys William laborer 594426 594426 Parys, William, of Benyngton, laborer 0
3650590 1910552 1910552 defendant Nore Thomas maltman 594426 594426 Nore, Thomas, of Benyngton, maltman 1
3650592 1910552 1910552 defendant Barret William maltman 594426 594426 Barret, William, of Benyngton, maltman 3
3654291 1911600 1911600 defendant Kent John maltman 594426 594426 Kent, John, of Benyngton, maltman 0
3659848 1913335 1913335 defendant Parys William laborer 594426 594426 Parys, William, of Benyngton, laborer 0
3662304 1914125 1914125 defendant Kent John maltman 594426 594426 Kent, John, of Benyngton, maltman 1
3662305 1914125 1914125 defendant Olyver Thomas husbandman 594426 594426 Olyver, Thomas, of Benyngton, husbandman 2
3663307 1914448 1914448 defendant Baker Richard smith 594426 594426 Baker, Richard, of Benyngton, smith 1
3671415 1917038 1917038 defendant Hoye Leonard maltman 594426 594426 Hoye, Leonard, of Benyngton, maltman 1
3675905 1918500 1918500 defendant Nore Thomas maltman 594426 594426 Nore, Thomas, of Benyngton, maltman 1
3675906 1918500 1918500 defendant Kent John maltman 594426 594426 Kent, John, of Benyngton, maltman 2
3676122 1918572 1918572 defendant Ramston Richard summoner 594426 594426 Ramston, Richard, of Benyngton, summoner 0
3677490 1919009 1919009 defendant Nore Thomas maltman 594426 594426 Nore, Thomas, of Benyngton, maltman 0
3684216 1921198 1921198 defendant Nore Thomas maltman 594426 594426 Nore, Thomas, of Benyngton, maltman 0
3684394 1921250 1921250 defendant Duke William maltman 594426 594426 Duke, William, of Benyngton, maltman 0
3691404 1923470 1923470 defendant Nore Thomas maltman 594426 594426 Nore, Thomas, of Benyngton, maltman 0
3692016 1923670 1923670 defendant Ramsten Richard summoner 594426 594426 Ramsten, Richard, of Benyngton, summoner 0
3692017 1923670 1923670 defendant Baker Richard smith 594426 594426 Baker, Richard, of Benyngton, smith 1
3694299 1924421 1924421 defendant Willard John Kent, clothier 594426 594426 Willard John, of Benyngton, Kent, clothier 0
3695053 1924662 1924662 defendant Bothby William herdman 594426 594426 Bothby, William, of Benyngton, herdman 0
3704903 1927826 1927826 defendant Stedeman William chaplain 594426 594426 Stedeman, William, of Benyngton, chaplain 0
3715329 1931078 1931078 defendant Nore Thomas husbandman 594426 594426 Nore, Thomas, of Benyngton, husbandman 2
3717813 1931874 1931874 defendant Barrett Leonard husbandman 594426 594426 Barrett, Leonard, of Benyngton, husbandman 3
3723915 1933761 1933761 defendant Harvy John maltman 594426 594426 Harvy, John, of Benyngton, maltman 0
3723916 1933761 1933761 defendant Harvy William maltman 594426 594426 Harvy, William, of Benyngton, maltman 1
3731392 1936040 1936040 defendant Stedman Thomas yeoman 594426 594426 Stedman, Thomas, of Benyngton, yeoman 0
3731841 1936187 1936187 defendant Howede alias Howe Isabel widow 594426 594426 Howede alias Howe, Isabel, of Benyngton, widow 1
3733539 1936734 1936734 defendant Kent John maltman 594426 594426 Kent, John, of Benyngton, maltman 4
3746776 1940909 1940909 defendant Praty John yeoman 594426 594426 Praty, John, of Benyngton, yeoman 1
3758769 1944729 1944729 defendant Barfote Thomas husbandman 594426 594426 Barfote, Thomas, of Benyngton, husbandman 4
3760185 1945186 1945186 defendant Praty John yeoman 594426 594426 Praty, John, of Benyngton, yeoman 0
3760189 1945188 1945188 defendant Harvy William husbandman 594426 594426 Harvy, William, of Benyngton, husbandman 0
3763315 1946159 1946159 defendant Barfote Thomas maltman 594426 594426 Barfote, Thomas, of Benyngton, maltman 0
3766654 1947232 1947232 defendant Barfote Thomas husbandman 594426 594426 Barfote, Thomas, of Benyngton, husbandman 1
3770768 1948545 1948545 defendant Nore Thomas maltman 594426 594426 Nore, Thomas, of Benyngton, maltman 1
3770769 1948545 1948545 defendant Barfote John maltman 594426 594426 Barfote, John, of Benyngton, maltman 2
3773678 1949486 1949486 defendant Harvy William husbandman 594426 594426 Harvy, William, of Benyngton, husbandman 3
3778018 1950836 1950836 defendant Hunt Edward maltman 594426 594426 Hunt, Edward, of Benyngton, maltman 0
3778453 1950975 1950975 defendant Chapman John maltman 594426 594426 Chapman, John, of Benyngton, maltman 0
3789270 1954461 1954461 defendant Nore Thomas maltman 594426 594426 Nore, Thomas, of Benyngton, maltman 0
3819436 1963964 1963964 defendant Cokke John husbandman 594426 594426 Cokke, John, of Benyngton, husbandman 0
3819438 1963964 1963964 defendant Parys William laborer 594426 594426 Parys, William, of Benyngton, laborer 2
3819963 1964124 1964124 defendant Coke John husbandman 594426 594426 Coke, John, of Benyngton, husbandman 3
3840150 1970491 1970491 defendant Chapman John maltman 594426 594426 Chapman, John, of Benyngton, maltman 0
3848331 1973053 1973053 defendant Warrant John husbandman 594426 594426 Warrant, John, of Benyngton, husbandman 1
3869914 1980182 1980182 defendant Denys Richard miller 594426 594426 Denys, Richard, of Benyngton, miller 1
3883738 1984831 1984831 defendant Denys Richard miller 594426 594426 Denys, Richard, of Benyngton, miller 3
3892844 1987854 1987854 defendant Hubberd Stephen laborer 594426 594426 Hubberd, Stephen, of Benyngton, laborer 2
3900052 1990239 1990239 defendant Fryskenay Richard gent 594426 594426 Fryskenay, Richard, of Benyngton, gent 0
3901088 1990589 1990589 plaintiff Clerke George   594426 594426 Clerke, George, of Benyngton 0
3911914 1994309 1994309 plaintiff Wolsay Alice gentlewoman 594426 594426 Wolsay, Alice, of Benyngton, gentlewoman 0
3921563 1997553 1997553 defendant Westland Richard husbandman 594426 594426 Westland, Richard, of Benyngton, husbandman 0
3965673 2012608 2012608 defendant Gylpyn Margaret widow 594426 594426 Gylpyn, Margaret, of Benyngton, widow 0
3970536 2014296 2014296 defendant Pynchebek Thomas husbandman 594426 594426 Pynchebek, Thomas, of Benyngton, husbandman 0
4092735 2057712 2057712 defendant Derbye William esq 594426 594426 Derbye, William, of Benyngton, esq 0
4118019 2066728 2066728 defendant Shepperd John yeoman 594426 594426 Shepperd, John, of Benyngton, yeoman 2
4170637 2085231 2085231 defendant Pygott John maltster 594426 594426 Pygott, John, of Benyngton, maltster 1
4187138 2090994 2090994 defendant Chaundler Edward yeoman 594426 594426 Chaundler, Edward, of Benyngton, yeoman 0
4220875 2102794 2102794 defendant Masson William   594426 594426 Masson, William, of Benyngton, malt carrier 3
4220937 2102817 2102817 defendant Masson William   594426 594426 Masson, William, of Benyngton, malt carrier 3
4221387 2102979 2102979 defendant Archer John carpenter 594426 594426 Archer, John, of Benyngton, yeoman, carpenter 0
4221481 2103005 2103005 defendant Archer John carpenter 594426 594426 Archer, John, of Benyngton, yeoman, carpenter 0
4221832 2103133 2103133 defendant Walker William yeoman 594426 594426 Walker, William, of Benyngton, yeoman 0
4221833 2103133 2103133 defendant Chaundler William yeoman 594426 594426 Chaundler, William, of Benyngton, yeoman 1
4221836 2103134 2103134 defendant Walker William yeoman 594426 594426 Walker, William, of Benyngton, yeoman 0
4221837 2103134 2103134 defendant Chaundler William yeoman 594426 594426 Chaundler, William, of Benyngton, yeoman 1
4234961 2107779 2107779 defendant Walker William husbandman 594426 594426 Walker, William, of Benyngton, husbandman 0
4235438 2107963 2107963 defendant Chandler William husbandman 594426 594426 Chandler, William, of Benyngton, husbandman 0
4235444 2107965 2107965 defendant Walker William yeoman 594426 594426 Walker, William, of Benyngton, yeoman 0
4239988 2109623 2109623 defendant Marson William   594426 594426 Marson, William, of Benyngton, malt carrier 0
4279355 2122704 2122704 defendant Marson or Marston John maltman 594426 594426 Marson or Marston, John, of Benyngton, maltman 1
4279356 2122704 2122704 defendant Same Thomas maltman 594426 594426 Same, Thomas, of Benyngton, maltman 2
4299494 2129910 2129910 defendant Younge Robert gent 594426 594426 Younge, Robert, of Benyngton, gent 0
4342349 2144598 2144598 defendant Bromeheade Edward yeoman 594426 594426 Bromeheade, Edward, of Benyngton, yeoman 2
4403718 2165817 2165817 defendant Foster Edward   594426 594426 Foster, Edward, of Benyngton, malt carrier 0
4417075 2170210 2170210 plaintiff Pycot Richard   594426 594426 Pycot, Richard, of Benyngton, parson 0
4433313 2175174 2175174 plaintiff Frensh Helen de   594426 594426 Frensh, Helen de, of Benyngton, formerly wife of Richard 0
4440933 2182086 2182086 defendant Brynyneham John   594426 594426 Brynyneham, John, of Benyngton, parson 0
4445507 2183548 2183548 defendant atte Parsons William   594426 594426 atte Parsons, William, of Benyngton 0
4445511 2183550 2183550 defendant atte Persons William   594426 594426 atte Persons, William, of Benyngton 0
4454198 2186328 2186328 plaintiff Loydon Margaret   594426 594426 Loydon, Margaret, of Benyngton, daughter of Nicola, formerly wife of Robert Loydon 0
4456840 2187151 2187151 defendant Coke Roger   594426 594426 Coke, Roger, of Benyngton, formerly servant of Michael Pole 0
4459984 2188177 2188177 plaintiff Segrave Robert de   594426 594426 Segrave, Robert de, of Benyngton, parson 0
4467192 2190411 2190411 defendant Devenysshe Robert   594426 594426 Devenysshe, Robert, of Benyngton 0
4478752 2194022 2194022 plaintiff Hoghton Roger (legal representative) 594426 594426 Hoghton, Roger, of Benyngton, vicar, administrator of 0
4483197 2195443 2195443 plaintiff Neweland John de   594426 594426 Neweland, John de, of Benyngton 0
4483199 2195443 2195443 defendant Jeffrey John   594426 594426 Jeffrey, John, of Benyngton 0
4498736 2200239 2200239 defendant Pakke William   594426 594426 Pakke, William, of Benyngton 0
4498737 2200239 2200239 defendant Belyngbroke Ralph de   594426 594426 Belyngbroke, Ralph de, of Benyngton 1
4511825 2204146 2204146 defendant Carter Robert   594426 594426 Carter, Robert, of Benyngton 0
4511826 2204146 2204146 defendant Davy Thomas   594426 594426 Davy, Thomas, of Benyngton 1
4524746 2208079 2208079 plaintiff Houghton Roger de (legal representative) 594426 594426 Houghton, Roger de, of Benyngton, vicar, administrator of 0
4553403 2216997 2216997 defendant Pakke William fishmonger 594426 594426 Pakke, William, of Benyngton, fishmonger 0
4553959 2217158 2217158 defendant Rose John   594426 594426 Rose, John, of Benyngton 4
4578340 2224716 2224716 defendant Jeffray William   594426 594426 Jeffray, William, of Benyngton 0
4579717 2225141 2225141 defendant Jeffray William   594426 594426 Jeffray, William, of Benyngton 0
4584139 2226458 2226458 defendant Jeffray William   594426 594426 Jeffray, William, of Benyngton 0
4585452 2226874 2226874 defendant Fytheler Alan   594426 594426 Fytheler, Alan, of Benyngton 0
4628919 2239976 2239976 defendant Sampson Robert   594426 594426 Sampson, Robert, of Benyngton 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);