names

155 rows where place_id = 586362

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588525 1864055 1864055 defendant Hunne Robert smith 586362 586362 Hunne, Robert, of Bungey, Suff, smith 1
3603457 1868746 1868746 defendant Rycher John yeoman 586362 586362 Rycher, John, of Bungey, Suff, yeoman 2
3603526 1868770 1868770 defendant Valey Simon, senior sherman 586362 586362 Valey, Simon, senior, of Bungey, Suff, sherman 0
3607070 1869876 1869876 defendant Sewale Peter chapman 586362 586362 Sewale, Peter, of Bungey, Suff, chapman 0
3627373 1903415 1903415 defendant Johnson Robert husbandman 586362 586362 Johnson, Robert, of Bungey, Suff, husbandman 0
3633096 1905163 1905163 plaintiff Rychers John   586362 586362 Rychers, John, of Bungey, Suff 1
3641480 1907793 1907793 defendant Fulcher Robert tailor 586362 586362 Fulcher, Robert, of Bungey, Suff, tailor 0
3641619 1907839 1907839 defendant George John gent 586362 586362 George, John, of Bungey, Suff, gent 0
3641667 1907852 1907852 plaintiff Brende Robert   586362 586362 Brende, Robert, of Bungey, Suff 0
3647856 1909726 1909726 defendant Brende John yeoman 586362 586362 Brende, John, of Bungey, Suff, yeoman 0
3647870 1909729 1909729 defendant Bronde John yeoman 586362 586362 Bronde, John, of Bungey, Suff, yeoman 4
3664896 1914966 1914966 defendant Codlyng Bonaventura chaplain 586362 586362 Codlyng, Bonaventura, of Bungey, Suff, chaplain 1
3668370 1916054 1916054 defendant Saunderson Peter mercer 586362 586362 Saunderson, Peter, of Bungey, Suff, mercer 0
3675646 1918418 1918418 defendant Fulcher Robert yeoman 586362 586362 Fulcher, Robert, of Bungey, Suff, yeoman 1
3689211 1922792 1922792 plaintiff Elys Richard tanner 586362 586362 Elys, Richard, of Bungey, Suff, tanner 0
3700759 1926490 1926490 defendant Jeorge John yeoman 586362 586362 Jeorge, John, of Bungey, Suff, yeoman 0
3705116 1927889 1927889 defendant Goddyng Thomas yeoman 586362 586362 Goddyng, Thomas, of Bungey, Suff, yeoman 1
3711581 1929931 1929931 defendant Rede John husbandman 586362 586362 Rede, John, of Bungey, Suff, husbandman 0
3716246 1931373 1931373 defendant Man Robert carpenter 586362 586362 Man, Robert, of Bungey, Suff, carpenter 0
3718711 1932130 1932130 defendant Somereshale John smith 586362 586362 Somereshale, John, of Bungey, Suff, smith 0
3730680 1935831 1935831 defendant Denham William dyer 586362 586362 Denham, William, of Bungey, Suff, dyer 0
3739370 1938520 1938520 defendant Warde James mercer 586362 586362 Warde, James, of Bungey, Suff, mercer 0
3751945 1942524 1942524 defendant Warde James mercer 586362 586362 Warde, James, of Bungey, Suff, mercer 0
3756655 1944061 1944061 defendant Hapton Philip fuller 586362 586362 Hapton, Philip, of Bungey, Suff, fuller 1
3764492 1946556 1946556 defendant Body William chapman 586362 586362 Body, William, of Bungey, Suff, chapman 3
3768369 1947750 1947750 defendant Warde James mercer 586362 586362 Warde, James, of Bungey, Suff, mercer 0
3770701 1948518 1948518 defendant Bremer Nicholas mercer 586362 586362 Bremer, Nicholas, of Bungey, Suff, mercer 2
3778218 1950894 1950894 defendant Riches John mercer 586362 586362 Riches, John, of Bungey, Suff, mercer 4
3781812 1952057 1952057 defendant Dene John yeoman 586362 586362 Dene, John, of Bungey, Suff, yeoman 0
3787151 1953771 1953771 defendant Hagon William barker 586362 586362 Hagon, William, of Bungey, Suff, barker 2
3793528 1955840 1955840 defendant Boode William chapman 586362 586362 Boode, William, of Bungey, Suff, chapman 1
3793545 1955842 1955842 defendant Bremer Nicholas chapman 586362 586362 Bremer, Nicholas, of Bungey, Suff, chapman 2
3795774 1956546 1956546 defendant Smuth John dyer 586362 586362 Smuth, John, of Bungey, Suff, dyer 1
3800095 1957954 1957954 defendant Bene William butcher 586362 586362 Bene, William, of Bungey, Suff, butcher 3
3810310 1961116 1961116 defendant Boode William mercer 586362 586362 Boode, William, of Bungey, Suff, mercer 0
3815929 1962887 1962887 defendant Todde Thomas cooper 586362 586362 Todde, Thomas, of Bungey, Suff, cooper 0
3822748 1965016 1965016 defendant Boode William mercer 586362 586362 Boode, William, of Bungey, Suff, mercer 0
3825585 1965853 1965853 defendant Dene John   586362 586362 Dene, John, of Bungey, Suff, worsted weaver 2
3838637 1970010 1970010 defendant Wharton Richard esq 586362 586362 Wharton, Richard, of Bungey, Suff, esq 0
3849746 1973509 1973509 defendant Smyth John dyer 586362 586362 Smyth, John, of Bungey, Suff, dyer 0
3852671 1974442 1974442 defendant Lane Roger mercer 586362 586362 Lane, Roger, of Bungey, Suff, mercer 1
3853848 1974836 1974836 plaintiff Stobbis Andrew   586362 586362 Stobbis, Andrew, of Bungey, Suff 0
3856849 1975769 1975769 defendant Code John hardwareman 586362 586362 Code, John, of Bungey, Suff, hardwareman 0
3857014 1975827 1975827 defendant Lane Roger merchant 586362 586362 Lane, Roger, of Bungey, Suff, merchant 0
3857017 1975828 1975828 defendant Lane Roger merchant 586362 586362 Lane, Roger, of Bungey, Suff, merchant 0
3858170 1976211 1976211 defendant Revet William butcher 586362 586362 Revet, William, of Bungey, Suff, butcher 0
3861909 1977442 1977442 defendant Woodcooke Thomas sherman 586362 586362 Woodcooke, Thomas, of Bungey, Suff, sherman 0
3867048 1979218 1979218 defendant Lane Roger mercer 586362 586362 Lane, Roger, of Bungey, Suff, mercer 0
3870221 1980288 1980288 defendant Codde John mercer 586362 586362 Codde, John, of Bungey, Suff, mercer 0
3870224 1980289 1980289 defendant Coodde John mercer 586362 586362 Coodde, John, of Bungey, Suff, mercer 0
3871135 1980597 1980597 defendant Stubbis Andrew gent 586362 586362 Stubbis, Andrew, of Bungey, Suff, gent 0
3871551 1980726 1980726 defendant Frosten John yeoman 586362 586362 Frosten, John, of Bungey, Suff, yeoman 2
3871664 1980759 1980759 defendant Frosten John yeoman 586362 586362 Frosten, John, of Bungey, Suff, yeoman 1
3879775 1983492 1983492 defendant Denny Christopher pinner 586362 586362 Denny, Christopher, of Bungey, Suff, pinner 0
3880968 1983905 1983905 defendant Leche Nicholas husbandman 586362 586362 Leche, Nicholas, of Bungey, Suff, husbandman 0
3881883 1984194 1984194 defendant Boton Nicholas tanner 586362 586362 Boton, Nicholas, of Bungey, Suff, tanner 1
3897428 1989352 1989352 defendant Pakke John stainer 586362 586362 Pakke, John, of Bungey, Suff, stainer 3
3897495 1989375 1989375 defendant Cod John yeoman 586362 586362 Cod, John, of Bungey, Suff, yeoman 0
3897498 1989376 1989376 defendant Codde John yeoman 586362 586362 Codde, John, of Bungey, Suff, yeoman 0
3913818 1994968 1994968 defendant Gowen John tailor 586362 586362 Gowen, John, of Bungey, Suff, tailor 0
3946359 2005800 2005800 plaintiff Button Edward yeoman 586362 586362 Button, Edward, of Bungey, Suff, yeoman 0
3991085 2021575 2021575 defendant Back Richard yeoman 586362 586362 Back, Richard, of Bungey, Suff, yeoman 2
3994367 2022738 2022738 defendant Back Richard yeoman 586362 586362 Back, Richard, of Bungey, Suff, yeoman 2
4024812 2033556 2033556 defendant Sudborne Walter (legal representative) 586362 586362 Sudborne, Walter, of Bungey, Suff, merchant, executors of 0
4102985 2061357 2061357 defendant Sherdelowe Leonard gent 586362 586362 Sherdelowe, Leonard, of Bungey, Suff, gent 0
4110892 2064150 2064150 defendant Woode John cooper 586362 586362 Woode, John, of Bungey, Suff, cooper 0
4116751 2066289 2066289 defendant Odbye William chapman 586362 586362 Odbye, William, of Bungey, Suff, chapman 0
4118606 2066948 2066948 defendant Cocke Robert weaver 586362 586362 Cocke, Robert, of Bungey, Suff, weaver 0
4121341 2067929 2067929 defendant Stannard Nicholas butcher 586362 586362 Stannard, Nicholas, of Bungey, Suff, butcher 1
4216432 2101242 2101242 defendant Killingworth William grocer 586362 586362 Killingworth, William, of Bungey, Suff, grocer 3
4305698 2132130 2132130 defendant Palmer Henry draper 586362 586362 Palmer, Henry, of Bungey, Suff, draper 1
4316974 2136052 2136052 defendant Smith John yeoman 586362 586362 Smith, John, of Bungey, Suff, yeoman 1
4328944 2139992 2139992 defendant Palmer Henry chapman 586362 586362 Palmer, Henry, of Bungey, Suff, chapman 1
4352977 2148270 2148270 defendant Kempe Edmund yeoman 586362 586362 Kempe, Edmund, of Bungey, Suff, yeoman 3
4389946 2161262 2161262 defendant Bulwer Winifred widow 586362 586362 (Bulwer, Winifred, of Bungey, Suff, widow 1
4393764 2162516 2162516 defendant Bray Richard butcher 586362 586362 Bray, Richard, of Bungey, Suff, butcher 1
4407234 2166984 2166984 defendant Palmer John draper 586362 586362 Palmer, John, of Bungey, Suff, draper 0
4674296 2257569 2257569 defendant Smyth Richard yeoman 586362 586362 Smyth, Richard, of Bungey, Suff, yeoman 1
4676155 2258155 2258155 defendant Balastre John fuller 586362 586362 Balastre, John, of Bungey, Suff, fuller 3
4775618 2288369 2288369 defendant Lardener Anne widow 586362 586362 Lardener, Anne, of Bungey, Suff, widow 1
4800296 2296271 2296271 defendant Culpy Adam husbandman 586362 586362 Culpy, Adam, of Bungey, Suff, husbandman 3
4829699 2305335 2305335 defendant Antell Robert baker 586362 586362 Antell, Robert, of Bungey, Suff, baker 0
4858547 2314046 2314046 defendant Aleyn John husbandman 586362 586362 Aleyn, John, of Bungey, Suff, husbandman 1
4912056 2330272 2330272 defendant Couper Willam chapman 586362 586362 Couper, Willam, of Bungey, Suff, chapman 1
4919280 2332539 2332539 defendant Aleyn John yeoman 586362 586362 Aleyn, John, of Bungey, Suff, yeoman 4
4931981 2336389 2336389 defendant Aleyn John mercer 586362 586362 Aleyn, John, of Bungey, Suff, mercer 3
4933074 2336737 2336737 defendant Aleyn John yeoman 586362 586362 Aleyn, John, of Bungey, Suff, yeoman 0
4937796 2338206 2338206 defendant Nerlynge John dyer 586362 586362 Nerlynge, John, of Bungey, Suff, dyer 0
4944850 2340378 2340378 defendant Goram Nicholas yeoman 586362 586362 Goram, Nicholas, of Bungey, Suff, yeoman 0
4946038 2340747 2340747 defendant Culpy Adam husbandman 586362 586362 Culpy, Adam, of Bungey, Suff, husbandman 3
4976230 2349842 2349842 defendant de Burnynghill John esq 586362 586362 de Burnynghill, John, of Bungey, Suff, esq 0
4983105 2351851 2351851 defendant Sadeler Ralph saddler 586362 586362 Sadeler, Ralph, of Bungey, Suff, saddler 0
5012958 2360623 2360623 defendant atte Ker Denis husbandman 586362 586362 atte Ker, Denis, of Bungey, Suff, or of Burgh juxta Bryston, Norf, husbandman 0
5032988 2366537 2366537 defendant Brandon William esq 586362 586362 Brandon, William, of Bungey, Suff, esq 0
5063380 2375573 2375573 defendant Aleyn John chandler 586362 586362 Aleyn, John, of Bungey, Suff, chandler 1
5063412 2375581 2375581 defendant Aleyn John chandler 586362 586362 Aleyn, John, of Bungey, Suff, chandler 1
5067345 2376741 2376741 defendant Waryn Thomas dyer 586362 586362 Waryn, Thomas, of Bungey, Suff, dyer 0
5075611 2379204 2379204 defendant Hardyng John yeoman 586362 586362 Hardyng, John, of Bungey, Suff, yeoman 0
5083509 2381569 2381569 defendant Brett Thomas husbandman 586362 586362 Brett, Thomas, of Bungey, Suff, husbandman 0
5107110 2388509 2388509 defendant Raye William yeoman 586362 586362 Raye, William, of Bungey, Suff, yeoman 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);