names

255 rows where place_id = 589100

✎ 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
3596539 1866552 1866552 defendant White William husbandman 589100 589100 White, William, of Chesterton, husbandman 0
3596541 1866553 1866553 defendant Whyte William husbandman 589100 589100 Whyte, William, of Chesterton, husbandman 0
3625314 1875454 1875454 plaintiff White William   589100 589100 White, William, of Chesterton 0
3626085 1903018 1903018 defendant Byrd Thomas yeoman 589100 589100 Byrd, Thomas, of Chesterton, yeoman 2
3654725 1911735 1911735 defendant Battesford Edward gent 589100 589100 Battesford, Edward, of Chesterton, gent 3
3656731 1912360 1912360 plaintiff Coall Henry   589100 589100 Coall, Henry, of Chesterton 1
3660128 1913429 1913429 defendant Burne John yeoman 589100 589100 Burne, John, of Chesterton, yeoman 3
3660134 1913430 1913430 defendant Burne John yeoman 589100 589100 Burne, John, of Chesterton, yeoman 3
3662300 1914124 1914124 defendant South Robert husbandman 589100 589100 South, Robert, of Chesterton, husbandman 0
3662301 1914124 1914124 defendant South William laborer 589100 589100 South, William, of Chesterton, laborer 1
3664609 1914886 1914886 defendant Sperhawke John husbandman 589100 589100 Sperhawke, John, of Chesterton, husbandman 0
3665691 1915219 1915219 defendant Coall Henry husbandman 589100 589100 Coall, Henry, of Chesterton, husbandman 2
3673877 1917863 1917863 defendant Disser William husbandman 589100 589100 Disser, William, of Chesterton, husbandman 1
3673881 1917864 1917864 defendant Disser William husbandman 589100 589100 Disser, William, of Chesterton, husbandman 1
3675087 1918241 1918241 defendant Dyssher William husbandman 589100 589100 Dyssher, William, of Chesterton, husbandman 1
3675977 1918524 1918524 defendant Sparehawke John husbandman 589100 589100 Sparehawke, John, of Chesterton, husbandman 1
3677546 1919022 1919022 plaintiff Lovell Thomas esq 589100 589100 Lovell, Thomas, of Chesterton, esq 0
3677548 1919023 1919023 plaintiff Lovell Thomas esq 589100 589100 Lovell, Thomas, of Chesterton, esq 0
3681829 1920420 1920420 defendant Dyssher William husbandman 589100 589100 Dyssher, William, of Chesterton, husbandman 0
3681830 1920420 1920420 defendant Raynes William husbandman 589100 589100 Raynes, William, of Chesterton, husbandman 1
3697358 1925393 1925393 defendant Burne Thomas yeoman 589100 589100 Burne, Thomas, of Chesterton, yeoman 0
3697359 1925393 1925393 defendant Wode John yeoman 589100 589100 Wode, John, of Chesterton, yeoman 1
3697360 1925393 1925393 defendant Cowall Henry yeoman 589100 589100 Cowall, Henry, of Chesterton, yeoman 2
3712661 1930275 1930275 defendant Petoo John esq 589100 589100 Petoo, John, of Chesterton, esq 0
3715795 1931227 1931227 defendant Pawkyn Robert husbandman 589100 589100 Pawkyn, Robert, of Chesterton, husbandman 4
3725986 1934400 1934400 defendant Dissher William, junior husbandman 589100 589100 Dissher, William, junior, of Chesterton, husbandman 0
3725987 1934401 1934401 plaintiff Swayne William yeoman 589100 589100 Swayne, William, of Chesterton, yeoman 0
3758588 1944683 1944683 defendant Pache William husbandman 589100 589100 Pache, William, of Chesterton, husbandman 0
3759460 1944952 1944952 defendant Burne Richard yeoman 589100 589100 Burne, Richard, of Chesterton, yeoman 1
3763044 1946073 1946073 plaintiff Guye John   589100 589100 Guye, John, of Chesterton 0
3764026 1946393 1946393 defendant Newe Richard husbandman 589100 589100 Newe, Richard, of Chesterton, husbandman 0
3785106 1953129 1953129 defendant Dyssher William, junior (legal representative) 589100 589100 Dyssher, William, junior, of Chesterton, husbandman, executors of 1
3785107 1953129 1953129 defendant Dyssher Joan widow 589100 589100 (Dyssher, Joan, of Chesterton, widow 2
3785108 1953129 1953129 defendant Mychell Richard husbandman 589100 589100 Mychell, Richard, of Chesterton, husbandman 3
3785227 1953163 1953163 defendant Drewe Thomas husbandman 589100 589100 Drewe, Thomas, of Chesterton, husbandman 0
3794187 1956053 1956053 defendant Patche William yeoman 589100 589100 Patche, William, of Chesterton, yeoman 0
3796704 1956855 1956855 defendant Peytoo John esq 589100 589100 Peytoo, John, of Chesterton, esq 0
3796706 1956856 1956856 defendant Peytoo John esq 589100 589100 Peytoo, John, of Chesterton, esq 0
3797166 1956997 1956997 defendant Gotobed Richard husbandman 589100 589100 Gotobed, Richard, of Chesterton, husbandman 1
3802665 1958729 1958729 defendant Swayne William (legal representative) 589100 589100 Swayne, William, of Chesterton, yeoman, executors of 0
3802666 1958729 1958729 defendant Adam Thomas yeoman 589100 589100 (Adam, Thomas, of Chesterton, yeoman 1
3806142 1959849 1959849 defendant Coke William husbandman 589100 589100 Coke, William, of Chesterton, husbandman 0
3806152 1959852 1959852 defendant Coke William husbandman 589100 589100 Coke, William, of Chesterton, husbandman 1
3811859 1961613 1961613 defendant Hychecockys John yeoman 589100 589100 Hychecockys, John, of Chesterton, yeoman 0
3811875 1961618 1961618 defendant Burne Roger husbandman 589100 589100 Burne, Roger, of Chesterton, husbandman 3
3811876 1961618 1961618 defendant Kenhall Henry husbandman 589100 589100 Kenhall, Henry, of Chesterton, husbandman 4
3814444 1962431 1962431 defendant Burne Thomas yeoman 589100 589100 Burne, Thomas, of Chesterton, yeoman 0
3817336 1963331 1963331 defendant Hichecok John yeoman 589100 589100 Hichecok, John, of Chesterton, yeoman 1
3820122 1964172 1964172 defendant Swayne William (legal representative) 589100 589100 Swayne, William, of Chesterton, yeoman, executors of 0
3833059 1968264 1968264 plaintiff Knyghte John   589100 589100 Knyghte, John, of Chesterton 0
3840176 1970498 1970498 defendant Malden Henry husbandman 589100 589100 Malden, Henry, of Chesterton, husbandman 2
3840184 1970499 1970499 defendant Malden Henry husbandman 589100 589100 Malden, Henry, of Chesterton, husbandman 3
3840189 1970499 1970499 defendant Michell Richard husbandman 589100 589100 Michell, Richard, of Chesterton, husbandman 8
3840194 1970500 1970500 defendant Malden Henry husbandman 589100 589100 Malden, Henry, of Chesterton, husbandman 2
3840201 1970502 1970502 defendant Horne Thomas husbandman 589100 589100 Horne, Thomas, of Chesterton, husbandman 0
3840202 1970502 1970502 defendant Patche William husbandman 589100 589100 Patche, William, of Chesterton, husbandman 1
3862048 1977494 1977494 defendant Cowell Henry yeoman 589100 589100 Cowell, Henry, of Chesterton, yeoman 4
3872414 1980997 1980997 defendant Horne Thomas husbandman 589100 589100 Horne, Thomas, of Chesterton, husbandman 0
3944906 2005313 2005313 plaintiff Bentley William husbandman 589100 589100 Bentley, William, of Chesterton, husbandman 0
3954241 2008558 2008558 defendant Maund Simon yeoman 589100 589100 Maund, Simon, of Chesterton, yeoman 0
4023408 2033082 2033082 defendant Cobbe Richard yeoman 589100 589100 Cobbe, Richard, of Chesterton, yeoman 0
4049373 2042221 2042221 defendant Spycer William husbandman 589100 589100 Spycer, William, of Chesterton, husbandman 1
4052989 2043504 2043504 defendant Clerke Nicholas chapman 589100 589100 Clerke, Nicholas, of Chesterton, chapman 2
4054788 2044101 2044101 defendant Cobbe Richard yeoman 589100 589100 Cobbe, Richard, of Chesterton, yeoman 0
4054971 2044173 2044173 plaintiff Baxter William maltster 589100 589100 Baxter, William, of Chesterton, maltster 0
4097324 2059360 2059360 defendant Shurley Robert husbandman 589100 589100 Shurley, Robert, of Chesterton, husbandman 1
4104824 2062002 2062002 defendant Brakyn Richard esq 589100 589100 Brakyn, Richard, of Chesterton, esq 0
4107365 2062923 2062923 defendant Burburye Elias husbandman 589100 589100 Burburye, Elias, of Chesterton, husbandman 0
4107367 2062924 2062924 defendant Burburye Elias husbandman 589100 589100 Burburye, Elias, of Chesterton, husbandman 0
4107368 2062924 2062924 defendant Hoden William husbandman 589100 589100 Hoden, William, of Chesterton, husbandman 1
4107370 2062925 2062925 defendant Burburye Elias yeoman 589100 589100 Burburye, Elias, of Chesterton, yeoman 0
4118343 2066850 2066850 defendant Hytchcock John yeoman 589100 589100 Hytchcock, John, of Chesterton, yeoman 0
4164429 2083077 2083077 defendant Burne Henry yeoman 589100 589100 Burne, Henry, of Chesterton, yeoman 3
4198165 2094904 2094904 defendant Pecocke Thomas maltster 589100 589100 Pecocke, Thomas, of Chesterton, husbandman, maltster 0
4198784 2095136 2095136 defendant Barnard John yeoman 589100 589100 Barnard, John, of Chesterton, yeoman 0
4204687 2097185 2097185 defendant Smyth William yeoman 589100 589100 Smyth, William, of Chesterton, yeoman 3
4212006 2099748 2099748 defendant Parrysche Richard yeoman 589100 589100 Parrysche Richard, of Chesterton, yeoman 1
4221486 2103007 2103007 defendant Burne William husbandman 589100 589100 Burne, William, of Chesterton, husbandman 0
4221487 2103007 2103007 defendant Turnor John husbandman 589100 589100 Turnor, John, of Chesterton, husbandman 1
4221488 2103007 2103007 defendant Tursfeild Richard laborer 589100 589100 Tursfeild, Richard, of Chesterton, laborer 2
4221489 2103007 2103007 defendant Olde Robert laborer 589100 589100 Olde, Robert, of Chesterton, laborer 3
4234912 2107762 2107762 defendant Spycer Urian or Urias yeoman 589100 589100 Spycer, Urian or Urias, of Chesterton, yeoman 2
4248469 2112475 2112475 defendant Ranewe John husbandman 589100 589100 Ranewe, John, of Chesterton, husbandman 0
4259608 2116190 2116190 defendant Gonne John yeoman 589100 589100 Gonne, John, of Chesterton, yeoman 1
4264589 2117800 2117800 defendant Monsey or Mousey Roger dyer 589100 589100 Monsey or Mousey, Roger, of Chesterton, yeoman, dyer 0
4264593 2117801 2117801 defendant Mousey Roger dyer 589100 589100 Mousey, Roger, of Chesterton, yeoman, dyer 0
4271565 2120071 2120071 defendant Munsey Roger dyer 589100 589100 Munsey, Roger, of Chesterton, yeoman, dyer 0
4273120 2120571 2120571 defendant Silvertoppe William yeoman 589100 589100 Silvertoppe, William, of Chesterton, yeoman 1
4273594 2120721 2120721 defendant Ranewe John husbandman 589100 589100 Ranewe, John, of Chesterton, husbandman 0
4283618 2124178 2124178 defendant Peytoo William   589100 589100 Peytoo, William, of Chesterton esq 0
4283619 2124178 2124178 defendant Dale William yeoman 589100 589100 Dale, William, of Chesterton, yeoman 1
4283620 2124178 2124178 defendant Thursfeld William yeoman 589100 589100 Thursfeld, William, of Chesterton, yeoman 2
4283621 2124178 2124178 defendant Bissell Jane spinster 589100 589100 Bissell, Jane, of Chesterton, spinster 3
4293672 2127801 2127801 defendant Renowe John, senior yeoman 589100 589100 Renowe, John, senior, of Chesterton, yeoman 0
4297378 2129166 2129166 defendant Silvertopp William yeoman 589100 589100 Silvertopp, William, of Chesterton, yeoman 0
4303963 2131519 2131519 defendant Sherley Robert yeoman 589100 589100 Sherley, Robert, of Chesterton, yeoman 6
4354513 2148812 2148812 defendant Dawntrye Robert yeoman 589100 589100 Dawntrye, Robert, of Chesterton, yeoman 1
4354515 2148813 2148813 defendant Redhead Andrew yeoman 589100 589100 Redhead, Andrew, of Chesterton, yeoman 0
4356304 2149431 2149431 defendant Goodwyn William yeoman 589100 589100 Goodwyn, William, of Chesterton, yeoman 0
4356978 2149671 2149671 defendant Sylvertopp William yeoman 589100 589100 Sylvertopp, William, of Chesterton, yeoman 2

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