names

154 rows where place_id = 588633

✎ 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
3595112 1866102 1866102 defendant Tyneham John merchant 588633 588633 Tyneham, John, of Lyme Regis, merchant 0
3598857 1867267 1867267 defendant Bysshop John merchant 588633 588633 Bysshop, John, of Lyme Regis, merchant 0
3607806 1870093 1870093 defendant Trensham John clerk 588633 588633 Trensham, John, of Lyme Regis, clerk 0
3610168 1870844 1870844 defendant Borough John merchant 588633 588633 Borough, John, of Lyme Regis, merchant 0
3610171 1870845 1870845 defendant Borough John merchant 588633 588633 Borough, John, of Lyme Regis, merchant 0
3610172 1870845 1870845 defendant Dare John merchant 588633 588633 Dare, John, of Lyme Regis, merchant 1
3610173 1870845 1870845 defendant Waren John carpenter 588633 588633 Waren, John, of Lyme Regis, carpenter 2
3610476 1870938 1870938 defendant Rapys John yeoman 588633 588633 Rapys, John, of Lyme Regis, yeoman 0
3610478 1870939 1870939 defendant Rapys John yeoman 588633 588633 Rapys, John, of Lyme Regis, yeoman 0
3611483 1871265 1871265 defendant Foweshon John merchant 588633 588633 Foweshon, John, of Lyme Regis, merchant 0
3612382 1871502 1871502 defendant Tyneham John merchant 588633 588633 Tyneham, John, of Lyme Regis, merchant 0
3612383 1871502 1871502 defendant Aysshe Thomas merchant 588633 588633 Aysshe, Thomas, of Lyme Regis, merchant 1
3612384 1871502 1871502 defendant Tyneham William mariner 588633 588633 Tyneham, William, of Lyme Regis, mariner 2
3612385 1871502 1871502 defendant Tyneham Richard mariner 588633 588633 Tyneham, Richard, of Lyme Regis, mariner 3
3612386 1871502 1871502 defendant Symond William laborer 588633 588633 Symond, William, of Lyme Regis, laborer 4
3612387 1871502 1871502 defendant Crosse Alexander tucker 588633 588633 Crosse, Alexander, of Lyme Regis, tucker 5
3612388 1871502 1871502 defendant Fosshen John barber 588633 588633 Fosshen, John, of Lyme Regis, barber 6
3612733 1871629 1871629 defendant Burgh John merchant 588633 588633 Burgh, John, of Lyme regis, merchant 0
3642047 1907963 1907963 plaintiff Burgh John gent 588633 588633 Burgh, John, of Lyme Regis, gent 0
3653661 1911409 1911409 defendant Marshall Robert merchant 588633 588633 Marshall, Robert, of Lyme Regis, merchant 0
3663901 1914651 1914651 defendant Pley Richard merchant 588633 588633 Pley, Richard, of Lyme Regis, merchant 1
3673833 1917847 1917847 defendant Pyne Robert merchant 588633 588633 Pyne, Robert, of Lyme Regis, merchant 0
3674670 1918128 1918128 defendant Todboll John yeoman 588633 588633 Todboll, John, of Lyme Regis, yeoman 1
3675479 1918369 1918369 defendant Pyne Robert merchant 588633 588633 Pyne, Robert, of Lyme Regis, merchant 0
3678599 1919364 1919364 defendant Chapelyn Robert merchant 588633 588633 Chapelyn, Robert, of Lyme Regis, merchant 0
3695120 1924691 1924691 defendant Davy Richard mariner 588633 588633 Davy, Richard, of Lyme Regis, mariner 0
3700584 1926428 1926428 defendant Hockytt John merchant 588633 588633 Hockytt, John, of Lyme Regis, merchant 1
3723679 1933682 1933682 defendant Dare William merchant 588633 588633 Dare, William, of Lyme Regis, merchant 0
3724105 1933822 1933822 defendant Chaplyn Robert (legal representative) 588633 588633 Chaplyn, Robert, of Lyme Regis, merchant, executrix of 2
3730434 1935750 1935750 defendant Tudboll William merchant 588633 588633 Tudboll, William, of Lyme Regis, merchant 1
3731417 1936049 1936049 defendant Philipp Thomas merchant 588633 588633 Philipp, Thomas, of Lyme Regis, merchant 0
3731418 1936049 1936049 defendant Raffe Thomas merchant 588633 588633 Raffe, Thomas, of Lyme Regis, merchant 1
3735667 1937390 1937390 defendant Lenard Richard merchant 588633 588633 Lenard, Richard, of Lyme Regis, merchant 0
3739816 1938668 1938668 defendant Elsdon Thomas merchant 588633 588633 Elsdon, Thomas, of Lyme Regis, merchant 0
3741794 1939297 1939297 defendant Holcombe William merchant 588633 588633 Holcombe, William, of Lyme Regis, merchant 0
3741795 1939297 1939297 defendant Pyne Robert merchant 588633 588633 Pyne, Robert, of Lyme Regis, merchant 1
3742385 1939490 1939490 defendant Orchard Henry weaver 588633 588633 Orchard, Henry, of Lyme Regis, weaver 1
3742386 1939490 1939490 defendant Play John merchant 588633 588633 Play, John, of Lyme Regis, merchant 2
3752400 1942673 1942673 plaintiff Pyne Robert (legal representative) 588633 588633 Pyne, Robert, of Lyme Regis, administrator of 0
3752402 1942673 1942673 defendant Skorche William merchant 588633 588633 Skorche, William, of Lyme Regis, merchant 0
3769109 1947993 1947993 defendant Chaplyn Robert (legal representative) 588633 588633 Chaplyn, Robert, of Lyme Regis, merchant, executors of 0
3782038 1952133 1952133 defendant Pleye Richard merchant 588633 588633 Pleye, Richard, of Lyme Regis, merchant 0
3783758 1952684 1952684 defendant Tutbold John merchant 588633 588633 Tutbold, John, of Lyme Regis, merchant 1
3786893 1953701 1953701 defendant Webber Richard yeoman 588633 588633 Webber, Richard, of Lyme Regis, yeoman 0
3789687 1954605 1954605 defendant Play John   588633 588633 Play, John, of Lyme Regis, groom 1
3794836 1956256 1956256 defendant Pley Richard merchant 588633 588633 Pley, Richard, of Lyme Regis, merchant 1
3795009 1956303 1956303 defendant Tudboll William merchant 588633 588633 Tudboll, William, of Lyme Regis, merchant 0
3800010 1957926 1957926 defendant Pley Richard merchant 588633 588633 Pley, Richard, of Lyme Regis, merchant 0
3803179 1958897 1958897 plaintiff Pyne Robert (legal representative) 588633 588633 Pyne, Robert, of Lyme Regis, merchant, administrator of 0
3812277 1961735 1961735 defendant Phylypps Robert merchant 588633 588633 Phylypps, Robert, of Lyme Regis, merchant 0
3814103 1962313 1962313 defendant Burrowe Thomas gent 588633 588633 Burrowe, Thomas, of Lyme Regis, gent 0
3837017 1969489 1969489 defendant Elsdon alias Raffe Thomas merchant 588633 588633 Elsdon alias Raffe, Thomas, of Lyme Regis, merchant 0
3837898 1969767 1969767 defendant Ellesdone Thomas merchant 588633 588633 Ellesdone, Thomas, of Lyme Regis, merchant 1
3845369 1972112 1972112 defendant Harrys William yeoman 588633 588633 Harrys, William, of Lyme Regis, yeoman 0
3854035 1974897 1974897 defendant at Mille Gregory tucker 588633 588633 at Mille, Gregory, of Lyme Regis, tucker 1
3858473 1976311 1976311 defendant Harrys William husbandman 588633 588633 Harrys, William, of Lyme Regis, husbandman 0
3883393 1984712 1984712 defendant Dennyng John husbandman 588633 588633 Dennyng, John, of Lyme Regis, husbandman 0
3925607 1998876 1998876 defendant Stamysby Gregory weaver 588633 588633 Stamysby, Gregory, of Lyme Regis, weaver 2
3948680 2006601 2006601 defendant Davye Robert   588633 588633 Davye, Robert, of Lyme Regis, ship master 0
3971299 2014519 2014519 defendant Garland John merchant 588633 588633 Garland, John, of Lyme Regis, merchant 0
3980639 2017842 2017842 defendant Durston Alexander merchant 588633 588633 Durston, Alexander, of Lyme Regis, merchant 0
3993754 2022518 2022518 defendant Morrys John merchant 588633 588633 Morrys, John, of Lyme Regis, merchant 1
3993755 2022518 2022518 defendant Barrett Anthony merchant 588633 588633 Barrett, Anthony, of Lyme Regis, merchant 2
3993758 2022519 2022519 defendant Holcombe John merchant 588633 588633 Holcombe, John, of Lyme Regis, merchant 1
3993759 2022519 2022519 defendant Hoper George merchant 588633 588633 Hoper, George, of Lyme Regis, merchant 2
4003020 2025843 2025843 defendant Cranley Robert mariner 588633 588633 Cranley, Robert, of Lyme Regis, mariner 1
4003021 2025844 2025844 plaintiff Holcomb John merchant 588633 588633 Holcomb, John, of Lyme Regis, merchant 0
4003303 2025940 2025940 plaintiff Hoper George merchant 588633 588633 Hoper, George, of Lyme Regis, merchant 0
4003306 2025941 2025941 plaintiff Hoper Christian   588633 588633 Christian his wife, formerly Christian Whit, of Lyme Regis 1
4009010 2027987 2027987 defendant Whetcome Nicholas merchant 588633 588633 Whetcome, Nicholas, of Lyme Regis, merchant 0
4029563 2035210 2035210 plaintiff Davige Richard merchant 588633 588633 Davige, Richard, of Lyme Regis, merchant 0
4034922 2037166 2037166 plaintiff Hayne Silvester merchant 588633 588633 Hayne, Silvester, of Lyme Regis, merchant 0
4034924 2037167 2037167 plaintiff Hayne Silvester merchant 588633 588633 Hayne, Silvester, of Lyme Regis, merchant 0
4041976 2039618 2039618 defendant Davye Robert yeoman 588633 588633 Davye, Robert, of Lyme Regis, yeoman 1
4041979 2039619 2039619 defendant Dyvye or Davie Robert yeoman 588633 588633 Dyvye or Davie, Robert, of Lyme Regis, yeoman 1
4059103 2045653 2045653 defendant Garrys John merchant 588633 588633 Garrys, John, of Lyme Regis, merchant 0
4063860 2047358 2047358 defendant Harvye Robert yeoman 588633 588633 Harvye, Robert, of Lyme Regis, yeoman 2
4065484 2047946 2047946 plaintiff Hayne Silvester merchant 588633 588633 Hayne, Silvester, of Lyme Regis, merchant 0
4095685 2058787 2058787 defendant Harvye Robert yeoman 588633 588633 Harvye, Robert, of Lyme Regis, yeoman 0
4132664 2072003 2072003 defendant Barrett Richard merchant 588633 588633 Barrett, Richard, of Lyme Regis, merchant 0
4141063 2075033 2075033 defendant Durston Alexander merchant 588633 588633 Durston, Alexander, of Lyme Regis, merchant 0
4158271 2080965 2080965 defendant Ellesdon William gent 588633 588633 Ellesdon, William, of Lyme Regis, gent 0
4160985 2081915 2081915 defendant Elsam Lawrence merchant 588633 588633 Elsam, Lawrence, of Lyme Regis, merchant 1
4163434 2082735 2082735 defendant Cogan John smith 588633 588633 Cogan, John, of Lyme Regis, smith 2
4168922 2084623 2084623 defendant Davye Richard merchant 588633 588633 Davye, Richard, of Lyme Regis, merchant 0
4181011 2088835 2088835 defendant Hassard Nicholas merchant 588633 588633 Hassard, Nicholas, of Lyme Regis, merchant 0
4184391 2090042 2090042 defendant Durston Alexander merchant 588633 588633 Durston, Alexander, of Lyme Regis, merchant 0
4188186 2091371 2091371 defendant Larstocke Richard gent 588633 588633 Larstocke, Richard, of Lyme Regis, gent 1
4188187 2091371 2091371 defendant Larstocke William gent 588633 588633 Larstocke, William, of Lyme Regis, gent 2
4191827 2092698 2092698 defendant Crandeley John tucker 588633 588633 Crandeley, John, of Lyme Regis, tucker 0
4191828 2092698 2092698 defendant Moone Anthony merchant 588633 588633 Moone Anthony, of Lyme Regis, merchant 1
4191917 2092733 2092733 defendant Crandley John fuller 588633 588633 Crandley, John, of Lyme Regis, fuller 2
4200105 2095589 2095589 defendant Hayne Silvester merchant 588633 588633 Hayne, Silvester, of Lyme Regis, merchant 0
4211572 2099598 2099598 defendant Larstock Richard gent 588633 588633 Larstock, Richard, of Lyme Regis, gent 1
4211573 2099598 2099598 defendant Larstock William gent 588633 588633 Larstock, William, of Lyme Regis, gent 2
4212340 2099862 2099862 defendant Golluppe alias Bucher Robert victualer 588633 588633 Golluppe alias Bucher, Robert, of Lyme Regis, victualer 2
4226078 2104592 2104592 defendant Bedford Richard   588633 588633 Bedford, Richard, of Lyme Regis, yeoman, captain and owner of bark called the Revenge of Lyme 1
4228513 2105456 2105456 defendant Moone Anthony yeoman 588633 588633 Moone, Anthony, of Lyme Regis, yeoman 0
4236775 2108438 2108438 defendant Laverstocke or Leystocke Richard gent 588633 588633 Laverstocke or Leystocke, Richard, of Lyme Regis, gent 2
4236990 2108517 2108517 defendant Moone Anthony yeoman 588633 588633 Moone, Anthony, of Lyme Regis, yeoman 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);