List of states/territories: HTML - Select Control
----------------------------
Alpha-2 code + Alpha-2 code
----------------------------
<select>
<option value="AN">AN</option>
<option value="AP">AP</option>
<option value="AR">AR</option>
<option value="AS">AS</option>
<option value="BR">BR</option>
<option value="CH">CH</option>
<option value="CT">CT</option>
<option value="DD">DD</option>
<option value="DL">DL</option>
<option value="DN">DN</option>
<option value="GA">GA</option>
<option value="GJ">GJ</option>
<option value="HR">HR</option>
<option value="HP">HP</option>
<option value="JH">JH</option>
<option value="JK">JK</option>
<option value="KA">KA</option>
<option value="KL">KL</option>
<option value="LD">LD</option>
<option value="MH">MH</option>
<option value="MP">MP</option>
<option value="MN">MN</option>
<option value="ML">ML</option>
<option value="MZ">MZ</option>
<option value="NL">NL</option>
<option value="OR">OR</option>
<option value="PB">PB</option>
<option value="PY">PY</option>
<option value="RJ">RJ</option>
<option value="SK">SK</option>
<option value="TN">TN</option>
<option value="TG">TG</option>
<option value="TR">TR</option>
<option value="UP">UP</option>
<option value="UT">UT</option>
<option value="WB">WB</option>
</select>
-------------------------------
Alpha-2 code + name - English
-------------------------------
<select>
<option value="AN">Andaman and Nicobar Islands</option>
<option value="AP">Andhra Pradesh</option>
<option value="AR">Arunachal Pradesh</option>
<option value="AS">Assam</option>
<option value="BR">Bihar</option>
<option value="CH">Chandigarh</option>
<option value="CT">Chhattisgarh</option>
<option value="DD">Daman and Diu</option>
<option value="DL">Delhi</option>
<option value="DN">Dadra and Nagar Haveli</option>
<option value="GA">Goa</option>
<option value="GJ">Gujarat</option>
<option value="HR">Haryana</option>
<option value="HP">Himachal Pradesh</option>
<option value="JK">Jammu and Kashmir</option>
<option value="JH">Jharkhand</option>
<option value="KA">Karnataka</option>
<option value="KL">Kerala</option>
<option value="LD">Lakshadweep</option>
<option value="MP">Madhya Pradesh</option>
<option value="MH">Maharashtra</option>
<option value="MN">Manipur</option>
<option value="ML">Meghalaya</option>
<option value="MZ">Mizoram</option>
<option value="NL">Nagaland</option>
<option value="OR">Odisha</option>
<option value="PB">Punjab</option>
<option value="PY">Puducherry</option>
<option value="RJ">Rajasthan</option>
<option value="SK">Sikkim</option>
<option value="TN">Tamil Nadu</option>
<option value="TG">Telangana</option>
<option value="TR">Tripura</option>
<option value="UT">Uttarakhand</option>
<option value="UP">Uttar Pradesh</option>
<option value="WB">West Bengal</option>
</select>
-------------------------------
Alpha-2 code + name - हिन्दी
-------------------------------
<select>
<option value="AN">अण्डमान और निकोबार द्वीपसमूह</option>
<option value="AP">आन्ध्र प्रदेश</option>
<option value="AR">अरुणाचल प्रदेश</option>
<option value="AS">असम</option>
<option value="BR">बिहार</option>
<option value="CH">चण्डीगढ़</option>
<option value="CT">छत्तीसगढ़</option>
<option value="DD">दमन और दीव</option>
<option value="DL">राष्ट्रीय राजधानी क्षेत्र दिल्ली</option>
<option value="DN">दादरा और नगर हवेली</option>
<option value="GA">गोवा</option>
<option value="GJ">गुजरात</option>
<option value="HR">हरयाणा</option>
<option value="HP">हिमाचल प्रदेश</option>
<option value="JK">जम्मू और कश्मीर</option>
<option value="JH">झारखण्ड</option>
<option value="KA">कर्नाटक</option>
<option value="KL">केरल</option>
<option value="LD">लक्षद्वीप</option>
<option value="MP">मध्य प्रदेश</option>
<option value="MH">महाराष्ट्र</option>
<option value="MN">मणिपुर</option>
<option value="ML">मेघालय</option>
<option value="MZ">मिज़ोरम</option>
<option value="NL">नागालैंड</option>
<option value="OR">उड़ीसा</option>
<option value="PB">पंजाब</option>
<option value="PY">पुदुच्चेरी</option>
<option value="RJ">राजस्थान</option>
<option value="SK">सिक्किम</option>
<option value="TN">तमिल नाडू</option>
<option value="TG">तेलंगाना</option>
<option value="TR">त्रिपुरा</option>
<option value="UT">उत्तराखण्ड</option>
<option value="UP">उत्तर प्रदेश</option>
<option value="WB">पश्चिम बंगा</option>
</select>
----------------------------------
ISO_3166-2 code + name - English
----------------------------------
<select>
<option value="IN-AN">Andaman and Nicobar Islands</option>
<option value="IN-AP">Andhra Pradesh</option>
<option value="IN-AR">Arunachal Pradesh</option>
<option value="IN-AS">Assam</option>
<option value="IN-BR">Bihar</option>
<option value="IN-CH">Chandigarh</option>
<option value="IN-CT">Chhattisgarh</option>
<option value="IN-DD">Daman and Diu</option>
<option value="IN-DL">Delhi</option>
<option value="IN-DN">Dadra and Nagar Haveli</option>
<option value="IN-GA">Goa</option>
<option value="IN-GJ">Gujarat</option>
<option value="IN-HR">Haryana</option>
<option value="IN-HP">Himachal Pradesh</option>
<option value="IN-JK">Jammu and Kashmir</option>
<option value="IN-JH">Jharkhand</option>
<option value="IN-KA">Karnataka</option>
<option value="IN-KL">Kerala</option>
<option value="IN-LD">Lakshadweep</option>
<option value="IN-MP">Madhya Pradesh</option>
<option value="IN-MH">Maharashtra</option>
<option value="IN-MN">Manipur</option>
<option value="IN-ML">Meghalaya</option>
<option value="IN-MZ">Mizoram</option>
<option value="IN-NL">Nagaland</option>
<option value="IN-OR">Odisha</option>
<option value="IN-PB">Punjab</option>
<option value="IN-PY">Puducherry</option>
<option value="IN-RJ">Rajasthan</option>
<option value="IN-SK">Sikkim</option>
<option value="IN-TN">Tamil Nadu</option>
<option value="IN-TG">Telangana</option>
<option value="IN-TR">Tripura</option>
<option value="IN-UT">Uttarakhand</option>
<option value="IN-UP">Uttar Pradesh</option>
<option value="IN-WB">West Bengal</option>
</select>
----------------------------------
ISO_3166-2 code + name - हिन्दी
----------------------------------
<select>
<option value="IN-AN">अण्डमान और निकोबार द्वीपसमूह</option>
<option value="IN-AP">आन्ध्र प्रदेश</option>
<option value="IN-AR">अरुणाचल प्रदेश</option>
<option value="IN-AS">असम</option>
<option value="IN-BR">बिहार</option>
<option value="IN-CH">चण्डीगढ़</option>
<option value="IN-CT">छत्तीसगढ़</option>
<option value="IN-DD">दमन और दीव</option>
<option value="IN-DL">राष्ट्रीय राजधानी क्षेत्र दिल्ली</option>
<option value="IN-DN">दादरा और नगर हवेली</option>
<option value="IN-GA">गोवा</option>
<option value="IN-GJ">गुजरात</option>
<option value="IN-HR">हरयाणा</option>
<option value="IN-HP">हिमाचल प्रदेश</option>
<option value="IN-JK">जम्मू और कश्मीर</option>
<option value="IN-JH">झारखण्ड</option>
<option value="IN-KA">कर्नाटक</option>
<option value="IN-KL">केरल</option>
<option value="IN-LD">लक्षद्वीप</option>
<option value="IN-MP">मध्य प्रदेश</option>
<option value="IN-MH">महाराष्ट्र</option>
<option value="IN-MN">मणिपुर</option>
<option value="IN-ML">मेघालय</option>
<option value="IN-MZ">मिज़ोरम</option>
<option value="IN-NL">नागालैंड</option>
<option value="IN-OR">उड़ीसा</option>
<option value="IN-PB">पंजाब</option>
<option value="IN-PY">पुदुच्चेरी</option>
<option value="IN-RJ">राजस्थान</option>
<option value="IN-SK">सिक्किम</option>
<option value="IN-TN">तमिल नाडू</option>
<option value="IN-TG">तेलंगाना</option>
<option value="IN-TR">त्रिपुरा</option>
<option value="IN-UT">उत्तराखण्ड</option>
<option value="IN-UP">उत्तर प्रदेश</option>
<option value="IN-WB">पश्चिम बंगा</option>
</select>
List of states/territories: CSV
// Alpha-2 code - English
AN,"Andaman and Nicobar Islands"
AP,"Andhra Pradesh"
AR,"Arunachal Pradesh"
AS,"Assam"
BR,"Bihar"
CH,"Chandigarh"
CT,"Chhattisgarh"
DD,"Daman and Diu"
DL,"Delhi"
DN,"Dadra and Nagar Haveli"
GA,"Goa"
GJ,"Gujarat"
HR,"Haryana"
HP,"Himachal Pradesh"
JK,"Jammu and Kashmir"
JH,"Jharkhand"
KA,"Karnataka"
KL,"Kerala"
LD,"Lakshadweep"
MP,"Madhya Pradesh"
MH,"Maharashtra"
MN,"Manipur"
ML,"Meghalaya"
MZ,"Mizoram"
NL,"Nagaland"
OR,"Odisha"
PB,"Punjab"
PY,"Puducherry"
RJ,"Rajasthan"
SK,"Sikkim"
TN,"Tamil Nadu"
TG,"Telangana"
TR,"Tripura"
UT,"Uttarakhand"
UP,"Uttar Pradesh"
WB,"West Bengal"
// ISO-3166-2 + Name - English
IN-AN,"Andaman and Nicobar Islands"
IN-AP,"Andhra Pradesh"
IN-AR,"Arunachal Pradesh"
IN-AS,"Assam"
IN-BR,"Bihar"
IN-CH,"Chandigarh"
IN-CT,"Chhattisgarh"
IN-DD,"Daman and Diu"
IN-DL,"Delhi"
IN-DN,"Dadra and Nagar Haveli"
IN-GA,"Goa"
IN-GJ,"Gujarat"
IN-HR,"Haryana"
IN-HP,"Himachal Pradesh"
IN-JK,"Jammu and Kashmir"
IN-JH,"Jharkhand"
IN-KA,"Karnataka"
IN-KL,"Kerala"
IN-LD,"Lakshadweep"
IN-MP,"Madhya Pradesh"
IN-MH,"Maharashtra"
IN-MN,"Manipur"
IN-ML,"Meghalaya"
IN-MZ,"Mizoram"
IN-NL,"Nagaland"
IN-OR,"Odisha"
IN-PB,"Punjab"
IN-PY,"Puducherry"
IN-RJ,"Rajasthan"
IN-SK,"Sikkim"
IN-TN,"Tamil Nadu"
IN-TG,"Telangana"
IN-TR,"Tripura"
IN-UT,"Uttarakhand"
IN-UP,"Uttar Pradesh"
IN-WB,"West Bengal"
// Alpha-2 code + Name - Hindi
AN,"अण्डमान और निकोबार द्वीपसमूह"
AP,"आन्ध्र प्रदेश"
AR,"अरुणाचल प्रदेश"
AS,"असम"
BR,"बिहार"
CH,"चण्डीगढ़"
CT,"छत्तीसगढ़"
DD,"दमन और दीव"
DL,"राष्ट्रीय राजधानी क्षेत्र दिल्ली"
DN,"दादरा और नगर हवेली"
GA,"गोवा"
GJ,"गुजरात"
HR,"हरयाणा"
HP,"हिमाचल प्रदेश"
JK,"जम्मू और कश्मीर"
JH,"झारखण्ड"
KA,"कर्नाटक"
KL,"केरल"
LD,"लक्षद्वीप"
MP,"मध्य प्रदेश"
MH,"महाराष्ट्र"
MN,"मणिपुर"
ML,"मेघालय"
MZ,"मिज़ोरम"
NL,"नागालैंड"
OR,"उड़ीसा"
PB,"पंजाब"
PY,"पुदुच्चेरी"
RJ,"राजस्थान"
SK,"सिक्किम"
TN,"तमिल नाडू"
TG,"तेलंगाना"
TR,"त्रिपुरा"
UT,"उत्तराखण्ड"
UP,"उत्तर प्रदेश"
WB,"पश्चिम बंगा"
// ISO-3166-2 + Name - Hindi
IN-AN,"अण्डमान और निकोबार द्वीपसमूह"
IN-AP,"आन्ध्र प्रदेश"
IN-AR,"अरुणाचल प्रदेश"
IN-AS,"असम"
IN-BR,"बिहार"
IN-CH,"चण्डीगढ़"
IN-CT,"छत्तीसगढ़"
IN-DD,"दमन और दीव"
IN-DL,"राष्ट्रीय राजधानी क्षेत्र दिल्ली"
IN-DN,"दादरा और नगर हवेली"
IN-GA,"गोवा"
IN-GJ,"गुजरात"
IN-HR,"हरयाणा"
IN-HP,"हिमाचल प्रदेश"
IN-JK,"जम्मू और कश्मीर"
IN-JH,"झारखण्ड"
IN-KA,"कर्नाटक"
IN-KL,"केरल"
IN-LD,"लक्षद्वीप"
IN-MP,"मध्य प्रदेश"
IN-MH,"महाराष्ट्र"
IN-MN,"मणिपुर"
IN-ML,"मेघालय"
IN-MZ,"मिज़ोरम"
IN-NL,"नागालैंड"
IN-OR,"उड़ीसा"
IN-PB,"पंजाब"
IN-PY,"पुदुच्चेरी"
IN-RJ,"राजस्थान"
IN-SK,"सिक्किम"
IN-TN,"तमिल नाडू"
IN-TG,"तेलंगाना"
IN-TR,"त्रिपुरा"
IN-UT,"उत्तराखण्ड"
IN-UP,"उत्तर प्रदेश"
IN-WB,"पश्चिम बंगा"
List of states/territories: JSON
-------------------------------
Alpha-2 code + Name - English
-------------------------------
[
{code: "AN", name: "Andaman and Nicobar Islands"},
{code: "AP", name: "Andhra Pradesh"},
{code: "AR", name: "Arunachal Pradesh"},
{code: "AS", name: "Assam"},
{code: "BR", name: "Bihar"},
{code: "CH", name: "Chandigarh"},
{code: "CT", name: "Chhattisgarh"},
{code: "DD", name: "Daman and Diu"},
{code: "DL", name: "Delhi"},
{code: "DN", name: "Dadra and Nagar Haveli"},
{code: "GA", name: "Goa"},
{code: "GJ", name: "Gujarat"},
{code: "HR", name: "Haryana"},
{code: "HP", name: "Himachal Pradesh"},
{code: "JK", name: "Jammu and Kashmir"},
{code: "JH", name: "Jharkhand"},
{code: "KA", name: "Karnataka"},
{code: "KL", name: "Kerala"},
{code: "LD", name: "Lakshadweep"},
{code: "MP", name: "Madhya Pradesh"},
{code: "MH", name: "Maharashtra"},
{code: "MN", name: "Manipur"},
{code: "ML", name: "Meghalaya"},
{code: "MZ", name: "Mizoram"},
{code: "NL", name: "Nagaland"},
{code: "OR", name: "Odisha"},
{code: "PB", name: "Punjab"},
{code: "PY", name: "Puducherry"},
{code: "RJ", name: "Rajasthan"},
{code: "SK", name: "Sikkim"},
{code: "TN", name: "Tamil Nadu"},
{code: "TG", name: "Telangana"},
{code: "TR", name: "Tripura"},
{code: "UT", name: "Uttarakhand"},
{code: "UP", name: "Uttar Pradesh"},
{code: "WB", name: "West Bengal"}
]
---------------------------
Alpha-2 code + Name - हिन्दी
---------------------------
[
{code: "AN", name: "अण्डमान और निकोबार द्वीपसमूह"},
{code: "AP", name: "आन्ध्र प्रदेश"},
{code: "AR", name: "अरुणाचल प्रदेश"},
{code: "AS", name: "असम"},
{code: "BR", name: "बिहार"},
{code: "CH", name: "चण्डीगढ़"},
{code: "CT", name: "छत्तीसगढ़"},
{code: "DD", name: "दमन और दीव"},
{code: "DL", name: "राष्ट्रीय राजधानी क्षेत्र दिल्ली"},
{code: "DN", name: "दादरा और नगर हवेली"},
{code: "GA", name: "गोवा"},
{code: "GJ", name: "गुजरात"},
{code: "HR", name: "हरयाणा"},
{code: "HP", name: "हिमाचल प्रदेश"},
{code: "JK", name: "जम्मू और कश्मीर"},
{code: "JH", name: "झारखण्ड"},
{code: "KA", name: "कर्नाटक"},
{code: "KL", name: "केरल"},
{code: "LD", name: "लक्षद्वीप"},
{code: "MP", name: "मध्य प्रदेश"},
{code: "MH", name: "महाराष्ट्र"},
{code: "MN", name: "मणिपुर"},
{code: "ML", name: "मेघालय"},
{code: "MZ", name: "मिज़ोरम"},
{code: "NL", name: "नागालैंड"},
{code: "OR", name: "उड़ीसा"},
{code: "PB", name: "पंजाब"},
{code: "PY", name: "पुदुच्चेरी"},
{code: "RJ", name: "राजस्थान"},
{code: "SK", name: "सिक्किम"},
{code: "TN", name: "तमिल नाडू"},
{code: "TG", name: "तेलंगाना"},
{code: "TR", name: "त्रिपुरा"},
{code: "UT", name: "उत्तराखण्ड"},
{code: "UP", name: "उत्तर प्रदेश"},
{code: "WB", name: "पश्चिम बंगा"}
]
----------------------------------
ISO-3166-2 code + Name - English
----------------------------------
[
{code: "IN-AN", name: "Andaman and Nicobar Islands"},
{code: "IN-AP", name: "Andhra Pradesh"},
{code: "IN-AR", name: "Arunachal Pradesh"},
{code: "IN-AS", name: "Assam"},
{code: "IN-BR", name: "Bihar"},
{code: "IN-CH", name: "Chandigarh"},
{code: "IN-CT", name: "Chhattisgarh"},
{code: "IN-DD", name: "Daman and Diu"},
{code: "IN-DL", name: "Delhi"},
{code: "IN-DN", name: "Dadra and Nagar Haveli"},
{code: "IN-GA", name: "Goa"},
{code: "IN-GJ", name: "Gujarat"},
{code: "IN-HR", name: "Haryana"},
{code: "IN-HP", name: "Himachal Pradesh"},
{code: "IN-JK", name: "Jammu and Kashmir"},
{code: "IN-JH", name: "Jharkhand"},
{code: "IN-KA", name: "Karnataka"},
{code: "IN-KL", name: "Kerala"},
{code: "IN-LD", name: "Lakshadweep"},
{code: "IN-MP", name: "Madhya Pradesh"},
{code: "IN-MH", name: "Maharashtra"},
{code: "IN-MN", name: "Manipur"},
{code: "IN-ML", name: "Meghalaya"},
{code: "IN-MZ", name: "Mizoram"},
{code: "IN-NL", name: "Nagaland"},
{code: "IN-OR", name: "Odisha"},
{code: "IN-PB", name: "Punjab"},
{code: "IN-PY", name: "Puducherry"},
{code: "IN-RJ", name: "Rajasthan"},
{code: "IN-SK", name: "Sikkim"},
{code: "IN-TN", name: "Tamil Nadu"},
{code: "IN-TG", name: "Telangana"},
{code: "IN-TR", name: "Tripura"},
{code: "IN-UT", name: "Uttarakhand"},
{code: "IN-UP", name: "Uttar Pradesh"},
{code: "IN-WB", name: "West Bengal"}
]
------------------------------
ISO-3166-2 code + Name - हिन्दी
------------------------------
[
{code: "IN-AN", name: "अण्डमान और निकोबार द्वीपसमूह"},
{code: "IN-AP", name: "आन्ध्र प्रदेश"},
{code: "IN-AR", name: "अरुणाचल प्रदेश"},
{code: "IN-AS", name: "असम"},
{code: "IN-BR", name: "बिहार"},
{code: "IN-CH", name: "चण्डीगढ़"},
{code: "IN-CT", name: "छत्तीसगढ़"},
{code: "IN-DD", name: "दमन और दीव"},
{code: "IN-DL", name: "राष्ट्रीय राजधानी क्षेत्र दिल्ली"},
{code: "IN-DN", name: "दादरा और नगर हवेली"},
{code: "IN-GA", name: "गोवा"},
{code: "IN-GJ", name: "गुजरात"},
{code: "IN-HR", name: "हरयाणा"},
{code: "IN-HP", name: "हिमाचल प्रदेश"},
{code: "IN-JK", name: "जम्मू और कश्मीर"},
{code: "IN-JH", name: "झारखण्ड"},
{code: "IN-KA", name: "कर्नाटक"},
{code: "IN-KL", name: "केरल"},
{code: "IN-LD", name: "लक्षद्वीप"},
{code: "IN-MP", name: "मध्य प्रदेश"},
{code: "IN-MH", name: "महाराष्ट्र"},
{code: "IN-MN", name: "मणिपुर"},
{code: "IN-ML", name: "मेघालय"},
{code: "IN-MZ", name: "मिज़ोरम"},
{code: "IN-NL", name: "नागालैंड"},
{code: "IN-OR", name: "उड़ीसा"},
{code: "IN-PB", name: "पंजाब"},
{code: "IN-PY", name: "पुदुच्चेरी"},
{code: "IN-RJ", name: "राजस्थान"},
{code: "IN-SK", name: "सिक्किम"},
{code: "IN-TN", name: "तमिल नाडू"},
{code: "IN-TG", name: "तेलंगाना"},
{code: "IN-TR", name: "त्रिपुरा"},
{code: "IN-UT", name: "उत्तराखण्ड"},
{code: "IN-UP", name: "उत्तर प्रदेश"},
{code: "IN-WB", name: "पश्चिम बंगा"}
]
List of states/territories: SQL
-- -----------------------------------------------------
-- Table `state`
-- -----------------------------------------------------
DROP TABLE IF EXISTS state;
CREATE TABLE IF NOT EXISTS state (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
code VARCHAR(6) NOT NULL,
name_en VARCHAR(50) NOT NULL,
name_hi VARCHAR(50) NOT NULL,
PRIMARY KEY (id),
UNIQUE INDEX id_UNIQUE (id ASC),
UNIQUE INDEX code_UNIQUE (code ASC)
) ENGINE = InnoDB;
---------------------
Alpha-2 code + name
---------------------
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'AN', 'Andaman and Nicobar Islands', 'अण्डमान और निकोबार द्वीपसमूह');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'AP', 'Andhra Pradesh', 'आन्ध्र प्रदेश');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'AR', 'Arunachal Pradesh', 'अरुणाचल प्रदेश');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'AS', 'Assam', 'असम');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'BR', 'Bihar', 'बिहार');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'CH', 'Chandigarh', 'चण्डीगढ़');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'CT', 'Chhattisgarh', 'छत्तीसगढ़');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'DD', 'Daman and Diu', 'दमन और दीव');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'DL', 'Delhi', 'राष्ट्रीय राजधानी क्षेत्र दिल्ली');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'DN', 'Dadra and Nagar Haveli', 'दादरा और नगर हवेली');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'GA', 'Goa', 'गोवा');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'GJ', 'Gujarat', 'गुजरात');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'HR', 'Haryana', 'हरयाणा');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'HP', 'Himachal Pradesh', 'हिमाचल प्रदेश');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'JK', 'Jammu and Kashmir', 'जम्मू और कश्मीर');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'JH', 'Jharkhand', 'झारखण्ड');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'KA', 'Karnataka', 'कर्नाटक');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'KL', 'Kerala', 'केरल');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'LD', 'Lakshadweep', 'लक्षद्वीप');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'MP', 'Madhya Pradesh', 'मध्य प्रदेश');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'MH', 'Maharashtra', 'महाराष्ट्र');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'MN', 'Manipur', 'मणिपुर');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'ML', 'Meghalaya', 'मेघालय');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'MZ', 'Mizoram', 'मिज़ोरम');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'NL', 'Nagaland', 'नागालैंड');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'OR', 'Odisha', 'नागालैंड');
------------------------
ISO-3166-2 code + name
------------------------
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-AN', 'Andaman and Nicobar Islands', 'अण्डमान और निकोबार द्वीपसमूह');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-AP', 'Andhra Pradesh', 'आन्ध्र प्रदेश');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-AR', 'Arunachal Pradesh', 'अरुणाचल प्रदेश');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-AS', 'Assam', 'असम');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-BR', 'Bihar', 'बिहार');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-CH', 'Chandigarh', 'चण्डीगढ़');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-CT', 'Chhattisgarh', 'छत्तीसगढ़');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-DD', 'Daman and Diu', 'दमन और दीव');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-DL', 'Delhi', 'राष्ट्रीय राजधानी क्षेत्र दिल्ली');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-DN', 'Dadra and Nagar Haveli', 'दादरा और नगर हवेली');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-GA', 'Goa', 'गोवा');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-GJ', 'Gujarat', 'गुजरात');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-HR', 'Haryana', 'हरयाणा');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-HP', 'Himachal Pradesh', 'हिमाचल प्रदेश');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-JK', 'Jammu and Kashmir', 'जम्मू और कश्मीर');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-JH', 'Jharkhand', 'झारखण्ड');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-KA', 'Karnataka', 'कर्नाटक');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-KL', 'Kerala', 'केरल');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-LD', 'Lakshadweep', 'लक्षद्वीप');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-MP', 'Madhya Pradesh', 'मध्य प्रदेश');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-MH', 'Maharashtra', 'महाराष्ट्र');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-MN', 'Manipur', 'मणिपुर');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-ML', 'Meghalaya', 'मेघालय');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-MZ', 'Mizoram', 'मिज़ोरम');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-NL', 'Nagaland', 'नागालैंड');
INSERT INTO province (id, code, name_en, name_hi) VALUES (null, 'IN-OR', 'Odisha', 'नागालैंड');
List of states/territories: XML
<!-- Alpha-2 code + name - English -->
<?xml version="1.0" encoding="UTF-8"?>
<states>
<state>
<code>AN</code>
<name>Andaman and Nicobar Islands</name>
</state>
<state>
<code>AP</code>
<name>Andhra Pradesh</name>
</state>
<state>
<code>AR</code>
<name>Arunachal Pradesh</name>
</state>
<state>
<code>AS</code>
<name>Assam</name>
</state>
<state>
<code>BR</code>
<name>Bihar</name>
</state>
<state>
<code>CH</code>
<name>Chandigarh</name>
</state>
<state>
<code>CT</code>
<name>Chhattisgarh</name>
</state>
<state>
<code>DD</code>
<name>Daman and Diu</name>
</state>
<state>
<code>DL</code>
<name>Delhi</name>
</state>
<state>
<code>DN</code>
<name>Dadra and Nagar Haveli</name>
</state>
<state>
<code>GA</code>
<name>Goa</name>
</state>
<state>
<code>GJ</code>
<name>Gujarat</name>
</state>
<state>
<code>HR</code>
<name>Haryana</name>
</state>
<state>
<code>HP</code>
<name>Himachal Pradesh</name>
</state>
<state>
<code>JK</code>
<name>Jammu and Kashmir</name>
</state>
<state>
<code>JH</code>
<name>Jharkhand</name>
</state>
<state>
<code>KA</code>
<name>Karnataka</name>
</state>
<state>
<code>KL</code>
<name>Kerala</name>
</state>
<state>
<code>LD</code>
<name>Lakshadweep</name>
</state>
<state>
<code>MP</code>
<name>Madhya Pradesh</name>
</state>
<state>
<code>MH</code>
<name>Maharashtra</name>
</state>
<state>
<code>MN</code>
<name>Manipur</name>
</state>
<state>
<code>ML</code>
<name>Meghalaya</name>
</state>
<state>
<code>MZ</code>
<name>Mizoram</name>
</state>
<state>
<code>NL</code>
<name>Nagaland</name>
</state>
<state>
<code>OR</code>
<name>Odisha</name>
</state>
<state>
<code>PB</code>
<name>Punjab</name>
</state>
<state>
<code>PY</code>
<name>Puducherry</name>
</state>
<state>
<code>RJ</code>
<name>Rajasthan</name>
</state>
<state>
<code>SK</code>
<name>Sikkim</name>
</state>
<state>
<code>TN</code>
<name>Tamil Nadu</name>
</state>
<state>
<code>TG</code>
<name>Telangana</name>
</state>
<state>
<code>TR</code>
<name>Tripura</name>
</state>
<state>
<code>UT</code>
<name>Uttarakhand</name>
</state>
<state>
<code>UP</code>
<name>Uttar Pradesh</name>
</state>
<state>
<code>WB</code>
<name>West Bengal</name>
</state>
</states>
<!-- ISO-3166-2 code + name - English -->
<?xml version="1.0" encoding="UTF-8"?>
<states>
<state>
<code>IN-AN</code>
<name>Andaman and Nicobar Islands</name>
</state>
<state>
<code>IN-AP</code>
<name>Andhra Pradesh</name>
</state>
<state>
<code>IN-AR</code>
<name>Arunachal Pradesh</name>
</state>
<state>
<code>IN-AS</code>
<name>Assam</name>
</state>
<state>
<code>IN-BR</code>
<name>Bihar</name>
</state>
<state>
<code>IN-CH</code>
<name>Chandigarh</name>
</state>
<state>
<code>IN-CT</code>
<name>Chhattisgarh</name>
</state>
<state>
<code>IN-DD</code>
<name>Daman and Diu</name>
</state>
<state>
<code>IN-DL</code>
<name>Delhi</name>
</state>
<state>
<code>IN-DN</code>
<name>Dadra and Nagar Haveli</name>
</state>
<state>
<code>IN-GA</code>
<name>Goa</name>
</state>
<state>
<code>IN-GJ</code>
<name>Gujarat</name>
</state>
<state>
<code>IN-HR</code>
<name>Haryana</name>
</state>
<state>
<code>IN-HP</code>
<name>Himachal Pradesh</name>
</state>
<state>
<code>IN-JK</code>
<name>Jammu and Kashmir</name>
</state>
<state>
<code>IN-JH</code>
<name>Jharkhand</name>
</state>
<state>
<code>IN-KA</code>
<name>Karnataka</name>
</state>
<state>
<code>IN-KL</code>
<name>Kerala</name>
</state>
<state>
<code>IN-LD</code>
<name>Lakshadweep</name>
</state>
<state>
<code>IN-MP</code>
<name>Madhya Pradesh</name>
</state>
<state>
<code>IN-MH</code>
<name>Maharashtra</name>
</state>
<state>
<code>IN-MN</code>
<name>Manipur</name>
</state>
<state>
<code>IN-ML</code>
<name>Meghalaya</name>
</state>
<state>
<code>IN-MZ</code>
<name>Mizoram</name>
</state>
<state>
<code>IN-NL</code>
<name>Nagaland</name>
</state>
<state>
<code>IN-OR</code>
<name>Odisha</name>
</state>
<state>
<code>IN-PB</code>
<name>Punjab</name>
</state>
<state>
<code>IN-PY</code>
<name>Puducherry</name>
</state>
<state>
<code>IN-RJ</code>
<name>Rajasthan</name>
</state>
<state>
<code>IN-SK</code>
<name>Sikkim</name>
</state>
<state>
<code>IN-TN</code>
<name>Tamil Nadu</name>
</state>
<state>
<code>IN-TG</code>
<name>Telangana</name>
</state>
<state>
<code>IN-TR</code>
<name>Tripura</name>
</state>
<state>
<code>IN-UT</code>
<name>Uttarakhand</name>
</state>
<state>
<code>IN-UP</code>
<name>Uttar Pradesh</name>
</state>
<state>
<code>IN-WB</code>
<name>West Bengal</name>
</state>
</states>
<!-- Alpha-2 code + name - Hindi -->
<?xml version="1.0" encoding="UTF-8"?>
<states>
<state>
<code>AN</code>
<name>अण्डमान और निकोबार द्वीपसमूह</name>
</state>
<state>
<code>AP</code>
<name>आन्ध्र प्रदेश</name>
</state>
<state>
<code>AR</code>
<name>अरुणाचल प्रदेश</name>
</state>
<state>
<code>AS</code>
<name>असम</name>
</state>
<state>
<code>BR</code>
<name>बिहार</name>
</state>
<state>
<code>CH</code>
<name>चण्डीगढ़</name>
</state>
<state>
<code>CT</code>
<name>छत्तीसगढ़</name>
</state>
<state>
<code>DD</code>
<name>दमन और दीव</name>
</state>
<state>
<code>DL</code>
<name>राष्ट्रीय राजधानी क्षेत्र दिल्ली</name>
</state>
<state>
<code>DN</code>
<name>दादरा और नगर हवेली</name>
</state>
<state>
<code>GA</code>
<name>गोवा</name>
</state>
<state>
<code>GJ</code>
<name>गुजरात</name>
</state>
<state>
<code>HR</code>
<name>हरयाणा</name>
</state>
<state>
<code>HP</code>
<name>हिमाचल प्रदेश</name>
</state>
<state>
<code>JK</code>
<name>जम्मू और कश्मीर</name>
</state>
<state>
<code>JH</code>
<name>झारखण्ड</name>
</state>
<state>
<code>KA</code>
<name>कर्नाटक</name>
</state>
<state>
<code>KL</code>
<name>केरल</name>
</state>
<state>
<code>LD</code>
<name>लक्षद्वीप</name>
</state>
<state>
<code>MP</code>
<name>मध्य प्रदेश</name>
</state>
<state>
<code>MH</code>
<name>महाराष्ट्र</name>
</state>
<state>
<code>MN</code>
<name>मणिपुर</name>
</state>
<state>
<code>ML</code>
<name>मेघालय</name>
</state>
<state>
<code>MZ</code>
<name>मिज़ोरम</name>
</state>
<state>
<code>NL</code>
<name>नागालैंड</name>
</state>
<state>
<code>OR</code>
<name>उड़ीसा</name>
</state>
<state>
<code>PB</code>
<name>पंजाब</name>
</state>
<state>
<code>PY</code>
<name>पुदुच्चेरी</name>
</state>
<state>
<code>RJ</code>
<name>राजस्थान</name>
</state>
<state>
<code>SK</code>
<name>सिक्किम</name>
</state>
<state>
<code>TN</code>
<name>तमिल नाडू</name>
</state>
<state>
<code>TG</code>
<name>तेलंगाना</name>
</state>
<state>
<code>TR</code>
<name>त्रिपुरा</name>
</state>
<state>
<code>UT</code>
<name>उत्तराखण्ड</name>
</state>
<state>
<code>UP</code>
<name>उत्तर प्रदेश</name>
</state>
<state>
<code>WB</code>
<name>पश्चिम बंगा</name>
</state>
</states>
<!-- ISO-3166-2 code + name - Hindi -->
<?xml version="1.0" encoding="UTF-8"?>
<states>
<state>
<code>IN-AN</code>
<name>अण्डमान और निकोबार द्वीपसमूह</name>
</state>
<state>
<code>IN-AP</code>
<name>आन्ध्र प्रदेश</name>
</state>
<state>
<code>IN-AR</code>
<name>अरुणाचल प्रदेश</name>
</state>
<state>
<code>IN-AS</code>
<name>असम</name>
</state>
<state>
<code>IN-BR</code>
<name>बिहार</name>
</state>
<state>
<code>IN-CH</code>
<name>चण्डीगढ़</name>
</state>
<state>
<code>IN-CT</code>
<name>छत्तीसगढ़</name>
</state>
<state>
<code>IN-DD</code>
<name>दमन और दीव</name>
</state>
<state>
<code>IN-DL</code>
<name>राष्ट्रीय राजधानी क्षेत्र दिल्ली</name>
</state>
<state>
<code>IN-DN</code>
<name>दादरा और नगर हवेली</name>
</state>
<state>
<code>IN-GA</code>
<name>गोवा</name>
</state>
<state>
<code>IN-GJ</code>
<name>गुजरात</name>
</state>
<state>
<code>IN-HR</code>
<name>हरयाणा</name>
</state>
<state>
<code>IN-HP</code>
<name>हिमाचल प्रदेश</name>
</state>
<state>
<code>IN-JK</code>
<name>जम्मू और कश्मीर</name>
</state>
<state>
<code>IN-JH</code>
<name>झारखण्ड</name>
</state>
<state>
<code>IN-KA</code>
<name>कर्नाटक</name>
</state>
<state>
<code>IN-KL</code>
<name>केरल</name>
</state>
<state>
<code>IN-LD</code>
<name>लक्षद्वीप</name>
</state>
<state>
<code>IN-MP</code>
<name>मध्य प्रदेश</name>
</state>
<state>
<code>IN-MH</code>
<name>महाराष्ट्र</name>
</state>
<state>
<code>IN-MN</code>
<name>मणिपुर</name>
</state>
<state>
<code>IN-ML</code>
<name>मेघालय</name>
</state>
<state>
<code>IN-MZ</code>
<name>मिज़ोरम</name>
</state>
<state>
<code>IN-NL</code>
<name>नागालैंड</name>
</state>
<state>
<code>IN-OR</code>
<name>उड़ीसा</name>
</state>
<state>
<code>IN-PB</code>
<name>पंजाब</name>
</state>
<state>
<code>IN-PY</code>
<name>पुदुच्चेरी</name>
</state>
<state>
<code>IN-RJ</code>
<name>राजस्थान</name>
</state>
<state>
<code>IN-SK</code>
<name>सिक्किम</name>
</state>
<state>
<code>IN-TN</code>
<name>तमिल नाडू</name>
</state>
<state>
<code>IN-TG</code>
<name>तेलंगाना</name>
</state>
<state>
<code>IN-TR</code>
<name>त्रिपुरा</name>
</state>
<state>
<code>IN-UT</code>
<name>उत्तराखण्ड</name>
</state>
<state>
<code>IN-UP</code>
<name>उत्तर प्रदेश</name>
</state>
<state>
<code>IN-WB</code>
<name>पश्चिम बंगा</name>
</state>
</states>
Comments