names

345 rows where place_id = 586504

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588900 1864175 1864175 defendant Body William husbandman 586504 586504 Body, William, of Frampton, husbandman 1
3598792 1867250 1867250 defendant Beell Robert husbandman 586504 586504 Beell, Robert, of Frampton, husbandman 3
3601272 1868061 1868061 defendant Okey Thomas husbandman 586504 586504 Okey, Thomas, of Frampton, husbandman 2
3611588 1871290 1871290 defendant Tysyn Robert husbandman 586504 586504 Tysyn, Robert, of Frampton, husbandman 2
3613057 1871736 1871736 defendant Broun Robert husbandman 586504 586504 Broun, Robert, of Frampton, husbandman 0
3654695 1911726 1911726 defendant Dyconson William laborer 586504 586504 Dyconson, William, of Frampton, laborer 2
3658218 1912825 1912825 defendant Hatherlegh alias Ferker Nicholas husbandman 586504 586504 Hatherlegh alias Ferker, Nicholas, of Frampton, husbandman 0
3667291 1915708 1915708 defendant Cleymond Alardus gent 586504 586504 Cleymond, Alardus, of Frampton, gent 0
3667672 1915834 1915834 defendant Cleymond Alfred   586504 586504 Cleymond, Alfred, of Frampton gent 0
3692237 1923741 1923741 defendant Evyngton Ralph husbandman 586504 586504 Evyngton, Ralph, of Frampton, husbandman 0
3692238 1923741 1923741 defendant Rychardson Ralph husbandman 586504 586504 Rychardson, Ralph, of Frampton, husbandman 1
3731729 1936153 1936153 defendant Rokes Richard painter 586504 586504 Rokes, Richard, of Frampton, painter 0
3766542 1947193 1947193 defendant Bartelett Richard husbandman 586504 586504 Bartelett, Richard, of Frampton, husbandman 0
3784446 1952917 1952917 defendant Bartelet Richard husbandman 586504 586504 Bartelet, Richard, of Frampton, husbandman 0
3789916 1954671 1954671 defendant Staunton William gent 586504 586504 Staunton, William, of Frampton, gent 0
3799362 1957723 1957723 defendant Staunton William gent 586504 586504 Staunton, William, of Frampton, gent 0
3799363 1957723 1957723 defendant Kyrke Oliver yeoman 586504 586504 Kyrke, Oliver, of Frampton, yeoman 1
3799364 1957723 1957723 defendant Hogekynson John yeoman 586504 586504 Hogekynson, John, of Frampton, yeoman 2
3799365 1957723 1957723 defendant Robynson Seth laborer 586504 586504 Robynson, Seth, of Frampton, laborer 3
3799366 1957723 1957723 defendant Whetley William laborer 586504 586504 Whetley, William, of Frampton, laborer 4
3799367 1957723 1957723 defendant Archebold William laborer 586504 586504 Archebold, William, of Frampton, laborer 5
3829582 1967141 1967141 defendant Astyn William fisher 586504 586504 Astyn, William, of Frampton, fisher 7
3829583 1967141 1967141 defendant Kodgyll John fisher 586504 586504 Kodgyll, John, of Frampton, fisher 8
3829584 1967141 1967141 defendant Elward Simon fisher 586504 586504 Elward, Simon, of Frampton, fisher 9
3829585 1967141 1967141 defendant Loveles Thomas husbandman 586504 586504 Loveles, Thomas, of Frampton, husbandman 10
3836123 1969212 1969212 defendant Thomson John (legal representative) 586504 586504 Thomson, John, of Frampton, yeoman, executor of 0
3836124 1969212 1969212 defendant Palmer Thomas gent 586504 586504 Palmer, Thomas, of Frampton, gent 1
3862587 1977682 1977682 defendant Dykson John husbandman 586504 586504 Dykson, John, of Frampton, husbandman 0
3864803 1978423 1978423 defendant Devenyshe Elias husbandman 586504 586504 Devenyshe, Elias, of Frampton, husbandman 0
3880801 1983847 1983847 defendant Jolyson William husbandman 586504 586504 Jolyson, William, of Frampton, husbandman 0
3880802 1983847 1983847 defendant Hedley William husbandman 586504 586504 Hedley, William, of Frampton, husbandman 1
3886104 1985602 1985602 defendant Trantor William yeoman 586504 586504 Trantor, William, of Frampton, yeoman 3
3892842 1987854 1987854 defendant Hedley William husbandman 586504 586504 Hedley, William, of Frampton, husbandman 0
3896748 1989124 1989124 defendant Sutler Richard husbandman 586504 586504 Sutler, Richard, of Frampton, husbandman 0
3910597 1993858 1993858 defendant Bate Thomas husbandman 586504 586504 Bate, Thomas, of Frampton, husbandman 0
3910599 1993859 1993859 defendant Bate Thomas husbandman 586504 586504 Bate, Thomas, of Frampton, husbandman 0
3910605 1993861 1993861 defendant Bate Thomas husbandman 586504 586504 Bate, Thomas, of Frampton, husbandman 0
3916008 1995739 1995739 defendant Woodward Robert husbandman 586504 586504 Woodward, Robert, of Frampton, husbandman 1
3916009 1995739 1995739 defendant Dyke Robert husbandman 586504 586504 Dyke, Robert, of Frampton, husbandman 2
3940266 2003764 2003764 plaintiff Snell Robert husbandman 586504 586504 Snell, Robert, of Frampton, husbandman 0
3957193 2009579 2009579 defendant Toght Thomas chapman 586504 586504 Toght, Thomas, of Frampton, chapman 0
3957195 2009580 2009580 defendant Toght Thomas chapman 586504 586504 Toght, Thomas, of Frampton, chapman 0
3963386 2011798 2011798 defendant Gover or Gouer Ralph husbandman 586504 586504 Gover or Gouer, Ralph, of Frampton, husbandman 0
3963387 2011798 2011798 defendant Bartelet John husbandman 586504 586504 Bartelet, John, of Frampton, husbandman 1
3963388 2011798 2011798 defendant Furlok alias Hatherley Richard husbandman 586504 586504 Furlok alias Hatherley, Richard, of Frampton, husbandman 2
3967041 2013098 2013098 plaintiff Browne John gent 586504 586504 Browne, John, of Frampton, gent 0
3973396 2015267 2015267 defendant Sydenham Christopher gent 586504 586504 Sydenham, Christopher, of Frampton, gent 0
3973397 2015267 2015267 defendant Bysshopp John husbandman 586504 586504 Bysshopp, John, of Frampton, husbandman 1
3973398 2015267 2015267 defendant Myller Thomas husbandman 586504 586504 Myller, Thomas, of Frampton, husbandman 2
3973399 2015267 2015267 defendant Tyser William husbandman 586504 586504 Tyser, William, of Frampton, husbandman 3
3973400 2015267 2015267 defendant Hodder John husbandman 586504 586504 Hodder, John, of Frampton, husbandman 4
3973722 2015383 2015383 defendant Cleymond George gent 586504 586504 Cleymond, George, of Frampton, gent 0
3993911 2022573 2022573 defendant Newport John yeoman 586504 586504 Newport, John, of Frampton, yeoman 0
3999740 2024665 2024665 plaintiff Garrard Richard yeoman 586504 586504 Garrard, Richard, of Frampton, yeoman 0
3999741 2024665 2024665 defendant Snell Thomas yeoman 586504 586504 Snell, Thomas, of Frampton, yeoman 0
4006672 2027166 2027166 defendant Richardson William yeoman 586504 586504 Richardson, William, of Frampton, yeoman 0
4006673 2027166 2027166 defendant Allyn Edward laborer 586504 586504 Allyn, Edward, of Frampton, laborer 1
4006974 2027269 2027269 defendant Richardson William yeoman 586504 586504 Richardson, William, of Frampton, yeoman 0
4006975 2027269 2027269 defendant Allyn Edward laborer 586504 586504 Allyn, Edward, of Frampton, laborer 1
4025671 2033834 2033834 plaintiff Browne John esq 586504 586504 Browne, John, of Frampton, esq 0
4095048 2058556 2058556 defendant Herne John yeoman 586504 586504 Herne, John, of Frampton, yeoman 2
4096604 2059113 2059113 defendant Holmes William yeoman 586504 586504 Holmes, William, of Frampton, yeoman 0
4128003 2070304 2070304 defendant Maber John husbandman 586504 586504 Maber, John, of Frampton, husbandman 0
4144350 2076184 2076184 defendant Blysse Thomas yeoman 586504 586504 Blysse, Thomas, of Frampton, yeoman 0
4162308 2082377 2082377 defendant Jones John mercer 586504 586504 Jones, John, of Frampton, mercer 1
4172314 2085782 2085782 defendant Allyn Robert husbandman 586504 586504 Allyn, Robert, of Frampton, husbandman 0
4172761 2085931 2085931 defendant Chewe Thomas yeoman 586504 586504 Chewe, Thomas, of Frampton, yeoman 0
4178134 2087822 2087822 defendant Blysse Thomas yeoman 586504 586504 Blysse, Thomas, of Frampton, yeoman 0
4199780 2095473 2095473 defendant Hewsdon John clerk 586504 586504 Hewsdon, John, of Frampton, clerk 2
4235348 2107928 2107928 defendant Garrett James yeoman 586504 586504 Garrett, James, of Frampton, yeoman 0
4236102 2108196 2108196 defendant Skelton George yeoman 586504 586504 Skelton, George, of Frampton, yeoman 2
4275064 2121231 2121231 defendant Blisse Thomas gent 586504 586504 Blisse, Thomas, of Frampton, or of Cirencester, gent 0
4282158 2123661 2123661 defendant Chawney Charles husbandman 586504 586504 Chawney, Charles, of Frampton, husbandman 0
4287330 2125524 2125524 defendant Skelton George yeoman 586504 586504 (Skelton, George, of Frampton, yeoman 1
4337396 2142815 2142815 defendant Frieston Robert yeoman 586504 586504 Frieston, Robert, of Frampton, yeoman 0
4360912 2151074 2151074 defendant Roche Hamond gent 586504 586504 Roche, Hamond, of Frampton, gent 0
4368682 2153850 2153850 defendant Addis John gent 586504 586504 Addis, John, of Frampton, gent 1
4376221 2156562 2156562 defendant Adyes John gent 586504 586504 Adyes, John, of Frampton, gent 0
4392522 2162120 2162120 defendant Blisse Thomas gent 586504 586504 Blisse, Thomas, of Frampton, gent 0
4424800 2172594 2172594 defendant Multon John de   586504 586504 Multon, John de, of Frampton, knight, son & heir of Thomas 0
4426015 2172941 2172941 plaintiff Multon John de   586504 586504 Multon, John de, of Frampton, knight 0
4433230 2175146 2175146 defendant Multon John de   586504 586504 Multon, John de, of Frampton, knight, son & heir of Thomas 0
4433240 2175149 2175149 defendant Multon John de   586504 586504 Multon, John de, of Frampton, knight 0
4434462 2175535 2175535 defendant Multon John de   586504 586504 Multon, John de, of Frampton, knight, son & heir of Thomas 0
4436800 2176250 2176250 defendant Selthe John   586504 586504 Selthe, John, of Frampton 2
4436806 2176251 2176251 defendant Selthe John   586504 586504 Selthe, John, of Frampton 3
4436809 2176252 2176252 defendant Selthe Robert   586504 586504 Selthe, Robert, of Frampton 0
4436810 2176252 2176252 defendant Selthe John   586504 586504 Selthe, John, of Frampton 1
4436812 2176253 2176253 defendant Selthe Robert   586504 586504 Selthe, Robert, of Frampton 0
4436813 2176253 2176253 defendant Selthe John   586504 586504 Selthe, John, of Frampton 1
4444894 2183377 2183377 plaintiff Copeldyk Stephen de   586504 586504 Copeldyk, Stephen de, of Frampton 0
4451409 2185413 2185413 defendant Austan Richard   586504 586504 Austan, Richard, of Frampton 0
4453156 2185993 2185993 defendant shirre William   586504 586504 shirre, William, of Frampton 1
4468413 2190783 2190783 defendant Cote Henry   586504 586504 Cote, Henry, of Frampton 0
4471064 2191607 2191607 defendant Claymond John   586504 586504 Claymond, John, of Frampton 0
4472793 2192161 2192161 defendant Ordyng John   586504 586504 Ordyng, John, of Frampton 0
4472808 2192167 2192167 defendant Claymond John   586504 586504 Claymond, John, of Frampton 0
4483699 2195594 2195594 plaintiff Ordyng John   586504 586504 Ordyng, John, of Frampton 0
4483700 2195594 2195594 defendant Quy Simon   586504 586504 Quy, Simon, of Frampton 0
4490118 2197628 2197628 defendant Astan Richard   586504 586504 Astan, Richard, of Frampton 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);