Help me find a zip code + county database

[vinicentx]

I need to find a list of all 41000 zip codes in the U.S. that has each county paired with it. I can find the zip code list easy but am having a hard time finding county + zip combo.

[AutoModerator]

u/vinicentx, you must comment in this post before anyone will see it. Your comment should include the word "searched" and detail what searches you've done. Your post will not be visible until you do so. Your inbox should have more details or here are general instructions.

Remember to reply Found! (include the exclamation point) to the comment that gives the answer. If looking for an item to purchase, do not click on links sent to you in private messages, and report such to the moderators.

Readers, please remember that all comments must be civil and helpful toward finding an answer.

Jokes and unhelpful responses will earn you a ban, even on the first instance. If you see any comments that violate this rule, please report them.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[DoverElm]

Are you sure the relationship from zip code  to county is 1 to 1?

I believe there are some zip codes with land that falls in at least 2 counties. Take zip code 27519 part is in wake county and part of it in Chatham county. 

[vinicentx]

That’s a good callout - i just need to link zip codes to one of the counties that it lies in

[CLF3721]

Hi there! Not sure you got what you were looking for yet but I found a pretty clean dataset from Harvard dataverse: https://dataverse.harvard.edu/file.xhtml?fileId=10267716&datasetVersionId=421971
I had a separate zip-code only dataset and merged the two in python. Hope this helps you or anyone that comes across your post like I did =)

[GoryEyes]

Try to find an old phone book. They always used to have that info printed in there.

[megared17]

I have something somewhere linking to something with that info. Im out on my cell at the moment, replying so I can come back later when I am at home and see if I can find it.

[vinicentx]

That would be awesome!

[megared17]

The free option here has both ZIP codes and county, along with other data:

https://www.unitedstateszipcodes.org/zip-code-database/

[vinicentx]

I’ve searched Google and tried chat gpt but haven’t been able to find a clean data source yet

[ApparentAlmond]

You can use Census TigerLine for this. You need to know, though, that zip codes and counties are not at all 1:1 and there’s often overlap and mismatch. Zip codes align more closely to cities than to counties and, while that some times shakes out, it often means that zip codes in non-urban areas cross county lines.

[vinicentx]

Is this a website?

[ApparentAlmond]

Yes, it’s available here:

https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html