names

172 rows where place_id = 593142

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610664 1871004 1871004 defendant Herman Reginald yeoman 593142 593142 Herman, Reginald, of Tunstall, yeoman 0
3610665 1871004 1871004 defendant Bullok Robert laborer 593142 593142 Bullok, Robert, of Tunstall, laborer 1
3610666 1871004 1871004 defendant Glover William laborwer 593142 593142 Glover, William, of Tunstall, laborwer 2
3610667 1871004 1871004 defendant Petyte Thomas laborer 593142 593142 Petyte, Thomas, of Tunstall, laborer 3
3610672 1871005 1871005 defendant Herman Reginald yeoman 593142 593142 Herman, Reginald, of Tunstall, yeoman 0
3610673 1871005 1871005 defendant Bullok Robert laborer 593142 593142 Bullok, Robert, of Tunstall, laborer 1
3610674 1871005 1871005 defendant Glover William laborer 593142 593142 Glover, William, of Tunstall, laborer 2
3610675 1871005 1871005 defendant Petyte Thomas laborer 593142 593142 Petyte, Thomas, of Tunstall, laborer 3
3611191 1871176 1871176 defendant Dunche Peter husbandman 593142 593142 Dunche, Peter, of Tunstall, husbandman 0
3617320 1873042 1873042 defendant Tonge John husbandman 593142 593142 (Tonge, John, of Tunstall, husbandman 2
3647455 1909593 1909593 defendant Harman Christopher gent 593142 593142 Harman, Christopher, of Tunstall, gent 1
3679513 1919662 1919662 defendant Harman Christopher gent 593142 593142 Harman, Christopher, of Tunstall, gent 0
3682268 1920552 1920552 defendant Grene geoffrey yeoman 593142 593142 Grene, geoffrey, of Tunstall, yeoman 1
3735347 1937292 1937292 defendant Blok Augustine husbandman 593142 593142 Blok, Augustine, of Tunstall, husbandman 0
3763388 1946176 1946176 defendant Parker John husbandman 593142 593142 Parker, John, of Tunstall, husbandman 1
3767457 1947462 1947462 defendant Crouche John husbandman 593142 593142 Crouche, John, of Tunstall, husbandman 2
3779525 1951320 1951320 defendant Wallys Patrick husbandman 593142 593142 Wallys, Patrick, of Tunstall, husbandman 0
3781495 1951951 1951951 defendant Wyatson William yeoman 593142 593142 Wyatson, William, of Tunstall, yeoman 0
3798161 1957320 1957320 defendant Parker John husbandman 593142 593142 Parker, John, of Tunstall, husbandman 1
3807098 1960111 1960111 defendant Harman Christopher (legal representative) 593142 593142 Harman, Christopher, of Tunstall, gent, executor of 0
3807099 1960111 1960111 defendant Harman John gent 593142 593142 Harman, John, of Tunstall, gent 1
3822003 1964772 1964772 defendant Harman John gent 593142 593142 Harman, John, of Tunstall, gent 0
3824658 1965587 1965587 defendant Herman Christopher (legal representative) 593142 593142 Herman, Christopher, of Tunstall, gent, executor of 0
3824659 1965587 1965587 defendant Herman John gent 593142 593142 Herman, John, of Tunstall, gent 1
3833060 1968264 1968264 defendant Tunstall John, junior husbandman 593142 593142 Tunstall, John, junior, of Tunstall, husbandman 0
3837322 1969583 1969583 defendant Herman John esq 593142 593142 Herman, John, of Tunstall, esq 0
3898694 1989770 1989770 plaintiff Aylmere Robert, senior   593142 593142 Aylmere, Robert, senior, of Tunstall 0
3972244 2014853 2014853 defendant Hill Nicholas husbandman 593142 593142 Hill, Nicholas, of Tunstall, husbandman 0
3976022 2016179 2016179 plaintiff Jenkynson Thomas   593142 593142 Jenkynson, Thomas, of Tunstall 0
3979336 2017359 2017359 plaintiff Newland James yeoman 593142 593142 Newland, James, of Tunstall, yeoman 0
3999972 2024755 2024755 defendant Spanye or Spavye Edward gent 593142 593142 Spanye or Spavye, Edward, of Tunstall, gent 1
4027543 2034497 2034497 defendant Towle William husbandman 593142 593142 Towle, William, of Tunstall, husbandman 0
4076452 2051874 2051874 defendant Gates Thomas husbandman 593142 593142 Gates, Thomas, of Tunstall, husbandman 0
4077665 2052300 2052300 defendant Burne Richard yeoman 593142 593142 Burne, Richard, of Tunstall, yeoman, son of Thomas Burne, of Tunstall, yeoman 1
4091216 2057147 2057147 defendant Wyllett Francis clerk 593142 593142 Wyllett, Francis, of Tunstall, clerk 1
4110922 2064158 2064158 defendant Spanye or Spavye Edward (legal representative) 593142 593142 Spanye or Spavye, Edward, of Tunstall, gent, executors of 0
4110924 2064158 2064158 defendant Jenkinson Thomas gent 593142 593142 Jenkinson, Thomas, of Tunstall, gent 2
4110927 2064159 2064159 defendant Spacye Edward (legal representative) 593142 593142 Spacye, Edward, of Tunstall, gent, executors of 0
4110929 2064159 2064159 defendant Jenkynson Thomas gent 593142 593142 Jenkynson, Thomas, of Tunstall, gent 2
4125478 2069394 2069394 defendant Yonge Thomas gent 593142 593142 Yonge, Thomas, of Tunstall, gent 0
4128564 2070506 2070506 defendant Warryner Roland yeoman 593142 593142 Warryner, Roland, of Tunstall, yeoman 0
4128565 2070506 2070506 defendant Parker Richard yeoman 593142 593142 Parker, Richard, of Tunstall, yeoman 1
4158520 2081049 2081049 defendant Gardyner Ralph yeoman 593142 593142 Gardyner, Ralph, of Tunstall, yeoman 0
4164876 2083227 2083227 defendant Candler William husbandman 593142 593142 Candler, William, of Tunstall, husbandman 0
4164877 2083227 2083227 defendant Candler Joan spinster 593142 593142 Candler, Joan, of Tunstall, spinster 1
4179286 2088231 2088231 defendant Maners alias Sothick William yeoman 593142 593142 Maners alias Sothick, William, of Tunstall, yeoman 3
4186093 2090622 2090622 defendant Basterd John husbandman 593142 593142 Basterd, John, of Tunstall, husbandman 0
4230464 2106149 2106149 defendant Woodd William husbandman or yeoman 593142 593142 Woodd, William, of Tunstall, husbandman or yeoman 0
4241961 2110302 2110302 defendant Savage John shoemaker 593142 593142 Savage, John, of Tunstall, shoemaker 3
4246327 2111749 2111749 defendant Webber John husbandman 593142 593142 Webber, John, of Tunstall, husbandman 0
4246329 2111749 2111749 defendant Andrewe Thomas husbandman 593142 593142 Andrewe, Thomas, of Tunstall, husbandman 2
4251077 2113339 2113339 defendant Calverte Christopher yeoman 593142 593142 Calverte, Christopher, of Tunstall, yeoman, son of Robert Calverte, of Tunstall, yeoman 0
4272940 2120511 2120511 defendant Calverte Thomas yeoman 593142 593142 Calverte, Thomas, of Tunstall, yeoman 1
4290349 2126603 2126603 defendant Hill John husbandman 593142 593142 Hill, John, of Tunstall, husbandman 0
4308879 2133255 2133255 defendant Baddaford John mariner 593142 593142 Baddaford, John, of Tunstall, mariner 0
4318328 2136517 2136517 defendant Trollopp William tailor 593142 593142 Trollopp, William, of Tunstall, tailor 2
4340363 2143891 2143891 defendant Osborne John yeoman 593142 593142 Osborne, John, of Tunstall, yeoman 0
4340367 2143893 2143893 defendant Osborne John yeoman 593142 593142 Osborne, John, of Tunstall, yeoman 0
4379992 2157945 2157945 defendant Jenkinson John gent 593142 593142 Jenkinson, John, of Tunstall, gent 0
4391468 2161763 2161763 defendant Shaply Richard yeoman 593142 593142 Shaply, Richard, of Tunstall, yeoman 3
4395245 2162990 2162990 defendant Browne Christopher chapman 593142 593142 Browne, Christopher, of Tunstall, chapman 2
4402276 2165348 2165348 defendant Dickens Thomas yeoman 593142 593142 Dickens, Thomas, of Tunstall, yeoman 2
4406024 2166582 2166582 defendant Jolloppe Thomas yeoman 593142 593142 Jolloppe, Thomas, of Tunstall, yeoman 0
4410026 2167960 2167960 defendant Jenkynson John gent 593142 593142 Jenkynson, John, of Tunstall, gent 0
4410341 2168054 2168054 defendant Wakeham Richard, senior yeoman 593142 593142 Wakeham, Richard, senior, of Tunstall, yeoman 0
4411418 2168408 2168408 defendant Lighte Thomas yeoman 593142 593142 Lighte, Thomas, of Tunstall ,yeoman 2
4429201 2173941 2173941 defendant Nicol John   593142 593142 Nicol, John, of Tunstall 1
4434265 2175476 2175476 defendant Dygges John   593142 593142 Dygges, John, of Tunstall 0
4434266 2175476 2175476 defendant Syward John   593142 593142 Syward, John, of Tunstall 1
4434568 2175569 2175569 defendant Spynkes Robert   593142 593142 Spynkes, Robert, of Tunstall 0
4464702 2189628 2189628 defendant Shephirde Thomas   593142 593142 Shephirde, Thomas, of Tunstall 1
4465144 2189756 2189756 plaintiff Wilde Agnes   593142 593142 Wilde, Agnes, of Tunstall 0
4465145 2189756 2189756 defendant Fraunceys Robert   593142 593142 Fraunceys, Robert, of Tunstall 0
4469942 2191265 2191265 defendant Hogekys William   593142 593142 Hogekys, William, of Tunstall 0
4531788 2210204 2210204 plaintiff Pety William   593142 593142 Pety, William, of Tunstall 0
4543420 2213831 2213831 plaintiff atte Gore Walter   593142 593142 atte Gore, Walter, of Tunstall, son of Robert 0
4545472 2214506 2214506 defendant Baxster John chaplain 593142 593142 Baxster, John, of Tunstall, chaplain 0
4592327 2228949 2228949 defendant Aylmere Thomas, sen   593142 593142 Aylmere, Thomas, sen, of Tunstall 0
4592331 2228949 2228949 defendant Godyng Thomas   593142 593142 Godyng, Thomas, of Tunstall 4
4616405 2236125 2236125 defendant Tunstall alias Clerk John   593142 593142 Tunstall alias Clerk, John, of Tunstall 0
4616521 2236163 2236163 defendant Sergand Thomas   593142 593142 Sergand, Thomas, of Tunstall 0
4620718 2237465 2237465 defendant Bysshebury William   593142 593142 Bysshebury, William, of Tunstall 0
4620722 2237466 2237466 defendant Bisshebury William   593142 593142 Bisshebury, William, of Tunstall 0
4666458 2250987 2250987 defendant Thomson John husbandman 593142 593142 Thomson, John, of Tunstall, husbandman 2
4666646 2251050 2251050 defendant Bysshebury William esq 593142 593142 Bysshebury, William, of Tunstall, esq 0
4669590 2256198 2256198 defendant Peddyng Thommas husbandman 593142 593142 Peddyng, Thommas, of Tunstall, husbandman 0
4679418 2259179 2259179 defendant Stent John husbandman 593142 593142 Stent, John, of Tunstall, husbandman 1
4682464 2260139 2260139 defendant Peddynge Thomas laborer 593142 593142 Peddynge, Thomas, of Tunstall, laborer 0
4690096 2262457 2262457 defendant Hesilton William yeoman 593142 593142 Hesilton, William, of Tunstall, yeoman 0
4703653 2266521 2266521 defendant Motte John yeoman 593142 593142 Motte, John, of Tunstall, yeoman 0
4707336 2267672 2267672 defendant Huntyng William husbandman 593142 593142 Huntyng, William, of Tunstall, husbandman 2
4707337 2267672 2267672 defendant Spenluffe William husbandman 593142 593142 Spenluffe, William, of Tunstall, husbandman 3
4762232 2284167 2284167 defendant Belchard Roger yeoman 593142 593142 Belchard, Roger, of Tunstall, yeoman 0
4777177 2288845 2288845 plaintiff atte Hacche Stephen   593142 593142 atte Hacche, Stephen, of Tunstall 0
4777178 2288845 2288845 defendant Wymond John husbandman 593142 593142 Wymond, John, of Tunstall, husbandman 0
4777179 2288845 2288845 defendant Kyng Richard laborer 593142 593142 Kyng, Richard, of Tunstall, laborer 1
4779896 2289710 2289710 defendant atte Merssh Thomas husbandman 593142 593142 atte Merssh, Thomas, of Tunstall, husbandman 2
4781790 2290320 2290320 defendant Godyng John husbandman 593142 593142 Godyng, John, of Tunstall, husbandman 0
4781792 2290321 2290321 defendant Godyng John husbandman 593142 593142 Godyng, John, of Tunstall, husbandman 0
4783002 2290703 2290703 defendant Yoman William yeoman 593142 593142 Yoman, William, of Tunstall, yeoman 1

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