Since counties can contain multiple zip codes, one can have multiple entries, in such a table: FIPScode, countyname, zipcode, Albany County, , Albany County, , Albany County, The examples above for Albany County can be found here.