names

149 rows where place_id = 586395

✎ 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
3588614 1864083 1864083 defendant Rydeoute John chapman 586395 586395 Rydeoute, John, of Alderton, chapman 0
3610212 1870859 1870859 defendant Freman John walker 586395 586395 Freman, John, of Alderton, walker 0
3611181 1871174 1871174 defendant Mannyng William husbandman 586395 586395 Mannyng, William, of Alderton, husbandman 0
3611182 1871174 1871174 defendant Kesby Robert husbandman 586395 586395 Kesby, Robert, of Alderton, husbandman 1
3611183 1871174 1871174 defendant Broun Henry husbandman 586395 586395 Broun, Henry, of Alderton, husbandman 2
3611184 1871174 1871174 defendant Tanner Thomas husbandman 586395 586395 Tanner, Thomas, of Alderton, husbandman 3
3611186 1871175 1871175 defendant Mannyng William husbandman 586395 586395 Mannyng, William, of Alderton, husbandman 0
3611187 1871175 1871175 defendant Kesby Robert husbandman 586395 586395 Kesby, Robert, of Alderton, husbandman 1
3611188 1871175 1871175 defendant Broun Henry husbandman 586395 586395 Broun, Henry, of Alderton, husbandman 2
3611189 1871175 1871175 defendant Tanner Thomas husbandman 586395 586395 Tanner, Thomas, of Alderton, husbandman 3
3623323 1874823 1874823 defendant Harries Richard clerk 586395 586395 Harries, Richard, of Alderton, clerk 0
3662310 1914126 1914126 defendant Hyll Edmund (legal representative) 586395 586395 Hyll, Edmund, of Alderton, husbandman, executor of 2
3662311 1914126 1914126 defendant Hyll Henry yeoman 586395 586395 Hyll, Henry, of Alderton, yeoman 3
3665144 1915051 1915051 plaintiff Smyth Thomas (legal representative) 586395 586395 Smyth, Thomas, of Alderton, executors of 0
3666240 1915390 1915390 defendant Rutter Richard husbandman 586395 586395 Rutter, Richard, of Alderton, husbandman 1
3666573 1915482 1915482 defendant Mower Gregory   586395 586395 Mower, Gregory, of Alderton, Suff, rector 0
3674091 1917936 1917936 defendant Furton William laborer 586395 586395 Furton, William, of Alderton, laborer 4
3675222 1918285 1918285 defendant Brynklove Thomas husbandman 586395 586395 (Brynklove, Thomas, of Alderton, husbandman 1
3714344 1930785 1930785 defendant Harvy William husbandman 586395 586395 Harvy, William, of Alderton, husbandman 0
3763555 1946235 1946235 defendant Renge William, senior husbandman 586395 586395 Renge, William, senior, of Alderton, husbandman 3
3763583 1946244 1946244 defendant Renge William husbandman 586395 586395 Renge, William, of Alderton, husbandman 0
3772576 1949115 1949115 defendant Waller John husbandman 586395 586395 Waller, John, of Alderton, husbandman 0
3810723 1961255 1961255 defendant Courteby alias Kyrkeby William yeoman 586395 586395 Courteby alias Kyrkeby, William, of Alderton, yeoman 0
3811268 1961420 1961420 defendant Harvy William husbandman 586395 586395 Harvy, William, of Alderton, husbandman 2
3826895 1966262 1966262 defendant Carter John clerk 586395 586395 Carter, John, of Alderton, clerk 0
3853475 1974711 1974711 defendant Waker William husbandman 586395 586395 Waker, William, of Alderton, husbandman 2
3878304 1982992 1982992 defendant Cooke William husbandman 586395 586395 Cooke, William, of Alderton, husbandman 2
3879857 1983520 1983520 defendant Dunne William husbandman 586395 586395 Dunne, William, of Alderton, husbandman 1
3887257 1986004 1986004 defendant Blomefeld William husbandman 586395 586395 Blomefeld, William, of Alderton, husbandman 1
3906813 1992568 1992568 defendant Shemyng Thomas husbandman 586395 586395 Shemyng, Thomas, of Alderton, husbandman 1
3917232 1996123 1996123 plaintiff Gore Giles   586395 586395 Gore, Giles, of Alderton 0
3920271 1997116 1997116 plaintiff Bucok Richard   586395 586395 Bucok, Richard, of Alderton 1
3920272 1997116 1997116 defendant Lane John yeoman 586395 586395 Lane, John, of Alderton, yeoman 0
3954934 2008787 2008787 defendant Smyth alias Rand Ranulph yeoman 586395 586395 Smyth alias Rand, Ranulph, of Alderton, yeoman 10
4029169 2035076 2035076 defendant Smyth alias Raines or Rames Randolph yeoman 586395 586395 Smyth alias Raines or Rames, Randolph, of Alderton, yeoman 0
4040932 2039244 2039244 defendant Revell Richard   586395 586395 Revell, Richard, of Alderton, rope maker 1
4058069 2045267 2045267 defendant Goodman Richard husbandman 586395 586395 Goodman, Richard, of Alderton, husbandman 0
4058070 2045267 2045267 defendant Page John husbandman 586395 586395 Page, John, of Alderton, husbandman 1
4111701 2064433 2064433 defendant Mathewes John carpenter 586395 586395 Mathewes, John, of Alderton, carpenter 1
4115115 2065694 2065694 defendant Pype William yeoman 586395 586395 Pype, William, of Alderton, yeoman 0
4158784 2081146 2081146 defendant Branson Robert yeoman 586395 586395 Branson, Robert, of Alderton, yeoman 2
4298181 2129450 2129450 defendant Waker Francis yeoman 586395 586395 Waker, Francis, of Alderton, yeoman 1
4302960 2131158 2131158 defendant Carpenter Thomas yeoman 586395 586395 Carpenter, Thomas, of Alderton, yeoman 1
4315921 2135679 2135679 defendant Visard Arthur yeoman 586395 586395 Visard, Arthur, of Alderton, yeoman 0
4335693 2142216 2142216 defendant Sharpe Nicholas blacksmith 586395 586395 Sharpe, Nicholas, of Alderton, blacksmith 1
4385003 2159675 2159675 defendant Silvester James carpenter 586395 586395 Silvester, James, of Alderton, carpenter 3
4419718 2171063 2171063 defendant Tiryngton William de   586395 586395 Tiryngton, William de, of Alderton, parson 0
4445463 2183536 2183536 defendant Luttyng Stephen   586395 586395 Luttyng, Stephen, of Alderton 1
4449882 2184917 2184917 defendant Miller Richard   586395 586395 Miller, Richard, of Alderton 0
4517764 2205948 2205948 plaintiff Dan William   586395 586395 Dan, William, of Alderton, on his own account 0
4579689 2225134 2225134 plaintiff Coyse William   586395 586395 Coyse, William, of Alderton 0
4587118 2227375 2227375 defendant Eggeton William clerk & parson 586395 586395 Eggeton, William, of Alderton, clerk & parson 0
4646189 2244959 2244959 defendant Parker John tailor 586395 586395 Parker, John, of Alderton, tailor 0
4657094 2248114 2248114 defendant Davy John husbandman 586395 586395 Davy, John, of Alderton, husbandman 0
4669175 2256065 2256065 defendant Ryal Henry tailor 586395 586395 Ryal, Henry, of Alderton, tailor 0
4687256 2261621 2261621 plaintiff Fornham Katherine   586395 586395 Fornham, Katherine, of Alderton, formerly wife of Walter Fornham 1
4709666 2268388 2268388 defendant Webbe Nicholas husbandman 586395 586395 Webbe, Nicholas, of Alderton, husbandman 2
4713122 2269425 2269425 defendant Naunton Peter esq 586395 586395 Naunton, Peter, of Alderton, esq 1
4713952 2269692 2269692 defendant Webbe Richard husbandman 586395 586395 Webbe, Richard, of Alderton, husbandman 0
4778220 2289172 2289172 defendant Ragge William butcher 586395 586395 Ragge, William, of Alderton, butcher 0
4779793 2289675 2289675 defendant Webbe Nicholas husbandman 586395 586395 Webbe, Nicholas, of Alderton, husbandman 0
4835803 2307192 2307192 defendant Fornham John yeoman 586395 586395 Fornham, John, of Alderton, yeoman 4
4906770 2328699 2328699 defendant Whyte John husbamdman 586395 586395 Whyte, John, of Alderton, husbamdman 3
4933304 2336807 2336807 defendant Webbe Nicholas husbandman 586395 586395 Webbe, Nicholas, of Alderton, husbandman 4
4940546 2339069 2339069 defendant Peyton Nicholas yeoman 586395 586395 Peyton, Nicholas, of Alderton, yeoman 1
4966378 2346875 2346875 defendant Peyton Nicholas yeoman 586395 586395 Peyton, Nicholas, of Alderton, yeoman 0
4994756 2355289 2355289 defendant Thornham John yeoman 586395 586395 Thornham, John, of Alderton, yeoman 0
4994757 2355289 2355289 defendant Thornham Walter husbandman 586395 586395 Thornham, Walter, of Alderton, husbandman 1
5020228 2362807 2362807 defendant Fornham Walter husbandman 586395 586395 Fornham, Walter, of Alderton, husbandman 0
5087347 2382680 2382680 defendant Bole John husbandman 586395 586395 Bole, John, of Alderton, husbandman 0
5130669 2395459 2395459 defendant Mason Simon husbandman 586395 586395 Mason, Simon, of Alderton, husbandman 0
5133636 2396331 2396331 defendant Cannvyle William husbandman 586395 586395 Cannvyle, William, of Alderton, husbandman 2
5153445 2402162 2402162 defendant Caunvyle William husbandman 586395 586395 Caunvyle, William, of Alderton, husbandman 2
5170857 2407202 2407202 defendant Caunvyle William husbandman 586395 586395 Caunvyle, William, of Alderton, husbandman 2
5182604 2410667 2410667 defendant Bullyng John butcher 586395 586395 Bullyng, John, of Alderton, butcher 0
5182606 2410668 2410668 defendant Bullyng John butcher 586395 586395 Bullyng, John, of Alderton, butcher 0
5199122 2415497 2415497 defendant Bongrove Thomas yeoman 586395 586395 Bongrove, Thomas, of Alderton, yeoman 1
5203495 2416775 2416775 defendant Bullyng John butcher 586395 586395 Bullyng, John, of Alderton, butcher 0
5210969 2418939 2418939 defendant Bengrove John yeoman 586395 586395 Bengrove, John, of Alderton, yeoman 0
5210970 2418939 2418939 defendant Bengrove Thomas yeoman 586395 586395 Bengrove, Thomas, of Alderton, yeoman 1
5227000 2423549 2423549 defendant Fornham Walter yeoman 586395 586395 Fornham, Walter, of Alderton, yeoman 0
5228135 2423836 2423836 defendant Barres John clerk 586395 586395 Barres, John, of Alderton, clerk 0
5240103 2427306 2427306 defendant Bengrove John husbandman 586395 586395 Bengrove, John, of Alderton, husbandman 0
5240104 2427306 2427306 defendant Bredon John husbandman 586395 586395 Bredon, John, of Alderton, husbandman 1
5245813 2428941 2428941 defendant Detour John husbandman 586395 586395 Detour, John, of Alderton, husbandman 2
5255728 2431908 2431908 defendant Wode William mariner 586395 586395 Wode, William, of Alderton, mariner 0
5261979 2433856 2433856 defendant Fornham Walter husbandman 586395 586395 Fornham, Walter, of Alderton, husbandman 0
5262760 2434093 2434093 defendant Naunton Robert esq 586395 586395 Naunton, Robert, of Alderton, esq 1
5266657 2435326 2435326 defendant Rydeoute John chapman 586395 586395 Rydeoute, John, of Alderton, chapman 0
5290119 2442117 2442117 defendant Rydeout John mercer 586395 586395 Rydeout, John, of Alderton, mercer 0
5296307 2443910 2443910 defendant Bengrene John husbandman 586395 586395 Bengrene, John, of Alderton, husbandman 1
5300653 2445157 2445157 defendant Hevenyngham Thomas clerk 586395 586395 Hevenyngham, Thomas, of Alderton, clerk 3
5303489 2446038 2446038 defendant Monge John husbandman 586395 586395 Monge, John, of Alderton, husbandman 0
5308219 2447490 2447490 defendant Caunvyle Henry husbandman 586395 586395 Caunvyle, Henry, of Alderton, husbandman 0
5313243 2448997 2448997 defendant Furton John husbandman 586395 586395 Furton, John, of Alderton, husbandman 0
5334327 2455337 2455337 defendant Daburne Richard gent 586395 586395 Daburne, Richard, of Alderton, gent 0
5348489 2459668 2459668 defendant Cook Robert yeoman 586395 586395 Cook, Robert, of Alderton, yeoman 1
5348492 2459669 2459669 defendant Cook Robert yeoman 586395 586395 Cook, Robert, of Alderton, yeoman 1
5355760 2461878 2461878 defendant Pullen Richard husbandman 586395 586395 Pullen, Richard, of Alderton, husbandman 1
5355974 2461952 2461952 defendant Hoodton John husbandman 586395 586395 Hoodton, John, of Alderton, husbandman 1

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