names

120 rows where place_id = 598184

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631476 1904659 1904659 defendant Shreve Edmund carpenter 598184 598184 Shreve, Edmund, of Totyngton, carpenter 0
3648601 1909952 1909952 defendant Bray Thomas   598184 598184 Bray, Thomas, of Totyngton, worsted weaver 0
3679578 1919682 1919682 defendant Salter Edmund yeoman 598184 598184 Salter, Edmund, of Totyngton, yeoman 0
3680189 1919876 1919876 defendant Haweson John fuller 598184 598184 Haweson, John, of Totyngton, fuller 2
3703262 1927292 1927292 defendant Goodwyn John husbandman 598184 598184 Goodwyn, John, of Totyngton, husbandman 0
3722923 1933435 1933435 defendant Stede Henry yeoman 598184 598184 Stede, Henry, of Totyngton, yeoman 1
3722924 1933435 1933435 defendant Wryght John yeoman 598184 598184 Wryght, John, of Totyngton, yeoman 2
3745484 1940494 1940494 defendant Goodwyn Robert courtholder 598184 598184 Goodwyn, Robert, of Totyngton, courtholder 0
3747459 1941120 1941120 defendant Mendham Thomas clerk 598184 598184 Mendham, Thomas, of Totyngton, clerk 0
3800727 1958139 1958139 defendant Goodwyn John, senior husbandman 598184 598184 Goodwyn, John, senior, of Totyngton, husbandman 4
3827787 1966558 1966558 defendant Foster William (legal representative) 598184 598184 Foster, William, of Totyngton, tailor, executor of 0
3838425 1969938 1969938 plaintiff Tracy William (legal representative) 598184 598184 Tracy, William, of Totyngton, esq, executor of 0
3841396 1970890 1970890 defendant Stede John husbandman 598184 598184 Stede, John, of Totyngton, husbandman 0
3868738 1979784 1979784 defendant Stede John husbandman 598184 598184 Stede, John, of Totyngton, husbandman 0
3868739 1979784 1979784 defendant Smyth Thomas, senior   598184 598184 Smyth, Thomas, senior, of Totyngton, shepherd 1
3868740 1979784 1979784 defendant Smyth Thomas, junior smith 598184 598184 Smyth, Thomas, junior, of Totyngton, smith 2
3897172 1989272 1989272 defendant Warner Ralph husbandman 598184 598184 Warner, Ralph, of Totyngton, husbandman 2
3909266 1993391 1993391 defendant Frensham Edmund laborer 598184 598184 Frensham, Edmund, of Totyngton, laborer 2
3909268 1993391 1993391 defendant Alen Lawrence laborer 598184 598184 Alen, Lawrence, of Totyngton, laborer 4
3913265 1994766 1994766 defendant Sugar alias Clerke William husbandman 598184 598184 Sugar alias Clerke, William, of Totyngton, husbandman 1
3933139 2001377 2001377 plaintiff Goodwyn John (legal representative) 598184 598184 Goodwyn, John, of Totyngton, administrator of 0
3933141 2001377 2001377 defendant Stede William singleman 598184 598184 Stede, William, of Totyngton, singleman 0
3940642 2003877 2003877 plaintiff Stede John (legal representative) 598184 598184 Stede, John, of Totyngton, yeoman, executors of 0
3960165 2010658 2010658 plaintiff Stede John (legal representative) 598184 598184 Stede, John, of Totyngton, yeoman, executors of 0
3963724 2011918 2011918 defendant Nicoll John husbandman 598184 598184 Nicoll, John, of Totyngton, husbandman 0
3982214 2018403 2018403 defendant Baker Thomas tailor 598184 598184 Baker, Thomas, of Totyngton, tailor 0
3986913 2020063 2020063 defendant Serles Richard husbandman 598184 598184 Serles, Richard, of Totyngton, husbandman 0
3986918 2020064 2020064 defendant Serlys Richard husbandman 598184 598184 Serlys, Richard, of Totyngton, husbandman 0
4265826 2118210 2118210 defendant Sharpyn Thomas   598184 598184 Sharpyn, Thomas, of Totyngton, shepherd 2
4416852 2170140 2170140 defendant Danyel William   598184 598184 Danyel, William, of Totyngton 0
4418546 2170678 2170678 defendant Danyel William   598184 598184 Danyel, William, of Totyngton 0
4426709 2173166 2173166 defendant Danyel William   598184 598184 Danyel, William, of Totyngton 0
4430227 2174233 2174233 defendant Danyel William   598184 598184 Danyel, William, of Totyngton 0
4502234 2201296 2201296 defendant Markaunt Thomas   598184 598184 Markaunt, Thomas, of Totyngton 2
4509810 2203554 2203554 defendant Godan John   598184 598184 Godan, John, of Totyngton 0
4558925 2218752 2218752 defendant Darke Roger   598184 598184 Darke, Roger, of Totyngton 0
4614352 2235499 2235499 defendant Smyth Richard   598184 598184 Smyth, Richard, of Totyngton 5
4700587 2265594 2265594 defendant Narke Roger laborer 598184 598184 Narke, Roger, of Totyngton, laborer 0
4712132 2269106 2269106 defendant (not given) George his son, gent 598184 598184 George, his son, of Totyngton, gent 1
4716388 2270445 2270445 defendant Narke Roger laborer 598184 598184 Narke, Roger, of Totyngton, laborer 2
4766097 2285386 2285386 defendant Wroo John weaver 598184 598184 Wroo, John, of Totyngton, weaver 0
4773085 2287552 2287552 defendant Rykkys Stephen   598184 598184 Rykkys, Stephen, of Totyngton, wool man 0
4773496 2287681 2287681 defendant Wroo John weaver 598184 598184 Wroo, John, of Totyngton, weaver 0
4790500 2293121 2293121 defendant Wroo John weaver 598184 598184 Wroo, John, of Totyngton, weaver 0
4795754 2294823 2294823 defendant Daubeney John spicer 598184 598184 Daubeney, John, of Totyngton, spicer 3
4809211 2299055 2299055 defendant Torell John yeoman 598184 598184 Torell, John, of Totyngton, yeoman 0
4809213 2299056 2299056 defendant Torell John yeoman 598184 598184 Torell, John, of Totyngton, yeoman 0
4837188 2307584 2307584 defendant Gedhode Roger yeoman 598184 598184 Gedhode, Roger, of Totyngton, yeoman 1
4897824 2325983 2325983 defendant Reymers John husbandman 598184 598184 Reymers, John, of Totyngton, husbandman 1
4902536 2327411 2327411 defendant Reymers John husbandman 598184 598184 Reymers, John, of Totyngton, husbandman 1
4906516 2328624 2328624 defendant Danyell Richard husbandman 598184 598184 Danyell, Richard, of Totyngton, husbandman 0
4917571 2332011 2332011 defendant Scarburgh John husbandman 598184 598184 Scarburgh, John, of totyngton, husbandman 0
4930879 2336058 2336058 defendant Aleyn John yeoman 598184 598184 Aleyn, John, of Totyngton, yeoman 1
4945618 2340610 2340610 defendant Gedont or Gedout Roger yeoman 598184 598184 Gedont or Gedout, Roger, of Totyngton, yeoman 2
4949870 2341941 2341941 defendant Miles John husbandman 598184 598184 Miles, John, of Totyngton, husbandman 4
4995336 2355450 2355450 plaintiff Gedoth Roger   598184 598184 Gedoth, Roger, of Totyngton 0
4995337 2355450 2355450 plaintiff Potter William   598184 598184 Potter, William, of Totyngton 1
5017343 2361961 2361961 defendant Stamppe Thomas husbandman 598184 598184 Stamppe, Thomas, of Totyngton, husbandman 0
5017344 2361961 2361961 defendant Loove Thomas yeoman 598184 598184 Loove, Thomas, of Totyngton, yeoman 1
5029688 2365553 2365553 defendant Lely William   598184 598184 Lely, William, of Totyngton, servant 0
5043131 2369564 2369564 defendant Dawbeney Adam husbandman 598184 598184 Dawbeney, Adam, of Totyngton, husbandman 0
5047146 2370767 2370767 defendant Gedowte Roger yeoman 598184 598184 Gedowte, Roger, of Totyngton, yeoman 2
5047147 2370767 2370767 defendant Fareman William dyer 598184 598184 Fareman, William, of Totyngton, dyer 3
5049403 2371458 2371458 defendant Stampe Thomas husbandman 598184 598184 Stampe, Thomas, of Totyngton, husbandman 1
5049536 2371490 2371490 defendant Saryssone Henry   598184 598184 Saryssone, Henry, of Totyngton, shepherd 0
5056158 2373416 2373416 defendant Grace Thomas husbandman 598184 598184 Grace, Thomas, of Totyngton, husbandman 3
5059494 2374409 2374409 defendant Grace Thomas husbandman 598184 598184 Grace, Thomas, of Totyngton, husbandman 0
5069259 2377295 2377295 defendant Gedont or Gedout Roger yeoman 598184 598184 Gedont or Gedout, Roger, of Totyngton, yeoman 0
5069371 2377332 2377332 defendant Potter Richard weaver 598184 598184 Potter, Richard, of Totyngton, weaver 1
5088119 2382902 2382902 defendant Gedout ot Gedont Roger yeoman 598184 598184 Gedout ot Gedont, Roger, of Totyngton, yeoman 0
5088120 2382902 2382902 defendant Feryman William yeoman 598184 598184 Feryman, William, of Totyngton, yeoman 1
5093092 2384368 2384368 defendant Gedont or Gedout Roger yeoman 598184 598184 Gedont or Gedout, Roger, of Totyngton, yeoman 0
5093198 2384402 2384402 defendant Gedont of Gedout Roger husbandman 598184 598184 Gedont of Gedout, Roger, of Totyngton, husbandman 2
5095168 2385002 2385002 defendant Stampe Thomas husbandman 598184 598184 Stampe, Thomas, of Totyngton, husbandman 0
5100259 2386519 2386519 defendant Dawebeney Simon yeoman 598184 598184 Dawebeney, Simon, of Totyngton, yeoman 2
5100588 2386600 2386600 defendant Dobbys Robert husbandman 598184 598184 Dobbys, Robert, of Totyngton, husbandman 2
5114642 2390697 2390697 defendant Dobbys Robert husbandman 598184 598184 Dobbys, Robert, of Totyngton, husbandman 1
5114861 2390759 2390759 defendant Staumpe Thomas husbandman 598184 598184 Staumpe, Thomas, of Totyngton, husbandman 1
5118952 2391976 2391976 defendant Gedour ot Gedont Roger husbandman 598184 598184 Gedour ot Gedont, Roger, of Totyngton, husbandman 1
5126103 2394117 2394117 defendant Sampe Thomas husbandman 598184 598184 Sampe, Thomas, of Totyngton, husbandman 2
5146354 2400067 2400067 defendant Stampe Thomas husbandman 598184 598184 Stampe, Thomas, of Totyngton, husbandman 0
5152047 2401735 2401735 defendant Stampe Thomas husbandman 598184 598184 Stampe, Thomas, of Totyngton, husbandman 0
5159762 2403956 2403956 defendant Bullour Robert husbandman 598184 598184 Bullour, Robert, of Totyngton, husbandman 0
5161509 2404465 2404465 defendant Bullour Robert husbandman 598184 598184 Bullour, Robert, of Totyngton, husbandman 0
5162627 2404791 2404791 defendant Stampe Thomas husbandman 598184 598184 Stampe, Thomas, of Totyngton, husbandman 1
5171851 2407483 2407483 defendant Boston John   598184 598184 Boston, John, of Totyngton, vicar 1
5175889 2408629 2408629 defendant Bulloure Robert husbandman 598184 598184 Bulloure, Robert, of Totyngton, husbandman 0
5177776 2409204 2409204 defendant Dawbeney Simon   598184 598184 Dawbeney, Simon, of Totyngton, worsted weaver 0
5177777 2409204 2409204 defendant Potter William   598184 598184 Potter, William, of Totyngton, worsted weaver 1
5177778 2409204 2409204 defendant Potter Geoffrey   598184 598184 Potter, Geoffrey, of Totyngton, worsted weaver 2
5207011 2417788 2417788 defendant Boston John   598184 598184 Boston, John, of Totyngton, vicar 1
5232920 2425212 2425212 defendant Stampe Thomas husbandman 598184 598184 Stampe, Thomas, of Totyngton, husbandman 3
5232922 2425212 2425212 defendant Wythe Roger husbandman 598184 598184 Wythe, Roger, of Totyngton, husbandman 5
5253032 2431053 2431053 defendant Portlond John yeoman 598184 598184 Portlond, John, of Totyngton, yeoman 4
5254321 2431479 2431479 defendant Portlond John yeoman 598184 598184 Portlond, John, of Totyngton, yeoman 4
5266428 2435247 2435247 defendant Hadsey Richard clerk 598184 598184 Hadsey, Richard, of Totyngton, clerk 0
5281424 2439637 2439637 defendant Sewale William husbandman 598184 598184 Sewale, William, of Totyngton, husbandman 0
5290943 2442354 2442354 defendant Norwiche Nicholas husbandman 598184 598184 (Norwiche, Nicholas, of Totyngton, husbandman 1
5290944 2442354 2442354 defendant Codyngham John husbandman 598184 598184 Codyngham, John, of Totyngton, husbandman 2
5290947 2442354 2442354 defendant Halys William clerk 598184 598184 Halys, William, of Totyngton, clerk 5

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