data engineering apis

Standardize State Names Get State Two-Letter Abbreviation API

This API provides the two-letter state abbreviation (or the province abbreviation for Canada) for state names, including many variations of a given state name.

Example of state and province abbreviation API responses.
State Abbreviation
California CA
Calif. CA
Cal CA
Ohio OH
S Dakota SD
Ore. OR
New York NY
Standardize State and Province Data in Database Tables: Use this API to easily standardize state and province name data in Cloud database tables. the browser while connected to a Cloud data platform or database platform. The State Name Standardization SQL is auto-generated to standardize data directly in database tables using this API.

Service API Endpoint:

Calling Structure:[licensekey]&state=[state]

Optional Specification Examples:
OpenAPI Specification 3.1 JSON
OpenAPI Specification 3.1 YAML

Input Parameters:
License: Your Interzoid-issued license key
State: State name, such as North Carolina, N.C., N Carolina...

Output Parameters:
Abbreviation: The two-letter abbreviation for the US state (or the Canadian province)

Sample URL Query:*****&state=Ohio
Sample JSON Output:
You can also set a header value for your API License Key (*recommended for production environments):
Curl Example:
curl --header "x-api-key: dh8dj2f*****" ""

Sample Code Showing Usage:

Try the API interactively:
(API License Key will auto-populate if you have an account and are logged in. Otherwise, register for a free account.)

Login or register to obtain

Result Code:



Credits Remaining:

Do you have custom requirements or are interested in on-premise solutions? Contact us at

All content (c) 2018-2023 Interzoid Incorporated. Questions? Contact

201 Spear Street, Suite 1100, San Francisco, CA 94105-6164

Interested in Data Cleansing Services?
Let us put our Generative AI-enhanced data tools and processes to work for you.

Start Here
Terms of Service
Privacy Policy

Use the Interzoid Cloud Connect Data Platform and Start to Supercharge your Cloud Data now.
Connect to your data and start running data analysis reports in minutes:
API Integration Code Examples and SDKs:
Documentation and Overview: Docs site
Interzoid Product and Technology Newsletter: Subscribe
Partnership Interest? Inquire