names

900 rows where place_id = 586842

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587682 1863792 1863792 defendant Keke John (legal representative) 586842 586842 Keke, John, of Cirencester, gent, executors of 0
3587687 1863794 1863794 plaintiff Arnold Thomas (legal representative) 586842 586842 Arnold, Thomas, of Cirencester, executor of Alcock, John, Bishop of Worcester, executrix of 0
3589780 1864444 1864444 defendant John Adam (legal representative) 586842 586842 John, Adam, of Cirencester, baker, executors of 0
3589781 1864444 1864444 defendant Compton John yeoman 586842 586842 (Compton, John, of Cirencester, yeoman 1
3592065 1865133 1865133 defendant Spycer John chapman 586842 586842 Spycer, John, of Cirencester, chapman 0
3592068 1865134 1865134 defendant Spycer John chapman 586842 586842 Spycer, John, of Cirencester, chapman 0
3592302 1865206 1865206 defendant Nele Thomas gracer 586842 586842 Nele, Thomas, of Cirencester, gracer 0
3592988 1865433 1865433 defendant Sutton John innholder 586842 586842 Sutton, John, of Cirencester, innholder 0
3592990 1865433 1865433 defendant Arderne Richard butcher 586842 586842 Arderne, Richard, of Cirencester, butcher 2
3594199 1865827 1865827 defendant Felpes Nicholas husbandman 586842 586842 Felpes, Nicholas, of Cirencester, husbandman 0
3594282 1865849 1865849 plaintiff Keke John (legal representative) 586842 586842 Keke, John, of Cirencester, gent, executors of 0
3594284 1865849 1865849 defendant Masser Richard mercer 586842 586842 Masser, Richard, of Cirencester, mercer 0
3594285 1865849 1865849 defendant Goldsmyth John goldsmith 586842 586842 Goldsmyth, John, of Cirencester, goldsmith 1
3597654 1866890 1866890 defendant Prat John grasier 586842 586842 Prat, John, of Cirencester, grasier 3
3599502 1867486 1867486 plaintiff Twyneho John (legal representative) 586842 586842 Twyneho, John, of Cirencester, gent, executors of 0
3600061 1867671 1867671 defendant Paynyswyk John yeoman 586842 586842 Paynyswyk, John, of Cirencester, yeoman 4
3600063 1867671 1867671 defendant Taillour William tailor 586842 586842 Taillour, William, of Cirencester, tailor 6
3600064 1867671 1867671 defendant Solas Richard husbandman 586842 586842 Solas, Richard, of Cirencester, husbandman 7
3600070 1867671 1867671 defendant Mose Thomas weaver 586842 586842 Mose, Thomas, of Cirencester, weaver 13
3600071 1867671 1867671 defendant Bedyll Matilda widow 586842 586842 Bedyll, Matilda, of Cirencester, widow 14
3600072 1867671 1867671 defendant Mason John yeoman 586842 586842 Mason, John, of Cirencester, yeoman 15
3608401 1870286 1870286 defendant Lyndesey Thomas yeoman 586842 586842 Lyndesey, Thomas, of Cirencester, yeoman 1
3613155 1871768 1871768 defendant Yerewyn Edward yeoman 586842 586842 Yerewyn, Edward, of Cirencester, yeoman 0
3613157 1871769 1871769 defendant Yerewyn Edward yeoman 586842 586842 Yerewyn, Edward, of Cirencester, yeoman 0
3615431 1872467 1872467 defendant Arderne Richard grasier 586842 586842 Arderne, Richard, of Cirencester, grasier 0
3616769 1872874 1872874 defendant Somerby Robert draper 586842 586842 Somerby, Robert, of Cirencester, draper 2
3622268 1874499 1874499 defendant Rikardis Robert clothier 586842 586842 Rikardis, Robert, of Cirencester, clothier 0
3622269 1874499 1874499 defendant Arderne Richard butcher 586842 586842 Arderne, Richard, of Cirencester, butcher 1
3622372 1874535 1874535 plaintiff Pratte Thomas (legal representative) 586842 586842 Pratte, Thomas, of Cirencester, executrix of 0
3631842 1904768 1904768 defendant Crofte Hugh weaver 586842 586842 Crofte, Hugh, of Cirencester, weaver 0
3631843 1904768 1904768 defendant Brigeman Walter miller 586842 586842 Brigeman, Walter, of Cirencester, miller 1
3631844 1904768 1904768 defendant Todde John laborer 586842 586842 Todde, John, of Cirencester, laborer 2
3635871 1906018 1906018 defendant Arnold John weaver 586842 586842 Arnold, John, of Cirencester, weaver 0
3658343 1912860 1912860 defendant Pole Leonard esq 586842 586842 Pole, Leonard, of Cirencester, esq 0
3658345 1912860 1912860 defendant Pen John yeoman 586842 586842 Pen, John, of Cirencester, yeoman 2
3658346 1912860 1912860 defendant Yate Thomas yeoman 586842 586842 Yate, Thomas, of Cirencester, yeoman 3
3658347 1912860 1912860 defendant Cove John yeoman 586842 586842 Cove, John, of Cirencester, yeoman 4
3659307 1913169 1913169 defendant Danys John weaver 586842 586842 Danys, John, of Cirencester, weaver 0
3672708 1917467 1917467 defendant Wellys Edward shoemaker 586842 586842 Wellys, Edward, of Cirencester, shoemaker 0
3675464 1918364 1918364 defendant Habgood Richard glover 586842 586842 Habgood, Richard, of Cirencester, glover 0
3678913 1919475 1919475 plaintiff Osmond Richard (legal representative) 586842 586842 Osmond, Richard, of Cirencester, executor of 0
3678915 1919475 1919475 defendant Aprice Morgan tailor 586842 586842 Aprice, Morgan, of Cirencester, tailor 0
3681728 1920381 1920381 defendant Rydeler Thomas husbandman 586842 586842 Rydeler, Thomas, of Cirencester, husbandman 2
3686067 1921802 1921802 defendant Straunge John gent 586842 586842 Straunge, John, of Cirencester, gent 0
3692044 1923681 1923681 defendant Sounde William yeoman 586842 586842 Sounde, William, of Cirencester, yeoman 1
3693005 1924016 1924016 plaintiff Leycettur Thomas mercer 586842 586842 Leycettur, Thomas, of Cirencester, mercer 0
3693006 1924016 1924016 defendant Whemyad Henry mercer 586842 586842 Whemyad, Henry, of Cirencester, mercer 0
3696517 1925139 1925139 defendant Martyn Thomas weaver 586842 586842 Martyn, Thomas, of Cirencester, weaver 1
3696688 1925189 1925189 defendant Marten Thomas weaver 586842 586842 Marten, Thomas, of Cirencester, weaver 0
3708048 1928817 1928817 defendant Richardis Robert (legal representative) 586842 586842 Richardis, Robert, of Cirencester, weaver, executors of 0
3708049 1928817 1928817 defendant Tolle Christopher gent 586842 586842 (Tolle, Christopher, of Cirencester, gent 1
3711180 1929802 1929802 defendant Leyceter Thomas mercer 586842 586842 Leyceter, Thomas, of Cirencester, mercer 0
3711181 1929803 1929803 plaintiff Straunge John gent 586842 586842 Straunge, John, of Cirencester, gent 0
3711182 1929803 1929803 defendant Snell Thomas fisher 586842 586842 Snell, Thomas, of Cirencester, fisher 0
3711183 1929803 1929803 defendant Donne or Doune Thomas tailor 586842 586842 Donne or Doune, Thomas, of Cirencester, tailor 1
3716452 1931439 1931439 plaintiff Cokk Richard (legal representative) 586842 586842 Cokk, Richard, of Cirencester, yeoman, executor of 0
3716454 1931439 1931439 defendant Pudsey Roger butcher 586842 586842 Pudsey, Roger, of Cirencester, butcher 0
3726231 1934472 1934472 defendant Parsall William laborer 586842 586842 Parsall, William, of Cirencester, laborer 2
3726237 1934473 1934473 defendant Parsall William laborer 586842 586842 Parsall, William, of Cirencester, laborer 2
3726243 1934474 1934474 defendant Parsall William laborer 586842 586842 Parsall, William, of Cirencester, laborer 2
3733172 1936607 1936607 defendant Russell Richard fletcher 586842 586842 Russell, Richard, of Cirencester, fletcher 2
3739576 1938589 1938589 defendant Newcombe John draper 586842 586842 Newcombe, John, of Cirencester, draper 0
3765525 1946880 1946880 defendant Benfeld Elizabeth widow 586842 586842 Benfeld, Elizabeth, of Cirencester, widow 1
3768329 1947735 1947735 defendant North John shoemaker 586842 586842 North, John, of Cirencester, shoemaker 0
3769483 1948116 1948116 defendant Donne or Doune Thomas draper 586842 586842 Donne or Doune, Thomas, of Cirencester, draper 0
3771877 1948894 1948894 defendant Westewod John innholder 586842 586842 (Westewod, John, of Cirencester, innholder 1
3792102 1955383 1955383 defendant Vayne John butcher 586842 586842 Vayne, John, of Cirencester, butcher 3
3804201 1959247 1959247 defendant Tolle Elizabeth widow 586842 586842 Tolle, Elizabeth, of Cirencester, widow 0
3805661 1959714 1959714 plaintiff Toll Christopher (legal representative) 586842 586842 Toll, Christopher, of Cirencester, gent, executrix of 0
3820733 1964374 1964374 defendant Tolle Isabel widow 586842 586842 Tolle, Isabel, of Cirencester, widow 1
3827145 1966352 1966352 defendant Vyncent Richard innholder 586842 586842 Vyncent, Richard, of Cirencester, innholder 0
3828929 1966930 1966930 defendant Donne Thomas draper or dyer 586842 586842 Donne, Thomas, of Cirencester, draper or dyer 0
3829235 1967026 1967026 defendant Lewes Marion widow 586842 586842 Lewes, Marion, of Cirencester, widow 3
3829792 1967211 1967211 defendant Surman John glover 586842 586842 Surman, John, of Cirencester, glover 0
3833412 1968377 1968377 defendant Vynor Richard chandler 586842 586842 Vynor, Richard, of Cirencester, chandler 0
3833413 1968377 1968377 defendant Meryng John barber 586842 586842 Meryng, John, of Cirencester, barber 1
3833414 1968377 1968377 defendant Peresall William husbandman 586842 586842 Peresall, William, of Cirencester, husbandman 2
3865798 1978790 1978790 defendant Byrchar Philip gilder 586842 586842 Byrchar, Philip, of Cirencester, gilder 0
3879734 1983478 1983478 defendant Watson Richard innholder 586842 586842 Watson, Richard, of Cirencester, innholder 0
3906124 1992338 1992338 defendant Owney John glover 586842 586842 Owney, John, of Cirencester, glover 4
3907721 1992871 1992871 plaintiff Penyngton John shoemaker 586842 586842 Penyngton, John, of Cirencester, shoemaker 0
3907722 1992871 1992871 defendant Nycolas Richard weaver 586842 586842 Nycolas, Richard, of Cirencester, weaver 0
3907723 1992871 1992871 defendant Tayler John innholder 586842 586842 Tayler, John, of Cirencester, innholder 1
3907725 1992871 1992871 defendant Nycolas John (legal representative) 586842 586842 Nycolas, John, of Cirencester, weaver, executrix of 3
3907726 1992871 1992871 defendant Nycolas Edith widow 586842 586842 Nycolas, Edith, of Cirencester, widow 4
3908975 1993296 1993296 defendant Style William innholder 586842 586842 Style, William, of Cirencester, innholder 0
3924433 1998482 1998482 defendant Bradford Thomas fishmonger 586842 586842 Bradford, Thomas, of Cirencester, fishmonger 2
3940697 2003895 2003895 defendant Wood Robert chaundeler 586842 586842 Wood, Robert, of Cirencester, chaundeler 1
3947341 2006141 2006141 defendant Moreton John laborer 586842 586842 Moreton, John, of Cirencester, laborer 0
3953934 2008446 2008446 defendant Bradford Thomas yeoman 586842 586842 Bradford, Thomas, of Cirencester, yeoman 0
3966729 2012997 2012997 defendant Gryffyth James yeoman 586842 586842 Gryffyth, James, of Cirencester, yeoman 2
3988465 2020618 2020618 defendant Pantyng Thomas baker 586842 586842 Pantyng, Thomas, of Cirencester, baker 0
3988466 2020618 2020618 defendant Hall Richard chapman or woollen draper 586842 586842 Hall, Richard, of Cirencester, chapman or woollen draper 1
3990785 2021462 2021462 defendant James Philip chapman 586842 586842 James, Philip, of Cirencester, chapman 1
3993514 2022426 2022426 plaintiff Chaperleyn John innholder 586842 586842 Chaperleyn, John, of Cirencester, innholder 0
3994500 2022781 2022781 defendant Ven Thomas capper 586842 586842 Ven, Thomas, of Cirencester, capper 1
3995820 2023253 2023253 plaintiff Cryps Richard   586842 586842 Cryps, Richard, of Cirencester, card maker 0
3999923 2024742 2024742 plaintiff George Christopher gent 586842 586842 George, Christopher, of Cirencester, gent 0
4004526 2026392 2026392 defendant Webbe Thomas innholder 586842 586842 Webbe, Thomas, of Cirencester, innholder 0
4004528 2026393 2026393 defendant Webbe Thomas innholder 586842 586842 Webbe, Thomas, of Cirencester, innholder 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);