names

53 rows where place_id = 596395

✎ 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
3624556 1875216 1875216 defendant Cavyll or Canyll Joan widow 596395 596395 (Cavyll or Canyll, Joan, of Lostwithiell, widow 2
3624557 1875216 1875216 defendant Cavyll or Canyll Thomas yeoman 596395 596395 Cavyll or Canyll, Thomas, of Lostwithiell, yeoman 3
3661237 1913792 1913792 defendant Stevyn Thomas weaver 596395 596395 Stevyn, Thomas, of Lostwithiell, weaver 1
3661238 1913792 1913792 defendant Joce John yeoman 596395 596395 Joce, John, of Lostwithiell, yeoman 2
3661239 1913792 1913792 defendant Bryan Edward mercer 596395 596395 Bryan, Edward, of Lostwithiell, mercer 3
3696262 1925051 1925051 defendant Buntholte Rose widow 596395 596395 Buntholte, Rose, of Lostwithiell, widow 5
3781797 1952052 1952052 plaintiff Helyer alias Maiowe Thomas merchant 596395 596395 Helyer alias Maiowe, Thomas, of Lostwithiell, merchant 0
3786532 1953580 1953580 defendant Mercer Henry tinner 596395 596395 Mercer, Henry, of Lostwithiell, tinner 1
3838480 1969959 1969959 defendant Johnsebell Richard tinner 596395 596395 Johnsebell, Richard, of Lostwithiell, tinner 1
3838481 1969959 1969959 defendant Johnsebell Philip tinner 596395 596395 Johnsebell, Philip, of Lostwithiell, tinner 2
3838524 1969973 1969973 defendant Gilbert alias Tanner John tanner 596395 596395 Gilbert alias Tanner, John, of Lostwithiell, tanner 2
3838525 1969973 1969973 defendant Kendall Flora widow 596395 596395 Kendall, Flora, of Lostwithiell, widow 3
4016815 2030711 2030711 plaintiff Swete John gent 596395 596395 Swete, John, of Lostwithiell, gent 0
4016817 2030712 2030712 plaintiff Swete John gent 596395 596395 Swete, John, of Lostwithiell, gent 0
4113422 2065073 2065073 defendant Tompkyn Thomas yeoman 596395 596395 Tompkyn, Thomas, of Lostwithiell, yeoman 0
4164024 2082945 2082945 defendant Lynam Nicholas hellyer or roofer 596395 596395 Lynam, Nicholas, of Lostwithiell, hellyer or roofer 0
4164025 2082945 2082945 defendant Brusy John husbandman 596395 596395 Brusy, John, of Lostwithiell, husbandman 1
4164026 2082945 2082945 defendant Alleyn John husbandman 596395 596395 Alleyn, John, of Lostwithiell, husbandman 2
4294025 2127940 2127940 defendant Gobell William pewterer 596395 596395 Gobell, William, of Lostwithiell, pewterer 0
4395407 2163045 2163045 defendant Farnaby Henry husbandman 596395 596395 Farnaby, Henry, of Lostwithiell, husbandman 0
4473798 2192450 2192450 plaintiff Daubron John   596395 596395 Daubron, John, of Lostwithiell 0
4500378 2200738 2200738 defendant Jenrlee Thomas   596395 596395 Jenrlee, Thomas, of Lostwithiell 0
4540137 2212817 2212817 defendant Chappeman William   596395 596395 Chappeman, William, of Lostwithiell 0
4545748 2214597 2214597 defendant Webber Henry   596395 596395 Webber, Henry, of Lostwithiell 7
4545749 2214597 2214597 defendant Hoper John   596395 596395 Hoper, John, of Lostwithiell 8
4559710 2218991 2218991 defendant Hogge John   596395 596395 Hogge, John, of Lostwithiell 2
4567914 2221537 2221537 defendant Waterbailly Hugh   596395 596395 Waterbailly, Hugh, of Lostwithiell 0
4567915 2221537 2221537 defendant Pyret John   596395 596395 Pyret, John, of Lostwithiell 1
4579347 2225023 2225023 defendant Hervy Richard   596395 596395 Hervy, Richard, of Lostwithiell 0
4590989 2228533 2228533 defendant Dier John   596395 596395 Dier, John, of Lostwithiell 1
4612213 2234884 2234884 defendant (not given) John mayor of Leylond 596395 596395 Leylond, John, of Lostwithiell, mayor of the town 0
4612218 2234886 2234886 defendant Quynt Roger   596395 596395 Quynt, Roger, of Lostwithiell, mayor 0
4612219 2234886 2234886 defendant Rowe William   596395 596395 Rowe, William, of Lostwithiell, formerly priest 1
4612220 2234886 2234886 defendant Barbour John water bailiff 596395 596395 Barbour, John, of Lostwithiell, water bailiff 2
4657849 2248341 2248341 defendant Coula John crocker 596395 596395 Coula, John, of Lostwithiell, crocker 2
4659051 2248701 2248701 defendant Clerowe Ralph tinner 596395 596395 Clerowe, Ralph, of Lostwithiell, tinner 0
4682472 2260142 2260142 defendant Laury Edward clerk 596395 596395 Laury, Edward, of Lostwithiell, clerk 0
4813647 2300375 2300375 defendant Bonnok Richard gent 596395 596395 Bonnok, Richard, of Lostwithiell, gent 0
4860323 2314590 2314590 defendant Hikedon John yeoman 596395 596395 Hikedon, John, of Lostwithiell, yeoman 1
4870991 2317903 2317903 defendant Borde or Gorde William cordwainer 596395 596395 Borde or Gorde, William, of Lostwithiell, cordwainer 0
4881910 2321240 2321240 defendant Peyntour Roger husbandman 596395 596395 Peyntour, Roger, of Lostwithiell, husbandman 1
4897565 2325901 2325901 plaintiff Bonek Richard   596395 596395 Bonek, Richard, of Lostwithiell 1
5002307 2357579 2357579 defendant Daberon John   596395 596395 Daberon, John, of Lostwithiell, formerly mayor 0
5077501 2379770 2379770 defendant Menwynnek William gent 596395 596395 Menwynnek, William, of Lostwithiell, gent 0
5088225 2382928 2382928 defendant Moriowe Thomas weaver 596395 596395 Moriowe, Thomas, of Lostwithiell, weaver 2
5163305 2405002 2405002 plaintiff West Thomas   596395 596395 West, Thomas, of Lostwithiell, son of Nicholas 0
5311281 2448403 2448403 defendant Chapman William mercer 596395 596395 Chapman, William, of Lostwithiell, mercer 1
5327364 2453255 2453255 defendant Dier William dyer 596395 596395 Dier, William, of Lostwithiell, dyer 2
5368060 2465632 2465632 defendant Southe John draper 596395 596395 Southe, John, of Lostwithiell, draper 0
5374751 2467699 2467699 defendant Taylour Otto tailor 596395 596395 Taylour, Otto, of Lostwithiell, tailor 0
5378321 2468798 2468798 defendant Menwynnek John gent 596395 596395 Menwynnek, John, of Lostwithiell, gent 0
5507685 2507307 2507307 defendant Lynam John smith 596395 596395 Lynam, John, of Lostwithiell, smith 0
5507686 2507307 2507307 defendant Lynam Nicholas barber 596395 596395 Lynam, Nicholas, of Lostwithiell, barber 1

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