names

127 rows where place_id = 586489

✎ 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
3588850 1864162 1864162 defendant Rede William cordwainer 586489 586489 Rede, William, of Holbeton, cordwainer 0
3621675 1874318 1874318 defendant Lampen Thomas clerk 586489 586489 Lampen, Thomas, of Holbeton, clerk 0
3628940 1903927 1903927 defendant Chubbe Simon yeoman 586489 586489 Chubbe, Simon, of Holbeton, yeoman 1
3650212 1910436 1910436 defendant Warwyk Walter yeoman 586489 586489 Warwyk, Walter, of Holbeton, yeoman 1
3650217 1910437 1910437 defendant Warwyk Walter yeoman 586489 586489 Warwyk, Walter, of Holbeton, yeoman 1
3660803 1913643 1913643 defendant Reynold Richard sheer man 586489 586489 Reynold, Richard, of Holbeton, sheer man 1
3676148 1918581 1918581 defendant Reynold Richard husbandman 586489 586489 Reynold, Richard, of Holbeton, husbandman 0
3749961 1941906 1941906 defendant Burell Robert gent 586489 586489 Burell, Robert, of Holbeton, gent 0
3755392 1943638 1943638 defendant Rowe Richard husbandman 586489 586489 Rowe, Richard, of Holbeton, husbandman 0
3765204 1946782 1946782 defendant Burell Robert gent 586489 586489 Burell, Robert, of Holbeton, gent 0
3768653 1947843 1947843 defendant Curteys John laborer 586489 586489 Curteys, John, of Holbeton, laborer 3
3779417 1951284 1951284 defendant Brend John husbandman 586489 586489 Brend, John, of Holbeton, husbandman 0
3858906 1976468 1976468 defendant Warwyke Walter gent 586489 586489 Warwyke, Walter, of Holbeton, gent 0
3875085 1981900 1981900 defendant Warwyke Walter gent 586489 586489 Warwyke, Walter, of Holbeton, gent 0
3881359 1984031 1984031 defendant Warwyke Walter   586489 586489 Warwyke, Walter, of Holbeton, franklin 0
3895763 1988792 1988792 defendant Chubb Walter husbandman 586489 586489 Chubb, Walter, of Holbeton, husbandman 0
3895764 1988792 1988792 defendant Chubb Richard   586489 586489 Chubb, Richard, of Holbeton, groom 1
3895766 1988793 1988793 defendant Chubb Walter husbandman 586489 586489 Chubb, Walter, of Holbeton, husbandman 0
3895767 1988793 1988793 defendant Chubb Richard   586489 586489 Chubb, Richard, of Holbeton, groom 1
3895768 1988793 1988793 defendant Roper Vincent   586489 586489 Roper, Vincent, of Holbeton, groom 2
3895769 1988793 1988793 defendant Chubb Agnes spinster 586489 586489 Chubb, Agnes, of Holbeton, spinster 3
3895770 1988793 1988793 defendant Tall Alice spinster 586489 586489 Tall, Alice, of Holbeton, spinster 4
3895771 1988793 1988793 defendant Roper Joan spinster 586489 586489 Roper, Joan, of Holbeton, spinster 5
3910046 1993665 1993665 defendant Chubbe Joan widow 586489 586489 Chubbe, Joan, of Holbeton, widow 0
3939028 2003386 2003386 defendant Peers Richard smith 586489 586489 Peers, Richard, of Holbeton, smith 0
3941942 2004315 2004315 defendant Frye David husbandman 586489 586489 Frye, David, of Holbeton, husbandman 0
3988876 2020767 2020767 defendant Gytsham or Eytsham John husbandman 586489 586489 Gytsham or Eytsham, John, of Holbeton, husbandman 1
3988877 2020767 2020767 defendant Facye Elias yeoman 586489 586489 Facye, Elias, of Holbeton, yeoman 2
3988878 2020767 2020767 defendant Chubb John yeoman 586489 586489 Chubb, John, of Holbeton, yeoman 3
4002284 2025600 2025600 defendant Dyllon Walter yeoman 586489 586489 Dyllon, Walter, of Holbeton, yeoman 0
4002289 2025603 2025603 plaintiff Hele John (legal representative) 586489 586489 Hele, John, of Holbeton, gent, executor of 0
4002295 2025604 2025604 plaintiff Hele John (legal representative) 586489 586489 Hele, John, of Holbeton, or of Lueston, yeoman, executor of 0
4002301 2025605 2025605 plaintiff Hele John (legal representative) 586489 586489 Hele, John, of Holbeton, yeoman, executor of 0
4002971 2025829 2025829 defendant Norrys Richard husbandman 586489 586489 Norrys, Richard, of Holbeton, husbandman 1
4002983 2025830 2025830 defendant Predys John yeoman 586489 586489 Predys, John, of Holbeton, yeoman 2
4006516 2027110 2027110 defendant Facye Elias husbandman 586489 586489 Facye, Elias, of Holbeton, husbandman 0
4011647 2028904 2028904 defendant Walke Richard husbandman 586489 586489 Walke, Richard, of Holbeton, husbandman 9
4015120 2030098 2030098 defendant Dyllon Walter yeoman 586489 586489 Dyllon, Walter, of Holbeton, yeoman 0
4016333 2030537 2030537 defendant Leay Andrew husbandman 586489 586489 Leay, Andrew, of Holbeton, husbandman 1
4016334 2030537 2030537 defendant Frye David husbandman 586489 586489 Frye, David, of Holbeton, husbandman 2
4018567 2031371 2031371 defendant Hengston Andrew husbandman 586489 586489 Hengston, Andrew, of Holbeton, husbandman 0
4029150 2035068 2035068 defendant Hele Elizabeth widow 586489 586489 Hele, Elizabeth, of Holbeton, widow 0
4029151 2035068 2035068 defendant Bounde Bartholomew carpenter 586489 586489 Bounde, Bartholomew, of Holbeton, carpenter 1
4047885 2041688 2041688 defendant Leye Andrew yeoman 586489 586489 Leye, Andrew, of Holbeton, yeoman 0
4193338 2093236 2093236 defendant Chubbe John yeoman 586489 586489 Chubbe, John, of Holbeton, yeoman 0
4290600 2126696 2126696 defendant Shepheard Nicholas yeoman 586489 586489 Shepheard, Nicholas, of Holbeton, yeoman 0
4332273 2141085 2141085 defendant Stachelye Richard gent 586489 586489 Stachelye, Richard, of Holbeton, gent 0
4467517 2190521 2190521 defendant Curtell Walter   586489 586489 Curtell, Walter, of Holbeton 0
4467520 2190522 2190522 defendant Curtelll Walter   586489 586489 Curtelll, Walter, of Holbeton 0
4479259 2194169 2194169 defendant Lymeger John   586489 586489 Lymeger, John, of Holbeton 2
4578918 2224888 2224888 defendant Wade John   586489 586489 Wade, John, of Holbeton 0
4589483 2228084 2228084 defendant Piers John   586489 586489 Piers, John, of Holbeton 0
4658255 2248461 2248461 defendant Dunne John husbandman 586489 586489 Dunne, John, of Holbeton, husbandman 0
4675601 2257979 2257979 defendant Hille William husbandman 586489 586489 Hille, William, of Holbeton, husbandman 0
4675603 2257979 2257979 defendant Veysy John husbandman 586489 586489 Veysy, John, of Holbeton, husbandman 2
4680757 2259599 2259599 defendant Tosere Andrew husbandman 586489 586489 Tosere, Andrew, of Holbeton, husbandman 0
4730079 2274608 2274608 defendant Torsere Andrew husbandman 586489 586489 Torsere, Andrew, of Holbeton, husbandman 0
4733143 2275543 2275543 defendant Ray William husbandman 586489 586489 Ray, William, of Holbeton, husbandman 0
4759075 2283188 2283188 defendant Fortescu John gent 586489 586489 Fortescu, John, of Holbeton, gent 0
4763863 2284688 2284688 defendant Oger William   586489 586489 Oger, William, of Holbeton, shoe maker 0
4763864 2284688 2284688 defendant Eye Reginald   586489 586489 Eye, Reginald, of Holbeton, arrow maker 1
4770528 2286761 2286761 defendant Paterson John gent 586489 586489 Paterson, John, of Holbeton, gent 0
4781190 2290127 2290127 defendant Fortescu John gent 586489 586489 Fortescu, John, of Holbeton, gent 0
4787637 2292203 2292203 defendant Oger John, senior laborer 586489 586489 together with Oger, John, senior, of Holbeton, laborer 4
4787638 2292203 2292203 defendant Oger John, junior laborer 586489 586489 Oger, John, junior, of Holbeton, laborer 5
4795296 2294680 2294680 defendant Fortescu John, senior gent 586489 586489 Fortescu, John, senior, of Holbeton, gent 0
4799926 2296161 2296161 defendant Gryme John clerk 586489 586489 Gryme, John, of Holbeton, clerk 0
4837620 2307699 2307699 defendant Bastard William gent 586489 586489 Bastard, William, of Holbeton, gent 0
4839150 2308175 2308175 defendant Oger Robert laborer 586489 586489 Oger, Robert, of Holbeton, laborer 0
4839151 2308175 2308175 defendant Forse John   586489 586489 Forse, John, of Holbeton, hoop maker 1
4839152 2308175 2308175 defendant Ryde John   586489 586489 Ryde, John, of Holbeton, shoe maker 2
4857964 2313859 2313859 defendant Rede John shoemaker 586489 586489 Rede, John, of Holbeton, shoemaker 2
4913704 2330786 2330786 defendant Adam John husbandman 586489 586489 Adam, John, of Holbeton, husbandman 0
4929768 2335724 2335724 defendant Adam John husbandman 586489 586489 Adam, John, of Holbeton, husbandman 4
4936241 2337733 2337733 defendant Nicoll John husbandman 586489 586489 Nicoll, John, of Holbeton, husbandman 3
4951497 2342428 2342428 defendant Veyse John husbandman 586489 586489 Veyse, John, of Holbeton, husbandman 0
4953711 2343071 2343071 defendant Forde William husbandman 586489 586489 Forde, William, of Holbeton, husbandman 3
4953712 2343071 2343071 defendant Adam John   586489 586489 Adam, John, of Holbeton, franklin 4
5004133 2358097 2358097 defendant Forde William husbandman 586489 586489 Forde, William, of Holbeton, husbandman 0
5049728 2371543 2371543 defendant Champernon Hugh esq 586489 586489 Champernon, Hugh, of Holbeton, esq 0
5060438 2374701 2374701 defendant Bokeram John, junior husbandman 586489 586489 Bokeram, John, junior, of Holbeton, husbandman 2
5060439 2374701 2374701 defendant Nicoll John husbandman 586489 586489 Nicoll, John, of Holbeton, husbandman 3
5076828 2379565 2379565 defendant Smyth William smith 586489 586489 Smyth, William, of Holbeton, smith 0
5087588 2382752 2382752 defendant Ritte John husbandman 586489 586489 Ritte, John, of Holbeton, husbandman 0
5087589 2382752 2382752 defendant Ritte John butcher 586489 586489 Ritte, John, of Holbeton, butcher 1
5093345 2384451 2384451 defendant Oger Thomas butcher 586489 586489 Oger, Thomas, of Holbeton, butcher 0
5093347 2384452 2384452 defendant Orger Thomas butcher 586489 586489 Orger, Thomas, of Holbeton, butcher 0
5110573 2389492 2389492 defendant Nicoll John, junior husbandman 586489 586489 Nicoll, John, junior, of Holbeton, husbandman 0
5110574 2389492 2389492 defendant Rendowe John husbandman 586489 586489 Rendowe, John, of Holbeton, husbandman 1
5132121 2395885 2395885 defendant Nicoll John, junior husbandman 586489 586489 Nicoll, John, junior, of Holbeton, husbandman 0
5132122 2395885 2395885 defendant Rendowe John husbandman 586489 586489 Rendowe, John, of Holbeton, husbandman 1
5201761 2416281 2416281 defendant Lydeston William   586489 586489 Lydeston, William, of Holbeton, franklin 0
5212790 2419488 2419488 defendant Lydston William   586489 586489 Lydston, William, of Holbeton, franklin 0
5222365 2422249 2422249 defendant Gaylard John chaplain 586489 586489 Gaylard, John, of Holbeton, chaplain 2
5224394 2422811 2422811 defendant Rytte John, junior husbandman 586489 586489 Rytte, John, junior, of Holbeton, husbandman 1
5237227 2426472 2426472 plaintiff Legh John   586489 586489 Legh, John, of Holbeton 1
5237228 2426472 2426472 defendant Forde William, senior husbandman 586489 586489 Forde, William, senior, of Holbeton, husbandman 0
5240116 2427310 2427310 defendant Rytte John butcher 586489 586489 Rytte, John, of Holbeton, butcher 0
5320436 2451194 2451194 defendant Lusshfeld Thomas fisher 586489 586489 Lusshfeld, Thomas, of Holbeton, fisher 0
5354283 2461407 2461407 defendant Dyer Thomas weaver 586489 586489 Dyer, Thomas, of Holbeton, weaver 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);