Collect climate data for 350 cities

This project was successfully completed by pakee for $77 USD in 5 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 USD
Completed In
5 days
Total Bids
Project Description

The project is to fill in the blank columns in this spreadsheet:
[url removed, login to view]

The spreadsheet contains a list of airports a long with the city and country the airport is located in. The country is in ISO 2-letter format (e.g. CN = China, US = United States, etc.)

There are two tabs in the spreadsheet, one for climate, which has a separate row for each month of the year for each airport, and another one with just one row per airport.

For the Climate tab: fill in the average low temperature, precipitation amount, average days with precipitation, snowfall amount, and average days with snowfall

For the Traffic tab: fill in the number of passengers per year (use 2013 estimated or 2012 actual data).

All of this information is generally available on the web. For example for the city of Chicago you can get climate data here:
[url removed, login to view] (click [show] under the Data section).

Most major cities have a Wikipedia entry like this. For the rest you can search the web.

For the Traffic tab you will need to search airport statistics. In general the website of each airport will have this data. Example:
[url removed, login to view]

You may also find lists of airport statistics:
[url removed, login to view]
[url removed, login to view]'s_busiest_airports_by_passenger_traffic

Please list the link of the data source (where you found the data) in each row in the Ref column.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online