names

214 rows where place_id = 598486

✎ 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
3622547 1874588 1874588 defendant Hynkes William   598486 598486 Hynkes, William, of Chippenham, card maker 2
3632715 1905049 1905049 defendant Dyx John husbandman 598486 598486 Dyx, John, of Chippenham, husbandman 3
3641656 1907847 1907847 defendant Flemmyng Martin clothier 598486 598486 Flemmyng, Martin, of Chippenham, clothier 0
3661631 1913915 1913915 plaintiff Leche alias Flemyng Martin   598486 598486 Leche alias Flemyng, Martin, of Chippenham, cloth man 0
3668029 1915940 1915940 defendant Baker Robert yeoman 598486 598486 Baker, Robert, of Chippenham, yeoman 0
3670164 1916614 1916614 defendant Affarnell Nicholas weaver 598486 598486 Affarnell, Nicholas, of Chippenham, weaver 1
3670166 1916614 1916614 defendant Townesende William laborer 598486 598486 Townesende, William, of Chippenham, laborer 3
3670484 1916729 1916729 defendant Archer Thomas husbandman 598486 598486 Archer, Thomas, of Chippenham, husbandman 0
3674374 1918030 1918030 defendant Flemmyng Martin (legal representative) 598486 598486 Flemmyng, Martin, of Chippenham, clothman, executrix of 0
3674375 1918030 1918030 defendant Flemmyng Matilda widow 598486 598486 Flemmyng, Matilda, of Chippenham, widow 1
3675755 1918452 1918452 defendant Fynamour Walter gent 598486 598486 Fynamour, Walter, of Chippenham, gent 0
3677518 1919017 1919017 defendant Townesende William husbandman 598486 598486 Townesende, William, of Chippenham, husbandman 1
3693194 1924082 1924082 defendant Mores Agnes widow 598486 598486 Mores, Agnes, of Chippenham, widow 0
3693195 1924082 1924082 defendant Mores Joan spinster 598486 598486 Mores, Joan, of Chippenham, spinster 1
3700411 1926364 1926364 defendant Blake Richard yeoman 598486 598486 Blake, Richard, of Chippenham, yeoman 0
3700413 1926365 1926365 defendant Nasshe alias Baker William butcher 598486 598486 Nasshe alias Baker, William, of Chippenham, butcher 0
3717705 1931834 1931834 defendant Chesham Robert yeoman 598486 598486 Chesham, Robert, of Chippenham, yeoman 0
3717713 1931838 1931838 defendant Chesham alias Chippenham Robert yeoman 598486 598486 Chesham alias Chippenham, Robert, of Chippenham, yeoman 0
3724739 1934022 1934022 defendant Rycharson alias Kyngton John carrier 598486 598486 Rycharson alias Kyngton, John, of Chippenham, carrier 0
3725890 1934373 1934373 defendant Reede Thomas laborer 598486 598486 Reede, Thomas, of Chippenham, laborer 2
3769932 1948253 1948253 defendant Wylkys Thomas yeoman 598486 598486 (Wylkys, Thomas, of Chippenham, yeoman 1
3790409 1954819 1954819 defendant Farnewell Nicholas clothier 598486 598486 Farnewell, Nicholas, of Chippenham, clothier 0
4032079 2036141 2036141 defendant Hewes Thomas yeoman 598486 598486 Hewes, Thomas, of Chippenham, yeoman 1
4032083 2036142 2036142 defendant Hewys Thomas yeoman 598486 598486 Hewys, Thomas, of Chippenham, yeoman 1
4032087 2036143 2036143 defendant Baker Richard yeoman 598486 598486 Baker, Richard, of Chippenham, yeoman 1
4032088 2036143 2036143 defendant Baker Robert brother of Richard 598486 598486 Baker, Robert, of Chippenham, yeoman, brother of Richard 2
4032092 2036144 2036144 defendant Baker Richard yeoman 598486 598486 Baker, Richard, of Chippenham, yeoman 1
4047337 2041504 2041504 defendant Godby Richard glover 598486 598486 Godby, Richard, of Chippenham, glover 1
4047343 2041506 2041506 defendant Godby Richard glover 598486 598486 Godby, Richard, of Chippenham, glover 2
4054702 2044071 2044071 defendant Woodland Leonard husbandman 598486 598486 Woodland, Leonard, of Chippenham, husbandman 0
4082506 2054049 2054049 defendant Reade Nicholas gent 598486 598486 Reade, Nicholas, of Chippenham, gent 1
4112766 2064828 2064828 defendant Reade Nicholas gent 598486 598486 Reade, Nicholas, of Chippenham, gent 1
4168523 2084476 2084476 defendant Tackle John yeoman 598486 598486 Tackle, John, of Chippenham, yeoman 0
4172964 2085996 2085996 defendant Wrotesley Edmund gent 598486 598486 Wrotesley, Edmund, of Chippenham, gent 1
4180199 2088556 2088556 defendant Howe John husbandman 598486 598486 Howe, John, of Chippenham, or of Aysh Pryor, Soms, husbandman 0
4180201 2088557 2088557 defendant Howe John husbandman 598486 598486 Howe, John, of Chippenham, or of Aysh Pryor, Soms, husbandman 0
4183941 2089878 2089878 defendant Vuzarm Robert Wilts, haberdasher 598486 598486 Vuzarm Robert, of Chippenham, Wilts, haberdasher 1
4204682 2097184 2097184 defendant Shene Robert husbandman 598486 598486 Shene, Robert, of Chippenham, husbandman 2
4238420 2109053 2109053 defendant Fowler William carrier 598486 598486 Fowler, William, of Chippenham, carrier 0
4243971 2110964 2110964 defendant Reade Walter yeoman 598486 598486 Reade, Walter, of Chippenham, yeoman 1
4264219 2117682 2117682 defendant Barnes Francis shoemaker 598486 598486 Barnes, Francis, of Chippenham, shoemaker 0
4265945 2118248 2118248 defendant Lisschild or Liffchild John husbandman 598486 598486 Lisschild or Liffchild, John, of Chippenham, husbandman 0
4265946 2118248 2118248 defendant Potter John husbandman 598486 598486 Potter, John, of Chippenham, husbandman 1
4274967 2121197 2121197 defendant Coutley or Contley Edward husbandman 598486 598486 Coutley or Contley, Edward, of Chippenham, husbandman 0
4276141 2121601 2121601 defendant Gale Edmund shoemaker 598486 598486 Gale, Edmund, of Chippenham, shoemaker 0
4278952 2122572 2122572 defendant Vizer Arthur tanner 598486 598486 Vizer, Arthur, of Chippenham, tanner 1
4282877 2123910 2123910 plaintiff Vizar Arthur   598486 598486 Vizar, Arthur, of Chippenham 0
4316290 2135812 2135812 defendant Vizer Arthur tanner 598486 598486 Vizer, Arthur, of Chippenham, tanner 1
4340320 2143879 2143879 defendant Ford Thomas dyer 598486 598486 Ford, Thomas, of Chippenham, dyer 0
4352280 2148032 2148032 defendant Balden Eleanor widow 598486 598486 Balden, Eleanor, of Chippenham, widow 1
4359093 2150414 2150414 defendant Coleman Samuel tanner 598486 598486 Coleman, Samuel, of Chippenham, tanner 0
4359676 2150622 2150622 defendant Coleman Samuel tanner 598486 598486 Coleman, Samuel, of Chippenham, tanner 0
4376517 2156670 2156670 defendant Cobden John gent 598486 598486 Cobden, John, of Chippenham, or of Oxshott, Stoke, Surrey, gent 0
4454103 2186301 2186301 plaintiff Lote Thomas   598486 598486 Lote, Thomas, of Chippenham 0
4454104 2186301 2186301 plaintiff Irmongere Thomas   598486 598486 Irmongere, Thomas, of Chippenham 1
4481313 2194843 2194843 plaintiff Lote Thomas (legal representative) 598486 598486 Lote, Thomas, of Chippenham, executor of 0
4529402 2209481 2209481 defendant Barbour Henry   598486 598486 Barbour, Henry, of Chippenham 5
4529419 2209483 2209483 defendant Andrewe John   598486 598486 Andrewe, John, of Chippenham 0
4529426 2209483 2209483 defendant Barbour Henry   598486 598486 Barbour, Henry, of Chippenham 7
4544273 2214124 2214124 plaintiff Baron John   598486 598486 Baron, John, of Chippenham 0
4596319 2230101 2230101 defendant Buskyn John   598486 598486 Buskyn, John, of Chippenham 0
4605881 2232954 2232954 plaintiff atte Hamme John   598486 598486 atte Hamme, John, of Chippenham 0
4606317 2233090 2233090 defendant Gorewey Thomas dyer 598486 598486 Gorewey, Thomas, of Chippenham, dyer 0
4606318 2233090 2233090 defendant Pavy William   598486 598486 Pavy, William, of Chippenham 1
4614222 2235460 2235460 defendant Pavy William   598486 598486 Pavy, William, of Chippenham 1
4615397 2235824 2235824 defendant Monteyn William   598486 598486 Monteyn, William, of Chippenham 0
4630343 2240398 2240398 defendant Mounteyn William   598486 598486 Mounteyn, William, of Chippenham 2
4630344 2240399 2240399 plaintiff Stode William   598486 598486 Stode, William, of Chippenham 0
4630347 2240399 2240399 defendant Goreway Thomas   598486 598486 Goreway, Thomas, of Chippenham 2
4630349 2240399 2240399 defendant Monteyn William   598486 598486 Monteyn, William, of Chippenham 4
4639493 2243065 2243065 defendant Chaldebury John   598486 598486 Chaldebury, John, of Chippenham 2
4642285 2243861 2243861 defendant Covenant Richard   598486 598486 Covenant, Richard, of Chippenham 0
4647739 2245397 2245397 defendant Fissher Bartholomew   598486 598486 Fissher, Bartholomew, of Chippenham 0
4672496 2257047 2257047 plaintiff Coke Robert   598486 598486 Coke, Robert, of Chippenham 0
4677287 2258513 2258513 defendant Piper Walter husbandman 598486 598486 Piper, Walter, of Chippenham, husbandman 0
4690687 2262636 2262636 defendant Pavy William husbandman 598486 598486 Pavy, William, of Chippenham, husbandman 1
4692498 2263170 2263170 plaintiff atte Hamme John   598486 598486 atte Hamme, John, of Chippenham 0
4703279 2266403 2266403 defendant Spondell Nicholas   598486 598486 Spondell, Nicholas, of Chippenham, franklin 0
4706638 2267457 2267457 plaintiff Madame Bartholomew fishmonger 598486 598486 Madame, Bartholomew, of Chippenham, fishmonger 0
4711065 2268813 2268813 defendant Mason Robert laborer 598486 598486 Mason, Robert, of Chippenham, laborer 0
4717259 2270728 2270728 defendant Norfolk John husbandman 598486 598486 Norfolk, John, of Chippenham, husbandman 0
4717260 2270728 2270728 defendant Grene Roger husbandman 598486 598486 Grene, Roger, of Chippenham, husbandman 1
4717897 2270938 2270938 defendant Hales Christina   598486 598486 Hales, Christina, of Chippenham, widow, formerly wife of Edward 1
4717900 2270939 2270939 defendant Hales Christine   598486 598486 (Hales, Christine, of Chippenham, widow, formerly wife of Edward 1
4719531 2271449 2271449 defendant Londone Thomas husbandman 598486 598486 Londone, Thomas, of Chippenham, husbandman 0
4735565 2276274 2276274 defendant Jay Nicholas husbandman 598486 598486 Jay, Nicholas, of Chippenham, husbandman 0
4737369 2276804 2276804 defendant Buskyn Alexander husbandman 598486 598486 Buskyn, Alexander, of Chippenham, husbandman 0
4748268 2280002 2280002 defendant Bocher Nicholas husbandman 598486 598486 Bocher, Nicholas, of Chippenham, husbandman 0
4761444 2283922 2283922 defendant Pavy William husbandman 598486 598486 Pavy, William, of Chippenham, husbandman 2
4764433 2284863 2284863 plaintiff Helyer Walter   598486 598486 Helyer, Walter, of Chippenham 0
4764434 2284863 2284863 defendant Taillour David tailor 598486 598486 Taillour, David, of Chippenham, tailor 0
4766232 2285430 2285430 defendant Paternoster William husbandman 598486 598486 Paternoster, William, of Chippenham, husbandman 0
4766233 2285430 2285430 defendant Damene Walter butcher 598486 598486 Damene, Walter, of Chippenham, butcher 1
4768909 2286256 2286256 defendant Bukton John   598486 598486 Bukton, John, of Chippenham, yeoman, alias of London victualler 0
4771113 2286948 2286948 defendant Rook William, sen (legal representative) 598486 598486 Rook, William, sen, of Chippenham, butcher, executors of 0
4771114 2286948 2286948 defendant Swayn Walter tiler 598486 598486 (Swayn, Walter, of Chippenham, tiler 1
4776274 2288567 2288567 defendant Stere John draper 598486 598486 Stere, John, of Chippenham, draper 6
4782688 2290599 2290599 defendant Stokes Nicholas ostler 598486 598486 Stokes, Nicholas, of Chippenham, ostler 1
4805465 2297920 2297920 defendant Colerne Robert husbandman 598486 598486 Colerne, Robert, of Chippenham, husbandman 0
4812562 2300046 2300046 defendant Taillour Lewis husbandman 598486 598486 Taillour, Lewis, of Chippenham, husbandman 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);