Quandries with Queries: James Gostick of Cosgrove, Northamptonshire

Date: [unknown] [unknown]
Location: Stony Stratford, Buckinghamshire, England, United Kingdom

Gostwick Name Study

James Gostick b 1777, Bedfordshire?, England

James is first seen Dec 1806, Stony Stratford, Bucks, where he marries Susannah Mooring. He settles in Cosgrove, Northamptonshire, where he and Susan have a large family with 10 children. James dies in May of 1844, at the age of 67yrs. We use this to create our first query below

We leverage his wedding location to create a second query to his family. He is shown as living in Stony Stratford, Buckinghamshire in 1806 when he marries. The family is then found in Cosgrove, Northants from 1807-1844.

---

Query #1:

Father born (1777-50=b aft1727) and (1777-16=b bef1760)

or abt (1727-1760) or (abt1744 +/-16yrs)

Select * from (people) where last name contains ("gos") or (("gas") not ("gascoi")) and SEX=M and Born (> 1726), and Born (< 1761)

Returns 33 possible fathers. Many are immediately ruled out for other reasons, such as being in the American Colonies. Instead, this time I flagged them ALL with RED

Query #2:

Then I ran another query:

Select * from (people) where any placename contains "stratford"

Returns around 25 records,

>> showing any that are marked red as the UNION of these two queries.

One Result:

• Gostwick, John, b. bef 1731, d. aft 1750, Cosgrove, Northants married Mary Hobbs

Taking a look at John, we find him marrying in Whaddon, Bucks, which is just west of Blechley..then Woburn, Ampthill, Westoning.

Given the strong logic and single result returned with nothing to the contrary, this is being used to map James Gostick as son of John Gostwick of Cosgrove, as above.

Other info: Executed 16-Oct-2021 against 1199 Male Gostwick-ish profiles. Only one early Gostwick profile added in the last 4yrs (a John b. bef 1400). Near complete, stable dataset, groomed for aliases, and placename normalization. (e.g. no typo'ed 'Stoney Startfords')