A comprehensive dataset integrating household energy consumption and weather conditions in a north-eastern Mexican urban city | Synapse