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
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