text: CREATE TABLE subdivision_ES (id VARCHAR(6) NOT NULL, name VARCHAR(255) NOT NULL, level VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
  
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-C', 'A Coruña', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-AB', 'Albacete', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-A', 'Alicante', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-AL', 'Almería', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-AN', 'Andaluzja', '');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-AS', 'Asturia', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-BA', 'Badajoz', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-IB', 'Baleary', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-B', 'Barcelona', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-BU', 'Burgos', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-CA', 'Kadyks', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-S', 'Kantabria', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-CS', 'Castellón', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-CM', 'Kastylia-La Mancha', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-CL', 'Kastylia i León', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-CT', 'Katalonia', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-CE', 'Ceuta', 'autonomous city');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-CR', 'Ciudad Real', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-CU', 'Cuenca', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-CO', 'Córdoba', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-EX', 'Estremadura', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-GA', 'Galicja', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-SS', 'Prowincja Guipúzcoa', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-GI', 'Girona', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-GR', 'Grenada', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-GU', 'Guadalajara', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-H', 'Huelva', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-HU', 'Huesca', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-J', 'Jaén', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-GC', 'Las Palmas de Gran Canaria', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-LE', 'Leon', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-L', 'Lleida', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-LU', 'Lugo', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-MD', 'Madryt', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-ML', 'Melilla', 'autonomous city');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-MC', 'Murcja', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-MA', 'Malaga', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-NC', 'Nawarra', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-OR', 'Ourense', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-P', 'Palencia', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-PO', 'Pontevedra', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-SA', 'Salamanka', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-TF', 'Santa Cruz de Tenerife', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-SG', 'Segowia', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-SE', 'Sewilla', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-SO', 'Soria', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-T', 'Tarragona', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-TE', 'Teruel', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-TO', 'Toledo', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-V', 'Walencja', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-VC', 'Walencja', 'autonomous community');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-VA', 'Valladolid', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-ZA', 'Zamora', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-Z', 'Saragossa', 'province');
  INSERT INTO `subdivision_ES` (`id`, `name`, `level`) VALUES ('ES-VI', 'Prowincja Araba', 'province');
  