Hi I need a list of all cities in the USA and their corresponding populations and median incomes put into an Excel CSV file. The entire file will need to range from the highest population cities to the lowest population cities.
In the A column - I need the city, please capitalize the first letter of each city. For example if the city has two words such as:
Altamonte Springs - Please capitalize the "A" and the "S"
In the B column - I need the corresponding state name. For example is the City in column A is: Altamonte Springs, then column B should say: Florida - Please capitalize the first letter of the state. If the state has 2 words, please capitalize each letter such as: New York
In the C column - I need the state abbreviation in ALL CAPS for the corresponding city obviously. For example if the city is: Altamonte Springs then in column C you should have: FL
In the D column - I need the current or last known population count ranging from high to low as stated above.
In the E column - I need the average median income for that particular city.
The price I am willing to pay is $50.00 so please bid $50 to be considered. I will put 100% of the funds in escrow.
There are around 30,000 some cities in the USA. Let me know if you have any questions. Please send me an sample and you will considered first. I would like to get this wrapped up ASAP. I will be posting other projects where I need zip codes, area codes and other lists created. If you do a good job on this one, you will considered for other list projects. Thank you.
14 freelancers are bidding on average $48 for this job
i am working in thomsonreuters as a seniour analyst and have been doing similar kind of work kindly provide me an opportunity to complete the task faster