names

179 rows where place_id = 640947

✎ 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
3858419 1976292 1976292 defendant Looke John pedder 640947 640947 Looke, John, of New Buckenham, pedder 1
3965458 2012533 2012533 defendant Godwyn Richard draper 640947 640947 Godwyn, Richard, of New Buckenham, draper 0
3967518 2013274 2013274 defendant Colman Rose widow 640947 640947 Colman, Rose, of New Buckenham, widow 2
3968319 2013551 2013551 plaintiff Chase William yeoman 640947 640947 Chase, William, of New Buckenham, yeoman 0
3972992 2015127 2015127 defendant Baldry Thomas   640947 640947 Baldry, Thomas, of New Buckenham, "sitwer" 1
3990665 2021413 2021413 defendant Chase William yeoman 640947 640947 Chase, William, of New Buckenham, yeoman 0
4016928 2030755 2030755 defendant Watt Richard yeoman 640947 640947 Watt, Richard, of New Buckenham, yeoman 3
4024027 2033297 2033297 defendant Chase William yeoman 640947 640947 Chase, William, of New Buckenham, yeoman 0
4024028 2033297 2033297 defendant Wharton Thomas beer brewer 640947 640947 Wharton, Thomas, of New Buckenham, beer brewer 1
4024029 2033297 2033297 defendant Dey Robert beer brewer 640947 640947 Dey, Robert, of New Buckenham, beer brewer 2
4026995 2034305 2034305 defendant Chase William yeoman 640947 640947 Chase, William, of New Buckenham, yeoman 1
4027000 2034306 2034306 defendant Chase William yeoman 640947 640947 Chase, William, of New Buckenham, yeoman 1
4041415 2039421 2039421 plaintiff Neve William tanner 640947 640947 Neve, William, of New Buckenham, tanner 0
4045991 2041012 2041012 defendant Fennyng William clerk 640947 640947 Fennyng, William, of New Buckenham, clerk 0
4045992 2041012 2041012 defendant Watt Richard yeoman 640947 640947 Watt, Richard, of New Buckenham, yeoman 1
4045994 2041013 2041013 defendant Fennyng William clerk 640947 640947 Fennyng, William, of New Buckenham, clerk 0
4045995 2041013 2041013 defendant Watt Richard yeoman 640947 640947 Watt, Richard, of New Buckenham, yeoman 1
4046007 2041016 2041016 defendant Gayton Robert tanner 640947 640947 Gayton, Robert, of New Buckenham, tanner 0
4046008 2041016 2041016 defendant Watt Richard yeoman 640947 640947 Watt, Richard, of New Buckenham, yeoman 1
4046011 2041017 2041017 defendant Gayton Robert tanner 640947 640947 Gayton, Robert, of New Buckenham, tanner 0
4046012 2041017 2041017 defendant Watt Richard yeoman 640947 640947 Watt, Richard, of New Buckenham, yeoman 1
4046021 2041019 2041019 defendant Gyldred William butcher 640947 640947 Gyldred, William, of New Buckenham, butcher 0
4046022 2041019 2041019 defendant Underwood Peter   640947 640947 Underwood, Peter, of New Buckenham, mason 1
4046023 2041019 2041019 defendant Fennyng William clerk 640947 640947 Fennyng, William, of New Buckenham, clerk 2
4046024 2041019 2041019 defendant Chase William yeoman 640947 640947 Chase, William, of New Buckenham, yeoman 3
4046057 2041028 2041028 defendant Gylderd William butcher 640947 640947 Gylderd, William, of New Buckenham, butcher 0
4046058 2041028 2041028 defendant Underwood Peter   640947 640947 Underwood, Peter, of New Buckenham, mason 1
4046060 2041028 2041028 defendant Chase William yeoman 640947 640947 Chase, William, of New Buckenham, yeoman 3
4046314 2041124 2041124 defendant Robard John yeoman 640947 640947 Robard, John, of New Buckenham, yeoman 0
4046315 2041124 2041124 defendant Fissher John carpenter 640947 640947 Fissher, John, of New Buckenham, carpenter 1
4046321 2041127 2041127 defendant Robard John singleman 640947 640947 Robard, John, of New Buckenham, yeoman, singleman 0
4046322 2041127 2041127 defendant Fyssher John carpenter 640947 640947 Fyssher, John, of New Buckenham, carpenter 1
4052433 2043290 2043290 defendant Fannyng William clerk 640947 640947 Fannyng, William, of New Buckenham, clerk 1
4055425 2044335 2044335 defendant Rumbold John husbandman 640947 640947 Rumbold, John, of New Buckenham, husbandman 0
4060515 2046162 2046162 defendant Verbe William smith 640947 640947 Verbe, William, of New Buckenham, smith 3
4073211 2050709 2050709 defendant Shalles William butcher 640947 640947 Shalles, William, of New Buckenham, butcher 0
4074264 2051093 2051093 defendant Yongman John butcher 640947 640947 Yongman, John, of New Buckenham, butcher 2
4078259 2052525 2052525 defendant Rysyng Robert cordwainer 640947 640947 Rysyng, Robert, of New Buckenham, cordwainer 3
4079392 2052933 2052933 defendant Margeris Francis hatter 640947 640947 Margeris, Francis, of New Buckenham, or of Stowe Market, hatter 1
4081174 2053577 2053577 defendant Watt Richard miller 640947 640947 Watt, Richard, of New Buckenham, miller 1
4081178 2053578 2053578 defendant Langdon Clement tailor 640947 640947 Langdon, Clement, of New Buckenham, tailor 1
4100881 2060632 2060632 defendant Neave William tanner 640947 640947 Neave, William, of New Buckenham, tanner 0
4103407 2061501 2061501 defendant Farrar Henry sawyer 640947 640947 Farrar, Henry, of New Buckenham, sawyer 2
4106668 2062676 2062676 defendant Mountigue Richard gent 640947 640947 Mountigue, Richard, of New Buckenham, gent 0
4108523 2063303 2063303 defendant Cullam Leonard   640947 640947 Cullam, Leonard, of New Buckenham, "rafeman" 3
4114933 2065629 2065629 defendant Neave Thomas yeoman 640947 640947 Neave, Thomas, of New Buckenham, yeoman 0
4115110 2065692 2065692 defendant Meggesonne Robert smith 640947 640947 Meggesonne, Robert, of New Buckenham, smith 2
4120681 2067676 2067676 defendant Mountigue Richard yeoman 640947 640947 Mountigue, Richard, of New Buckenham, yeoman 1
4129222 2070756 2070756 defendant Barrett alias Cockes James   640947 640947 Barrett alias Cockes, James, of New Buckenham, surgeon 0
4143764 2075980 2075980 defendant Mountigue Richard yeoman 640947 640947 Mountigue, Richard, of New Buckenham, yeoman 1
4144813 2076347 2076347 defendant Wayt Richard yeoman 640947 640947 Wayt, Richard, of New Buckenham, yeoman 1
4148391 2077567 2077567 defendant Lambard William tailor 640947 640947 Lambard, William, of New Buckenham, tailor 0
4149013 2077772 2077772 defendant Lamberd William tailor 640947 640947 Lamberd, William, of New Buckenham, tailor 1
4149345 2077896 2077896 defendant Watt Richard yeoman 640947 640947 Watt, Richard, of New Buckenham, yeoman 0
4149649 2078002 2078002 defendant Knyvett Edmund gent or esq 640947 640947 Knyvett, Edmund, of New Buckenham, gent or esq 0
4157938 2080846 2080846 defendant Payne Stephen, junior blacksmith 640947 640947 Payne, Stephen, junior, of New Buckenham, blacksmith 1
4158953 2081197 2081197 defendant Gayton Robert tanner 640947 640947 Gayton, Robert, of New Buckenham, tanner 1
4164730 2083173 2083173 defendant Atkyns Henry tanner 640947 640947 Atkyns, Henry, of New Buckenham, tanner 0
4164731 2083173 2083173 defendant Geyton Robert tanner 640947 640947 Geyton, Robert, of New Buckenham, tanner 1
4164971 2083256 2083256 defendant Keryson Richard joiner 640947 640947 Keryson, Richard, of New Buckenham, joiner 0
4167083 2083991 2083991 defendant Wharton Thomas yeoman 640947 640947 Wharton, Thomas, of New Buckenham, yeoman 0
4181194 2088900 2088900 defendant Wharton Thomas, junior yeoman 640947 640947 Wharton, Thomas, junior, of New Buckenham, yeoman 0
4188302 2091412 2091412 defendant Atkyns Henry tanner 640947 640947 Atkyns, Henry, of New Buckenham, tanner 0
4192165 2092823 2092823 defendant Eldred Thomas butcher 640947 640947 Eldred, Thomas, of New Buckenham, butcher 3
4192716 2093012 2093012 defendant Dey Robert innholder 640947 640947 Dey, Robert, of New Buckenham, innholder 0
4192717 2093012 2093012 defendant Spense Thomas butcher 640947 640947 Spense, Thomas, of New Buckenham, butcher 1
4192718 2093012 2093012 defendant Thurston Robert husbandman 640947 640947 Thurston, Robert, of New Buckenham, husbandman 2
4192719 2093012 2093012 defendant Evans Elizabeth widow 640947 640947 Evans, Elizabeth, of New Buckenham, widow 3
4193756 2093386 2093386 defendant Wharton William beer brewer 640947 640947 Wharton, William, of New Buckenham, beer brewer 1
4193757 2093386 2093386 defendant Wharton Thomas beer brewer 640947 640947 Wharton, Thomas, of New Buckenham, beer brewer 2
4194357 2093577 2093577 defendant Wharton Thomas yeoman 640947 640947 Wharton, Thomas, of New Buckenham, yeoman 0
4194879 2093771 2093771 defendant Webbe Margaret spinster 640947 640947 Webbe, Margaret, of New Buckenham, spinster 3
4198661 2095087 2095087 defendant Longe John, junior tailor 640947 640947 Longe, John, junior, of New Buckenham, tailor 0
4198662 2095087 2095087 defendant Kendall Thomas yeoman 640947 640947 Kendall, Thomas, of New Buckenham, yeoman 1
4198663 2095087 2095087 defendant Wright Edward husbandman 640947 640947 Wright, Edward, of New Buckenham, husbandman 2
4202127 2096290 2096290 defendant Lamberd William tailor 640947 640947 Lamberd, William, of New Buckenham, tailor 0
4202128 2096290 2096290 defendant Brande Gregory   640947 640947 Brande, Gregory, of New Buckenham, sieve maker 1
4204732 2097200 2097200 defendant Wase Roger husbandman 640947 640947 Wase, Roger, of New Buckenham, husbandman 2
4204733 2097200 2097200 defendant Whale Thomas   640947 640947 Whale, Thomas, of New Buckenham, point maker 3
4205758 2097563 2097563 defendant Browne Thomas   640947 640947 Browne, Thomas, of New Buckenham, mason 0
4208288 2098447 2098447 defendant Longe John tailor 640947 640947 Longe, John, of New Buckenham, tailor 2
4208671 2098583 2098583 defendant Hyde Robert chapman 640947 640947 Hyde, Robert, of New Buckenham, chapman 0
4212639 2099961 2099961 defendant Wharton Thomas, junior yeoman 640947 640947 Wharton, Thomas, junior, of New Buckenham, yeoman 0
4212640 2099961 2099961 defendant Dey Robert innholder 640947 640947 Dey, Robert, of New Buckenham, innholder 1
4212641 2099961 2099961 defendant Lamberd William tailor 640947 640947 Lamberd, William, of New Buckenham, tailor 2
4214814 2100685 2100685 defendant Feeke John miller 640947 640947 Feeke, John, of New Buckenham, miller 2
4214920 2100719 2100719 defendant Fysher Thomas baker 640947 640947 Fysher, Thomas, of New Buckenham, baker 3
4215179 2100804 2100804 defendant Youngeman John blacksmith 640947 640947 Youngeman, John, of New Buckenham, blacksmith 2
4215180 2100804 2100804 defendant Parrish William sawyer 640947 640947 Parrish, William, of New Buckenham, sawyer 3
4217050 2101458 2101458 defendant Dey George cooper 640947 640947 Dey, George, of New Buckenham, cooper 0
4217051 2101458 2101458 defendant Keryson Richard plumber 640947 640947 Keryson, Richard, of New Buckenham, plumber 1
4217052 2101458 2101458 defendant Walker Richard husbandman 640947 640947 Walker, Richard, of New Buckenham, husbandman 2
4217053 2101458 2101458 defendant Mayes William husbandman 640947 640947 Mayes, William, of New Buckenham, husbandman 3
4219621 2102368 2102368 defendant Wharton William yeoman 640947 640947 Wharton, William, of New Buckenham, yeoman 0
4222074 2103212 2103212 defendant Ens William tailor 640947 640947 Ens, William, of New Buckenham, tailor 0
4222076 2103212 2103212 defendant Tyler Thomas fishmonger 640947 640947 Tyler, Thomas, of New Buckenham, fishmonger 2
4222077 2103212 2103212 defendant Wolwarde Thomas carpenter 640947 640947 Wolwarde, Thomas, of New Buckenham, carpenter 3
4222311 2103293 2103293 defendant Rysinge Robert cordwainer 640947 640947 Rysinge, Robert, of New Buckenham, cordwainer 3
4222638 2103409 2103409 defendant Fysher Thomas beer brewer 640947 640947 Fysher, Thomas, of New Buckenham, beer brewer 0
4225805 2104490 2104490 defendant Underwood Peter   640947 640947 Underwood, Peter, of New Buckenham, rough mason 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);