names

112 rows where place_id = 591342

✎ 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
3604123 1868955 1868955 defendant Duke Richard yeoman 591342 591342 Duke, Richard, of Rolvynden, yeoman 0
3640582 1907495 1907495 defendant Guldeford George esq 591342 591342 Guldeford, George, of Rolvynden, esq 1
3640583 1907495 1907495 defendant Gage John esq 591342 591342 Gage, John, of Rolvynden, esq 2
3722470 1933287 1933287 defendant Newland John husbandman 591342 591342 Newland, John, of Rolvynden, husbandman 5
3726801 1934649 1934649 defendant Frankham William (legal representative) 591342 591342 Frankham, William, of Rolvynden, yeoman, administrator of 0
3774497 1949751 1949751 defendant Fowle Dunstan weaver 591342 591342 Fowle, Dunstan, of Rolvynden, weaver 0
3840792 1970686 1970686 defendant Dudley John   591342 591342 (Dudley, John, of Rolvynden, knight 2
3848206 1973005 1973005 plaintiff Hubberd Gervase   591342 591342 Hubberd, Gervase, of Rolvynden 0
3848208 1973006 1973006 plaintiff Hubberd Gervase   591342 591342 Hubberd, Gervase, of Rolvynden 0
3860870 1977129 1977129 plaintiff Dyngilde John (legal representative) 591342 591342 Dyngilde, John, of Rolvynden, clothmaker, administrator of 0
3875159 1981929 1981929 defendant Pachyng Thomas butcher 591342 591342 Pachyng, Thomas, of Rolvynden, butcher 0
3911414 1994132 1994132 defendant Ramysden William clothmaker 591342 591342 Ramysden, William, of Rolvynden, clothmaker 0
3974635 2015694 2015694 defendant Hunt Anthony mercer 591342 591342 Hunt, Anthony, of Rolvynden, yeoman, or of Smarden, mercer 0
4010948 2028694 2028694 defendant Sysley George husbandman 591342 591342 (Sysley, George, of Rolvynden, husbandman 2
4010949 2028694 2028694 defendant Combe William husbandman 591342 591342 Combe, William, of Rolvynden, husbandman 3
4013417 2029532 2029532 defendant Forde Simon glasier 591342 591342 Forde, Simon, of Rolvynden, glasier 1
4039942 2038907 2038907 defendant Lawles Richard yeoman 591342 591342 Lawles, Richard, of Rolvynden, yeoman 0
4039945 2038908 2038908 defendant Lawles Richard yeoman 591342 591342 Lawles, Richard, of Rolvynden, yeoman 0
4122264 2068269 2068269 defendant Baker William   591342 591342 Baker, William, of Rolvynden, yeoman, or of Benenden, bachelor 0
4138694 2074206 2074206 defendant Badcocke James yeoman 591342 591342 Badcocke, James, of Rolvynden, or of Hawkeherst, yeoman 0
4142975 2075713 2075713 defendant Higham John tailor 591342 591342 Higham, John, of Rolvynden, tailor 3
4145515 2076586 2076586 defendant Baker William   591342 591342 Baker, William, of Rolvynden, yeoman, or of Benenden, bachelor 0
4162560 2082465 2082465 defendant Moore Henry shoemaker 591342 591342 Moore, Henry, of Rolvynden, yeoman, shoemaker 0
4162561 2082465 2082465 defendant Sysley Henry butcher 591342 591342 Sysley, Henry, of Rolvynden, butcher 1
4172507 2085848 2085848 defendant Scisley Henry butcher 591342 591342 Scisley, Henry, of Rolvynden, butcher 0
4177062 2087450 2087450 defendant Frencham Daniel joiner 591342 591342 Frencham, Daniel, of Rolvynden, joiner 2
4178833 2088071 2088071 defendant Boxe Joan widow 591342 591342 Boxe, Joan, of Rolvynden, widow 0
4225444 2104363 2104363 defendant Johnson Richard yeoman 591342 591342 Johnson, Richard, of Rolvynden, yeoman 1
4235334 2107921 2107921 defendant Crouch Thomas husbandman 591342 591342 Crouch, Thomas, of Rolvynden, husbandman 0
4237441 2108687 2108687 defendant Baker William yeoman 591342 591342 Baker, William, of Rolvynden, yeoman 0
4316760 2135979 2135979 defendant Pattenden John husbandman 591342 591342 Pattenden, John, of Rolvynden, husbandman 1
4316761 2135979 2135979 defendant Stanlye Robert miller 591342 591342 Stanlye Robert, of Rolvynden, miller 2
4467658 2190562 2190562 defendant Selbrightenden Joan   591342 591342 Selbrightenden, Joan, of Rolvynden 0
4524221 2207910 2207910 plaintiff Hikke John   591342 591342 Hikke, John, of Rolvynden 0
4562466 2219822 2219822 defendant Brenchesle William   591342 591342 Brenchesle, William, of Rolvynden 0
4587484 2227492 2227492 plaintiff Hykke John   591342 591342 Hykke, John, of Rolvynden 0
4587485 2227492 2227492 defendant atte Knolle John, sen   591342 591342 atte Knolle, John, sen, of Rolvynden 0
4593126 2229160 2229160 plaintiff Page William   591342 591342 Page, William, of Rolvynden 0
4593128 2229160 2229160 defendant Gybon John   591342 591342 Gybon, John, of Rolvynden 0
4596064 2230015 2230015 defendant Jan or Ian John   591342 591342 Jan or Ian, John, of Rolvynden 0
4619302 2237031 2237031 plaintiff Hikke John   591342 591342 Hikke, John, of Rolvynden 0
4619304 2237032 2237032 plaintiff Hikke John   591342 591342 Hikke, John, of Rolvynden 0
4622976 2238165 2238165 defendant Page William   591342 591342 Page, William, of Rolvynden 0
4642849 2244020 2244020 plaintiff Hicke John, sen (legal representative) 591342 591342 Hicke, John, sen, of Rolvynden, executors of 0
4642855 2244021 2244021 plaintiff Hicke John, sen (legal representative) 591342 591342 Hicke, John, sen, of Rolvynden, executors of 0
4642866 2244024 2244024 plaintiff Hikke John   591342 591342 Hikke, John, of Rolvynden 0
4663272 2249981 2249981 defendant Hikkes Henry gent 591342 591342 Hikkes, Henry, of Rolvynden, gent 0
4663274 2249982 2249982 defendant Hikkes Henry gent 591342 591342 Hikkes, Henry, of Rolvynden, gent 0
4676335 2258209 2258209 defendant Robyn William laborer 591342 591342 Robyn, William, of Rolvynden, laborer 0
4678253 2258806 2258806 plaintiff Hilke or Hill Henry   591342 591342 Hilke or Hill, Henry, of Rolvynden, 0
4678822 2258982 2258982 plaintiff Hycke John, senior   591342 591342 Hycke, John, senior, of Rolvynden, 0
4678828 2258983 2258983 plaintiff Hycke John, senior (legal representative) 591342 591342 Hycke, John, senior, of Rolvynden, executors of 0
4685028 2260915 2260915 defendant William John laborer 591342 591342 William, John, of Rolvynden, laborer 0
4703636 2266517 2266517 plaintiff Hicke John, sen (legal representative) 591342 591342 Hicke, John, sen, of Rolvynden, executors of 0
4703637 2266517 2266517 plaintiff Hicke John   591342 591342 (Hicke, John, of Rolvynden, son of John, sen 1
4703641 2266518 2266518 plaintiff Hicke John, sen (legal representative) 591342 591342 Hicke, John, sen, of Rolvynden, executors of 0
4707812 2267812 2267812 plaintiff More Thomas   591342 591342 More, Thomas, of Rolvynden 0
4716679 2270536 2270536 defendant Bysshopynden John fuller 591342 591342 Bysshopynden, John, of Rolvynden, fuller 0
4727609 2273877 2273877 plaintiff Hicke John, sen (legal representative) 591342 591342 Hicke, John, sen, of Rolvynden, executors of 0
4727615 2273878 2273878 plaintiff Hicke John, sen (legal representative) 591342 591342 Hicke, John, sen, of Rolvynden, executors of 0
4728289 2274092 2274092 plaintiff Hycke John   591342 591342 (Hycke, John, of Rolvynden, son of John, sen 1
4735764 2276334 2276334 defendant More Thomas (legal representative) 591342 591342 More, Thomas, of Rolvynden, gent, executors of 0
4743602 2278657 2278657 defendant Kengeham Peter husbandman 591342 591342 Kengeham, Peter, of Rolvynden, husbandman 0
4746637 2279507 2279507 plaintiff Hikkes Henry gent 591342 591342 Hikkes, Henry, of Rolvynden, gent 0
4787511 2292165 2292165 defendant Pytlesden John husbandman 591342 591342 Pytlesden, John, of Rolvynden, husbandman 0
4802729 2297037 2297037 defendant Ketyng John laborer 591342 591342 Ketyng, John, of Rolvynden, laborer 0
4811208 2299616 2299616 plaintiff Frengeham Richard   591342 591342 Frengeham, Richard, of Rolvynden 0
4894107 2324853 2324853 defendant Breggys Richard   591342 591342 Breggys, Richard, of Rolvynden, bailiff 2
4907025 2328773 2328773 defendant Pyper Thomas farmer 591342 591342 Pyper, Thomas, of Rolvynden, farmer 0
4907218 2328821 2328821 defendant Bregges Richard   591342 591342 Bregges, Richard, of Rolvynden, bailiff 2
4919385 2332573 2332573 defendant Dengylden Henry laborer 591342 591342 Dengylden, Henry, of Rolvynden, laborer 0
4970143 2348020 2348020 defendant Pypere Thomas yeoman 591342 591342 Pypere, Thomas, of Rolvynden, yeoman 0
4976126 2349815 2349815 defendant Pipere Thomas husbandman 591342 591342 Pipere, Thomas, of Rolvynden, husbandman 0
4996658 2355854 2355854 defendant Pyper Thomas yeoman 591342 591342 Pyper, Thomas, of Rolvynden, yeoman 0
5005270 2358442 2358442 plaintiff Roberd Henry   591342 591342 Roberd, Henry, of Rolvynden 0
5005271 2358442 2358442 defendant Piper Thomas husbandman 591342 591342 Piper, Thomas, of Rolvynden, husbandman 0
5055283 2373166 2373166 defendant Rede John laborer 591342 591342 Rede, John, of Rolvynden, laborer 1
5117191 2391456 2391456 defendant Netter John (legal representative) 591342 591342 Netter, John, of Rolvynden, clothmaker, administratrix of 0
5117192 2391456 2391456 defendant Netter Joan widow 591342 591342 Netter, Joan, of Rolvynden, widow 1
5137290 2397418 2397418 defendant Netter John (legal representative) 591342 591342 Netter, John, of Rolvynden, cothmaker, administratrix of 0
5137291 2397418 2397418 defendant Netter Joan widow & formerly wife of John 591342 591342 Netter, Joan, of Rolvynden, widow & formerly wife of John 1
5173689 2407999 2407999 defendant Netter John (legal representative) 591342 591342 Netter, John, of Rolvynden, cloth maker, administratrix of 0
5238101 2426730 2426730 defendant Gilford John esq 591342 591342 Gilford, John, of Rolvynden, esq 0
5249837 2430064 2430064 defendant Gyldeford John esq 591342 591342 Gyldeford, John, of Rolvynden, esq 0
5249840 2430065 2430065 defendant Gyldeford John esq 591342 591342 Gyldeford, John, of Rolvynden, esq 0
5257945 2432609 2432609 defendant Mapelisden Thomas butcher 591342 591342 Mapelisden, Thomas, of Rolvynden, butcher 0
5299477 2444825 2444825 defendant Maplesden Thomas yeoman 591342 591342 Maplesden, Thomas, of Rolvynden, yeoman 0
5319678 2450982 2450982 plaintiff Hobard Robert (legal representative) 591342 591342 Hobard, Robert, of Rolvynden, executors of 0
5338667 2456664 2456664 defendant Foule Richard weaver 591342 591342 Foule, Richard, of Rolvynden, weaver 0
5338668 2456664 2456664 defendant Costyn Peter sawyer 591342 591342 together with Costyn, Peter, of Rolvynden, sawyer 1
5350414 2460251 2460251 defendant Engham John esq 591342 591342 Engham, John, of Rolvynden, esq 1
5373045 2467160 2467160 defendant Hykkys Henry butcher 591342 591342 Hykkys, Henry, of Rolvynden, butcher 0
5378466 2468850 2468850 defendant Netter Alan husbandman 591342 591342 Netter, Alan, of Rolvynden, husbandman 0
5388097 2471655 2471655 defendant Sexton John husbandman 591342 591342 Sexton, John, of Rolvynden, husbandman 2
5388098 2471655 2471655 defendant Gebon John husbandman 591342 591342 Gebon, John, of Rolvynden, husbandman 3
5401405 2475467 2475467 defendant Maplisden Thomas yeoman 591342 591342 Maplisden, Thomas, of Rolvynden, yeoman 1
5414396 2479244 2479244 defendant Maplisden Thomas yeoman 591342 591342 Maplisden, Thomas, of Rolvynden, yeoman 1
5430205 2483972 2483972 defendant Maplysden Thomas yeoman 591342 591342 Maplysden, Thomas, of Rolvynden, yeoman 1
5430789 2484146 2484146 defendant Frengeham Henry husbandman 591342 591342 Frengeham, Henry, of Rolvynden, husbandman 2
5437984 2486297 2486297 defendant Sexten John husbandman 591342 591342 Sexten, John, of Rolvynden, husbandman 4

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