names

138 rows where place_id = 586416

✎ 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
3588675 1864101 1864101 defendant Philipp Oto gent 586416 586416 Philipp, Oto, of Padestowe, gent 0
3590116 1864547 1864547 defendant Engeff John laborer 586416 586416 Engeff, John, of Padestowe, laborer 3
3595972 1866371 1866371 defendant Nycholas John, senior husbandman 586416 586416 Nycholas, John, senior, of Padestowe, husbandman 3
3595973 1866371 1866371 defendant Mason William   586416 586416 Mason, William, of Padestowe, mason 4
3595974 1866371 1866371 defendant Jagowe Nicholas miller 586416 586416 Jagowe, Nicholas, of Padestowe, miller 5
3595975 1866371 1866371 defendant Payne Thomas husbandman 586416 586416 Payne, Thomas, of Padestowe, husbandman 6
3601881 1868242 1868242 defendant Borlas John   586416 586416 Borlas, John, of Padestowe, franklin 0
3608583 1870343 1870343 defendant Rawlyn William gent 586416 586416 Rawlyn, William, of Padestowe, gent 0
3611635 1871308 1871308 defendant Tomme John chaplain 586416 586416 Tomme, John, of Padestowe, chaplain 0
3634838 1905696 1905696 defendant Wik Richard Jenkyn husbandman 586416 586416 Wik, Richard Jenkyn, of Padestowe, husbandman 0
3641383 1907758 1907758 defendant Paule John yeoman 586416 586416 Paule, John, of Padestowe, yeoman 0
3652114 1911008 1911008 defendant Powle John yeoman 586416 586416 Powle, John, of Padestowe, yeoman 7
3657594 1912637 1912637 defendant Hill William yeoman 586416 586416 Hill, William, of Padestowe, yeoman 0
3658102 1912790 1912790 defendant Phylyp Robert   586416 586416 Phylyp, Robert, of Padestowe, ship master 0
3666252 1915394 1915394 defendant Marke Richard laborer 586416 586416 Marke, Richard, of Padestowe, laborer 3
3683781 1921062 1921062 defendant Hyck Thomas fisher 586416 586416 Hyck, Thomas, of Padestowe, fisher 0
3811202 1961399 1961399 defendant Halwey William mariner 586416 586416 Halwey, William, of Padestowe, mariner 0
3811203 1961399 1961399 defendant Walky Richard mariner 586416 586416 Walky, Richard, of Padestowe, mariner 1
3811204 1961399 1961399 defendant Mahound Thomas mariner 586416 586416 Mahound, Thomas, of Padestowe, mariner 2
3811205 1961399 1961399 defendant Bechyn John mariner 586416 586416 Bechyn, John, of Padestowe, mariner 3
3811206 1961399 1961399 defendant Paramour Nicholas mariner 586416 586416 Paramour, Nicholas, of Padestowe, mariner 4
3811207 1961399 1961399 defendant Glover John mariner 586416 586416 Glover, John, of Padestowe, mariner 5
3983003 2018697 2018697 defendant Goodchylde Thomas merchant 586416 586416 Goodchylde, Thomas, of Padestowe, merchant 0
4032839 2036399 2036399 defendant de Balderanna Jingo merchant 586416 586416 de Balderanna, Jingo, of Padestowe, merchant 0
4032840 2036399 2036399 defendant Crabbe alias Burlace Roger husbandman 586416 586416 Crabbe alias Burlace, Roger, of Padestowe, husbandman 1
4042856 2039920 2039920 defendant Leane Edward husbandman 586416 586416 Leane, Edward, of Padestowe, husbandman 2
4124196 2068943 2068943 defendant Roche William   586416 586416 Roche, William, of Padestowe merchant 1
4168546 2084483 2084483 defendant Sunter Edward merchant 586416 586416 Sunter, Edward, of Padestowe, merchant 0
4191972 2092751 2092751 defendant Trevethen Guy gent 586416 586416 Trevethen, Guy, of Padestowe, gent 0
4191979 2092753 2092753 defendant Sunter Edward merchant 586416 586416 Sunter Edward, of Padestowe, merchant 0
4238777 2109181 2109181 defendant Pentyre John yeoman 586416 586416 Pentyre, John, of Padestowe, yeoman 0
4294299 2128038 2128038 defendant Prideaux Richard gent 586416 586416 Prideaux, Richard, of Padestowe, gent 0
4298936 2129714 2129714 defendant Ranke John carpenter 586416 586416 Ranke, John, of Padestowe, carpenter 0
4298937 2129714 2129714 defendant Gilbert Nicholas carpenter 586416 586416 Gilbert, Nicholas, of Padestowe, carpenter 1
4432042 2174802 2174802 plaintiff Chaloner Eustace le   586416 586416 Chaloner, Eustace le, of Padestowe 0
4512918 2204475 2204475 plaintiff Bray Richard   586416 586416 Bray, Richard, of Padestowe 0
4609955 2234204 2234204 plaintiff Bylyon John   586416 586416 Bylyon, John, of Padestowe 0
4674171 2257529 2257529 defendant Hoskyns Richard husbandman 586416 586416 Hoskyns, Richard, of Padestowe, husbandman 1
4674175 2257530 2257530 defendant Hoskyn Richard husandman 586416 586416 with Hoskyn, Richard, of Padestowe, husandman 1
4676245 2258182 2258182 plaintiff Geffrey Richard (legal representative) 586416 586416 Geffrey, Richard, of Padestowe, executor of 0
4723922 2272780 2272780 defendant Herward John   586416 586416 Herward, John, of Padestowe 0
4725659 2273312 2273312 plaintiff Geffrey Richard (legal representative) 586416 586416 Geffrey, Richard, of Padestowe, executor of 0
4796718 2295127 2295127 defendant Restulyan John gent 586416 586416 Restulyan, John, of Padestowe, gent 0
4858075 2313895 2313895 defendant Doune Thomas fisher 586416 586416 Doune, Thomas, of Padestowe, fisher 0
4864380 2315838 2315838 defendant Gelly Stephen helyer or roofer 586416 586416 Gelly, Stephen, of Padestowe, helyer or roofer 0
4887363 2322883 2322883 defendant Kyng Walter fisher 586416 586416 Kyng, Walter, of Padestowe, fisher 0
4936220 2337728 2337728 defendant Mathy John husbandman 586416 586416 Mathy, John, of Padestowe, husbandman 7
5077483 2379765 2379765 defendant Kyrn John gent 586416 586416 Kyrn, John, of Padestowe, gent 0
5081209 2380885 2380885 defendant Mathy John shipman 586416 586416 Mathy, John, of Padestowe, shipman 0
5084252 2381799 2381799 defendant Simon John fisher 586416 586416 Simon, John, of Padestowe, fisher 2
5084253 2381799 2381799 defendant Whithiell Ralph fisher 586416 586416 Whithiell, Ralph, of Padestowe, fisher 3
5084254 2381799 2381799 defendant Hayle John fiser 586416 586416 Hayle, John, of Padestowe, fiser 4
5084255 2381799 2381799 defendant Moreys William fisher 586416 586416 Moreys, William, of Padestowe, fisher 5
5084256 2381799 2381799 defendant Bodyscastell John fisher 586416 586416 Bodyscastell, John, of Padestowe, fisher 6
5100045 2386451 2386451 defendant Henrue Richard husbandman 586416 586416 Henrue, Richard, of Padestowe, husbandman 0
5100047 2386452 2386452 defendant Herne or Herve Richard husbandman 586416 586416 Herne or Herve, Richard, of Padestowe, husbandman 0
5123334 2393265 2393265 defendant Tredenek John gent 586416 586416 Tredenek, John, of Padestowe, gent 1
5163477 2405050 2405050 defendant Trethennek William gent 586416 586416 Trethennek, William, of Padestowe, gent 2
5164049 2405221 2405221 defendant Yeoman Richard gent 586416 586416 Yeoman, Richard, of Padestowe, gent 2
5200497 2415905 2415905 defendant Yeo Richard gent 586416 586416 (Yeo, Richard, of Padestowe, gent 1
5200777 2415988 2415988 defendant Toker John husbandman 586416 586416 Toker, John, of Padestowe, husbandman 0
5211282 2419028 2419028 defendant Trethennek William gent 586416 586416 Trethennek, William, of Padestowe, gent 2
5211625 2419138 2419138 defendant Toker John husbandman 586416 586416 Toker, John, of Padestowe, husbandman 0
5229112 2424121 2424121 defendant Yeo Richard gent 586416 586416 together with Yeo, Richard, of Padestowe, gent 2
5251890 2430700 2430700 defendant Herry Richard weaver 586416 586416 Herry, Richard, of Padestowe, weaver 0
5251891 2430700 2430700 defendant Pastowe John fisher 586416 586416 Pastowe, John, of Padestowe, fisher 1
5251892 2430700 2430700 defendant Bray Patrick shoemaker 586416 586416 Bray, Patrick, of Padestowe, shoemaker 2
5251893 2430700 2430700 defendant Gormond Thomas fisher 586416 586416 Gormond, Thomas, of Padestowe, fisher 3
5251894 2430700 2430700 defendant Laury John tailor 586416 586416 Laury, John, of Padestowe, tailor 4
5251895 2430700 2430700 defendant Coteler William cutler 586416 586416 Coteler, William, of Padestowe, cutler 5
5251896 2430700 2430700 defendant Grysy John yeoman 586416 586416 Grysy, John, of Padestowe, yeoman 6
5251899 2430700 2430700 defendant Cok John fisher 586416 586416 Cok, John, of Padestowe, fisher 9
5252986 2431045 2431045 defendant Porthumre John husbandman 586416 586416 Porthumre, John, of Padestowe, husbandman 0
5252987 2431045 2431045 defendant Carpenter Nicholas husbandman 586416 586416 Carpenter, Nicholas, of Padestowe, husbandman 1
5252988 2431045 2431045 defendant Pascowe John husbandman 586416 586416 Pascowe, John, of Padestowe, husbandman 2
5252989 2431045 2431045 defendant Stephyn John fisher 586416 586416 together with Stephyn, John, of Padestowe, fisher 3
5252990 2431045 2431045 defendant Trelouthowe Thomas husbandman 586416 586416 Trelouthowe, Thomas, of Padestowe, husbandman 4
5252991 2431045 2431045 defendant Mason John husbandman 586416 586416 Mason, John, of Padestowe, husbandman 5
5252992 2431045 2431045 defendant Braban John husbandman 586416 586416 Braban, John, of Padestowe, husbandman 6
5252993 2431045 2431045 defendant Nicoltouker John husbandman 586416 586416 Nicoltouker, John, of Padestowe, husbandman 7
5252995 2431045 2431045 defendant Peen Thomas husbandman 586416 586416 Peen, Thomas, of Padestowe, husbandman 9
5252997 2431046 2431046 defendant Stephyn John fisher 586416 586416 Stephyn, John, of Padestowe, fisher 0
5252998 2431046 2431046 defendant Trelouthowe Thomas husbandman 586416 586416 Trelouthowe, Thomas, of Padestowe, husbandman 1
5252999 2431046 2431046 defendant Mason John husbandman 586416 586416 Mason, John, of Padestowe, husbandman 2
5253000 2431046 2431046 defendant Braban John husbandman 586416 586416 Braban, John, of Padestowe, husbandman 3
5253001 2431046 2431046 defendant Nicoltouker John husbandman 586416 586416 Nicoltouker, John, of Padestowe, husbandman 4
5253003 2431046 2431046 defendant Peen Thomas husbandman 586416 586416 Peen, Thomas, of Padestowe, husbandman 6
5261061 2433572 2433572 defendant Hayly John fisher 586416 586416 Hayly, John, of Padestowe, fisher 0
5261062 2433572 2433572 defendant Herry Richard weaver 586416 586416 Herry, Richard, of Padestowe, weaver 1
5261063 2433572 2433572 defendant Coteler William cutler 586416 586416 Coteler, William, of Padestowe, cutler 2
5261836 2433811 2433811 defendant Dey John weaver 586416 586416 Dey, John, of Padestowe, weaver 1
5261839 2433812 2433812 defendant Dey John weaver 586416 586416 Dey, John, of Padestowe, weaver 1
5276086 2438080 2438080 defendant bocher Lawrence butcher 586416 586416 bocher, Lawrence, of Padestowe, butcher 4
5277538 2438507 2438507 defendant Oryn John husbandman 586416 586416 Oryn, John, of Padestowe, husbandman 0
5277539 2438507 2438507 defendant Harry Richard weaver 586416 586416 Harry, Richard, of Padestowe, weaver 1
5277543 2438507 2438507 defendant Trelyner Roger weaver 586416 586416 Trelyner, Roger, of Padestowe, weaver 5
5277544 2438507 2438507 defendant Mana or Mava Henry smith 586416 586416 Mana or Mava, Henry, of Padestowe, smith 6
5291949 2442652 2442652 defendant Baker Thomas baker 586416 586416 Baker, Thomas, of Padestowe, baker 0
5291950 2442652 2442652 defendant Kent Thomas fisher 586416 586416 Kent, Thomas, of Padestowe, fisher 1
5291951 2442652 2442652 defendant Trenethen Walter husbandman 586416 586416 Trenethen, Walter, of Padestowe, husbandman 2

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