ISO Code Endpoints
Lookup State by ISO Code
Find a state or province by ISO 3166-2 subdivision code
GET
Resolve an ISO 3166-2 subdivision code (e.g.
US-CA, IN-MH, DE-BY) to the state/province record.
The match prefers the canonical iso3166_2 column. When that column is NULL for a row (common in older imports), the endpoint falls back to matching the legacy iso2 column scoped to the same country — so the lookup works even for partially-coded rows without risking cross-country false matches.
Availability: Starter plan and above. Returns
403 on Community plan.Responses are cached server-side for 1 hour. The lookup key is the full ISO 3166-2 code, so
US-CA and us-ca collapse to the same cache slot (input is auto-uppercased).Authentication
Your API key for authentication
Query Parameters
ISO 3166-2 subdivision code in the form
XX-YYY — 2-letter country code, hyphen, then 1–3 alphanumeric characters for the subdivision. Case-insensitive (auto-uppercased).Examples: US-CA, IN-MH, DE-BY, GB-ENG, JP-13Response
Internal CSC state ID — same value used by
/v1/states/:id and as a foreign key from /cities.Official state/province name in English (e.g.
"California").Legacy subdivision code without the country prefix (e.g.
"CA"). May be null for some entries.Canonical ISO 3166-2 code (e.g.
"US-CA"). May be null for older entries — the endpoint still resolves them via the iso2 fallback.Internal CSC country ID — foreign key into
/countries.ISO 3166-1 alpha-2 code of the parent country (e.g.
"US").Related Endpoints
- Lookup Country by ISO Code — country-level ISO lookup (alpha-2/alpha-3/numeric)
- Get State Details — full state record (all fields, tier-gated)
- Get States by Country — all states for a given country