names

135 rows where place_id = 591456

✎ 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
3604472 1869066 1869066 defendant Selwyn Richard gent 591456 591456 Selwyn, Richard, of Feltwell, gent 6
3606811 1869801 1869801 defendant Selwyn Richard gent 591456 591456 Selwyn, Richard, of Feltwell, gent 10
3616668 1872843 1872843 defendant Mathewe John husbandman 591456 591456 Mathewe, John, of Feltwell, husbandman 0
3620489 1873985 1873985 defendant Chyncheball William yeoman 591456 591456 Chyncheball, William, of Feltwell, yeoman 0
3620668 1874042 1874042 defendant Parseley Adam husbandman 591456 591456 Parseley, Adam, of Feltwell, husbandman 2
3632629 1905024 1905024 plaintiff Holyour Thomas   591456 591456 Holyour, Thomas, of Feltwell 0
3632633 1905024 1905024 defendant Yonger John husbandman 591456 591456 Yonger, John, of Feltwell, husbandman 3
3648899 1910044 1910044 defendant Russell Robert husbandman 591456 591456 Russell, Robert, of Feltwell, husbandman 1
3648900 1910044 1910044 defendant Donham Thomas husbandman 591456 591456 Donham, Thomas, of Feltwell, husbandman 2
3648901 1910044 1910044 defendant Noresse Osbert husbandman 591456 591456 Noresse, Osbert, of Feltwell, husbandman 3
3668046 1915946 1915946 defendant Cukkowe Thomas butcher 591456 591456 Cukkowe, Thomas, of Feltwell, butcher 0
3702612 1927083 1927083 defendant Baster or Caster Thomas husbandman 591456 591456 Baster or Caster, Thomas, of Feltwell, husbandman 2
3703901 1927500 1927500 defendant Bysshopp Thomas husbandman 591456 591456 Bysshopp, Thomas, of Feltwell, husbandman 0
3707570 1928662 1928662 defendant Trodes Alexander clerk 591456 591456 Trodes, Alexander, of Feltwell, clerk 0
3716402 1931422 1931422 defendant Baxster Thomas husbandman 591456 591456 Baxster, Thomas, of Feltwell, husbandman 2
3722234 1933211 1933211 defendant Ruddelond Robert husbandman 591456 591456 Ruddelond, Robert, of Feltwell, husbandman 2
3744265 1940104 1940104 plaintiff Atmere John   591456 591456 Atmere, John, of Feltwell 0
3750611 1942111 1942111 defendant Fyncham Thomas yeoman 591456 591456 Fyncham, Thomas, of Feltwell, yeoman 0
3756532 1944020 1944020 plaintiff Atmere John   591456 591456 Atmere, John, of Feltwell 0
3758333 1944602 1944602 defendant Hulyear Thomas laborer 591456 591456 Hulyear, Thomas, of Feltwell, laborer 1
3761487 1945604 1945604 defendant Mercer Robert chaplain 591456 591456 Mercer, Robert, of Feltwell, chaplain 0
3761488 1945604 1945604 defendant Mercer Christopher husbandman 591456 591456 Mercer, Christopher, of Feltwell, husbandman 1
3784074 1952799 1952799 defendant Rudlond John husbandman 591456 591456 Rudlond, John, of Feltwell, husbandman 3
3787879 1953999 1953999 defendant Turnor Margery widow 591456 591456 Turnor, Margery, of Feltwell, widow 0
3847597 1972818 1972818 defendant Taylour Richard clerk 591456 591456 Taylour, Richard, of Feltwell, clerk 1
3852386 1974346 1974346 defendant Moundford Francis esq 591456 591456 Moundford, Francis, of Feltwell, esq 3
3860661 1977058 1977058 defendant Rudlond John, senior husbandman 591456 591456 Rudlond, John, senior, of Feltwell, husbandman 0
3862803 1977751 1977751 defendant Wortys Henry husbandman 591456 591456 Wortys, Henry, of Feltwell, husbandman 0
3871203 1980623 1980623 defendant Halle Robert   591456 591456 Halle, Robert, of Feltwell, shepherd 0
3871205 1980623 1980623 defendant Newall Thomas yeoman 591456 591456 Newall, Thomas, of Feltwell, yeoman 2
3871206 1980623 1980623 defendant Danyell Francis husbandman 591456 591456 Danyell, Francis, of Feltwell, husbandman 3
3887911 1986206 1986206 defendant Tayllour Thomas clerk 591456 591456 Tayllour, Thomas, of Feltwell, clerk 0
3913278 1994771 1994771 defendant Asshill Peter tailor 591456 591456 Asshill, Peter, of Feltwell, tailor 0
3913700 1994922 1994922 defendant Palmer Thomas husbandman 591456 591456 Palmer, Thomas, of Feltwell, husbandman 0
3913701 1994922 1994922 defendant Rudlond John husbandman 591456 591456 Rudlond, John, of Feltwell, husbandman 1
3918009 1996390 1996390 defendant Brese Thomas husbandman 591456 591456 Brese, Thomas, of Feltwell, husbandman 2
3939655 2003569 2003569 defendant Warde William husbandman 591456 591456 Warde, William, of Feltwell, husbandman 3
3948827 2006656 2006656 defendant More John husbandman 591456 591456 More, John, of Feltwell, husbandman 0
3948840 2006661 2006661 plaintiff Dey William (legal representative) 591456 591456 Dey, William, of Feltwell, executors of 0
3949850 2007024 2007024 defendant Sutton William husbandman 591456 591456 Sutton, William, of Feltwell, husbandman 0
3962516 2011483 2011483 defendant Cokoo Robert husbandman 591456 591456 Cokoo, Robert, of Feltwell, husbandman 0
3995722 2023215 2023215 defendant Herlande William clerk 591456 591456 Herlande, William, of Feltwell, clerk 0
3996634 2023557 2023557 defendant Dey Thomas husbandman 591456 591456 Dey, Thomas, of Feltwell, husbandman 0
3996636 2023558 2023558 defendant Dey Thomas husbandman 591456 591456 Dey, Thomas, of Feltwell, husbandman 0
3999429 2024557 2024557 defendant Herland William clerk 591456 591456 Herland, William, of Feltwell, clerk 0
4018689 2031418 2031418 plaintiff Wace John   591456 591456 Wace, John, of Feltwell 0
4033288 2036559 2036559 defendant Palmer William husbandman 591456 591456 Palmer, William, of Feltwell, husbandman 3
4046125 2041052 2041052 defendant Harland William clerk 591456 591456 Harland, William, of Feltwell, clerk 0
4052416 2043284 2043284 defendant Day Thomas husbandman 591456 591456 Day, Thomas, of Feltwell, husbandman 0
4052417 2043284 2043284 defendant Palmer William husbandman 591456 591456 Palmer, William, of Feltwell, husbandman 1
4052423 2043286 2043286 defendant Dye or Deye Thomas husbandman 591456 591456 Dye or Deye, Thomas, of Feltwell, husbandman 0
4052427 2043288 2043288 defendant Palmer William husbandman 591456 591456 Palmer, William, of Feltwell, husbandman 0
4056884 2044843 2044843 defendant Gyslyngham Nicholas gent 591456 591456 Gyslyngham, Nicholas, of Feltwell, gent 0
4276308 2121657 2121657 defendant Cutler Nicholas gent 591456 591456 Cutler, Nicholas, of Feltwell, gent 0
4291731 2127119 2127119 defendant Scallen or Stallen Adam husbandman 591456 591456 Scallen or Stallen, Adam, of Feltwell, husbandman 2
4400041 2164601 2164601 defendant Cutler Charles gent 591456 591456 Cutler, Charles, of Feltwell, gent 1
4408093 2167278 2167278 defendant Edwardes Peter husbandman 591456 591456 Edwardes, Peter, of Feltwell, husbandman 0
4408094 2167278 2167278 defendant Bennett William husbandman 591456 591456 Bennett, William, of Feltwell, husbandman 1
4408745 2167521 2167521 defendant Stallon Richard husbandman 591456 591456 Stallon, Richard, of Feltwell, husbandman 0
4410806 2168203 2168203 defendant Turner John yeoman 591456 591456 Turner, John, of Feltwell, yeoman 1
4497787 2199951 2199951 defendant Fykeys John   591456 591456 Fykeys, John, of Feltwell 0
4497793 2199953 2199953 defendant Cook John   591456 591456 Cook, John, of Feltwell 1
4497795 2199953 2199953 defendant Yonge Richard   591456 591456 Yonge, Richard, of Feltwell 3
4497796 2199953 2199953 defendant Pers Thomas   591456 591456 Pers, Thomas, of Feltwell 4
4576205 2224058 2224058 defendant Parcheys John, sen   591456 591456 Parcheys, John, sen, of Feltwell 0
4583048 2226121 2226121 defendant Multon Thomas   591456 591456 Multon, Thomas, of Feltwell 0
4636355 2242206 2242206 defendant Est Henry   591456 591456 Est, Henry, of Feltwell 1
4758647 2283081 2283081 defendant Wynch Richard husbandman 591456 591456 Wynch, Richard, of Feltwell, husbandman 14
4758705 2283083 2283083 defendant Wynch Richard husbandman 591456 591456 Wynch, Richard, of Feltwell, husbandman 15
4842638 2309232 2309232 defendant Whytelegge Thomas laborer 591456 591456 Whytelegge, Thomas, of Feltwell, laborer 5
4897789 2325972 2325972 defendant atte Hache Henry   591456 591456 atte Hache, Henry, of Feltwell, cook 0
4906320 2328564 2328564 defendant Casshe John husbandman 591456 591456 Casshe, John, of Feltwell, husbandman 0
4948221 2341417 2341417 defendant Turnour Richard husbandman 591456 591456 Turnour, Richard, of Feltwell, husbandman 3
4959505 2344809 2344809 defendant Turnour Richard husbandman 591456 591456 Turnour, Richard, of Feltwell, husbandman 4
4959506 2344809 2344809 defendant Dey John husbandman 591456 591456 Dey, John, of Feltwell, husbandman 5
4962818 2345791 2345791 defendant Dey William husbandman 591456 591456 Dey, William, of Feltwell, husbandman 1
5028028 2365077 2365077 defendant Dunham Robert yeoman 591456 591456 Dunham, Robert, of Feltwell, yeoman 0
5049426 2371463 2371463 defendant Myles Simon husbandman 591456 591456 Myles, Simon, of Feltwell, husbandman 2
5074284 2378802 2378802 defendant Norys Richard husbandman 591456 591456 Norys, Richard, of Feltwell, husbandman 0
5074535 2378886 2378886 defendant Russell Adam yeoman 591456 591456 Russell, Adam, of Feltwell, yeoman 0
5090061 2383464 2383464 defendant Dunham Edmund chapman 591456 591456 Dunham, Edmund, of Feltwell, chapman 1
5092587 2384208 2384208 defendant Carll Robert husbandman 591456 591456 Carll, Robert, of Feltwell, husbandman 2
5101022 2386713 2386713 defendant Turnour Richard husbandman 591456 591456 Turnour, Richard, of Feltwell, husbandman 0
5101023 2386713 2386713 defendant Ostelyn John husbandman 591456 591456 Ostelyn, John, of Feltwell, husbandman 1
5101024 2386713 2386713 defendant Palmer John husbandman 591456 591456 Palmer, John, of Feltwell, husbandman 2
5101025 2386713 2386713 defendant Feryer Richard husbandman 591456 591456 Feryer, Richard, of Feltwell, husbandman 3
5131008 2395553 2395553 defendant Meye John chaplain 591456 591456 Meye, John, of Feltwell, chaplain 0
5133958 2396430 2396430 defendant Dunham Edmund mercer 591456 591456 Dunham, Edmund, of Feltwell, mercer 4
5133959 2396430 2396430 defendant Toneld John   591456 591456 Toneld, John, of Feltwell 5
5133960 2396430 2396430 defendant Wright John husbandman 591456 591456 Wright, John, of Feltwell, husbandman 6
5171142 2407282 2407282 defendant Dunham Edmund mercer 591456 591456 Dunham, Edmund, of Feltwell, mercer 2
5171151 2407282 2407282 defendant Toneld John weaver 591456 591456 Toneld, John, of Feltwell, weaver 11
5171153 2407282 2407282 defendant Wright John husbandman 591456 591456 Wright, John, of Feltwell, husbandman 13
5226591 2423439 2423439 defendant Wryght John husbandman 591456 591456 Wryght, John, of Feltwell, husbandman 0
5226592 2423439 2423439 defendant Douse William husbandman 591456 591456 Douse, William, of Feltwell, husbandman 1
5226594 2423439 2423439 defendant Mathewe John yeoman 591456 591456 Mathewe, John, of Feltwell, yeoman 3
5232190 2424991 2424991 defendant Westhorp Robert yeoman 591456 591456 Westhorp, Robert, of Feltwell, yeoman 0
5235653 2426009 2426009 plaintiff Deye John   591456 591456 Deye, John, of Feltwell 0
5259802 2433188 2433188 defendant Mowdforde Richard husbandman 591456 591456 Mowdforde, Richard, of Feltwell, husbandman 0
5278664 2438865 2438865 defendant Chynchenald William yeoman 591456 591456 Chynchenald, William, of Feltwell, 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);