names

108 rows where place_id = 588259

✎ 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
3593862 1865719 1865719 defendant Grene Thomas laborer 588259 588259 Grene, Thomas, of Flecchyng, laborer 0
3593865 1865719 1865719 defendant Bolney John clerk 588259 588259 Bolney, John, of Flecchyng, clerk 3
3594852 1866019 1866019 defendant Dorkyng William husbandman 588259 588259 Dorkyng, William, of Flecchyng, husbandman 0
3646255 1909219 1909219 defendant Everys Richard butcher 588259 588259 Everys, Richard, of Flecchyng, butcher 0
3673335 1917675 1917675 defendant Byrde John mercer 588259 588259 Byrde, John, of Flecchyng, mercer 0
3673336 1917675 1917675 defendant Reynold John mercer 588259 588259 Reynold, John, of Flecchyng, mercer 1
3673459 1917721 1917721 defendant Reynold Roland fishmonger 588259 588259 Reynold, Roland, of Flecchyng, yeoman, or of London, fishmonger 0
3673552 1917754 1917754 defendant Adam Joan widow 588259 588259 Adam, Joan, of Flecchyng, widow 0
3677413 1918987 1918987 defendant Payn Robert laborer 588259 588259 Payn, Robert, of Flecchyng, laborer 1
3697305 1925379 1925379 defendant Adams Richard gent 588259 588259 Adams, Richard, of Flecchyng, gent 0
3697395 1925403 1925403 defendant Holmewode Edmund husbandman 588259 588259 Holmewode, Edmund, of Flecchyng, husbandman 1
3697397 1925403 1925403 defendant Hartfeld John laborer 588259 588259 Hartfeld, John, of Flecchyng, laborer 3
3698581 1925774 1925774 defendant Adams Richard gent 588259 588259 Adams, Richard, of Flecchyng, gent 0
3698582 1925774 1925774 defendant Wynter Thomas laborer 588259 588259 Wynter, Thomas, of Flecchyng, laborer 1
3703985 1927530 1927530 defendant Byrde John mercer 588259 588259 Byrde, John, of Flecchyng, mercer 0
3703986 1927530 1927530 defendant Raynold John mercer 588259 588259 Raynold, John, of Flecchyng, mercer 1
3712206 1930131 1930131 defendant Adams Richard gent 588259 588259 Adams, Richard, of Flecchyng, gent 5
3718044 1931939 1931939 plaintiff Fayreall Thomas husbandman 588259 588259 Fayreall, Thomas, of Flecchyng, husbandman 0
3722127 1933183 1933183 defendant Plumdon John husbandman 588259 588259 Plumdon, John, of Flecchyng, husbandman 3
3722129 1933184 1933184 defendant Hawkyn Thomas husbandman 588259 588259 Hawkyn, Thomas, of Flecchyng, husbandman 0
3722130 1933184 1933184 defendant Plumden John husbandman 588259 588259 Plumden, John, of Flecchyng, husbandman 1
3745152 1940389 1940389 defendant Plomden John miner 588259 588259 Plomden, John, of Flecchyng, miner 2
3746630 1940862 1940862 plaintiff Couper alias Roper Nicholas wheeler 588259 588259 Couper alias Roper, Nicholas, of Flecchyng, wheeler 0
3747484 1941128 1941128 defendant Atherwold Richard husbandman 588259 588259 Atherwold, Richard, of Flecchyng, husbandman 0
3762289 1945850 1945850 defendant Levett John gent 588259 588259 Levett, John, of Flecchyng, gent 1
3769423 1948097 1948097 defendant Levett William chaplain 588259 588259 Levett, William, of Flecchyng, chaplain 0
3769424 1948097 1948097 defendant Skynner John, senior husbandman 588259 588259 Skynner, John, senior, of Flecchyng, husbandman 1
3769425 1948097 1948097 defendant Skynner John, junior husbandman 588259 588259 Skynner, John, junior, of Flecchyng, husbandman 2
3769426 1948097 1948097 defendant Skynner Robert husbandman 588259 588259 Skynner, Robert, of Flecchyng, husbandman 3
3769427 1948097 1948097 defendant Banaster Nicholas husbandman 588259 588259 Banaster, Nicholas, of Flecchyng, husbandman 4
3769428 1948097 1948097 defendant Castelynd John husbandman 588259 588259 Castelynd, John, of Flecchyng, husbandman 5
3778180 1950883 1950883 defendant Skynner Richard husbandman 588259 588259 Skynner, Richard, of Flecchyng, husbandman 0
3778182 1950884 1950884 defendant Ward John husbandman 588259 588259 Ward, John, of Flecchyng, husbandman 0
3782867 1952390 1952390 defendant Hankyn Thomas husbandman 588259 588259 Hankyn, Thomas, of Flecchyng, husbandman 2
3787824 1953979 1953979 defendant Couper Nicholas   588259 588259 Couper, Nicholas, of Flecchyng, wheelwright 0
3787828 1953980 1953980 defendant Couper Nicholas   588259 588259 Couper, Nicholas, of Flecchyng, wheelwright 0
3787832 1953981 1953981 defendant Cowper Nicholas   588259 588259 Cowper, Nicholas, of Flecchyng, wheelwright 0
3795331 1956408 1956408 plaintiff Cowper Nicholas wheeler 588259 588259 Cowper, Nicholas, of Flecchyng, wheeler 0
3889034 1986572 1986572 defendant Locke Thomas butcher 588259 588259 Locke, Thomas, of Flecchyng, butcher 0
4452210 2185673 2185673 plaintiff Irland John, junior   588259 588259 Irland, John, junior, of Flecchyng 0
4573746 2223306 2223306 defendant Payn John   588259 588259 Payn, John, of Flecchyng 0
4610248 2234289 2234289 defendant Wythyere John   588259 588259 Wythyere, John, of Flecchyng 0
4613369 2235208 2235208 defendant Couper John   588259 588259 Couper, John, of Flecchyng 14
4613378 2235209 2235209 defendant Stydolf John   588259 588259 Stydolf, John, of Flecchyng 0
4613394 2235210 2235210 defendant Couper John   588259 588259 Couper, John, of Flecchyng 13
4625545 2238949 2238949 defendant Couper John   588259 588259 Couper, John, of Flecchyng 11
4674450 2257619 2257619 defendant Denet Peter skinner 588259 588259 Denet, Peter, of Flecchyng, skinner 0
4674451 2257619 2257619 defendant Pollard Edward wheeler 588259 588259 Pollard, Edward, of flecchyng, wheeler 1
4676533 2258276 2258276 plaintiff Godman William   588259 588259 Godman, William, of Flecchyng 0
4676534 2258276 2258276 defendant Malle John   588259 588259 Malle, John, of Flecchyng, milward 0
4701907 2266001 2266001 defendant atte More John tailor 588259 588259 atte More, John, of Flecchyng, tailor 1
4729681 2274495 2274495 defendant Taillour John husbandman 588259 588259 Taillour, John, of Flecchyng, husbandman 0
4735257 2276174 2276174 defendant Bowey Richard husbandman 588259 588259 Bowey, Richard, of Flecchyng, husbandman 0
4745258 2279122 2279122 defendant Terry William fuller 588259 588259 Terry, William, of Flecchyng, fuller 0
4747573 2279797 2279797 defendant Malle Richard husbandman 588259 588259 Malle, Richard, of Flecchyng, husbandman 0
4754264 2281712 2281712 defendant Colle John smith 588259 588259 Colle, John, of Flecchyng, smith 2
4760494 2283633 2283633 defendant Elyot William husbandman 588259 588259 Elyot, William, of Flecchyng, husbandman 1
4777277 2288882 2288882 defendant Tailloure John husbandman 588259 588259 Tailloure, John, of Flecchyng, husbandman 0
4779261 2289492 2289492 defendant Harpour Robert husbandman 588259 588259 Harpour, Robert, of Flecchyng, husbandman 0
4779262 2289492 2289492 defendant Malle Richard husbandman 588259 588259 Malle, Richard, of Flecchyng, husbandman 1
4785784 2291591 2291591 defendant Malle Richard husbandman 588259 588259 Malle, Richard, of Flecchyng, husbandman 2
4785785 2291591 2291591 defendant Harpour Robert laborer 588259 588259 Harpour, Robert, of Flecchyng, laborer 3
4785808 2291594 2291594 defendant Malle Richard husbandman 588259 588259 Malle, Richard, of Flecchyng, husbandman 8
4785809 2291594 2291594 defendant Harpour Robert husbandman 588259 588259 Harpour, Robert, of Flecchyng, husbandman 9
4834986 2306945 2306945 defendant Vygorus Andrew shoemaker 588259 588259 Vygorus, Andrew, of Flecchyng, shoemaker 0
4941052 2339222 2339222 defendant Whyte Richard husbandman 588259 588259 Whyte, Richard, of Flecchyng, husbandman 0
4943559 2339956 2339956 defendant Fyssyne John thatcher 588259 588259 Fyssyne, John, of Flecchyng, thatcher 2
5026621 2364661 2364661 defendant Melle Richard husbandman 588259 588259 Melle, Richard, of Flecchyng, husbandman 0
5066109 2376386 2376386 defendant Couper Nicholas butcher 588259 588259 Couper, Nicholas, of Flecchyng, butcher 0
5113962 2390473 2390473 defendant Taylour John   588259 588259 Taylour, John, of Flecchyng 0
5155827 2402864 2402864 defendant White Thomas husbandman 588259 588259 together with White, Thomas, of Flecchyng, husbandman 17
5155829 2402865 2402865 defendant White Thomas husbandman 588259 588259 White, Thomas, of Flecchyng, husbandman 0
5163559 2405075 2405075 defendant Brethern John clerk 588259 588259 Brethern, John, of Flecchyng, clerk 0
5163560 2405075 2405075 defendant Durantt John clerk 588259 588259 Durantt, John, of Flecchyng, clerk 1
5163561 2405075 2405075 defendant Reynold John yeoman 588259 588259 Reynold, John, of Flecchyng, yeoman 2
5185570 2411532 2411532 defendant Strode William butcher 588259 588259 Strode, William, of Flecchyng, butcher 0
5199946 2415738 2415738 defendant Reynold John yeoman 588259 588259 Reynold, John, of Flecchyng, yeoman 0
5199947 2415738 2415738 defendant Brethern John   588259 588259 Brethern, John, of Flecchyng clerk 1
5199948 2415738 2415738 defendant Durant John cler 588259 588259 Durant, John, of flecchyng, cler 2
5216230 2420483 2420483 defendant Reynold John yeoman 588259 588259 Reynold, John, of Flecchyng, yeoman 0
5242490 2428012 2428012 defendant Strode William, senior butcher 588259 588259 Strode, William, senior, of Flecchyng, butcher 0
5242491 2428012 2428012 defendant Mall Richard husbandman 588259 588259 Mall, Richard, of Flecchyng, husbandman 1
5242492 2428012 2428012 defendant Lye John husbandman 588259 588259 Lye, John, of Flecchyng, husbandman 2
5242493 2428012 2428012 defendant atte Downe Richard husbandman 588259 588259 atte Downe, Richard, of Flecchyng, husbandman 3
5242494 2428012 2428012 defendant Studolf John husbandman 588259 588259 Studolf, John, of Flecchyng, husbandman 4
5242495 2428012 2428012 defendant Studolf Richard husbandman 588259 588259 Studolf, Richard, of Flecchyng, husbandman 5
5242496 2428012 2428012 defendant Holford Richard husbandman 588259 588259 Holford, Richard, of Flecchyng, husbandman 6
5242497 2428012 2428012 defendant Avecok Thomas husbandman 588259 588259 Avecok, Thomas, of Flecchyng, husbandman 7
5260623 2433452 2433452 defendant Parys Thomas miller 588259 588259 Parys, Thomas, of Flecchyng, miller 14
5260624 2433452 2433452 defendant Acok Richsard husbandman 588259 588259 Acok, Richsard, of Flecchyng, husbandman 15
5302137 2445595 2445595 plaintiff Edward Stephen   588259 588259 Edward, Stephen, of Flecchyng 0
5302138 2445595 2445595 defendant Nicholasl   (legal representative) 588259 588259 _, Nicholasl, of Flecchyng, butcher, executors of 0
5302139 2445595 2445595 defendant atte Stone William smith 588259 588259 (atte Stone, William, of Flecchyng, smith 1
5302140 2445595 2445595 defendant Stone John laborer 588259 588259 Stone, John, of Flecchyng, laborer 2
5325195 2452623 2452623 defendant Durkyn Richard carpenter 588259 588259 Durkyn, Richard, of Flecchyng, carpenter 0
5456501 2491870 2491870 defendant Aderwold Thomas butcher 588259 588259 Aderwold, Thomas, of Flecchyng, butcher 0
5475975 2497825 2497825 defendant Adderwold Thomas   588259 588259 Adderwold, Thomas, of Flecchyng 0
5516388 2509959 2509959 defendant Canell or Cavell Thomas husbandman 588259 588259 Canell or Cavell, Thomas, of Flecchyng, husbandman 0
5526008 2512728 2512728 defendant Hawkyn Thomas laborer 588259 588259 Hawkyn, Thomas, of Flecchyng, laborer 0
5526009 2512728 2512728 defendant Stone Richard laborer 588259 588259 Stone, Richard, of Flecchyng, laborer 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);