names

110 rows where place_id = 603621

✎ 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
3655151 1911872 1911872 defendant Kemell Thomas yeoman 603621 603621 Kemell, Thomas, of Helston, yeoman 1
3655152 1911872 1911872 defendant Lannarght Agnes widow 603621 603621 Lannarght, Agnes, of Helston, widow 2
3682849 1920744 1920744 defendant Dayne John laborer 603621 603621 Dayne, John, of Helston, laborer 0
3692509 1923841 1923841 defendant Kelway Nicholas husbandman 603621 603621 Kelway, Nicholas, of Helston, husbandman 0
3723584 1933651 1933651 defendant John Henry chaplain 603621 603621 John, Henry, of Helston, chaplain 0
3723585 1933651 1933651 defendant Perys Martin merchant 603621 603621 Perys, Martin, of Helston, merchant 1
3729890 1935603 1935603 defendant Wylson John merchant 603621 603621 Wylson, John, of Helston, merchant 0
3729893 1935604 1935604 defendant Wylson John merchant 603621 603621 Wylson, John, of Helston, merchant 0
3729909 1935608 1935608 defendant Wylson John merchant 603621 603621 Wylson, John, of Helston, merchant 1
3759333 1944909 1944909 defendant Alen William Rawe yeoman 603621 603621 Alen, William Rawe, of Helston, yeoman 1
3759334 1944909 1944909 defendant Breton Guy yeoman 603621 603621 Breton, Guy, of Helston, yeoman 2
3759335 1944909 1944909 defendant Greton Martin   603621 603621 Greton, Martin, of Helston, groom 3
3759336 1944909 1944909 defendant Hadlon John yeoman 603621 603621 Hadlon, John, of Helston, yeoman 4
3822486 1964931 1964931 defendant Wolcok John smith 603621 603621 Wolcok, John, of Helston, smith 0
3822487 1964931 1964931 defendant Marke Thomas husbandman 603621 603621 Marke, Thomas, of Helston, husbandman 1
3822488 1964931 1964931 defendant Nele William smith 603621 603621 Nele, William, of Helston, smith 2
3822489 1964931 1964931 defendant Edwarde Alexander glover 603621 603621 Edwarde, Alexander, of Helston, glover 3
3822490 1964931 1964931 defendant Jamys Ralph cordwainer 603621 603621 Jamys, Ralph, of Helston, cordwainer 4
3822491 1964931 1964931 defendant Bosweke John smith 603621 603621 Bosweke, John, of Helston, smith 5
3830723 1967492 1967492 defendant Lostwoon Richard husbandman 603621 603621 Lostwoon, Richard, of Helston, husbandman 0
3838479 1969959 1969959 defendant Rowe William tinner 603621 603621 Rowe, William, of Helston, tinner 0
3838485 1969960 1969960 defendant Thomas Nicholas tinner 603621 603621 Thomas, Nicholas, of Helston, tinner 2
3838487 1969960 1969960 defendant Kyllowe John tinner 603621 603621 Kyllowe, John, of Helston, tinner 4
3839206 1970189 1970189 defendant Rowe William yeoman or tinner 603621 603621 Rowe, William, of Helston, yeoman or tinner 0
3854692 1975114 1975114 defendant Rowe William tinner 603621 603621 Rowe, William, of Helston, tinner 0
3854697 1975115 1975115 defendant Thomas Nicholas tinner 603621 603621 Thomas, Nicholas, of Helston, tinner 1
3854699 1975115 1975115 defendant Kyllowe John tinner 603621 603621 Kyllowe, John, of Helston, tinner 3
3855581 1975389 1975389 defendant Rawe William tanner 603621 603621 Rawe, William, of Helston, tanner 0
3869952 1980191 1980191 defendant Saundre Elizabeth John widow 603621 603621 Saundre, Elizabeth John, of Helston, widow 0
3899418 1990019 1990019 defendant Martyn Peter yeoman 603621 603621 Martyn, Peter, of Helston, yeoman 6
3927292 1999467 1999467 defendant Resegh John yeoman 603621 603621 Resegh, John, of Helston, yeoman 0
3927293 1999467 1999467 defendant Nicholl Peter yeoman 603621 603621 Nicholl, Peter, of Helston, yeoman 1
3934954 2001994 2001994 defendant Hoolkyn Peter tinner 603621 603621 Hoolkyn, Peter, of Helston, tinner 0
3934955 2001994 2001994 defendant Bretton alias Penruyth John milner 603621 603621 Bretton alias Penruyth, John, of Helston, milner 1
3934956 2001994 2001994 defendant Botha John tinner 603621 603621 Botha, John, of Helston, tinner 2
3935358 2002138 2002138 defendant Resegh John yeoman 603621 603621 Resegh, John, of Helston, yeoman 0
3935359 2002138 2002138 defendant Nycoll Peter yeoman 603621 603621 Nycoll, Peter, of Helston, yeoman 1
3938653 2003269 2003269 defendant Resegh John yeoman 603621 603621 Resegh, John, of Helston, yeoman 0
3938654 2003269 2003269 defendant Nicholl Peter yeoman 603621 603621 Nicholl, Peter, of Helston, yeoman 1
3940473 2003831 2003831 defendant Penheleok Alexander husbandman 603621 603621 Penheleok, Alexander, of Helston, husbandman 1
3940474 2003831 2003831 defendant Rolland John tailor 603621 603621 Rolland, John, of Helston, tailor 2
3940475 2003831 2003831 defendant Trest Thomas yeoman 603621 603621 Trest, Thomas, of Helston, yeoman 3
3940476 2003831 2003831 defendant John Perys Joan widow 603621 603621 John Perys, Joan, of Helston, widow 4
3940480 2003831 2003831 defendant Carlyan William yeoman 603621 603621 Carlyan, William, of Helston, yeoman 8
3940481 2003831 2003831 defendant Luke Pastus yeoman 603621 603621 Luke, Pastus, of Helston, yeoman 9
3957163 2009570 2009570 defendant Arnold John saddler 603621 603621 Arnold, John, of Helston, saddler 0
4008364 2027757 2027757 defendant Welcoke John James cordwainer 603621 603621 Welcoke, John James, of Helston, cordwainer 0
4078459 2052594 2052594 defendant Penhelycke Florence widow 603621 603621 Penhelycke, Florence, of Helston, widow 2
4132349 2071883 2071883 defendant Waterton alias George Peirce tanner 603621 603621 Waterton alias George, Peirce, of Helston, tanner 0
4154580 2079695 2079695 defendant Dottsen John Cornw, gent 603621 603621 Dottsen John, of Helston, Cornw, gent 0
4160018 2081573 2081573 defendant Peers Thomas yeoman 603621 603621 Peers, Thomas, of Helston, yeoman 0
4160019 2081573 2081573 defendant John Richard yeoman 603621 603621 John, Richard, of Helston, yeoman 1
4160020 2081573 2081573 defendant Studwell Stephen yeoman 603621 603621 Studwell, Stephen, of Helston, yeoman 2
4160021 2081573 2081573 defendant James Thomas yeoman 603621 603621 James, Thomas, of Helston, yeoman 3
4160022 2081573 2081573 defendant Trelace Nicholas yeoman 603621 603621 Trelace, Nicholas, of Helston, yeoman 4
4160023 2081573 2081573 defendant Peers alias Richarde John yeoman 603621 603621 Peers alias Richarde, John, of Helston, yeoman 5
4160024 2081573 2081573 defendant Peers henry yeoman 603621 603621 Peers, henry, of Helston, yeoman 6
4160025 2081573 2081573 defendant Pasmore Robert yeoman 603621 603621 Pasmore, Robert, of Helston, yeoman 7
4160026 2081573 2081573 defendant Penhalnrecke Peter yeoman 603621 603621 Penhalnrecke, Peter, of Helston, yeoman 8
4160027 2081573 2081573 defendant Penhelicke John yeoman 603621 603621 Penhelicke, John, of Helston, yeoman 9
4160028 2081573 2081573 defendant Steman William yeoman 603621 603621 Steman, William, of Helston, yeoman 10
4160029 2081573 2081573 defendant Stephyn Isaac yeoman 603621 603621 Stephyn, Isaac, of Helston, yeoman 11
4160030 2081573 2081573 defendant Bryan John yeoman 603621 603621 Bryan, John, of Helston, yeoman 12
4160031 2081573 2081573 defendant Caron Robert yeoman 603621 603621 Caron, Robert, of Helston, yeoman 13
4160032 2081573 2081573 defendant James alias Wolcocke John yeoman 603621 603621 James alias Wolcocke, John, of Helston, yeoman 14
4187638 2091178 2091178 defendant Parsmore John draper 603621 603621 Parsmore, John, of Helston, draper 0
4187640 2091179 2091179 defendant Parsmore Robert cordwainer 603621 603621 Parsmore, Robert, of Helston, cordwainer 0
4214796 2100681 2100681 defendant Penhellicke William gent 603621 603621 Penhellicke, William, of Helston, gent 0
4242793 2110580 2110580 defendant Nalcoe alias Penhalnrycke Peter yeoman 603621 603621 Nalcoe alias Penhalnrycke, Peter, of Helston, yeoman 0
4310757 2133905 2133905 defendant Mathy John yeoman 603621 603621 Mathy, John, of Helston, yeoman 1
4360191 2150809 2150809 defendant Collyns William mercer 603621 603621 Collyns, William, of Helston, mercer 0
4383696 2159256 2159256 defendant Hunt John merchant 603621 603621 Hunt, John, of Helston, merchant 0
4405892 2166534 2166534 defendant Hunt John merchant 603621 603621 Hunt, John, of Helston, merchant 0
4489821 2197523 2197523 defendant Tregher William   603621 603621 Tregher, William, of Helston, son of Mary Tregher 5
4554985 2217487 2217487 defendant Carnebon Thomas   603621 603621 Carnebon, Thomas, of Helston 0
4577526 2224483 2224483 defendant Sadeler John   603621 603621 Sadeler, John, of Helston 2
4577529 2224483 2224483 defendant Burwyk John   603621 603621 Burwyk, John, of Helston 5
4626279 2239178 2239178 plaintiff Power John   603621 603621 Power, John, of Helston 0
4626281 2239179 2239179 plaintiff Power John   603621 603621 Power, John, of Helston 0
4654944 2247430 2247430 plaintiff Brae John   603621 603621 Brae, John, of Helston 0
4654945 2247430 2247430 defendant Cornowe Walter glover 603621 603621 Cornowe, Walter, of Helston, glover 0
4654946 2247430 2247430 defendant R- Harvy tinner 603621 603621 R-, Harvy, of Helston, tinner 1
4654947 2247430 2247430 defendant Reynward John scrivener 603621 603621 Reynward, John, of Helston, scrivener 2
4659562 2248842 2248842 defendant Waryner Adam yeoman 603621 603621 Waryner, Adam, of Helston, yeoman 0
4681575 2259850 2259850 defendant Bon William   603621 603621 Bon, William, of Helston, bailiff 0
4703700 2266536 2266536 defendant Noel John yeoman 603621 603621 Noel, John, of Helston, yeoman 1
4719724 2271517 2271517 defendant Rawe John smith 603621 603621 Rawe, John, of Helston, smith 0
4814524 2300651 2300651 defendant Herryrychowe John tinner 603621 603621 Herryrychowe, John, of Helston, tinner 2
4814525 2300651 2300651 defendant Brystonwe Richard shoemaker 603621 603621 Brystonwe, Richard, of Helston, shoemaker 3
4917780 2332074 2332074 defendant Trevenne Michael husbandman 603621 603621 Trevenne, Michael, of Helston, husbandman 0
4936833 2337900 2337900 defendant Kilner John yeoman 603621 603621 Kilner, John, of Helston, yeoman 2
4936834 2337900 2337900 defendant Baudwenson Roger waller 603621 603621 Baudwenson, Roger, of Helston, waller 3
4995150 2355402 2355402 defendant Levens Thomas yeoman 603621 603621 Levens, Thomas, of Helston, yeoman 3
5036185 2367438 2367438 defendant Chapman Thomas mercer 603621 603621 Chapman, Thomas, of Helston, mercer 1
5040772 2368855 2368855 defendant Nauskylly Richard tanner 603621 603621 Nauskylly, Richard, of Helston in Keryer, tanner 0
5130544 2395417 2395417 defendant Emout John mercer 603621 603621 Emout, John, of Helston, mercer 0
5132045 2395862 2395862 defendant Guont or Evont John mercer 603621 603621 Guont or Evont, John, of Helston, mercer 0
5141027 2398499 2398499 defendant Martyn John smith 603621 603621 Martyn, John, of Helston, smith 0
5364608 2464591 2464591 defendant Nonyell Robert yeoman 603621 603621 Nonyell, Robert, of Helston, yeoman 3
5364609 2464591 2464591 defendant Jenkyn Richard mercer 603621 603621 Jenkyn, Richard, of Helston, mercer 4

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