names

107 rows where place_id = 587961

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592964 1865422 1865422 defendant Gele John husbandman 587961 587961 Gele, John, of Elyng, husbandman 0
3611037 1871130 1871130 defendant Neweman William husbandman 587961 587961 Neweman, William, of Elyng, husbandman 0
3611038 1871130 1871130 defendant Guymond William husbandman 587961 587961 Guymond, William, of Elyng, husbandman 1
3613337 1871818 1871818 defendant Bery John husbandman 587961 587961 Bery, John, of Elyng, husbandman 0
3613338 1871818 1871818 defendant Pynnok John waterman 587961 587961 Pynnok, John, of Elyng, waterman 1
3620494 1873987 1873987 defendant Rake Henry esq 587961 587961 Rake, Henry, of Elyng, esq 0
3620495 1873987 1873987 defendant Rake Thomas yeoman 587961 587961 Rake, Thomas, of Elyng, yeoman 1
3641702 1907861 1907861 defendant Hygdon William husbandman 587961 587961 Hygdon, William, of Elyng, husbandman 1
3641703 1907861 1907861 defendant Hygdon George husbandman 587961 587961 Hygdon, George, of Elyng, husbandman 2
3643964 1908542 1908542 defendant Wyg Richard husbandman 587961 587961 Wyg, Richard, of Elyng, husbandman 0
3682351 1920581 1920581 defendant Barrett Stephen husbandman 587961 587961 Barrett, Stephen, of Elyng, husbandman 0
3682352 1920581 1920581 defendant Hyndebeste William husbandman 587961 587961 Hyndebeste, William, of Elyng, husbandman 1
3706020 1928174 1928174 defendant Tuppyn William yeoman 587961 587961 Tuppyn, William, of Elyng, or of Hease, yeoman 1
3707011 1928477 1928477 defendant Bere Walter yeoman 587961 587961 Bere, Walter, of Elyng, yeoman 1
3707012 1928477 1928477 defendant Marr Robert yeoman 587961 587961 Marr, Robert, of Elyng, yeoman 2
3730537 1935786 1935786 defendant Tuchet James gent 587961 587961 Tuchet, James, of Elyng, gent 0
3746518 1940822 1940822 defendant Tuchet James gent 587961 587961 Tuchet, James, of Elyng, gent 0
3751313 1942336 1942336 defendant Kelyng John yeoman 587961 587961 Kelyng, John, of Elyng, yeoman 0
3751314 1942336 1942336 defendant Lovell Henry husbandman 587961 587961 Lovell, Henry, of Elyng, husbandman 1
3751315 1942336 1942336 defendant Hyndbest Robert husbandman 587961 587961 Hyndbest, Robert, of Elyng, husbandman 2
3751316 1942336 1942336 defendant Whyte Robert husbandman 587961 587961 Whyte, Robert, of Elyng, husbandman 3
3780299 1951568 1951568 defendant Tuchet James gent 587961 587961 Tuchet, James, of Elyng, gent 0
3800371 1958033 1958033 defendant Twychet alias Audeley James gent 587961 587961 Twychet alias Audeley, James, of Elyng, gent 0
3800372 1958033 1958033 defendant Hooper Henry yeoman 587961 587961 Hooper, Henry, of Elyng, yeoman 1
3802201 1958584 1958584 defendant Twychet alias Audeley James gent 587961 587961 Twychet alias Audeley, James, of Elyng, gent 0
3802202 1958584 1958584 defendant Hooper Henry yeoman 587961 587961 Hooper, Henry, of Elyng, yeoman 1
3813640 1962182 1962182 defendant Wyllyams John yeoman 587961 587961 Wyllyams, John, of Elyng, yeoman 0
3816675 1963118 1963118 defendant Lorde Richard yeoman 587961 587961 Lorde, Richard, of Elyng, yeoman 0
3832372 1968043 1968043 defendant Tuchet James esq 587961 587961 Tuchet, James, of Elyng, esq 0
3863897 1978099 1978099 defendant Lurkyn Thomas husbandman 587961 587961 Lurkyn, Thomas, of Elyng, husbandman 0
3882011 1984243 1984243 defendant Deye Elias (legal representative) 587961 587961 Deye, Elias, of Elyng, yeoman, executors of 1
3902999 1991233 1991233 defendant Medylton John yeoman 587961 587961 Medylton, John, of Elyng, yeoman 1
3903000 1991233 1991233 defendant Turver Thomas, senior yeoman 587961 587961 Turver, Thomas, senior, of Elyng, yeoman 2
3903001 1991233 1991233 defendant Lovell Henry yeoman 587961 587961 Lovell, Henry, of Elyng, yeoman 3
3903002 1991233 1991233 defendant Carde John smith 587961 587961 Carde, John, of Elyng, smith 4
3903003 1991233 1991233 defendant Canterton George yeoman 587961 587961 Canterton, George, of Elyng, yeoman 5
3903004 1991233 1991233 defendant Lovell Richard yeoman 587961 587961 Lovell, Richard, of Elyng, yeoman 6
3903005 1991233 1991233 defendant Russell John yeoman 587961 587961 Russell, John, of Elyng, yeoman 7
3903006 1991233 1991233 defendant Oldyng John yeoman 587961 587961 Oldyng, John, of Elyng, yeoman 8
3903010 1991234 1991234 defendant Turver Thomas, junior yeoman 587961 587961 Turver, Thomas, junior, of Elyng, yeoman 2
3903011 1991234 1991234 defendant Whytt William yeoman 587961 587961 Whytt, William, of Elyng, yeoman 3
3903012 1991234 1991234 defendant Jewell Richard yeoman 587961 587961 Jewell, Richard, of Elyng, yeoman 4
3906197 1992362 1992362 defendant Romsey alias Hoker Walter yeoman 587961 587961 Romsey alias Hoker, Walter, of Elyng, yeoman 4
3948282 2006459 2006459 defendant Warwyk Robert, junior husbandman 587961 587961 Warwyk, Robert, junior, of Elyng, husbandman 0
4216763 2101358 2101358 defendant Morrys Robert wheeler 587961 587961 Morrys, Robert, of Elyng, wheeler 0
4519619 2206496 2206496 defendant Pepil Roger   587961 587961 Pepil, Roger, of Elyng 0
4526095 2208457 2208457 defendant Herdman Thomas, sen   587961 587961 Herdman, Thomas, sen, of Elyng 0
4526096 2208457 2208457 defendant Bayly John   587961 587961 Bayly, John, of Elyng 1
4545866 2214638 2214638 defendant Cole Richard   587961 587961 Cole, Richard, of Elyng 0
4550274 2216032 2216032 defendant Turnour Stephen   587961 587961 Turnour, Stephen, of Elyng 1
4550275 2216032 2216032 defendant Turnour Peter   587961 587961 Turnour, Peter, of Elyng 2
4550276 2216032 2216032 defendant Kykil John   587961 587961 Kykil, John, of Elyng 3
4561397 2219513 2219513 defendant Warenere Robert   587961 587961 Warenere, Robert, of Elyng 0
4566853 2221195 2221195 defendant Cole Richard   587961 587961 Cole, Richard, of Elyng 0
4575680 2223907 2223907 defendant Haute Henry   587961 587961 Haute, Henry, of Elyng 0
4654741 2247361 2247361 defendant Cole Richard   587961 587961 Cole, Richard, of Elyng, franklin 0
4677749 2258659 2258659 defendant Brydgen Richard laborer 587961 587961 Brydgen, Richard, of Elyng, laborer 1
4677750 2258659 2258659 defendant Waleys William laborer 587961 587961 Waleys, William, of elyng, laborer 2
4677751 2258659 2258659 defendant Beffe John laborer 587961 587961 Beffe, John, of Elyng, laborer 3
4703185 2266376 2266376 defendant Brykedon Richard laborer 587961 587961 Brykedon, Richard, of Elyng, laborer 3
4703188 2266376 2266376 defendant Waleys William husbandman 587961 587961 Waleys, William, of Elyng, husbandman 6
4738314 2277079 2277079 defendant Baret John husbandman 587961 587961 Baret, John, of Elyng, husbandman 0
4765763 2285287 2285287 defendant Cole Richard gent 587961 587961 Cole, Richard, of Elyng, gent 0
4793805 2294182 2294182 defendant Cole Richard gent 587961 587961 Cole, Richard, of Elyng, gent 0
4800843 2296452 2296452 defendant Baret John yeoman 587961 587961 Baret, John, of Elyng, yeoman 0
4805480 2297925 2297925 defendant Baret John husbandman 587961 587961 Baret, John, of Elyng, husbandman 0
4829959 2305414 2305414 defendant Landaf Lewis   587961 587961 Landaf, Lewis, of Elyng, servant 1
4832891 2306309 2306309 defendant Hardyng John husbandman 587961 587961 Hardyng, John, of Elyng, husbandman 2
4833548 2306499 2306499 defendant Trot John husbandman 587961 587961 Trot, John, of Elyng, husbandman 0
4833549 2306499 2306499 defendant atte Yee John husbandman 587961 587961 atte Yee, John, of Elyng, husbandman 1
4895751 2325348 2325348 defendant Baret John yeoman 587961 587961 Baret, John, of Elyng, yeoman 0
4953841 2343111 2343111 defendant Gilbard Nicholas smith 587961 587961 Gilbard, Nicholas, of Elyng, smith 0
4969189 2347745 2347745 defendant Richard William husbandman 587961 587961 Richard, William, of Elyng, husbandman 3
4982651 2351724 2351724 defendant Vagull Thomas   587961 587961 Vagull, Thomas, of Elyng, holy water clerk 0
5067819 2376876 2376876 defendant Midelton John butcher 587961 587961 Midelton, John, of Elyng, butcher 2
5089207 2383213 2383213 defendant Hewe John husbandman 587961 587961 Hewe, John, of Elyng, husbandman 2
5091135 2383804 2383804 defendant Bailly John husbandman 587961 587961 Bailly, John, of Elyng, husbandman 1
5107915 2388754 2388754 defendant Prat John tailor 587961 587961 Prat, John, of Elyng, tailor 0
5134083 2396466 2396466 defendant Larkeys Roger husbandman 587961 587961 Larkeys, Roger, of Elyng, husbandman 0
5154986 2402613 2402613 defendant Baret Thomas gent 587961 587961 Baret, Thomas, of Elyng, gent 0
5154988 2402614 2402614 defendant Baret Thomas gent 587961 587961 Baret, Thomas, of Elyng, gent 0
5205521 2417360 2417360 defendant Skete John fishmonger 587961 587961 Skete, John, of Elyng, fishmonger 9
5266929 2435408 2435408 defendant Lorde Richard husbandman 587961 587961 Lorde, Richard, of Elyng, husbandman 0
5306617 2446968 2446968 defendant Godyere John husbandman 587961 587961 Godyere, John, of Elyng, husbandman 0
5366280 2465110 2465110 defendant Bedwyn Thomas yeoman 587961 587961 Bedwyn, Thomas, of Elyng, yeoman 1
5396942 2474209 2474209 defendant Beccles Thomas yeoman 587961 587961 Beccles, Thomas, of Elyng, yeoman 3
5408978 2477647 2477647 defendant Lake Henry clerk 587961 587961 Lake, Henry, of Elyng, clerk 0
5408979 2477647 2477647 defendant Smyth Robert yeoman 587961 587961 Smyth, Robert, of Elyng, yeoman 1
5410238 2478013 2478013 defendant Bodewyn Thomas yeoman 587961 587961 Bodewyn, Thomas, of Elyng, yeoman 3
5422351 2481630 2481630 defendant Lake Henry clerk 587961 587961 Lake, Henry, of Elyng, clerk 0
5422352 2481630 2481630 defendant Smyth Robert yeoman 587961 587961 Smyth, Robert, of Elyng, yeoman 1
5423959 2482119 2482119 defendant Bedwyn Thomas yeoman 587961 587961 Bedwyn, Thomas, of Elyng, yeoman 3
5423982 2482125 2482125 defendant Bedwyn Thomas yeoman 587961 587961 Bedwyn, Thomas, of Elyng, yeoman 3
5508012 2507400 2507400 defendant Waller John husbandman 587961 587961 Waller, John, of Elyng, husbandman 1
5520854 2511342 2511342 defendant Bokett John thatcher 587961 587961 Bokett, John, of Elyng, thatcher 0
5521989 2511695 2511695 defendant Fleccher Walter yeoman 587961 587961 Fleccher, Walter, of Elyng, yeoman 0
5527279 2513110 2513110 defendant Kelyng Robert husbandman 587961 587961 Kelyng, Robert, of Elyng, husbandman 0
5527280 2513110 2513110 defendant Kelyng Richard yeoman 587961 587961 Kelyng, Richard, of Elyng, yeoman 1
5527281 2513110 2513110 defendant Fleccher Walter, junior yeoman 587961 587961 Fleccher, Walter, junior, of Elyng, yeoman 2
5527445 2513166 2513166 defendant Kelyng Robert husbandman 587961 587961 Kelyng, Robert, of Elyng, husbandman 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);