Collect climate data for 350 cities

IN PROGRESS
Bids
69
Avg Bid (USD)
$132
Project Budget (USD)
$30 - $250

Project Description:
The project is to fill in the blank columns in this spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0Av-CaUz6lJ45dFVFbzduMlVzSUZZOVdXbjNKR3lTOUE&usp=sharing

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:
http://en.wikipedia.org/wiki/Climate_of_Chicago (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:
http://www.fraport.com/en/investor-relations/financial-and-air-traffic-figures/traffic-figures.html

You may also find lists of airport statistics:
http://www.faa.gov/airports/planning_capacity/passenger_allcargo_stats/passenger/index.cfm?year=2012
http://en.wikipedia.org/wiki/World'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.

Skills required:
Data Entry, Excel, Web Scraping, Web Search
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire dataworker2009
$ 128
in 3 days
$ 185
in 3 days
$ 154
in 3 days
$ 144
in 3 days
$ 144
in 3 days
$ 157
in 3 days
$ 111
in 3 days
$ 147
in 4 days
Hire pandey2008
$ 84
in 3 days
$ 151
in 4 days