names

111 rows where place_id = 586240

✎ 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
3588239 1863977 1863977 defendant Leventhorp Robert gent 586240 586240 Leventhorp, Robert, of Pountfret, gent 0
3617283 1873029 1873029 defendant Brangwyn or Braugwyn Diggory capper 586240 586240 Brangwyn or Braugwyn, Diggory, of Pountfret, capper 1
3629073 1903970 1903970 defendant Leventhorp John brasier 586240 586240 Leventhorp, John, of Pountfret, brasier 0
3640097 1907348 1907348 defendant Wilson John shoemaker 586240 586240 Wilson, John, of Pountfret, shoemaker 0
3644784 1908775 1908775 plaintiff Forster John   586240 586240 Forster, John, of Pountfret 0
3647735 1909681 1909681 defendant Gibson Robert barker 586240 586240 (Gibson, Robert, of Pountfret, barker 1
3665700 1915221 1915221 defendant Bull Alexander   586240 586240 Bull, Alexander, of Pountfret, yeoman, King's Crown valet 0
3666777 1915553 1915553 defendant Warde John butcher 586240 586240 Warde, John, of Pountfret, butcher 0
3666778 1915553 1915553 defendant Walker John yeoman 586240 586240 Walker, John, of Pountfret, yeoman 1
3666779 1915553 1915553 defendant Chester Anthony smith 586240 586240 Chester, Anthony, of Pountfret, smith 2
3666780 1915553 1915553 defendant Tenande William weaver 586240 586240 Tenande, William, of Pountfret, weaver 3
3694605 1924516 1924516 defendant Walker John yeoman 586240 586240 Walker, John, of Pountfret, yeoman 0
3719948 1932508 1932508 defendant Edryngton John spurrier 586240 586240 Edryngton, John, of Pountfret, spurrier 0
3720588 1932721 1932721 defendant Clerkson John fisher 586240 586240 Clerkson, John, of Pountfret, fisher 0
3730768 1935848 1935848 defendant Flynt Robert yeoman 586240 586240 Flynt, Robert, of Pountfret, yeoman 0
3734843 1937140 1937140 defendant Dryve Thomas tailor 586240 586240 Dryve, Thomas, of Pountfret, tailor 0
3770572 1948479 1948479 defendant Halyday Thomas butcher 586240 586240 Halyday, Thomas, of Pountfret, butcher 2
3787514 1953884 1953884 defendant Halle Thomas bowyer 586240 586240 Halle, Thomas, of Pountfret, bowyer 0
3809101 1960730 1960730 defendant Turner William yeoman 586240 586240 Turner, William, of Pountfret, yeoman 0
3809103 1960730 1960730 defendant Purser Elizabeth widow 586240 586240 Purser, Elizabeth, of Pountfret, widow 2
3814854 1962561 1962561 plaintiff Gower John tailor 586240 586240 Gower, John, of Pountfret, tailor 0
3821059 1964480 1964480 defendant Whytte William yeoman 586240 586240 Whytte, William, of Pountfret, yeoman 0
3830395 1967395 1967395 defendant Clerkson John yeoman 586240 586240 Clerkson, John, of Pountfret, yeoman 2
3830396 1967395 1967395 defendant Meres John mercer 586240 586240 Meres, John, of Pountfret, mercer 3
3830397 1967395 1967395 defendant Blesby Thomas yeoman 586240 586240 Blesby, Thomas, of Pountfret, yeoman 4
3836118 1969211 1969211 defendant Wakefeld Peter merchant 586240 586240 Wakefeld, Peter, of Pountfret, merchant 1
3836439 1969304 1969304 defendant Aungell William yeoman 586240 586240 Aungell, William, of Pountfret, yeoman 1
3836440 1969304 1969304 defendant Grave Edward shoemaker 586240 586240 Grave, Edward, of Pountfret, shoemaker 2
3845050 1972007 1972007 defendant Uthwhayte John yeoman 586240 586240 Uthwhayte, John, of Pountfret, yeoman 0
4157875 2080830 2080830 defendant Otes Brian laborer 586240 586240 Otes, Brian, of Pountfret, laborer 3
4655242 2247524 2247524 defendant Neweton alias Flesshewer Nicholas butcher 586240 586240 Neweton alias Flesshewer, Nicholas, of Pountfret, butcher 0
4741833 2278105 2278105 defendant Stubbes Nicholas dyer 586240 586240 Stubbes, Nicholas, of Pountfret, dyer 0
4745803 2279279 2279279 defendant Farnhill Wiliam fletcher 586240 586240 Farnhill, Wiliam, of Pountfret, fletcher 2
4757513 2282729 2282729 plaintiff Thornton John   586240 586240 (Thornton, John, of Pountfret, vicar 1
4796090 2294932 2294932 defendant Botiler Thomas cordwainer 586240 586240 Botiler, Thomas, of Pountfret, cordwainer 0
4797069 2295250 2295250 defendant Bayard Robert barker 586240 586240 Bayard, Robert, of Pountfret, barker 0
4855364 2313032 2313032 defendant Boteler Alexander yeoman 586240 586240 Boteler, Alexander, of Pountfret, yeoman 1
4864089 2315744 2315744 defendant Hynderwell William spurrier 586240 586240 Hynderwell, William, of Pountfret, spurrier 0
4864092 2315745 2315745 defendant Hyndewell William spurrier 586240 586240 Hyndewell, William, of Pountfret, spurrier 0
4866363 2316448 2316448 defendant Wilbarn Thomas husbandman 586240 586240 Wilbarn, Thomas, of Pountfret, husbandman 0
4867297 2316735 2316735 defendant Nenette or Nevette William bowyer 586240 586240 Nenette or Nevette, William, of Pountfret, bowyer 2
4873368 2318625 2318625 defendant Pepircorne Isabel widow 586240 586240 Pepircorne, Isabel, of Pountfret, widow 0
4879552 2320531 2320531 defendant Boteler Alexander yeoman 586240 586240 Boteler, Alexander, of Pountfret, yeoman 1
4883136 2321651 2321651 defendant Wilbaron or Wilbarou Thomas yeoman 586240 586240 Wilbaron or Wilbarou, Thomas, of Pountfret, yeoman 0
4886005 2322483 2322483 defendant More Thomas spicer 586240 586240 More, Thomas, of Pountfret, spicer 1
4886006 2322483 2322483 defendant White Thomas yeoman 586240 586240 White, Thomas, of Pountfret, yeoman 2
4898565 2326196 2326196 defendant Barston Richard butcher 586240 586240 Barston, Richard, of Pountfret, butcher 1
4901472 2327064 2327064 defendant Barston Richard butcher 586240 586240 Barston, Richard, of Pountfret, butcher 1
4914664 2331104 2331104 defendant Chapyll William chapman 586240 586240 Chapyll, William, of Pountfret, chapman 0
4927435 2335012 2335012 defendant Huchonson Roger merchant 586240 586240 Huchonson, Roger, of Pountfret, merchant 0
4936492 2337804 2337804 defendant Cade Robert skinner 586240 586240 Cade, Robert, of Pountfret, skinner 0
4939610 2338776 2338776 defendant Arkyn John weaver 586240 586240 Arkyn, John, of Pountfret, weaver 0
4941321 2339310 2339310 defendant Shipley William smith 586240 586240 Shipley, William, of Pountfret, smith 3
4941629 2339400 2339400 defendant del Hall William butcher 586240 586240 del Hall, William, of Pountfret, butcher 0
4969910 2347951 2347951 defendant Frysshe Thomas tailor 586240 586240 Frysshe, Thomas, of Pountfret, tailor 1
4972539 2348717 2348717 defendant Kerby Robert spurrier 586240 586240 Kerby, Robert, of Pountfret, spurrier 2
4997267 2356037 2356037 defendant Gyseley John weaver 586240 586240 Gyseley, John, of Pountfret, weaver 0
4997268 2356037 2356037 defendant Radclyf Thomas yeoman 586240 586240 Radclyf, Thomas, of Pountfret, yeoman 1
5018337 2362249 2362249 defendant Radclyff Thomas yeoman 586240 586240 Radclyff, Thomas, of Pountfret, yeoman 1
5048872 2371296 2371296 plaintiff Salvyngton John   586240 586240 Salvyngton, John, of Pountfret 0
5048873 2371296 2371296 defendant Hunt Thomas slater 586240 586240 Hunt, Thomas, of Pountfret, slater 0
5048874 2371296 2371296 defendant Lokwod Thomas plasterer 586240 586240 Lokwod, Thomas, of Pountfret, plasterer 1
5048946 2371319 2371319 defendant Wikynson Thomas tanner 586240 586240 Wikynson, Thomas, of Pountfret, tanner 0
5056603 2373547 2373547 plaintiff Chaloner Thomas   586240 586240 Chaloner, Thomas, of Pountfret 0
5056604 2373547 2373547 plaintiff Lowe Henry merchant 586240 586240 Lowe, Henry, of Pountfret, merchant 1
5056605 2373547 2373547 defendant Roos William esq 586240 586240 Roos, William, of Pountfret, esq 0
5070036 2377532 2377532 defendant Dewode John dyer 586240 586240 Dewode, John, of Pountfret, dyer 0
5100668 2386620 2386620 defendant Herpham Nicholas yeoman 586240 586240 Herpham, Nicholas, of Pountfret, yeoman 3
5114585 2390675 2390675 defendant Forster Richard yeoman 586240 586240 Forster, Richard, of Pountfret, yeoman 0
5154312 2402419 2402419 defendant Parker William smith 586240 586240 Parker, William, of Pountfret, smith 1
5165184 2405559 2405559 defendant Pereson John cooper 586240 586240 Pereson, John, of Pountfret, cooper 0
5171423 2407367 2407367 defendant Parker William smith 586240 586240 Parker, William, of Pountfret, smith 1
5224672 2422885 2422885 defendant Burley William   586240 586240 Burley, William, of Pountfret 3
5224676 2422886 2422886 defendant Burley William yeoman 586240 586240 Burley, William, of Pountfret, yeoman 2
5285528 2440787 2440787 plaintiff Gyseley John weaver 586240 586240 Gyseley, John, of Pountfret, weaver 0
5288182 2441560 2441560 defendant Wode Henry smith 586240 586240 Wode, Henry, of Pountfret, smith 7
5289307 2441877 2441877 defendant Maymond Robert bowyer 586240 586240 Maymond, Robert, of Pountfret, bowyer 5
5289308 2441877 2441877 defendant Courteney John laborer 586240 586240 Courteney, John, of Pountfret, laborer 6
5289309 2441877 2441877 defendant Andrewe Henry tailor 586240 586240 Andrewe, Henry, of Pountfret, tailor 7
5289310 2441877 2441877 defendant Shankes William barker 586240 586240 Shankes, William, of Pountfret, barker 8
5289311 2441877 2441877 defendant Stanhop John weaver 586240 586240 Stanhop, John, of Pountfret, weaver 9
5290164 2442127 2442127 defendant Hill John yeoman 586240 586240 Hill, John, of Pountfret, yeoman 0
5303829 2446143 2446143 defendant Ratclyff Thomas yeoman 586240 586240 Ratclyff, Thomas, of Pountfret, yeoman 1
5315812 2449801 2449801 defendant Bocher John butcher 586240 586240 Bocher, John, of Pountfret, butcher 5
5333112 2454974 2454974 defendant Bocher John butcher 586240 586240 Bocher, John, of Pountfret, butcher 3
5343173 2458055 2458055 defendant Box or Boy George gent 586240 586240 Box or Boy, George, of Pountfret, gent 0
5343176 2458056 2458056 defendant Box George gent 586240 586240 Box, George, of Pountfret, gent 0
5346235 2458961 2458961 defendant Grene Nicholas yeoman 586240 586240 Grene, Nicholas, of Pountfret, yeoman 0
5346294 2458982 2458982 defendant Roper Thomas chapman 586240 586240 Roper, Thomas, of Pountfret, chapman 2
5350898 2460391 2460391 defendant Strother William yeoman 586240 586240 Strother, William, of Pountfret, yeoman 5
5357548 2462428 2462428 defendant Bocher John butcher 586240 586240 Bocher, John, of Pountfret, butcher 0
5357560 2462433 2462433 defendant Bolle John husbandman 586240 586240 Bolle, John, of Pountfret, husbandman 0
5358101 2462599 2462599 defendant Roper Thomas chapman 586240 586240 Roper, Thomas, of Pountfret, chapman 0
5359750 2463088 2463088 defendant Bull John yeoman 586240 586240 Bull, John, of Pountfret, yeoman 0
5375974 2468077 2468077 defendant Mychell Robert   586240 586240 Mychell, Robert, of Pountfret, hat maker 0
5387337 2471450 2471450 defendant Botefissh Richard   586240 586240 Botefissh, Richard, of Pountfret 1
5392516 2472931 2472931 defendant Patryk John husbandman 586240 586240 Patryk, John, of Pountfret, husbandman 4
5494316 2503203 2503203 defendant Bull John yeoman 586240 586240 Bull, John, of Pountfret, yeoman 0
5509642 2507850 2507850 defendant Stele Katherine widow 586240 586240 Stele, Katherine, of Pountfret, widow 0
5509655 2507854 2507854 defendant Russworth Robert chapman 586240 586240 Russworth, Robert, of Pountfret, chapman 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);