names

317 rows where place_id = 587716

✎ 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
3592205 1865178 1865178 defendant Coke John yeoman 587716 587716 Coke, John, of Hecham, yeoman 3
3597217 1866753 1866753 defendant Crowe Thomas thatcher 587716 587716 Crowe, Thomas, of Hecham, thatcher 4
3603170 1868656 1868656 defendant Reve Nicholas gent 587716 587716 Reve, Nicholas, of Hecham, gent 0
3607377 1869969 1869969 defendant Ramsey Thomas esq 587716 587716 (Ramsey, Thomas, of Hecham, esq 1
3617151 1872988 1872988 plaintiff Fenys Robert   587716 587716 Fenys, Robert, of Hecham, knight 0
3618354 1873372 1873372 defendant Newerk Thomas husbandman 587716 587716 Newerk, Thomas, of Hecham, husbandman 0
3627104 1903339 1903339 defendant Curtes William chaplain 587716 587716 Curtes, William, of Hecham, chaplain 0
3641982 1907940 1907940 defendant Newark Robert husbandman 587716 587716 Newark, Robert, of Hecham, husbandman 0
3645378 1908962 1908962 defendant Johnson John husbandman 587716 587716 Johnson, John, of Hecham, husbandman 6
3658552 1912927 1912927 defendant Cooke Gregory husbandman 587716 587716 Cooke, Gregory, of Hecham, husbandman 0
3670123 1916602 1916602 defendant Wulmer Walter yeoman 587716 587716 Wulmer, Walter, of Hecham, yeoman 0
3670127 1916603 1916603 defendant Wulmer Walter yeoman 587716 587716 Wulmer, Walter, of Hecham, yeoman 0
3673569 1917761 1917761 defendant Brygge Thomas gent 587716 587716 Brygge, Thomas, of Hecham, gent 0
3677027 1918854 1918854 defendant Smyth Edmund laborer 587716 587716 Smyth, Edmund, of Hecham, laborer 0
3678846 1919451 1919451 defendant Wolmer Walter yeoman 587716 587716 Wolmer, Walter, of Hecham, yeoman 0
3680681 1920038 1920038 defendant Briggis Thomas gent 587716 587716 Briggis, Thomas, of Hecham, gent 0
3685787 1921711 1921711 plaintiff Bedyngfeld Edmund esq 587716 587716 Bedyngfeld, Edmund, of hecham, esq 0
3685789 1921711 1921711 defendant Brygge Thomas gent 587716 587716 Brygge, Thomas, of hecham, gent 1
3689572 1922896 1922896 defendant Brygge Thomas gent 587716 587716 Brygge, Thomas, of Hecham, gent 0
3689642 1922920 1922920 defendant Bryggis Thomas gent 587716 587716 Bryggis, Thomas, of Hecham, gent 0
3690123 1923070 1923070 defendant Folkys John husbandman 587716 587716 Folkys, John, of Hecham, husbandman 0
3700733 1926482 1926482 plaintiff Bedyngfeld Edmund   587716 587716 Bedyngfeld, Edmund, of Hecham, knight 0
3700734 1926482 1926482 defendant Brygge Thomas gent 587716 587716 Brygge, Thomas, of Hecham, gent 0
3715366 1931090 1931090 defendant Wroxham John husbandman 587716 587716 Wroxham, John, of Hecham, husbandman 0
3718164 1931967 1931967 defendant Brygge Thomas gent 587716 587716 Brygge, Thomas, of Hecham, gent 2
3726402 1934523 1934523 defendant Ravyn John (legal representative) 587716 587716 Ravyn, John, of Hecham, husbandman, executor of 0
3726403 1934523 1934523 defendant Foster Alexander clerk 587716 587716 Foster, Alexander, of Hecham, clerk 1
3734759 1937117 1937117 defendant Hovy or Hoby Giles laborer 587716 587716 Hovy or Hoby, Giles, of Hecham, laborer 2
3734760 1937117 1937117 defendant Jade Richard butcher 587716 587716 Jade, Richard, of Hecham, butcher 3
3740901 1939013 1939013 defendant Spryng John esq 587716 587716 Spryng, John, of Hecham, esq 0
3746705 1940882 1940882 defendant Kymbolde Thomas husbandman 587716 587716 Kymbolde, Thomas, of Hecham, husbandman 0
3750613 1942111 1942111 defendant Bulle John yeoman 587716 587716 Bulle, John, of Hecham, yeoman 2
3760141 1945168 1945168 defendant Kymbold Thomas husbandman 587716 587716 Kymbold, Thomas, of Hecham, husbandman 0
3762064 1945778 1945778 plaintiff Fuller William   587716 587716 Fuller, William, of Hecham 0
3765447 1946858 1946858 defendant Lynson William laborer 587716 587716 Lynson, William, of Hecham, laborer 0
3765448 1946858 1946858 defendant Kymbold Thomas laborer 587716 587716 Kymbold, Thomas, of Hecham, laborer 1
3765449 1946858 1946858 defendant Essy Robert tanner 587716 587716 Essy, Robert, of Hecham, tanner 2
3783309 1952530 1952530 defendant Brygge Elizabeth widow 587716 587716 Brygge, Elizabeth, of Hecham, widow 4
3787657 1953926 1953926 defendant Turpyn John   587716 587716 Turpyn, John, of Hecham 1
3795389 1956429 1956429 defendant Janyng Thomas cooper 587716 587716 Janyng, Thomas, of Hecham, cooper 0
3797109 1956978 1956978 plaintiff Fuller William   587716 587716 Fuller, William, of Hecham 0
3803906 1959134 1959134 defendant Turpyn John husbandman 587716 587716 Turpyn, John, of Hecham, husbandman 0
3804832 1959455 1959455 defendant Goche John smith 587716 587716 Goche, John, of Hecham, smith 2
3806115 1959839 1959839 defendant Lowt John husbandman 587716 587716 Lowt, John, of Hecham, husbandman 3
3806116 1959839 1959839 defendant Smyth William husbandman 587716 587716 Smyth, William, of Hecham, husbandman 4
3813524 1962147 1962147 defendant Janyng Thomas cooper 587716 587716 Janyng, Thomas, of Hecham, cooper 3
3817246 1963306 1963306 defendant Holle John yeoman 587716 587716 Holle, John, of Hecham, yeoman 2
3817252 1963307 1963307 defendant Holle John yeoman 587716 587716 Holle, John, of Hecham, yeoman 1
3819166 1963881 1963881 defendant Hobson Alexander husbandman 587716 587716 Hobson, Alexander, of Hecham, husbandman 0
3821233 1964532 1964532 defendant Bull John yeoman 587716 587716 Bull, John, of Hecham, yeoman 0
3823526 1965260 1965260 defendant Kembold Thomas husbandman 587716 587716 Kembold, Thomas, of Hecham, husbandman 0
3829102 1966982 1966982 defendant Fenes John gent 587716 587716 Fenes, John, of Hecham, gent 0
3832539 1968096 1968096 defendant Mayken John laborer 587716 587716 Mayken, John, of Hecham, laborer 0
3838413 1969935 1969935 defendant Goslyn Roger gent 587716 587716 Goslyn, Roger, of Hecham, gent 0
3838414 1969935 1969935 defendant Johnson Richard husbandman 587716 587716 Johnson, Richard, of Hecham, husbandman 1
3838415 1969935 1969935 defendant Alen Geoffrey husbandman 587716 587716 Alen, Geoffrey, of Hecham, husbandman 2
3838416 1969935 1969935 defendant Precher Thomas husbandman 587716 587716 Precher, Thomas, of Hecham, husbandman 3
3838417 1969935 1969935 defendant Raven John husbandman 587716 587716 Raven, John, of Hecham, husbandman 4
3838418 1969935 1969935 defendant Raven William husbandman 587716 587716 Raven, William, of Hecham, husbandman 5
3839660 1970330 1970330 defendant Welham Richard husbandman 587716 587716 Welham, Richard, of Hecham, husbandman 0
3839661 1970330 1970330 defendant Welham Thomas husbandman 587716 587716 Welham, Thomas, of Hecham, husbandman 1
3843100 1971366 1971366 defendant Wryght John carpenter 587716 587716 Wryght, John, of Hecham, carpenter 1
3852114 1974257 1974257 defendant Blacksmyth Thomas husbandman 587716 587716 Blacksmyth, Thomas, of Hecham, husbandman 1
3852115 1974257 1974257 defendant Hardy William tailor 587716 587716 Hardy, William, of Hecham, tailor 2
3852480 1974382 1974382 defendant Welham Thomas husbandman 587716 587716 Welham, Thomas, of Hecham, husbandman 4
3859272 1976593 1976593 defendant Dale Robert butcher 587716 587716 Dale, Robert, of Hecham, butcher 4
3869881 1980171 1980171 defendant Wryghte John carpenter 587716 587716 Wryghte, John, of Hecham, carpenter 2
3877553 1982731 1982731 defendant Gybon Henry tailor 587716 587716 Gybon, Henry, of Hecham, tailor 0
3877554 1982731 1982731 defendant Gybon Robert tailor 587716 587716 Gybon, Robert, of Hecham, tailor 1
3877555 1982731 1982731 defendant Gybon John laborer 587716 587716 Gybon, John, of Hecham, laborer 2
3888422 1986389 1986389 defendant Janyng Thomas cooper 587716 587716 Janyng, Thomas, of Hecham, cooper 3
3888739 1986487 1986487 defendant Baker Alexander husbandman 587716 587716 Baker, Alexander, of Hecham, husbandman 1
3916135 1995782 1995782 defendant Brigges Edward gent 587716 587716 Brigges, Edward, of Hecham, gent 0
3917497 1996210 1996210 defendant Laman William butcher 587716 587716 Laman, William, of Hecham, butcher 0
3924788 1998608 1998608 defendant Kembowe John, junior husbandman 587716 587716 Kembowe, John, junior, of Hecham, husbandman 1
3951001 2007417 2007417 defendant Bowle Thomas husbandman 587716 587716 Bowle, Thomas, of Hecham, husbandman 0
4033285 2036559 2036559 defendant Raven William husbandman 587716 587716 Raven, William, of Hecham, husbandman 0
4033286 2036559 2036559 defendant Raven Ambrose yeoman or waterman 587716 587716 Raven, Ambrose, of Hecham, yeoman or waterman 1
4036185 2037624 2037624 defendant Raven Thomas yeoman 587716 587716 Raven, Thomas, of Hecham, yeoman 1
4036189 2037625 2037625 defendant Ravon Thomas yeoman 587716 587716 Ravon, Thomas, of Hecham, yeoman 1
4044965 2040655 2040655 plaintiff Rolff Eustace yeoman 587716 587716 Rolff, Eustace, of Hecham, yeoman 0
4250492 2113152 2113152 defendant Skyppon Thomas yeoman 587716 587716 Skyppon, Thomas, of Hecham, yeoman 0
4335280 2142071 2142071 defendant Skyppon William yeoman 587716 587716 Skyppon, William, of Hecham, yeoman 1
4335281 2142071 2142071 defendant Sawer Robert carpenter 587716 587716 Sawer, Robert, of Hecham, carpenter 2
4468039 2190674 2190674 plaintiff Baret Simon   587716 587716 Baret, Simon, of Hecham 0
4468041 2190675 2190675 plaintiff Baret Simon   587716 587716 Baret, Simon, of Hecham 0
4470636 2191465 2191465 plaintiff Bryghte John   587716 587716 Bryghte, John, of Hecham 0
4471437 2191727 2191727 defendant Wryghte John   587716 587716 Wryghte, John, of Hecham 5
4471458 2191731 2191731 defendant Strystrem William   587716 587716 Strystrem, William, of Hecham 0
4478568 2193963 2193963 defendant Wrighte John   587716 587716 Wrighte, John, of Hecham 2
4478569 2193963 2193963 defendant Cakebreed John   587716 587716 Cakebreed, John, of Hecham 3
4479943 2194392 2194392 defendant Wryghte John, senior   587716 587716 Wryghte, John, senior, of Hecham 0
4479944 2194392 2194392 defendant Wryghte John, junior   587716 587716 Wryghte, John, junior, of Hecham 1
4479945 2194392 2194392 defendant Randolf John   587716 587716 Randolf, John, of Hecham 2
4481944 2195060 2195060 plaintiff Marchaunt Thomas   587716 587716 Marchaunt, Thomas, of Hecham, son of Simon 0
4485855 2196283 2196283 plaintiff Robynsesson Alice   587716 587716 Robynsesson, Alice, of Hecham, formerly wife of Simon 0
4508553 2203152 2203152 defendant Posewode John   587716 587716 Posewode, John, of Hecham 1
4546209 2214761 2214761 defendant Doraunt John   587716 587716 Doraunt, John, of Hecham 0
4546210 2214761 2214761 defendant Doraunt Richard   587716 587716 Doraunt, Richard, of Hecham 1
4551737 2216487 2216487 plaintiff Eleyne Robert   587716 587716 Eleyne, Robert, of Hecham 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);