names

248 rows where place_id = 585900

✎ 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
3587453 1863723 1863723 defendant Gardener Richard chaplain 585900 585900 Gardener, Richard, of Saham Tony, chaplain 0
3606082 1869570 1869570 plaintiff Markaunte Nicholas, senior   585900 585900 Markaunte, Nicholas, senior, of Saham Tony 0
3608391 1870283 1870283 defendant Coo John (legal representative) 585900 585900 Coo, John, of Saham Tony, gent, administrator of 0
3608567 1870336 1870336 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3608570 1870337 1870337 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3610025 1870808 1870808 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3610029 1870809 1870809 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3615700 1872555 1872555 defendant Trendyll Thomas yeoman 585900 585900 Trendyll, Thomas, of Saham Tony, yeoman 0
3624519 1875205 1875205 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3624690 1875261 1875261 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3629055 1903965 1903965 defendant Talbot John woolman 585900 585900 Talbot, John, of Saham Tony, woolman 0
3629938 1904220 1904220 defendant Atkynson Robert clerk 585900 585900 Atkynson, Robert, of Saham Tony, clerk 0
3633810 1905387 1905387 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3637154 1906420 1906420 defendant Tenawnt Thomas, junior husbandman 585900 585900 Tenawnt, Thomas, junior, of Saham Tony, husbandman 1
3640724 1907543 1907543 defendant Chapman John woolman 585900 585900 Chapman, John, of Saham Tony, woolman 0
3640726 1907544 1907544 defendant Heynes William husbandman 585900 585900 Heynes, William, of Saham Tony, husbandman 0
3640728 1907545 1907545 defendant Norfolke Nicholas tailor 585900 585900 Norfolke, Nicholas, of Saham Tony, tailor 0
3641205 1907700 1907700 defendant Atkenson Robert chaplain 585900 585900 Atkenson, Robert, of Saham Tony, chaplain 1
3644045 1908567 1908567 defendant Markaunt George butcher 585900 585900 Markaunt, George, of Saham Tony, butcher 0
3646141 1909194 1909194 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3649708 1910281 1910281 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 1
3654822 1911767 1911767 defendant Deynes Thomas husbandman 585900 585900 Deynes, Thomas, of Saham Tony, husbandman 3
3663696 1914581 1914581 defendant Marcaunt George yeoman 585900 585900 Marcaunt, George, of Saham Tony, yeoman 0
3665028 1915008 1915008 defendant Stampe Roger yeoman 585900 585900 Stampe, Roger, of Saham Tony, yeoman 0
3666094 1915339 1915339 defendant Chapman John   585900 585900 Chapman, John, of Saham tony, wool man 0
3678593 1919362 1919362 defendant Markaunt George yeoman 585900 585900 Markaunt, George, of Saham Tony, yeoman 0
3691635 1923542 1923542 defendant Markaunt George yeoman 585900 585900 Markaunt, George, of Saham Tony, yeoman 0
3692265 1923751 1923751 defendant Markaunt George yeoman 585900 585900 Markaunt, George, of Saham Tony, yeoman 0
3694719 1924553 1924553 defendant Stampe Robert   585900 585900 Stampe, Robert, of Saham Tony, shepherd 0
3704452 1927688 1927688 defendant Hawyn John husbandman 585900 585900 Hawyn, John, of Saham Tony, husbandman 0
3705886 1928125 1928125 defendant Markaunt George yeoman 585900 585900 Markaunt, George, of Saham Tony, yeoman 0
3718461 1932053 1932053 plaintiff Freman Richard (legal representative) 585900 585900 Freman, Richard, of Saham Tony, executor of 0
3718463 1932053 1932053 defendant Hawyn John husbandman 585900 585900 Hawyn, John, of Saham Tony, husbandman 0
3723420 1933591 1933591 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3723422 1933592 1933592 defendant Coo Hugh gent 585900 585900 Coo, Hugh, of Saham Tony, gent 0
3733786 1936819 1936819 defendant Newman Thomas husbandman 585900 585900 Newman, Thomas, of Saham Tony, husbandman 0
3733787 1936819 1936819 defendant Stampe Robert husbandman 585900 585900 Stampe, Robert, of Saham Tony, husbandman 1
3739125 1938445 1938445 defendant Tenant Thomas yeoman 585900 585900 Tenant, Thomas, of Saham Tony, yeoman 1
3747368 1941092 1941092 defendant Parkyn John butcher 585900 585900 Parkyn, John, of Saham Tony, butcher 0
3756111 1943869 1943869 defendant Markaunt Robert husbandman 585900 585900 Markaunt, Robert, of Saham Tony, husbandman 0
3763395 1946179 1946179 defendant Reder Edmund   585900 585900 Reder, Edmund, of Saham Tony, parish clerk 0
3763588 1946246 1946246 defendant Baret George butcher 585900 585900 Baret, George, of Saham Tony, butcher 0
3763859 1946340 1946340 defendant Parkyn John butcher 585900 585900 Parkyn, John, of Saham Tony, butcher 0
3763860 1946340 1946340 defendant Baret George husbandman 585900 585900 Baret, George, of Saham Tony, husbandman 1
3763861 1946340 1946340 defendant Newman Thomas husbandman 585900 585900 Newman, Thomas, of Saham Tony, husbandman 2
3763863 1946340 1946340 defendant Garet William husbandman 585900 585900 Garet, William, of Saham Tony, husbandman 4
3768285 1947722 1947722 defendant Coo Christopher esq 585900 585900 Coo, Christopher, of Saham Tony, esq 1
3771042 1948631 1948631 defendant Markaunt Robert husbandman 585900 585900 Markaunt, Robert, of Saham Tony, husbandman 2
3779958 1951457 1951457 defendant Baret George butcher 585900 585900 Baret, George, of Saham Tony, butcher 1
3787181 1953782 1953782 plaintiff Reder Edmund   585900 585900 Reder, Edmund, of Saham Tony 0
3793184 1955727 1955727 plaintiff Bolton Thomas (legal representative) 585900 585900 Bolton, Thomas, of Saham Tony, gent, executrix of 0
3794618 1956195 1956195 defendant Fysshe Thomas husbandman 585900 585900 Fysshe, Thomas, of Saham Tony, husbandman 0
3794619 1956195 1956195 defendant Baret George laborer 585900 585900 Baret, George, of Saham Tony, laborer 1
3794620 1956195 1956195 defendant Baret William carpenter 585900 585900 Baret, William, of Saham Tony, carpenter 2
3802304 1958619 1958619 defendant Coo Leonard gent 585900 585900 Coo, Leonard, of Saham Tony, gent 1
3802307 1958620 1958620 defendant Coo Leonard gent 585900 585900 Coo, Leonard, of Saham Tony, gent 0
3802782 1958766 1958766 defendant Baret George butcher 585900 585900 Baret, George, of Saham Tony, butcher 0
3802784 1958766 1958766 defendant Markaunt Robert beer brewer 585900 585900 Markaunt, Robert, of Saham Tony, beer brewer 2
3818396 1963652 1963652 plaintiff Hansard Humphrey   585900 585900 Hansard, Humphrey, of Saham Tony 1
3824536 1965545 1965545 defendant Northfolke Nicholas husbandman 585900 585900 Northfolke, Nicholas, of Saham Tony, husbandman 1
3828162 1966675 1966675 defendant Hansard Humphrey gent 585900 585900 Hansard, Humphrey, of Saham Tony, gent 0
3829316 1967053 1967053 defendant Yelverton John gent 585900 585900 Yelverton, John, of Saham Tony, gent 1
3835152 1968935 1968935 defendant Warde John husbandman 585900 585900 Warde, John, of Saham Tony, husbandman 0
3836947 1969462 1969462 defendant Austen Thomas husbandman 585900 585900 Austen, Thomas, of Saham Tony, husbandman 0
3839104 1970152 1970152 defendant Pory Peter gent 585900 585900 Pory, Peter, of Saham Tony, gent 0
3846340 1972408 1972408 defendant Cokke Nicholas husbandman 585900 585900 Cokke, Nicholas, of Saham Tony, husbandman 2
3846341 1972408 1972408 defendant Blake John husbandman 585900 585900 Blake, John, of Saham Tony, husbandman 3
3846481 1972453 1972453 defendant Drury John gent 585900 585900 Drury, John, of Saham Tony, gent 0
3846483 1972453 1972453 defendant Trendell Gregory yeoman 585900 585900 Trendell, Gregory, of Saham Tony, yeoman 2
3846709 1972526 1972526 defendant Tyndell William husbandman 585900 585900 Tyndell, William, of Saham Tony, husbandman 1
3852640 1974432 1974432 defendant Herne John husbandman 585900 585900 Herne, John, of Saham Tony, husbandman 0
3852641 1974432 1974432 defendant Palmer Nicholas husbandman 585900 585900 Palmer, Nicholas, of Saham Tony, husbandman 1
3855193 1975257 1975257 defendant Savery Richard butcher 585900 585900 Savery, Richard, of Saham Tony, butcher 0
3855194 1975257 1975257 defendant Therne John husbandman 585900 585900 Therne, John, of Saham Tony, husbandman 1
3855472 1975355 1975355 defendant Pory Peter gent 585900 585900 Pory, Peter, of Saham Tony, gent 0
3861684 1977368 1977368 defendant Barret George butcher 585900 585900 Barret, George, of Saham Tony, butcher 0
3866590 1979053 1979053 defendant Turnour John yeoman 585900 585900 Turnour, John, of Saham Tony, yeoman 0
3867949 1979514 1979514 defendant Barret George butcher 585900 585900 Barret, George, of Saham Tony, butcher 3
3872146 1980915 1980915 defendant Austyn Thomas yeoman 585900 585900 Austyn, Thomas, of Saham Tony, yeoman 0
3872147 1980915 1980915 defendant Hey William husbandman 585900 585900 Hey, William, of Saham Tony, husbandman 1
3873415 1981322 1981322 defendant Humfrey John tanner 585900 585900 Humfrey, John, of Saham Tony, tanner 0
3876896 1982514 1982514 defendant Davy Brian husbandman 585900 585900 Davy, Brian, of Saham Tony, husbandman 0
3879248 1983310 1983310 defendant Tenant George husbandman 585900 585900 Tenant, George, of Saham Tony, husbandman 2
3881144 1983962 1983962 defendant Tenaunt George husbandman 585900 585900 Tenaunt, George, of Saham Tony, husbandman 2
3881145 1983962 1983962 defendant Markaunt George butcher 585900 585900 Markaunt, George, of Saham Tony, butcher 3
3886565 1985757 1985757 defendant Cokke Richard yeoman 585900 585900 Cokke, Richard, of Saham Tony, yeoman 2
3892375 1987701 1987701 defendant Southous Edmund gent 585900 585900 Southous, Edmund, of Saham Tony, gent 0
3893752 1988129 1988129 defendant Ives Stephen butcher 585900 585900 Ives, Stephen, of Saham Tony, butcher 2
3893766 1988133 1988133 defendant Savery Richard butcher 585900 585900 Savery, Richard, of Saham Tony, butcher 0
3895444 1988686 1988686 plaintiff Southous Edward   585900 585900 Southous, Edward, of Saham Tony 0
3895819 1988808 1988808 defendant Pory Peter gent 585900 585900 Pory, Peter, of Saham Tony, gent 0
3895852 1988820 1988820 defendant Savery Richard butcher 585900 585900 Savery, Richard, of Saham Tony, butcher 1
3900367 1990359 1990359 defendant Watson William husbandman 585900 585900 Watson, William, of Saham Tony, husbandman 0
3905261 1992027 1992027 defendant Cocke John husbandman 585900 585900 Cocke, John, of Saham Tony, husbandman 0
3910095 1993684 1993684 defendant Pory Peter gent 585900 585900 Pory, Peter, of Saham Tony, gent 0
3911111 1994043 1994043 defendant Davy Brian husbandman 585900 585900 Davy, Brian, of Saham Tony, husbandman 0
3914469 1995181 1995181 defendant Therne John husbandman 585900 585900 Therne, John, of Saham Tony, husbandman 1
3915281 1995477 1995477 defendant Pykard George husbandman 585900 585900 Pykard, George, of Saham Tony, husbandman 0
3916494 1995893 1995893 defendant Smyth Richard laborer 585900 585900 Smyth, Richard, of Saham Tony, laborer 3
3924552 1998527 1998527 defendant Savery Richard butcher 585900 585900 Savery, Richard, of Saham Tony, butcher 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);