Format Census Data

170527 Quote Request US Zip Codes


Format 2010 Census data, according to these specifications:

Deliver tab-delimited text file.

Include all Zip Codes in the lower 48 states.

Approximately 40,000 records.

The client primarily is interested in zip codes where

the zip code's area includes any portion of one of

the 50 largest CSA's.

Please provide these seven fields:

1) Zip Code

2) Population

3) Population Density

4) Avg Household Income

5) State

6) County or City

Where a zip code spans more than one county/city, list

the one county/city that covers the largest portion

of the zip code's area.

7) The CSA, where any portion of the area of the zip

code falls within one of the 50 largest CSA's.

CSA - Combined Statistical Area

[url removed, login to view]

Largest 50 CSA's, including ID number

1 New York-Newark, NY-NJ-CT-PA

2 Los Angeles-Long Beach, CA

3 Chicago-Naperville, IL-IN-WI

4 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA

5 San Jose-San Francisco-Oakland, CA

6 Boston-Worcester-Providence, MA-RI-NH-CT

7 Dallas-Fort Worth, TX-OK

8 Philadelphia-Reading-Camden, PA-NJ-DE-MD

9 Houston-The Woodlands, TX

10 Miami-Fort Lauderdale-Port St. Lucie, FL

11 Atlanta-Athens-Clarke-Sandy Springs, GA

12 Detroit-Warren-Ann Arbor, MI

13 Seattle-Tacoma, WA

14 Minneapolis-St. Paul, MN-WI

15 Cleveland-Akron-Canton, OH

16 Denver-Aurora, CO

17 Orlando-Deltona-Daytona Beach, FL

18 Portland-Vancouver-Salem, OR-WA

19 St. Louis-St. Charles-Farmington, MO-IL

20 Pittsburgh-New Castle-Weirton, PA-OH-WV

21 Charlotte-Concord, NC-SC

22 Sacramento-Roseville, CA

23 Salt Lake City-Provo-Orem, UT

24 Kansas City-Overland Park-Kansas City, MO-KS

25 Columbus-Marion-Zanesville, OH

26 Las Vegas-Henderson, NV-AZ

27 Indianapolis-Carmel-Muncie, IN

28 Cincinnati-Wilmington-Maysville, OH-KY-IN

29 Raleigh-Durham-Chapel Hill, NC

30 Milwaukee-Racine-Waukesha, WI

31 Nashville-Davidson–Murfreesboro, TN

32 Virginia Beach-Norfolk, VA-NC

33 Greensboro–Winston-Salem–High Point, NC

34 Jacksonville-St. Marys-Palatka, FL-GA

35 Louisville/Jefferson County–Elizabethtown–Madison, KY-IN

36 New Orleans-Metairie-Hammond, LA-MS

37 Hartford-West Hartford, CT

38 Oklahoma City-Shawnee, OK

39 Grand Rapids-Wyoming-Muskegon, MI

40 Greenville-Spartanburg-Anderson, SC

41 Memphis-Forrest City, TN-MS-AR

42 Birmingham-Hoover-Talladega, AL

43 Harrisburg-York-Lebanon, PA

44 Buffalo-Cheektowaga, NY

45 Albany-Schenectady, NY

46 Rochester-Batavia-Seneca Falls, NY

47 Albuquerque-Santa Fe-Las Vegas, NM

48 Tulsa-Muskogee-Bartlesville, OK

49 Fresno-Madera, CA

50 Knoxville-Morristown-Sevierville, TN

Skills: Data Entry, Data Processing

See more: urdu data inpage format, data extraction format, uae data excel format, microsoft excel, access data entry format, pulling data pdf format, import historical data excel format, collect data xml format, sample supplier data base format excel format, data entry format access, filemaker data excel format, data sheet format, data sheet format excel, store data csv format, data encoder format, convrt data date format sql

About the Employer:
( 0 reviews ) United States

Project ID: #14161696

18 freelancers are bidding on average $162 for this job


Hi, After reviewing the project description I know that I'm an excellent fit for this [login to view URL]'s discuss and start right now. Awaiting for your positive reply thanks.

$200 USD in 7 days
(490 Reviews)

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the informatio More

$250 USD in 3 days
(225 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$200 USD in 2 days
(132 Reviews)

Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportu More

$100 USD in 3 days
(115 Reviews)
$150 USD in 3 days
(48 Reviews)

Dear Employer, I am a student of [login to view URL] Electrical Engineering. It's my main source of income. More than last 5-years having 100+ completed projects along with top positive feedback on my profile easily proof my expertis More

$111 USD in 3 days
(28 Reviews)

4 years of experience in data [login to view URL] science and analytics professional with excellent coding skills in R and Python .  - Proficient in R, Python, SQL,Matlab ; Hands on experience with VBA & Tableau - Stati More

$250 USD in 3 days
(6 Reviews)

Hi There, I’d like to be considered for your position. For years I’ve worked in Engineering and so I am accustomed to working with all sorts of products and services, and in a variety of industries. I have a deep More

$35 USD in 3 days
(18 Reviews)

Hi.. I am interested to your project . I m new here but I believe that I can do this work properly and in timely . I am agree with your budget .And I'm sure that I'll finish the task with your full satisfactio More

$40 USD in 3 days
(3 Reviews)

Hi, I am interested in working for you. I have read your description and I am confident that I can complete the task. I am proficient in excel and data recording. I am detail, precise, organized and always complete More

$111 USD in 3 days
(7 Reviews)

A proposal has not yet been provided

$60 USD in 3 days
(3 Reviews)

I'm a Exel developer for more than 15 years including macros. this task of Zip codes can be completed in rwo days or less.

$177 USD in 2 days
(1 Review)

Hi, I want to do this job for you. I possess advanced MS Access skills that I shall use to do massive data analysis. Here is a good example of what I can do: Late last year and early this year, I consulted for three More

$244 USD in 5 days
(0 Reviews)

have a nice day sir/ma'am, I'm so willing to do the project you have posted, I hope you will give me a chance to do the job. I'm a hardworking person and can do the task efficiently and accurately and I am also a fast More

$111 USD in 3 days
(0 Reviews)

Job will be done, fast! Accurate! On Time! Without any single chance for any complaint! There wouldn't be a single wrong entry, and project won't be delayed by one single day!

$250 USD in 3 days
(0 Reviews)

Hey please share your photos/ design/ ideas/ concept and receive a good deliverable. I'm basically MACHINE DESIGN ENGINEER. I have a very good expertise in Machine design calculation, 3D modelling, Finite Element Analy More

$30 USD in 3 days
(1 Review)

I have been working on the Excel sheets & MS Office products for the past 10 years. I am really good at Internet market research & Data processing. please let me know your feedback.

$333 USD in 5 days
(0 Reviews)
$261 USD in 2 days
(0 Reviews)