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 ('ES-AB', 'אלבסטה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-A', 'אליקנטה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-AN', 'אנדלוסיה', '');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-AS', 'אסטוריאס', 'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-BA', 'בדחוס', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-IB', 'האיים הבלאריים', 'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-B', 'ברצלונה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-CA', 'קדיס', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-S', 'קנטבריה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-CL', 'קסטיליה ולאון', 'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-CT', 'קטלוניה', 'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-CE', 'סאוטה', 'autonomous city');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-CR', 'סיודאד ריאל', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-CU', 'קואנקה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-CO', 'קורדובה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-EX', 'אקסטרמדורה', 'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-GR', 'גרנדה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-GU', 'גוודלחרה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-HU', 'אואסקה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-LE', 'לאון', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-L', 'ליידה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-LU', 'לוגו', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-MD', 'מדריד', 'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-ML', 'מלייה', 'autonomous city');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-MC', 'מורסיה', 'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-MA', 'מאלגה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-NC', 'נווארה', 'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-SA', 'סלמנקה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-TF', 'סנטה קרוס דה טנריפה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-SG', 'סגוביה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-SE', 'סביליה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-SO', 'סוריה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-T', 'טרגונה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-V', 'ולנסיה', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-VC', 'ולנסיה', 'autonomous community');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-VA', 'ואיאדוליד', 'province');
  INSERT INTO "subdivision_ES" ("id", "name", "level") VALUES ('ES-Z', 'סרגוסה', 'province');
  