Database Mapping World Cities to Metropolitan Statistical Areas (and non-US MSA equivalents) Ask Question. There is a good answer here that provides a csv with zip codes for every city in the US. Site The Google Geocoding developer's site has a useful CSV that has some US cities mapped to a Google Metro Region code. The problem is that. Download Open Datasets on 1000s of Projects + Share Projects on One Platform. Explore Popular Topics Like Government, Sports, Medicine, Fintech, Food, More. Flexible Data Ingestion.
Bearing in mind that zip codes and zip code tabulation areas (ZCTAs) are not the same thing, you have a few different options. You may need to use some basic GIS operations to join the datasets you need. For ZCTAs: For MSA/CSA: Load into GIS of your choosing (use QGIS if you need a free open source one), do a spatial join between the layers, and the resulting attribute table will have your combined data.
You can also use this ESRI data that purports to be actual zip code delivery areas sourced from TomTom / USPS: I think you will need ArcGIS to view that data but I am not sure.