names

117 rows where place_id = 592214

✎ 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
3606951 1869837 1869837 defendant Ame John butcher 592214 592214 Ame, John, of Rocheford, butcher 0
3606952 1869837 1869837 defendant Gefferey John baker 592214 592214 Gefferey, John, of Rocheford, baker 1
3607505 1870006 1870006 defendant Ame John butcher 592214 592214 Ame, John, of Rocheford, butcher 1
3702539 1927062 1927062 defendant Braychurche John clerk 592214 592214 Braychurche, John, of Rocheford, clerk 0
3702540 1927062 1927062 defendant Smyth John husbandman 592214 592214 Smyth, John, of Rocheford, husbandman 1
3736320 1937602 1937602 defendant Fyp John husbandman 592214 592214 Fyp, John, of Rocheford, husbandman 0
3746804 1940919 1940919 defendant Pennell Thomas husbandman 592214 592214 Pennell, Thomas, of Rocheford, husbandman 1
3789516 1954546 1954546 defendant Davy Humphrey yeoman 592214 592214 Davy, Humphrey, of Rocheford, yeoman 2
3792737 1955581 1955581 defendant Penell or Pevell Thomas husbandman 592214 592214 Penell or Pevell, Thomas, of Rocheford, husbandman 0
3792739 1955582 1955582 defendant Penell Thomas husbandman 592214 592214 Penell, Thomas, of Rocheford, husbandman 0
3805651 1959711 1959711 defendant Bayly Humphrey yeoman 592214 592214 Bayly, Humphrey, of Rocheford, yeoman 2
3823166 1965158 1965158 defendant Bayly Humphrey yeoman 592214 592214 Bayly, Humphrey, of Rocheford, yeoman 2
3861185 1977217 1977217 defendant Johnson Thomas shoemaker 592214 592214 Johnson, Thomas, of Rocheford, shoemaker 3
3866492 1979021 1979021 defendant Cremyll Richard yeoman 592214 592214 Cremyll, Richard, of Rocheford, yeoman 2
3873325 1981297 1981297 defendant Wattys Christopher tanner 592214 592214 Wattys, Christopher, of Rocheford, tanner 1
3888451 1986400 1986400 defendant Baylly John yeoman 592214 592214 Baylly, John, of Rocheford, yeoman 2
3888453 1986400 1986400 defendant Shutt John yeoman 592214 592214 Shutt, John, of Rocheford, yeoman 4
3904844 1991884 1991884 defendant Baylly John yeoman 592214 592214 Baylly, John, of Rocheford, yeoman 2
3946800 2005950 2005950 defendant Wood Henry tailor 592214 592214 Wood, Henry, of Rocheford, tailor 1
3946802 2005950 2005950 defendant Freborne John husbandman 592214 592214 Freborne, John, of Rocheford, husbandman 3
3965510 2012549 2012549 defendant Holte Roger husbandman 592214 592214 Holte, Roger, of Rocheford, husbandman 0
3966158 2012793 2012793 plaintiff Bode John yeoman 592214 592214 Bode, John, of Rocheford, yeoman 0
3968789 2013712 2013712 plaintiff Cocke John gent 592214 592214 Cocke, John, of Rocheford, gent 0
3987366 2020230 2020230 plaintiff Wymond John painter 592214 592214 Wymond, John, of Rocheford, painter 0
3994892 2022925 2022925 defendant Noble Richard yeoman 592214 592214 Noble, Richard, of Rocheford, yeoman 1
4059826 2045908 2045908 defendant Cock George weaver 592214 592214 Cock, George, of Rocheford, weaver 0
4062934 2047043 2047043 defendant Wyllys John yeoman 592214 592214 Wyllys, John, of Rocheford, yeoman 0
4071373 2050060 2050060 plaintiff Morys Thomas yeoman 592214 592214 Morys, Thomas, of Rocheford, yeoman 0
4073026 2050649 2050649 defendant Hanley Richard   592214 592214 Hanley, Richard, of Rocheford, yeoman, his son 1
4074190 2051068 2051068 plaintiff Pydgyn William   592214 592214 Pydgyn, William, of Rocheford 0
4074191 2051068 2051068 defendant Rogers Richard yeoman 592214 592214 Rogers, Richard, of Rocheford, yeoman 0
4074192 2051068 2051068 defendant Hynton Elizabeth widow 592214 592214 Hynton, Elizabeth, of Rocheford, widow 1
4139940 2074649 2074649 defendant Adams John carpenter 592214 592214 Adams, John, of Rocheford, carpenter 2
4155018 2079847 2079847 defendant Buston Thomas husbandman 592214 592214 Buston, Thomas, of Rocheford, or of Estham, Worcs, husbandman 1
4157695 2080766 2080766 defendant Buston Thomas husbandman 592214 592214 Buston, Thomas, of Rocheford, or of Estham, Worcs, husbandman 0
4421834 2171706 2171706 defendant Ken Thomas le (legal representative) 592214 592214 Ken, Thomas le, of Rocheford, executors of 0
4448780 2184558 2184558 defendant Goodweve Philip   592214 592214 Goodweve, Philip, of Rocheford 0
4459758 2188105 2188105 plaintiff Saner Or Saier John, junior   592214 592214 Saner Or Saier, John, junior, of Rocheford 0
4501746 2201144 2201144 defendant Chapman Henry   592214 592214 Chapman, Henry, of Rocheford 0
4515263 2205188 2205188 plaintiff Chaynell Nicholas   592214 592214 Chaynell, Nicholas, of Rocheford 0
4516568 2205592 2205592 defendant Cok John   592214 592214 Cok, John, of Rocheford 0
4570955 2222482 2222482 defendant Offwel John clerk 592214 592214 Offwel, John, of Rocheford, clerk 0
4683675 2260495 2260495 defendant atte Gate Richard husbandman 592214 592214 atte Gate, Richard, of Rocheford, husbandman 1
4717990 2270966 2270966 defendant Bocher Thomas butcher 592214 592214 Bocher, Thomas, of Rocheford, butcher 0
4786564 2291848 2291848 plaintiff Gardener Robert (legal representative) 592214 592214 Gardener, Robert, of Rocheford, executors of 0
4786566 2291848 2291848 plaintiff Alnethele alias Clerk John   592214 592214 Alnethele alias Clerk, John, of Rocheford 2
4786567 2291848 2291848 defendant Wardele John laborer 592214 592214 Wardele, John, of Rocheford, laborer 0
4820969 2302645 2302645 defendant Harry John baker 592214 592214 Harry, John, of Rocheford, baker 0
4835401 2307068 2307068 defendant Huntyngdon John chaplain 592214 592214 Huntyngdon, John, of Rocheford, chaplain 0
4841175 2308776 2308776 defendant Belle William water man 592214 592214 Belle, William, of Rocheford, water man 0
4855692 2313152 2313152 defendant Smyth Thomas smith 592214 592214 Smyth, Thomas, of Rocheford, smith 0
4856552 2313431 2313431 defendant Houchon William husbandman 592214 592214 Houchon, William, of Rocheford, husbandman 0
4865129 2316067 2316067 defendant Vedryche John butcher 592214 592214 Vedryche, John, of Rocheford, butcher 1
4865130 2316067 2316067 defendant Wardele John thatcher 592214 592214 Wardele, John, of Rocheford, thatcher 2
5015502 2361419 2361419 defendant Gefferey Nicholas husbandman 592214 592214 Gefferey, Nicholas, of Rocheford, husbandman 0
5020898 2363010 2363010 defendant Fedreche John butcher 592214 592214 Fedreche, John, of Rocheford, butcher 0
5020902 2363010 2363010 defendant Davy Richard husbandman 592214 592214 Davy, Richard, of Rocheford, husbandman 4
5027743 2364991 2364991 defendant Duns Joan widow 592214 592214 Duns, Joan, of Rocheford, widow 3
5035346 2367196 2367196 defendant Bocher William butcher 592214 592214 Bocher, William, of Rocheford, butcher 0
5041071 2368956 2368956 defendant Balle Humphrey butcher 592214 592214 Balle, Humphrey, of Rocheford, butcher 0
5041072 2368956 2368956 defendant Clerk alias Bucher Thomas herdsman 592214 592214 Clerk alias Bucher, Thomas, of Rocheford, herdsman 1
5041073 2368956 2368956 defendant Gefferey Nicholas husbandman 592214 592214 Gefferey, Nicholas, of Rocheford, husbandman 2
5041076 2368957 2368957 plaintiff Chetilbere John clerk 592214 592214 Chetilbere, John, of Rocheford, clerk 0
5042666 2369412 2369412 defendant Instowe Richard yeoman 592214 592214 Instowe, Richard, of Rocheford, yeoman 0
5042667 2369412 2369412 defendant Fedrych John butcher 592214 592214 Fedrych, John, of Rocheford, butcher 1
5042668 2369412 2369412 defendant Butcher William butcher 592214 592214 Butcher, William, of Rocheford, butcher 2
5043120 2369560 2369560 defendant Clerk Thomas herdsman 592214 592214 Clerk, Thomas, of Rocheford, herdsman 0
5047292 2370811 2370811 defendant Hawkyn Roger   592214 592214 Hawkyn, Roger, of Rocheford, "hierd" or herdsman 2
5048175 2371082 2371082 defendant Blak William chapman 592214 592214 Blak, William, of Rocheford, chapman 0
5048177 2371083 2371083 defendant Knyfe Robert tailor 592214 592214 Knyfe, Robert, of Rocheford, tailor 0
5052060 2372228 2372228 defendant Chetilbere John clerk 592214 592214 Chetilbere, John, of Rocheford, clerk 0
5059897 2374526 2374526 defendant Quyk John, senior   592214 592214 Quyk, John, senior, of Rocheford, hierd or herder 0
5063618 2375652 2375652 defendant Camper John husbandman 592214 592214 Camper, John, of Rocheford, husbandman 0
5070903 2377793 2377793 defendant Wardeley John husbandman 592214 592214 Wardeley, John, of Rocheford, husbandman 0
5070904 2377793 2377793 defendant Foster John husbandman 592214 592214 Foster, John, of Rocheford, husbandman 1
5070905 2377793 2377793 defendant Geffrey Nicholas husbandman 592214 592214 Geffrey, Nicholas, of Rocheford, husbandman 2
5077942 2379885 2379885 defendant Balle Humphrey butcher 592214 592214 Balle, Humphrey, of Rocheford, butcher 0
5077943 2379885 2379885 defendant Bocher Thomas husbandman 592214 592214 Bocher, Thomas, of Rocheford, husbandman 1
5078293 2379996 2379996 defendant Blak William chapman 592214 592214 Blak, William, of Rocheford, chapman 2
5093706 2384558 2384558 defendant Federich John butcher 592214 592214 Federich, John, of Rocheford, butcher 0
5093707 2384558 2384558 defendant Knyfe Robert tailor 592214 592214 Knyfe, Robert, of Rocheford, tailor 1
5093918 2384620 2384620 defendant Harford John yeoman 592214 592214 Harford, John, of Rocheford, yeoman 1
5108453 2388908 2388908 defendant Alcok Thomas   592214 592214 Alcok, Thomas, of Rocheford, servant 1
5129195 2395027 2395027 defendant Belkeswell John mercer 592214 592214 Belkeswell, John, of Rocheford, mercer 0
5136212 2397108 2397108 defendant Chapman William husbandman 592214 592214 Chapman, William, of Rocheford, husbandman 1
5136215 2397109 2397109 defendant Chapman William husbandman 592214 592214 Chapman, William, of Rocheford, husbandman 1
5142952 2399065 2399065 defendant Bekyswell John chapman 592214 592214 Bekyswell, John, of Rocheford, chapman 0
5152178 2401775 2401775 defendant Cryppys Robert husbandman 592214 592214 Cryppys, Robert, of Rocheford, husbandman 0
5156568 2403074 2403074 defendant Frenche John chapman 592214 592214 Frenche, John, of Rocheford, chapman 0
5164333 2405304 2405304 defendant Bekyswell John chapman 592214 592214 Bekyswell, John, of Rocheford, chapman 0
5227958 2423789 2423789 defendant Gate Thomas husbandman 592214 592214 Gate, Thomas, of Rocheford, husbandman 0
5239212 2427056 2427056 defendant Chetylberwode William husbandman 592214 592214 Chetylberwode, William, of Rocheford, husbandman 1
5239213 2427056 2427056 defendant Foderiche John husbandman 592214 592214 Foderiche, John, of Rocheford, husbandman 2
5239214 2427056 2427056 defendant Ball Humphrey butcher 592214 592214 Ball, Humphrey, of Rocheford, butcher 3
5245395 2428808 2428808 plaintiff atte Gate Thomas   592214 592214 atte Gate, Thomas, of Rocheford 1
5245398 2428809 2428809 plaintiff atte Gate Thomas   592214 592214 atte Gate, Thomas, of Rocheford 1
5292138 2442697 2442697 defendant Holand Richard laborer 592214 592214 Holand, Richard, of Rocheford, laborer 3
5323003 2451955 2451955 defendant Grymston Clement chapman 592214 592214 Grymston, Clement, of Rocheford, chapman 0
5327932 2453423 2453423 defendant Bocher alias Clerk Thomas (legal representative) 592214 592214 Bocher alias Clerk, Thomas, of Rocheford, butcher, administratrix of 0
5327933 2453423 2453423 defendant Bocher Joan widow 592214 592214 Bocher, Joan, of Rocheford, widow 1

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