names

84 rows where place_id = 594965

✎ 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
3618287 1873347 1873347 defendant Adcoke William clothmaker 594965 594965 Adcoke, William, of Stapleherst, clothmaker 2
3663783 1914606 1914606 defendant Herenden Walter gent 594965 594965 Herenden, Walter, of Stapleherst, gent 0
3673828 1917845 1917845 defendant Roberthe Henry clothmaker 594965 594965 Roberthe, Henry, of Stapleherst, clothmaker 0
3673829 1917845 1917845 defendant Williams Lawrence husbandman 594965 594965 Williams, Lawrence, of Stapleherst, husbandman 1
3689800 1922966 1922966 defendant Batherst John husbandman 594965 594965 Batherst, John, of Stapleherst, husbandman 0
3698807 1925846 1925846 defendant Patynden Henry husbandman 594965 594965 Patynden, Henry, of Stapleherst, husbandman 0
3698811 1925846 1925846 defendant Hoge William carpenter 594965 594965 Hoge, William, of Stapleherst, carpenter 4
3707797 1928737 1928737 defendant Colyer William clothier 594965 594965 Colyer, William, of Stapleherst, clothier 2
3723484 1933611 1933611 defendant Turke Thomas laborer 594965 594965 Turke, Thomas, of Stapleherst, laborer 1
3727739 1934945 1934945 defendant Alen John baker 594965 594965 Alen, John, of Stapleherst, baker 3
3739294 1938506 1938506 defendant Wanden Richard yeoman 594965 594965 Wanden, Richard, of Stapleherst, yeoman 0
3739295 1938506 1938506 defendant Scranton William clothmaker 594965 594965 Scranton, William, of Stapleherst, clothmaker 1
3739296 1938506 1938506 defendant Scranton John clothman 594965 594965 Scranton, John, of Stapleherst, clothman 2
3739297 1938506 1938506 defendant Fenner Thomas fuller 594965 594965 Fenner, Thomas, of Stapleherst, fuller 3
3751868 1942502 1942502 defendant Wanden Richard yeoman 594965 594965 Wanden, Richard, of Stapleherst, yeoman 0
3751869 1942502 1942502 defendant Scranton William clothmaker 594965 594965 Scranton, William, of Stapleherst, clothmaker 1
3751870 1942502 1942502 defendant Scranton John clothman 594965 594965 Scranton, John, of Stapleherst, clothman 2
3751871 1942502 1942502 defendant Fenner Thomas fuller 594965 594965 Fenner, Thomas, of Stapleherst, fuller 3
3808091 1960422 1960422 defendant Iden Thomas sawyer 594965 594965 Iden, Thomas, of Stapleherst, sawyer 2
3897881 1989496 1989496 defendant Whyte Nicholas carpenter 594965 594965 Whyte, Nicholas, of Stapleherst, carpenter 1
3897882 1989496 1989496 defendant Reynold Roger carpenter 594965 594965 Reynold, Roger, of Stapleherst, carpenter 2
3917339 1996157 1996157 defendant Maylyn Henry weaver 594965 594965 Maylyn, Henry, of Stapleherst, weaver 3
3921885 1997666 1997666 plaintiff Pykynden John   594965 594965 Pykynden, John, of Stapleherst, "paunler" 0
3921887 1997666 1997666 defendant Asten Parcival yeoman 594965 594965 Asten, Parcival, of Stapleherst, yeoman 1
3924205 1998404 1998404 defendant Van Thomas husbandman 594965 594965 Van, Thomas, of Stapleherst, husbandman 0
3943827 2004951 2004951 plaintiff Austen James yeoman 594965 594965 Austen, James, of Stapleherst, yeoman 0
3944550 2005195 2005195 plaintiff Batherst Thomas, senior clothier 594965 594965 Batherst, Thomas, senior, of Stapleherst, clothier 0
3944551 2005195 2005195 defendant Stranton or Strauton Thomas clothier 594965 594965 Stranton or Strauton, Thomas, of Stapleherst, clothier 0
3958165 2009928 2009928 plaintiff Rede John   594965 594965 Rede, John, of Stapleherst, scythe smith 0
3959161 2010290 2010290 defendant Mayne Walter esq 594965 594965 Mayne, Walter, of Stapleherst, esq 0
3960726 2010852 2010852 defendant Farley Thomas chapman 594965 594965 Farley, Thomas, of Stapleherst, chapman 1
3964671 2012249 2012249 defendant Buddes Nicholas husbandman 594965 594965 Buddes, Nicholas, of Stapleherst, husbandman 0
3970393 2014244 2014244 defendant Lynckefeld Richard weaver 594965 594965 Lynckefeld, Richard, of Stapleherst, weaver 2
3981868 2018273 2018273 defendant Austen Thomas yeoman 594965 594965 Austen, Thomas, of Stapleherst, yeoman 1
3994705 2022857 2022857 defendant Day Richard butcher 594965 594965 Day, Richard, of Stapleherst, butcher 0
3995843 2023261 2023261 defendant Day Richard butcher 594965 594965 Day, Richard, of Stapleherst, butcher 0
4031063 2035782 2035782 plaintiff Farmar John   594965 594965 Farmar, John, of Stapleherst 0
4031064 2035782 2035782 defendant Undryll John clothier 594965 594965 Undryll, John, of Stapleherst, clothier 0
4031065 2035782 2035782 defendant Undryll Edward clothier 594965 594965 Undryll, Edward, of Stapleherst, clothier 1
4031066 2035783 2035783 plaintiff Farmar John   594965 594965 Farmar, John, of Stapleherst 0
4031067 2035783 2035783 defendant Undryll John clothier 594965 594965 Undryll, John, of Stapleherst, clothier 0
4031068 2035783 2035783 defendant Undryll Edward clothier 594965 594965 Undryll, Edward, of Stapleherst, clothier 1
4038249 2038315 2038315 defendant Maynye John yeoman 594965 594965 Maynye, John, of Stapleherst, yeoman 1
4047933 2041707 2041707 plaintiff Suder Thomas clothier 594965 594965 Suder, Thomas, of Stapleherst, clothier 0
4063976 2047396 2047396 defendant Todyam alias Todgill Richard tailor 594965 594965 Todyam alias Todgill, Richard, of Stapleherst, tailor 0
4077554 2052263 2052263 defendant Quayffe John husbandman 594965 594965 Quayffe, John, of Stapleherst, husbandman 0
4093013 2057814 2057814 defendant Fermer Thomas clothier 594965 594965 Fermer, Thomas, of Stapleherst, clothier 0
4120070 2067467 2067467 defendant Draner or Draver Michael butcher 594965 594965 Draner or Draver, Michael, of Stapleherst, butcher 0
4120071 2067467 2067467 defendant Giles James tailor 594965 594965 Giles, James, of Stapleherst, tailor 1
4120072 2067467 2067467 defendant Newbye Mathew sawyer 594965 594965 Newbye, Mathew, of Stapleherst, sawyer 2
4120073 2067467 2067467 defendant Dawson Thomas laborer 594965 594965 Dawson, Thomas, of Stapleherst, laborer 3
4121954 2068151 2068151 defendant Buckhurst Thomas clothier 594965 594965 Buckhurst, Thomas, of Stapleherst, clothier 0
4121962 2068155 2068155 defendant Harnden Robert yeoman 594965 594965 Harnden, Robert, of Stapleherst, yeoman 0
4130468 2071210 2071210 defendant Spyllett William yeoman 594965 594965 Spyllett, William, of Stapleherst, yeoman 0
4145320 2076524 2076524 defendant Gyles James tailor 594965 594965 Gyles, James, of Stapleherst, tailor 1
4156031 2080182 2080182 defendant Faunt John clothier 594965 594965 Faunt, John, of Stapleherst, clothier 2
4156310 2080280 2080280 defendant Slanye William yeoman 594965 594965 Slanye, William, of Stapleherst, yeoman 0
4156311 2080280 2080280 defendant Gyles James yeoman 594965 594965 Gyles, James, of Stapleherst, yeoman 1
4167774 2084218 2084218 defendant Roper William clothier 594965 594965 Roper, William, of Stapleherst, clothier 0
4182750 2089444 2089444 defendant Benson William innholder 594965 594965 Benson, William, of Stapleherst, innholder 0
4205242 2097384 2097384 defendant Meyney John esq 594965 594965 Meyney, John, of Stapleherst, esq 1
4206353 2097766 2097766 defendant Benston William innholder 594965 594965 Benston, William, of Stapleherst, innholder 0
4238278 2108998 2108998 defendant Nasshe or Nasse Geoffrey butcher 594965 594965 Nasshe or Nasse, Geoffrey, of Stapleherst, butcher 0
4286390 2125172 2125172 defendant Baker William shoemaker 594965 594965 Baker, William, of Stapleherst, shoemaker 3
4309830 2133594 2133594 defendant Austen Giles clothier 594965 594965 Austen, Giles, of Stapleherst, clothier 0
4315616 2135572 2135572 defendant Smalwood William broad weaver 594965 594965 Smalwood William, of Stapleherst, broad weaver 0
4360162 2150798 2150798 defendant Gorham Jonah yeoman 594965 594965 Gorham, Jonah, of Stapleherst, yeoman 0
4373374 2155544 2155544 defendant Grensted John husbandman 594965 594965 Grensted, John, of Stapleherst, husbandman 1
4374681 2156007 2156007 defendant Balden James tailor 594965 594965 Balden, James, of Stapleherst, tailor 1
4383551 2159208 2159208 defendant Crompe James carpenter 594965 594965 Crompe, James, of Stapleherst, carpenter 0
4383910 2159322 2159322 defendant Austen Richard shoemaker 594965 594965 Austen, Richard, of Stapleherst, shoemaker 0
4383913 2159323 2159323 defendant Baker William shoemaker 594965 594965 Baker, William, of Stapleherst, shoemaker 0
4398412 2164050 2164050 defendant Ware Edward clothier 594965 594965 Ware, Edward, of Stapleherst, clothier 0
4398413 2164050 2164050 defendant Ware Peter clothier 594965 594965 Ware, Peter, of Stapleherst, clothier 1
5014772 2361192 2361192 defendant Norton John yeoman 594965 594965 Norton, John, of Stapleherst, yeoman 0
5134282 2396522 2396522 defendant Dey John fuller 594965 594965 Dey, John, of Stapleherst, fuller 0
5318391 2450595 2450595 defendant Beest Richard weaver 594965 594965 Beest, Richard, of Stapleherst, weaver 1
5354389 2461439 2461439 defendant Hopper Richard yeoman 594965 594965 Hopper, Richard, of Stapleherst, yeoman 3
5354394 2461440 2461440 defendant Hopper Richard yeoman 594965 594965 Hopper, Richard, of Stapleherst, yeoman 3
5414865 2479376 2479376 defendant Ilchym William   594965 594965 Ilchym, William, of Stapleherst, cloth maker 0
5430341 2484011 2484011 plaintiff Herenden John gent 594965 594965 Herenden, John, of Stapleherst, gent 0
5430793 2484148 2484148 defendant Ilchynden William clothmaker 594965 594965 Ilchynden, William, of Stapleherst, clothmaker 0
5585539 2530546 2530546 defendant Usbarn Thomas tanner 594965 594965 Usbarn, Thomas, of Stapleherst, tanner 0
5597700 2534175 2534175 defendant Ferer Stephen yeoman 594965 594965 Ferer, Stephen, of Stapleherst, yeoman 0

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);