I would like to build a local dataset of monthly averages for rainfall, sunshine hours, temperate (C/F) for all the major cities of the world.

I have all the lon/lat's stored for all the cities I need in SQL, so what is the best way to mine this data?

The links to the monthly Global Historical Climatology Network files seem to be broken, and I wouldn't quite know the best way to parse them.

So say we took 2018 as an example; I just want something like this enter image description here

I can consume an API if there is a free one; but it also looks like what Weather Underground offers;


I know its a lot of data I need, but I really need to find a free source for this data ideally, or at worst one which wont cost hundreds of dollars.

Can anyone help?

  • There are over a 100 questions on this site tagged weather, surely your answer is among them?
    – user4293
    Commented May 2, 2019 at 14:39
  • I’ve just double checked that list in full - no, no similar questions - happy to stand corrected but I want monthly averages for cities; temperature, mm, sunshine and ranges - I see nothing else similar.
    – dhj
    Commented May 2, 2019 at 14:43
  • But wouldn't e.g. daily data be sufficient? You can do the averages.
    – user4293
    Commented May 2, 2019 at 14:44
  • For 5 datasets, and for 6700 cities... probably would exceed most API limits or be unworkable. These averages are on many sites so I can’t be the first to need them. I don’t think the processing is realistic - however if daily sources meet the needs then yes...
    – dhj
    Commented May 2, 2019 at 15:21
  • opendata.stackexchange.com/questions/10154/… may or may not be helpful
    – user3856
    Commented May 23, 2019 at 14:36

1 Answer 1


NOAA is where you should be looking which also has enough historical data and a lot of modalities. They have different options for download. If you are looking for an API, this is a starting point.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.