names

237 rows where place_id = 586339

✎ 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
3588459 1864037 1864037 defendant Carles John tiler 586339 586339 Carles, John, of Leomynstre, tiler 1
3611582 1871289 1871289 defendant Wolryche John tanner 586339 586339 Wolryche, John, of Leomynstre, tanner 0
3613962 1872023 1872023 defendant Lluwellan Hugh cordwainer 586339 586339 Lluwellan, Hugh, of Leomynstre, cordwainer 0
3719031 1932228 1932228 defendant Powell Philip mercer 586339 586339 Powell, Philip, of Leomynstre, mercer 0
3732653 1936443 1936443 defendant Heth Philip butcher 586339 586339 Heth, Philip, of Leomynstre, butcher 0
3811067 1961355 1961355 defendant Scarlett Richard yeoman 586339 586339 Scarlett, Richard, of Leomynstre, yeoman 0
3847411 1972752 1972752 defendant Newman William laborer 586339 586339 Newman, William, of Leomynstre, laborer 1
3860509 1977008 1977008 defendant Stevyns John butcher 586339 586339 Stevyns, John, of Leomynstre, butcher 1
3868897 1979838 1979838 defendant Inke Richard yeoman 586339 586339 Inke, Richard, of Leomynstre, yeoman 1
4425909 2172907 2172907 defendant Shepeherd William de   586339 586339 Shepeherd, William de, of Leomynstre 0
4441736 2182353 2182353 defendant Broun John   586339 586339 Broun, John, of Leomynstre 0
4550884 2216210 2216210 defendant Stokton William   586339 586339 Stokton, William, of Leomynstre 6
4584620 2226610 2226610 plaintiff Goldsmyth William   586339 586339 Goldsmyth, William, of Leomynstre 0
4588556 2227792 2227792 defendant Barbour Thomas butcher 586339 586339 Barbour, Thomas, of Leomynstre, butcher 0
4595431 2229826 2229826 defendant Braas John   586339 586339 Braas, John, of Leomynstre 2
4595927 2229982 2229982 defendant Turnour Roger   586339 586339 Turnour, Roger, of Leomynstre 0
4595928 2229982 2229982 defendant Webbe John   586339 586339 Webbe, John, of Leomynstre 1
4595931 2229982 2229982 defendant Duyton Richard   586339 586339 Duyton, Richard, of Leomynstre 4
4595932 2229982 2229982 defendant Turball Hugh   586339 586339 Turball, Hugh, of Leomynstre 5
4596915 2230275 2230275 defendant Goldsmyth William   586339 586339 Goldsmyth, William, of Leomynstre 0
4600230 2231301 2231301 plaintiff Thorne Walter   586339 586339 Thorne, Walter, of Leomynstre 0
4608782 2233851 2233851 defendant Salesbury John   586339 586339 Salesbury, John, of Leomynstre 0
4612279 2234906 2234906 plaintiff Corvyser William   586339 586339 Corvyser, William, of Leomynstre 0
4614632 2235585 2235585 plaintiff Edery John   586339 586339 Edery, John, of Leomynstre 0
4616066 2236026 2236026 defendant Cok Peter   586339 586339 Cok, Peter, of Leomynstre 1
4616067 2236026 2236026 defendant Dyere John   586339 586339 Dyere, John, of Leomynstre 2
4619899 2237203 2237203 defendant Goldsmyth William   586339 586339 Goldsmyth, William, of Leomynstre 0
4635150 2241839 2241839 plaintiff Wyte Thomas   586339 586339 Wyte, Thomas, of Leomynstre 0
4652534 2246746 2246746 plaintiff Baker John   586339 586339 Baker, John, of Leomynstre 0
4652535 2246746 2246746 defendant Baker Geoffrey baker 586339 586339 Baker, Geoffrey, of Leomynstre, baker 0
4656483 2247924 2247924 plaintiff Turball Walter   586339 586339 Turball, Walter, of Leomynstre 2
4659795 2248913 2248913 defendant Wayte William husbandman 586339 586339 Wayte, William, of Leomynstre, husbandman 0
4661192 2249325 2249325 defendant Presthemede William   586339 586339 Presthemede, William, of Leomynstre, wax chandler 0
4662822 2249833 2249833 plaintiff Fysshchere David   586339 586339 Fysshchere, David, of Leomynstre 0
4662823 2249833 2249833 defendant Hulle Richard barker 586339 586339 Hulle, Richard, of Leomynstre, barker 0
4663325 2250000 2250000 plaintiff Glasier John   586339 586339 Glasier, John, of Leomynstre 0
4664923 2250508 2250508 defendant Tyler Lucy   586339 586339 Tyler, Lucy, of Leomynstre 1
4667217 2255480 2255480 defendant Monmouth Richard yeoman 586339 586339 Monmouth, Richard, of Leomynstre, yeoman 0
4667218 2255480 2255480 defendant Glasyer John yeoman 586339 586339 Glasyer, John, of Leomynstre, yeoman 1
4667219 2255480 2255480 defendant Kerver William shoemaker 586339 586339 Kerver, William, of Leomynstre, shoemaker 2
4672952 2257181 2257181 defendant Turball Thomas mercer 586339 586339 Turball, Thomas, of Leomynstre, mercer 0
4672953 2257181 2257181 defendant Whyte Thomas butcher 586339 586339 Whyte, Thomas, of Leomynstre, butcher 1
4672954 2257181 2257181 defendant Smyth William weaver 586339 586339 Smyth, William, of Leomynstre, weaver 2
4672955 2257181 2257181 defendant Vikere John yeoman 586339 586339 Vikere, John, of Leomynstre, yeoman 3
4672956 2257181 2257181 defendant Payn John weaver 586339 586339 Payn, John, of Leomynstre, weaver 4
4675323 2257893 2257893 plaintiff Fisshere David   586339 586339 Fisshere, David, of Leomynstre, on his own account 0
4675325 2257894 2257894 plaintiff Fisshere David   586339 586339 Fisshere, David, of Leomynstre, on his own account 0
4678510 2258886 2258886 defendant Turball Thomas mercer 586339 586339 Turball, Thomas, of Leomynstre, mercer 0
4678511 2258886 2258886 defendant Walker Walter butcher 586339 586339 Walker, Walter, of Leomynstre, butcher 1
4681378 2259798 2259798 defendant Syre Thomas tailor 586339 586339 Syre, Thomas, of Leomynstre, tailor 0
4682805 2260238 2260238 defendant Wayte William husbandman 586339 586339 Wayte, William, of Leomynstre, husbandman 0
4688388 2261936 2261936 plaintiff Taylour John   586339 586339 Taylour, John, of Leomynstre, on his own account 0
4688391 2261936 2261936 defendant Tyler David husbandman 586339 586339 Tyler, David, of Leomynstre, husbandman 2
4688393 2261936 2261936 defendant Romayne John yeoman 586339 586339 Romayne, John, of Leomynstre, yeoman 4
4688394 2261937 2261937 plaintiff Taylour John   586339 586339 Taylour, John, of Leomynstre, on his own account 0
4688397 2261937 2261937 defendant Tyler David husbandman 586339 586339 Tyler, David, of Leomynstre, husbandman 2
4688399 2261937 2261937 defendant Romayne John yeoman 586339 586339 Romayne, John, of Leomynstre, yeoman 4
4690110 2262463 2262463 plaintiff Webbe Hugh   586339 586339 Webbe, Hugh, of Leomynstre 0
4690112 2262463 2262463 defendant Payne John weaver 586339 586339 Payne, John, of Leomynstre, weaver 1
4743496 2278627 2278627 defendant Dreoyn Matilda spinster 586339 586339 Dreoyn, Matilda, of Leomynstre, spinster 2
4743498 2278627 2278627 defendant Northwych John chaplain 586339 586339 Northwych, John, of Leomynstre, chaplain 4
4780135 2289785 2289785 defendant Warde Richard butcher 586339 586339 Warde, Richard, of Leomynstre, butcher 0
4789210 2292682 2292682 defendant Brace Joan widow 586339 586339 Brace, Joan, of Leomynstre, widow 1
4790158 2293005 2293005 plaintiff Kerver William yeoman 586339 586339 Kerver, William, of Leomynstre, yeoman 0
4790159 2293005 2293005 defendant More Richard chaplain 586339 586339 More, Richard, of Leomynstre, chaplain 0
4795302 2294683 2294683 defendant Munede John yeoman 586339 586339 Munede, John, of Leomynstre, yeoman 0
4795303 2294683 2294683 defendant Hulle Richard tanner 586339 586339 Hulle, Richard, of Leomynstre, tanner 1
4795304 2294683 2294683 defendant Walkelayn Richard weaver 586339 586339 Walkelayn, Richard, of Leomynstre, weaver 2
4795668 2294799 2294799 defendant Prestehende William husbandman 586339 586339 Prestehende, William, of Leomynstre, husbandman 0
4795669 2294799 2294799 defendant Maynard William cordwainer 586339 586339 Maynard, William, of Leomynstre, cordwainer 1
4795670 2294799 2294799 defendant Wykers Richard butcher 586339 586339 Wykers, Richard, of Leomynstre, butcher 2
4795671 2294799 2294799 defendant Riggere William sherman 586339 586339 Riggere, William, of Leomynstre, sherman 3
4795672 2294799 2294799 defendant Wylkyns Thomas husbandman 586339 586339 Wylkyns, Thomas, of Leomynstre, husbandman 4
4800401 2296306 2296306 defendant Shobdon Thomas   586339 586339 Shobdon, Thomas, of Leomynstre, shepherd 0
4800402 2296306 2296306 defendant Monnemouth John husbandman 586339 586339 Monnemouth, John, of Leomynstre, husbandman 1
4800404 2296306 2296306 defendant Carpenter Richard weaver 586339 586339 Carpenter, Richard, of Leomynstre, weaver 3
4807926 2298664 2298664 defendant Vicaries Richard butcher 586339 586339 Vicaries, Richard, of Leomynstre, butcher 1
4807929 2298664 2298664 defendant Socour Thomas shoemaker 586339 586339 Socour, Thomas, of Leomynstre, shoemaker 4
4808379 2298799 2298799 defendant Aylmer Richard (legal representative) 586339 586339 Aylmer, Richard, of Leomynstre, chaplain, executors of 0
4808381 2298799 2298799 defendant Bradeley John mercer 586339 586339 Bradeley, John, of Leomynstre, mercer 2
4809772 2299219 2299219 plaintiff Ederey John husbandman 586339 586339 Ederey, John, of Leomynstre, husbandman 0
4811810 2299807 2299807 defendant Crewe John yeoman 586339 586339 Crewe, John, of Leomynstre, yeoman 0
4815000 2300802 2300802 defendant Warde Richard butcher 586339 586339 Warde, Richard, of Leomynstre, butcher 0
4815001 2300802 2300802 defendant Don John shoemaker 586339 586339 Don, John, of Leomynstre, shoemaker 1
4818873 2301986 2301986 defendant Preschemde William   586339 586339 Preschemde, William, of Leomynstre, wax maker 0
4825956 2304151 2304151 defendant Baret Richard walker 586339 586339 Baret, Richard, of Leomynstre, walker 0
4841379 2308839 2308839 defendant Michell Nicholas husbandman 586339 586339 Michell, Nicholas, of Leomynstre or Lyminster, husbandman 0
4841381 2308840 2308840 defendant Michell Nicholas husbandman 586339 586339 Michell, Nicholas, of Leomynstre or Lyminster , husbandman 0
4855938 2313231 2313231 defendant Clerk Robert dyer 586339 586339 Clerk, Robert, of Leomynstre, dyer 0
4857334 2313678 2313678 plaintiff Blewet Thomas   586339 586339 Blewet, Thomas, of Leomynstre 0
4857335 2313678 2313678 defendant Munede John chaloner or blanket weaver 586339 586339 Munede, John, of Leomynstre, chaloner or blanket weaver 0
4866372 2316451 2316451 defendant Glasyer John barber 586339 586339 Glasyer, John, of Leomynstre, barber 0
4866373 2316451 2316451 defendant Rogers Thomas husbandman 586339 586339 Rogers, Thomas, of Leomynstre, husbandman 1
4866374 2316451 2316451 defendant Credy Thomas draper 586339 586339 Credy, Thomas, of Leomynstre, draper 2
4866375 2316451 2316451 defendant Crywe John yeoman 586339 586339 Crywe, John, of Leomynstre, yeoman 3
4873305 2318604 2318604 defendant Hood John mercer 586339 586339 Hood, John, of Leomynstre, mercer 0
4874532 2318977 2318977 defendant Cruwe John yeoman 586339 586339 Cruwe, John, of Leomynstre, yeoman 0
4874533 2318977 2318977 defendant Burton Thomas butcher 586339 586339 Burton, Thomas, of Leomynstre, butcher 1
4874570 2318992 2318992 defendant Socoure Thomas cordwainer 586339 586339 Socoure, Thomas, of Leomynstre, cordwainer 0
4875032 2319140 2319140 plaintiff Rogers Thomas   586339 586339 Rogers, Thomas, of Leomynstre 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);