names

81 rows where place_id = 599883

✎ 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
3638644 1906902 1906902 defendant Abraham John smith 599883 599883 Abraham, John, of Shaftsbury, smith 1
4027052 2034321 2034321 defendant Smyth alias Nicholl John smith 599883 599883 Smyth alias Nicholl, John, of Shaftsbury, smith 0
4036127 2037601 2037601 defendant Vanner William yeoman 599883 599883 Vanner, William, of Shaftsbury, yeoman 1
4036128 2037601 2037601 defendant Wilkyns John yeoman 599883 599883 Wilkyns, John, of Shaftsbury, yeoman 2
4059675 2045853 2045853 defendant Ryche William cutler 599883 599883 Ryche, William, of Shaftsbury, cutler 0
4104853 2062011 2062011 defendant Cole Charles goldsmith 599883 599883 Cole, Charles, of Shaftsbury, goldsmith 0
4112646 2064780 2064780 defendant Skydmore Thomas gent 599883 599883 Skydmore, Thomas, of Shaftsbury, gent 0
4116120 2066059 2066059 defendant Skydmore Thomas gent 599883 599883 Skydmore, Thomas, of Shaftsbury, gent 0
4116641 2066245 2066245 defendant Cole Charles goldsmith 599883 599883 Cole, Charles, of Shaftsbury, goldsmith 0
4119346 2067212 2067212 defendant Cole Charles innholder 599883 599883 Cole, Charles, of Shaftsbury, innholder 1
4121007 2067801 2067801 defendant Percey Nicholas gent 599883 599883 Percey, Nicholas, of Shaftsbury, gent 0
4123368 2068659 2068659 defendant Magge Charles roper 599883 599883 Magge, Charles, of Shaftsbury, roper 3
4126952 2069932 2069932 defendant Mason William gent 599883 599883 Mason, William, of Shaftsbury, gent 1
4130851 2071346 2071346 defendant Hawkyns Thomas tailor 599883 599883 Hawkyns, Thomas, of Shaftsbury, or of Yevyll, Soms, tailor 1
4137027 2073593 2073593 defendant Edward Stephen husbandman 599883 599883 Edward, Stephen, of Shaftsbury, husbandman 0
4148502 2077605 2077605 defendant Cole Charles goldsmith 599883 599883 Cole, Charles, of Shaftsbury, goldsmith 0
4167231 2084041 2084041 defendant Bowlande John yeoman 599883 599883 Bowlande, John, of Shaftsbury, or of Sutton Veny, yeoman 0
4170688 2085245 2085245 defendant Cole Charles goldsmith 599883 599883 Cole, Charles, of Shaftsbury, goldsmith 0
4170689 2085245 2085245 defendant Gunt John weaver 599883 599883 Gunt, John, of Shaftsbury, "typler" or alehouse keeper, weaver 1
4170690 2085245 2085245 defendant Sutton Thomas brewer 599883 599883 Sutton, Thomas, of Shaftsbury, brewer 2
4186099 2090625 2090625 defendant Humfrye Richard husbandman 599883 599883 Humfrye, Richard, of Shaftsbury, husbandman 0
4188005 2091304 2091304 defendant Morgan Edward gent 599883 599883 Morgan, Edward, of Shaftsbury, or of Salisbury, gent 0
4192341 2092879 2092879 defendant Zouche Francis gent 599883 599883 Zouche, Francis, of Shaftsbury, or of Meere Parke, Wilts, gent 0
4192343 2092879 2092879 defendant Gogsgarne or Gogsgarve or Coysgarve or Coysgarne John esq 599883 599883 Gogsgarne or Gogsgarve or Coysgarve or Coysgarne, John, of Shaftsbury, or of Boswydell, Cornw, esq 2
4199343 2095324 2095324 defendant Hellyer Richard skinner 599883 599883 Hellyer, Richard, of Shaftsbury, skinner 0
4199344 2095324 2095324 defendant Bryne Thomas joiner 599883 599883 Bryne, Thomas, of Shaftsbury, joiner 1
4203920 2096923 2096923 defendant Fawkner Ralph gent 599883 599883 Fawkner, Ralph, of Shaftsbury, or of Deverel Langbridge, gent 0
4203921 2096923 2096923 defendant Wheatacker John clothier 599883 599883 Wheatacker, John, of Shaftsbury, clothier 1
4231840 2106634 2106634 defendant Rendall Thomas, senior blacksmith 599883 599883 Rendall, Thomas, senior, of Shaftsbury, or of Slapton, blacksmith 0
4231841 2106634 2106634 defendant Myse John yeoman 599883 599883 Myse, John, of Shaftsbury, yeoman 1
4231842 2106634 2106634 defendant Locke George yeoman 599883 599883 Locke, George, of Shaftsbury, or of Slapton, yeoman 2
4231845 2106635 2106635 defendant Kynge William clerk 599883 599883 Kynge, William, of Shaftsbury, or of Motcombe, Liberty of Gillingham, clerk 1
4234746 2107701 2107701 defendant Gawen Walter gent 599883 599883 Gawen, Walter, of Shaftsbury, or of Imber, Wilts, gent 0
4235467 2107973 2107973 defendant Heyse Edward glover 599883 599883 Heyse, Edward, of Shaftsbury, glover 0
4238108 2108932 2108932 defendant Vaughan Thomas miller 599883 599883 Vaughan, Thomas, of Shaftsbury, or of Byshoppestonne, Wilts, miller 0
4247014 2111976 2111976 defendant Watkins Humphrey gent 599883 599883 Watkins, Humphrey, of Shaftsbury, gent 0
4250359 2113102 2113102 defendant Kynge John husbandman 599883 599883 Kynge, John, of Shaftsbury, husbandman 0
4252769 2113913 2113913 defendant Crocker Ralph yeoman 599883 599883 Crocker, Ralph, of Shaftsbury, or of Marston Byggott, Soms, yeoman 0
4259482 2116148 2116148 defendant Vaughan Thomas miller 599883 599883 Vaughan, Thomas, of Shaftsbury, or of Byshopestonne, Wilts, miller 0
4260243 2116389 2116389 defendant Lachett Simon husbandman 599883 599883 Lachett, Simon, of Shaftsbury, husbandman 1
4263713 2117523 2117523 defendant Rendall Thomas, senior blacksmith 599883 599883 Rendall, Thomas, senior, of Shaftsbury, or of Slapton, Devon, blacksmith 0
4263714 2117523 2117523 defendant Moyse John yeoman 599883 599883 Moyse, John, of Shaftsbury, yeoman 1
4263715 2117523 2117523 defendant Locke George yeoman 599883 599883 Locke, George, of Shaftsbury, yeoman 2
4290549 2126679 2126679 defendant Zouche Edmund esq 599883 599883 Zouche, Edmund, of Shaftsbury, or of Ansty, Wilts, esq 0
4290613 2126701 2126701 defendant Case alias Hann Henry yeoman 599883 599883 Case alias Hann, Henry, of Shaftsbury, yeoman 1
4304279 2131635 2131635 defendant Percy Nicholas gent 599883 599883 Percy, Nicholas, of Shaftsbury, gent 0
4305035 2131904 2131904 defendant Jennynges Thomas miller 599883 599883 Jennynges, Thomas, of Shaftsbury, husbandman, miller 0
4305036 2131904 2131904 defendant Lovett Robert miller 599883 599883 Lovett, Robert, of Shaftsbury, or of Gillingham, miller 1
4305037 2131904 2131904 defendant Webber Guy glover 599883 599883 Webber, Guy, of Shaftsbury, glover 2
4305038 2131904 2131904 defendant Edwardes Stephen husbandman 599883 599883 Edwardes, Stephen, of Shaftsbury, husbandman 3
4305891 2132198 2132198 defendant Zouch Francis esq 599883 599883 Zouch, Francis, of Shaftsbury, or of Anstie, Wilts, esq 0
4320733 2137347 2137347 defendant Myles alias Powtall John husbandman 599883 599883 Myles alias Powtall, John, of Shaftsbury, husbandman 0
4332535 2141170 2141170 defendant Case alias Hann Henry yeoman 599883 599883 Case alias Hann, Henry, of Shaftsbury, yeoman 1
4356436 2149480 2149480 defendant Seymor John mercer 599883 599883 Seymor, John, of Shaftsbury, mercer 1
4358263 2150125 2150125 defendant Dyett Helen widow 599883 599883 Dyett, Helen, of Shaftsbury, or of Veny Sutton, Wilts, widow 0
4360681 2150990 2150990 defendant Keate Philip husbandman 599883 599883 Keate, Philip, of Shaftsbury, husbandman 0
4362128 2151500 2151500 defendant Case alias Han John shoemaker 599883 599883 Case alias Han, John, of Shaftsbury, shoemaker 0
4363669 2152075 2152075 defendant Morgan Thomas   599883 599883 Morgan, Thomas, of Shaftsbury, woollen draper 0
4377119 2156891 2156891 defendant Brice Roger innkeeper 599883 599883 Brice, Roger, of Shaftsbury, innkeeper 1
4377120 2156891 2156891 defendant Seynior Nicholas husbandman 599883 599883 Seynior, Nicholas, of Shaftsbury, husbandman 2
4377121 2156891 2156891 defendant Basterd Robert cutler 599883 599883 Basterd, Robert, of Shaftsbury, cutler 3
4377981 2157197 2157197 defendant Souche Francis esq 599883 599883 Souche, Francis, of Shaftsbury, esq 0
4377982 2157197 2157197 defendant Lambe William gent 599883 599883 Lambe, William, of Shaftsbury, gent 1
4377983 2157197 2157197 defendant Tennant Edward yeoman 599883 599883 Tennant, Edward, of Shaftsbury, yeoman 2
4380582 2158163 2158163 defendant Senyor John mercer 599883 599883 Senyor, John, of Shaftsbury, mercer 1
4380717 2158215 2158215 defendant Spiller Elias gent 599883 599883 Spiller, Elias, of Shaftsbury, gent 0
4770827 2286856 2286856 defendant Bartelmewe John husbandman 599883 599883 Bartelmewe, John, of Shaftsbury, husbandman 0
4770829 2286857 2286857 defendant Bartelmewe John husbandman 599883 599883 Bartelmewe, John, of Shaftsbury, husbandman 0
4835737 2307175 2307175 defendant Wylkyns Robert   599883 599883 Wylkyns, Robert, of Shaftsbury, notary 1
4965596 2346626 2346626 plaintiff Cronage Richard   599883 599883 Cronage, Richard, of Shaftsbury 0
4965597 2346626 2346626 defendant Hunt John clerk 599883 599883 Hunt, John, of Shaftsbury, clerk 0
5016954 2361854 2361854 defendant Percy Richard yeoman 599883 599883 Percy, Richard, of Shaftsbury, yeoman 0
5016957 2361855 2361855 defendant Percy Richard husbandman 599883 599883 Percy, Richard, of Shaftsbury, husbandman 0
5143687 2399287 2399287 defendant Percy Richard husbandman 599883 599883 Percy, Richard, of Shaftsbury, husbandman 2
5143688 2399287 2399287 defendant Kent Thomas, sen husbandman 599883 599883 Kent, Thomas, sen, of Shaftsbury, husbandman 3
5178510 2409426 2409426 defendant Percy Richard husbandman 599883 599883 Percy, Richard, of Shaftsbury, husbandman 0
5178511 2409426 2409426 defendant Kent Thomas, sen husbandman 599883 599883 Kent, Thomas, sen, of Shaftsbury, husbandman 1
5178513 2409427 2409427 defendant Percy Richard husbandman 599883 599883 Percy, Richard, of Shaftsbury, husbandman 0
5178514 2409427 2409427 defendant Kent Thomas, sen husbandman 599883 599883 Kent, Thomas, sen, of Shaftsbury, husbandman 1
5350488 2460272 2460272 defendant Shaylle William chapman 599883 599883 Shaylle, William, of Shaftsbury, chapman 1
5358718 2462788 2462788 defendant Covyll or Conyll Thomas ostler or tucker 599883 599883 Covyll or Conyll, Thomas, of Shaftsbury, ostler or tucker 0

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