As described by The Global Historical Climatology Network, the GHCN is an integrated database of climate summaries from land surface stations across the globe that have been subjected to a common suite of quality assurance reviews. The data are obtained from more than 20 sources. Some data are more than 175 years old while others are less than an hour old.
As of Version: 3.27-upd-2019081018, there are 113,933 stations in the archive.
The files in this repo can be used to maintain a local verion of a gzip'ed GHCN tar file and build a SQLite database of the stations and inventories for querying.
Add query functions that search for stations within a radius of a given location and have the desired inventory of measurements (type and time).
Menne, M.J., I. Durre, R.S. Vose, B.E. Gleason, and T.G. Houston, 2012: An overview of the Global Historical Climatology Network-Daily Database. Journal of Atmospheric and Oceanic Technology, 29, 897-910, doi:10.1175/JTECH-D-11-00103.1.
Menne, M.J., I. Durre, B. Korzeniewski, S. McNeal, K. Thomas, X. Yin, S. Anthony, R. Ray, R.S. Vose, B.E.Gleason, and T.G. Houston, 2012: Global Historical Climatology Network - Daily (GHCN-Daily), Version 3.27.