Standardize US state and province name data to a consistent full name plus abbreviation. Handles variations like 'Calif', 'CA', 'Cal', 'California'.