names

117 rows where place_id = 591118

✎ 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
3603394 1868733 1868733 defendant Stonewall John husbandman 591118 591118 Stonewall, John, of Longdon, husbandman 0
3614687 1872246 1872246 defendant Grene John husbandman 591118 591118 Grene, John, of Longdon, husbandman 0
3622147 1874462 1874462 defendant Bodeliche Thomas chaplain 591118 591118 Bodeliche, Thomas, of Longdon, chaplain 0
3622148 1874462 1874462 defendant Hater William laborer 591118 591118 Hater, William, of Longdon, laborer 1
3622149 1874462 1874462 defendant Chapleyn John husbandman 591118 591118 Chapleyn, John, of Longdon, husbandman 2
3634120 1905469 1905469 defendant Lynacres William husbandman 591118 591118 Lynacres, William, of Longdon, husbandman 0
3634122 1905470 1905470 defendant Lynacres William husbandman 591118 591118 Lynacres, William, of Longdon, husbandman 0
3634123 1905470 1905470 defendant Hille Thomas husbandman 591118 591118 Hille, Thomas, of Longdon, husbandman 1
3640673 1907524 1907524 defendant Ruggeley Richard (legal representative) 591118 591118 Ruggeley, Richard, of Longdon, gent, executors of 0
3640674 1907524 1907524 defendant Ruggeley Anne widow 591118 591118 (Ruggeley, Anne, of Longdon, widow 1
3640675 1907524 1907524 defendant Ruggeley Humphrey gent 591118 591118 Ruggeley, Humphrey, of Longdon, gent 2
3650165 1910421 1910421 defendant Stonewall William yeoman 591118 591118 Stonewall, William, of Longdon, yeoman 0
3650167 1910422 1910422 defendant Stonewall William yeoman 591118 591118 Stonewall, William, of Longdon, yeoman 0
3652219 1911036 1911036 defendant Rugeley Humphrey gent 591118 591118 Rugeley, Humphrey, of Longdon, gent 0
3652220 1911036 1911036 defendant Edyall Richard husbandman 591118 591118 Edyall, Richard, of Longdon, husbandman 1
3652221 1911036 1911036 defendant Pateman Hugh yeoman 591118 591118 Pateman, Hugh, of Longdon, yeoman 2
3652222 1911036 1911036 defendant Hiedogge Richard miller 591118 591118 Hiedogge, Richard, of Longdon, miller 3
3652225 1911037 1911037 defendant Ediall Richard husbandman 591118 591118 Ediall, Richard, of Longdon, husbandman 1
3652226 1911037 1911037 defendant Pateman Hugh yeoman 591118 591118 Pateman, Hugh, of Longdon, yeoman 2
3652227 1911037 1911037 defendant Hyedogge Richard miller 591118 591118 Hyedogge, Richard, of Longdon, miller 3
3678747 1919420 1919420 plaintiff Norres William   591118 591118 Norres, William, of Longdon 0
3678748 1919420 1919420 defendant Rugeley Humphrey gent 591118 591118 Rugeley, Humphrey, of Longdon, gent 0
3678749 1919421 1919421 plaintiff Norres William   591118 591118 Norres, William, of Longdon 0
3686858 1922051 1922051 defendant Colett Hugh   591118 591118 Colett, Hugh, of Longdon 0
3697870 1925554 1925554 defendant Toney William husbandman 591118 591118 Toney, William, of Longdon, husbandman 2
3702917 1927182 1927182 defendant Wrenford John yeoman 591118 591118 Wrenford, John, of Longdon, yeoman 8
3715647 1931182 1931182 defendant Collett Hugh husbandman 591118 591118 Collett, Hugh, of Longdon, husbandman 0
3715649 1931183 1931183 defendant Collett Hugh husbandman 591118 591118 Collett, Hugh, of Longdon, husbandman 0
3725144 1934154 1934154 defendant Alkyn John yeoman 591118 591118 Alkyn, John, of Longdon, yeoman 5
3747892 1941264 1941264 defendant Flecher William husbandman 591118 591118 Flecher, William, of Longdon, husbandman 3
3775756 1950168 1950168 defendant Alkyns John yeoman 591118 591118 Alkyns, John, of Longdon, yeoman 2
3800789 1958160 1958160 defendant Wyllyams William chaplain 591118 591118 Wyllyams, William, of Longdon, chaplain 0
3800791 1958160 1958160 defendant Stokes George laborer 591118 591118 Stokes, George, of Longdon, laborer 2
3816717 1963134 1963134 defendant Luffey Roger husbandman 591118 591118 Luffey, Roger, of Longdon, husbandman 0
3819390 1963948 1963948 defendant Dudley Hugh husbandman 591118 591118 Dudley, Hugh, of Longdon, husbandman 0
3819391 1963948 1963948 defendant Bromlewe John husbandman 591118 591118 Bromlewe, John, of Longdon, husbandman 1
3819392 1963948 1963948 defendant Howlo John husbandman 591118 591118 Howlo, John, of Longdon, husbandman 2
3854092 1974915 1974915 defendant Ilseley Humphrey yeoman 591118 591118 Ilseley, Humphrey, of Longdon, yeoman 0
3854093 1974915 1974915 defendant Lynakers William husbandman 591118 591118 Lynakers, William, of Longdon, husbandman 1
3870823 1980492 1980492 defendant Lynakers William husbandman 591118 591118 Lynakers, William, of Longdon, husbandman 0
3891323 1987365 1987365 defendant Wylkyns Nicholas tailor 591118 591118 Wylkyns, Nicholas, of Longdon, tailor 0
3891324 1987365 1987365 defendant Gorney Thomas clerk 591118 591118 Gorney, Thomas, of Longdon, clerk 1
3891325 1987365 1987365 defendant Mychell William husbandman 591118 591118 Mychell, William, of Longdon, husbandman 2
3893782 1988139 1988139 plaintiff Poumfret Thomas   591118 591118 Poumfret, Thomas, of Longdon 0
3906145 1992346 1992346 defendant Lynacrys John yeoman 591118 591118 Lynacrys, John, of Longdon, yeoman 0
3907990 1992964 1992964 plaintiff Powmffrett Thomas   591118 591118 Powmffrett, Thomas, of Longdon 0
3910752 1993915 1993915 defendant Alen Roger yeoman 591118 591118 Alen, Roger, of Longdon, yeoman 0
3923700 1998237 1998237 defendant Alen Roger yeoman 591118 591118 Alen, Roger, of Longdon, yeoman 2
3931755 2000923 2000923 defendant Walton Thomas husandman 591118 591118 Walton, Thomas, of Longdon, husandman 0
3931756 2000923 2000923 defendant Marshall Humphrey husandman 591118 591118 Marshall, Humphrey, of Longdon, husandman 1
3952881 2008081 2008081 defendant Lytlehale William laborer 591118 591118 Lytlehale, William, of Longdon, laborer 1
3952883 2008081 2008081 defendant Higgons Richard laborer 591118 591118 Higgons, Richard, of Longdon, laborer 3
3952884 2008081 2008081 defendant Mauncell Richard husbandman 591118 591118 Mauncell, Richard, of Longdon, husbandman 4
3952885 2008081 2008081 defendant Lytlehale Richard husbandman 591118 591118 Lytlehale, Richard, of Longdon, husbandman 5
3952888 2008081 2008081 defendant Modlycott John husbandman 591118 591118 Modlycott, John, of Longdon, husbandman 8
3959397 2010370 2010370 defendant Butler Edward laborer 591118 591118 Butler, Edward, of Longdon, laborer 0
3959398 2010370 2010370 defendant Butler John husbandman 591118 591118 Butler, John, of Longdon, husbandman 1
3987770 2020375 2020375 defendant Walker Richard carpenter 591118 591118 Walker, Richard, of Longdon, carpenter 0
3987771 2020375 2020375 defendant Walker Thomas carpenter 591118 591118 Walker, Thomas, of Longdon, carpenter 1
3987778 2020376 2020376 defendant Walker Richard carpenter 591118 591118 Walker, Richard, of Longdon, carpenter 0
3987779 2020376 2020376 defendant Walker Thomas carpenter 591118 591118 Walker, Thomas, of Longdon, carpenter 1
4063619 2047276 2047276 defendant Wollaston Thomas tailor 591118 591118 Wollaston, Thomas, of Longdon, tailor 2
4117366 2066511 2066511 defendant Smyth Thomas yeoman 591118 591118 Smyth, Thomas, of Longdon, yeoman 0
4117367 2066511 2066511 defendant James Roger yeoman 591118 591118 James, Roger, of Longdon, yeoman 1
4118222 2066804 2066804 defendant Tony Henry yeoman 591118 591118 Tony, Henry, of Longdon, yeoman 0
4119623 2067305 2067305 defendant Arblaster Margery widow 591118 591118 Arblaster, Margery, of Longdon, widow 0
4142681 2075608 2075608 defendant Arblaster Margery widow 591118 591118 Arblaster, Margery, of Longdon, widow 0
4155579 2080033 2080033 defendant Adams Thomas esq 591118 591118 Adams, Thomas, of Longdon, esq 1
4191057 2092436 2092436 defendant Arblaster Margery widow 591118 591118 Arblaster, Margery, of Longdon, widow 0
4221300 2102948 2102948 defendant Adams Thomas, senior gent 591118 591118 Adams, Thomas, senior, of Longdon, gent 0
4221301 2102948 2102948 defendant Adams Francis gent 591118 591118 Adams, Francis, of Longdon, gent 1
4228401 2105415 2105415 defendant Barwyck William (legal representative) 591118 591118 Barwyck, William, of Longdon, husbandman, executors of 0
4228403 2105415 2105415 defendant Barwyck Roland gent 591118 591118 Barwyck, Roland, of Longdon, gent 2
4232902 2107015 2107015 defendant Bullocke Nicholas yeoman 591118 591118 Bullocke, Nicholas, of Longdon, yeoman 0
4245515 2111475 2111475 defendant Barwyck William (legal representative) 591118 591118 Barwyck, William, of Longdon, Salop husbandman, executors of 0
4245517 2111475 2111475 defendant Barwyck Roland gent 591118 591118 Barwyck, Roland, of Longdon, gent 2
4248726 2112559 2112559 defendant Pytt William husbandman 591118 591118 Pytt, William, of Longdon, husbandman 0
4296036 2128682 2128682 defendant Tailor Richard yeoman 591118 591118 Tailor, Richard, of Longdon, yeoman 2
4328868 2139968 2139968 defendant Hall Hugh carpenter 591118 591118 Hall, Hugh, of Longdon, carpenter 0
4328870 2139969 2139969 defendant Hall Hugh husbandman 591118 591118 Hall, Hugh, of Longdon, husbandman 0
4329214 2140083 2140083 defendant Gurney William yeoman 591118 591118 Gurney, William, of Longdon, yeoman 1
4330913 2140639 2140639 defendant Addie Thomas sawyer 591118 591118 Addie, Thomas, of Longdon, sawyer 0
4388450 2160775 2160775 defendant Kemble Charles husbandman 591118 591118 Kemble, Charles, of Longdon, husbandman 0
4772582 2287394 2287394 defendant Broghton William laborer 591118 591118 Broghton, William, of Longdon, laborer 0
4844845 2309912 2309912 defendant Halsey John   591118 591118 Halsey, John, of Longdon, husbandman, son of Geoffrey 3
4910304 2329740 2329740 defendant Gonny John husbandman 591118 591118 Gonny, John, of Longdon, husbandman 0
4954511 2343313 2343313 defendant Botteler Thomas yeoman 591118 591118 Botteler, Thomas, of Longdon, yeoman 5
4960352 2345065 2345065 defendant Halsey John husbandman 591118 591118 Halsey, John, of Longdon, husbandman 4
5045833 2370387 2370387 defendant Okey William husbandman 591118 591118 Okey, William, of Longdon, husbandman 4
5092292 2384125 2384125 defendant Horsmon Thomas husbandman 591118 591118 Horsmon, Thomas, of Longdon, husbandman 3
5120447 2392407 2392407 defendant Ruggeley William gent 591118 591118 Ruggeley, William, of Longdon, gent 0
5140140 2398216 2398216 defendant Saunders John   591118 591118 Saunders, John, of Longdon 0
5161199 2404375 2404375 defendant Saundres John chaplain 591118 591118 Saundres, John, of Longdon, chaplain 0
5175663 2408568 2408568 defendant Saundres John chaplain 591118 591118 Saundres, John, of Longdon, chaplain 0
5175669 2408569 2408569 defendant Saundres John chaplain 591118 591118 Saundres, John, of Longdon, chaplain 0
5175675 2408570 2408570 defendant Saundres John chaplain 591118 591118 Saundres, John, of Longdon, chaplain 0
5248899 2429800 2429800 defendant Estynton William gent 591118 591118 Estynton, William, of Longdon, gent 0
5248900 2429800 2429800 defendant Okey Richard yeoman 591118 591118 Okey, Richard, of Longdon, yeoman 1
5291355 2442475 2442475 defendant Ruggeley Richard gent 591118 591118 Ruggeley, Richard, of Longdon, gent 0
5342188 2457748 2457748 defendant Richardson Robert husbandman 591118 591118 Richardson, Robert, of Longdon, husbandman 1

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