names

87 rows where place_id = 605263

✎ 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
3660952 1913697 1913697 defendant Guyll Thomas yeoman 605263 605263 Guyll, Thomas, of Frome Selwood, yeoman 0
3664424 1914821 1914821 defendant Dorset John fuller of cloth 605263 605263 Dorset, John, of Frome Selwood, fuller of cloth 0
3666911 1915594 1915594 defendant George John fuller 605263 605263 George, John, of Frome Selwood, fuller 0
3854585 1975077 1975077 defendant Leversage Robert gent 605263 605263 Leversage, Robert, of Frome Selwood, gent 1
3901209 1990630 1990630 defendant Fowey alias Spencer Thomas tailor 605263 605263 Fowey alias Spencer, Thomas, of Frome Selwood, tailor 0
3965976 2012720 2012720 plaintiff Blackborowe Peter Soms, clothier 605263 605263 Blackborowe Peter, of Frome Selwood, Soms, clothier 0
3965978 2012721 2012721 plaintiff Blackborowe Peter Soms, clothier 605263 605263 Blackborowe Peter, of Frome Selwood, Soms, clothier 0
3978255 2016977 2016977 defendant Stylle John yeoman or victualer 605263 605263 Stylle, John, of Frome Selwood, yeoman or victualer 3
3978256 2016977 2016977 defendant Ichecock or Hyskoke Richard husbandman 605263 605263 Ichecock or Hyskoke, Richard, of Frome Selwood, mercer, husbandman 4
3978267 2016980 2016980 defendant Edgyll Nicholas glover 605263 605263 Edgyll, Nicholas, of Frome Selwood, glover 1
3979089 2017272 2017272 defendant Blake John innholder 605263 605263 Blake, John, of Frome Selwood, innholder 0
4069161 2049262 2049262 defendant Traharne Elizabeth widow 605263 605263 Traharne, Elizabeth, of Frome Selwood, widow 0
4069162 2049262 2049262 defendant Audley Edward shoemaker 605263 605263 Audley, Edward, of Frome Selwood, shoemaker 1
4070570 2049768 2049768 defendant Twynyhoo Thomas gent 605263 605263 Twynyhoo, Thomas, of Frome Selwood, or of Wellowe, Soms, gent 0
4076140 2051753 2051753 defendant Leversage William esq 605263 605263 Leversage, William, of Frome Selwood, esq 0
4076349 2051839 2051839 defendant Twynnce or Twinny Thomas gent 605263 605263 Twynnce or Twinny, Thomas, of Frome Selwood, or of Wellock Soms, gent 0
4119466 2067255 2067255 defendant Whitmore Ralph blacksmith 605263 605263 Whitmore, Ralph, of Frome Selwood, blacksmith 0
4119467 2067255 2067255 defendant Parsons Thomas husbandman 605263 605263 Parsons, Thomas, of Frome Selwood, husbandman 1
4119468 2067255 2067255 defendant Combes John tailor 605263 605263 Combes, John, of Frome Selwood, tailor 2
4131683 2071651 2071651 defendant Daves Richard husbandman 605263 605263 Daves, Richard, of Frome Selwood, husbandman 0
4131684 2071651 2071651 defendant Osborne William shoemaker 605263 605263 Osborne, William, of Frome Selwood, or of Cossam, Wilts, shoemaker 1
4155402 2079981 2079981 defendant Cooke Gabriel yeoman 605263 605263 Cooke, Gabriel, of Frome Selwood, yeoman 0
4164352 2083051 2083051 defendant Ballye Robert   605263 605263 Ballye, Robert, of Frome Selwood, linen draper 0
4173373 2086144 2086144 defendant Cottington John gent 605263 605263 Cottington, John, of Frome Selwood, gent 1
4186312 2090698 2090698 defendant Chislatt Thomas clerk 605263 605263 Chislatt, Thomas, of Frome Selwood, clerk 2
4186313 2090698 2090698 defendant Chubbe William clerk 605263 605263 Chubbe, William, of Frome Selwood, clerk 3
4186318 2090699 2090699 defendant Chubbe William clerk 605263 605263 Chubbe, William, of Frome Selwood, clerk 3
4190198 2092077 2092077 defendant Yearbery Thomas   605263 605263 Yearbery, Thomas, of Frome Selwood, Soms innholder 1
4196695 2094391 2094391 defendant Cottington John gent 605263 605263 Cottington, John, of Frome Selwood, gent 1
4203030 2096610 2096610 defendant Cooke Gabriel yeoman 605263 605263 Cooke, Gabriel, of Frome Selwood, yeoman 0
4218848 2102087 2102087 defendant Treherne Anthony smith 605263 605263 Treherne, Anthony, of Frome Selwood, smith 0
4227007 2104919 2104919 defendant Blake Augustine mercer 605263 605263 Blake, Augustine, of Frome Selwood, mercer 0
4251556 2113503 2113503 defendant Love Robert tailor 605263 605263 Love, Robert, of Frome Selwood, tailor 0
4254930 2114638 2114638 defendant Blacke Augustine mercer 605263 605263 Blacke, Augustine, of Frome Selwood, mercer 0
4258628 2115848 2115848 defendant Mawdley John   605263 605263 Mawdley, John, of Frome Selwood, gent, his son 1
4303902 2131498 2131498 defendant Mewe Henry yeoman 605263 605263 Mewe, Henry, of Frome Selwood, yeoman 0
4305337 2132006 2132006 defendant Pickford Richard husbandman 605263 605263 Pickford, Richard, of Frome Selwood, husbandman 0
4312573 2134532 2134532 defendant Whitinother Ralph smith 605263 605263 Whitinother Ralph, of Frome Selwood, ,smith 1
4312576 2134533 2134533 defendant Pearce John yeoman 605263 605263 Pearce, John, of Frome Selwood, yeoman 1
4312577 2134533 2134533 defendant Pearce Richard husbandman 605263 605263 Pearce, Richard, of Frome Selwood, husbandman 2
4312578 2134533 2134533 defendant Singer George husbandman 605263 605263 Singer, George, of Frome Selwood, husbandman 3
4322816 2138049 2138049 defendant Love Robert tailor 605263 605263 Love, Robert, of Frome Selwood, tailor 0
4322818 2138050 2138050 defendant Mewe Henry yeoman 605263 605263 Mewe, Henry, of Frome Selwood, yeoman 0
4323551 2138294 2138294 defendant Drickewater alias Andrews William yeoman 605263 605263 Drickewater alias Andrews, William, of Frome Selwood, yeoman 1
4329348 2140126 2140126 defendant Love Robert tailor 605263 605263 Love, Robert, of Frome Selwood, tailor 1
4329349 2140126 2140126 defendant Pearse John yeoman 605263 605263 Pearse, John, of Frome Selwood, yeoman 2
4332367 2141117 2141117 defendant Hipstone Richard husbandman 605263 605263 Hipstone, Richard, of Frome Selwood, husbandman 0
4358561 2150233 2150233 defendant Joneson Nicholas tailor 605263 605263 Joneson, Nicholas, of Frome Selwood, tailor 1
4358562 2150233 2150233 defendant Statton John butcher 605263 605263 Statton, John, of Frome Selwood, butcher 2
4358563 2150233 2150233 defendant Clunn William shoemaker 605263 605263 Clunn, William, of Frome Selwood, shoemaker 3
4371438 2154839 2154839 defendant Thorneboroughe John   605263 605263 Thorneboroughe, John, of Frome Selwood, linen draper 0
4379379 2157708 2157708 defendant Mewe Henry yeoman 605263 605263 Mewe, Henry, of Frome Selwood, yeoman 0
4380280 2158051 2158051 defendant Coles Walter chapman 605263 605263 Coles, Walter, of Frome Selwood, chapman 0
4386063 2160023 2160023 defendant Horlocke Robert clothier 605263 605263 Horlocke, Robert, of Frome Selwood, clothier 0
4386064 2160023 2160023 defendant West Richard gent 605263 605263 West, Richard, of Frome Selwood, gent 1
4395204 2162984 2162984 defendant Crocker John tailor 605263 605263 Crocker, John, of Frome Selwood, tailor 1
4397097 2163597 2163597 defendant Corsley Robert cordwainer 605263 605263 Corsley, Robert, of Frome Selwood, cordwainer 1
4598399 2230739 2230739 defendant Alyn John   605263 605263 Alyn, John, of Frome Selwood 0
4682111 2260025 2260025 defendant Bakkere John husbandman 605263 605263 Bakkere, John, of Frome Selwood, husbandman 1
4682112 2260025 2260025 defendant Anglesey alias Tanner John husbandman 605263 605263 Anglesey alias Tanner, John, of Frome Selwood, husbandman 2
4682113 2260025 2260025 defendant Cable William dyer 605263 605263 Cable, William, of Frome Selwood, dyer 3
4722912 2272484 2272484 defendant Honycod Christian widow 605263 605263 Honycod, Christian, of Frome Selwood, widow 0
4772621 2287407 2287407 plaintiff Starke William (legal representative) 605263 605263 Starke, William, of Frome Selwood, parson of St John Baptist church, Bath & Wells diocese, executors of 0
4774221 2287918 2287918 defendant Style Thomas weaver 605263 605263 Style, Thomas, of Frome Selwood, weaver 0
5004493 2358214 2358214 defendant Fyvean John mercer 605263 605263 Fyvean, John, of Frome Selwood, mercer 0
5050718 2371841 2371841 defendant Piers Alexander laborer 605263 605263 Piers, Alexander, of Frome Selwood, laborer 0
5050719 2371841 2371841 defendant Botyler John fuller 605263 605263 Botyler, John, of Frome Selwood, fuller 1
5128243 2394735 2394735 defendant Baker John   605263 605263 Baker, John, of Frome Selwood, cloth man 4
5142366 2398889 2398889 defendant Osteler Thomas dyer 605263 605263 Osteler, Thomas, of Frome Selwood, dyer 1
5298985 2444685 2444685 defendant Crase Thomas   605263 605263 Crase, Thomas, of Frome Selwood 0
5298986 2444685 2444685 defendant Leversegge William gent 605263 605263 Leversegge, William, of Frome Selwood, gent 1
5298987 2444685 2444685 defendant Touker Walter yeoman 605263 605263 together with Touker, Walter, of Frome Selwood, yeoman 2
5299007 2444689 2444689 defendant Liversegge William gent 605263 605263 Liversegge, William, of Frome Selwood, gent 0
5300787 2445195 2445195 defendant Leversegge William gent 605263 605263 together with Leversegge, William, of Frome Selwood, gent 1
5374298 2467565 2467565 defendant Irlond Richard yeoman 605263 605263 Irlond, Richard, of Frome Selwood, yeoman 0
5378434 2468837 2468837 defendant Crase Thomas gent 605263 605263 Crase, Thomas, of Frome Selwood, gent 0
5378442 2468841 2468841 defendant Northcote John clothier 605263 605263 Northcote, John, of Frome Selwood, clothier 0
5378672 2468913 2468913 defendant Style John clothier 605263 605263 Style, John, of Frome Selwood, clothier 0
5392630 2472958 2472958 defendant Smale John fuller 605263 605263 Smale, John, of Frome Selwood, fuller 0
5398152 2474540 2474540 defendant Crokker Richard yeoman 605263 605263 Crokker, Richard, of Frome Selwood, yeoman 0
5398156 2474541 2474541 defendant Webbe John husbandman 605263 605263 Webbe, John, of Frome Selwood, husbandman 1
5398162 2474544 2474544 defendant Crase Thomas gent 605263 605263 Crase, Thomas, of Frome Selwood, gent 0
5409241 2477729 2477729 defendant Osborn John (legal representative) 605263 605263 Osborn, John, of Frome Selwood, yeoman, executrix of 1
5411161 2478296 2478296 defendant Crase Thomas gent 605263 605263 Crase, Thomas, of Frome Selwood, gent 0
5466576 2494943 2494943 defendant Style John (legal representative) 605263 605263 Style, John, of Frome Selwood, clothier, executor of 0
5466577 2494943 2494943 defendant Wynot Robert clothier 605263 605263 (Wynot, Robert, of Frome Selwood, clothier 1
5608858 2537671 2537671 defendant Tokre John carrier 605263 605263 Tokre, John, of Frome Selwood, carrier 1

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