names

59 rows where place_id = 602118

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607395 1869974 1869974 defendant Treyar John husbandman 602118 602118 Treyar, John, of St Colombe the Nether, husbandman 2
3627052 1903322 1903322 defendant Retallek John cordwainer 602118 602118 Retallek, John, of St Colombe le Over, cordwainer 0
3627053 1903322 1903322 defendant Peryn John butcher 602118 602118 Peryn, John, of St Colombe le Over, butcher 1
3628406 1903750 1903750 defendant Michell John yeoman 602118 602118 Michell, John, of St Colombe le Over, yeoman 0
3634839 1905696 1905696 defendant Pomerey John, junior husbandman 602118 602118 Pomerey, John, junior, of St Colombe le Nether, husbandman 1
3636718 1906277 1906277 defendant Luke John laborer 602118 602118 Luke, John, of St Colombe le Over, laborer 0
3636729 1906280 1906280 defendant Perys Thomas laborer 602118 602118 Perys, Thomas, of St Colombe le Over, laborer 0
3648474 1909921 1909921 defendant Robyn Mark yeoman 602118 602118 Robyn, Mark, of St Colombe the Over, yeoman 1
3675226 1918287 1918287 defendant Ganergan John gent 602118 602118 Ganergan, John, of St Colombe the Over, gent 0
3675227 1918287 1918287 defendant Watte William yeoman 602118 602118 Watte, William, of St Colombe the Over, yeoman 1
3675228 1918287 1918287 defendant Tyak Richard yeoman 602118 602118 Tyak, Richard, of St Colombe the Over, yeoman 2
3685943 1921761 1921761 defendant Michell John gent 602118 602118 Michell, John, of St Colombe the Over, gent 0
3702148 1926930 1926930 defendant Teek Richard yeoman 602118 602118 Teek, Richard, of St Colombe the Over, yeoman 1
3729874 1935599 1935599 defendant Pendynne Stephen yeoman 602118 602118 Pendynne, Stephen, of St Colombe the Over, yeoman 0
3729875 1935599 1935599 defendant Pawle John yeoman 602118 602118 Pawle, John, of St Colombe the Over, yeoman 1
3762002 1945762 1945762 defendant Rawe John smith 602118 602118 Rawe, John, of St Colombe the Over, smith 0
3762003 1945762 1945762 defendant Rettorrek Thomas tailor 602118 602118 Rettorrek, Thomas, of St Colombe the Over, tailor 1
3772009 1948937 1948937 defendant Rawe John smith 602118 602118 Rawe, John, of St Colombe the Over, smith 0
3772445 1949070 1949070 defendant Tyak John yeoman 602118 602118 Tyak, John, of St Colombe, yeoman 0
3840630 1970634 1970634 defendant Barre Richard husbandman 602118 602118 Barre, Richard, of St Colombe the Over, husbandman 0
3879479 1983388 1983388 defendant Peren William husbandman 602118 602118 Peren, William, of St Colombe, husbandman 0
3960353 2010717 2010717 defendant John Thomas glover 602118 602118 John, Thomas, of St Colombe the Over, glover 0
3965940 2012706 2012706 defendant Lyndeth Anthony yeoman 602118 602118 Lyndeth, Anthony, of St Colombe the Lower, yeoman 1
4086410 2055419 2055419 defendant Geane Henry husbandman 602118 602118 Geane, Henry, of St Colombe the Over, husbandman 0
4088964 2056353 2056353 defendant Bomthen John gent 602118 602118 Bomthen, John, of St Colombe le Higher, gent 0
4129279 2070770 2070770 defendant Wynter John husbandman 602118 602118 Wynter, John, of St Colombe the Lower, husbandman 0
4129396 2070817 2070817 defendant Lovyes Humphrey gent 602118 602118 Lovyes, Humphrey, of St Colombe, or of Shepwashe, Devon, gent 0
4136073 2073242 2073242 defendant Bridall John   602118 602118 Bridall, John, of St Colombe, or of St Thomas Apostle, Exeter, bell founder 0
4145800 2076684 2076684 defendant John Peter husbandman 602118 602118 John, Peter, of St Colombe, husbandman 1
4152643 2079038 2079038 defendant Wynter John husbandman 602118 602118 Wynter, John, of St Colombe the Lower, husbandman 0
4152817 2079093 2079093 defendant Lovyes or Louyes Humprey gent 602118 602118 Lovyes or Louyes, Humprey, of St Colombe, or of Shepwashe, Devon, gent 0
4158023 2080878 2080878 defendant Hick Nicholas husbandman 602118 602118 Hick, Nicholas, of St Colombe le Lower, husbandman 0
4160309 2081677 2081677 defendant Bridall John bellfounder 602118 602118 Bridall, John, of St Colombe, or of Exeter St Thomas Apostle, bellfounder 0
4180350 2088605 2088605 defendant Lydcott Gregory yeoman 602118 602118 Lydcott, Gregory, of St Colombe, yeoman 1
4180838 2088777 2088777 defendant Dar John husbandman 602118 602118 Dar, John, of St Colombe le Higher, husbandman 0
4188635 2091506 2091506 defendant Moyse Robert yeoman 602118 602118 Moyse, Robert, of St Colombe, yeoman 0
4188636 2091506 2091506 defendant Retallacke Mark yeoman 602118 602118 Retallacke, Mark, of St Colombe, yeoman 1
4190132 2092054 2092054 defendant Bruer Richard husbandman 602118 602118 Bruer, Richard, of St Colombe le Lower, husbandman 0
4212024 2099756 2099756 defendant Moyse Robert yeoman 602118 602118 Moyse, Robert, of St Colombe, yeoman 0
4212025 2099756 2099756 defendant Retallacke Mark yeoman 602118 602118 Retallacke, Mark, of St Colombe, yeoman 1
4243688 2110878 2110878 defendant Merifeilde John gent 602118 602118 Merifeilde, John, of St Colombe, gent 2
4243689 2110878 2110878 defendant Meryfeilde Thomas gent 602118 602118 Meryfeilde, Thomas, of St Colombe, gent 3
4244614 2111183 2111183 defendant Moyle John husbandman 602118 602118 Moyle, John, of St Colombe le Over, husbandman 0
4244615 2111183 2111183 defendant Moyle Baldwin husbandman 602118 602118 Moyle, Baldwin, of St Colombe le Over, husbandman 1
4410243 2168026 2168026 defendant Daye Thomas gent 602118 602118 Daye, Thomas, of St Colombe le Over, gent 0
4410244 2168026 2168026 defendant Myll Thomas yeoman 602118 602118 Myll, Thomas, of St Colombe le Over, yeoman 1
4410247 2168026 2168026 defendant Penrose Joan children and heirs of Roger Flamanke, gent 602118 602118 Joan his wife, children and heirs of Roger Flamanke, of St Colombe le Over, gent 4
4830764 2305649 2305649 defendant Dolle John carpenter 602118 602118 Dolle, John, of St Colombe Over, carpenter 4
5542831 2517878 2517878 defendant Marchaunt Alan chaplain 602118 602118 Marchaunt, Alan, of St Colombe le Nether, chaplain 1
5542832 2517878 2517878 defendant Crugowe John chaplain 602118 602118 Crugowe, John, of St Colombe le Nether, chaplain 2
5548300 2519533 2519533 defendant Treyer John cordwainer 602118 602118 Treyer, John, of St Colombe the Over, cordwainer 0
5548301 2519533 2519533 defendant Nycoll Thomas glover 602118 602118 Nycoll, Thomas, of St Colombe the Over, glover 1
5549222 2519818 2519818 defendant Michell John yeoman 602118 602118 Michell, John, of St Colombe le Over, yeoman 0
5549224 2519819 2519819 defendant Pole John yeoman 602118 602118 Pole, John, of St Colombe the Over, yeoman 0
5556004 2521750 2521750 defendant Michell John gent 602118 602118 Michell, John, of St Colombe the Over, gent 0
5557601 2522179 2522179 defendant Robyn Ralph husbandman 602118 602118 Robyn, Ralph, of St Colombe the Over, husbandman 0
5557602 2522179 2522179 defendant Robyn Mark merchant 602118 602118 Robyn, Mark, of St Colombe the Over, merchant 1
5562534 2523641 2523641 defendant Sporyar Thomas spurrier 602118 602118 Sporyar, Thomas, of St Colombe the Over, spurrier 0
5607034 2537095 2537095 defendant Harryes John, senior gent 602118 602118 Harryes, John, senior, of St Colombe the Over, gent 0

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