170527 Quote Request US Zip Codes
Objective:
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
[login to view URL]
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