names

107 rows where place_id = 591145

✎ 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
3603476 1868753 1868753 defendant Togye Joan widow 591145 591145 Togye, Joan, of Hungerford, Berks, widow 3
3653656 1911407 1911407 defendant Jenyns Richard (legal representative) 591145 591145 Jenyns, Richard, of Hungerford, Berks, tanner, executrix of 4
3696342 1925077 1925077 defendant Wrenne William yeoman 591145 591145 Wrenne, William, of Hungerford, Berks, yeoman 0
3696704 1925195 1925195 defendant Edon John   591145 591145 Edon, John, of Hungerford, Berks 0
3703535 1927382 1927382 defendant Kyrton Jenever innholder 591145 591145 Kyrton, Jenever, of Hungerford, Berks, innholder 0
3723638 1933667 1933667 defendant Mason Thomas mercer 591145 591145 Mason, Thomas, of Hungerford, Berks, mercer 1
3768210 1947696 1947696 defendant Bonoure William clothier 591145 591145 Bonoure, William, of Hungerford, Berks, clothier 3
3768216 1947697 1947697 defendant Bonoure William clothier 591145 591145 Bonoure, William, of Hungerford, Berks, clothier 3
3787913 1954010 1954010 defendant Mason Thomas yeoman 591145 591145 Mason, Thomas, of Hungerford, Berks, yeoman 0
3788858 1954321 1954321 defendant Lovelayk George   591145 591145 Lovelayk, George, of Hungerford, Berks, apothecary or grocer 0
3800161 1957972 1957972 defendant Lovelake George chapman 591145 591145 Lovelake, George, of Hungerford, Berks, chapman 0
3804090 1959204 1959204 defendant Mason Thomas yeoman 591145 591145 Mason, Thomas, of Hungerford, Berks, yeoman 0
3805832 1959764 1959764 defendant Fawler Thomas yeoman 591145 591145 Fawler, Thomas, of Hungerford, Berks, yeoman 0
3839018 1970129 1970129 defendant Faller Ralph chapman 591145 591145 Faller, Ralph, of Hungerford, Berks, chapman 0
3839036 1970135 1970135 defendant Faller Ralph chapman 591145 591145 Faller, Ralph, of Hungerford, Berks, chapman 0
3843782 1971590 1971590 defendant Kyrton Jeniver (legal representative) 591145 591145 Kyrton, Jeniver, of Hungerford, Berks, butcher, executors of 0
3915448 1995534 1995534 defendant Hedache Thomas clothier 591145 591145 Hedache, Thomas, of Hungerford, Berks, clothier 1
3920151 1997075 1997075 defendant Hedache Thomas chapman 591145 591145 Hedache, Thomas, of Hungerford, Berks, chapman 1
3930468 2000536 2000536 defendant Lovelake George mercer 591145 591145 Lovelake, George, of Hungerford, Berks, mercer 1
3944637 2005222 2005222 defendant Collyns John mercer 591145 591145 Collyns, John, of Hungerford, Berks, mercer 0
3946618 2005885 2005885 plaintiff Canon William (legal representative) 591145 591145 Canon, William, of Hungerford, Berks, executors of 0
3946624 2005886 2005886 plaintiff Canon William (legal representative) 591145 591145 Canon, William, of Hungerford, Berks, executors of 0
3946628 2005887 2005887 plaintiff Canon William (legal representative) 591145 591145 Canon, William, of Hungerford, Berks, executors of 0
3946633 2005888 2005888 plaintiff Canon William (legal representative) 591145 591145 Canon, William, of Hungerford, Berks, yeoman, executors of 0
3951416 2007558 2007558 defendant Wythers Christopher miller 591145 591145 Wythers, Christopher, of Hungerford, Berks, miller 0
3952957 2008103 2008103 defendant Collyns John chapman 591145 591145 Collyns, John, of Hungerford, Berks, chapman 0
3952974 2008108 2008108 defendant Collyns John chapman 591145 591145 Collyns, John, of Hungerford, Berks, chapman 1
3974026 2015486 2015486 defendant Lovelake John chapman 591145 591145 Lovelake, John, of Hungerford, Berks, chapman 1
3980125 2017655 2017655 plaintiff Pashyn Nicholas   591145 591145 Pashyn, Nicholas, of Hungerford, Berks 0
3980137 2017661 2017661 plaintiff Passhyn Nicholas clothier 591145 591145 Passhyn, Nicholas, of Hungerford, Berks, clothier 0
3980139 2017662 2017662 plaintiff Passhyn Nicholas clothman 591145 591145 Passhyn, Nicholas, of Hungerford, Berks, clothman 0
3997599 2023890 2023890 defendant Gyllet Thomas yeoman 591145 591145 Gyllet, Thomas, of Hungerford, Berks, yeoman 0
4017967 2031142 2031142 defendant Wren John husbandman 591145 591145 Wren, John, of Hungerford, Berks, husbandman 0
4034316 2036942 2036942 defendant Lovelak Roger yeoman 591145 591145 Lovelak, Roger, of Hungerford, Berks, yeoman 0
4034626 2037060 2037060 defendant Lovelake John chapman 591145 591145 Lovelake, John, of Hungerford, Berks, chapman 0
4040823 2039210 2039210 defendant Lovelak Roger yeoman 591145 591145 Lovelak, Roger, of Hungerford, Berks, yeoman 0
4051688 2043024 2043024 defendant Lovelace Roger chapman 591145 591145 Lovelace, Roger, of Hungerford, Berks, chapman 0
4051695 2043025 2043025 defendant Lovelake George chapman 591145 591145 Lovelake, George, of Hungerford, Berks, chapman 5
4051701 2043026 2043026 defendant Lovelake George chapman 591145 591145 Lovelake, George, of Hungerford, Berks, chapman 4
4052812 2043441 2043441 defendant Lovelacke John chapman 591145 591145 Lovelacke, John, of Hungerford, Berks, chapman 0
4062453 2046862 2046862 defendant Lovelake John yeoman 591145 591145 Lovelake, John, of Hungerford, Berks, yeoman 0
4104758 2061978 2061978 defendant Horsehyll Edward yeoman 591145 591145 Horsehyll, Edward, of Hungerford, Berks, yeoman 1
4126981 2069942 2069942 defendant Hedache George husbandman 591145 591145 Hedache, George, of Hungerford, Berks, husbandman 0
4136278 2073320 2073320 defendant Passyon Robert yeoman 591145 591145 Passyon, Robert, of Hungerford, Berks, yeoman 2
4138121 2073999 2073999 defendant Passyon Robert chapman 591145 591145 Passyon, Robert, of Hungerford, Berks, chapman 1
4148451 2077587 2077587 defendant Passion Robert mercer 591145 591145 Passion, Robert, of Hungerford, Berks, chapman, or of London, mercer 0
4164145 2082986 2082986 defendant Allen Thomas butcher 591145 591145 Allen, Thomas, of Hungerford, Berks, butcher 0
4203721 2096858 2096858 defendant Passyon or Pasyence Robert chapman 591145 591145 Passyon or Pasyence, Robert, of Hungerford, Berks, chapman 4
4298579 2129598 2129598 defendant Morrys John yeoman 591145 591145 Morrys, John, of Hungerford, Berks, yeoman 2
4374984 2156113 2156113 defendant Pottinger William clothier 591145 591145 Pottinger, William, of Hungerford, Berks, clothier 0
4653742 2247093 2247093 defendant Clerk William   591145 591145 Clerk, William, of Hungerford, Berks, holy water clerk 4
4686171 2261270 2261270 defendant Dyer John dyer 591145 591145 Dyer, John, of Hungerford, Berks, dyer 1
4691156 2262754 2262754 defendant Dyer John husbandman 591145 591145 Dyer, John, of Hungerford, Berks, husbandman 2
4704243 2266703 2266703 defendant Bocher Roger husbandman 591145 591145 Bocher, Roger, of Hungerford, Berks, husbandman 0
4721259 2271981 2271981 defendant Dyere John dyer 591145 591145 Dyere, John, of Hungerford, Berks, dyer 0
4725965 2273407 2273407 defendant Clyter John ploughman 591145 591145 Clyter, John, of Hungerford, Berks, ploughman 0
4728103 2274037 2274037 defendant Davy Walter husbandman 591145 591145 Davy, Walter, of Hungerford, Berks, husbandman 1
4753718 2281535 2281535 defendant Dyer John dyer 591145 591145 Dyer, John, of Hungerford, Berks, dyer 2
4753722 2281536 2281536 defendant Dyer John dyer 591145 591145 Dyer, John, of Hungerford, Berks, dyer 2
4754033 2281644 2281644 defendant Cleter John husbandman 591145 591145 Cleter, John, of Hungerford, Berks, husbandman 0
4773856 2287803 2287803 defendant Parker William   591145 591145 (Parker, William, of Hungerford, Berks, park man 1
4801269 2296585 2296585 defendant Clyter John husbandman 591145 591145 Clyter, John, of Hungerford, Berks, husbandman 0
4832497 2306190 2306190 defendant Bocher Richard yeoman 591145 591145 Bocher, Richard, of Hungerford, Berks, yeoman 1
4905850 2328432 2328432 defendant Gorway John dyer 591145 591145 Gorway, John, of Hungerford, Berks, dyer 2
4914743 2331127 2331127 defendant Purre John baker 591145 591145 Purre, John, of Hungerford, Berks, baker 1
4985730 2352649 2352649 plaintiff Robynvill Nicholas   591145 591145 Robynvill, Nicholas, of Hungerford, Berks 1
4992108 2354530 2354530 defendant Horshull William husbandman 591145 591145 Horshull, William, of Hungerford, Berks, husbandman 0
5002844 2357735 2357735 defendant Pounde William husbandman 591145 591145 Pounde, William, of Hungerford, Berks, husbandman 3
5002849 2357736 2357736 defendant Pounde William husbandman 591145 591145 Pounde, William, of Hungerford, Berks, husbandman 3
5094499 2384799 2384799 defendant Togyle John mercer 591145 591145 Togyle, John, of Hungerford, Berks, mercer 0
5133301 2396227 2396227 defendant Hoskyn Thomas yeoman 591145 591145 Hoskyn, Thomas, of Hungerford, Berks, yeoman 0
5143988 2399388 2399388 defendant Touker Thomas fuller 591145 591145 Touker, Thomas, of Hungerford, Berks, fuller 1
5161337 2404409 2404409 defendant Taillour Henry tailor 591145 591145 Taillour, Henry, of Hungerford, Berks, tailor 4
5199223 2415525 2415525 defendant Boucher William butcher 591145 591145 Boucher, William, of Hungerford, Berks, butcher 0
5200174 2415806 2415806 defendant Boucher William butcher 591145 591145 Boucher, William, of Hungerford, Berks, butcher 0
5208185 2418123 2418123 defendant Home John (legal representative) 591145 591145 Home, John, of Hungerford, Berks, dyer, executors of 1
5210143 2418695 2418695 defendant Hoysshkyns Thomas yeoman 591145 591145 Hoysshkyns, Thomas, of Hungerford, Berks, yeoman 3
5211381 2419061 2419061 defendant Boucher William butcher 591145 591145 Boucher, William, of Hungerford, Berks, butcher 0
5217714 2420910 2420910 defendant Tukhull John clothier 591145 591145 Tukhull, John, of Hungerford, Berks, clothier 13
5219147 2421327 2421327 defendant Tukhill John chapman 591145 591145 Tukhill, John, of Hungerford, Berks, chapman 0
5267885 2435719 2435719 plaintiff Tukhill John mercer 591145 591145 Tukhill, John, of Hungerford, Berks, mercer 1
5267888 2435720 2435720 plaintiff Tykhill John mercer 591145 591145 Tykhill, John, of Hungerford, Berks, mercer 1
5275460 2437891 2437891 defendant Dyer Thomas dyer 591145 591145 Dyer, Thomas, of Hungerford, Berks, dyer 2
5276587 2438229 2438229 defendant Waymouth Thomas merchant 591145 591145 Waymouth, Thomas, of Hungerford, Berks, merchant 1
5285208 2440696 2440696 defendant Tokyll Robert chapman 591145 591145 Tokyll, Robert, of Hungerford, Berks, chapman 1
5293995 2443217 2443217 defendant Boucher William butcher 591145 591145 Boucher, William, of Hungerford, Berks, butcher 0
5294037 2443229 2443229 defendant Boucher William butcher 591145 591145 Boucher, William,of Hungerford, Berks, butcher 0
5319131 2450815 2450815 defendant Trewelove alias Purcer John yeoman 591145 591145 Trewelove alias Purcer, John, of Hungerford, Berks, yeoman 4
5326165 2452918 2452918 defendant Boucher William butcher 591145 591145 Boucher, William, of Hungerford, Berks, butcher 0
5326167 2452919 2452919 defendant Boucher William butcher 591145 591145 Boucher, William, of Hungerford, Berks, butcher 0
5358943 2462846 2462846 defendant Clyfford Robert hosier 591145 591145 Clyfford, Robert, of Hungerford, Berks, hosier 2
5361504 2463620 2463620 defendant Yong John husbandman 591145 591145 Yong, John, of Hungerford, Berks, husbandman 3
5388500 2471763 2471763 defendant Jenyns Richard   591145 591145 Jenyns, Richard, of Hungerford, Berks 0
5401298 2475432 2475432 defendant Jenyns Richard tanner 591145 591145 Jenyns, Richard, of Hungerford, Berks, tanner 0
5404875 2476471 2476471 defendant Loveleg William husbandman 591145 591145 Loveleg, William, of Hungerford, Berks, husbandman 0
5411736 2478462 2478462 defendant Trewelove John yeoman 591145 591145 Trewelove, John, of Hungerford, Berks, yeoman 0
5414218 2479188 2479188 defendant Loveleg William husbandman 591145 591145 Loveleg, William, of Hungerford, Berks, husbandman 0
5414575 2479297 2479297 defendant Jenyns Richard tanner 591145 591145 Jenyns, Richard, of Hungerford, Berks, tanner 0
5426175 2482782 2482782 defendant Trewelove John yeoman 591145 591145 Trewelove, John, of Hungerford, Berks, yeoman 0
5426179 2482783 2482783 defendant Trewelove John yeoman 591145 591145 Trewelove, John, of Hungerford, Berks, yeoman 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);