names

127 rows where place_id = 587220

✎ 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
3590796 1864760 1864760 defendant Barbour John butcher 587220 587220 Barbour, John, of Fresyngfeld, butcher 3
3599010 1867324 1867324 defendant Potell John yeoman 587220 587220 Potell, John, of Fresyngfeld, yeoman 1
3599016 1867325 1867325 defendant Potell John yeoman 587220 587220 Potell, John, of Fresyngfeld, yeoman 1
3606807 1869801 1869801 defendant Awles John husbandman 587220 587220 Awles, John, of Fresyngfeld, husbandman 6
3607272 1869937 1869937 defendant Grenlyng Thomas husbandman 587220 587220 Grenlyng, Thomas, of Fresyngfeld, husbandman 4
3614875 1872307 1872307 defendant Dade John gent 587220 587220 (Dade, John, of Fresyngfeld, gent 1
3642231 1908017 1908017 defendant Bothewright Richard husbandman 587220 587220 Bothewright, Richard, of Fresyngfeld, husbandman 4
3650140 1910414 1910414 plaintiff Botwright Richard   587220 587220 Botwright, Richard, of Fresyngfeld 1
3656034 1912140 1912140 defendant Batewryght Richard husbandman 587220 587220 Batewryght, Richard, of Fresyngfeld, husbandman 0
3657164 1912505 1912505 defendant Potell Barnard singleman 587220 587220 Potell, Barnard, of Fresyngfeld, singleman 0
3682780 1920716 1920716 defendant Shelton William   587220 587220 Shelton, William, of Fresyngfeld, wheelwright 0
3682781 1920716 1920716 defendant Gilbert William laborer 587220 587220 Gilbert, William, of Fresyngfeld, laborer 1
3703512 1927371 1927371 defendant Wulnall Richard carpenter 587220 587220 Wulnall, Richard, of Fresyngfeld, carpenter 0
3708518 1928960 1928960 defendant Whyte William clerk 587220 587220 Whyte, William, of Fresyngfeld, clerk 0
3715744 1931213 1931213 defendant Botwright Richard husbandman 587220 587220 Botwright, Richard, of Fresyngfeld, husbandman 0
3717301 1931695 1931695 plaintiff Debden Robert (legal representative) 587220 587220 Debden, Robert, of Fresyngfeld, executors of 0
3717305 1931695 1931695 defendant Grenlyng William husbandman 587220 587220 Grenlyng, William, of Fresyngfeld, husbandman 1
3733029 1936551 1936551 defendant Botwryght Richard husbandman 587220 587220 Botwryght, Richard, of Fresyngfeld, husbandman 0
3733030 1936552 1936552 plaintiff Debden Robert (legal representative) 587220 587220 Debden, Robert, of Fresyngfeld, executors of 0
3745782 1940584 1940584 defendant Bokenham Joan widow 587220 587220 Bokenham, Joan, of Fresyngfeld, widow 0
3745783 1940584 1940584 defendant Bokenham Nicholas husbandman 587220 587220 Bokenham, Nicholas, of Fresyngfeld, husbandman 1
3779708 1951385 1951385 defendant Whyte William clerk 587220 587220 Whyte, William, of Fresyngfeld, clerk 1
3782689 1952327 1952327 defendant Goche Robert husbandman 587220 587220 Goche, Robert, of Fresyngfeld, husbandman 0
3784606 1952971 1952971 defendant Laverons Robert husbandman 587220 587220 Laverons, Robert, of Fresyngfeld, husbandman 0
3789173 1954426 1954426 defendant Sharman William   587220 587220 Sharman, William, of Fresyngfeld, wheelwright 1
3790829 1954959 1954959 plaintiff White William clerk 587220 587220 White, William, of Fresyngfeld, clerk 0
3790920 1954992 1954992 defendant Botwyn Nicholas husbandman 587220 587220 Botwyn, Nicholas, of Fresyngfeld, husbandman 0
3795985 1956607 1956607 defendant Wolnawe Richard (legal representative) 587220 587220 Wolnawe, Richard, of Fresyngfeld, carpenter, executor of 0
3795986 1956607 1956607 defendant Wolnawe John husbandman 587220 587220 Wolnawe, John, of Fresyngfeld, husbandman 1
3805707 1959730 1959730 defendant Baker John husbandman 587220 587220 Baker, John, of Fresyngfeld, husbandman 1
3812809 1961903 1961903 defendant Botwright Richard yeoman 587220 587220 Botwright, Richard, of Fresyngfeld, yeoman 0
3818640 1963733 1963733 defendant Lauerons Robert husbandman 587220 587220 Lauerons, Robert, of Fresyngfeld, husbandman 1
3854596 1975081 1975081 plaintiff Toppesfeld Simon gent 587220 587220 Toppesfeld, Simon, of Fresyngfeld, gent 0
3854598 1975082 1975082 plaintiff Toppesfeld Simon gent 587220 587220 Toppesfeld, Simon, of Fresyngfeld, gent 0
3857772 1976068 1976068 defendant Sherman William   587220 587220 Sherman, William, of Fresyngfeld, wheelwright 0
3897693 1989436 1989436 defendant Botwright Richard husbandman 587220 587220 Botwright, Richard, of Fresyngfeld, husbandman 1
3904812 1991873 1991873 plaintiff Huggeman Robert husbandman 587220 587220 Huggeman, Robert, of Fresyngfeld, husbandman 0
3904813 1991873 1991873 defendant Bokenham George yeoman 587220 587220 Bokenham, George, of Fresyngfeld, yeoman 0
3913054 1994696 1994696 defendant Corwyn William husbandman 587220 587220 Corwyn, William, of Fresyngfeld, husbandman 0
3917446 1996194 1996194 plaintiff Grynlyng Robert (legal representative) 587220 587220 Grynlyng, Robert, of Fresyngfeld, executors of 0
3923140 1998045 1998045 defendant Wulnall Agnes widow 587220 587220 Wulnall, Agnes, of Fresyngfeld, widow 1
3924382 1998465 1998465 defendant Cotwyn Robert yeoman 587220 587220 Cotwyn, Robert, of Fresyngfeld, yeoman 0
3940722 2003903 2003903 plaintiff Storer William yeoman 587220 587220 Storer, William, of Fresyngfeld, yeoman 0
3945381 2005470 2005470 plaintiff Bottrek Robert yeoman 587220 587220 Bottrek, Robert, of Fresyngfeld, yeoman 0
3961169 2011000 2011000 defendant Wolnawe James yeoman 587220 587220 Wolnawe, James, of Fresyngfeld, yeoman 0
3963786 2011936 2011936 defendant Harvye Thomas butcher 587220 587220 Harvye, Thomas, of Fresyngfeld, butcher 0
3980653 2017846 2017846 defendant Bowler James yeoman 587220 587220 Bowler, James, of Fresyngfeld, yeoman 1
4019142 2031586 2031586 plaintiff Warne John tanner 587220 587220 Warne, John, of Fresyngfeld, or of Thornham Magna, tanner 0
4026104 2033982 2033982 defendant Kynge Robert yeoman 587220 587220 Kynge, Robert, of Fresyngfeld, yeoman 1
4028666 2034901 2034901 defendant Barbar Robert tailor 587220 587220 Barbar, Robert, of Fresyngfeld, tailor 0
4033755 2036724 2036724 defendant Hudd Thomas potter 587220 587220 Hudd, Thomas, of Fresyngfeld, potter 2
4040653 2039153 2039153 plaintiff Wolnoughe James yeoman 587220 587220 Wolnoughe, James, of Fresyngfeld, yeoman 1
4041846 2039565 2039565 plaintiff Ockeley Thomas clerk 587220 587220 Ockeley, Thomas, of Fresyngfeld, clerk 0
4428101 2173620 2173620 defendant Smyth William le   587220 587220 Smyth, William le, of Fresyngfeld 6
4506076 2202413 2202413 defendant Cove or Cone Thomas   587220 587220 Cove or Cone, Thomas, of Fresyngfeld 0
4506078 2202414 2202414 defendant Cone or Cove Thomas   587220 587220 Cone or Cove, Thomas, of Fresyngfeld 0
4547377 2215111 2215111 defendant Nene Richard   587220 587220 Nene, Richard, of Fresyngfeld 1
4547383 2215112 2215112 defendant Nene Richard   587220 587220 Nene, Richard, of Fresyngfeld 1
4547388 2215113 2215113 defendant Nene Richard   587220 587220 Nene, Richard, of Fresyngfeld 0
4555490 2217648 2217648 defendant Aylmer Edmund   587220 587220 Aylmer, Edmund, of Fresyngfeld 4
4564686 2220519 2220519 plaintiff Seman William   587220 587220 Seman, William, of Fresyngfeld 0
4575730 2223919 2223919 defendant Gyle William   587220 587220 Gyle, William, of Fresyngfeld 1
4582785 2226052 2226052 defendant Kittesson William   587220 587220 Kittesson, William, of Fresyngfeld 1
4595444 2229830 2229830 defendant Roop John   587220 587220 Roop, John, of Fresyngfeld 0
4595446 2229831 2229831 defendant Seman William   587220 587220 Seman, William, of Fresyngfeld 0
4614272 2235476 2235476 defendant Gyle William   587220 587220 (Gyle, William, of Fresyngfeld 1
4630964 2240576 2240576 defendant Barbour John   587220 587220 Barbour, John, of Fresyngfeld 1
4636389 2242217 2242217 defendant Seman William   587220 587220 Seman, William, of Fresyngfeld 2
4655152 2247491 2247491 defendant Nene or Neve John husbandman 587220 587220 Nene or Neve, John, of Fresyngfeld, husbandman 0
4655153 2247491 2247491 defendant Date John smith 587220 587220 Date, John, of Fresyngfeld, smith 1
4675147 2257840 2257840 defendant Roo Alice tapster or tapesty maker 587220 587220 Roo, Alice, of Fresyngfeld, formerly wife of William, tapster or tapesty maker 0
4697390 2264669 2264669 defendant Seman William husbandman 587220 587220 Seman, William, of Fresyngfeld, husbandman 0
4718262 2271047 2271047 defendant Shelton John   587220 587220 Shelton, John, of Fresyngfeld, wheel wright 0
4722302 2272299 2272299 defendant Seman William husbandman 587220 587220 Seman, William, of Fresyngfeld, husbandman 0
4722305 2272300 2272300 defendant Seman William husbandman 587220 587220 Seman, William, of Fresyngfeld, husbandman 0
4724167 2272851 2272851 defendant Seman William yeoman 587220 587220 Seman, William, of Fresyngfeld, yeoman 2
4726231 2273489 2273489 defendant Gyle William husbandman 587220 587220 Gyle, William, of Fresyngfeld, husbandman 0
4763781 2284661 2284661 plaintiff Gyle William   587220 587220 Gyle, William, of Fresyngfeld 0
4766113 2285391 2285391 defendant Aldebergh Gilbert chaplain 587220 587220 Aldebergh, Gilbert, of Fresyngfeld, chaplain 0
4786599 2291858 2291858 defendant Swyft Gilbert chaplain 587220 587220 Swyft, Gilbert, of Fresyngfeld, chaplain 0
4787512 2292166 2292166 plaintiff Gyle William   587220 587220 Gyle, William, of Fresyngfeld 0
4798366 2295676 2295676 defendant Aldebergh Gilbert chaplain 587220 587220 Aldebergh, Gilbert, of Fresyngfeld, chaplain 3
4805455 2297917 2297917 defendant Gyle William (legal representative) 587220 587220 Gyle, William, of Fresyngfeld, administratrix of 0
4805456 2297917 2297917 defendant Gyle Alice widow 587220 587220 Gyle, Alice, of Fresyngfeld, widow 1
4805923 2298061 2298061 defendant Dalangho William yeoman 587220 587220 Dalangho, William, of Fresyngfeld, yeoman 0
4821064 2302667 2302667 defendant Seman William yeoman 587220 587220 Seman, William, of Fresyngfeld, yeoman 0
4822056 2302974 2302974 defendant Sancroft Thomas laborer 587220 587220 Sancroft, Thomas, of Fresyngfeld, laborer 2
4835063 2306967 2306967 defendant Seford John husbandman 587220 587220 Seford, John, of Fresyngfeld, husbandman 1
4849872 2311432 2311432 defendant Seman William yeoman 587220 587220 Seman, William, of Fresyngfeld, yeoman 0
4893591 2324696 2324696 defendant Barbour John, senior husbandman 587220 587220 Barbour, John, senior, of Fresyngfeld, husbandman 4
4945054 2340435 2340435 defendant Shepe Richard yeoman 587220 587220 Shepe, Richard, of Fresyngfeld, yeoman 1
4945622 2340611 2340611 defendant Shelton John husbandman 587220 587220 Shelton, John, of Fresyngfeld, husbandman 0
4945623 2340611 2340611 defendant Barret Geoffrey husbandman 587220 587220 Barret, Geoffrey, of Fresyngfeld, husbandman 1
4965120 2346492 2346492 defendant Russhley John, senior husbandman 587220 587220 Russhley, John, senior, of Fresyngfeld, husbandman 1
4979249 2350752 2350752 plaintiff Seman William (legal representative) 587220 587220 Seman, William, of Fresyngfeld, executors of 0
5069833 2377472 2377472 defendant Brougger Richard   587220 587220 Brougger, Richard, of Fresyngfeld, wheelwright 0
5213320 2419628 2419628 defendant Stannard Henry husbandman 587220 587220 Stannard, Henry, of Fresyngfeld, husbandman 0
5262511 2434018 2434018 defendant Walpoll Robert chaplain 587220 587220 Walpoll,Robert, of Fresyngfeld, chaplain 0
5334842 2455490 2455490 plaintiff Fox Robert   587220 587220 Fox, Robert, of Fresyngfeld 0
5345999 2458883 2458883 defendant Ryngbald or Ryngvald Richard yeoman 587220 587220 Ryngbald or Ryngvald, Richard, of Fresyngfeld, yeoman 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);