Here is my take on it: I use R and its IDE RStudio.
The hard part, cleaning the data, is luckily done. Sharing the CSV via a dropbox link is not bad. The file is well structured. To improve it you could add a licence and provide a bit more information about the source. For more information see our certificates.
If you want to publish in a more "...
For international and historical data, and for a modest number of requests per day, I personally recommend the Wunderground API. Once you register, you can get 500 free requests per day.
The URL for historical data will look like this:
I've posted a sample code (python 2.7) ...
The NOAA / National Weather Service has an archive from the Weather Prediction Center, but it only started archiving most products a few years ago:
Most of what's archived are weather maps (like what ...
The UNDP gathers and reports data along the line of what you are looking for. I think its a matter of finding the right tables. They collect historic data as well as predicating climate changes to countries.
The following link is a repository of some reports and raw data for 61 countries, mostly africa, middle east and south america. Each country has a zip ...
forecast.io also provides historical forecasts through their API. You can call a past date and time and still get the daily, hourly, and minute forecasts (in addition to actual forecasts). That is, ask for the weather on April 16th and will include forecasts for April 20th in the daily summaries.
It's free for under 1,000 calls per day, and then $1 for 10,...
A remodel of weather since 1979, based on many many measurements. The resulting dataset contains daily to hourly values around the globe for many meteorological and climatological parameters such as temperatures, water content, wind, radiation and various fluxes.
The most up to date version of ...
Get the data from BigQuery:
SELECT name, stn, a.wban, TIMESTAMP(CONCAT(year, '-', mo, '-', da)) date, temp, prcp
FROM `bigquery-public-data.noaa_gsod.gsod2*` a
AND name LIKE '%...
For UK & Europe solar data, I've used Photovoltaic Geographical Information System (PVGIS) before. This may be more of a "typical meteorological year" as opposed to a climate database/almanac/normal. It's also data, not an API.
PVSyst has a good resource on finding solar data: Meteo data sources.
As no one's given anything else so far, so might as well make this an official answer.
I'm not aware of any free APIs specifically, but there are various data sources that might be able to give you what you need:
The US Department of Energy's National Renewable Energy Lab offers maps of solar radiation in the US, both annual and monthly averages, although ...
If you are looking for global temperatures that are not constrained to political borders, then you can access 150 years of global temperatures either as a dataset or with Google Earth as an interface. The data is based on latitude and longitude grids of 5 degrees and includes temperature, precipitation, pressure, etc..
https://developer.forecast.io/ (free for low use, then paid after that)
The NOAA data is used by a developer in Chicago to explore the correlation between weather and crime.
There are several related opendata.stackexchange related questions to weather in Europe. Here is a compendium of questions/answers:
Weather radar data for Europe, especially Latvia
Database with monthly climate/weather data by country
What data source for cloud coverage available with forecast and how to parse it?
Historical Weather Forecasts
How might ...
The two links below are NOAA/NWS weather terms used in their datasets:
This document is the vocabulary for the annual summaries:
This document is the vocabulary for the daily summaries
These are a ...
Where are you searching? The NOAA and all of its child departments/organizations provide a plethora of satellite and API datasets, including satellite datasets accessible via API. The list below is a tiny sampling of all three; I cannot stress enough how much more data there is. NOAA is basically a cornucopia of satellite/API datasets.
API Web Service - ...
The US government just last week released climate.data.gov.
From their announcement :
Data from NOAA, NASA, the U.S. Geological Survey, the Department of Defense, and other Federal agencies will be featured on climate.data.gov, a new section within data.gov that opens for business today. The first batch of climate data being made available will focus on ...
The NOAA National Oceangraphic Data Center (NODC) maintains data (and datasets) for sea levels and tides. You can get current (hourly) or historic data back to 1994. The data is collected from 289 stations around the world.
We (met.no) plan on publishing a JSON-LD vocabulary for climate/weather data, when we release our public portal later this year. We'll be publishing JSON-LD ourselves as our primary data format.
To the best of my knowledge, there isn't anything else stable out there yet suitable for this kind of use. The closest you get, AFAIK, is http://codes.wmo.int/
I have written some sample code for directly building a CSV starting with a given date and ending with a given date: https://github.com/joshmalina/pollution/blob/master/notebooks/Build_historical_weather_data.ipynb
The city is currently set to Beijing, but you can change that easily. The data will also be cleaned of null values.
This is very coarse data from the worldbank. It shows historical average temperature per country:
Using their Climate API you can get slightly more detailed information and by per year. I believe they have data going back to 1961.
We have the data you are asking for in our regional Open Data portal (Basque Country, Spain), so I guess you could have it without purchasing it. I do not know how NOAA works, but here, you could send a message to the people in charge of the Open Data portal and they always answer your demands.
Have you tried Google BigQuery?
GBQ has now loaded climate data worldwide from the National Oceanic and Atmospheric Association (NOAA) from over 9,000 weather stations. The data includes 2015 and 2016.
You can query the climate data set using SQL. This queries 14 days of max temperatures (tested just now):
SELECT year, mo, da, temp FROM [bigquery-public-...
The World Glacier Monitoring Service
The World Glacier Monitoring Service hosts database with mainly mass balance, front variation and thickness change data. The main website is:
http://wgms.ch/ the map with data can be found here: http://www.wgms.ch/metadatabrowser.html
The Global Land Ice Measurements from Space initiative hosts another ...
There's a good list of weather data sources on this excellent website created by Robin Wilson, which I duplicate here in case that site ever goes away:
WorldClim: Climate data for past, present and predicted future conditions. Includes temperature (min, max, mean) and precipitation. 1km x 1km resolution.
NCAR GIS Climate Change Scenarios: Lots of data from ...
If there is no well documented API for weatherbase.com, it might be interesting to scrape the information. Here is the list of cities the site contains with their URL. You can select some cities and paste their rows into a csv file. This Python 2 script will read the .csv and extract the average temperature in February for each city. The code is probably ...
If you are after weather data besides the US and need UK data, you can use the 3 hourly reports from data.gov.uk although historically it goes back only to December 2011 and we don't provide a data API.
The interface gives access to three datasets, hourly observations for approximately 150 UK observing stations, daily site specific and 3 hourly site ...
How about NASA GISS Surface Temperature Analysis? Although they have station-oriented timeseries, global coverage seems quite good and they provide monthly average temperatures globally for a ridiculously long time: random sample of a station dataset in Africa (1946-2012):
YEAR JAN FEB ... DEC
1946 24.8 25.9 ... 26.4
1947 26.1 27.3 ... ...
Here is a recently updated climate data set from the University of East Anglia's Climate Research Unit:
It covers 1901-2014, with variables broken down by country at monthly, quarterly and annual intervals.