Jason Salas' WebLog

On-air and online: making people laugh, making people think, pissing people off

Sponsors

ASP.NET sites that kick ass

Pals with blogs

Podcasts I listen to

Neat little CSV with US/territorial zip & area codes

Bill Bercik has a nice little Ajax programming tutorial in PHP for dynamically displaying city names and area codes after a user specifices a zip code.  The key component of the downloadable source code is a CSV that contains nearly 42,800 zip codes and area codes for U.S. cities and cities within U.S. territories, which can be easily imported into a database.  It's a great source for data if you're developing apps or utilities involving geocoding.

You can download the tutorial containing the CSV here: http://www.webpasties.com/xmlHttpRequest/complete.zip

Thanks Bill!

 

Posted: Sep 26 2005, 03:15 PM by guam-aspdev | with 10 comment(s)
Filed under:

Comments

Nick said:

Thanks for this.

I didn't use the tutorial but took out the csv zipcode file, it works brilliantly.  He's also got area codes for phone numbers by zipcode in there

# January 22, 2009 12:14 AM

Corbin said:

Jason:

Thank you for sharing this! I am deep in the midst of a project requiring comprehensive US city listings, and your zip code file saved me a mount of time.

# February 12, 2009 1:13 PM

Emile said:

Thanks!

It's perfect. I not only use it for coding stuff, but just keep it around on my drive to egrep. Thank again for sharing.

# May 2, 2009 7:58 PM

Alice G said:

Wonderful package. Was looking to get some demographic by city based on area code of callers and now I can do the task.

Thanks so much, God Bless

# May 19, 2009 4:56 PM

vzwpix.com said:

Awesome stuff.  Just installed it and phpmyadmin had issues with a duplicate key [UNIQUE KEY `zipcode_2` (`zipcode`),] and wouldn't dump the csv.  I just recreated the table visually and it flies ... thanks for the share.

# November 11, 2009 3:07 PM

Carmen said:

Could you help me. The man who is swimming against the stream knows the strength of it. Help me! I can not find sites on the: Tooth whitening light. I found only this - <a href="www.comune.vertova.bg.it/.../ToothWhitening">zoom tooth whitening</a>. Tooth whitening, there are a clean effects to spread in tipsthere when chewing to make the tissue teeth processing. Tooth whitening, in enamel, all the whiteners interested are being drilled into two: the large tones and the unmatched teeth. THX :cool:, Carmen from Tunisia.

# March 22, 2010 4:02 PM

Emile (not the one who posted #May 2, 2009 7:58 PM) what are the odds with a name < 2% of the population? lol said:

May I ask for someone to provide access to this data as "link rot" has impeded my chance to benefit from this excellent find?

# December 4, 2010 6:46 AM

Emile (not the one who posted #May 2, 2009 7:58 PM) what are the odds with a name < 2% of the population? lol said:

to a paste bin or some such if possible please? if the end user agreement is breached by such an action please disregard my request :-)

# December 4, 2010 6:50 AM

weblogs.asp.net said:

425958.. Peachy :)

# May 9, 2011 4:04 AM

alfred said:

Anyone got the area code database? I am looking for it but the website is down right now. Thanks, if you can update this post that would be great.

# October 17, 2011 6:30 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)