names

157 rows where place_id = 599869

✎ 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
3638604 1906888 1906888 defendant Pendyne John yeoman 599869 599869 Pendyne, John, of Lostwythyell, yeoman 0
3639314 1907106 1907106 defendant Toker Stephen husbandman 599869 599869 Toker, Stephen, of Lostwythyell, husbandman 0
3639641 1907206 1907206 defendant Menwennek Edward gent 599869 599869 Menwennek, Edward, of Lostwythyell, gent 0
3639643 1907207 1907207 defendant Menwennek Edward gent 599869 599869 Menwennek, Edward, of Lostwythyell, gent 0
3655858 1912086 1912086 defendant Michell Thomas (legal representative) 599869 599869 Thomas Michell, of Lostwythyell, executors of 0
3655859 1912086 1912086 defendant Kendall Henry   599869 599869 (Kendall, Henry, of Lostwythyell, frankelyn 1
3666272 1915398 1915398 defendant Hobbe William yeoman 599869 599869 Hobbe, William, of Lostwythyell, yeoman 1
3667612 1915814 1915814 defendant Wylstreme John tanner 599869 599869 Wylstreme, John, of Lostwythyell, tanner 0
3667613 1915814 1915814 defendant Porter William yeoman 599869 599869 Porter, William, of Lostwythyell, yeoman 1
3831996 1967905 1967905 defendant Weryson Peter clerk 599869 599869 Weryson, Peter, of Lostwythyell, clerk 0
3865258 1978589 1978589 defendant Waye William yeoman 599869 599869 Waye, William, of Lostwythyell, yeoman 0
3877016 1982553 1982553 defendant Fanston or Fauston John mercer 599869 599869 Fanston or Fauston, John, of Lostwythyell, mercer 0
3877018 1982554 1982554 defendant Fanston John mercer 599869 599869 Fanston, John, of Lostwythyell, mercer 0
3887522 1986081 1986081 defendant Waye William mercer 599869 599869 Waye, William, of Lostwythyell, mercer 0
3887523 1986081 1986081 defendant Pendyne John yeoman 599869 599869 Pendyne, John, of Lostwythyell, yeoman 1
3887524 1986081 1986081 defendant Gebyn William glover 599869 599869 Gebyn, William, of Lostwythyell, glover 2
3887525 1986081 1986081 defendant Talleck Nicholas clerk 599869 599869 Talleck, Nicholas, of Lostwythyell, clerk 3
3887526 1986081 1986081 defendant Chemowe Richard baker 599869 599869 Chemowe, Richard, of Lostwythyell, baker 4
3887527 1986081 1986081 defendant Jago John husbandman 599869 599869 Jago, John, of Lostwythyell, husbandman 5
3887528 1986081 1986081 defendant Watt John sherman 599869 599869 Watt, John, of Lostwythyell, sherman 6
3887529 1986081 1986081 defendant Tpnkyn Ralph mercer 599869 599869 Tpnkyn, Ralph, of Lostwythyell, mercer 7
3887530 1986081 1986081 defendant Rawlon Henry husbandman 599869 599869 Rawlon, Henry, of Lostwythyell, husbandman 8
3887531 1986081 1986081 defendant La John smith 599869 599869 La, John, of Lostwythyell,smith 9
3887791 1986176 1986176 defendant Helyer William potter 599869 599869 Helyer, William, of Lostwythyell, potter 0
3887792 1986176 1986176 defendant Tonkyn Ralph mercer 599869 599869 Tonkyn, Ralph, of Lostwythyell, mercer 1
3887793 1986176 1986176 defendant Cripps Thomas tailor 599869 599869 Cripps, Thomas, of Lostwythyell, tailor 2
3887795 1986176 1986176 defendant Gevyn William glover 599869 599869 Gevyn, William, of Lostwythyell, glover 4
3887796 1986176 1986176 defendant Taleck Nicholas clerk 599869 599869 Taleck, Nicholas, of Lostwythyell, clerk 5
3887797 1986176 1986176 defendant Jago John tinner 599869 599869 Jago, John, of Lostwythyell, tinner 6
3887798 1986176 1986176 defendant Hobbe William potter 599869 599869 Hobbe, William, of Lostwythyell, potter 7
3887799 1986176 1986176 defendant Rawlyn Henry tanner 599869 599869 Rawlyn, Henry, of Lostwythyell, tanner 8
3887800 1986176 1986176 defendant Nans Thomas smith 599869 599869 Nans, Thomas, of Lostwythyell, smith 9
3887801 1986176 1986176 defendant Peryn William laborer 599869 599869 Peryn, William, of Lostwythyell, laborer 10
3887802 1986176 1986176 defendant La John smith 599869 599869 La, John, of Lostwythyell, smith 11
3887803 1986176 1986176 defendant Goodman John laborer 599869 599869 Goodman, John, of Lostwythyell, laborer 12
3887804 1986176 1986176 defendant Dyer Henry yeoman 599869 599869 Dyer, Henry, of Lostwythyell, yeoman 13
3887805 1986176 1986176 defendant Brytten Nicholas smith 599869 599869 Brytten, Nicholas, of Lostwythyell, smith 14
3887806 1986176 1986176 defendant Alan Henry weaver 599869 599869 Alan, Henry, of Lostwythyell, weaver 15
3887808 1986177 1986177 defendant Waye William mercer 599869 599869 Waye, William, of Lostwythyell, mercer 0
3887809 1986177 1986177 defendant Crokyer alias Brand Edward mercer 599869 599869 Crokyer alias Brand, Edward, of Lostwythyell, mercer 1
3887810 1986177 1986177 defendant Gyllett William tanner 599869 599869 Gyllett, William, of Lostwythyell, tanner 2
3887811 1986177 1986177 defendant Cryppes Robert tanner 599869 599869 Cryppes, Robert, of Lostwythyell, tanner 3
3891810 1987514 1987514 defendant Crokyer alias Brand Edward mercer 599869 599869 Crokyer alias Brand, Edward, of Lostwythyell, mercer 0
3891811 1987514 1987514 defendant Tonkyn Ralph mercer 599869 599869 Tonkyn, Ralph, of Lostwythyell, mercer 1
3891812 1987514 1987514 defendant Helyar alias Mayowe John yeoman 599869 599869 Helyar alias Mayowe, John, of Lostwythyell, yeoman 2
3891813 1987514 1987514 defendant Fanston John mercer 599869 599869 Fanston, John, of Lostwythyell, mercer 3
3891814 1987514 1987514 defendant Tonkyn alias Thomas John husbandman 599869 599869 Tonkyn alias Thomas, John, of Lostwythyell, husbandman 4
3891815 1987514 1987514 defendant Huchyn alias Hugh Richard yeoman 599869 599869 Huchyn alias Hugh, Richard, of Lostwythyell, yeoman 5
3891816 1987514 1987514 defendant Wacom John husbandman 599869 599869 Wacom, John, of Lostwythyell, husbandman 6
3891817 1987514 1987514 defendant Pendyne John yeoman 599869 599869 Pendyne, John, of Lostwythyell, yeoman 7
3891818 1987514 1987514 defendant Slepe John husbandman 599869 599869 Slepe, John, of Lostwythyell, husbandman 8
3893401 1988025 1988025 defendant Bryand alias Crokyer Edward   599869 599869 Bryand alias Crokyer, Edward, of Lostwythyell, yeoman, warden of stannery gaol 0
3959887 2010551 2010551 defendant Govell Thomas pewterer 599869 599869 Govell, Thomas, of Lostwythyell, pewterer 1
3959888 2010551 2010551 defendant Allen Thomas miiler 599869 599869 Allen, Thomas, of Lostwythyell, miiler 2
4011115 2028747 2028747 defendant Swete John gent 599869 599869 Swete, John, of Lostwythyell, gent 3
4033118 2036494 2036494 defendant Pecott Michael glover 599869 599869 Pecott, Michael, of Lostwythyell, glover 2
4033119 2036494 2036494 defendant Pytt William weaver 599869 599869 Pytt, William, of Lostwythyell, weaver 3
4048969 2042074 2042074 defendant Hellyar alias Mayowe John yeoman 599869 599869 Hellyar alias Mayowe, John, of Lostwythyell, yeoman 0
4048970 2042074 2042074 defendant Gybbes Robert husbandman 599869 599869 Gybbes, Robert, of Lostwythyell, husbandman 1
4068230 2048937 2048937 defendant Meye alias Hellyar John gent 599869 599869 Meye alias Hellyar, John, of Lostwythyell, gent 0
4077838 2052373 2052373 defendant Tewsen Remand gent 599869 599869 Tewsen, Remand, of Lostwythyell, gent 1
4077839 2052373 2052373 defendant Butterd Francis husbandman 599869 599869 Butterd, Francis, of Lostwythyell, husbandman 2
4250484 2113148 2113148 defendant Kendall Thomas esq 599869 599869 Kendall, Thomas, of Lostwythyell, esq 2
4264720 2117842 2117842 defendant Kendall William (legal representative) 599869 599869 Kendall, William, of Lostwythyell, esq, executor of 1
4479485 2194240 2194240 defendant Umfrey Roger   599869 599869 Umfrey, Roger, of lostwythyell 0
4529672 2209563 2209563 defendant Quynt John   599869 599869 Quynt, John, of Lostwythyell 0
4542985 2213699 2213699 defendant Bellyetter John   599869 599869 Bellyetter, John, of Lostwythyell 4
4624352 2238595 2238595 defendant Tynner Thomas   599869 599869 Tynner, Thomas, of Lostwythyell 2
4624356 2238596 2238596 defendant Tynner Thomas   599869 599869 Tynner, Thomas, of Lostwythyell 2
4662018 2249596 2249596 defendant Vyvyan John yeoman 599869 599869 Vyvyan, John, of Lostwythyell, yeoman 6
4667038 2255421 2255421 defendant Dey John gent 599869 599869 Dey, John, of Lostwythyell, gent 0
4669238 2256084 2256084 defendant Hikka John baker 599869 599869 Hikka, John, of Lostwythyell, baker 0
4678052 2258745 2258745 defendant Bagge Roger sadler 599869 599869 Bagge, Roger, of Lostwythyell, sadler 0
4678053 2258745 2258745 defendant Groke William husbandman 599869 599869 Groke, William, of Lostwythyell, husbandman 1
4682475 2260143 2260143 defendant Pery John smith 599869 599869 Pery, John, of Lostwythyell, smith 0
4682476 2260143 2260143 defendant Laury Edward clerk 599869 599869 with Laury, Edward, of Lostwythyell, clerk 1
4684008 2260607 2260607 defendant Bonok or Bovok Richard merchant 599869 599869 Bonok or Bovok, Richard, of Lostwythyell, merchant 0
4689014 2262122 2262122 defendant Barthe John   599869 599869 Barthe, John, of Lostwythyell, bailiff servant 0
4703475 2266470 2266470 defendant Bagge Roger sadler 599869 599869 Bagge, Roger, of Lostwythyell, sadler 0
4703476 2266470 2266470 defendant Greke William husbandman 599869 599869 Greke, William, of Lostwythyell, husbandman 1
4703963 2266617 2266617 defendant Tomma Joan widow 599869 599869 Tomma, Joan, of Lostwythyell, widow 3
4703964 2266617 2266617 defendant Wynchelsee Thomas baker 599869 599869 Wynchelsee, Thomas, of Lostwythyell, baker 4
4703966 2266617 2266617 defendant Amys Nicholas draper 599869 599869 Amys, Nicholas, of Lostwythyell, draper 6
4705758 2267173 2267173 defendant Padarda Roger sadler or sawyer 599869 599869 Padarda, Roger, of Lostwythyell, sadler or sawyer 0
4714611 2269902 2269902 defendant Barthe John   599869 599869 Barthe, John, of Lostwythyell, bailiff ferrant 0
4714662 2269917 2269917 defendant Tomma John smith 599869 599869 Tomma, John, of Lostwythyell, smith 3
4714669 2269918 2269918 defendant Barthe John yeoman 599869 599869 Barthe, John, of Lostwythyell, yeoman 3
4714691 2269923 2269923 defendant Vyvyan John husbandman 599869 599869 Vyvyan, John, of Lostwythyell, husbandman 2
4735441 2276230 2276230 defendant Hervy Richard husbandman 599869 599869 Hervy, Richard, of Lostwythyell, husbandman 0
4736976 2276693 2276693 defendant Hykedon John husbandman 599869 599869 Hykedon, John, of Lostwythyell, husbandman 1
4737141 2276733 2276733 defendant Trelartha John yeoman 599869 599869 Trelartha, John, of Lostwythyell, yeoman 0
4737143 2276734 2276734 defendant Barthe John   599869 599869 Barthe, John, of Lostwythyell, bailiff errant 0
4737199 2276754 2276754 defendant Hervy Richard husbandman 599869 599869 Hervy, Richard, of Lostwythyell, husbandman 0
4755584 2282127 2282127 defendant Vyvyan Joahn brewer 599869 599869 Vyvyan, Joahn, of Lostwythyell, brewer 0
4764386 2284853 2284853 defendant Doncke (illegible) gent 599869 599869 Doncke, _, of Lostwythyell, gent 0
4790699 2293178 2293178 defendant Bille John butcher 599869 599869 Bille, John, of Lostwythyell, butcher 1
4794385 2294389 2294389 defendant Bonok Richard gent 599869 599869 Bonok, Richard, of Lostwythyell, gent 0
4794602 2294452 2294452 defendant Rawe William merchant 599869 599869 Rawe, William, of Lostwythyell, merchant 0
4827574 2304673 2304673 defendant Permeray John fuller 599869 599869 Permeray, John, of Lostwythyell, fuller 0
4845492 2310104 2310104 defendant Mathy Walter mariner 599869 599869 Mathy, Walter, of Lostwythyell, mariner 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);