SELECT A.CITY_NAME , A.CITY_CODE , C.STATE_ABBREV , C.STATE_CODE , Z.ZIP_START , Z.ZIP_END , B.COUNTY_NAME , B.COUNTY_CODE FROM PAY_US_CITY_NAMES A , PAY_US_COUNTIES B , PAY_US_STATES C , PAY_US_ZIP_CODES Z WHERE A.STATE_CODE = C.STATE_CODE AND A.COUNTY_CODE = B.COUNTY_CODE AND B.STATE_CODE = C.STATE_CODE AND A.CITY_CODE = Z.CITY_CODE AND A.STATE_CODE = Z.STATE_CODE AND A.COUNTY_CODE = Z.COUNTY_CODE AND A.STATE_CODE != 70