names

103 rows where place_id = 587862

✎ 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
3592659 1865318 1865318 defendant Baron Nicholas chapman 587862 587862 Baron, Nicholas, of Bodmyn, Cornw, chapman 0
3608453 1870305 1870305 defendant Richard John mercer 587862 587862 Richard, John, of Bodmyn, Cornw, mercer 0
3650833 1910625 1910625 defendant Sagemore William merchant 587862 587862 Sagemore, William, of Bodmyn, Cornw, merchant 0
3680135 1919856 1919856 defendant Escote John tanner 587862 587862 Escote, John, of Bodmyn, Cornw, tanner 3
3700043 1926246 1926246 defendant Wattys Richard tinner 587862 587862 Wattys, Richard, of Bodmyn, Cornw, tinner 0
3714266 1930760 1930760 defendant Lavedwyn John gent 587862 587862 Lavedwyn, John, of Bodmyn, Cornw, gent 0
3721386 1932997 1932997 defendant Trote Thomas gent 587862 587862 Trote, Thomas, of Bodmyn, Cornw, gent 0
3737350 1937919 1937919 defendant Trote Thomas gent 587862 587862 Trote, Thomas, of Bodmyn, Cornw, gent 0
3929619 2000255 2000255 defendant Corant Richard yeoman 587862 587862 Corant, Richard, of Bodmyn, Cornw, yeoman 0
3951096 2007450 2007450 defendant Coryn Richard gent 587862 587862 Coryn, Richard, of Bodmyn, Cornw, gent 0
3956081 2009196 2009196 defendant Hartwyll Robert bookbinder 587862 587862 Hartwyll, Robert, of Bodmyn, Cornw, bookbinder 0
3956085 2009197 2009197 defendant Morcombe William yeoman 587862 587862 Morcombe, William, of Bodmyn, Cornw, yeoman 0
3995214 2023029 2023029 defendant Sadler William yeoman 587862 587862 Sadler, William, of Bodmyn, Cornw, yeoman 1
4111721 2064441 2064441 defendant Clake or Blake Richard hatter 587862 587862 Clake or Blake, Richard, of Bodmyn, Cornw, yeoman, hatter 0
4115691 2065897 2065897 defendant Warde Henry chapman 587862 587862 Warde, Henry, of Bodmyn, Cornw, yeoman, chapman 0
4115695 2065898 2065898 defendant Hackworthye Richard yeoman 587862 587862 Hackworthye, Richard, of Bodmyn, Cornw, yeoman 0
4127433 2070102 2070102 defendant Hollins or Helling William gent 587862 587862 Hollins or Helling, William, of Bodmyn, Cornw, gent 0
4132618 2071988 2071988 defendant Torney William chapman 587862 587862 Torney, William, of Bodmyn, Cornw, chapman 0
4157055 2080546 2080546 defendant Knyghte William   587862 587862 Knyghte, William, of Bodmyn, Cornw, point maker 0
4162799 2082541 2082541 defendant Opy Thomas gent 587862 587862 Opy, Thomas, of Bodmyn, Cornw, gent 15
4181058 2088849 2088849 defendant Knighte William   587862 587862 Knighte, William, of Bodmyn, Cornw, point maker 0
4204442 2097101 2097101 defendant Knyghte William   587862 587862 Knyghte, William, of Bodmyn, Cornw, point maker 0
4210195 2099127 2099127 defendant Tompson George haberdasher 587862 587862 Tompson, George, of Bodmyn, Cornw, haberdasher 0
4256158 2115040 2115040 defendant Coxe Thomas gent 587862 587862 Coxe, Thomas, of Bodmyn, Cornw, gent 0
4256938 2115293 2115293 defendant Walker Jerome gent 587862 587862 Walker, Jerome, of Bodmyn, Cornw, gent 3
4299749 2129995 2129995 defendant Mychell Richard yeoman 587862 587862 Mychell, Richard, of Bodmyn, Cornw, yeoman 0
4322234 2137850 2137850 defendant Turney William chapman 587862 587862 Turney, William, of Bodmyn, Cornw, chapman 0
4324881 2138706 2138706 defendant Mapowder George vintner 587862 587862 Mapowder, George, of Bodmyn, Cornw, vintner 0
4330276 2140429 2140429 defendant Marshall Digory chapman 587862 587862 Marshall, Digory, of Bodmyn, Cornw, chapman 0
4349734 2147168 2147168 defendant Marshall Digory merchant 587862 587862 Marshall, Digory, of Bodmyn, Cornw, merchant 0
4363108 2151869 2151869 defendant Blighe John, senior gent 587862 587862 Blighe, John, senior, of Bodmyn, Cornw, gent 0
4369243 2154062 2154062 defendant Marshall Digory chapman 587862 587862 Marshall, Digory, of Bodmyn, Cornw, chapman 0
4369245 2154063 2154063 defendant Marshall Digory chapman 587862 587862 Marshall, Digory, of Bodmyn, Cornw, chapman 0
4380352 2158078 2158078 defendant Marshall Digory chapman 587862 587862 Marshall, Digory, of Bodmyn, Cornw, chapman 1
4385335 2159786 2159786 defendant Marshall Digory chapman 587862 587862 Marshall, Digory, of Bodmyn, Cornw, chapman 0
4398318 2164018 2164018 defendant Blighte John gent 587862 587862 Blighte, John, of Bodmyn, Cornw, gent 1
4401300 2165030 2165030 defendant Turney William merchant 587862 587862 Turney, William, of Bodmyn, Cornw, merchant 0
4658213 2248449 2248449 defendant Baudewyn William chapman 587862 587862 Baudewyn, William, of Bodmyn, Cornw, chapman 1
4659081 2248709 2248709 defendant Baudyn William   587862 587862 Baudyn, William, of Bodmyn, Cornw 0
4662747 2249806 2249806 defendant Trevelowe John chapman 587862 587862 together with Trevelowe, John, of Bodmyn, Cornw, chapman 2
4670967 2256589 2256589 defendant Symond John chapman 587862 587862 Symond, John, of Bodmyn, Cornw, chapman 1
4727285 2273787 2273787 defendant Rawe Thomas mercer 587862 587862 Rawe, Thomas, of Bodmyn, Cornw, mercer 0
4727289 2273789 2273789 defendant Richard Stephen merchant 587862 587862 Richard, Stephen, of Bodmyn, Cornw, merchant 0
4786874 2291955 2291955 defendant Wydell John goldsmith 587862 587862 Wydell, John, of Bodmyn, Cornw, goldsmith 0
4786880 2291956 2291956 defendant Wydell John goldsmith 587862 587862 Wydell, John, of Bodmyn, Cornw, goldsmith 4
4798215 2295637 2295637 defendant Broun Thomas chapman 587862 587862 Broun, Thomas, of Bodmyn, Cornw, chapman 0
4798850 2295814 2295814 defendant Rawe Thomas mercer 587862 587862 Rawe, Thomas, of Bodmyn, Cornw, mercer 0
4798852 2295815 2295815 defendant Rawe Thomas mercer 587862 587862 Rawe, Thomas, of Bodmyn, Cornw, mercer 0
4818665 2301921 2301921 defendant Brasyer Thomas yeoman 587862 587862 Brasyer, Thomas, of Bodmyn, Cornw, yeoman 0
4861288 2314897 2314897 defendant Bille or Bilbe John gent 587862 587862 Bille or Bilbe, John, of Bodmyn, Cornw, gent 0
4861293 2314898 2314898 defendant Bille John gent 587862 587862 Bille, John, of Bodmyn, Cornw, gent 0
4863491 2315552 2315552 defendant Peyntour John merchant 587862 587862 Peyntour, John, of Bodmyn, Cornw, merchant 1
4863494 2315553 2315553 defendant Peyntour John merchant 587862 587862 Peyntour, John, of Bodmyn, Cornw, merchant 1
4863894 2315683 2315683 defendant Broun Richard (legal representative) 587862 587862 Broun, Richard, of Bodmyn, Cornw, executrix of 0
4863897 2315684 2315684 defendant Broun Richard (legal representative) 587862 587862 Broun, Richard, of Bodmyn, Cornw, executrix of 0
4871838 2318162 2318162 defendant Budde John merchant 587862 587862 Budde, John, of Bodmyn, Cornw, merchant 0
4904066 2327887 2327887 defendant Body Thomas yeoman 587862 587862 Body, Thomas, of Bodmyn, Cornw, yeoman 0
4913000 2330563 2330563 defendant Gibbe John chapman 587862 587862 Gibbe, John, of Bodmyn, Cornw, chapman 1
4913045 2330575 2330575 defendant Byllys John esq 587862 587862 Byllys, John, of Bodmyn, Cornw, esq 1
4932694 2336615 2336615 defendant Broun Thomas merchant 587862 587862 Broun, Thomas, of Bodmyn, Cornw, merchant 0
4961765 2345481 2345481 defendant Bylle John   587862 587862 Bylle, John, of Bodmyn, Cornw 0
4968107 2347409 2347409 defendant Baron Thomas gent 587862 587862 Baron, Thomas, of Bodmyn, Cornw, gent 1
4968111 2347410 2347410 defendant Baron Thomas gent 587862 587862 Baron, Thomas, of Bodmyn, Cornw, gent 1
4979062 2350695 2350695 defendant Huntyngdon Peter gent 587862 587862 Huntyngdon, Peter, of Bodmyn, Cornw, gent 6
4979070 2350696 2350696 defendant Huntyngdon Peter gent 587862 587862 Huntyngdon, Peter, of Bodmyn, Cornw, gent 6
4979281 2350762 2350762 defendant Byll John esq 587862 587862 Byll, John, of Bodmyn, Cornw, esq 2
4979289 2350764 2350764 defendant Byll John esq 587862 587862 Byll, John, of Bodmyn, Cornw, esq 2
4990885 2354165 2354165 defendant Bylle John esq 587862 587862 Bylle, John, of Bodmyn, Cornw, esq 0
4995242 2355425 2355425 defendant Lanhergy Thomas gent 587862 587862 Lanhergy, Thomas, of Bodmyn, Cornw, gent 1
5011519 2360237 2360237 plaintiff Withyel John goldsmith 587862 587862 Withyel, John, of Bodmyn, Cornw, goldsmith 0
5020187 2362793 2362793 defendant Southray William lorimer 587862 587862 Southray, William, of Bodmyn, Cornw, lorimer 2
5083298 2381505 2381505 defendant Byll John, senior weaver 587862 587862 Byll, John, senior, of Bodmyn, Cornw, weaver 0
5083922 2381694 2381694 defendant Trote Thomas yeoman 587862 587862 Trote, Thomas, of Bodmyn, Cornw, yeoman 0
5107335 2388575 2388575 defendant Pole Henry skinner 587862 587862 Pole, Henry, of Bodmyn, Cornw, skinner 0
5107337 2388576 2388576 defendant Pole Henry skinner 587862 587862 Pole, Henry, of Bodmyn, Cornw, skinner 0
5135151 2396780 2396780 defendant Naufan James gent 587862 587862 Naufan, James, of Bodmyn, Cornw, gent 1
5140980 2398482 2398482 defendant Stapulton alias Daunce John chapman 587862 587862 Stapulton alias Daunce, John, of Bodmyn, Cornw, chapman 1
5223512 2422568 2422568 defendant Trotte Bartholomew chapman 587862 587862 Trotte, Bartholomew, of Bodmyn, Cornw, chapman 1
5242057 2427880 2427880 defendant Cok John chapman 587862 587862 Cok, John, of Bodmyn, Corn, chapman 0
5250772 2430352 2430352 defendant Colyn Odo esq 587862 587862 Colyn, Odo, of Bodmyn, Cornw, esq 0
5250777 2430353 2430353 defendant Colyn Odo esq 587862 587862 Colyn, Odo, of Bodmyn, Cornw, esq 1
5263379 2434294 2434294 defendant Jenyn Thomas chaplain 587862 587862 Jenyn, Thomas, of Bodmyn, Cornw, chaplain 1
5277032 2438365 2438365 defendant Melyonek Nicholas yeoman 587862 587862 Melyonek, Nicholas, of Bodmyn, Cornw, yeoman 0
5278013 2438655 2438655 defendant Welton Thomas   587862 587862 Welton, Thomas, of Bodmyn, Cornw, tin merchant 1
5296559 2443983 2443983 defendant Watton Thomas chapman 587862 587862 Watton, Thomas, of Bodmyn, Cornw, chapman 0
5296564 2443984 2443984 defendant Watton Thomas chapman 587862 587862 Watton, Thomas, of Bodmyn, Cornw, chapman 0
5313269 2449005 2449005 defendant Wattys John chapman 587862 587862 Wattys, John, of Bodmyn, Cornw, chapman 3
5319284 2450861 2450861 defendant Watta John merchant 587862 587862 Watta, John, of Bodmyn, Cornw, merchant 0
5326655 2453041 2453041 defendant Cok John mercer 587862 587862 Cok, John, of Bodmyn, Cornw, mercer 0
5347050 2459233 2459233 defendant Cok William yeoman 587862 587862 Cok, William, of Bodmyn, Cornw, yeoman 2
5350455 2460263 2460263 defendant Bere John gent 587862 587862 Bere, John, of Bodmyn, Cornw, gent 4
5445541 2488563 2488563 defendant Melionek Nicholas gent 587862 587862 Melionek, Nicholas, of Bodmyn, Cornw, gent 0
5450542 2490045 2490045 defendant Jenyns Thomas chaplain 587862 587862 Jenyns, Thomas, of Bodmyn, Cornw, chaplain 0
5493692 2503025 2503025 defendant Cokke William husbandman 587862 587862 Cokke, William, of Bodmyn, Cornw, husbandman 0
5510909 2508252 2508252 defendant Harry Stephen yeoman 587862 587862 Harry, Stephen, of Bodmyn, Cornw, yeoman 2
5513895 2509197 2509197 defendant Tankerd John clerk 587862 587862 Tankerd, John, of Bodmyn, Cornw, clerk 3
5527919 2513297 2513297 defendant Newhall John yeoman 587862 587862 Newhall, John, of Bodmyn, Cornw, yeoman 0
5545832 2518771 2518771 defendant Baron Nicholas chapman 587862 587862 Baron, Nicholas, of Bodmyn, Cornw, chapman 0
5545850 2518776 2518776 defendant Baron Nicholas chapman 587862 587862 Baron, Nicholas, of Bodmyn, Cornw, chapman 1
5549756 2519960 2519960 defendant Sawegemore William merchant 587862 587862 Sawegemore, William, of Bodmyn, Cornw, merchant 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);