names

211 rows where place_id = 606006

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588185 1863959 1863959 defendant Moyle John weaver 606006 606006 Moyle, John, of St Mynner, weaver 0
3588187 1863959 1863959 defendant Blake John, junior husbandman 606006 606006 Blake, John, junior, of St Mynner, husbandman 2
3610877 1871073 1871073 defendant Walky William chaplain 606006 606006 Walky, William, of St Cleder, chaplain 0
3634840 1905696 1905696 defendant Chyton Stephen husbandman 606006 606006 Chyton, Stephen, of St Enoder, husbandman 2
3644283 1908639 1908639 defendant Woen Richard gent 606006 606006 Woen, Richard, of St Enoder, gent 0
3649766 1910289 1910289 defendant Lanehyne Thomas yeoman 606006 606006 Lanehyne, Thomas, of St Synner, yeoman 3
3649767 1910289 1910289 defendant Walter Bartian husbandman 606006 606006 Walter, Bartian, of St Synner, husbandman 4
3652037 1910988 1910988 defendant Jankyn Henry chaplain 606006 606006 Jankyn, Henry, of St Gwyner, chaplain 0
3653984 1911511 1911511 defendant Bonde Joan widow 606006 606006 Bonde, Joan, of St Jerman, widow 0
3663668 1914571 1914571 defendant Brushe William smith 606006 606006 Brushe, William, of St German, smith 1
3664072 1914713 1914713 defendant Lanehyne Thomas yeoman 606006 606006 Lanehyne, Thomas, of St Synner, yeoman 2
3664073 1914713 1914713 defendant Walter Bertram husbandman 606006 606006 Walter, Bertram, of St Synner, husbandman 3
3671963 1917230 1917230 defendant Bonathon Richard gent 606006 606006 Bonathon, Richard, of St Miler, gent 1
3680156 1919863 1919863 defendant Lanehyne Thomas yeoman 606006 606006 Lanehyne, Thomas, of St Synner, yeoman 3
3680157 1919863 1919863 defendant Walter Bartram husbandman 606006 606006 Walter, Bartram, of St Synner, husbandman 4
3680625 1920021 1920021 plaintiff Menwenyk John   606006 606006 Menwenyk, John, of St German 4
3681904 1920441 1920441 defendant Bonathon Thomas gent 606006 606006 Bonathon, Thomas, of St Miler, gent 1
3713652 1930572 1930572 defendant Fairechild Harvy yeoman 606006 606006 Fairechild, Harvy, of St Cleder, yeoman 0
3713675 1930573 1930573 defendant Fairechild Harvy yeoman 606006 606006 Fairechild, Harvy, of St Cleder, yeoman 0
3726668 1934602 1934602 defendant Trelegh Nicholas husbandman 606006 606006 Trelegh, Nicholas, of St Enoder, husbandman 1
3727698 1934931 1934931 defendant Gayer Stephen gent 606006 606006 Gayer, Stephen, of St Kenner, gent 0
3735529 1937349 1937349 defendant Kekewych Peter chaplain 606006 606006 Kekewych, Peter, of St Jerman, chaplain 0
3739075 1938431 1938431 defendant Kekewich Peter chaplain 606006 606006 Kekewich, Peter, of St Jerman, chaplain 0
3740434 1938867 1938867 plaintiff Menwynnek John   606006 606006 Menwynnek, John, of St German 5
3740629 1938931 1938931 defendant Bory William husbandman 606006 606006 Bory, William, of St German, husbandman 0
3740630 1938931 1938931 defendant Forstret William, senior husbandman 606006 606006 Forstret, William, senior, of St German, husbandman 1
3742376 1939487 1939487 defendant Holman Richard husbandman 606006 606006 Holman, Richard, of St Cleder, husbandman 1
3749180 1941672 1941672 defendant Genyberyn Richard husbandman 606006 606006 Genyberyn, Richard, of St Tenyder, husbandman 2
3753004 1942873 1942873 defendant Bery William husbandman 606006 606006 Bery, William, of St German, husbandman 0
3753005 1942873 1942873 defendant Forstrete William husbandman 606006 606006 Forstrete, William, of St German, husbandman 1
3769970 1948264 1948264 defendant Bery William husbandman 606006 606006 Bery, William, of St German, husbandman 0
3769971 1948264 1948264 defendant Forstrete William, senior husbandman 606006 606006 Forstrete, William, senior, of St German, husbandman 1
3783142 1952484 1952484 defendant Pennarth Joh (legal representative) 606006 606006 Pennarth, Joh, of St German, gent, administratrix of 0
3783143 1952484 1952484 defendant Pennarth alias Harrys Alice widow 606006 606006 Pennarth alias Harrys, Alice, of St German, widow 1
3787786 1953969 1953969 defendant Bery William husbandman 606006 606006 Bery, William, of St German, husbandman 0
3787787 1953969 1953969 defendant Forstrete William, senior husbandman 606006 606006 Forstrete, William, senior, of St German, husbandman 1
3790403 1954817 1954817 defendant Westcote Robert butcher 606006 606006 Westcote, Robert, of St German, butcher 1
3793960 1955982 1955982 defendant Roger Richard laborer 606006 606006 Roger, Richard, of St Bruer, laborer 0
3794662 1956207 1956207 defendant Dyngell John husbandman 606006 606006 Dyngell, John, of St German, husbandman 0
3794665 1956207 1956207 defendant Gache William laborer 606006 606006 Gache, William, of St German, laborer 3
3811745 1961571 1961571 defendant Wattys John mariner 606006 606006 Wattys, John, of St Myller, mariner 1
3819188 1963889 1963889 defendant Alyn Edo cordwainer 606006 606006 Alyn, Edo, of St Enyder, cordwainer 0
3821224 1964531 1964531 plaintiff Mennewennek John   606006 606006 Mennewennek, John, of St German 4
3840638 1970637 1970637 defendant Gyst Henry tinner 606006 606006 Gyst, Henry, of St Enoder, tinner 0
3853412 1974693 1974693 defendant Gache Walter miller 606006 606006 Gache, Walter, of St German, miller 3
3853413 1974693 1974693 defendant Ellett John miller 606006 606006 Ellett, John, of St German, miller 4
3858444 1976300 1976300 defendant Trevylys Thomas esq 606006 606006 Trevylys, Thomas, of St Meyler, esq 0
3861841 1977420 1977420 defendant Lawse John husbandman 606006 606006 Lawse, John, of St Clether, husbandman 2
3874498 1981695 1981695 defendant Will John husbandman 606006 606006 Will, John, of St German, husbandman 1
3875880 1982189 1982189 defendant Dunne Michael husbanbdman 606006 606006 Dunne, Michael, of St Enoder, husbanbdman 2
3878070 1982911 1982911 defendant Stone John gent 606006 606006 Stone, John, of St Mynver, gent 0
3879685 1983460 1983460 defendant Borthey Alexander yeoman 606006 606006 Borthey, Alexander, of St Enoder, yeoman 0
3887144 1985965 1985965 defendant Kent Richard husbandman 606006 606006 Kent, Richard, of St Mynver, husbandman 2
3887145 1985965 1985965 defendant Kent William husbandman 606006 606006 Kent, William, of St Mynver, husbandman 3
3887146 1985965 1985965 defendant Spernall Thomas   606006 606006 Spernall, Thomas, of St Mynver 4
3887147 1985965 1985965 defendant Fyke John husbandman 606006 606006 Fyke, John, of St Mynver, husbandman 5
3887148 1985965 1985965 defendant Tene John husbandman 606006 606006 Tene, John, of St Mynver, husbandman 6
3887892 1986199 1986199 defendant Gayche John husbandman 606006 606006 Gayche, John, of St German, husbandman 0
3899413 1990019 1990019 defendant Faryrchyld Harry husbandman 606006 606006 Faryrchyld, Harry, of St Cleder, husbandman 1
3901043 1990577 1990577 defendant Maye William husbandman 606006 606006 Maye, William, of St Jerman, husbandman 2
3903512 1991402 1991402 defendant Tregowith Thomas husbandman 606006 606006 Tregowith, Thomas, of St Myler, husbandman 0
3905196 1992003 1992003 defendant Bukley Richard husbandman 606006 606006 Bukley, Richard, of St Enoder, husbandman 0
3905197 1992003 1992003 defendant Bone William husbandman 606006 606006 Bone, William, of St Enoder, husbandman 1
3905198 1992003 1992003 defendant Keball Richard husbandman 606006 606006 Keball, Richard, of St Enoder, husbandman 2
3905199 1992003 1992003 defendant Borthy Alexander husbandman 606006 606006 Borthy, Alexander, of St Enoder, husbandman 3
3905200 1992003 1992003 defendant Latt Walter husbandman 606006 606006 Latt, Walter, of St Enoder, husbandman 4
3905201 1992003 1992003 defendant Trevesa Peter husbandman 606006 606006 Trevesa, Peter, of St Enoder, husbandman 5
3905202 1992003 1992003 defendant Trevyllyan James   606006 606006 Trevyllyan, James, of St Enoder 6
3905203 1992003 1992003 defendant Sampson Walter husbandman 606006 606006 Sampson, Walter, of St Senoder, husbandman 7
3905204 1992003 1992003 defendant Polyblank Robert husbandman 606006 606006 Polyblank, Robert, of St Enoder, husbandman 8
3905205 1992003 1992003 defendant William John husbandman 606006 606006 William, John, of St Enoder, husbandman 9
3905206 1992003 1992003 defendant Jenkyn Hugh husbandman 606006 606006 Jenkyn, Hugh, of St Enoder, husbandman 10
3907688 1992861 1992861 defendant Olever William husbandman 606006 606006 Olever, William, of St Myler, husbandman 2
3907692 1992862 1992862 defendant Olyver William husbandman 606006 606006 Olyver, William, Of St Myler, husbandman 2
3913338 1994795 1994795 defendant Mably Henry yeoman 606006 606006 Mably, Henry, of St Mynver, yeoman 0
3921614 1997574 1997574 defendant Body William yeoman 606006 606006 Body, William, of St Myler, yeoman 0
3921712 1997604 1997604 defendant Richard John William husbandman 606006 606006 Richard, John William, of St Enyduyer, husbandman 0
3921713 1997604 1997604 defendant Robert John yeoman 606006 606006 Robert, John, of St Enyduyer, yeoman 1
3926742 1999277 1999277 defendant Bodye William yeoman 606006 606006 Bodye, William, of St Meyller, yeoman 0
3929801 2000304 2000304 defendant Walter Sampson husbandman 606006 606006 Walter, Sampson, of St Kever, husbandman 0
3935476 2002173 2002173 defendant Hyck Agnes widow 606006 606006 Hyck, Agnes, of St Mynver, widow 1
3935477 2002173 2002173 defendant Treman John husbandman 606006 606006 Treman, John, of St Mynver, husbandman 2
3949007 2006718 2006718 defendant Trevylyan John gent 606006 606006 Trevylyan, John, of St Cleder, gent 0
3969035 2013787 2013787 defendant Trelawder John husbandman 606006 606006 Trelawder, John, of St Mynver, husbandman 0
3969036 2013787 2013787 defendant Trelawder Richard husbandman 606006 606006 Trelawder, Richard, of St Mynver, husbandman 1
3969037 2013787 2013787 defendant Olyver Thomas fisherman 606006 606006 Olyver, Thomas, of St Mynver, fisherman 2
3979895 2017567 2017567 defendant Hawke Thomas husbandman 606006 606006 Hawke, Thomas, of St Clether, husbandman 2
3988160 2020511 2020511 defendant Egle alias Morres Thomas husbandman 606006 606006 Egle alias Morres, Thomas, of St Mynver, husbandman 0
3988161 2020511 2020511 defendant Hodge John laborer 606006 606006 Hodge, John, of St Mynver, laborer 1
3989261 2020900 2020900 defendant Robert or Robartes Hugh husbandman 606006 606006 Robert or Robartes, Hugh, of St Decoman, husbandman 5
3993213 2022318 2022318 defendant Burlasse John gent 606006 606006 Burlasse, John, of St Enoder, gent 0
3993214 2022318 2022318 defendant Treluddrowe Walter gent 606006 606006 Treluddrowe, Walter, of St Enoder, gent 1
4030013 2035380 2035380 defendant Trevylian John esq 606006 606006 Trevylian, John, of St Cleder, esq 0
4037455 2038057 2038057 defendant Trevell Thomas husbandman 606006 606006 Trevell, Thomas, of St Mynver, husbandman 0
4046974 2041368 2041368 defendant Davy Robert husbandman 606006 606006 Davy, Robert, of St Clether, husbandman 4
4055453 2044345 2044345 defendant Frauncys Margery widow 606006 606006 Frauncys, Margery, of St Enoder, widow 0
4055454 2044345 2044345 defendant Frauncys Richard husbandman 606006 606006 Frauncys, Richard, of St Enoder, husbandman 1
4055456 2044346 2044346 defendant Frauncys Margery widow 606006 606006 Frauncys, Margery, of St Enoder, widow 0
4055457 2044346 2044346 defendant Frauncys Richard husbandman 606006 606006 Frauncys, Richard, of St Enoder, husbandman 1
4063964 2047392 2047392 defendant ap David Thomas ap Res Wyn gent 606006 606006 ap David, Thomas ap Res Wyn, of St Norman, gent 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);