names

241 rows where place_id = 591511

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604601 1869103 1869103 defendant Wenham John fuller 591511 591511 Wenham, John, of Stratford, fuller 1
3629555 1904100 1904100 defendant Bollyngton John husbandman 591511 591511 Bollyngton, John, of Stratford, husbandman 0
3630524 1904377 1904377 defendant Sawer Robert husbandman 591511 591511 Sawer, Robert, of Stratford, husbandman 1
3630525 1904377 1904377 defendant Wythe John husbandman 591511 591511 Wythe, John, of Stratford, husbandman 2
3631440 1904645 1904645 defendant Mors Edward clothmaker 591511 591511 Mors, Edward, of Stratford, clothmaker 1
3640716 1907540 1907540 defendant Benet John glover 591511 591511 Benet, John, of Stratford, glover 1
3663278 1914440 1914440 defendant Smith John clothmaker 591511 591511 Smith, John, of Stratford, clothmaker 0
3681507 1920307 1920307 defendant Wodward John husbandman 591511 591511 Wodward, John, of Stratford, husbandman 1
3687716 1922326 1922326 plaintiff Cole Robert clothmaker 591511 591511 Cole, Robert, of Stratford, clothmaker 0
3689427 1922852 1922852 defendant Sawer Robert husbandman 591511 591511 Sawer, Robert, of Stratford, husbandman 0
3692986 1924007 1924007 defendant Debnam Thomas weaver 591511 591511 Debnam, Thomas, of Stratford, weaver 0
3693182 1924078 1924078 defendant Deknam Thomas weaver 591511 591511 Deknam, Thomas, of Stratford, weaver 0
3701573 1926740 1926740 defendant Bulkyn Richard husbandman 591511 591511 Bulkyn, Richard, of Stratford, husbandman 1
3709719 1929350 1929350 defendant Howe Thomas clothmaker 591511 591511 Howe, Thomas, of Stratford, clothmaker 0
3716493 1931453 1931453 plaintiff Cole Robert clothier 591511 591511 Cole, Robert, of Stratford, clothier 0
3719829 1932466 1932466 defendant Bartlett Elizabeth widow 591511 591511 Bartlett, Elizabeth, of Stratford Mortymer, widow 1
3724273 1933879 1933879 defendant Howe Thomas clothman 591511 591511 Howe, Thomas, of Stratford, clothman 2
3738464 1938234 1938234 defendant Rychardys John yeoman 591511 591511 Rychardys, John, of Stratford Mortymer, yeoman 0
3739069 1938428 1938428 defendant Wright Simon sherman 591511 591511 Wright, Simon, of Stratford, sherman 0
3740005 1938732 1938732 defendant Howe Thomas clothmaker 591511 591511 Howe, Thomas, of Stratford, clothmaker 0
3741168 1939099 1939099 defendant Howe Thomas baker or yeoman 591511 591511 Howe, Thomas, of Stratford, baker or yeoman 0
3749413 1941731 1941731 defendant Aimes John laborer 591511 591511 Aimes, John, of Stratford, laborer 0
3764563 1946573 1946573 defendant Mannok Richard clothier 591511 591511 Mannok, Richard, of Stratford, clothier 0
3784098 1952808 1952808 defendant Morus Hugh husbandman 591511 591511 (Morus, Hugh, of Stratford, husbandman 1
3788290 1954135 1954135 defendant Haven Robert clothmaker 591511 591511 Haven, Robert, of Stratford, clothmaker 0
3795620 1956515 1956515 defendant Boges Robert clothmaker 591511 591511 Boges, Robert, of Stratford, clothmaker 0
3795634 1956517 1956517 defendant Howe Elizabeth widow 591511 591511 Howe, Elizabeth, of Stratford, widow 3
3814286 1962377 1962377 defendant Shepard Richard sherman 591511 591511 Shepard, Richard, of Stratford, sherman 0
3839002 1970126 1970126 defendant Warde William butcher 591511 591511 Warde, William, of Stratford, butcher 0
3876436 1982364 1982364 defendant Annott William smith 591511 591511 Annott, William, of Stratford, smith 0
3892083 1987604 1987604 defendant Chelston alias Crowe John yeoman 591511 591511 Chelston alias Crowe, John, of Stratford, yeoman 0
3901247 1990642 1990642 defendant Peyton Thomas carrier 591511 591511 Peyton, Thomas, of Stratford, carrier 0
3901248 1990642 1990642 defendant Crane Robert laborer 591511 591511 Crane, Robert, of Stratford, laborer 1
3914778 1995289 1995289 defendant Annott William smith 591511 591511 Annott, William, of Stratford, smith 0
3923321 1998109 1998109 defendant Boggys Robert clothier 591511 591511 Boggys, Robert, of Stratford, clothier 0
3929948 2000358 2000358 defendant Wheatley William vintner 591511 591511 Wheatley, William, of Stratford, vintner 1
3940902 2003962 2003962 defendant Wadward John sheer man 591511 591511 Wadward, John, of Stratford, sheer man 0
3944643 2005224 2005224 defendant Wythe John husbandman 591511 591511 Wythe, John, of Stratford, husbandman 1
3954923 2008787 2008787 plaintiff Lucas John gent 591511 591511 Lucas, John, of Stratford, gent 0
3962104 2011326 2011326 defendant Carnsdale Robert clothier 591511 591511 Carnsdale, Robert, of Stratford, clothier 1
3977659 2016754 2016754 defendant Smyth alias Howell Richard yeoman 591511 591511 Smyth alias Howell, Richard, of Stratford, yeoman 0
3987224 2020178 2020178 plaintiff Wyles Robert (legal representative) 591511 591511 Wyles, Robert, of Stratford, clothier, executors of 0
3987228 2020179 2020179 plaintiff Wyles Robert (legal representative) 591511 591511 Wyles, Robert, of Stratford, clothier, executors of 0
3987353 2020226 2020226 plaintiff Wylys or Wyles Robert (legal representative) 591511 591511 Wylys or Wyles, Robert, of Stratford, husbandman or clothier, executors of 0
4000032 2024776 2024776 defendant Ursett John clothier 591511 591511 Ursett, John, of Stratford, clothier 1
4046804 2041312 2041312 plaintiff Smythe William gent 591511 591511 Smythe, William, of Stratford, gent 0
4052268 2043234 2043234 defendant Gryffyn Robert shoemaker 591511 591511 Gryffyn, Robert, of Stratford, shoemaker 2
4075608 2051579 2051579 defendant Hobson Robert clerk 591511 591511 Hobson, Robert, of Stratford Mortimer, or of Over Marshe, Berks, clerk 0
4077061 2052082 2052082 defendant Blomefyld George husbandman 591511 591511 Blomefyld, George, of Stratford, husbandman 0
4087349 2055765 2055765 defendant Charnoll John tanner 591511 591511 Charnoll, John, of Stratford, tanner 1
4101174 2060729 2060729 defendant Beckett William clothier 591511 591511 Beckett, William, of Stratford, clothier 0
4138706 2074210 2074210 defendant Woodward Thomas sherman 591511 591511 Woodward, Thomas, of Stratford, sherman 1
4155465 2079999 2079999 defendant Cole Richard tailor 591511 591511 Cole, Richard, of Stratford, tailor 0
4156702 2080422 2080422 defendant Blundell John clerk 591511 591511 Blundell, John, of Stratford, clerk 0
4175121 2086761 2086761 defendant Sympson Nicholas yeoman 591511 591511 Sympson, Nicholas, of Stratford, yeoman 0
4185615 2090475 2090475 defendant Sympson Nicholas yeoman 591511 591511 Sympson, Nicholas, of Stratford, yeoman 2
4193523 2093302 2093302 defendant Humfrey Richard tanner 591511 591511 Humfrey, Richard, of Stratford, tanner 0
4193525 2093303 2093303 defendant Pickford William   591511 591511 Pickford, William, of Stratford, card maker 0
4194293 2093552 2093552 defendant Bragge Richard clothier 591511 591511 Bragge, Richard, of Stratford, clothier 0
4197891 2094814 2094814 defendant Charnold John tanner 591511 591511 Charnold, John, of Stratford, tanner 0
4197892 2094814 2094814 defendant Kyng William miller 591511 591511 Kyng, William, of Stratford, miller 1
4208821 2098629 2098629 defendant Sharpe John husbandman 591511 591511 Sharpe, John, of Stratford, husbandman 2
4209398 2098840 2098840 defendant Holde John clothworker 591511 591511 Holde, John, of Stratford, clothworker 1
4210851 2099353 2099353 defendant Bedyngfeld Richard yeoman 591511 591511 Bedyngfeld, Richard, of Stratford, yeoman 1
4213515 2100242 2100242 defendant Kynge William miller 591511 591511 Kynge, William, of Stratford, miller 2
4219928 2102471 2102471 defendant Ravens Richard scheoolmaster 591511 591511 Ravens, Richard, of Stratford, scheoolmaster 1
4219929 2102471 2102471 defendant Nicholson Christopher clothier 591511 591511 Nicholson, Christopher, of Stratford, clothier 2
4241869 2110273 2110273 defendant Simpson Nicholas husbandman 591511 591511 Simpson, Nicholas, of Stratford, husbandman 0
4257782 2115576 2115576 defendant Langford Anthony gent 591511 591511 Langford, Anthony, of Stratford, Leominster, or of Tedston Dallomer, Herefs, gent 0
4274552 2121042 2121042 defendant Collen Thomas clothier 591511 591511 Collen, Thomas, of Stratford, clothier 1
4274553 2121042 2121042 defendant Townes Robert innholder 591511 591511 Townes, Robert, of Stratford, innholder 2
4282464 2123769 2123769 defendant Barber Lawrence tanner 591511 591511 Barber, Lawrence, of Stratford, tanner 1
4352336 2148054 2148054 defendant Mosse Israel gent 591511 591511 Mosse, Israel, of Stratford, gent 0
4353400 2148416 2148416 defendant Fashion Walter gent 591511 591511 Fashion, Walter, of Stratford, gent 0
4401364 2165053 2165053 defendant Bragge Ambrose clothier 591511 591511 Bragge, Ambrose, of Stratford, clothier 1
4406948 2166887 2166887 defendant Beyfeld Ralph clothier 591511 591511 Beyfeld, Ralph, of Stratford, clothier 0
4406949 2166887 2166887 defendant Creake Henry clothier 591511 591511 Creake, Henry, of Stratford, clothier 1
4409452 2167757 2167757 defendant Bonde Samuel tailor 591511 591511 Bonde, Samuel, of Stratford, tailor 3
4440126 2181841 2181841 defendant Westynton William de   591511 591511 Westynton, William de, of Stratford 1
4440127 2181841 2181841 defendant Compton Thomas   591511 591511 Compton, Thomas, of Stratford 2
4440128 2181841 2181841 defendant Filly Richard   591511 591511 Filly, Richard, of Stratford 3
4440951 2182090 2182090 defendant Taverner William   591511 591511 Taverner, William, of Stratford 9
4448980 2184622 2184622 defendant Fullere Thomas   591511 591511 Fullere, Thomas, of Stratford 0
4452094 2185641 2185641 defendant Shephered John   591511 591511 Shephered, John, of Stratford 2
4452116 2185648 2185648 defendant Cookes William butcher 591511 591511 Cookes, William, of Stratford, butcher 1
4464156 2189459 2189459 defendant Chareter John   591511 591511 Chareter, John, of Stratford 1
4466104 2190058 2190058 defendant Sparwode William carpenter 591511 591511 Sparwode, William, of Stratford, carpenter 0
4469100 2191002 2191002 defendant Strout William   591511 591511 Strout, William, of Stratford 0
4477180 2193527 2193527 defendant Hayne Henry   591511 591511 Hayne, Henry, of Stratford 0
4489868 2197539 2197539 defendant Brasyere John   591511 591511 Brasyere, John, of Stratford 0
4499414 2200467 2200467 defendant Shepehurd Richard   591511 591511 Shepehurd, Richard, of Stratford 0
4500085 2200673 2200673 defendant Baker John Remals-servant   591511 591511 Baker, John Remals-servant, of Stratford 0
4508521 2203140 2203140 plaintiff Albyn Ralph baker 591511 591511 Albyn, Ralph, of Stratford, baker 0
4519293 2206390 2206390 plaintiff Edmond John baker 591511 591511 Edmond, John, of Stratford, baker 0
4519295 2206391 2206391 plaintiff Edmond John baker 591511 591511 Edmond, John, of Stratford, baker 0
4521910 2207191 2207191 defendant Smyth Thomas   591511 591511 Smyth, Thomas, of Stratford 1
4522137 2207268 2207268 plaintiff golde William   591511 591511 golde, William, of Stratford 0
4524764 2208083 2208083 defendant Mory John   591511 591511 Mory, John, of Stratford 3
4540758 2213013 2213013 plaintiff Whether John   591511 591511 Whether, John, of Stratford 0
4542661 2213593 2213593 defendant Mory John   591511 591511 Mory, John, of Stratford 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);