names

117 rows where place_id = 592010

✎ 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
3606297 1869638 1869638 defendant Yeo Nicholas esq 592010 592010 Yeo, Nicholas, of Hatherlegh, esq 0
3619825 1873776 1873776 defendant Baggetor Thomas yeoman 592010 592010 Baggetor, Thomas, of Hatherlegh, yeoman 1
3619827 1873777 1873777 defendant Bakketor Thomas yeoman 592010 592010 Bakketor, Thomas, of Hatherlegh, yeoman 0
3623151 1874762 1874762 defendant Toker William husbandman 592010 592010 Toker, William, of Hatherlegh, husbandman 4
3636209 1906114 1906114 defendant Pylestrete Thomas husbandman 592010 592010 Pylestrete, Thomas, of Hatherlegh, husbandman 0
3648634 1909960 1909960 defendant Chugge William husbandman 592010 592010 Chugge, William, of Hatherlegh, husbandman 2
3652272 1911049 1911049 defendant Haysed John carpenter 592010 592010 Haysed, John, of Hatherlegh, carpenter 0
3654539 1911680 1911680 defendant Thorne John   592010 592010 Thorne, John, of Hatherlegh, groom 4
3699711 1926136 1926136 defendant Ratynbery John husbandman 592010 592010 Ratynbery, John, of Hatherlegh, husbandman 0
3739826 1938673 1938673 defendant Monke John gent 592010 592010 Monke, John, of Hatherlegh, gent 0
3796403 1956744 1956744 plaintiff Efford John   592010 592010 Efford, John, of Hatherlegh 0
3827531 1966474 1966474 defendant Kelly Oliver gent 592010 592010 Kelly, Oliver, of Hatherlegh, gent 0
3827532 1966474 1966474 defendant Gruggeworthy John husbandman 592010 592010 Gruggeworthy, John, of Hatherlegh, husbandman 1
3827533 1966474 1966474 defendant Harrys Vincent husbandman 592010 592010 Harrys, Vincent, of Hatherlegh, husbandman 2
3867276 1979289 1979289 defendant Haysyde Henry husbandman 592010 592010 Haysyde, Henry, of Hatherlegh, husbandman 0
3916539 1995906 1995906 defendant Rede William husbandman 592010 592010 Rede, William, of Hatherlegh, husbandman 0
3964410 2012157 2012157 defendant Locke John husbandman 592010 592010 Locke, John, of Hatherlegh, husbandman 0
3964415 2012158 2012158 defendant Lock John husbandman 592010 592010 Lock, John, of Hatherlegh, husbandman 1
3971018 2014420 2014420 defendant Mounckligh John weaver 592010 592010 Mounckligh, John, of Hatherlegh, weaver 2
3974694 2015717 2015717 defendant Mounckligh John weaver 592010 592010 Mounckligh, John, of Hatherlegh, weaver 1
4041670 2039509 2039509 defendant Clercke John tailor 592010 592010 Clercke, John, of Hatherlegh, tailor 12
4041671 2039509 2039509 defendant Stowell John gent 592010 592010 Stowell, John, of Hatherlegh, gent 13
4515047 2205116 2205116 defendant Aleyn John   592010 592010 Aleyn, John, of Hatherlegh 0
4596248 2230077 2230077 defendant White John   592010 592010 White, John, of Hatherlegh 1
4676884 2258389 2258389 plaintiff Grey William   592010 592010 Grey, William, of Hatherlegh 0
4714582 2269890 2269890 plaintiff Treffrewe Roger (legal representative) 592010 592010 Treffrewe, Roger, of Hatherlegh, vicar, executor of 0
4714585 2269891 2269891 plaintiff (not given) Roger vicar of Trefrewe 592010 592010 Trefrewe, Roger, of Hatherlegh, vicar of the church, executor of 0
4723067 2272525 2272525 defendant Trefrewe Roger (legal representative) 592010 592010 Trefrewe, Roger, of Hatherlegh, vicar, executor of 0
4723068 2272525 2272525 defendant Hyreward Robert clerk 592010 592010 Hyreward, Robert, of Hatherlegh, clerk 1
4747498 2279773 2279773 defendant atte Clyve Richard husbandman 592010 592010 atte Clyve, Richard, of Hatherlegh, husbandman 1
4747501 2279774 2279774 defendant atte Clyve Richard husbandman 592010 592010 atte Clyve, Richard, of Hatherlegh, husbandman 1
4765633 2285241 2285241 defendant Belamy John husbandman 592010 592010 Belamy, John, of Hatherlegh, husbandman 0
4778768 2289333 2289333 defendant Body Robert husbandman 592010 592010 Body, Robert, of Hatherlegh, husbandman 4
4796193 2294959 2294959 defendant Bury John laborer 592010 592010 Bury, John, of Hatherlegh, laborer 6
4796195 2294959 2294959 defendant Best John husbandman 592010 592010 Best, John, of Hatherlegh, husbandman 8
4812273 2299955 2299955 defendant Stary Richard smith 592010 592010 Stary, Richard, of Hatherlegh, smith 0
4856502 2313414 2313414 defendant Stoyle Roger husbandman 592010 592010 Stoyle, Roger, of Hatherlegh, husbandman 0
4856503 2313414 2313414 defendant Cremell Richard husbandman 592010 592010 Cremell, Richard, of Hatherlegh, husbandman 1
4881666 2321164 2321164 defendant Southecote Richard husbandman 592010 592010 Southecote, Richard, of Hatherlegh, husbandman 0
4895295 2325187 2325187 defendant Wylly Thomas chaplain 592010 592010 Wylly, Thomas, of Hatherlegh, chaplain 0
4897664 2325934 2325934 defendant Lywer John husbandman 592010 592010 Lywer, John, of Hatherlegh, husbandman 1
4909857 2329606 2329606 defendant Bruggeworthy William husbandman 592010 592010 Bruggeworthy, William, of Hatherlegh, husbandman 0
4925753 2334490 2334490 defendant Burcy or Durcy Robert chaplain 592010 592010 Burcy or Durcy, Robert, of Hatherlegh, chaplain 0
4925754 2334490 2334490 defendant Wille Thomas   592010 592010 Wille, Thomas, of Hatherlegh, vicar 1
4931305 2336169 2336169 defendant Fynyan Henry husbandman 592010 592010 Fynyan, Henry, of Hatherlegh, husbandman 0
4956313 2343851 2343851 defendant Medelond William, junior yeoman 592010 592010 Medelond, William, junior, of Hatherlegh, yeoman 0
4956715 2343962 2343962 defendant Raddek John husbandman 592010 592010 Raddek, John, of Hatherlegh, husbandman 2
4970426 2348101 2348101 defendant Brok Thomas husbandman 592010 592010 Brok, Thomas, of Hatherlegh, husbandman 0
5025461 2364345 2364345 defendant Lewer Walter gent 592010 592010 Lewer, Walter, of Hatherlegh, gent 0
5046547 2370609 2370609 defendant Jenyn Geoffrey ostler 592010 592010 Jenyn, Geoffrey, of Hatherlegh, ostler 0
5060544 2374734 2374734 defendant Wylle Thomas clerk 592010 592010 Wylle, Thomas, of Hatherlegh, clerk 0
5060545 2374734 2374734 defendant Parker Thomas butcher 592010 592010 Parker, Thomas, of Hatherlegh, butcher 1
5060546 2374734 2374734 defendant Cok John husbandman 592010 592010 Cok, John, of Hatherlegh, husbandman 2
5060547 2374734 2374734 defendant Monkeley John carpenter 592010 592010 Monkeley, John, of Hatherlegh, carpenter 3
5060882 2374829 2374829 defendant Ratynbury Leonard yeoman 592010 592010 Ratynbury, Leonard, of Hatherlegh, yeoman 0
5078183 2379962 2379962 defendant Cook Thomas husbandman 592010 592010 Cook, Thomas, of Hatherlegh, husbandman 1
5082823 2381368 2381368 defendant Jenyn Geffrey ostler 592010 592010 Jenyn, Geffrey, of Hatherlegh, ostler 1
5082824 2381368 2381368 defendant Belamy Walter husbandman 592010 592010 Belamy, Walter, of Hatherlegh, husbandman 2
5090528 2383613 2383613 defendant Ratenebery Leonard husbandman 592010 592010 Ratenebery, Leonard, of Hatherlegh, husbandman 0
5095309 2385046 2385046 defendant Ratenebery Leonard husbandman 592010 592010 Ratenebery, Leonard, of Hatherlegh, husbandman 3
5129551 2395130 2395130 defendant Snell Richard husbandman 592010 592010 with Snell, Richard, of Hatherlegh, husbandman 2
5150999 2401432 2401432 defendant Barleben John husbandman 592010 592010 Barleben, John, of Hatherlegh, husbandman 1
5151595 2401620 2401620 defendant Belamy Walter yeoman 592010 592010 Belamy, Walter, of Hatherlegh, yeoman 0
5153992 2402329 2402329 defendant Seldon William husbandman 592010 592010 Seldon, William, of Hatherlegh, husbandman 0
5153994 2402330 2402330 defendant Seldon Williamm husbandman 592010 592010 Seldon, Williamm, of Hatherlegh, husbandman 0
5169698 2406877 2406877 defendant Belamy Walter yeoman 592010 592010 Belamy, Walter, of Hatherlegh, yeoman 0
5171220 2407307 2407307 defendant Seldon William husbandman 592010 592010 Seldon, William, of Hatherlegh, husbandman 0
5181797 2410418 2410418 defendant Ballamay Walter yeoman 592010 592010 Ballamay, Walter, of Hatherlegh, yeoman 1
5186770 2411877 2411877 defendant Belamy Walter yeoman 592010 592010 Belamy, Walter, of Hatherlegh, yeoman 0
5205359 2417321 2417321 defendant Belamy Walter yeoman 592010 592010 Belamy, Walter, of Hatherlegh, yeoman 0
5213105 2419567 2419567 defendant Symon Thomas husbandman 592010 592010 Symon, Thomas, of Hatherlegh, husbandman 4
5213109 2419568 2419568 defendant Symon Thomas husbandman 592010 592010 Symon, Thomas, of Hatherlegh, husbandman 2
5218876 2421243 2421243 defendant Belamy Walter yeoman 592010 592010 Belamy, Walter, of Hatherlegh, yeoman 0
5238486 2426845 2426845 defendant Belamy Walter pardoner 592010 592010 Belamy, Walter, of Hatherlegh, pardoner 3
5250737 2430340 2430340 defendant Genyn Geoffrey husbandman 592010 592010 Genyn, Geoffrey, of Hatherlegh, husbandman 0
5253563 2431223 2431223 defendant Belamy Walter husbandman 592010 592010 Belamy, Walter, of Hatherlegh, husbandman 2
5264458 2434639 2434639 defendant Belamay Walter husbandman 592010 592010 Belamay, Walter, of Hatherlegh, husbandman 2
5296536 2443976 2443976 defendant Bolehede John husbandman 592010 592010 Bolehede, John, of Hatherlegh, husbandman 0
5297084 2444143 2444143 defendant Belamy Walter yeoman 592010 592010 Belamy, Walter, of Hatherlegh, yeoman 3
5345047 2458612 2458612 defendant Coke Thomas husbandman 592010 592010 Coke, Thomas, of Hatherlegh, husbandman 0
5356580 2462127 2462127 defendant Belamy Walter clerk 592010 592010 Belamy, Walter, of Hatherlegh, clerk 0
5356583 2462128 2462128 defendant White Stephen husbandman 592010 592010 White, Stephen, of Hatherlegh, husbandman 0
5369943 2466191 2466191 defendant Rede Ellis carpenter 592010 592010 Rede, Ellis, of Hatherlegh, carpenter 0
5440768 2487150 2487150 defendant Medlond Thomas husbandman 592010 592010 Medlond, Thomas, of Hatherlegh, husbandman 0
5465879 2494712 2494712 defendant Medlond Thomas husbandman 592010 592010 Medlond, Thomas, of Hatherlegh, husbandman 0
5477363 2498240 2498240 defendant Medlond Thomas husbandman 592010 592010 Medlond, Thomas, of Hatherlegh, husbandman 0
5477365 2498241 2498241 defendant Medlond Thomas husbandman 592010 592010 Medlond, Thomas, of Hatherlegh, husbandman 0
5484526 2500291 2500291 defendant Belamy Walter clerk 592010 592010 Belamy, Walter, of Hatherlegh, clerk 0
5489035 2501594 2501594 defendant Medlond Thomas husbandman 592010 592010 Medlond, Thomas, of Hatherlegh, husbandman 0
5492246 2502597 2502597 defendant Bisshoppe Hugh yeoman 592010 592010 Bisshoppe, Hugh, of Hatherlegh, yeoman 0
5492247 2502597 2502597 defendant Seldon Walter husbandman 592010 592010 Seldon, Walter, of Hatherlegh, husbandman 1
5492248 2502597 2502597 defendant Stoule or Stonle Hugh husbandman 592010 592010 Stoule or Stonle, Hugh, of Hatherlegh, husbandman 2
5492249 2502597 2502597 defendant Payrde William yeoman 592010 592010 Payrde, William, of Hatherlegh, yeoman 3
5492250 2502597 2502597 defendant Geffray Richard husbandman 592010 592010 Geffray, Richard, of Hatherlegh, husbandman 4
5504048 2506183 2506183 defendant Medlond Thomas husbandman 592010 592010 Medlond, Thomas, of Hatherlegh, husbandman 0
5504051 2506184 2506184 defendant Medlond Thomas husbandman 592010 592010 Medlond, Thomas, of Hatherlegh, husbandman 0
5512623 2508804 2508804 defendant Medelond Thomas, senior husbandman 592010 592010 Medelond, Thomas, senior, of Hatherlegh, husbandman 0
5512625 2508805 2508805 defendant Medelond John   592010 592010 Medelond, John, of Hatherlegh, husbandman, son of Medelond, Richard 0
5512631 2508807 2508807 defendant Medlond John   592010 592010 Medlond, John, of Hatherlegh, husbandman, son of Medelond, Richard 0
5512684 2508823 2508823 defendant Coke Thomas husbandman 592010 592010 Coke, Thomas, of Hatherlegh, husbandman 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);