names

186 rows where place_id = 593814

✎ 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
3613428 1871846 1871846 defendant Ramme Edward husbandman 593814 593814 Ramme, Edward, of Sporle, husbandman 4
3621529 1874276 1874276 defendant Wuttys William husbandman 593814 593814 Wuttys, William, of Sporle, husbandman 2
3646610 1909345 1909345 defendant Asshby Robert laborer 593814 593814 Asshby, Robert, of Sporle, laborer 1
3650960 1910671 1910671 defendant Isaac William yeoman 593814 593814 Isaac, William, of Sporle, yeoman 0
3682030 1920487 1920487 defendant Calybut Francis husbandman 593814 593814 Calybut, Francis, of Sporle, husbandman 0
3684798 1921381 1921381 defendant Isak Richard husbandman 593814 593814 Isak, Richard, of Sporle, husbandman 0
3684800 1921382 1921382 defendant Isak Richard husbandman 593814 593814 Isak, Richard, of Sporle, husbandman 0
3699979 1926226 1926226 defendant Isaak Richard husbandman 593814 593814 Isaak, Richard, of Sporle, husbandman 0
3699981 1926227 1926227 defendant Isak Richard husbandman 593814 593814 Isak, Richard, of Sporle, husbandman 0
3707264 1928561 1928561 defendant Isack Richard yeoman 593814 593814 Isack, Richard, of Sporle, yeoman 0
3713503 1930534 1930534 defendant Isek Richard husbandman 593814 593814 Isek, Richard, of Sporle, husbandman 0
3713505 1930535 1930535 defendant Isak Richard husbandman 593814 593814 Isak, Richard, of Sporle, husbandman 0
3721304 1932969 1932969 defendant Isaak Richard yeoman 593814 593814 Isaak, Richard, of Sporle, yeoman 0
3747660 1941187 1941187 defendant Dyer William gent 593814 593814 Dyer, William, of Sporle, gent 2
3752861 1942818 1942818 defendant Wentlonde Thomas husbandman 593814 593814 Wentlonde, Thomas, of Sporle, husbandman 0
3761107 1945476 1945476 defendant Wentlond Robert yeoman 593814 593814 Wentlond, Robert, of Sporle, yeoman 1
3763277 1946147 1946147 defendant Wentlonde Thomas husbandman 593814 593814 Wentlonde, Thomas, of Sporle, husbandman 1
3801015 1958229 1958229 defendant Davy Paul husbandman 593814 593814 Davy, Paul, of Sporle, husbandman 1
3811214 1961402 1961402 defendant Maunde Richard husbandman 593814 593814 Maunde, Richard, of Sporle, husbandman 0
3840239 1970514 1970514 defendant Isake William yeoman 593814 593814 Isake, William, of Sporle, yeoman 1
3846702 1972524 1972524 defendant Eyre William (legal representative) 593814 593814 Eyre, William, of Sporle, gent, executors of 0
3846705 1972525 1972525 defendant Syre William (legal representative) 593814 593814 Syre, William, of Sporle, gent, executors of 0
3848863 1973234 1973234 defendant Maunde Richard husbandman 593814 593814 Maunde, Richard, of Sporle, husbandman 4
3848864 1973234 1973234 defendant Calibutt Francis husbandman 593814 593814 Calibutt, Francis, of Sporle, husbandman 5
3857008 1975825 1975825 defendant Isake William yeoman 593814 593814 Isake, William, of Sporle, yeoman 0
3863322 1977928 1977928 defendant Isaak William husbandman 593814 593814 Isaak, William, of Sporle, husbandman 0
3863699 1978045 1978045 defendant Pery William husbandman 593814 593814 Pery, William, of Sporle, husbandman 3
3864067 1978166 1978166 defendant Maunde Richard husbandman 593814 593814 Maunde, Richard, of Sporle, husbandman 1
3864368 1978279 1978279 defendant Isak William husbandman 593814 593814 Isak, William, of Sporle, husbandman 0
3871207 1980623 1980623 defendant Isak William husbandman 593814 593814 Isak, William, of Sporle, husbandman 4
3878996 1983225 1983225 defendant Maunde Richard husbandman 593814 593814 Maunde, Richard, of Sporle, husbandman 0
3881142 1983962 1983962 defendant Markaunt Henry butcher 593814 593814 Markaunt, Henry, of Sporle, butcher 0
3881143 1983962 1983962 defendant Isaak William yeoman 593814 593814 Isaak, William, of Sporle, yeoman 1
3893243 1987973 1987973 defendant Feltwell Andrew laborer 593814 593814 Feltwell, Andrew, of Sporle, laborer 2
3893244 1987973 1987973 defendant Case William laborer 593814 593814 Case, William, of Sporle, laborer 3
3893247 1987973 1987973 defendant Mendham Robert, senior laborer 593814 593814 Mendham, Robert, senior, of Sporle, laborer 6
3893248 1987973 1987973 defendant Mendham Robert, junior laborer 593814 593814 Mendham, Robert, junior, of Sporle, laborer 7
3893249 1987973 1987973 defendant Bartram John laborer 593814 593814 Bartram, John, of Sporle, laborer 8
3893250 1987973 1987973 defendant Poseley Robert laborer 593814 593814 Poseley, Robert, of Sporle, laborer 9
3907551 1992820 1992820 defendant Sharlyn William husbandman 593814 593814 Sharlyn, William, of Sporle, husbandman 1
3907553 1992821 1992821 defendant Smyth Roger husbandman 593814 593814 Smyth, Roger, of Sporle, husbandman 0
3907554 1992821 1992821 defendant Briges Edward husbandman 593814 593814 Briges, Edward, of Sporle, husbandman 1
3907555 1992821 1992821 defendant Kyrby John husbandman 593814 593814 Kyrby, John, of Sporle, husbandman 2
3907556 1992821 1992821 defendant Cukcoo John husbandman 593814 593814 Cukcoo, John, of Sporle, husbandman 3
3907557 1992821 1992821 defendant Hyll Richard husbandman 593814 593814 Hyll, Richard, of Sporle, husbandman 4
3907558 1992821 1992821 defendant Deye Robert husbandman 593814 593814 Deye, Robert, of Sporle, husbandman 5
3907559 1992821 1992821 defendant Ivego Simon   593814 593814 Ivego, Simon, of Sporle, shepherd 6
3907560 1992821 1992821 defendant Robson John husbandman 593814 593814 Robson, John, of Sporle, husbandman 7
3907561 1992821 1992821 defendant Robson Thomas husbandman 593814 593814 Robson, Thomas, of Sporle, husbandman 8
3907565 1992822 1992822 defendant Feltwell Andrew laborer 593814 593814 Feltwell, Andrew, of Sporle, laborer 2
3907566 1992822 1992822 defendant Casse William laborer 593814 593814 Casse, William, of Sporle, laborer 3
3907569 1992822 1992822 defendant Mendham Robert, senior laborer 593814 593814 Mendham, Robert, senior, of Sporle, laborer 6
3907570 1992822 1992822 defendant Mendham Robert, junior laborer 593814 593814 Mendham, Robert, junior, of Sporle, laborer 7
3907571 1992822 1992822 defendant Bartram John laborer 593814 593814 Bartram, John, of Sporle, laborer 8
3907572 1992822 1992822 defendant Posyley Robert laborer 593814 593814 Posyley, Robert, of Sporle, laborer 9
3912114 1994376 1994376 defendant Pereson Richard laborer 593814 593814 Pereson, Richard, of Sporle, laborer 0
3912115 1994376 1994376 defendant Byrge Edward laborer 593814 593814 Byrge, Edward, of Sporle, laborer 1
3914476 1995182 1995182 defendant Fychett Walter husbandman 593814 593814 Fychett, Walter, of Sporle, husbandman 2
3973845 2015421 2015421 defendant Coo Clement husbandman 593814 593814 Coo, Clement, of Sporle, husbandman 0
4042581 2039814 2039814 defendant Lacye Thomas husbandman 593814 593814 Lacye, Thomas, of Sporle, husbandman 0
4162754 2082531 2082531 defendant Lyther Edmund husbandman 593814 593814 Lyther, Edmund, of Sporle, husbandman 1
4168624 2084511 2084511 defendant Hallman Richard husbandman 593814 593814 Hallman, Richard, of Sporle, husbandman 0
4168626 2084512 2084512 defendant Lacye Thomas husbandman 593814 593814 Lacye, Thomas, of Sporle, husbandman 0
4217633 2101661 2101661 defendant Paynter Robert clerk 593814 593814 Paynter, Robert, of Sporle, clerk 0
4222050 2103203 2103203 defendant Lether Edmund yeoman 593814 593814 Lether, Edmund, of Sporle, yeoman 1
4223609 2103746 2103746 defendant Coo Clement husbandman 593814 593814 Coo, Clement, of Sporle, husbandman 1
4247685 2112206 2112206 defendant Lether Edmund yeoman 593814 593814 Lether, Edmund, of Sporle, yeoman 1
4259508 2116157 2116157 defendant Lyther Edmund yeoman 593814 593814 Lyther, Edmund, of Sporle, yeoman 0
4259512 2116158 2116158 defendant Lether or Leather Edmund   593814 593814 Lether or Leather, Edmund, of Sporle yeoman 2
4267238 2118682 2118682 defendant Barwicke William yeoman 593814 593814 Barwicke, William, of Sporle, yeoman 1
4297067 2129050 2129050 defendant Lether Edmund yeoman 593814 593814 Lether, Edmund, of Sporle, yeoman 0
4309814 2133587 2133587 defendant Lether Edmund yeoman 593814 593814 Lether, Edmund, of Sporle, yeoman 2
4317914 2136377 2136377 defendant Whiteman Anthony yeoman 593814 593814 Whiteman, Anthony, of Sporle, yeoman 1
4319506 2136936 2136936 defendant Lether Edmund yeoman 593814 593814 Lether, Edmund, of Sporle, yeoman 0
4319507 2136936 2136936 defendant Lether George yeoman 593814 593814 Lether, George, of Sporle, yeoman 1
4321291 2137538 2137538 defendant Lacy Thomas yeoman 593814 593814 Lacy, Thomas, of Sporle, yeoman 0
4328194 2139745 2139745 defendant Clarington John yeoman 593814 593814 Clarington, John, of Sporle, yeoman 3
4331170 2140722 2140722 defendant Poynter Robert clerk 593814 593814 Poynter, Robert, of Sporle, clerk 0
4331171 2140722 2140722 defendant Blade Richard carpenter 593814 593814 Blade, Richard, of Sporle, carpenter 1
4394810 2162850 2162850 defendant Leather Edmund yeoman 593814 593814 Leather, Edmund, of Sporle, yeoman 2
4452495 2185779 2185779 defendant Somour John   593814 593814 Somour, John, of Sporle 1
4501198 2200981 2200981 plaintiff Leekes Thomas   593814 593814 Leekes, Thomas, of Sporle, on his own account 0
4501199 2200981 2200981 defendant Coupere John   593814 593814 Coupere, John, of Sporle 0
4637071 2242398 2242398 defendant Hunte William   593814 593814 Hunte, William, of Sporle 2
4663043 2249906 2249906 defendant Palmere Agnes widow 593814 593814 Palmere, Agnes, of Sporle, widow 0
4666888 2255373 2255373 defendant Lalle Thomas laborer 593814 593814 Lalle, Thomas, of Sporle, laborer 0
4666889 2255373 2255373 defendant Hamond John laborer 593814 593814 Hamond, John, of Sporle, laborer 1
4666891 2255374 2255374 defendant Lalle Thomas laborer 593814 593814 Lalle, Thomas, of Sporle, laborer 0
4666892 2255374 2255374 defendant Hamond John laborer 593814 593814 Hamond, John, of Sporle, laborer 1
4670970 2256589 2256589 defendant Garlek Walter esq 593814 593814 Garlek, Walter, of Sporle, esq 4
4701388 2265836 2265836 defendant Halman John yeoman 593814 593814 Halman, John, of Sporle, yeoman 0
4720924 2271877 2271877 defendant Bedeford Thomas husbandman 593814 593814 Bedeford, Thomas, of Sporle, husbandman 2
4744269 2278847 2278847 defendant Bedeford Thomas husbandman 593814 593814 Bedeford, Thomas, of Sporle, husbandman 2
4744276 2278848 2278848 defendant Colvyle Thomas husbandman 593814 593814 Colvyle, Thomas, of Sporle, husbandman 3
4744277 2278848 2278848 defendant Gyrdens Thomas husbandman 593814 593814 Gyrdens, Thomas, of Sporle, husbandman 4
4744842 2279011 2279011 defendant Bedforde Thomas   593814 593814 Bedforde, Thomas, of Sporle, bailiff 0
4754890 2281909 2281909 defendant Gyrdyn Robert   593814 593814 Gyrdyn, Robert, of Sporle, holy water clerk 0
4758345 2282983 2282983 defendant Bedeford Thomas husbandman 593814 593814 Bedeford, Thomas, of Sporle, husbandman 1
4759780 2283395 2283395 defendant Bedford Thomas   593814 593814 Bedford, Thomas, of Sporle, bailiff 0
4796794 2295148 2295148 defendant Bedford Thomas   593814 593814 Bedford, Thomas, of Sporle, bailiff 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);