names

183 rows where place_id = 601056

✎ 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
3643701 1908455 1908455 plaintiff Dare John merchant 601056 601056 Dare, John, of Lyme Regis, Dorset, merchant 0
3671550 1917085 1917085 defendant Pyne Robert merchant 601056 601056 Pyne, Robert, of Lyme Regis, Dorset, merchant 0
3674669 1918128 1918128 defendant Hamlyn Anne widow 601056 601056 Hamlyn, Anne, of Lyme Regis, Dorset, widow 0
3679282 1919580 1919580 defendant Tynbell William merchant 601056 601056 Tynbell, William, of Lyme Regis, Dorset, merchant 0
3686052 1921797 1921797 defendant Turbold William merchant 601056 601056 Turbold, William, of Lyme Regis, Dorset, merchant 0
3691418 1923475 1923475 defendant Pyne Robert yeoman 601056 601056 Pyne, Robert, of Lyme Regis, Dorset, yeoman 0
3691579 1923524 1923524 defendant Lenard Richard merchant 601056 601056 Lenard, Richard, of Lyme Regis, Dorset, merchant 0
3691584 1923525 1923525 defendant Batyn Thomas merchant 601056 601056 Batyn, Thomas, of Lyme Regis, Dorset, merchant 1
3694386 1924449 1924449 defendant Pyne Robert merchant 601056 601056 Pyne, Robert, of Lyme Regis, Dorset, merchant 0
3697736 1925512 1925512 defendant Chapelyn Robert merchant 601056 601056 Chapelyn, Robert, of Lyme Regis, Dorset, merchant 0
3697958 1925584 1925584 defendant Pyne Robert merchant 601056 601056 Pyne, Robert, of Lyme Regis, Dorset, merchant 0
3698666 1925799 1925799 defendant Pyne Robert merchant 601056 601056 Pyne, Robert, of Lyme Regis, Dorset, merchant 3
3699249 1925978 1925978 defendant Playe John merchant 601056 601056 Playe, John, of Lyme Regis, Dorset, merchant 0
3700583 1926428 1926428 defendant Plee John merchant 601056 601056 Plee, John, of Lyme Regis, Dorset, merchant 0
3701516 1926723 1926723 defendant Parker alias Turner Thomas yeoman 601056 601056 Parker alias Turner, Thomas, of Lyme Regis, Dorset, yeoman 0
3705864 1928117 1928117 defendant Pyn Robert   601056 601056 Pyn, Robert, of Lyme Regis, Dorset 0
3719977 1932518 1932518 defendant Pyn Robert   601056 601056 Pyn, Robert, of Lyme Regis, Dorset 0
3729478 1935467 1935467 defendant Plee John merchant 601056 601056 Plee, John, of Lyme Regis, Dorset, merchant 0
3730433 1935750 1935750 defendant Lymbre John merchant 601056 601056 Lymbre, John, of Lyme Regis, Dorset, merchant 0
3735671 1937391 1937391 defendant Pyn Robert merchant 601056 601056 Pyn, Robert, of Lyme Regis, Dorset, merchant 0
3742384 1939490 1939490 defendant Maryk William weaver 601056 601056 Maryk, William, of Lyme Regis, Dorset, weaver 0
3746401 1940793 1940793 defendant Marshall Robert merchant 601056 601056 Marshall, Robert, of Lyme Regis, Dorset, merchant 0
3749554 1941773 1941773 defendant Pynne Robert merchant 601056 601056 Pynne, Robert, of Lyme Regis, Dorset, merchant 3
3752391 1942670 1942670 defendant Chapleyn Robert   601056 601056 Chapleyn, Robert, of Lyme Regis, Dorset, merchant, administrators of 3
3754440 1943345 1943345 defendant Trensham alias Streynsham John clerk 601056 601056 Trensham alias Streynsham, John, of Lyme Regis, Dorset, clerk 3
3754934 1943492 1943492 defendant Marshall Robert merchant 601056 601056 Marshall, Robert, of Lyme Regis, Dorset, merchant 3
3763667 1946278 1946278 defendant Danyell John, senior merchant 601056 601056 Danyell, John, senior, of Lyme Regis, Dorset, merchant 0
3763933 1946361 1946361 defendant Lymbery John merchant 601056 601056 (Lymbery, John, of Lyme Regis, Dorset, merchant 3
3763975 1946372 1946372 defendant Danyell John, senior merchant 601056 601056 Danyell, John, senior, of Lyme Regis, Dorset, merchant 0
3775794 1950177 1950177 defendant Tudboll William merchant 601056 601056 Tudboll, William, of Lyme Regis, Dorset, merchant 0
3777053 1950569 1950569 defendant Ploye Richard, junior merchant 601056 601056 Ploye, Richard, junior, of Lyme Regis, Dorset, merchant 0
3783245 1952513 1952513 defendant Philipp Robert merchant 601056 601056 Philipp, Robert, of Lyme Regis, Dorset, merchant 1
3783757 1952684 1952684 defendant Plettye Richard merchant 601056 601056 Plettye, Richard, of Lyme Regis, Dorset, merchant 0
3786891 1953700 1953700 defendant Tudboll William yeoman 601056 601056 Tudboll, William, of Lyme Regis, Dorset, yeoman 0
3786898 1953703 1953703 defendant Tudboll William yeoman 601056 601056 Tudboll, William, of Lyme Regis, Dorset, yeoman 0
3786901 1953704 1953704 defendant Webber Richard yeoman 601056 601056 Webber, Richard, of Lyme Regis, Dorset, yeoman 0
3786909 1953707 1953707 defendant Tudboll John merchant 601056 601056 Tudboll, John, of Lyme Regis, Dorset, merchant 0
3789686 1954605 1954605 defendant Wolcote John glover 601056 601056 Wolcote, John, of Lyme Regis, Dorset, glover 0
3795171 1956355 1956355 defendant Pley Richard merchant 601056 601056 Pley, Richard, of Lyme Regis, Dorset, merchant 0
3798658 1957491 1957491 defendant Pley John merchant 601056 601056 Pley, John, of Lyme Regis, Dorset, merchant 0
3800007 1957925 1957925 defendant Pley Richard merchant 601056 601056 Pley, Richard, of Lyme Regis, Dorset, merchant 0
3803166 1958892 1958892 defendant Tudbold William merchant 601056 601056 Tudbold, William, of Lyme Regis, Dorset, merchant 1
3803181 1958897 1958897 defendant Chaplyn Robert   601056 601056 Chaplyn, Robert, of Lyme Regis, Dorset, merchant, administrators of 0
3805822 1959761 1959761 defendant Play John merchant 601056 601056 Play, John, of Lyme Regis, Dorset, merchant 0
3817031 1963238 1963238 defendant Mereke Ralph merchant 601056 601056 Mereke, Ralph, of Lyme Regis, Dorset, merchant 0
3819631 1964018 1964018 defendant Aman Thomas merchant 601056 601056 Aman, Thomas, of Lyme Regis, Dorset, merchant 0
3820613 1964332 1964332 defendant Borough Thomas gent 601056 601056 Borough, Thomas, of Lyme Regis, Dorset, gent 0
3820626 1964335 1964335 defendant Tudbolle John merchant 601056 601056 Tudbolle, John, of Lyme Regis, Dorset, merchant 0
3823926 1965354 1965354 defendant Batyn Thomas merchant 601056 601056 Batyn, Thomas, of Lyme Regis, Dorset, merchant 0
3832582 1968111 1968111 defendant Waddon Robert merchant 601056 601056 (Waddon, Robert, of Lyme Regis, Dorset, merchant 1
3832587 1968113 1968113 defendant Ropper Richard merchant 601056 601056 Ropper, Richard, of Lyme Regis, Dorset, merchant 0
3832589 1968114 1968114 defendant Pley Richard merchant 601056 601056 Pley, Richard, of Lyme Regis, Dorset, merchant 0
3837897 1969767 1969767 defendant Philippes Robert merchant 601056 601056 Philippes, Robert, of Lyme Regis, Dorset, merchant 0
3843796 1971596 1971596 defendant Pley Richard merchant 601056 601056 Pley, Richard, of Lyme Regis, Dorset, merchant 0
3854034 1974897 1974897 defendant Elsdon alias Raff Thomas merchant 601056 601056 Elsdon alias Raff, Thomas, of Lyme Regis, Dorset, merchant 0
3855431 1975340 1975340 defendant Meryk Ralph yeoman 601056 601056 Meryk, Ralph, of Lyme Regis, Dorset, yeoman 0
3855434 1975341 1975341 defendant Meryk Ralph yeoman 601056 601056 Meryk, Ralph, of Lyme Regis, Dorset, yeoman 0
3855437 1975342 1975342 defendant Meryk Ralph yeoman 601056 601056 Meryk, Ralph, of Lyme Regis, Dorset, yeoman 0
3855440 1975343 1975343 defendant Meryk Ralph yeoman 601056 601056 Meryk, Ralph, of Lyme Regis, Dorset, yeoman 0
3863457 1977971 1977971 defendant Waddon Robert merchant 601056 601056 Waddon, Robert, of Lyme Regis, Dorset, merchant 0
3864376 1978281 1978281 defendant Waddon Robert merchant 601056 601056 (Waddon, Robert, of Lyme Regis, Dorset, merchant 1
3878102 1982923 1982923 defendant Webber Richard husbandman 601056 601056 Webber, Richard, of Lyme Regis, Dorset, husbandman 0
3881486 1984072 1984072 defendant Elsedon alias Raffe Thomas yeoman 601056 601056 Elsedon alias Raffe, Thomas, of Lyme Regis, Dorset, yeoman 1
3993753 2022518 2022518 defendant Washington Thomas clerk 601056 601056 Washington, Thomas, of Lyme Regis, Dorset, clerk 0
3993757 2022519 2022519 defendant Wasshington Thomas clerk 601056 601056 Wasshington, Thomas, of Lyme Regis, Dorset, clerk 0
4003004 2025837 2025837 plaintiff Holcomb alias Holton John merchant 601056 601056 Holcomb alias Holton, John, of Lyme Regis, Dorset, merchant 0
4003018 2025843 2025843 plaintiff Holcomb John   601056 601056 Holcomb, John, of Lyme Regis, Dorset 0
4003024 2025845 2025845 plaintiff Holcombe John merchant 601056 601056 Holcombe, John, of Lyme Regis, Dorset, merchant 0
4007642 2027518 2027518 defendant Edger John yeoman 601056 601056 Edger, John, of Lyme Regis, Dorset, yeoman 0
4008369 2027758 2027758 defendant Barrett Anthony merchant 601056 601056 Barrett, Anthony, of Lyme Regis, Dorset, merchant 0
4015992 2030412 2030412 plaintiff Spyrynge William merchant 601056 601056 Spyrynge, William, of Lyme Regis, Dorset, merchant 0
4015994 2030413 2030413 plaintiff Spyrynge William merchant 601056 601056 Spyrynge, William, of Lyme Regis, Dorset, merchant 0
4017189 2030852 2030852 defendant Morice John   601056 601056 Morice, John, of Lyme Regis, Dorset, merchsnt 0
4017191 2030853 2030853 defendant Moryce John merchant 601056 601056 Moryce, John, of Lyme Regis, Dorset, merchant 0
4023381 2033073 2033073 plaintiff Barret Richard merchant 601056 601056 Barret, Richard, of Lyme Regis, Dorset, merchant 0
4024425 2033414 2033414 defendant Chapman alias Hayne Silvester merchant 601056 601056 Chapman alias Hayne, Silvester, of Lyme Regis, Dorset, merchant 0
4033574 2036660 2036660 defendant Moxaye alias Tanner William yeoman 601056 601056 Moxaye alias Tanner, William, of Lyme Regis, Dorset, yeoman 2
4033579 2036661 2036661 defendant Moxaye alias Tanner Wiklliam yeoman 601056 601056 Moxaye alias Tanner, Wiklliam, of Lyme Regis, Dorset, yeoman 2
4034916 2037163 2037163 plaintiff Hayne Silvester merchant 601056 601056 Hayne, Silvester, of Lyme Regis, Dorset, merchant 0
4034918 2037164 2037164 plaintiff Hayne Silvester merchant 601056 601056 Hayne, Silvester, of Lyme Regis, Dorset, merchant 0
4034920 2037165 2037165 plaintiff Hayne Silvester merchant 601056 601056 Hayne, Silvester, of Lyme Regis, Dorset, merchant 0
4035789 2037473 2037473 plaintiff Hoper Christian   601056 601056 Christian his wife, formerly Christian Whyte, of Lyme Regis, Dorset 1
4040462 2039082 2039082 defendant Barrett Anthony merchant 601056 601056 Barrett, Anthony, of Lyme Regis, Dorset, merchant 0
4041975 2039618 2039618 defendant Wasshington Thomas clerk 601056 601056 Wasshington, Thomas, of Lyme Regis, Dorset, clerk 0
4041978 2039619 2039619 defendant Wasshington Thomas yeoman 601056 601056 Wasshington, Thomas, of Lyme Regis, Dorset, yeoman 0
4055331 2044305 2044305 defendant Barret Richard merchant 601056 601056 Barret, Richard, of Lyme Regis, Dorset, merchant 0
4056974 2044876 2044876 defendant Harvye Robert yeoman 601056 601056 Harvye, Robert, of Lyme Regis, Dorset, yeoman 0
4063621 2047277 2047277 defendant Merrycke Thomas yeoman 601056 601056 Merrycke, Thomas, of Lyme Regis, Dorset, yeoman 0
4068004 2048864 2048864 plaintiff Jorden John merchant 601056 601056 Jorden, John, of Lyme Regis, Dorset, merchant 0
4071905 2050251 2050251 defendant Bonner Anne widow 601056 601056 Bonner, Anne, of Lyme regis, Dorset, widow 1
4080357 2053288 2053288 defendant Barrett Richard merchant 601056 601056 Barrett, Richard, of Lyme Regis, Dorset, merchant 0
4080361 2053290 2053290 defendant Elesdon William gent 601056 601056 Elesdon, William, of Lyme Regis, Dorset, gent 0
4086647 2055513 2055513 defendant Barett Richard merchant 601056 601056 Barett, Richard, of Lyme Regis, Dorset, merchant 0
4089594 2056568 2056568 defendant Heywood Philip vintner 601056 601056 Heywood, Philip, of Lyme Regis, Dorset, yeoman, vintner 0
4108137 2063182 2063182 defendant Harvye Robert gent 601056 601056 Harvye, Robert, of Lyme Regis, Dorset, gent 0
4112220 2064628 2064628 defendant Barrett Richard merchant 601056 601056 Barrett, Richard, of Lyme Regis, Dorset, merchant 0
4112222 2064629 2064629 defendant Barrett Richard merchant 601056 601056 Barrett, Richard, of Lyme Regis, Dorset, merchant 0
4112790 2064838 2064838 defendant Barrett Richard merchant 601056 601056 Barrett, Richard, of Lyme Regis, Dorset, merchant 0
4114864 2065602 2065602 defendant Barrett Richard merchant 601056 601056 Barrett, Richard, of Lyme Regis, Dorset, merchant 0
4114866 2065603 2065603 defendant Barrett Richard merchant 601056 601056 Barrett, Richard, of Lyme Regis, Dorset, merchant 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);