names

135 rows where place_id = 586546

✎ 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
3589003 1864211 1864211 defendant Stowe Thomas chapman 586546 586546 Stowe, Thomas, of Stratford on Avon, Warks, chapman 2
3590093 1864541 1864541 defendant Whalley James yeoman 586546 586546 (Whalley, James, of Stratford on Avon, Warks, yeoman 4
3590099 1864542 1864542 defendant Whalley James yeoman 586546 586546 (Whalley, James, of Stratford on Avon, Warks, yeoman 4
3597517 1866845 1866845 defendant Belamy John mercer 586546 586546 Belamy, John, of Stratford on Avon, Warks, mercer 1
3599986 1867650 1867650 defendant Stewe Richard chapman 586546 586546 Stewe, Richard, of Stratford on Avon, Warks, chapman 1
3602173 1868346 1868346 defendant Hannys alias Smyth William chapman 586546 586546 Hannys alias Smyth, William, of Stratford on Avon, Warks, chapman 1
3602177 1868347 1868347 defendant Hannys alias Smyth William chapman 586546 586546 Hannys alias Smyth, William, of Stratford on Avon, Warks, chapman 0
3614595 1872213 1872213 defendant Smyth Wolfram chapman 586546 586546 Smyth, Wolfram, of Stratford on Avon, Warks, chapman 1
3703707 1927439 1927439 defendant (not given) Thomas rector of Stokke 586546 586546 Stokke, Thomas, of Stratford on Avon, Warks, rector of Pendocke, Worcs 0
3708120 1928837 1928837 defendant Edwardys Elizabeth widow 586546 586546 Edwardys, Elizabeth, of Stratford on Avon, Warks, widow 0
3709477 1929267 1929267 defendant Edward Mathew mercer 586546 586546 Edward, Mathew, of Stratford on Avon, Warks, mercer 0
3736251 1937577 1937577 defendant Ketylby Elizabeth widow 586546 586546 Ketylby, Elizabeth, of Stratford on Avon, Warks, widow 3
3737749 1938028 1938028 defendant Wylkynson alias Sadler John saddler 586546 586546 (Wylkynson alias Sadler, John, of Stratford on Avon, Warks, saddler 1
3738497 1938246 1938246 defendant Edwardys Elizabeth widow 586546 586546 Edwardys, Elizabeth, of Stratford on Avon, Warks, widow 0
3923062 1998016 1998016 defendant Sutton Andrew tailor 586546 586546 Sutton, Andrew, of Stratford on Avon, Warks, tailor 3
3943159 2004728 2004728 defendant Clopton William   586546 586546 Clopton, William, of Stratford on Avon, Warks, esq, son of William clopton, of Clopton, Stratford on Avon 0
3944878 2005303 2005303 defendant Rogers Henry butcher 586546 586546 Rogers, Henry, of Stratford on Avon, Warks, butcher 1
3951519 2007586 2007586 defendant Chester Ralph fuller 586546 586546 Chester, Ralph, of Stratford on Avon, Warks, fuller 3
3954696 2008707 2008707 defendant Swallowe Clement gent 586546 586546 Swallowe, Clement, of Stratford on Avon, Warks, gent 1
3958750 2010137 2010137 defendant Harryngton Richard draper 586546 586546 Harryngton, Richard, of Stratford on Avon, Warks, draper 0
3963317 2011770 2011770 defendant Smyth William mercer 586546 586546 Smyth, William, of Stratford on Avon, Warks, mercer 0
3968891 2013746 2013746 defendant Bette William gent 586546 586546 Bette, William, of Stratford on Avon, Warks, gent 0
3973799 2015406 2015406 defendant Lane John yeoman 586546 586546 Lane, John, of Stratford on Avon, Warks, yeoman 0
3976991 2016520 2016520 plaintiff Lane Nicholas yeoman 586546 586546 Lane, Nicholas, of Stratford on Avon, Warks, yeoman 0
3996467 2023495 2023495 defendant Annes John husbandman 586546 586546 Annes, John, of Stratford on Avon, Warks, husbandman 0
4015952 2030393 2030393 defendant Smythe William draper 586546 586546 (Smythe, William, of Stratford on Avon, Warks, draper 1
4017484 2030957 2030957 defendant Browne John chapman 586546 586546 Browne, John, of Stratford on Avon, Warks, chapman 1
4020371 2032007 2032007 defendant Welshe Roger chapman 586546 586546 Welshe, Roger, of Stratford on Avon, Warks, chapman 0
4037971 2038226 2038226 defendant Harbage Henry skinner 586546 586546 Harbage, Henry, of Stratford on Avon, Warks, skinner 1
4045937 2040996 2040996 plaintiff Shaxbere John yeoman 586546 586546 Shaxbere, John, of Stratford on Avon, Warks, yeoman 0
4059326 2045728 2045728 defendant Lewes William mercer 586546 586546 Lewes, William, of Stratford on Avon, Warks, mercer 0
4067560 2048715 2048715 defendant Brogden Thomas draper 586546 586546 Brogden, Thomas, of Stratford on Avon, Warks, draper 0
4075337 2051481 2051481 defendant Lockey or Locke John woolman 586546 586546 Lockey or Locke, John, of Stratford on Avon, Warks, woolman 1
4080126 2053203 2053203 defendant Willyams alias Lewes William mercer 586546 586546 Willyams alias Lewes, William, of Stratford on Avon, Warks, mercer 0
4081342 2053636 2053636 defendant Hill William glover 586546 586546 Hill, William, of Stratford on Avon, Warks, glover 0
4098519 2059800 2059800 defendant Harrington Richard yeoman 586546 586546 Harrington, Richard, of Stratford on Avon, Warks, yeoman 2
4100722 2060579 2060579 defendant ap Williams Lewis chapman 586546 586546 ap Williams, Lewis, of Stratford on Avon, Warks, chapman 0
4102646 2061247 2061247 defendant Rogers William chapman 586546 586546 Rogers, William, of Stratford on Avon, Warks, chapman 0
4107324 2062910 2062910 defendant Lane John yeoman 586546 586546 Lane, John, of Stratford on Avon, Warks, yeoman 0
4111821 2064478 2064478 defendant Bragden Thomas draper 586546 586546 Bragden, Thomas, of Stratford on Avon, Warks, draper 0
4117604 2066591 2066591 defendant Queney Adrian chapman 586546 586546 Queney, Adrian, of Stratford on Avon, Warks, chapman 0
4123750 2068794 2068794 defendant Sponer Richard chapman 586546 586546 Sponer, Richard, of Stratford on Avon, Warks, chapman 1
4127050 2069964 2069964 defendant ap William Lewis yeoman 586546 586546 ap William, Lewis, of Stratford on Avon, Warks, yeoman 2
4133655 2072370 2072370 defendant Byrde Basil husbandman 586546 586546 Byrde, Basil, of Stratford on Avon, Warks, husbandman 0
4146615 2076970 2076970 defendant Roche Walter clerk 586546 586546 Roche, Walter, of Stratford on Avon, Warks, clerk 0
4146984 2077092 2077092 defendant Lewes alias Wyllyams William chapman 586546 586546 Lewes alias Wyllyams, William, of Stratford on Avon, Warks, chapman 0
4146991 2077094 2077094 defendant Spooner Richard chapman 586546 586546 Spooner, Richard, of Stratford on Avon, Warks, chapman 1
4160069 2081586 2081586 defendant Wheler John yeoman 586546 586546 Wheler, John, of Stratford on Avon, Warks, yeoman 0
4168435 2084446 2084446 defendant Smythe John salter 586546 586546 Smythe, John, of Stratford on Avon, Warks, salter 1
4177239 2087507 2087507 defendant More Philip   586546 586546 More, Philip, of Stratford on Avon, Warks, surgeon 0
4201556 2096090 2096090 defendant Badger George draper 586546 586546 Badger, George, of Stratford on Avon, Warks, draper 2
4203679 2096845 2096845 defendant Smyth John chapman 586546 586546 Smyth, John, of Stratford on Avon, Warks, chapman 0
4204904 2097256 2097256 defendant Browne John draper 586546 586546 Browne, John, of Stratford on Avon, Warks, draper 0
4213247 2100149 2100149 defendant Clapton William gent 586546 586546 Clapton, William, of Stratford on Avon, Warks, gent 1
4219278 2102238 2102238 defendant Jeffereys John gent 586546 586546 Jeffereys, John, of Stratford on Avon, Warks, gent 0
4230742 2106251 2106251 defendant Welshe Roger haberdasher 586546 586546 Welshe, Roger, of Stratford on Avon, Warks, haberdasher 0
4290867 2126792 2126792 defendant Quyney Richard chapman 586546 586546 Quyney, Richard, of Stratford on Avon, Warks, mercer, chapman 0
4326072 2139090 2139090 defendant Parsons William draper 586546 586546 Parsons, William, of Stratford on Avon, Warks, draper 0
4330661 2140548 2140548 defendant Quyney Adrian chapman 586546 586546 Quyney, Adrian, of Stratford on Avon, Warks, chapman 0
4333873 2141614 2141614 defendant Hitchcock Isaac yeoman 586546 586546 Hitchcock, Isaac, of Stratford on Avon, Warks, yeoman 1
4336669 2142554 2142554 defendant Bent William chapman 586546 586546 Bent, William, of Stratford on Avon, Warks, chapman 0
4337104 2142701 2142701 defendant Price Thomas tinker 586546 586546 Price, Thomas, of Stratford on Avon, Warks, tinker 0
4337141 2142717 2142717 defendant Smythe John vintner 586546 586546 Smythe, John, of Stratford on Avon, Warks, vintner 0
4341817 2144414 2144414 defendant Badger George draper 586546 586546 Badger, George, of Stratford on Avon, Warks, draper 0
4346531 2146037 2146037 defendant Parsons Williams draper 586546 586546 Parsons, Williams, of Stratford on Avon, Warks, draper 0
4346533 2146038 2146038 defendant Parsons Williams draper 586546 586546 Parsons, Williams, of Stratford on Avon, Warks, draper 0
4346797 2146130 2146130 defendant Maunde Edward yeoman 586546 586546 Maunde, Edward, of Stratford on Avon, Warks, yeoman 2
4348763 2146828 2146828 defendant Smythe John haberdasher 586546 586546 Smythe, John, of Stratford on Avon, Warks, haberdasher 0
4350072 2147283 2147283 defendant Dickson alias Waterman Richard yeoman 586546 586546 Dickson alias Waterman, Richard, of Stratford on Avon, Warks, yeoman 0
4350725 2147506 2147506 defendant Badger George chapman 586546 586546 Badger, George, of Stratford on Avon, Warks, chapman 0
4354137 2148674 2148674 defendant Perrye William butcher 586546 586546 Perrye, William, of Stratford on Avon, Warks, butcher 0
4356856 2149630 2149630 defendant Smythe John vintner 586546 586546 Smythe, John, of Stratford on Avon, Warks, vintner 0
4360398 2150885 2150885 defendant Price Thomas tinker 586546 586546 Price, Thomas, of Stratford on Avon, Warks, tinker 0
4388451 2160775 2160775 defendant Perry William butcher 586546 586546 Perry, William, of Stratford on Avon, Warks, butcher 1
4393316 2162367 2162367 defendant Reynold Thomas gent 586546 586546 Reynold, Thomas, of Stratford on Avon, Warks, gent 0
4404212 2165978 2165978 defendant Smythe John chapman 586546 586546 Smythe, John, of Stratford on Avon, Warks, chapman 2
4405211 2166321 2166321 defendant Smythe John haberdasher 586546 586546 Smythe, John, of Stratford on Avon, Warks, haberdasher 0
4876660 2319671 2319671 defendant Salford Hugh yeoman 586546 586546 Salford, Hugh, of Stratford on Avon, Warks, yeoman 0
4879328 2320465 2320465 defendant Whetston John yeoman 586546 586546 Whetston, John, of Stratford on Avon, Warks, yeoman 2
4879350 2320470 2320470 defendant Whetston John yeoman 586546 586546 Whetston, John, of Stratford on Avon, Warks, yeoman 2
4936706 2337863 2337863 defendant Forst Roger mercer 586546 586546 Forst, Roger, of Stratford on Avon, Warks, mercer 0
4948292 2341444 2341444 defendant Frost Roger chapman 586546 586546 Frost, Roger, of Stratford on Avon, Warks, chapman 2
4948296 2341445 2341445 defendant Frost Roger chapman 586546 586546 Frost, Roger, of Stratford on Avon, Warks, chapman 2
5036008 2367389 2367389 defendant Vysshelake Hugh weaver 586546 586546 Vysshelake, Hugh, of Stratford on Avon, Warks, weaver 0
5052835 2372437 2372437 defendant Skynner John skinner 586546 586546 Skynner, John, of Stratford on Avon, Warks, skinner 3
5060408 2374689 2374689 defendant Gayton Robert merchant 586546 586546 Gayton, Robert, of Stratford on Avon, Warks, merchant 0
5061822 2375133 2375133 defendant Kent Thomas husbandman 586546 586546 Kent, Thomas, of Stratford on Avon, Warks, husbandman 0
5075357 2379127 2379127 defendant Hore Thomas chapman 586546 586546 Hore, Thomas, of Stratford on Avon, Warks, chapman 0
5080141 2380547 2380547 defendant Compton Thomas mercer 586546 586546 Compton, Thomas, of Stratford on Avon, Warks, mercer 0
5085591 2382182 2382182 defendant Powys William butcher 586546 586546 Powys, William, of Stratford on Avon, Warks, butcher 0
5088944 2383142 2383142 defendant Gayton Robert merchant 586546 586546 Gayton, Robert, of Stratford on Avon, Warks, merchant 0
5090751 2383683 2383683 defendant Wyseman Thomas yeoman 586546 586546 Wyseman, Thomas, of Stratford on Avon, Warks, yeoman 2
5092278 2384124 2384124 defendant Hall Edward mercer 586546 586546 Hall, Edward, of Stratford on Avon, Warks, mercer 0
5110607 2389501 2389501 defendant Tallaunt Robert yeoman 586546 586546 Tallaunt, Robert, of Stratford on Avon, Warks, yeoman 2
5226384 2423385 2423385 defendant Walker Henry husbandman 586546 586546 Walker, Henry, of Stratford on Avon, Warks, husbandman 2
5226393 2423386 2423386 defendant Alcotys Richard husbandman 586546 586546 Alcotys, Richard, of Stratford on Avon, Warks, husbandman 3
5226399 2423387 2423387 defendant Wylcottys William huysbandman 586546 586546 Wylcottys, William, of Stratford on Avon, Warks, huysbandman 1
5226422 2423390 2423390 defendant Powes William butcher 586546 586546 Powes, William, of Stratford on Avon, Warks, butcher 2
5230105 2424421 2424421 defendant Oxton John yeoman 586546 586546 Oxton, John, of Stratford on Avon, Warks, yeoman 2
5238161 2426749 2426749 defendant Wyllot William baker 586546 586546 Wyllot, William, of Stratford on Avon, Warks, baker 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);