Like last week, my answer is a strong maybe! I’ve been researching my John Duer, Patriot, and his relationship to his purported son, Thomas for YEARS! I have so much indirect evidence and one piece that does state Thomas was the son of John but it is in a collection made beginning in 1865 that doesn’t provide the source. Of course!
So, I turned to AI to get its take on the problem.
Before I tell you the result, I want to share with you how to take data and create an Excel table using AI. It’s so super simple and saves a lot of time. WARNING: Like with all new tech, you much check for accuracy. Don’t assume it is 100% correct. Even with the time taken for that, it will be a time saver in the long run.
- Create a prompt to “extract structured data from…” whatever you uploaded. From the class I took, it was suggested we add “prioritize fidelity to the information below; dry recitation, avoid editorialization. Prioritize sentence-by-sentence from beginning to end. Extract from the (uploaded item) this structured data… (list whatever info you want). Display your response in the form of a CSV file. The response should have the header row: (titles you want – could be) “Person’s Names”, “Relationships Noted”, “Evidence of the Relationship” (or whatever you deem important). Enclose all cells or fields in quotation marks, omit, ignore, and avoid commas and other punctuation in the original text in your response in an attempt to keep the CSV error-free. Display your response in a code window for easy copy-and-paste.
- Upload your item as a .pdf file.
- A black box will display with the text in white letters. You can ctr c and ctr v into Notepad (you can find notepad by typing Notepad or Text in your computer search bar). Or, you can click on the upper right screen on ChatGPT and share, then copy code.
- Open the file in Excel and clean it up, if necessary.
- Then I opened a new ChatGPT message and gave the following prompt: Today you and I are an expert genealogist and writer. Your goal is to generate true and accurate reports. Find below the contents of a CSV file created from my research on the relationship of John and Thomas Duer. Transform the structured data into a narrative report; dry recitation, no editorialization, please.
- This is what I received:
John Duer was born on January 19, 1748, in Cranbury, Middlesex, New Jersey. Various sources, including family data collections and genealogical websites, document this event. The death of John’s mother, Mary Ann Hollingshead Duer, occurred in 1751 in Newton, Sussex, New Jersey, although specific source documentation is absent beyond public family trees.
In 1773, John married Susannah Miller in Sussex, New Jersey. Their marriage is recorded in the Family Data Collection and referenced in genealogical records from Youngstown and Mahoning County, Ohio. The couple had several children, the first of which was Esther Duer Hopkins, born in Monmouth, New Jersey, in 1774. However, there is a discrepancy in her birth location, as other sources suggest Sussex County, New Jersey, as her birthplace.
John’s military service is confused with that of a cousin who served in the Pennsylvania militia. Despite this error, records from Ohio acknowledge John Duer’s service, including listings in the official roster of American Revolution soldiers buried in Ohio.
Thomas Duer, John’s son, was born in 1775 in Sussex, New Jersey, with multiple sources confirming this, though his gravestone lacks specific dates. Jonathan Duer followed on November 11, 1777, also in Sussex, with his life documented through family data collections and census records.
Joseph Duer’s birth in 1779 is only supported by public family trees, lacking concrete source documentation. In 1780, Mary Duer Hazen, another of John’s daughters, was born in Sussex. Her lineage is established through the DAR lineage book and a family history published in 1947.
John Duer was a church member at the First Baptist Church of Wantage, Sussex, New Jersey, in 1783, with historical records from the Sussex County Historical Society likely supporting this fact. His military service is further documented in DAR and New Jersey Revolutionary War records, as well as in family genealogical files.
In the following years, John resided in Newton, Sussex, New Jersey, where he is listed as a vestryman in a history of Christ Church, and in Hanover Township, Morris County, New Jersey, as indicated by tax records. He also engaged in land transactions, including purchasing land that would later become part of West Virginia, and in 1797, he was a resident of Mansfield Township, Sussex, New Jersey, acting as a bondsman.
John’s life from 1798 to 1829 included various land dealings, military service records, family events such as the deaths of his sister Anna Duer Hull and his son Thomas Duer, and his own death on April 3, 1831, in Jackson Township, Trumbull, Ohio. His will was probated in March 1832, and his estate included guardianship arrangements for his grandchildren.
The narrative concludes with references to Thomas Duer’s estate papers, tax records, and land transactions that involved John Duer and his son Thomas. The document also notes a DNA connection to the family through Elizabeth Suriner and references to historical maps and newspaper articles related to the Duer family in Hubbard, Trumbull, Ohio.
Interesting, huh?! Nowhere in the csv data did it say that Thomas was John’s son. My headings were Date, Event, Place, Source, Name. Would this be accepted by a lineage society? Definitely not but it was an unbiased analysis of the indirect evidence. I did provide in the prompt to look for a relationship of John and Thomas Duer but did not state it was father-son.
I’d love to hear what you find in using AI to establish relationship.