text: CREATE TABLE subdivision_ES (id VARCHAR(6) NOT NULL, name VARCHAR(255), level VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-C', E'A Coruña', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-AB', E'Albacete', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-A', E'Alicante', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-AL', E'Almería', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-AN', E'Andalusia', E'');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-O', E'Asturias', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-AS', E'Asturias', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-BA', E'Badajoz', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-PM', E'Baleares', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-B', E'Barcelona', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-BU', E'Burgos', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CN', E'Canarias', E'');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CB', E'Cantabria', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-S', E'Cantabria', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CS', E'Castellón', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CL', E'Castile and León', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CM', E'Castile-La Mancha', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CT', E'Catalonia', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CE', E'Ceuta', E'autonomous city');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CR', E'Ciudad Real', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CU', E'Cuenca', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CC', E'Cáceres', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CA', E'Cadiz', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-CO', E'Córdoba', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-EX', E'Extremadura', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-GA', E'Galicia', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-GI', E'Girona', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-GR', E'Granada', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-GU', E'Guadalajara', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-SS', E'Gipuzkoa', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-H', E'Huelva', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-HU', E'Huesca', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-IB', E'Balearic Islands', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-J', E'Jaén', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-LO', E'Rioja', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-GC', E'Las Palmas', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-LE', E'Leon', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-L', E'Lleida', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-LU', E'Lugo', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-M', E'Madrid', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-MD', E'Madrid', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-ML', E'Melilla', E'autonomous city');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-MU', E'Murcia', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-MC', E'Murcia', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-MA', E'Málaga', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-NA', E'Navarre', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-NC', E'Navarra', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-OR', E'Ourense', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-P', E'Palencia', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-PV', E'Basque Country', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-PO', E'Pontevedra', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-SA', E'Salamanca', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-TF', E'Santa Cruz de Tenerife', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-SG', E'Segovia', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-SE', E'Seville', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-SO', E'Soria', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-T', E'Tarragona', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-TE', E'Teruel', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-TO', E'Toledo', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-V', E'Valencia', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-VC', E'Valencian Community', E'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-VA', E'Valladolid', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-BI', E'Vizcaya', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-ZA', E'Zamora', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-Z', E'Zaragoza', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-VI', E'Álava', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-AV', E'Ávila', E'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-AR', E'', E'');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES (E'ES-RI', E'', E'autonomous community');
  