Where can I find historical rainfall data?

Historical rainfall data is easy to obtain from various sources, but the best options differ depending upon your needs. Below, we’ll help sort through the options to find the easiest and best way to obtain historical rainfall data for your project.

Single Location and Single Date

If you need historical rainfall data for only a single location and a single date, you can use a weather history page such as Weather Underground. For example, the following URL will give you weather history data for Herndon, VA.

https://visualcrossing.com/weather-history/Herndon,%20VA/us/last15days

Simply select the specific date(s) in which you are interested, and the metrics on the page will update to show the weather on that date. To find the rainfall on that date, scroll down the page until you see the precipitation section.

There are some great features to note about this method. First, the data is presented on a web page that shows informative graphs and tables to be very human friendly. Users can scroll to the weather station map at the bottom of the page to see exactly where their nearest stations are and which ones typically contribute to their historical weather data observations.

Another valuable feature is the ability to see how your current selection compares to a 10-year “typical” weather pattern for this location and time. The color-coded area graphs that serve as a background your selected weather will tell you how it compares to those averages.

Finally, this dashboard has a few hidden features for more advanced users or those that are looking to take the next step with weather. By clicking on the ‘Download’ button you will be taken to the Query Builder page where your current query will automatically select the options and show you the raw data that is available for download for users with accounts. (free accounts are available) Even more advanced users can click on the ‘API’ button to see the Web URL query string that can be used to retrieve data in browsers, web, excel and other applications that can utilize RESTful web queries.

There are also some negatives related to this method. One primary limitation is the inability to load more than a single location. If you need data for multiple locations or dates, this process will become tedious very quickly.

Multiple Locations

If you need access to a solution that can handle multiple locations, then a more robust option such as Visual Crossing Query Builder is likely the best for you. Data is available in CSV, Excel and JSON formats for easy download, scheduling or direct API query.

For a full tutorial on the Query Builder you can utilize the following guide:

To get started quickly we will use the “Download” link above to get to our query immediately.

Once in the Query Builder you will see the raw data in a table ready for download or modification:

From this point, you can advance as far as you would like with choosing weather options, hourly/daily, weather metrics and much more. To query for more locations, simply choose one of the following Location sections:

Then add a location such as “Chicago, IL” and click the ‘+’ button:

Some of the positives of this approach are that you can easily get data get data for many locations for large date ranges very quickly. You can even import an entire list of thousands of locations at a time.

Now we can return back to the ‘View Data’ section and click ‘Download’. This will give us a good set of options to choose from including hourly/daily and the format we would like the data. We recommend CSV for its versatility and readability even as plain text. It easily imports into any database or spreadsheet tools such as excel. It also has the benefit of including all locations into a single file of data.

Finally, clicke “Download” after the query finishes running. The file will appear in your browser download section. Be aware that some browser security will either not allow or hide the download until you give it permission. A small icon in the upper right will indicate if there was an issue.

Now that you have your CSV file you can analyze it in a variety of tools.

Approach

Another positive is that the Visual Crossing Weather tool relies on the highest quality government weather reporting stations and will automatically interpolate among multiple stations in order to find the most valid weather details for a given location and time. This means that you don’t need to worry about selecting a “major” reporting station or manually account for situations where a specific station does not report valid data. The tool will automatically handle these cases without your intervention. You can read more about how we process integrated surface database historical weather data.

Summary

You can find historical rainfall and other metrics from various sources. If you need data for only a single location and date, a site such as Visual Crossing History Dashboard can be used to view historical weather data easily. However, if you have need data for multiple dates and locations, a more robust weather data source such as Visual Crossing Query Builder can get you the data that you need without the slowness and frustration of the more basic consumer web page options. In addition, if you need the weather data in an analysis tool such as Excel, Google Sheets, or a database, then Visual Crossing Weather is the far better option.