names

117 rows where place_id = 606578

✎ 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
3665733 1915229 1915229 defendant Sheperd Henry mercer 606578 606578 Sheperd, Henry, of Devizes, mercer 0
3929267 2000131 2000131 defendant Gyfforde John, senior yeoman 606578 606578 Gyfforde, John, senior, of Devizes, yeoman 0
3929804 2000306 2000306 plaintiff Chapell John   606578 606578 Chapell, John, of Devizes, surgeon 0
3936584 2002561 2002561 defendant Chapell John   606578 606578 Chapell, John, of Devizes, surgeon 0
3941839 2004283 2004283 defendant Truslowe alias Struslowe Robert (legal representative) 606578 606578 Truslowe alias Struslowe, Robert, of Devizes, mercer, executors of 1
3991330 2021652 2021652 defendant Cley Phineas mercer 606578 606578 Cley, Phineas, of Devizes, mercer 0
4010062 2028364 2028364 defendant Cley Phineas   606578 606578 Cley, Phineas, of Devizes, linen draper 0
4064498 2047583 2047583 defendant Elwell John tailor 606578 606578 Elwell, John, of Devizes, tailor 0
4104139 2061754 2061754 defendant Hadnett John tailor 606578 606578 Hadnett, John, of Devizes, tailor 2
4180606 2088701 2088701 defendant Blackborowe Edith widow 606578 606578 Blackborowe, Edith, of Devizes, widow 0
4183974 2089893 2089893 defendant Hadnett John yeoman 606578 606578 Hadnett, John, of Devizes, yeoman 0
4186558 2090780 2090780 defendant Harper Richard tailor 606578 606578 Harper, Richard, of Devizes, tailor 0
4186561 2090781 2090781 defendant Harper Richard tailor 606578 606578 Harper, Richard, of Devizes, tailor 0
4192368 2092888 2092888 defendant Ispell alias Loker William blacksmith 606578 606578 Ispell alias Loker, William, of Devizes, blacksmith 1
4192369 2092888 2092888 defendant Chyffyn Richard chapman 606578 606578 Chyffyn, Richard, of Devizes, chapman 2
4192370 2092888 2092888 defendant Morrys Robert weaver 606578 606578 Morrys, Robert, of Devizes, weaver 3
4217069 2101464 2101464 defendant Kynge William weaver 606578 606578 Kynge, William, of Devizes, weaver 0
4236841 2108463 2108463 defendant Batt John clothier 606578 606578 Batt, John, of Devizes, clothier 0
4238314 2109012 2109012 defendant Lawrence Mathew gent 606578 606578 Lawrence, Mathew, of Devizes, gent 0
4238725 2109164 2109164 defendant Michell Edward gent 606578 606578 Michell, Edward, of Devizes, gent 0
4239807 2109555 2109555 defendant Hadnett John yeoman 606578 606578 Hadnett, John, of Devizes, yeoman 0
4240297 2109730 2109730 defendant Bayllie Thomas gent 606578 606578 Bayllie, Thomas, of Devizes, gent 1
4276653 2121768 2121768 defendant Stephens Richard baker 606578 606578 Stephens, Richard, of Devizes, baker 2
4278287 2122344 2122344 defendant Sticle John yeoman 606578 606578 Sticle, John, of Devizes, yeoman 0
4281349 2123382 2123382 defendant Sticklowe John butcher 606578 606578 Sticklowe, John, of Devizes, butcher 0
4290301 2126584 2126584 defendant Sticklowe John butcher 606578 606578 Sticklowe, John, of Devizes, butcher 0
4322550 2137953 2137953 defendant Judd Robert yeoman 606578 606578 Judd, Robert, of Devizes, yeoman 0
4336377 2142459 2142459 defendant Hadbett John yeoman 606578 606578 Hadbett, John, of Devizes, yeoman 0
4338056 2143052 2143052 defendant Gest John tailor 606578 606578 Gest, John, of Devizes, tailor 0
4338057 2143052 2143052 defendant Eaton John haberdasher 606578 606578 Eaton, John, of Devizes, haberdasher 1
4340530 2143953 2143953 defendant Blackboroughe Henry yeoman 606578 606578 Blackboroughe, Henry, of Devizes, yeoman 0
4341210 2144196 2144196 defendant Kynbury or Kilbury John chapman 606578 606578 Kynbury or Kilbury, John, of Devizes, chapman 0
4350808 2147540 2147540 defendant Miles John yeoman 606578 606578 Miles, John, of Devizes, yeoman 0
4350809 2147540 2147540 defendant Brewer Walter husbandman 606578 606578 Brewer, Walter, of Devizes, husbandman 1
4380515 2158144 2158144 defendant Sloper Ralph yeoman 606578 606578 Sloper, Ralph, of Devizes, yeoman 0
4416718 2170095 2170095 defendant Bradele Roger de dyer 606578 606578 Bradele, Roger de, of Devizes, dyer 2
4426390 2173061 2173061 defendant Bradele Roger de dyer 606578 606578 Bradele, Roger de, of Devizes, dyer 2
4446674 2183877 2183877 defendant Mylleward John   606578 606578 Mylleward, John, of Devizes 3
4455902 2186863 2186863 plaintiff Mulleward John   606578 606578 Mulleward, John, of Devizes 0
4455904 2186864 2186864 plaintiff Mulleward John   606578 606578 Mulleward, John, of Devizes 0
4455906 2186865 2186865 plaintiff Mulleward John   606578 606578 Mulleward, John, of Devizes 0
4455911 2186866 2186866 plaintiff Mulleward John   606578 606578 Mulleward, John, of Devizes 0
4455916 2186867 2186867 plaintiff Mulleward John   606578 606578 Mulleward, John, of Devizes 0
4455921 2186868 2186868 plaintiff Mulleward John   606578 606578 Mulleward, John, of Devizes 0
4455949 2186878 2186878 plaintiff Mulward Johney   606578 606578 Mulward, Johney, of Devizes 0
4516566 2205591 2205591 defendant Clerk John   606578 606578 Clerk, John, of Devizes 0
4522686 2207433 2207433 defendant Burneford John   606578 606578 Burneford, John, of Devizes 0
4531362 2210083 2210083 defendant Woderove John   606578 606578 Woderove, John, of Devizes 0
4534517 2211068 2211068 defendant Drape William   606578 606578 Drape, William, of Devizes 0
4602024 2231854 2231854 defendant Draper William   606578 606578 Draper, William, of Devizes 0
4617664 2236530 2236530 defendant Stafford John tanner 606578 606578 together with Stafford, John, of Devizes, tanner 1
4628189 2239744 2239744 plaintiff Saltere William (legal representative) 606578 606578 Saltere, William, of Devizes, executrix of 0
4628192 2239745 2239745 plaintiff Saltere William (legal representative) 606578 606578 Saltere, William, of Devizes, executrix of 0
4643158 2244108 2244108 plaintiff Huet Thomas   606578 606578 Huet, Thomas, of Devizes 0
4712818 2269318 2269318 defendant Brewere John husbandman 606578 606578 Brewere, John, of Devizes, husbandman 0
4720179 2271655 2271655 defendant Fildewe John butcher 606578 606578 Fildewe, John, of Devizes, butcher 1
4728465 2274135 2274135 plaintiff Ismell Robert mercer 606578 606578 Ismell, Robert, of Devizes, mercer 0
4733692 2275716 2275716 defendant Malter John husbandman 606578 606578 Malter, John, of Devizes, husbandman 0
4741962 2278147 2278147 plaintiff Brymysgrene William   606578 606578 Brymysgrene, William, of Devizes 0
4746994 2279623 2279623 defendant Skarlet Thomas yeoman 606578 606578 Skarlet, Thomas, of Devizes, yeoman 2
4760336 2283585 2283585 plaintiff Coventry William   606578 606578 Coventry, William, of Devizes 0
4761443 2283922 2283922 defendant Hosyer Richard draper 606578 606578 Hosyer, Richard, of Devizes, draper 1
4771283 2287000 2287000 defendant Coventre Thomas merchant 606578 606578 Coventre, Thomas, of Devizes, merchant 0
4771284 2287000 2287000 defendant Coventre John, sen merchant 606578 606578 Coventre, John, sen, of Devizes, merchant 1
4771285 2287000 2287000 defendant Coventre William merchant 606578 606578 Coventre, William, of Devizes, merchant 2
4772000 2287217 2287217 defendant Courte William husbandman 606578 606578 Courte, William, of Devizes, husbandman 1
4775268 2288258 2288258 defendant Brewer John butcher 606578 606578 Brewer, John, of Devizes, butcher 0
4803097 2297156 2297156 plaintiff Baker John   606578 606578 Baker, John, of Devizes, on his own account 0
4819828 2302274 2302274 defendant Flour Thomas baker 606578 606578 Flour, Thomas, of devizes, baker 1
4831459 2305871 2305871 plaintiff Bromysgrove William   606578 606578 Bromysgrove, William, of Devizes, formerly mayor 0
4847532 2310730 2310730 defendant Nekke or Nekko William weaver 606578 606578 Nekke or Nekko, William, of Devizes, weaver 1
4847534 2310731 2310731 defendant Nekke William weaver 606578 606578 Nekke, William, of Devizes, weaver 0
4914189 2330952 2330952 plaintiff Coventre John   606578 606578 Coventre, John, of Devizes 0
4914191 2330953 2330953 plaintiff Coventre John   606578 606578 Coventre, John, of Devizes, burgess & merchant 0
4914204 2330957 2330957 plaintiff Coventry John   606578 606578 Coventry, John, of Devizes 0
4914206 2330958 2330958 plaintiff Coventry John   606578 606578 Coventry, John, of Devizes, burgess & merchant 0
4914208 2330959 2330959 plaintiff Coventry John   606578 606578 Coventry, John, of Devizes, burgess & merchant 0
4914518 2331060 2331060 plaintiff Cupper William   606578 606578 Cupper, William, of Devizes 0
4914519 2331060 2331060 defendant Cupper William   606578 606578 Cupper, William, of Devizes 0
4924109 2333979 2333979 defendant Water Philip chapman 606578 606578 Water, Philip, of Devizes, chapman 1
4927491 2335032 2335032 defendant Paradys Thomas gent 606578 606578 Paradys, Thomas, of Devizes, gent 0
4931061 2336108 2336108 defendant Pederton John husbandman 606578 606578 Pederton, John, of Devizes, husbandman 1
4985739 2352651 2352651 defendant Barbour Stephen barber 606578 606578 Barbour, Stephen, of Devizes, barber 0
4991408 2354316 2354316 defendant Ingram John   606578 606578 Ingram, John, of Devizes, white tawyer 0
4991409 2354316 2354316 defendant Myblanke John   606578 606578 Myblanke, John, of Devizes, white tawyer 1
4991985 2354491 2354491 defendant Danyell Edward weaver 606578 606578 Danyell, Edward, of Devizes, weaver 0
4991986 2354491 2354491 defendant Botley William glover 606578 606578 Botley, William, of Devizes, glover 1
4992518 2354648 2354648 plaintiff Danyell Edward weaver 606578 606578 Danyell, Edward, of Devizes, weaver 0
4992519 2354648 2354648 plaintiff Botley William glover 606578 606578 Botley, William, of Devizes, glover 1
4992520 2354648 2354648 defendant Wastell William   606578 606578 Wastell, William, of Devizes, wheel wright 0
5051627 2372104 2372104 defendant atte Nasshe Stephen weaver 606578 606578 atte Nasshe, Stephen, of Devizes, weaver 0
5051628 2372104 2372104 defendant Fylde Roger carrier 606578 606578 Fylde, Roger, of Devizes, carrier 1
5157064 2403205 2403205 defendant Curteys Robert smith 606578 606578 Curteys, Robert, of Devizes, smith 0
5157068 2403206 2403206 defendant Curteys Robert smith 606578 606578 Curteys, Robert, of Devizes, smith 0
5185915 2411628 2411628 defendant Shete John   606578 606578 Shete, John, of Devizes, cloth maker 0
5194172 2414028 2414028 defendant Cope John chapman 606578 606578 Cope, John, of Devizes, chapman 4
5205660 2417400 2417400 plaintiff Hendelove William   606578 606578 Hendelove, William, of Devizes 0
5208595 2418242 2418242 defendant Cope John chapman 606578 606578 Cope, John, of Devizes, chapman 4
5208602 2418243 2418243 defendant Cope John chapman 606578 606578 Cope, John, of Devizes, chapman 4
5269104 2436069 2436069 plaintiff Bukman John, senior clothman 606578 606578 Bukman, John, senior, of Devizes, clothman 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);