names

125 rows where place_id = 588739

✎ 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
3595418 1866200 1866200 defendant Bower alias Stuppersfeld Nicholas laborer 588739 588739 Bower alias Stuppersfeld, Nicholas, of Tyseherst, laborer 3
3595423 1866201 1866201 defendant Bower Nicholas laborer 588739 588739 Bower, Nicholas, of Tyseherst, laborer 3
3595424 1866201 1866201 defendant Stuppersfeld Nicholas laborer 588739 588739 Stuppersfeld, Nicholas, of Tyseherst, laborer 4
3598465 1867149 1867149 defendant Legh John carpenter 588739 588739 Legh, John, of Tyseherst, carpenter 0
3598756 1867239 1867239 defendant Shosewell John gent 588739 588739 Shosewell, John, of Tyseherst, gent 0
3601814 1868224 1868224 defendant Noke John baker 588739 588739 Noke, John, of Tyseherst, baker 5
3607335 1869955 1869955 defendant Nasshe John husbandman 588739 588739 Nasshe, John, of Tyseherst, husbandman 3
3607339 1869956 1869956 defendant Nasshe John husbandman 588739 588739 Nasshe, John, of Tyseherst, husbandman 2
3613986 1872033 1872033 defendant Schoswell John, junior gent 588739 588739 Schoswell, John, junior, of Tyseherst, gent 0
3613987 1872033 1872033 defendant Asshfeld Thomas clerk 588739 588739 Asshfeld, Thomas, of Tyseherst, clerk 1
3618827 1873498 1873498 defendant Herte John laborer 588739 588739 Herte, John, of Tyseherst, laborer 0
3625302 1875450 1875450 defendant Roper William, senior husbandman 588739 588739 Roper, William, senior, of Tyseherst, husbandman 2
3625303 1875450 1875450 defendant Roper William, junior husbandman 588739 588739 Roper, William, junior, of Tyseherst, husbandman 3
3625304 1875450 1875450 defendant Brekynden John butcher 588739 588739 Brekynden, John, of Tyseherst, butcher 4
3632644 1905027 1905027 defendant Ongle or Ougle Henry carpenter 588739 588739 Ongle or Ougle, Henry, of Tyseherst, carpenter 4
3648821 1910019 1910019 defendant Grayllyng Thomas yeoman 588739 588739 Grayllyng, Thomas, of Tyseherst, yeoman 0
3648822 1910019 1910019 defendant Maunser Peter yeoman 588739 588739 Maunser, Peter, of Tyseherst, yeoman 1
3673918 1917879 1917879 defendant Oxenbrige William, senior husbandman 588739 588739 Oxenbrige, William, senior, of Tyseherst, husbandman 0
3683490 1920965 1920965 defendant Maunser Peter husbandman 588739 588739 Maunser, Peter, of Tyseherst, husbandman 0
3683491 1920965 1920965 defendant Stevens John, junior husbandman 588739 588739 Stevens, John, junior, of Tyseherst, husbandman 1
3723202 1933527 1933527 defendant Staple homas tailor 588739 588739 Staple, homas, of Tyseherst, tailor 1
3728737 1935227 1935227 defendant Nasshe Robert husbandman 588739 588739 Nasshe, Robert, of Tyseherst, husbandman 0
3748013 1941298 1941298 defendant Roper Thomas husbandman 588739 588739 Roper, Thomas, of Tyseherst, husbandman 0
3751667 1942437 1942437 defendant Wybarne William gent 588739 588739 Wybarne, William, of Tyseherst, gent 0
3825352 1965781 1965781 defendant Graylyng John husbandman 588739 588739 Graylyng, John, of Tyseherst, husbandman 5
3825361 1965782 1965782 defendant Graylyng John husbandman 588739 588739 Graylyng, John, of Tyseherst, husbandman 5
3865333 1978616 1978616 defendant Elyott Richard laborer 588739 588739 Elyott, Richard, of Tyseherst, laborer 0
3865827 1978801 1978801 plaintiff Oxenbregge William (legal representative) 588739 588739 Oxenbregge, William, of Tyseherst, executors of 0
3882936 1984558 1984558 defendant Aleyn Thomas   588739 588739 Aleyn, Thomas, of Tyseherst, "ryppyer" 0
3907932 1992943 1992943 defendant Morebred John butcher 588739 588739 Morebred, John, of Tyseherst, butcher 2
3961610 2011161 2011161 defendant May Thomas gent 588739 588739 May, Thomas, of Tyseherst, gent 1
3965833 2012664 2012664 defendant Byrcheley John tanner 588739 588739 Byrcheley, John, of Tyseherst, tanner 0
3965835 2012665 2012665 defendant Byrcheley John tanner 588739 588739 Byrcheley, John, of Tyseherst, tanner 0
4157849 2080821 2080821 defendant Wharton John clerk 588739 588739 Wharton, John, of Tyseherst, clerk 0
4157850 2080821 2080821 defendant Harman John yeoman 588739 588739 Harman, John, of Tyseherst, yeoman 1
4157851 2080821 2080821 defendant Harman Thomas yeoman 588739 588739 Harman, Thomas, of Tyseherst, yeoman 2
4157852 2080821 2080821 defendant Moorebread Thomas yeoman 588739 588739 Moorebread, Thomas, of Tyseherst, yeoman 3
4224301 2103983 2103983 defendant Humfrey John   588739 588739 Humfrey, John, of Tyseherst, "asheeler" 0
4229470 2105791 2105791 defendant Nashe Anthony butcher 588739 588739 Nashe, Anthony, of Tyseherst, butcher 0
4236217 2108236 2108236 defendant Taylor John, junior yeoman 588739 588739 Taylor, John, junior, of Tyseherst, yeoman 0
4309982 2133651 2133651 defendant Kyne John yeoman 588739 588739 Kyne, John, of Tyseherst, yeoman 0
4309983 2133651 2133651 defendant Kyne Alexander   588739 588739 Kyne, Alexander, of Tyseherst, husbandman, his son 1
4309984 2133651 2133651 defendant Amerye or EMberye Thomas husbandman 588739 588739 Amerye or EMberye, Thomas, of Tyseherst, yeoman, or of Iden, husbandman 2
4309985 2133651 2133651 defendant Bett Nicholas laborer 588739 588739 Bett, Nicholas, of Tyseherst, husbandman, laborer 3
4312697 2134572 2134572 defendant Cogger John butcher 588739 588739 Cogger, John, of Tyseherst, butcher 0
4317713 2136309 2136309 defendant Cogger John butcher 588739 588739 Cogger, John, of Tyseherst, butcher 0
4317714 2136309 2136309 defendant Randall John clothier 588739 588739 Randall, John, of Tyseherst, clothier 1
4317715 2136309 2136309 defendant Cogger William   588739 588739 Cogger, William, of Tyseherst, "ashealer" 2
4342750 2144737 2144737 defendant Gilbert Edmund husbandman 588739 588739 Gilbert, Edmund, of Tyseherst, husbandman 0
4359753 2150649 2150649 defendant Nooke or Anooke Thomas husbandman 588739 588739 Nooke or Anooke, Thomas, of Tyseherst, husbandman 0
4359755 2150650 2150650 defendant Nooke or Anooke Thomas husbandman 588739 588739 Nooke or Anooke, Thomas, of Tyseherst, husbandman 0
4361781 2151371 2151371 defendant Iden John yeoman 588739 588739 Iden, John, of Tyseherst, yeoman 2
4369427 2154126 2154126 defendant Roper Richard yeoman 588739 588739 Roper, Richard, of Tyseherst, yeoman 0
4369428 2154126 2154126 defendant Cresye John yeoman 588739 588739 Cresye, John, of Tyseherst, yeoman 1
4372435 2155209 2155209 defendant Procter William yeoman 588739 588739 Procter, William, of Tyseherst, yeoman 0
4382399 2158813 2158813 defendant Bacheler Goddard yeoman 588739 588739 Bacheler, Goddard, of Tyseherst, yeoman 1
4382447 2158831 2158831 defendant Cogger Ambrose   588739 588739 Cogger, Ambrose, of Tyseherst, "ashyealer" 0
4382448 2158831 2158831 defendant Batcheler Godderd husbandman 588739 588739 Batcheler, Godderd, of Tyseherst, husbandman 1
4409628 2167818 2167818 defendant Nayshe Anthony butcher 588739 588739 Nayshe, Anthony, of Tyseherst, butcher 0
4736287 2276478 2276478 defendant atte Noke John laborer 588739 588739 atte Noke, John, of Tyseherst, laborer 1
4750961 2280764 2280764 defendant Sprynget John husbandman 588739 588739 Sprynget, John, of Tyseherst, husbandman 0
4788815 2292557 2292557 defendant Berworth John tanner 588739 588739 Berworth, John, of Tyseherst, tanner 0
4817886 2301677 2301677 defendant Bereworth John tanner 588739 588739 Bereworth, John, of Tyseherst, tanner 2
5081560 2380987 2380987 defendant Greylyng John yeoman 588739 588739 Greylyng, John, of Tyseherst, ripier or fishmonger, yeoman 0
5095992 2385255 2385255 defendant Belfant or Belsant Thomas, junior sawyer 588739 588739 Belfant or Belsant, Thomas, junior, of Tyseherst, sawyer 0
5102267 2387082 2387082 defendant Waterman Richard husbandman 588739 588739 Waterman, Richard, of Tyseherst, husbandman 0
5199033 2415468 2415468 defendant Wate John butcher 588739 588739 Wate, John, of Tyseherst, butcher 1
5210898 2418920 2418920 defendant Waterman John butcher 588739 588739 Waterman, John, of Tyseherst, butcher 0
5217613 2420890 2420890 defendant Waterman Richard husbandman 588739 588739 Waterman, Richard, of Tyseherst, husbandman 10
5217631 2420890 2420890 defendant Hamond William husbandman 588739 588739 Hamond, William, of Tyseherst, husbandman 28
5255719 2431905 2431905 defendant Hunt Thomas laborer 588739 588739 Hunt, Thomas, of Tyseherst, laborer 0
5268388 2435880 2435880 defendant Ferthyng John husbandman 588739 588739 Ferthyng, John, of Tyseherst, husbandman 3
5283388 2440196 2440196 defendant Rychard Agnes   588739 588739 Rychard, Agnes, of Tyseherst, servant 0
5283389 2440196 2440196 defendant Cheseman Thomas cooper 588739 588739 Cheseman, Thomas, of Tyseherst, cooper 1
5312576 2448794 2448794 defendant Curll John yeoman 588739 588739 Curll, John, of Tyseherst, yeoman 0
5313022 2448925 2448925 defendant Curle John thatcher 588739 588739 Curle, John, of Tyseherst, thatcher 0
5318969 2450766 2450766 defendant Curll John thatcher 588739 588739 Curll, John, of Tyseherst, thatcher 0
5334097 2455263 2455263 defendant Corle or Curle John thatcher 588739 588739 Corle or Curle, John, of Tyseherst, thatcher 0
5334108 2455267 2455267 defendant Corle John thatcher 588739 588739 Corle, John, of Tyseherst, thatcher 0
5340547 2457240 2457240 defendant Atnoke Thomas baker 588739 588739 Atnoke, Thomas, of Tyseherst, baker 0
5340548 2457240 2457240 defendant Couper Richard husbandman 588739 588739 Couper, Richard, of Tyseherst, husbandman 1
5340719 2457297 2457297 defendant Partrigge Gabriel husbandman 588739 588739 Partrigge, Gabriel, of Tyseherst, husbandman 3
5351374 2460528 2460528 defendant Skynner Robert   588739 588739 Skynner, Robert, of Tyseherst, "repyer" 1
5356132 2461995 2461995 defendant Chaloner John smith 588739 588739 Chaloner, John, of Tyseherst, smith 0
5356133 2461995 2461995 defendant Hunt Thomas husbandman 588739 588739 Hunt, Thomas, of Tyseherst, husbandman 1
5356134 2461995 2461995 defendant Skynner Robert   588739 588739 Skynner, Robert, of Tyseherst, "repyer" 2
5359757 2463091 2463091 defendant Partrych Gabriel husbandman 588739 588739 Partrych, Gabriel, of Tyseherst, husbandman 1
5359758 2463091 2463091 defendant Smyth John   588739 588739 Smyth, John, of Tyseherst, "trugger" 2
5365416 2464857 2464857 defendant Curle John thatcher 588739 588739 Curle, John, of Tyseherst, thatcher 0
5373480 2467301 2467301 defendant Broun John husbandman 588739 588739 Broun, John, of Tyseherst, husbandman 0
5375293 2467858 2467858 defendant Manser Thomas laborer 588739 588739 Manser, Thomas, of Tyseherst, laborer 0
5375294 2467858 2467858 defendant Nayssh Thomas repyer 588739 588739 Nayssh, Thomas, of Tyseherst, repyer 1
5376040 2468099 2468099 defendant Whateman John repyer 588739 588739 Whateman, John, of Tyseherst, repyer 0
5376399 2468214 2468214 defendant Wodman Simon laborer 588739 588739 Wodman, Simon, of Tyseherst, laborer 4
5442259 2487604 2487604 defendant Cheseman Thomas husbandman 588739 588739 Cheseman, Thomas, of Tyseherst, husbandman 0
5454999 2491412 2491412 defendant Cheseman Thomas husbandman 588739 588739 Cheseman, Thomas, of Tyseherst, husbandman 0
5461406 2493363 2493363 defendant Sexten William laborer 588739 588739 Sexten, William, of Tyseherst, laborer 0
5466861 2495036 2495036 defendant Cheseman Thomas husbandman 588739 588739 Cheseman, Thomas, of Tyseherst, husbandman 0
5466863 2495037 2495037 defendant Cheseman Thomas husbandman 588739 588739 Cheseman, Thomas, of Tyseherst, husbandman 0
5473232 2496955 2496955 defendant Hamond Richard forester 588739 588739 Hamond, Richard, of Tyseherst, forester 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);