Find your city's temperature history

In Sunday's post I'm going to be looking at how outside air temperature impacts your home's energy consumption (mostly because of heating/air conditioning).  In order to do that, I had to find history data on weather in my city.  This was actually harder than I thought.  Here's how to do it in case you would like to do some detailed analysis on your home's energy consumption.

1.) Go to - This is actually a great resource for all weather related data

2.)  At the very top right of the page, type in your zip/city and state and and press Go. - This will pull data from the weather station closest to your city.  If you want to find weather data to a location closer to you, you have the option to choose this.  The weather stations are usually located at airports.

3.)  Under the City name you should see a list of items starting with : Today, Hourly, 10-Day, Calendar, History.  Click on "History"


4.) At the next page you can select: Daily, Weekly, Monthly, or Custom.  


5.)  Scroll down to the bottom of the page and you will see the section "Daily Weather History and Observations". There's your data.  At this point, you can copy the data and paste into excel to perform some more detailed analysis (just make sure to "paste special; text"). Now you have the data you will need to compare how your home's energy consumption is impacted by the temperature outside.  That will be my next blog! Seen here: Outside Temp and Energy Consumption.

enjoyed our post? let others know: 


Jay, Here you go, let me know what you think!
Great info! Do you have any links, examples or resources regarding your excel file? I made one to track my monthly and avg daily kwh, and monthly h2o use, but I'd love to see what you've done. Oh, it looks like that will be your next post - looking forward to it.
Jay, along with my post later I will give instructions on how I created the excel file. All pretty standard stuff but it did take me awhile remembering how to graph on two y axes.


Post new comment

Subscribe to Comments for "Find your city's temperature history"