names

335 rows where place_id = 586363

✎ 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
3588526 1864055 1864055 defendant Wodcok Robert dyer 586363 586363 Wodcok, Robert, of Bungey, dyer 2
3624444 1875180 1875180 defendant Wyngefeld Robert gent 586363 586363 Wyngefeld, Robert, of Bungey, gent 0
3624447 1875181 1875181 defendant Wyngefeld Robert gent 586363 586363 Wyngefeld, Robert, of Bungey, gent 0
3632992 1905138 1905138 defendant Gooram Geoffrey   586363 586363 Gooram, Geoffrey, of Bungey, paten maker 0
3632993 1905138 1905138 defendant Welles Thomas tailor 586363 586363 Welles, Thomas, of Bungey, tailor 1
3633098 1905163 1905163 defendant Edon Adam yeoman 586363 586363 Edon, Adam, of Bungey, yeoman 1
3633161 1905184 1905184 defendant Wharton Richard gent 586363 586363 Wharton, Richard, of Bungey, gent 0
3635094 1905774 1905774 defendant Hamerton Elizabeth spinster 586363 586363 Hamerton, Elizabeth, of Bungey, spinster 2
3639528 1907171 1907171 defendant Felde William weaver 586363 586363 Felde, William, of Bungey, weaver 1
3641106 1907663 1907663 defendant Felde John mercer 586363 586363 Felde, John, of Bungey, mercer 1
3641620 1907839 1907839 defendant Atkynson Robert yeoman 586363 586363 Atkynson, Robert, of Bungey, yeoman 1
3643842 1908502 1908502 defendant Elwyn Henry yeoman 586363 586363 Elwyn, Henry, of Bungey, yeoman 0
3649525 1910241 1910241 defendant Dowsyng John husbandman 586363 586363 Dowsyng, John, of Bungey, husbandman 0
3658426 1912886 1912886 defendant Brende Robert yeoman 586363 586363 Brende, Robert, of Bungey, butcher. Osforthe, William, of Cretfeld, yeoman 0
3664886 1914963 1914963 defendant Brodfote John husbandman 586363 586363 Brodfote, John, of Bungey, husbandman 0
3664888 1914964 1914964 defendant Codlyng Bonaventura chaplain 586363 586363 Codlyng, Bonaventura, of Bungey, chaplain 0
3664892 1914965 1914965 defendant Felde Edmund husbandman 586363 586363 Felde, Edmund, of Bungey, husbandman 2
3664904 1914969 1914969 defendant Felde Edmund husbandman 586363 586363 Felde, Edmund, of Bungey, husbandman 2
3664905 1914969 1914969 defendant Foster Thomas husbandman 586363 586363 Foster, Thomas, of Bungey, husbandman 3
3664908 1914970 1914970 defendant Felde Edmund husbandman 586363 586363 Felde, Edmund, of Bungey, husbandman 1
3664909 1914970 1914970 defendant Foster Thomas husbandman 586363 586363 Foster, Thomas, of Bungey, husbandman 2
3664912 1914971 1914971 defendant Felde Edmund husbandman 586363 586363 Felde, Edmund, of Bungey, husbandman 0
3664915 1914972 1914972 defendant Felde Edmund husbandman 586363 586363 Felde, Edmund, of Bungey, husbandman 0
3671707 1917135 1917135 defendant Corys John thatcher 586363 586363 Corys, John, of Bungey, thatcher 2
3678579 1919358 1919358 defendant Kyppyng Nicholas husbandman 586363 586363 Kyppyng, Nicholas, of Bungey, husbandman 0
3679316 1919592 1919592 defendant Kyppyng Nicholas husbandman 586363 586363 Kyppyng, Nicholas, of Bungey, husbandman 0
3680274 1919904 1919904 defendant Greystok Reginald   586363 586363 Greystok, Reginald, of Bungey, parchment maker 0
3680766 1920066 1920066 plaintiff Rychers John merchant 586363 586363 Rychers, John, of Bungey, merchant 0
3684134 1921173 1921173 defendant Denny Christopher mercer 586363 586363 Denny, Christopher, of Bungey, mercer 3
3696593 1925168 1925168 defendant Suthall Richard yeoman 586363 586363 Suthall, Richard, of Bungey, yeoman 0
3698322 1925695 1925695 plaintiff Vynys John   586363 586363 Vynys, John, of Bungey 0
3704706 1927759 1927759 defendant Boyse John smith 586363 586363 Boyse, John, of Bungey, smith 1
3704707 1927759 1927759 defendant Saunderson Peter mercer 586363 586363 Saunderson, Peter, of Bungey, mercer 2
3709818 1929387 1929387 defendant Crakenthorp John dyer 586363 586363 Crakenthorp, John, of Bungey, dyer 0
3709819 1929387 1929387 defendant Goldsmyth John yeoman 586363 586363 Goldsmyth, John, of Bungey, yeoman 1
3709824 1929388 1929388 defendant Crakenthorp John dyer 586363 586363 Crakenthorp, John, of Bungey, dyer 0
3709825 1929388 1929388 defendant Goldsmyth John yeoman 586363 586363 Goldsmyth, John, of Bungey, yeoman 1
3715028 1930996 1930996 plaintiff Brende John baker 586363 586363 Brende, John, of Bungey, baker 0
3715029 1930996 1930996 defendant Denham John dyer 586363 586363 Denham, John, of Bungey, dyer 0
3715030 1930996 1930996 defendant Bradefote John husbandman 586363 586363 Bradefote, John, of Bungey, husbandman 1
3723195 1933525 1933525 defendant Thorp William husbandman 586363 586363 Thorp, William, of Bungey, husbandman 0
3725027 1934111 1934111 defendant Glede Richard smith 586363 586363 Glede, Richard, of Bungey, smith 1
3730542 1935789 1935789 plaintiff Brend Richard (legal representative) 586363 586363 Brend, Richard, of Bungey, executor of 0
3730545 1935789 1935789 defendant Brodfote John husbandman 586363 586363 Brodfote, John, of Bungey, husbandman 1
3730546 1935789 1935789 defendant Brend John baker 586363 586363 Brend, John, of Bungey, baker 2
3730550 1935791 1935791 plaintiff Brende John baker 586363 586363 Brende, John, of Bungey, baker 0
3730552 1935792 1935792 plaintiff Brende John baker 586363 586363 Brende, John, of Bungey, baker 0
3730681 1935831 1935831 defendant Baysse John smith 586363 586363 Baysse, John, of Bungey, smith 1
3733510 1936726 1936726 plaintiff Elice Richard (legal representative) 586363 586363 Elice, Richard, of Bungey, executors of 0
3733515 1936727 1936727 plaintiff Elice Richard (legal representative) 586363 586363 Elice, Richard, of Bungey, executors of 0
3733719 1936794 1936794 defendant Dalyson Richard clerk 586363 586363 Dalyson, Richard, of Bungey, clerk 0
3745248 1940422 1940422 defendant Brodfote John husbandman 586363 586363 Brodfote, John, of Bungey, husbandman 0
3746668 1940869 1940869 defendant Man Robert carpenter 586363 586363 Man, Robert, of Bungey, carpenter 2
3747452 1941118 1941118 plaintiff Elys Richard (legal representative) 586363 586363 Elys, Richard, of Bungey, executors of 0
3747492 1941132 1941132 plaintiff Esthawe alias Estowe William   586363 586363 Esthawe alias Estowe, William, of Bungey 0
3747496 1941133 1941133 plaintiff Esthawe William   586363 586363 Esthawe, William, of Bungey 0
3747901 1941266 1941266 defendant Butte Thomas sawyer 586363 586363 Butte, Thomas, of Bungey, sawyer 0
3748177 1941360 1941360 plaintiff Gase Thomas (legal representative) 586363 586363 Gase, Thomas, of Bungey, executrix of 0
3748180 1941361 1941361 plaintiff Gase Thomas (legal representative) 586363 586363 Gase, Thomas, of Bungey, executrix of 0
3749041 1941631 1941631 plaintiff Hatton John saddler 586363 586363 Hatton, John, of Bungey, saddler 0
3751940 1942522 1942522 defendant Fulcher Robert (legal representative) 586363 586363 Fulcher, Robert, of Bungey, executrix of 0
3751941 1942522 1942522 defendant Fulcher Ellen widow 586363 586363 Fulcher, Ellen, of Bungey, widow 1
3756046 1943845 1943845 defendant Gryffyth John pardoner 586363 586363 Gryffyth, John, of Bungey, pardoner 1
3756540 1944023 1944023 plaintiff Atton alias Hatton John saddler 586363 586363 Atton alias Hatton, John, of Bungey, saddler 0
3760113 1945158 1945158 defendant Man Robert carpenter 586363 586363 Man, Robert, of Bungey, carpenter 2
3761247 1945520 1945520 plaintiff Elys Richard (legal representative) 586363 586363 Elys, Richard, of Bungey, executors of 0
3761249 1945520 1945520 defendant Vynes John merchant 586363 586363 Vynes, John, of Bungey, merchant 0
3767064 1947359 1947359 defendant Johnson Robert husbandman 586363 586363 Johnson, Robert, of Bungey, husbandman 0
3780462 1951622 1951622 plaintiff Gase Thomas (legal representative) 586363 586363 Gase, Thomas, of Bungey, executrix of 0
3780465 1951623 1951623 plaintiff Gase Thomas (legal representative) 586363 586363 Gase, Thomas, of Bungey, executrix of 0
3780469 1951624 1951624 plaintiff Gase Thomas (legal representative) 586363 586363 Gase, Thomas, of Bungey, executrix of 0
3780658 1951678 1951678 defendant Gase Thomas (legal representative) 586363 586363 Gase, Thomas, of Bungey, merchant, executrix of 0
3780659 1951678 1951678 defendant Gase Sybil widow 586363 586363 Gase, Sybil, of Bungey, widow 1
3780661 1951679 1951679 defendant Gase Thomas (legal representative) 586363 586363 Gase, Thomas, of Bungey, merchant, executrix of 0
3780662 1951679 1951679 defendant Gase Sybil widow 586363 586363 Gase, Sybil, of Bungey, widow 1
3781813 1952057 1952057 defendant Todde Thomas cooper 586363 586363 Todde, Thomas, of Bungey, cooper 1
3793504 1955833 1955833 defendant Bode William mercer 586363 586363 Bode, William, of Bungey, mercer 0
3796240 1956688 1956688 defendant Payn William husbandman 586363 586363 Payn, William, of Bungey, husbandman 1
3800122 1957961 1957961 defendant Underwode John husbandman 586363 586363 Underwode, John, of Bungey, husbandman 1
3801598 1958399 1958399 defendant Wrote John mercer or draper 586363 586363 Wrote, John, of Bungey, mercer or draper 0
3803921 1959140 1959140 defendant Bradwell Nicholas shoemaker 586363 586363 Bradwell, Nicholas, of Bungey, shoemaker 0
3807262 1960169 1960169 defendant Pake John painter 586363 586363 Pake, John, of Bungey, painter 0
3807532 1960264 1960264 plaintiff Wryght Anthony   586363 586363 Wryght, Anthony, of Bungey 0
3810309 1961116 1961116 plaintiff Brende John baker 586363 586363 Brende, John, of Bungey, baker 0
3810312 1961117 1961117 plaintiff Brende John yeoman 586363 586363 Brende, John, of Bungey, yeoman 0
3822749 1965016 1965016 defendant Wharton Richard gent 586363 586363 Wharton, Richard, of Bungey, gent 1
3827535 1966475 1966475 plaintiff Brende John baker 586363 586363 Brende, John, of Bungey, baker 0
3836421 1969300 1969300 plaintiff Richers Agnes   586363 586363 Richers, Agnes, of Bungey, widow, administrators of 0
3837167 1969526 1969526 defendant Molle Thomas butcher 586363 586363 Molle, Thomas, of Bungey, butcher 0
3837168 1969526 1969526 defendant Bemonde John husbandman 586363 586363 Bemonde, John, of Bungey, husbandman 1
3842962 1971335 1971335 defendant Paynter John chaplain 586363 586363 Paynter, John, of Bungey, chaplain 0
3842963 1971335 1971335 defendant Peynter William chaplain 586363 586363 Peynter, William, of Bungey, chaplain 1
3850210 1973658 1973658 defendant Pynner Robert pinner 586363 586363 Pynner, Robert, of Bungey, pinner 2
3853170 1974611 1974611 defendant Molle Thomas butcher 586363 586363 Molle, Thomas, of Bungey, butcher 0
3853171 1974611 1974611 defendant Bemond John husbandman 586363 586363 Bemond, John, of Bungey, husbandman 1
3853611 1974758 1974758 defendant Molle Thomas butcher 586363 586363 Molle, Thomas, of Bungey, butcher 1
3857015 1975827 1975827 defendant Breke William   586363 586363 Breke, William, of Bungey, mercer, Coode, John, of Nungey, wax chandler 1
3857018 1975828 1975828 defendant Broke William mercer 586363 586363 Broke, William, of Bungey, mercer 1
3857019 1975828 1975828 defendant Code John   586363 586363 Code, John, of Bungey, wax chandler 2
3857339 1975927 1975927 defendant Bremer Nicholas mercer 586363 586363 Bremer, Nicholas, of Bungey, mercer 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);