Introduction
In this article, I have included a large amount (>27 Gb) of daily temperature data from monitoring stations across the world. This data contains daily Tmax, Tmin and Trange at each monitoring station.
The data included in these downloadable files were extracted from the GHCN on 3/18/2017. For each monitoring station, the data that was retained included the following:
- Both Tmax and Tmin were available for each day
- No quality assurance or quality control issues were identified for either Tmax or Tmin
- All available data that met 1&2 above is included.
Tonight I checked the repository links (https://www.ncdc.noaa.gov/oa/climate/ghcn-daily) to verify their accuracy, and it turns out that the links have now changed (https://www.ncdc.noaa.gov/data-access/land-based-station-data/land-based-datasets/global-historical-climatology-network-ghcn) (Thanks for the info, Craig Jackson). This website reorganization is good as it appears that more data is now available and the monitoring station stats have been updated.
US State Daily Temperature Data
You can click each link to download the state-level max and min temperature data set. Figure 2 shows what you get in each file.
Figure 3 shows a partial listing (the top 10) of the 50 states worth of data that is included in the following links. Click here for an Excel file that gives you the file sizes for the *.csv and *.zip files for each state.
US State Daily Data Download Links
The total size of these zip files is approximately 1.7 Gb. The first two zip files include all the states and they are big at 840 and 928 Mb. If you don’t want data from all the states, you can download each state one-by-one.
- States_1_25 (840 Mb = Big File)
- States_26_50 (928 Mb = Big File)
- AK_Daily_Temps
- AL_Daily_Temps
- AR_Daily_Temps
- AZ_Daily_Temps
- CA_Daily_Temps
- CO_Daily_Temps
- CT_Daily_Temps
- DE_Daily_Temps
- FL_Daily_Temps
- GA_Daily_Temps
- HI_Daily_Temps
- IA_Daily_Temps
- ID_Daily_Temps
- IL_Daily_Temps
- IN_Daily_Temps
- KS_Daily_Temps
- KY_Daily_Temps
- LA_Daily_Temps
- MA_Daily_Temps
- MD_Daily_Temps
- ME_Daily_Temps
- MI_Daily_Temps
- MN_Daily_Temps
- MO_Daily_Temps
- MS_Daily_Temps
- MT_Daily_Temps
- NC_Daily_Temps
- ND_Daily_Temps
- NE_Daily_Temps
- NH_Daily_Temps
- NJ_Daily_Temps
- NM_Daily_Temps
- NV_Daily_Temps
- NY_Daily_Temps
- OH_Daily_Temps
- OK_Daily_Temps
- OR_Daily_Temps
- PA_Daily_Temps
- RI_Daily_Temps
- SC_Daily_Temps
- SD_Daily_Temps
- TN_Daily_Temps
- TX_Daily_Temps
- UT_Daily_Temps
- VA_Daily_Temps
- VT_Daily_Temps
- WA_Daily_Temps
- WI_Daily_Temps
- WV_Daily_Temps
- WY_Daily_Temps
Non-US Country Daily Data Download Link
Figure 4 shows a partial listing (the top 10) of the 174 countries worth of data that is included in the following link. Click here to get an Excel file showing you the complete content and file sizes for each of these countries. Note that the California *.csv data is nearly as big as the data from the entire country of Russia!
The link shown below will send a 717 Mb zip file down to your machine (so ready to wait a few minutes for the download to complete, depending upon your internet speed).
An Example Tableau Workbook
You can build a lot of different types of workbooks and dashboards for this data. Figure 5 is an example for Nebraska for the month of March. Click here to retrieve a zipped version of the Tableau workbook that created this dashboard. All you have to do is use the replace data source feature to use this dashboard with any of the other state or country *.csv files.
Figure 6 shows an example of daily data averaged by month and then by decade for a monitoring station in Arkansas. The total time span is 130 years.
Final Thoughts
The next article in the series will include monthly aggregated temperature data, followed by decade-level data and a few other things. Once that is done, I’ll move onto publishing the precipitation, snow, and snow depth data in these easy-to-use formats. Thanks for reading.
Pingback: 3danim8's Blog - Global Climate Data Set 2 – Monthly and Decade Average Temperatures
Pingback: Dashboard Week: Day 5 - Daily Temperatures Around the World - The Data School
Pingback: Week 51: Global Temperature Anomalies | Makeover Monday