Introducing our Snowflake Data Cloud Native Application: AI-Driven Data Quality built into SQL statements! Learn More

Get State/Province Standard and Two-Letter Abbreviation API

Standardize state and province names for efficient data management and more accurate analysis

API Overview

This API provides the two-letter state full standard name and two-letter abbreviation for US state and Canadian province names, including many variations, misspellings, and other inconsistencies often found in this data.

Standardization

Converts various state and province name formats, spellings, and abbreviations to a standardized form.

US & Canada Coverage

Supports both US states and Canadian provinces for comprehensive North American data standardization.

Database Integration

Easily integrate with cloud database tables for efficient data cleansing and standardization.

How It Works

State Input State Standard Abbreviation
Californa California CA
Calif. California CA
Cal California CA
wiconsin Wisconsin WI
S Dakoa South Dakota SD
Ohio Ohio OH
Ore. Oregon OR
NEW YORK New York NY
OKLA Oklahoma OK
Brit Col British Columbia BC
Qeubec Quebec QC

API Details

Endpoint

https://api.interzoid.com/getstateabbreviation

Request Format

https://api.interzoid.com/getstateabbreviation?license=[APIkey]&algorithm=ai-medium&state=[state]

Sample Request

https://api.interzoid.com/getstateabbreviation?license=dh8dj2f*****&algorithm=ai-medium&state=Ohio

Sample Response

{"State":"Ohio","Abbreviation":"OH","Code":"Success","Credits":10043}

cURL Example (with API key in header)

curl --header "x-api-key: dh8dj2f*****" "https://api.interzoid.com/getstateabbreviation?state=ohio&algorithm=ai-medium"

Algorithm & AI Model Options

narrow

Basic standardization algorithm. Very fast for very high volume requirements, but less accurate than AI options.

ai-plus

AI-enhanced standardization. Better accuracy in standardization than narrow, with good performance.

ai-medium

Best accuracy results for state name standardization. Recommended algorithm for most cases, but API response can take a little bit longer.

Recommended

Additional Resources

Database Integration

Standardize state and province name data in Cloud database tables:

Try Cloud Data Connect
Optional OpenAPI Specification

An OpenAPI Specification (OAS) is a standardized format for describing the structure, endpoints, and functionality of a RESTful API in a machine-readable format.

It is a blueprint for developers and enables integration by defining request and response schemas, authentication methods, and available operations.

YAML JSON Swagger Editor with Client Generators
Service Bureau

Want us to do it for you? We can take your data and use our products on your behalf:

Contact Support