text: CREATE TABLE subdivision_IN (id VARCHAR(6) NOT NULL, name VARCHAR(255), level VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-AN', E'Andamanerna och Nikobarerna', E'union territory');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-AP', E'Andhra Pradesh', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-AR', E'Arunachal Pradesh', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-AS', E'Assam', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-BR', E'Bihar', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-CH', E'Chandigarh', E'union territory');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-CT', E'Chhattisgarh', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-DN', E'Dadra och Nagar Haveli', E'union territory');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-DD', E'Daman och Diu', E'union territory');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-DL', E'Delhi', E'union territory');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-GA', E'Goa', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-GJ', E'Gujarat', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-HR', E'Haryana', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-HP', E'Himachal Pradesh', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-JK', E'Jammu och Kashmir', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-JH', E'Jharkhand', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-KA', E'Karnataka', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-KL', E'Kerala', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-LD', E'Lakshadweep', E'union territory');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-MP', E'Madhya Pradesh', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-MH', E'Maharashtra', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-MN', E'Manipur', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-ML', E'Meghalaya', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-MZ', E'Mizoram', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-NL', E'Nagaland', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-OR', E'Orissa', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-PY', E'Pondicherry', E'union territory');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-PB', E'Punjab', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-RJ', E'Rajasthan', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-SK', E'Sikkim', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-TN', E'Tamil Nadu', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-TR', E'Tripura', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-UP', E'Uttar Pradesh', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-UT', E'Uttarakhand', E'state');
  INSERT INTO "subdivision_IN" ("id", "name", "level") VALUES (E'IN-WB', E'Västbengalen', E'state');
  