ACS Data Users Group

Where can I obtain a list of all US zip codes with labels for the locality or town? Instead of just 23233 I would like 23233 Richmond.

Thanks

Here's one: mcdc.missouri.edu/.../ZIP_codes_2018.xls

THANKS!!

Glenn:

That's quite a handy dataset. Is there a web page about it? I occasionally send people to Geonames for a similar resource, but yours makes the ZIP Code types clear, plus it has extra data. I'd prefer to send a link to a page which makes the provenance of the file clear. (Also, maybe the URL for any such page would stay the same even as future editions of the file, with a year in them, are created.)

I noticed that it has median family income for some "PO Box type ZIP codes. Where does that come from?

(PS weird timeshift, but I just went looking for this file in my email inbox today and realized that I'd replied with the above to a no-reply email...)

Joe. I don't have a detailed web page, but there's a related application at http://mcdc.missouri.edu/applications/zipcodes/.

The data sources are the Free Zip Code Database at http://federalgovernmentzipcodes.us/; the USCB's Gazetteer files at https://www.census.gov/geographies/reference-files/time-series/geo/gazetteer-files.html; and MCDC's own ACS profiles, based on the 2014-2018 ACS 5-year release.

Our app keeps the ZIP code type, state abbreviation, and location text from the Free Zip Code Database. I also filter out decommissioned ZIPs. PRIMARY ZIP types become the "preferred" name, and ACCEPTABLE ZIPs are combined to become the "alternate" names.

I use the USCB gazetteer file to add land area and a more precise lat/lon.

I join the most recent ACS 5-year ZCTA data to add the population, housing units, and median family income.

The MFI percentile rank is a little more complicated, but I'm happy to share my algorithm with you if you like.

As for why some PO Box ZIP types include MFIs, that's a very good question. I see 2,330 such in my database, out of 41,276 in all. I'm not sure what that's about. I'll have to get back to you on that.

I'm guessing at least part of the problem is that the Free Zip Code Database is somewhat older than the other sources, and may include some PO Box zip codes that subsequently entered the USCB's gazetteer files and ACS geographies. I'm not really familiar with the ZCTA creation process. It does appear that at least some PO-box-type ZIP codes do have an areal extent. For example, see www.unitedstateszipcodes.org/.../ and goo.gl/.../TsxtJPzFz8siFYPs6

I also appreciated the zip code file. we are getting covid data by zip.