names

323 rows where place_id = 593968

✎ 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
3614010 1872041 1872041 defendant Bruer William husbandman 593968 593968 Bruer, William, of Calne, husbandman 1
3620312 1873933 1873933 defendant Seneacre Edward husbandman 593968 593968 Seneacre, Edward, of Calne, husbandman 0
3620313 1873933 1873933 defendant Chaundeler William butcher 593968 593968 Chaundeler, William, of Calne, butcher 1
3624267 1875123 1875123 defendant Pynseke Robert butcher 593968 593968 Pynseke, Robert, of Calne, butcher 0
3642584 1908124 1908124 defendant Baker William weaver 593968 593968 Baker, William, of Calne, weaver 0
3646823 1909410 1909410 defendant Reve Thomas husbandman 593968 593968 Reve, Thomas, of Calne, husbandman 3
3646826 1909410 1909410 defendant Fynymore Richard gent 593968 593968 Fynymore, Richard, of Calne, gent 6
3646827 1909410 1909410 defendant Seman Thomas gent 593968 593968 Seman, Thomas, of Calne, gent 7
3646835 1909412 1909412 defendant Fynymore Richard gent 593968 593968 Fynymore, Richard, of Calne, gent 0
3646836 1909412 1909412 defendant Seman Thomas gent 593968 593968 Seman, Thomas, of Calne, gent 1
3646844 1909412 1909412 defendant Reve Thomas yeoman 593968 593968 Reve, Thomas, of Calne, yeoman 9
3673699 1917799 1917799 defendant Wodroff John husbandman 593968 593968 Wodroff, John, of Calne, husbandman 0
3685899 1921747 1921747 defendant Alen John clothman 593968 593968 Alen, John, of Calne, clothman 0
3701046 1926576 1926576 plaintiff Blake Roger gent 593968 593968 Blake, Roger, of Calne, gent 0
3751431 1942364 1942364 defendant Parson Henry husbandman 593968 593968 Parson, Henry, of Calne, husbandman 0
3788215 1954113 1954113 defendant Chever Rober husbandman 593968 593968 Chever, Rober, of Calne, husbandman 0
3788220 1954113 1954113 defendant Wodrose John husbandman 593968 593968 Wodrose, John, of Calne, husbandman 5
3788221 1954113 1954113 defendant Wyght Thomas husbandman 593968 593968 Wyght, Thomas, of Calne, husbandman 6
3809316 1960795 1960795 defendant Gryffyn John butcher 593968 593968 Gryffyn, John, of Calne, butcher 0
3824393 1965498 1965498 defendant Greffyth John butcher 593968 593968 Greffyth, John, of Calne, butcher 0
3824395 1965499 1965499 defendant Greffyth John butcher 593968 593968 Greffyth, John, of Calne, butcher 0
3838175 1969856 1969856 defendant Baker alias Horton Thomas clerk 593968 593968 Baker alias Horton, Thomas, of Calne, clerk 0
3879701 1983465 1983465 defendant Kyng Humphrey husbandman 593968 593968 Kyng, Humphrey, of Calne, husbandman 2
3899525 1990056 1990056 defendant Aleyn William clothier 593968 593968 Aleyn, William, of Calne, clothier 0
3909439 1993456 1993456 defendant Chever Robert (legal representative) 593968 593968 Chever, Robert, of Calne, husbandman, executrix of 1
3916810 1995988 1995988 defendant Nycolas Richard butcher 593968 593968 Nycolas, Richard, of Calne, butcher 0
3916811 1995988 1995988 defendant Forman John husbandman 593968 593968 Forman, John, of Calne, husbandman 1
3916812 1995988 1995988 defendant Walker William husbandman 593968 593968 Walker, William, of Calne, husbandman 2
3916815 1995989 1995989 defendant Nycolas Richard butcher 593968 593968 Nycolas, Richard, of Calne, butcher 0
3916816 1995989 1995989 defendant Forman John husbandman 593968 593968 Forman, John, of Calne, husbandman 1
3916817 1995989 1995989 defendant Walker William husbandman 593968 593968 Walker, William, of Calne, husbandman 2
3920278 1997118 1997118 defendant Spryngall William yeoman 593968 593968 Spryngall, William, of Calne, yeoman 1
3928423 1999844 1999844 defendant Coppe Bartholomew butcher 593968 593968 Coppe, Bartholomew, of Calne, butcher 0
3930201 2000448 2000448 plaintiff Collymore Thomas clothier 593968 593968 Collymore, Thomas, of Calne, clothier 0
3938289 2003144 2003144 defendant Danyell John yeoman 593968 593968 Danyell, John, of Calne, yeoman 0
3940263 2003763 2003763 defendant Parsons Robert husbandman 593968 593968 Parsons, Robert, of Calne, husbandman 0
3942458 2004487 2004487 defendant Spryngall William yeoman 593968 593968 Spryngall, William, of Calne, yeoman 1
3947097 2006050 2006050 defendant Allen William gent 593968 593968 Allen, William, of Calne, gent 0
3947099 2006051 2006051 defendant Allen William gent 593968 593968 Allen, William, of Calne, gent 0
3966768 2013012 2013012 defendant Massey Henry yeoman 593968 593968 Massey, Henry, of Calne, yeoman 1
3972040 2014778 2014778 plaintiff Forte Robert shoemaker 593968 593968 Forte, Robert, of Calne, shoemaker 0
3972041 2014778 2014778 defendant Chambers Edward yeoman 593968 593968 Chambers, Edward, of Calne, yeoman 0
3972349 2014900 2014900 defendant Bankes Walter husbandman 593968 593968 Bankes, Walter, of Calne, husbandman 0
3978575 2017084 2017084 defendant Norrys William butcher 593968 593968 Norrys, William, of Calne, butcher 1
3978576 2017084 2017084 defendant Browne William butcher 593968 593968 Browne, William, of Calne, butcher 2
3979670 2017485 2017485 defendant Braye George butcher 593968 593968 Braye, George, of Calne, butcher 0
3979671 2017485 2017485 defendant Were alias Browne Richard butcher 593968 593968 Were alias Browne, Richard, of Calne, butcher 1
3979672 2017485 2017485 defendant Were alias Browne William innholder 593968 593968 Were alias Browne, William, of Calne, innholder 2
3979673 2017485 2017485 defendant Welsted William smith 593968 593968 Welsted, William, of Calne, smith 3
3997955 2024028 2024028 defendant Colman William yeoman 593968 593968 Colman, William, of Calne, yeoman 0
3997957 2024029 2024029 defendant Colman William yeoman 593968 593968 Colman, William, of Calne, yeoman 0
3999422 2024554 2024554 plaintiff Fynamore Roger gent 593968 593968 Fynamore, Roger, of Calne, gent 0
4010065 2028365 2028365 defendant Clyfford alias Bartylmewe John yeoman 593968 593968 Clyfford alias Bartylmewe, John, of Calne, yeoman 1
4015694 2030311 2030311 plaintiff Somerford or Somers Richard husbandman 593968 593968 Somerford or Somers, Richard, of Calne, husbandman 0
4016492 2030604 2030604 defendant Danyell John yeoman 593968 593968 Danyell, John, of Calne, yeoman 0
4020090 2031908 2031908 defendant Browne William yeoman 593968 593968 Browne, William, of Calne, yeoman 0
4030338 2035504 2035504 defendant Clyff Thomas butcher 593968 593968 Clyff, Thomas, of Calne, butcher 0
4030339 2035504 2035504 defendant Colman William yeoman 593968 593968 Colman, William, of Calne, yeoman 1
4032080 2036141 2036141 defendant Robynson alias Peirs John clothman 593968 593968 Robynson alias Peirs, John, of Calne, clothman 2
4032084 2036142 2036142 defendant Robynson alias Peirs John yeoman or clothman 593968 593968 Robynson alias Peirs, John, of Calne, yeoman or clothman 2
4056589 2044744 2044744 defendant Clyfford alias Bartylmewe John yeoman 593968 593968 Clyfford alias Bartylmewe, John, of Calne, yeoman 2
4060928 2046316 2046316 defendant Jeyes Henry shoemaker 593968 593968 Jeyes, Henry, of Calne, shoemaker 1
4085436 2055067 2055067 defendant Gonne Richard yeoman 593968 593968 Gonne, Richard, of Calne, or of Dursley, Glos, yeoman 0
4086568 2055482 2055482 defendant Ryche Philip clerk 593968 593968 Ryche, Philip, of Calne, clerk 1
4087850 2055948 2055948 defendant Birkes Robert   593968 593968 Birkes, Robert, of Calne, yeoman, or of Doncaster, Yorks, mayor 0
4087875 2055956 2055956 defendant Holmes John tailor 593968 593968 Holmes, John, of Calne, or of Fyshelake, Yorks, tailor 0
4087877 2055957 2055957 defendant Stylle John butcher 593968 593968 Stylle, John, of Calne, or of Reddynge, Berks, butcher 0
4089715 2056617 2056617 defendant Pryce John yeoman 593968 593968 Pryce, John, of Calne, or of Barton Regis, Glos, yeoman 0
4090326 2056824 2056824 defendant Tynbury John   593968 593968 Tynbury, John, of Calne, mason 0
4091189 2057139 2057139 defendant Huck Thomas yeoman 593968 593968 Huck, Thomas, of Calne, or of Kelmyscatt, Oxon, yeoman 0
4092163 2057494 2057494 defendant Cheyne Thomas gent 593968 593968 Cheyne, Thomas, of Calne, or of West Woodhey, Berks, gent 0
4092165 2057495 2057495 defendant Cheyney Thomas gent 593968 593968 Cheyney, Thomas, of Calne, or of West Woodhey, Berks, gent 0
4092167 2057496 2057496 defendant Gryffyn Robert yeoman 593968 593968 Gryffyn, Robert, of Calne, or of Spenamland, Spene, yeoman 0
4092171 2057498 2057498 defendant Zouche Edmund esq 593968 593968 Zouche, Edmund, of Calne, or of Anstye, esq 0
4092475 2057613 2057613 defendant Knyght John gent 593968 593968 Knyght, John, of Calne, or of North Tydworth, gent 0
4092477 2057614 2057614 defendant Reade Henry gent 593968 593968 Reade, Henry, of Calne, or of St Martin in the Fields juxta Charing Crosse, Middx, gent 0
4092480 2057615 2057615 defendant Herlle William gent 593968 593968 Herlle, William, of Calne, gent 0
4093577 2058021 2058021 defendant Gwyn John gent 593968 593968 Gwyn, John, of Calne, or of London, gent 0
4094544 2058385 2058385 defendant Merynge William   593968 593968 Merynge, William, of Calne, knight 0
4095513 2058723 2058723 defendant Denyson Miles tailor 593968 593968 Denyson, Miles, of Calne, or of Bath, Soms, tailor 0
4095813 2058836 2058836 defendant Lee Rowland gent 593968 593968 Lee, Rowland, of Calne, or of Hoggesden, Middx, gent 0
4096175 2058960 2058960 defendant Chappell Roger husbandman 593968 593968 Chappell, Roger, of Calne, or of Streate, Soms, husbandman 0
4108962 2063460 2063460 defendant Warren William gent 593968 593968 Warren, William, of Calne, or of Stoke, Devon, gent 0
4109688 2063722 2063722 defendant Payne Anthony yeoman 593968 593968 Payne, Anthony, of Calne, or of Andever, Hants, yeoman 0
4110854 2064137 2064137 defendant Skealton William vintner 593968 593968 Skealton, William, of Calne, or of Woodstocke, Oxon, vintner 0
4111366 2064312 2064312 defendant Bonnett Roger tanner 593968 593968 Bonnett, Roger, of Calne, or of Wainehaiston, Suff, tanner 0
4111637 2064411 2064411 defendant Ollyffe Thomas butcher 593968 593968 Ollyffe, Thomas, of Calne, butcher 0
4111639 2064412 2064412 defendant Vyner Henry gent 593968 593968 Vyner, Henry, of Calne, gent 0
4111641 2064413 2064413 defendant Vyner Henry gent 593968 593968 Vyner, Henry, of Calne, gent 0
4113549 2065126 2065126 defendant Massy Henry gent 593968 593968 Massy, Henry, of Calne, gent 0
4113645 2065164 2065164 defendant Bonett Roger tanner 593968 593968 Bonett, Roger, of Calne, or of Wainehaston, Suff, tanner 0
4118042 2066738 2066738 defendant Clifforde Peter yeoman 593968 593968 Clifforde, Peter, of Calne, yeoman 0
4126023 2069592 2069592 defendant Bastell William tanner 593968 593968 Bastell, William, of Calne, or of Shawebridge, Berks, tanner 0
4126444 2069742 2069742 defendant Allen William gent 593968 593968 Allen, William, of Calne, gent 0
4135662 2073081 2073081 defendant Wickware Andrew miller 593968 593968 Wickware, Andrew, of Calne, miller 0
4149155 2077831 2077831 defendant Bastell William tanner 593968 593968 Bastell, William, of Calne, or of Sawbridge, Berks, tanner 0
4157693 2080765 2080765 defendant Neame William gent 593968 593968 Neame, William, of Calne, gent 0
4159755 2081481 2081481 defendant Wickware Andrew miller 593968 593968 Wickware, Andrew, of Calne, ,miller 0
4178298 2087880 2087880 defendant Whoodde Thomas tailor 593968 593968 Whoodde, Thomas, of Calne, tailor 0
4179291 2088233 2088233 defendant Allen Margaret widow 593968 593968 Allen, Margaret, of Calne, widow 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);