Perhaps already suggested?

('Looks like the data up to ~2005 are here, but not as a tabulated digital dataset...)

https://www.amazon.com/Historical-Gazetteer-United-States-Hellmann/dp/0415939488
Historical Gazetteer of the United States: Hellmann, Paul T.: 9780415939485: Amazon.com: Books<https://www.amazon.com/Historical-Gazetteer-United-States-Hellmann/dp/0415939488>
Historical Gazetteer of the United States [Hellmann, Paul T.] on Amazon.com. *FREE* shipping on qualifying offers. Historical Gazetteer of the United States
www.amazon.com



Edward A. Sullivan, III

Senior Technical Associate

Email: [log in to unmask]<mailto:[log in to unmask]>


Economic & Planning Systems (EPS)
1330 Broadway, Suite 450
Oakland, CA 94612
T 510-841-9190
http://www.epsys.com<http://www.epsys.com/>


 [EPS_Logo_01]



Due to the potential that information exchanged by electronic media can deteriorate, be damaged, lost or modified, intentionally or otherwise, use of this electronic data by anyone other than Economic & Planning Systems, Inc. shall be at the sole risk of such user and without liability or legal exposure to Economic & Planning Systems, Inc.



The recipient is responsible for verifying the accuracy of data against governing hard copy documentation.  If there is a discrepancy between the hard copy and the electronic copy, the hard copy will govern.



Recipient assumes all risks in the changing or modification of data and revisions or updating of hard copy documents.


________________________________
From: Maps-L: Map Librarians, etc. <[log in to unmask]> on behalf of Sierra Laddusaw <[log in to unmask]>
Sent: Thursday, February 2, 2023 1:44 PM
To: [log in to unmask] <[log in to unmask]>
Subject: Re: dataset of US towns including when they were founded


I’m not aware of that dataset already existing – but I wonder if your researcher could query from Wikidata? It certainly wouldn’t be complete but is away to start compiling the dataset.



Two ways pop to mind:

  1.  They could form a query that pulls location name, date of founding (in Wikidata “inception”), and the coordinate location. The researcher would need to look around to see the different “instances of” for locations that they would want included in the query – these might be “city in the United Sates,” “village in the United States,” “town in the United States,” etc.



A quick and dirty query that lists date of inception and coordinates, only pulling locations listed as in Wikidata as a “city in the United Sates”: https://w.wiki/6Hum I’m sure someone with actual SPARQL capabilities could create a better query.



  1.  Locations in Wikidata often include their GeoNames ID, so the researcher could query Wikidata for date of founding and GeoNames ID then merge with the GeoNames dataset for lat/long and all their other data.



Either way would take time and cleanup.



Sierra Laddusaw
(she/her)

Associate Librarian | Scholarly Communication Librarian
Boreham Library
University of Arkansas - Fort Smith

479.788.7217 | [log in to unmask]<mailto:[log in to unmask]>









From: Maps-L: Map Librarians, etc. <[log in to unmask]> On Behalf Of Susan Powell
Sent: Thursday, February 2, 2023 2:54 PM
To: [log in to unmask]
Subject: dataset of US towns including when they were founded



You don't often get email from [log in to unmask]<mailto:[log in to unmask]>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>

CAUTION: This e-mail originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hello all,

I received a question from a researcher looking for a "dataset of all the towns in the USA and the dates they were founded."



The first thing that came to my mind were gazetteers, but none of the digital/data-based once I looked at included dates.



There are a few book gazetteers I found that appear to have founding date information:

Historical Gazetteer of the United States by Paul T. Hellmann (not comprehensive)

American places dictionary : a guide to 45,000 populated places, natural features, and other places in the United States ... in four volumes by Abate, Frank R.

Omni gazetteer of the United States of America, by Abate, Frank S



The researcher mentioned a Census dataset that costs money.



Does anyone know of something like this that's available in dataset form?

Many thanks!

Susan



--

Susan Powell

GIS & Map Librarian

UC Berkeley

[log in to unmask]<mailto:[log in to unmask]>

pronouns: she/her/hers