names

143 rows where place_id = 588855

✎ 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
3595796 1866319 1866319 defendant Russell Thomas husbandman 588855 588855 Russell, Thomas, of Langford, husbandman 3
3596867 1866656 1866656 plaintiff Jetter John   588855 588855 (Jetter, John, of Langford 1
3596871 1866657 1866657 plaintiff Jetter John   588855 588855 (Jetter, John, of Langford 1
3622627 1874606 1874606 defendant Atkyns John miller 588855 588855 Atkyns, John, of Langford, miller 1
3632670 1905033 1905033 defendant Walron Humphrey esq 588855 588855 Walron, Humphrey, of Langford, esq 0
3646781 1909402 1909402 defendant Milbroke William carpenter 588855 588855 Milbroke, William, of Langford, carpenter 0
3649835 1910311 1910311 defendant Angell William carpenter 588855 588855 Angell, William, of Langford, carpenter 0
3654064 1911534 1911534 defendant Cockkys John husbandman 588855 588855 Cockkys, John, of Langford, Gloucester, husbandman 1
3662427 1914161 1914161 defendant Godwyn Thomas warrener 588855 588855 Godwyn, Thomas, of Langford, warrener 0
3669628 1916439 1916439 defendant Wylde Barnard laborer 588855 588855 Wylde, Barnard, of Langford, laborer 3
3672220 1917311 1917311 defendant Pynde William husbandman 588855 588855 Pynde, William, of Langford, husbandman 1
3672221 1917311 1917311 defendant Pynd William, junior husbandman 588855 588855 Pynd, William, junior, of Langford, husbandman 2
3677389 1918978 1918978 defendant Whyte Robert husbandman 588855 588855 Whyte, Robert, of Langford, husbandman 0
3678620 1919372 1919372 defendant Haylbron John husbandman 588855 588855 Haylbron, John, of Langford, husbandman 2
3680145 1919859 1919859 defendant Selles Thomas husbandman 588855 588855 Selles, Thomas, of Langford, husbandman 0
3710643 1929650 1929650 defendant Walys William husbandman 588855 588855 Walys, William, of Langford, husbandman 3
3718577 1932086 1932086 defendant Walron Humphrey yeoman 588855 588855 Walron, Humphrey, of Langford, yeoman 0
3750945 1942220 1942220 plaintiff Methwold William gent 588855 588855 Methwold, William, of Langford, gent 0
3759945 1945107 1945107 defendant Wallys Robert husbandman 588855 588855 Wallys, Robert, of Langford, husbandman 0
3760209 1945195 1945195 defendant Graye Richard husbandman 588855 588855 Graye, Richard, of Langford, husbandman 0
3787089 1953757 1953757 defendant Broderwyke John yeoman 588855 588855 Broderwyke, John, of Langford, yeoman 0
3788318 1954145 1954145 defendant Grey Richard husbandman 588855 588855 Grey, Richard, of Langford, husbandman 1
3809843 1960965 1960965 defendant Bydgood John husbandman 588855 588855 Bydgood, John, of Langford, husbandman 0
3812684 1961858 1961858 defendant Grey Richard husbandman 588855 588855 Grey, Richard, of Langford, husbandman 0
3834137 1968619 1968619 plaintiff Methwold William esq 588855 588855 Methwold, William, of Langford, esq 0
3838929 1970103 1970103 plaintiff Walrond Humphrey   588855 588855 Walrond, Humphrey, of Langford 0
3840366 1970552 1970552 defendant Poke John husbandman 588855 588855 Poke, John, of Langford, husbandman 0
3845672 1972192 1972192 defendant Alegh alias Awbrey alias Lee William yeoman 588855 588855 Alegh alias Awbrey alias Lee, William, of Langford, yeoman 0
3850319 1973687 1973687 plaintiff Methwold William esq 588855 588855 Methwold, William, of Langford, esq 0
3877883 1982846 1982846 plaintiff Jenyver William gent 588855 588855 Jenyver, William, of Langford, gent 0
3883428 1984726 1984726 defendant Leke Joan widow 588855 588855 Leke, Joan, of Langford, widow 0
3883532 1984764 1984764 defendant Braye William   588855 588855 Braye, William, of Langford, shepherd 1
3925368 1998798 1998798 defendant Cock Richard laborer 588855 588855 (Cock, Richard, of Langford, laborer 1
3981023 2017973 2017973 defendant Fetyplace Thomas gent 588855 588855 Fetyplace, Thomas, of Langford, gent 0
3981045 2017982 2017982 defendant Fetiplace Thomas gent 588855 588855 Fetiplace, Thomas, of Langford, gent 0
3991229 2021624 2021624 plaintiff Bradbent Margaret   588855 588855 Margaret his wife, formerly Margaret Walton, of Langford 1
4053922 2043781 2043781 plaintiff Astye Robert husbandman 588855 588855 Astye, Robert, of Langford, husbandman 0
4053927 2043782 2043782 plaintiff Astye Robert yeoman 588855 588855 Astye, Robert, of Langford, yeoman 0
4075759 2051635 2051635 defendant Merion Robert (legal representative) 588855 588855 Merion, Robert, of Langford, tanner, executrix of 0
4085530 2055098 2055098 defendant Hunnes Richard husbandman 588855 588855 Hunnes, Richard, of Langford, husbandman 6
4088913 2056339 2056339 defendant Hunes or Himes Richard husbandman 588855 588855 Hunes or Himes, Richard, of Langford, husbandman 1
4203007 2096602 2096602 defendant Jobson Thomas clerk 588855 588855 Jobson, Thomas, of Langford, clerk 0
4292202 2127282 2127282 defendant Dawson George laborer 588855 588855 Dawson, George, of Langford, laborer 1
4292203 2127282 2127282 defendant Samwell William laborer 588855 588855 Samwell, William, of Langford, laborer 2
4306060 2132258 2132258 defendant Stringer Robert yeoman 588855 588855 Stringer, Robert, of Langford, yeoman 0
4306061 2132258 2132258 defendant Stringer William yeoman 588855 588855 Stringer, William, of Langford, yeoman 1
4330802 2140600 2140600 defendant Sibthorpe John yeoman 588855 588855 Sibthorpe, John, of Langford, yeoman 1
4330803 2140600 2140600 defendant Hubberd Thomas yeoman 588855 588855 Hubberd, Thomas, of Langford, yeoman 2
4337041 2142677 2142677 defendant Smythe William yeoman 588855 588855 Smythe, William, of Langford, yeoman 1
4383256 2159119 2159119 defendant Longford Nicholas yeoman 588855 588855 Longford, Nicholas, of Langford, or of Nether Thurbastone, yeoman 0
4502340 2201319 2201319 plaintiff Methewold Sibyl   588855 588855 Methewold, Sibyl, of Langford, formerly wife of John Methewold 0
4549359 2215742 2215742 defendant Bose Robert   588855 588855 Bose, Robert, of Langford 0
4554733 2217406 2217406 defendant Rypon John   588855 588855 Rypon, John, of Langford 0
4569572 2222066 2222066 defendant Hampton Richard   588855 588855 Hampton, Richard, of Langford 0
4572940 2223074 2223074 defendant Smyth Thomas   588855 588855 Smyth, Thomas, of Langford 0
4657662 2248285 2248285 defendant Clere Thomas   588855 588855 Clere, Thomas, of Langford 2
4660140 2249016 2249016 defendant Colyn Richard carter 588855 588855 Colyn, Richard, of Langford, carter 2
4662301 2249682 2249682 defendant Colles John husbandman 588855 588855 Colles, John, of Langford, husbandman 0
4699273 2265239 2265239 defendant Langford Randolf gent 588855 588855 Langford, Randolf, of Langford, gent 0
4710218 2268547 2268547 defendant Joy John husbandman 588855 588855 Joy, John, of Langford, husbandman 0
4715490 2270182 2270182 defendant Smytht Thomas maltman 588855 588855 Smytht, Thomas, of Langford, maltman 0
4726009 2273423 2273423 defendant Sawold Agnes widow 588855 588855 Sawold, Agnes, of Langford, widow 0
4726010 2273423 2273423 defendant Clerk William husbandman 588855 588855 Clerk, William, of Langford, husbandman 1
4726011 2273423 2273423 defendant Smyth John husbandman 588855 588855 Smyth, John, of Langford, husbandman 2
4726012 2273423 2273423 defendant atte Alle William husbandman 588855 588855 atte Alle, William, of Langford, husbandman 3
4726014 2273423 2273423 defendant Mowys John husbandman 588855 588855 Mowys, John, of Langford, husbandman 5
4734122 2275856 2275856 defendant Reynell Richard tanner 588855 588855 Reynell, Richard, of Langford Lester, tanner 0
4737306 2276786 2276786 defendant H_ Robert esq 588855 588855 H_, Robert, of Langford, esq 0
4769445 2286421 2286421 plaintiff Peek Thomas   588855 588855 Peek, Thomas, of Langford 0
4779999 2289746 2289746 defendant Sawold William husbandman 588855 588855 Sawold, William, of Langford, husbandman 0
4786843 2291944 2291944 defendant Miller John miller 588855 588855 Miller, John, of Langford, miller 4
4793286 2293996 2293996 defendant Sawold William smith 588855 588855 Sawold, William, of Langford, smith 0
4800429 2296314 2296314 defendant Mewes John husbandman 588855 588855 Mewes, John, of Langford, husbandman 3
4815164 2300852 2300852 defendant Norreys John ploughman 588855 588855 Norreys, John, of Langford, ploughman 1
4817209 2301474 2301474 defendant Benet John husbandman 588855 588855 Benet, John, of Langford, husbandman 1
4817215 2301475 2301475 defendant Benet John husbandman 588855 588855 Benet, John, of Langford, husbandman 2
4854939 2312898 2312898 defendant Prioure John husbandman 588855 588855 Prioure, John, of Langford, husbandman 1
4860281 2314574 2314574 plaintiff Chyboll Robert   588855 588855 Chyboll, Robert, of Langford 0
4885752 2322417 2322417 defendant Chapman Thomas   588855 588855 Chapman, Thomas, of Langford, bailiff 0
4936024 2337668 2337668 defendant Bollegh William gent 588855 588855 Bollegh, William, of Langford, gent 0
4946405 2340867 2340867 defendant Chapman Thomas husbandman 588855 588855 Chapman, Thomas, of Langford, husbandman 2
4954210 2343232 2343232 defendant Whytyng William husbandman 588855 588855 Whytyng, William, of Langford, husbandman 1
4958965 2344650 2344650 defendant Holkham Margaret widow 588855 588855 Holkham, Margaret, of Langford, widow 0
4988912 2353632 2353632 defendant Chiboll Robert butcher 588855 588855 Chiboll, Robert, of Langford, butcher 0
5023850 2363888 2363888 defendant Cok Nicholas yeoman 588855 588855 Cok, Nicholas, of Langford, yeoman 0
5034446 2366935 2366935 defendant Prutteston John yeoman 588855 588855 Prutteston, John, of Langford Lester, yeoman 0
5034447 2366935 2366935 defendant Were John yeoman 588855 588855 Were, John, of Langford Lester, yeoman 1
5034448 2366935 2366935 defendant Robyn John yeoman 588855 588855 Robyn, John, of Langford Lester, yeoman 2
5034449 2366935 2366935 defendant Haredon John yeoman 588855 588855 Haredon, John, of Langford Lester, yeoman 3
5054890 2373030 2373030 defendant Godmore or Cotmore William husbandman 588855 588855 Godmore or Cotmore, William, of Langford, husbandman 0
5054892 2373031 2373031 defendant Godmore William husbandman 588855 588855 Godmore, William, of Langford, husbandman 0
5083931 2381697 2381697 defendant Ferlegh Henry husbadman 588855 588855 Ferlegh, Henry, of Langford Lester,husbadman 0
5085537 2382162 2382162 defendant Mund John husbandman 588855 588855 Mund, John, of Langford, husbandman 0
5085538 2382162 2382162 defendant Mund Richard husbandman 588855 588855 Mund, Richard, of Langford, husbandman 1
5086067 2382316 2382316 defendant Cok Nicholas husbandman 588855 588855 Cok, Nicholas, of Langford, husbandman 1
5088267 2382943 2382943 defendant Methewold Robert gent 588855 588855 Methewold, Robert, of Langford, gent 0
5114961 2390790 2390790 defendant Cok Nicholas husbandman 588855 588855 Cok, Nicholas, of Langford, husbandman 3
5175580 2408542 2408542 defendant Weldes John (legal representative) 588855 588855 Weldes, John, of Langford, husbandman, executrix of 0
5217385 2420822 2420822 defendant Fyssher John husbandman 588855 588855 Fyssher, John, of Langford, husbandman 0
5217386 2420822 2420822 defendant Herberd Richard husbandman 588855 588855 Herberd, Richard, of Langford, husbandman 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);