names

184 rows where place_id = 588899

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595964 1866369 1866369 defendant Innewe Thomas mercer 588899 588899 Innewe, Thomas, of Branktre, mercer 0
3616998 1872937 1872937 defendant Hewet Robert tailor 588899 588899 Hewet, Robert, of Branktre, tailor 0
3618158 1873304 1873304 defendant Sadlar William (legal representative) 588899 588899 Sadlar, William, of Branktre, clothman, executrix of 0
3618159 1873304 1873304 defendant Sadlare Elizabeth widow 588899 588899 Sadlare, Elizabeth, of Branktre, widow 1
3619957 1873816 1873816 defendant Norfolk John schoolmaster 588899 588899 Norfolk, John, of Branktre, schoolmaster 3
3631435 1904644 1904644 defendant Bukford William butcher 588899 588899 Bukford, William, of Branktre, butcher 1
3643968 1908544 1908544 defendant Tomkyns alias Tomson John saddler 588899 588899 Tomkyns alias Tomson, John, of Branktre, saddler 0
3650654 1910569 1910569 defendant Pokke Robert weaver 588899 588899 Pokke, Robert, of Branktre, weaver 1
3651207 1910745 1910745 defendant Acton Robert   588899 588899 Acton, Robert, of Branktre, wax chandler 0
3677586 1919030 1919030 defendant West William tanner 588899 588899 West, William, of Branktre, tanner 0
3683210 1920867 1920867 defendant Harwarde William yeoman 588899 588899 Harwarde, William, of Branktre, yeoman 1
3750468 1942059 1942059 defendant Bere John smith 588899 588899 Bere, John, of Branktre, smith 0
3750470 1942060 1942060 defendant Brokton Walter innholder 588899 588899 Brokton, Walter, of Branktre, innholder 0
3750471 1942060 1942060 defendant Hyll Thomas bricklayer 588899 588899 Hyll, Thomas, of Branktre, bricklayer 1
3750473 1942060 1942060 defendant Northfoke Richard fishmonger 588899 588899 Northfoke, Richard, of Branktre, fishmonger 3
3766013 1947034 1947034 defendant Bere John smith 588899 588899 Bere, John, of Branktre, smith 0
3766015 1947035 1947035 defendant Brokton Walter innholder 588899 588899 Brokton, Walter, of Branktre, innholder 0
3766017 1947035 1947035 defendant Norffoke Richard fishmonger 588899 588899 Norffoke, Richard, of Branktre, fishmonger 2
3791585 1955207 1955207 defendant Halle William yeoman 588899 588899 Halle, William, of Branktre, yeoman 0
3791587 1955207 1955207 defendant Halle John yeoman 588899 588899 Halle, John, of Branktre, yeoman 2
3827590 1966490 1966490 defendant Appulby Thomas clerk 588899 588899 Appulby, Thomas, of Branktre, clerk 0
3883677 1984810 1984810 defendant Broughton William yoman 588899 588899 Broughton, William, of Branktre, yoman 0
3946266 2005771 2005771 plaintiff Busshe Barnard painter 588899 588899 Busshe, Barnard, of Branktre, painter 0
3951111 2007457 2007457 plaintiff Gregyll alias Grigg William   588899 588899 Gregyll alias Grigg, William, of Branktre 0
4534161 2210946 2210946 defendant Copehode Robert shoemaker 588899 588899 Copehode, Robert, of Branktre, shoemaker 0
4544110 2214071 2214071 defendant Bocher Edmund   588899 588899 Bocher, Edmund, of Branktre 0
4546991 2214992 2214992 defendant Dassh John   588899 588899 Dassh, John, of Branktre 0
4548442 2215451 2215451 plaintiff Normoundy Robert   588899 588899 Normoundy, Robert, of Branktre 2
4588162 2227695 2227695 defendant Coket Walter   588899 588899 (Coket, Walter, of Branktre 1
4597070 2230327 2230327 defendant Lyntowe Walter   588899 588899 Lyntowe, Walter, of Branktre 0
4597072 2230327 2230327 defendant Corsour Nicholas   588899 588899 Corsour, Nicholas, of Branktre 2
4609346 2234023 2234023 plaintiff Bryd John   588899 588899 Bryd, John, of Branktre 0
4618892 2236902 2236902 defendant Lynton John   588899 588899 Lynton, John, of Branktre 0
4642666 2243970 2243970 defendant Lynton John   588899 588899 Lynton, John, of Branktre 0
4668633 2255901 2255901 defendant Halys John   588899 588899 Halys, John, of Branktre 0
4681938 2259966 2259966 defendant Goldyngham John yeoman 588899 588899 Goldyngham, John, of Branktre, yeoman 0
4681939 2259966 2259966 defendant Goldyngham Robert yeoman 588899 588899 Goldyngham, Robert, of Branktre, yeoman 1
4721805 2272153 2272153 defendant Smyth John draper 588899 588899 Smyth, John, of Branktre, draper 0
4735055 2276114 2276114 plaintiff Smyth John   588899 588899 Smyth, John, of Branktre 0
4735057 2276114 2276114 defendant Crauele John carter 588899 588899 Crauele, John, of Branktre, carter 1
4735065 2276115 2276115 defendant Brille John laborer 588899 588899 Brille, John, of Branktre, laborer 3
4751519 2280929 2280929 plaintiff Smyth John   588899 588899 Smyth, John, of Branktre 0
4766733 2285586 2285586 defendant Naylyngherst Hugh esq 588899 588899 Naylyngherst, Hugh, of Branktre, esq 0
4776727 2288712 2288712 defendant Olyver John tailor 588899 588899 Olyver, John, of Branktre, tailor 4
4777309 2288894 2288894 defendant Capon John miller 588899 588899 Capon, John, of Branktre, miller 0
4779325 2289516 2289516 defendant Smyth John yeoman 588899 588899 Smyth, John, of Branktre, yeoman 0
4785449 2291469 2291469 defendant Mellere Thomas miller 588899 588899 Mellere, Thomas, of Branktre, miller 0
4785741 2291573 2291573 defendant Spicer Richard husbandman 588899 588899 Spicer, Richard, of Branktre, husbandman 0
4790069 2292969 2292969 defendant Corbitere John weaver 588899 588899 Corbitere, John, of Branktre, weaver 0
4811448 2299691 2299691 defendant Potter John husbandman 588899 588899 Potter, John, of Branktre, husbandman 3
4817286 2301498 2301498 defendant Lynton John yeoman 588899 588899 Lynton, John, of Branktre, yeoman 3
4823007 2303277 2303277 defendant Curtays John husbandman 588899 588899 Curtays, John, of Branktre, husbandman 0
4823009 2303278 2303278 defendant Curtays John husbandman 588899 588899 Curtays, John, of Branktre, husbandman 0
4852821 2312299 2312299 defendant Curteys Thomas husbandman 588899 588899 Curteys, Thomas, of Branktre, husbandman 2
4857745 2313799 2313799 defendant Clerk Richard spicer 588899 588899 Clerk, Richard, of Branktre, spicer 1
4857746 2313799 2313799 defendant Curteys Thomas (legal representative) 588899 588899 Curteys, Thomas, of Branktre, executrix of 2
4857747 2313799 2313799 defendant Curteys Alice widow 588899 588899 Curteys, Alice, of Branktre, widow 3
4857750 2313800 2313800 defendant Clerk Richard spicer 588899 588899 Clerk, Richard, of Branktre, spicer 1
4857751 2313800 2313800 defendant Curteys Thomas (legal representative) 588899 588899 Curteys, Thomas, of Branktre, executrix of 2
4857752 2313800 2313800 defendant Curteys Alice widow 588899 588899 Curteys, Alice, of Branktre, widow 3
4860669 2314698 2314698 defendant Bele Thomas smith 588899 588899 Bele, Thomas, of Branktre, smith 0
4863285 2315482 2315482 defendant atte Forde Richard husbandman 588899 588899 atte Forde, Richard, of Branktre, husbandman 0
4866670 2316536 2316536 defendant Curteys Alice widow 588899 588899 Curteys, Alice, of Branktre, widow 1
4867831 2316911 2316911 defendant Brunne John tailor 588899 588899 Brunne, John, of Branktre, tailor 0
4870740 2317826 2317826 defendant Garnon Maud widow 588899 588899 Garnon, Maud, of Branktre, widow 0
4870741 2317826 2317826 defendant Beele Thomas smith 588899 588899 Beele, Thomas, of Branktre, smith 1
4875657 2319341 2319341 defendant Smytthe John husbandman 588899 588899 Smytthe, John, of Branktre, husbandman 0
4875658 2319341 2319341 defendant atte Forde Richard husbandman 588899 588899 atte Forde, Richard, of Branktre, husbandman 1
4878480 2320212 2320212 defendant Bocher Thomas butcher 588899 588899 Bocher, Thomas, of Branktre, butcher 0
4881164 2321017 2321017 defendant Sampton John cutler 588899 588899 Sampton, John, of Branktre, cutler 1
4881245 2321038 2321038 defendant Curteys Thomas (legal representative) 588899 588899 Curteys, Thomas, of Branktre, ostler, executrix of 3
4931258 2336158 2336158 defendant Curteys John husbandman 588899 588899 Curteys, John, of Branktre, husbandman 3
4943239 2339856 2339856 defendant Payn John yeoman 588899 588899 Payn, John, of Branktre, yeoman 0
4944382 2340220 2340220 defendant Curteys Alice widow 588899 588899 Curteys, Alice, of Branktre, widow 0
4973136 2348898 2348898 plaintiff Potter John   588899 588899 Potter, John, of Branktre 1
4979697 2350882 2350882 defendant Bekwyth John husbandman 588899 588899 Bekwyth, John, of Branktre, husbandman 6
4999701 2356789 2356789 defendant Hasilwode William carpenter 588899 588899 Hasilwode, William, of Branktre, carpenter 0
5005238 2358429 2358429 defendant Wyke William chapman 588899 588899 Wyke, William, of Branktre, chapman 1
5052604 2372371 2372371 defendant Wayte John gent 588899 588899 Wayte, John, of Branktre, gent 2
5052612 2372372 2372372 defendant Wayte John gent 588899 588899 Wayte, John, of Branktre, gent 2
5059062 2374275 2374275 defendant Wayte John, junior gent 588899 588899 Wayte, John, junior, of Branktre, gent 0
5059065 2374276 2374276 defendant Wayte John, junior gent 588899 588899 Wayte, John, junior, of Branktre, gent 0
5059959 2374543 2374543 defendant Motte Thomas tailor 588899 588899 Motte, Thomas, of Branktre, tailor 3
5059966 2374544 2374544 defendant Motte Thomas tailor 588899 588899 Motte, Thomas, of Branktre, tailor 3
5070183 2377576 2377576 defendant Child Thomas husbandman 588899 588899 Child, Thomas, of Branktre, husbandman 2
5133839 2396391 2396391 defendant Clerk William dyer 588899 588899 Clerk, William, of Branktre, yeoman, Norman, William, dyer 1
5136549 2397204 2397204 defendant (illegible) William chapman 588899 588899 ---, William, of Branktre, chapman 2
5211889 2419216 2419216 defendant Bury John gent 588899 588899 Bury, John, of Branktre, gent 0
5214456 2419961 2419961 defendant Bukford Thomas butcher 588899 588899 Bukford, Thomas, of Branktre, butcher 2
5214465 2419963 2419963 plaintiff Bury John gent 588899 588899 Bury, John, of Branktre, gent 0
5221254 2421912 2421912 defendant Wotton John husbandman 588899 588899 Wotton, John, of Branktre, husbandman 0
5254839 2431628 2431628 defendant Paycok John butcher 588899 588899 Paycok, John, of Branktre, or of Bokkyng, butcher 0
5264632 2434692 2434692 defendant Oscombe Thomas yeoman 588899 588899 Oscombe, Thomas, of Branktre, yeoman 0
5282764 2440017 2440017 defendant Clerk William yeoman 588899 588899 Clerk, William, of Branktre, yeoman 0
5293170 2442983 2442983 defendant Legh John weaver 588899 588899 Legh, John, of Branktre, weaver 0
5295322 2443628 2443628 plaintiff Turnor John (legal representative) 588899 588899 Turnor, John, of Branktre, executors of 0
5295328 2443629 2443629 plaintiff Turnour John (legal representative) 588899 588899 Turnour, John, of Branktre, executors of 0
5302411 2445688 2445688 defendant Hacche John husbandman 588899 588899 Hacche, John, of Branktre, husbandman 0
5302413 2445688 2445688 defendant Hacche Robert laborer 588899 588899 Hacche, Robert, of Branktre, laborer 2
5307323 2447196 2447196 defendant Donmowe Nicholas barber 588899 588899 Donmowe, Nicholas, of Branktre, barber 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);