names

216 rows where place_id = 596822

✎ 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
3626288 1903078 1903078 defendant Gryg Reginald husbandman 596822 596822 Gryg, Reginald, of Walsoken, husbandman 1
3627289 1903382 1903382 defendant Scutte John husbandman 596822 596822 Scutte, John, of Walsoken, husbandman 1
3627290 1903382 1903382 defendant Mey William husbandman 596822 596822 Mey, William, of Walsoken, husbandman 2
3631985 1904818 1904818 defendant Norman Geoffrey chaplain 596822 596822 Norman, Geoffrey, of Walsoken, chaplain 0
3631988 1904819 1904819 defendant Norman Geoffrey chaplain 596822 596822 Norman, Geoffrey, of Walsoken, chaplain 1
3635380 1905861 1905861 defendant Thompson John husbandman 596822 596822 Thompson, John, of Walsoken, husbandman 0
3639349 1907116 1907116 defendant Wyseman John husbandman 596822 596822 Wyseman, John, of Walsoken, husbandman 0
3639350 1907116 1907116 defendant Mower Richard husbandman 596822 596822 Mower, Richard, of Walsoken, husbandman 1
3639351 1907116 1907116 defendant Shipley Robert husbandman 596822 596822 Shipley, Robert, of Walsoken, husbandman 2
3655174 1911877 1911877 defendant Prentes Thomas yeoman 596822 596822 Prentes, Thomas, of Walsoken, yeoman 0
3672517 1917407 1917407 defendant Hill alias Gryg Reginald husbandman 596822 596822 Hill alias Gryg, Reginald, of Walsoken, husbandman 0
3672520 1917407 1917407 defendant May William husbandman 596822 596822 May, William, of Walsoken, husbandman 3
3689988 1923028 1923028 defendant Cowpar John husbandman 596822 596822 Cowpar, John, of Walsoken, husbandman 0
3689990 1923028 1923028 defendant Benett John husbandman 596822 596822 Benett, John, of Walsoken, husbandman 2
3689991 1923028 1923028 defendant Cowper John, junior husbandman 596822 596822 Cowper, John, junior, of Walsoken, husbandman 3
3693367 1924139 1924139 defendant Prentys Thomas yeoman 596822 596822 Prentys, Thomas, of Walsoken, yeoman 1
3694435 1924464 1924464 defendant Seman William husbandman 596822 596822 Seman, William, of Walsoken, husbandman 1
3707225 1928552 1928552 defendant Halle Henry husbandman 596822 596822 Halle, Henry, of Walsoken, husbandman 1
3707226 1928552 1928552 defendant Cowper John, senior husbandman 596822 596822 Cowper, John, senior, of Walsoken, husbandman 2
3707227 1928552 1928552 defendant Cowper John, junior husbandman 596822 596822 Cowper, John, junior, of Walsoken, husbandman 3
3752247 1942626 1942626 plaintiff Prentyse Thomas   596822 596822 Prentyse, Thomas, of Walsoken 0
3761140 1945489 1945489 defendant Legatt Henry yeoman 596822 596822 Legatt, Henry, of Walsoken, yeoman 1
3761141 1945489 1945489 defendant Blossom Henry husbandman 596822 596822 Blossom, Henry, of Walsoken, husbandman 2
3761145 1945490 1945490 defendant Legatt Henry yeoman 596822 596822 Legatt, Henry, of Walsoken, yeoman 1
3761146 1945490 1945490 defendant Blossom Henry husbandman 596822 596822 Blossom, Henry, of Walsoken, husbandman 2
3779348 1951263 1951263 defendant Legatt Henry yeoman 596822 596822 Legatt, Henry, of Walsoken, yeoman 1
3779349 1951263 1951263 defendant Blossom Henry husbandman 596822 596822 Blossom, Henry, of Walsoken, husbandman 2
3797908 1957244 1957244 defendant Steward Henry husbandman 596822 596822 Steward, Henry, of Walsoken, husbandman 0
3843869 1971622 1971622 defendant Emson Adam husbandman 596822 596822 Emson, Adam, of Walsoken, husbandman 0
3871744 1980786 1980786 defendant Legatt Thomas yeoman 596822 596822 Legatt, Thomas, of Walsoken, yeoman 1
3893054 1987925 1987925 defendant Creswell Martin (legal representative) 596822 596822 Creswell, Martin, of Walsoken, husbandman, administratrix of 0
3903840 1991519 1991519 defendant Myller Lawrence smith 596822 596822 Myller, Lawrence, of Walsoken, smith 2
3905914 1992262 1992262 defendant Marten William yeoman 596822 596822 Marten, William, of Walsoken, yeoman 0
3912278 1994436 1994436 defendant Thorp Nicholas husbandman 596822 596822 Thorp, Nicholas, of Walsoken, husbandman 1
3912279 1994436 1994436 defendant Knowght William laborer 596822 596822 Knowght, William, of Walsoken, laborer 2
3923990 1998334 1998334 defendant Thorn Nicholas husbandman 596822 596822 Thorn, Nicholas, of Walsoken, husbandman 1
3927116 1999406 1999406 defendant Sne or Sue John husbandman 596822 596822 Sne or Sue, John, of Walsoken, husbandman 1
3930696 2000617 2000617 defendant Homyter Thomas husbandman 596822 596822 Homyter, Thomas, of Walsoken, husbandman 0
3930697 2000617 2000617 defendant Bigge Thomas husbandman 596822 596822 Bigge, Thomas, of Walsoken, husbandman 1
3930698 2000617 2000617 defendant Whelpdale Robert yeoman 596822 596822 Whelpdale, Robert, of Walsoken, yeoman 2
3933565 2001513 2001513 defendant Big William husbandman 596822 596822 Big, William, of Walsoken, husbandman 0
3933566 2001513 2001513 defendant Big John husbandman 596822 596822 Big, John, of Walsoken, husbandman 1
3934642 2001881 2001881 defendant Watsone Thomas husbandman 596822 596822 Watsone, Thomas, of Walsoken, husbandman 0
3934643 2001881 2001881 defendant Mey Robert husbandman 596822 596822 Mey, Robert, of Walsoken, husbandman 1
3934644 2001881 2001881 defendant Blossham alias Blossom Edward (legal representative) 596822 596822 Blossham alias Blossom, Edward, of Walsoken, husbandman, executors of 2
3934645 2001881 2001881 defendant Blossham Robert husbandman 596822 596822 (Blossham, Robert, of Walsoken, husbandman 3
3934646 2001881 2001881 defendant Blossham John husbandman 596822 596822 Blossham, John, of Walsoken, husbandman 4
3939404 2003483 2003483 defendant Thorpe Nicholas husbandman 596822 596822 Thorpe, Nicholas, of Walsoken, husbandman 0
3961012 2010947 2010947 defendant Sale John yeoman 596822 596822 Sale, John, of Walsoken, yeoman 0
3963470 2011829 2011829 defendant Cawston William yeoman 596822 596822 Cawston, William, of Walsoken, yeoman 0
3972191 2014835 2014835 defendant Thorpe Robert husbandman 596822 596822 Thorpe, Robert, of Walsoken, husbandman 0
3972193 2014835 2014835 defendant Thormer John blacksmith 596822 596822 Thormer, John, of Walsoken, blacksmith 2
3978369 2017019 2017019 defendant Hyll alias Gregg John husbandman 596822 596822 Hyll alias Gregg, John, of Walsoken, husbandman 0
3978370 2017019 2017019 defendant Churche John husbandman 596822 596822 Churche, John, of Walsoken, husbandman 1
3978371 2017019 2017019 defendant Hunston John husbandman 596822 596822 Hunston, John, of Walsoken, husbandman 2
3986519 2019920 2019920 defendant Wytton Robert husbandman 596822 596822 Wytton, Robert, of Walsoken, husbandman 0
3995500 2023137 2023137 defendant Sparrowe Richard yeoman 596822 596822 Sparrowe, Richard, of Walsoken, yeoman 0
4009834 2028293 2028293 defendant Wetheram John laborer 596822 596822 Wetheram, John, of Walsoken, laborer 1
4030381 2035519 2035519 defendant Cawson William yeoman 596822 596822 Cawson, William, of Walsoken, yeoman 0
4030383 2035520 2035520 defendant Cawson William yeoman 596822 596822 Cawson, William, of Walsoken, yeoman 0
4042236 2039703 2039703 defendant Splitte Joan widow 596822 596822 Splitte, Joan, of Walsoken, widow 0
4057972 2045230 2045230 defendant Broke Roger gent 596822 596822 Broke, Roger, of Walsoken, gent 0
4065655 2048005 2048005 defendant Maye Stephen husbandman 596822 596822 Maye, Stephen, of Walsoken, husbandman 0
4080487 2053334 2053334 defendant Cawson William yeoman 596822 596822 Cawson, William, of Walsoken, yeoman 0
4080910 2053487 2053487 plaintiff Well John yeoman 596822 596822 Well, John, of Walsoken, yeoman 0
4091116 2057109 2057109 defendant Balam Charles gent 596822 596822 Balam, Charles, of Walsoken, gent, son of John Balam, of Barton, Suff, gent 0
4092937 2057783 2057783 defendant Hervye Thomas yeoman 596822 596822 Hervye, Thomas, of Walsoken, yeoman 1
4099359 2060096 2060096 defendant Pulvertofte Robert gent 596822 596822 Pulvertofte, Robert, of Walsoken, or of Whaplode, Lincs, gent 0
4099360 2060096 2060096 defendant Pulvertofte William gent 596822 596822 Pulvertofte, William, of Walsoken, or of Wisbytche, Isle of Ely, Cams, gent 1
4103879 2061663 2061663 defendant Woode Robert armorer 596822 596822 Woode, Robert, of Walsoken, armorer 0
4108532 2063307 2063307 defendant Browne Robert husbandman 596822 596822 Browne, Robert, of Walsoken, or of Sleforthe, Lincs, husbandman 0
4108535 2063308 2063308 defendant Browne Robert husbandman 596822 596822 Browne, Robert, of Walsoken, or of Slefurthe, Lincs, husbandman 0
4108538 2063309 2063309 defendant Tymberland Robert butcher 596822 596822 Tymberland, Robert, of Walsoken, husbandman, or of Sleforthe, Lincs, butcher 0
4129723 2070940 2070940 defendant Bedingfeld William gent 596822 596822 Bedingfeld, William, of Walsoken, gent 0
4129725 2070941 2070941 defendant Bedyngfeld William gent 596822 596822 Bedyngfeld, William, of Walsoken, gent 0
4132668 2072005 2072005 defendant Harvye Thomas yeoman 596822 596822 Harvye, Thomas, of Walsoken, yeoman 0
4144925 2076385 2076385 defendant Grene William yeoman 596822 596822 Grene, William, of Walsoken, yeoman 0
4144926 2076385 2076385 defendant Davyes Thomas husbandman 596822 596822 Davyes, Thomas, of Walsoken, husbandman 1
4144927 2076385 2076385 defendant Bones Thomas laborer 596822 596822 Bones, Thomas, of Walsoken, laborer 2
4154513 2079671 2079671 defendant Hunston Richard gent 596822 596822 Hunston, Richard, of Walsoken, or of Marslande, Norf, gent 0
4172584 2085869 2085869 defendant Sale John yeoman 596822 596822 Sale John, of Walsoken, yeoman 0
4173894 2086325 2086325 defendant Robsyd Thomas husbandman 596822 596822 Robsyd, Thomas, of Walsoken, husbandman 1
4176578 2087284 2087284 defendant Loveday John husbandman 596822 596822 Loveday, John, of Walsoken, husbandman 3
4177925 2087752 2087752 defendant Rolson John husbandman 596822 596822 Rolson, John, of Walsoken, husbandman 0
4177927 2087753 2087753 defendant Tompson Thomas husbandman 596822 596822 Tompson, Thomas, of Walsoken, husbandman 0
4182271 2089275 2089275 defendant Harvye Thomas husbandman 596822 596822 Harvye, Thomas, of Walsoken, husbandman 2
4187230 2091026 2091026 defendant Sayle John husbandman 596822 596822 Sayle, John, of Walsoken, husbandman 0
4187231 2091026 2091026 defendant Maye Richard husbandman 596822 596822 Maye, Richard, of Walsoken, husbandman 1
4190068 2092027 2092027 defendant Sale or Saylle John, junior husbandman 596822 596822 Sale or Saylle, John, junior, of Walsoken, husbandman 0
4192233 2092848 2092848 defendant Pellam or Pelham William yeoman 596822 596822 Pellam or Pelham, William, of Walsoken, or of Wysbeche, Isle of Ely, Cams, yeoman 0
4195779 2094076 2094076 defendant Sale John yeoman 596822 596822 Sale, John, of Walsoken, yeoman 0
4211534 2099587 2099587 defendant Harvye Thomas husbandman 596822 596822 Harvye, Thomas, of Walsoken, husbandman 1
4211535 2099587 2099587 defendant Honyter John husbandman 596822 596822 Honyter, John, of Walsoken, husbandman 2
4213543 2100254 2100254 defendant Sale John, junior husbandman 596822 596822 Sale, John, junior, of Walsoken, husbandman 0
4219170 2102201 2102201 defendant Smyth Thomas gent 596822 596822 Smyth, Thomas, of Walsoken, gent 0
4219171 2102201 2102201 defendant Robynson Andrew carpenter 596822 596822 Robynson, Andrew, of Walsoken, carpenter 1
4219700 2102395 2102395 defendant Thorneton James husbandman 596822 596822 Thorneton, James, of Walsoken, or of Emnyth, husbandman 0
4219701 2102395 2102395 defendant Roghbye John yeoman 596822 596822 Roghbye, John, of Walsoken, yeoman 1
4219702 2102395 2102395 defendant Carter Robert laborer 596822 596822 Carter, Robert, of Walsoken, laborer 2
4219703 2102395 2102395 defendant Jannson Thomas laborer 596822 596822 Jannson, Thomas, of Walsoken, laborer 3

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