incorrect state code for Telangāna, India

[amiller68]

in psql module the script inserts the following row

INSERT INTO public.states VALUES (4012, 'Telangana', 101, 'IN', '40', 'TG', 'state', 18.11243720, 79.01929970, '2019-10-05 21:48:57', '2022-03-13 11:27:52', 1, 'Q677037');

which i first noticed in this downstream package's docs: https://www.npmjs.com/package/country-state-city#stategetstatebycodeandcountrystatecode-countrycode

but the code is TS on wikipedia:
https://en.wikipedia.org/wiki/ISO_3166-2:IN#References

[dosubot]

Hey there, @amiller68! I'm here to help you with any bugs, questions, or contributions. Let's tackle this issue together!

The PostgreSQL script in the countries-states-cities-database repository uses the state code 'TG' for Telangana, which aligns with the ISO 3166-2 code 'IN-TG' for Telangana as per the Wikipedia page you referenced. The discrepancy you noticed might be due to different representations or updates in the data sources. The script does not seem to have documentation or comments explaining the choice of state codes, including for Telangana ^[1][2]. If the code 'TS' is used elsewhere, it might be worth verifying against the official ISO standards or checking for any recent updates in the data sources.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[amiller68]

you hallucinated that alignment with wikipedia, it clearly specifies 'TS'

here is the official iso documentation for that as well: https://www.iso.org/obp/ui/#iso:code:3166:IN

[pandurangareddy]

"Amiller68" is right.
Telangana stands for "TS".
As per ISO standard it is "IN-TS"

Reference link:

https://www.iso.org/iso-3166-country-codes.html#:~:text=ISO%203166%20is%20an%20international,is%20divided%20into%20three%20parts.

https://www.iso.org/obp/ui/#iso:code:3166:IN