names

104 rows where place_id = 599163

✎ 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
3635565 1905926 1905926 defendant Thomas John yeoman 599163 599163 Thomas, John, of St Austell, yeoman 5
3642735 1908174 1908174 defendant Moyle John husbandman 599163 599163 Moyle, John, of St Austell, husbandman 0
3658375 1912868 1912868 defendant Michell John husbandman 599163 599163 Michell, John, of St Austell, husbandman 1
3662458 1914170 1914170 defendant Rows John Andrew   599163 599163 Rows, John Andrew, of St Austell, tin merchant 0
3673330 1917674 1917674 defendant Michell John yeoman 599163 599163 Michell, John, of St Austell, yeoman 1
3673331 1917674 1917674 defendant Tomme John yeoman 599163 599163 Tomme, John, of St Austell, yeoman 2
3684809 1921386 1921386 defendant Trewhela Richard yeoman 599163 599163 Trewhela, Richard, of St Austell, yeoman 0
3684810 1921386 1921386 defendant Hokke Henry yeoman 599163 599163 Hokke, Henry, of St Austell, yeoman 1
3684811 1921386 1921386 defendant Richowe John yeoman 599163 599163 Richowe, John, of St Austell, yeoman 2
3684812 1921386 1921386 defendant Rouse Stephen merchant 599163 599163 Rouse, Stephen, of St Austell, merchant 3
3729815 1935581 1935581 defendant Trounson John chaplain 599163 599163 Trounson, John, of St Austell, chaplain 0
3831009 1967581 1967581 defendant Hygawe William husbandman 599163 599163 Hygawe, William, of St Austell, husbandman 1
3838215 1969869 1969869 defendant Thomas John husbandman 599163 599163 Thomas, John, of St Austell, husbandman 0
3845868 1972262 1972262 defendant Tome John merchant 599163 599163 Tome, John, of St Austell, merchant 1
3851647 1974102 1974102 defendant Bosithyowe John husbandman 599163 599163 Bosithyowe, John, of St Austell, husbandman 0
3851648 1974102 1974102 defendant Rosvyar John husbandman 599163 599163 Rosvyar, John, of St Austell, husbandman 1
3868759 1979791 1979791 defendant Thom John husbandman 599163 599163 Thom, John, of St Austell, husbandman 0
3869021 1979884 1979884 defendant Ewyn Nicholas shoemaker 599163 599163 Ewyn, Nicholas, of St Austell, shoemaker 0
3869688 1980104 1980104 defendant Brenek Robert gent 599163 599163 Brenek, Robert, of St Austell, gent 0
3872099 1980899 1980899 defendant Thomas John yeoman 599163 599163 Thomas, John, of St Austell, yeoman 0
3873881 1981482 1981482 defendant Bosythyowe Thomas clerk 599163 599163 Bosythyowe, Thomas, of St Austell, clerk 0
3896380 1988996 1988996 defendant Cowga Richard glover 599163 599163 Cowga, Richard, of St Austell, glover 0
3907708 1992866 1992866 defendant Rows Nicholas yeoman 599163 599163 Rows, Nicholas, of St Austell, yeoman 3
3914663 1995248 1995248 defendant Rowse Nicholas husmandman 599163 599163 Rowse, Nicholas, of St Austell, husmandman 0
3915123 1995416 1995416 defendant Penpons Richard gent 599163 599163 Penpons, Richard, of St Austell, gent 0
3924361 1998458 1998458 defendant Moyll John yeoman 599163 599163 Moyll, John, of St Austell, yeoman 0
3925073 1998701 1998701 defendant Cock Richard glover 599163 599163 Cock, Richard, of St Austell, glover 3
3928634 1999915 1999915 defendant Rosebeare Richard husbandman 599163 599163 Rosebeare, Richard, of St Austell, husbandman 0
3950901 2007382 2007382 defendant Harry John husbandman 599163 599163 Harry, John, of St Austell, husbandman 0
3969712 2014014 2014014 plaintiff Coysgarne John   599163 599163 Coysgarne, John, of St Austell 0
3969713 2014014 2014014 defendant Cole John, junior tinner 599163 599163 Cole, John, junior, of St Austell, tinner 0
3969714 2014014 2014014 defendant Cole Thomas tinner 599163 599163 Cole, Thomas, of St Austell, tinner 1
3991599 2021756 2021756 defendant Delamyne John shoemaker 599163 599163 Delamyne, John, of St Austell, shoemaker 0
4068559 2049043 2049043 defendant Hawkyn Mathew husbandman 599163 599163 Hawkyn, Mathew, of St Austell, husbandman 0
4068560 2049043 2049043 defendant Hawkyn Robert husbandman 599163 599163 Hawkyn, Robert, of St Austell, husbandman 1
4068561 2049043 2049043 defendant Stronge John husbandman 599163 599163 Stronge, John, of St Austell, husbandman 2
4068562 2049043 2049043 defendant Baron William husbandman 599163 599163 Baron, William, of St Austell, husbandman 3
4068564 2049044 2049044 defendant James William husbandman 599163 599163 James, William, of St Austell, husbandman 0
4068565 2049044 2049044 defendant Pynche Robert husbandman 599163 599163 Pynche, Robert, of St Austell, husbandman 1
4068566 2049044 2049044 defendant Treleven John husbandman 599163 599163 Treleven, John, of St Austell, husbandman 2
4068567 2049044 2049044 defendant Reyotte John husbandman 599163 599163 Reyotte, John, of St Austell, husbandman 3
4068727 2049103 2049103 plaintiff Laa Nicholas husbandman 599163 599163 Laa, Nicholas, of St Austell, husbandman 0
4134879 2072796 2072796 defendant Ivye William husbandman 599163 599163 Ivye, William, of St Austell, husbandman 0
4134880 2072796 2072796 defendant Knyght Edward husbandman 599163 599163 Knyght, Edward, of St Austell, husbandman 1
4180333 2088601 2088601 defendant Carlyan John husbandman 599163 599163 Carlyan, John, of St Austell, husbandman 0
4197446 2094663 2094663 defendant Menhers Mathew husbandman 599163 599163 Menhers, Mathew, of St Austell, husbandman 0
4297184 2129095 2129095 defendant Dallamayne Richard gent 599163 599163 Dallamayne, Richard, of St Austell, gent 0
4300080 2130125 2130125 defendant Taylor Thomas yeoman 599163 599163 Taylor, Thomas, of St Austell, yeoman 0
4368033 2153620 2153620 defendant Dallemeane Richard yeoman 599163 599163 Dallemeane, Richard, of St Austell, yeoman 0
4399607 2164457 2164457 defendant Tonkyn Richard husbandman 599163 599163 Tonkyn, Richard, of St Austell, husbandman 0
4489284 2197368 2197368 defendant Wysa Alice   599163 599163 Wysa, Alice, of St Austell 3
4525398 2208279 2208279 defendant Smyth Philip   599163 599163 Smyth, Philip, of St Austell 13
4525768 2208363 2208363 defendant Burglas Richard   599163 599163 Burglas, Richard, of St Austell 1
4620732 2237467 2237467 defendant Juyll John   599163 599163 Juyll, John, of St Austell, vicar 5
4659056 2248701 2248701 defendant Nicoll John tinner 599163 599163 Nicoll, John, of St Austell, tinner 5
4684012 2260608 2260608 defendant Kyttowe William   599163 599163 Kyttowe, William, of St Austell, mason 2
4702318 2266134 2266134 defendant Bocher Odo   599163 599163 Bocher, Odo, of St Austell, tin miner 0
4732524 2275347 2275347 defendant Irys Richard   599163 599163 Irys, Richard, of St Austell, mill ward 1
4733743 2275735 2275735 defendant Stout John   599163 599163 Stout, John, of St Austell, mill ward 0
4830763 2305649 2305649 defendant Sage Philip merchant 599163 599163 Sage, Philip, of St Austell, merchant 3
4886909 2322758 2322758 defendant Porth Philip husbandman 599163 599163 Porth, Philip, of St Austell, husbandman 0
4886910 2322758 2322758 defendant Kyllygren or Kyllygreu John husbandman 599163 599163 Kyllygren or Kyllygreu, John, of St Austell, husbandman 1
4915869 2331458 2331458 defendant Pya William husbandman 599163 599163 Pya, William, of St Austell, husbandman 1
4941067 2339227 2339227 defendant Pya William husbandman 599163 599163 Pya, William, of St Austell, husbandman 1
4970851 2348224 2348224 defendant Jakhopkyn Thomas tinner 599163 599163 Jakhopkyn, Thomas, of St Austell, tinner 0
4970852 2348224 2348224 defendant Jakhopkyn John gent 599163 599163 Jakhopkyn, John, of St Austell, gent 1
4982509 2351686 2351686 defendant Tresythny Richard gent 599163 599163 Tresythny, Richard, of St Austell, gent 2
5097736 2385762 2385762 defendant Cornnayll John gent 599163 599163 Cornnayll, John, of St Austell, gent 0
5102890 2387266 2387266 defendant Heenkyn John baker 599163 599163 Heenkyn, John, of St Austell, baker 0
5102891 2387266 2387266 defendant Panter John husbandman 599163 599163 Panter, John, of St Austell, husbandman 1
5111943 2389882 2389882 defendant Hogge John fisher 599163 599163 Hogge, John, of St Austell, fisher 0
5111944 2389882 2389882 defendant Mason Gervase   599163 599163 Mason, Gervase, of St Austell, mason 1
5128969 2394958 2394958 defendant Speare John tailor 599163 599163 Speare, John, of St Austell, tailor 1
5148159 2400607 2400607 defendant Speare John tailor 599163 599163 Speare, John, of St Austell, tailor 1
5183129 2410806 2410806 defendant Speare John tailor 599163 599163 Speare, John, of St Austell, tailor 1
5225746 2423200 2423200 defendant Bleyden Henry yeoman 599163 599163 Bleyden, Henry, of St Austell, yeoman 1
5267996 2435753 2435753 defendant Gunhithe John yeoman 599163 599163 Gunhithe, John, of St Austell, yeoman 0
5267997 2435753 2435753 defendant Restourek John gent 599163 599163 Restourek, John, of St Austell, gent 1
5276085 2438080 2438080 defendant Harry John, junior husbandman 599163 599163 Harry, John, junior, of St Austell, husbandman 3
5370300 2466299 2466299 defendant Trouson Peter husbandman 599163 599163 Trouson, Peter, of St Austell, husbandman 4
5375764 2468014 2468014 defendant Denys Thomas clerk 599163 599163 Denys, Thomas, of St Austell, clerk 0
5388109 2471658 2471658 defendant Tronson Peter husbandman 599163 599163 Tronson, Peter, of St Austell, husbandman 1
5413740 2479036 2479036 defendant Trevison Peter husbandman 599163 599163 Trevison, Peter, of St Austell, husbandman 4
5476459 2497961 2497961 defendant Tomwalter John husbandman 599163 599163 Tomwalter, John, of St Austell, husbandman 1
5476460 2497961 2497961 defendant Tromson Peter husbandman 599163 599163 Tromson, Peter, of St Austell, husbandman 2
5480695 2499189 2499189 defendant Denyok William gent 599163 599163 Denyok, William, of St Austell, gent 0
5483807 2500101 2500101 defendant Auryan John husbandman 599163 599163 Auryan, John, of St Austell, husbandman 0
5487689 2501208 2501208 defendant Gower Thomas husbandman 599163 599163 Gower, Thomas, of St Austell, husbandman 0
5487690 2501208 2501208 defendant Marche Stephen husbandman 599163 599163 Marche, Stephen, of St Austell, husbandman 1
5487691 2501208 2501208 defendant Pascowe John husbandman 599163 599163 Pascowe, John, of St Austell, husbandman 2
5493382 2502936 2502936 defendant Harrys William husbandman 599163 599163 (Harrys, William, of St Austell, husbandman 6
5493389 2502937 2502937 defendant Harrys William husbandman 599163 599163 (Harrys, William, of St Austell, husbandman 1
5504346 2506274 2506274 defendant Rous Andrew husbandman 599163 599163 Rous, Andrew, of St Austell, husbandman 0
5506348 2506896 2506896 defendant Wyse Philip yeoman 599163 599163 Wyse, Philip, of St Austell, yeoman 2
5506366 2506902 2506902 defendant Wyse Philip husbandman 599163 599163 Wyse, Philip, of St Austell, husbandman 0
5506367 2506902 2506902 defendant Wyse Michael husbandman 599163 599163 Wyse, Michael, of St Austell, husbandman 1
5517206 2510215 2510215 defendant Denyok William gent 599163 599163 Denyok, William, of St Austell, gent 0
5552428 2520763 2520763 defendant Uryn William clerk 599163 599163 Uryn, William, of St Austell, clerk 0
5571641 2526261 2526261 defendant Newehall Robert gent 599163 599163 Newehall, Robert, of St Austell, gent 2
5606495 2536921 2536921 defendant Pridias Richard laborer 599163 599163 Pridias, Richard, of St Austell, laborer 0

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