So I decided recently to work on getting a list of zip codes for the United States, in case I needed them in the future. I thought that it might be useful. I already had a list of US States, but I added a State FIPS code to correspond to the FIPS code in the Zip Code table.

I saved both files as ODF, CSV and SQL. You can download them here.

US Zip Codes (rar)
US States (rar)

The SQL files will let you import the information into your database, so you can build awesome web applications! I don’t think the zip code table is a complete list of zip codes, but it is the best I have for now. If you have anything that is more current, please let me know.

Reminder:
Only approved sites can link directly to the files. Please link to this page instead.

1. Go to Flickr.com

   

2. Do you have a previous Flickr account or yahoo email address? If so, click on the Sign In link in the upper right part of the page. You may also click here to goto the sign in page. Skip to step 4 in these directions.
3. If you do not have a Flickr account or Yahoo email address, click on the pink Sign up! button on the right.
   
   You may also click here to goto the sign up page.

a. On the “Sign in to Yahoo!” page click the “Sign Up” link in the lower right part of the page


b. Fill in all the form fields, choosing a Yahoo ID!

c. Click the I agree button after “reading” their Terms of Service. If you entered an Alternate Email, be sure to check that email account and click on the link to verify the alternate email address.

d. Click the Continue to Yahoo! Flickr Button. If you don’t want spam from Yahoo you might also click “Edit Marketing Preferences” and uncheck all the boxes.

e. If there is a security warning, click continue

f. Click the “CREATE A NEW ACCOUNT” button after choosing a Flickr screen name

g. Click the Flickr Logo or the Explore Flickr Link.

4. Now that you are logged into Flickr, you can add people as a contacts.  Under the Contacts menu there is a link for “People Search”.
   

   Another way to add people is if they send you a link to their account. For instance, if you want to add me, go here:

   http://www.flickr.com/people/llbbl/relationship/

   If I am a friend or family you can check the boxes, otherwise click the Ok button.

5. That is all there is to it. If you added me as a contact I will be notified and all you have to do is wait for me to reciprocate.