names

111 rows where place_id = 601693

✎ 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
3646571 1909329 1909329 defendant Whityng John yeoman 601693 601693 Whityng, John, of Capell, yeoman 0
3663388 1914473 1914473 defendant Geddyng Henry husbandman 601693 601693 Geddyng, Henry, of Capell, husbandman 0
3667580 1915803 1915803 defendant Whutyng John yeoman 601693 601693 Whutyng, John, of Capell, yeoman 2
3689439 1922855 1922855 defendant Walter Richard husbandman 601693 601693 Walter, Richard, of Capell, husbandman 0
3690784 1923283 1923283 defendant Mowrar Nicholas husbandman 601693 601693 Mowrar, Nicholas, of Capell, husbandman 1
3695680 1924880 1924880 defendant Bowrege Richard husbandman 601693 601693 Bowrege, Richard, of Capell, husbandman 0
3697118 1925319 1925319 defendant Skeete Robert husbandman 601693 601693 Skeete, Robert, of Capell, husbandman 0
3697119 1925319 1925319 defendant Vynnor William husbandman 601693 601693 Vynnor, William, of Capell, husbandman 1
3697120 1925319 1925319 defendant geddyng Henry husbandman 601693 601693 geddyng, Henry, of Capell, husbandman 2
3728059 1935035 1935035 defendant Wulwarde Stephen husbandman 601693 601693 Wulwarde, Stephen, of Capell, husbandman 1
3741412 1939181 1939181 defendant Lodbroke Roger butcher 601693 601693 Lodbroke, Roger, of Capell, butcher 0
3742962 1939647 1939647 defendant Cole John laborer 601693 601693 Cole, John, of Capell, laborer 4
3742963 1939647 1939647 defendant Exe Robert laborer 601693 601693 Exe, Robert, of Capell, laborer 5
3746420 1940800 1940800 defendant Geddyng Henry husbandman 601693 601693 Geddyng, Henry, of Capell, husbandman 0
3752825 1942809 1942809 defendant Lodbroke Roger husbandman 601693 601693 Lodbroke, Roger, of Capell, husbandman 0
3759749 1945041 1945041 defendant Goddyng Henry husbandman 601693 601693 Goddyng, Henry, of Capell, husbandman 0
3769465 1948110 1948110 defendant Bowregge Henry yeoman 601693 601693 Bowregge, Henry, of Capell, yeoman 0
3769466 1948110 1948110 defendant Walter Richard husbandman 601693 601693 Walter, Richard, of Capell, husbandman 1
3776748 1950473 1950473 defendant Bysshop Thomas husbandman 601693 601693 Bysshop, Thomas, of Capell, husbandman 0
3781594 1951980 1951980 defendant Wyllyams John clothmaker 601693 601693 Wyllyams, John, of Capell, clothmaker 0
3781596 1951981 1951981 defendant Wyllyams John clothmaker 601693 601693 Wyllyams, John, of Capell, clothmaker 0
3788267 1954126 1954126 defendant Baker Robert husbandman 601693 601693 Baker, Robert, of Capell, husbandman 3
3825347 1965781 1965781 defendant Bowregge Michael (legal representative) 601693 601693 Bowregge, Michael, of Capell, husbandman, executors of 0
3825356 1965782 1965782 defendant Bowregge Michael (legal representative) 601693 601693 Bowregge, Michael, of Capell, husbandman, executors of 0
3828335 1966738 1966738 defendant Baldwyn William husbandman 601693 601693 Baldwyn, William, of Capell, husbandman 1
3830259 1967358 1967358 defendant Stryngfelawe Robert clerk 601693 601693 Stryngfelawe, Robert, of Capell, clerk 0
3902472 1991057 1991057 defendant Wynter Henry husbandman 601693 601693 Wynter, Henry, of Capell, husbandman 1
3902473 1991057 1991057 defendant Wynter John laborer 601693 601693 Wynter, John, of Capell, laborer 2
4049886 2042390 2042390 defendant Tarverm William yeoman 601693 601693 Tarverm William, of Capell, yeoman 0
4088297 2056107 2056107 defendant Grenall or Grevall alias Ellys Nicholas yeoman 601693 601693 Grenall or Grevall alias Ellys, Nicholas, of Capell, yeoman 0
4089243 2056438 2056438 defendant Grenall or Grevall alias Ellys Nicholas yeoman 601693 601693 Grenall or Grevall alias Ellys, Nicholas, of Capell, yeoman 0
4100720 2060578 2060578 defendant Alderton John, junior laborer 601693 601693 Alderton, John, junior, of Capell, laborer 0
4119293 2067193 2067193 defendant FitzAllen Timothy   601693 601693 FitzAllen, Timothy, of Capell, clerk, parson of Dedham, Essex 0
4167078 2083989 2083989 defendant Fitzallan Timothy clerk 601693 601693 Fitzallan, Timothy, of Capell, clerk 0
4184421 2090056 2090056 defendant Tarver John yeoman 601693 601693 Tarver, John, of Capell, yeoman 0
4235140 2107849 2107849 defendant Fitzallen Timothy clerk 601693 601693 Fitzallen, Timothy, of Capell, clerk 0
4241192 2110042 2110042 defendant Hubberd Christopher (legal representative) 601693 601693 Hubberd, Christopher, of Capell, yeoman, executor of 1
4305673 2132121 2132121 defendant Smythe William gent 601693 601693 Smythe, William, of Capell, gent 3
4308081 2132971 2132971 defendant Lorkyn James tailor 601693 601693 Lorkyn, James, of Capell, tailor 2
4325191 2138805 2138805 defendant Poole John yeoman 601693 601693 Poole, John, of Capell, yeoman 0
4330023 2140344 2140344 defendant Forster Richard yeoman 601693 601693 Forster, Richard, of Capell, yeoman 3
4369180 2154041 2154041 defendant Colson Thomas   601693 601693 Colson, Thomas, of Capell, Kent laborer 2
4369181 2154041 2154041 defendant Sergeant Thomas laborer 601693 601693 Sergeant, Thomas, of Capell, laborer 3
4369184 2154042 2154042 defendant Sergeant Thomas laborer 601693 601693 Sergeant, Thomas, of Capell, laborer 1
4382483 2158847 2158847 defendant A Stone Henry yeoman 601693 601693 A Stone, Henry, of Capell, yeoman 0
4382485 2158848 2158848 defendant A Stone Henry yeoman 601693 601693 A Stone, Henry, of Capell, yeoman 0
4400445 2164744 2164744 defendant Smyth William yeoman 601693 601693 Smyth, William, of Capell, yeoman 0
4452177 2185665 2185665 defendant Pascull John   601693 601693 Pascull, John, of Capell 0
4467303 2190452 2190452 defendant atte Misbroke Walter   601693 601693 atte Misbroke, Walter, of Capell 0
4574788 2223638 2223638 defendant Hunte Richard   601693 601693 Hunte, Richard, of Capell 1
4579272 2224998 2224998 defendant Wryghte John   601693 601693 Wryghte, John, of Capell 2
4621607 2237745 2237745 defendant Wryghte John   601693 601693 Wryghte, John, of Capell 2
4625813 2239025 2239025 defendant Wareyn John   601693 601693 Wareyn, John, of Capell 2
4625976 2239080 2239080 defendant Waryn John   601693 601693 Waryn, John, of Capell 0
4629842 2240257 2240257 defendant Lorkere Richard   601693 601693 Lorkere, Richard, of Capell 0
4635467 2241950 2241950 defendant Wareyn John   601693 601693 Wareyn, John, of Capell 3
4638279 2242742 2242742 defendant Waryn John   601693 601693 Waryn, John, of Capell 0
4704271 2266713 2266713 plaintiff Hunte John   601693 601693 Hunte, John, of Capell 0
4715290 2270115 2270115 defendant Henfold Adam husbandman 601693 601693 Henfold, Adam, of Capell, husbandman 0
4752472 2281184 2281184 defendant Rokesfold John laborer 601693 601693 Rokesfold, John, of Capell, laborer 1
4757618 2282759 2282759 defendant Rayne Thomas husbandman 601693 601693 Rayne, Thomas, of Capell, husbandman 0
4757620 2282760 2282760 defendant Honde or Houde John laborer 601693 601693 Honde or Houde, John, of Capell, laborer 0
4808950 2298974 2298974 defendant Eybrook John yeoman 601693 601693 Eybrook, John, of Capell, yeoman 1
4808951 2298974 2298974 defendant Scherwynde William yeoman 601693 601693 Scherwynde, William, of Capell, yeoman 2
4808952 2298974 2298974 defendant Truston John yeoman 601693 601693 Truston, John, of Capell, yeoman 3
4851953 2312044 2312044 defendant Semon Thomas yeoman 601693 601693 Semon, Thomas, of Capell, yeoman 0
4851958 2312045 2312045 defendant Seman Thomas yeoman 601693 601693 Seman, Thomas, of Capell, yeoman 0
4884510 2322059 2322059 defendant Mount Richard husbandman 601693 601693 Mount, Richard, of Capell, husbandman 0
4884511 2322059 2322059 defendant Steven John husbandman 601693 601693 Steven, John, of Capell, husbandman 1
4898449 2326169 2326169 defendant Breyle William yeoman 601693 601693 Breyle, William, of Capell, yeoman 2
4923524 2333790 2333790 defendant Newenham John yeoman 601693 601693 Newenham, John, of Capell, yeoman 0
4923525 2333790 2333790 defendant Eybrook Richard yeoman 601693 601693 Eybrook, Richard, of Capell, yeoman 1
4938134 2338306 2338306 defendant Nicoll William yeoman 601693 601693 Nicoll, William, of Capell, yeoman 3
4944848 2340377 2340377 defendant Herde Thomas husbandman 601693 601693 Herde, Thomas, of Capell, husbandman 2
4962095 2345569 2345569 defendant Reyn John laborer 601693 601693 Reyn, John, of Capell, laborer 1
5020041 2362748 2362748 defendant Eybrook Richard butcher 601693 601693 Eybrook, Richard, of Capell, butcher 0
5024571 2364100 2364100 defendant Heybrook Richard yeoman 601693 601693 Heybrook, Richard, of Capell, yeoman 1
5042197 2369272 2369272 defendant Birche Richard laborer 601693 601693 Birche, Richard, of Capell, laborer 0
5042536 2369372 2369372 defendant Totyler Henry   601693 601693 Totyler, Henry, of Capell, parson 0
5049835 2371578 2371578 defendant Boweregge Thomas husbandman 601693 601693 Boweregge, Thomas, of Capell, husbandman 2
5063015 2375470 2375470 defendant Claresmore Robert laborer 601693 601693 Claresmore, Robert, of Capell, laborer 3
5110144 2389378 2389378 defendant Broker William husbandman 601693 601693 Broker, William, of Capell, husbandman 0
5110145 2389378 2389378 defendant Nyghtynghale John husbandman 601693 601693 Nyghtynghale, John, of Capell, husbandman 1
5110146 2389378 2389378 defendant Mille Peter husbandman 601693 601693 Mille, Peter, of Capell, husbandman 2
5110147 2389378 2389378 defendant Pytte John husbandman 601693 601693 Pytte, John, of Capell, husbandman 3
5137248 2397408 2397408 defendant Horley William laborer 601693 601693 with Horley, William, of Capell, laborer 4
5154932 2402600 2402600 defendant Eybroke Richard yeoman 601693 601693 Eybroke, Richard, of Capell, yeoman 2
5157160 2403232 2403232 defendant Burdon Thomas, sen husbandman 601693 601693 Burdon, Thomas, sen, of Capell, husbandman 0
5226093 2423298 2423298 defendant Steer John husbandman 601693 601693 Steer, John, of Capell, husbandman 1
5251876 2430696 2430696 defendant Reyne William husbandman 601693 601693 Reyne, William, of Capell, husbandman 0
5251877 2430696 2430696 defendant Reyne John husbandman 601693 601693 Reyne, John, of Capell, husbandman 1
5282442 2439924 2439924 defendant Haunteyn Stephen yeoman 601693 601693 Haunteyn, Stephen, of Capell, yeoman 0
5325510 2452710 2452710 defendant Andrewe John weaver 601693 601693 Andrewe, John, of Capell, weaver 3
5329133 2453791 2453791 defendant Venyour Richard husbandman 601693 601693 Venyour, Richard, of Capell, husbandman 2
5351468 2460557 2460557 defendant Haunten Robert yeman 601693 601693 Haunten, Robert, of Capell, yeman 2
5351477 2460559 2460559 defendant Hanten or Hauten Robert yeoman 601693 601693 Hanten or Hauten, Robert, of Capell, yeoman 3
5351478 2460559 2460559 defendant Hanten or Hauten Sarah widow 601693 601693 Hanten or Hauten, Sarah, of Capell, widow 4
5359383 2462972 2462972 defendant Reve John husbandman 601693 601693 Reve, John, of Capell, husbandman 0
5359384 2462972 2462972 defendant Tastard John husbandman 601693 601693 Tastard, John, of Capell, husbandman 1
5385372 2470893 2470893 defendant Bache Robert husbandman 601693 601693 Bache,Robert, of Capell, husbandman 3

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