text: CREATE TABLE subdivision (country VARCHAR(2) NOT NULL, id VARCHAR(6) NOT NULL, name VARCHAR(255), level VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AD', 'AD-07', 'אנדורה לה ולה', 'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-1', 'בורגנלנד', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-3', 'אוסטריה תחתית', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-5', 'זלצבורג', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-6', 'שטיריה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-7', 'טירול', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-4', 'אוסטריה עילית', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-9', 'וינה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-8', 'פורארלברג', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BY', 'BY-HM', 'מינסק', 'city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-VAN', 'אנטוורפן', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-BRU', 'בריסל', 'capital region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-WLX', 'לוקסמבורג', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-WAL', 'ולוניה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-AB', 'אלברטה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-BC', 'קולומביה הבריטית', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-MB', 'מניטובה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NB', 'ניו ברנזוויק', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NL', 'ניופאונדלנד ולברדור', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NT', 'הטריטוריות הצפון-מערביות', 'territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NS', 'נובה סקוטיה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NU', 'נונאווט', 'territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-ON', 'אונטריו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-PE', 'אי הנסיך אדוארד', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-QC', 'קוויבק', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-YT', 'יוקון', 'territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-AT', 'מדבר אטקמה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-VS', 'ולפראיסו', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-070', 'אורהוס', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-040', 'בורנהולם', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-015', 'קופנהגן', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-85', 'זיילנד', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-37', 'מחוז האריו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-39', 'היומאה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-44', 'מחוז אידה-וירו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-51', 'מחוז יארבה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-49', 'מחוז ייגבה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-59', 'מחוז לאנה-וירו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-57', 'מחוז לאנה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-67', 'מחוז פרנו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-65', 'מחוז פילבה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-70', 'מחוז ראפלה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-74', 'סארמאה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-78', 'מחוז טרטו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-82', 'מחוז ולגה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-84', 'מחוז ויליאנדי', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-86', 'מחוז וורו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-01', 'אן', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-02', 'אן', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-03', 'אלייה', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-06', 'האלפים הימיים', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-04', 'האלפים של פרובאנס עילית', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-A', 'אלזס', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-B', 'אקיטן', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-08', 'ארדנים', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-07', 'ארדש', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-10', 'אוב', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-11', 'אוד', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-12', 'אוורון', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-67', 'ריין תחתון', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-D', 'בורגונדי', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-14', 'קלבדוס', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-F', 'מרכז', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-G', 'שמפאן-ארדן', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-17', 'השראנט הימי', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-18', 'שר', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-CP', 'קליפרטון', 'dependency');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-2A', 'קורסיקה הדרומית', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-H', 'קורסיקה', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-25', 'דו', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-29', 'פיניסטר', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-I', 'פראנש-קונטה', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-GP', 'גוואדלופ', 'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-2B', 'קורסיקה עילית', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-P', 'נורמנדי תחתית', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-GF', 'גיאנה הצרפתית', 'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-74', 'סבואה עילית', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-05', 'האלפים העליונים', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-92', 'רמות הסן', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-34', 'ארו', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-35', 'איל ווילן', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-37', 'אנדר ולואר', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-K', 'לנגדוק-רוסיון', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-42', 'לואר', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-44', 'הלואר האטלנטי', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-M', 'לוריין', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-46', 'לוט', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-48', 'לוזר', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-50', 'מאנש', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-MQ', 'מרטיניק', 'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-YT', 'מיוט', 'territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-N', 'מידי-פירנה', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-57', 'מוזל', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-O', 'נור-פה דה קאלה', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-61', 'אורן', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-75', 'פריז', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-62', 'פה-דה-קאלה', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-R', 'פיי דה לה לואר', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-S', 'פיקרדי', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-T', 'פואטו-שראנט', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-Q', 'נורמנדי עילית', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-PF', 'פולינזיה הצרפתית', 'overseas territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-NC', 'קלדוניה החדשה', 'overseas territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-RE', 'ראוניון', 'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-64', 'הפירנאים האטלנטיים', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-69', 'רון', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-V', 'רון-אלפ', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-73', 'סבואה', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-76', 'סן-מריטים', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-80', 'סום', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-81', 'טארן', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-82', 'טארן וגארון', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-84', 'ווקלוז', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-85', 'ונדה', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-86', 'ויין', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-89', 'יון', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-BL', 'סן ברתלמי', 'overseas territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-PM', 'סן פייר ומיקלון', 'territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-WF', 'ואליס ופוטונה', 'overseas territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-BW', 'באדן-וירטמברג', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-BY', 'בוואריה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-BE', 'ברלין', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-BB', 'ברנדנבורג', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-HB', 'ברמן', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-HH', 'המבורג', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-HE', 'הסן', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-NI', 'סקסוניה התחתונה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-MV', 'מקלנבורג-מערב פומרניה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-NW', 'נורדריין-וסטפאליה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-RP', 'ריינלנד-פאלץ', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-SL', 'חבל הסאר', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-SN', 'סקסוניה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-ST', 'סקסוניה-אנהלט', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-SH', 'שלזוויג-הולשטיין', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-TH', 'תורינגיה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-TV', 'וולטה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-AN', 'איי אנדמן וניקובר', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-AP', 'אנדרה פראדש', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-AS', 'אסאם', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-BR', 'ביהר', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-DN', 'דאדרה ונאגר הבלי', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-DD', 'דאמאן ודיו', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-DL', 'דלהי', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-GA', 'גואה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-HR', 'הריאנה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-KA', 'קארנאטקה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-KL', 'קרלה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-LD', 'לקשאדוויפ', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-MP', 'מאדהיה פראדש', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-MH', 'מהאראשטרה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-MN', 'מאניפור', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-ML', 'מגהלאיה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-MZ', 'מיזוראם', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-NL', 'נאגאלנד', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-OR', 'אוריסה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-SK', 'סיקים', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-TN', 'טאמיל נאדו', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-TR', 'טריפורה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-UP', 'אוטר פראדש', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-UT', 'אוטראקהאנד', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-WB', 'מערב בנגל', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-D', 'דבלין', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-G', 'גולוויי', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-L', 'לנסטר', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-LK', 'לימריק', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-M', 'מנסטר', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-U', 'אלסטר', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IL', 'IL-HA', 'חיפה', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IL', 'IL-JM', 'ירושלים', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IL', 'IL-TA', 'תל אביב-יפו', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-65', 'אברוצו', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AL', 'אלסנדריה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AN', 'אנקונה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AO', 'אאוסטה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AR', 'ארצו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AT', 'אסטי', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BA', 'בארי', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-77', 'בזיליקטה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BN', 'בנוונטו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BG', 'ברגמו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BI', 'ביאלה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BO', 'בולוניה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BZ', 'בולצנו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BS', 'ברשה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BR', 'ברינדיזי', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CA', 'קליארי', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-78', 'קלבריה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CL', 'קלטניסטה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-72', 'קמפניה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CB', 'קמפובאסו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CT', 'קטניה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CZ', 'קטנזארו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CO', 'קומו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CR', 'קרמונה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-KR', 'קרוטונה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CN', 'קונאו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-45', 'אמיליה-רומאניה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-EN', 'אנה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-FE', 'פרארה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-FI', 'פירנצה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-GO', 'גוריציה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BT', 'בארלטה-אנדריה-טראני', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CI', 'קרבוניה איגלסיס', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-75', 'פוליה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SP', 'לה ספציה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-62', 'לאציו', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-42', 'ליגוריה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-LI', 'ליבורנו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-25', 'לומברדיה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-LU', 'לוקה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MN', 'מנטובה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-57', 'מארקה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MT', 'מטרה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-ME', 'מסינה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MI', 'מילאנו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MO', 'מודנה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-67', 'מוליזה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-NA', 'נאפולי', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-OR', 'אוריסטאנו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PD', 'פאדובה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PA', 'פלרמו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PR', 'פארמה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PV', 'פאביה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-21', 'פיימונטה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PI', 'פיזה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PT', 'פיסטויה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PZ', 'פוטנצה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PO', 'פראטו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MS', 'מאסה-קרארה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-OL', 'אולביה טמפיו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PU', 'פזארו אה אורבינו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RG', 'רגוזה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RA', 'רוונה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RN', 'רימיני', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RM', 'רומא', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SA', 'סלרנו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-88', 'סרדיניה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SS', 'סאסארי', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-82', 'סיציליה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SI', 'סיינה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TA', 'טאראנטו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TR', 'טרני', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TP', 'טרפאני', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TN', 'טרנטו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TV', 'טרוויזו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TS', 'טריאסטה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TO', 'טורינו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-52', 'טוסקנה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-55', 'אומבריה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VA', 'וארזה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-34', 'ונטו', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VE', 'ונציה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VR', 'ורונה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VV', 'ויבו ולנטיה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('LU', 'LU-L', 'לוקסמבורג', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-AW', 'ארובה', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-BQ1', 'בונייר', 'special municipality');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-CW', 'קוראסאו', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-DR', 'דרנתה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-FL', 'פלבולנד', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-FR', 'פריסלנד', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-GE', 'חלדרלנד', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-GR', 'חרונינגן', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-NB', 'צפון בראבנט', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-NH', 'צפון הולנד', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-OV', 'אובראיסל', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-BQ2', 'סאבא', 'special municipality');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-BQ3', 'סנט אוסטתיוס', 'special municipality');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-ZH', 'דרום הולנד', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-UT', 'אוטרכט', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-ZE', 'זיילנד', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-02', 'אקרסהוס', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-22', 'יאן מאיין', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-03', 'אוסלו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-21', 'סבאלברד', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-20', 'האיים האזוריים', 'autonomous region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-03', 'בראגה', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-06', 'קוימברה', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-10', 'לייריה', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-11', 'ליסבון', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-30', 'מדיירה', 'autonomous region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-13', 'פורטו', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-14', 'סנטרם', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-15', 'סטובל', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-07', 'אבורה', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-AR', 'ארד', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BC', 'בקאו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BT', 'בוטושאן', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BV', 'בראשוב', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BR', 'בראילה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-B', 'בוקרשט', 'city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BZ', 'בוזאו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-CT', 'קונסטנצה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-GL', 'גאלאץ', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-HD', 'חונדוארה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-IS', 'יאשי', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-SM', 'סאטו מארה', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-SB', 'סיביו', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-VS', 'וסלוי', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-00', 'בלגרד', 'city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SK', 'SK-BC', 'באנסקה ביסטריצה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SK', 'SK-TA', 'מחוז טרנבה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-AB', 'אלבסטה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-A', 'אליקנטה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-AN', 'אנדלוסיה', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-AS', 'אסטוריאס', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-BA', 'בדחוס', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-IB', 'האיים הבלאריים', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-B', 'ברצלונה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CA', 'קדיס', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-S', 'קנטבריה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CL', 'קסטיליה ולאון', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CT', 'קטלוניה', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CE', 'סאוטה', 'autonomous city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CR', 'סיודאד ריאל', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CU', 'קואנקה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CO', 'קורדובה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-EX', 'אקסטרמדורה', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-GR', 'גרנדה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-GU', 'גוודלחרה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-HU', 'אואסקה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-LE', 'לאון', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-L', 'ליידה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-LU', 'לוגו', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-MD', 'מדריד', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-ML', 'מלייה', 'autonomous city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-MC', 'מורסיה', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-MA', 'מאלגה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-NC', 'נווארה', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-SA', 'סלמנקה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-TF', 'סנטה קרוס דה טנריפה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-SG', 'סגוביה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-SE', 'סביליה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-SO', 'סוריה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-T', 'טרגונה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-V', 'ולנסיה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-VC', 'ולנסיה', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-VA', 'ואיאדוליד', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-Z', 'סרגוסה', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-X', 'מחוז יבלבורג', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-Z', 'מחוז ימטלנד', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-AB', 'מחוז סטוקהולם', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-O', 'מחוז יטאלנד המערבית', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-AG', 'ארגאו', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-BE', 'ברן', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-FR', 'פריבור', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-GR', 'גראובינדן', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-NW', 'נידוולדן', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-OW', 'אובוולדן', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-SG', 'סנט גאלן', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-SO', 'זולותורן', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-TG', 'תורגאו', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-VS', 'ואלה', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-VD', 'וו', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-LU', 'לוצרן', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-ZH', 'ציריך', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-43', 'חצי האי קרים', 'autonomous republic');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-30', 'קייב', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-40', 'סבסטופול', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-05', 'מחוז ויניצה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-21', 'זקרפטיה', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ABE', 'אברדין', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-AGB', 'ארגייל וביוט', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BDF', 'בדפורדשייר', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BFS', 'בלפאסט', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BIR', 'ברמינגהאם', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BST', 'בריסטול', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CMD', 'קמדן', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CRF', 'קארדיף', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CON', 'קורנוול', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-COV', 'קובנטרי', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BDG', 'בארקינג ודאגנהאם', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CMA', 'קאמבריה', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DEN', 'דנבישייר', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DER', 'דרבי', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DBY', 'דרבישייר', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DRY', 'דרי', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DOR', 'דורסט', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DUR', 'דרהאם', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-EAL', 'אילינג', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-EDH', 'אדינבורו', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ENF', 'אנפילד', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ESS', 'אסקס', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-GAT', 'גייטסהד', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-GLG', 'גלאזגו', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-GLS', 'גלוסטרשייר', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HAM', 'המפשייר', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HRW', 'הארו', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HAV', 'הברינג', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-AGY', 'אנגלסי', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LND', 'הסיטי של לונדון', 'city corporation');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-IOW', 'האי וייט', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-IOS', 'איי סילי', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ISL', 'איזלינגטון', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-KEN', 'קנט', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-KHL', 'האל', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LAN', 'לנקשייר', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LRN', 'לרן', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LDS', 'לידס', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LCE', 'לסטר', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LIV', 'ליברפול', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NWM', 'ניוהאם', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MDB', 'מידלסברו', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NET', 'ניוקאסל', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NFK', 'נורפוק', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NGM', 'נוטינגהאם', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-OLD', 'אולדהאם', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ORK', 'אורקני', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-OXF', 'אוקספורדשייר', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-RDG', 'רדינג', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-RUT', 'ראטלנד', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SHF', 'שפילד', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ZET', 'איי שטלנד', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SOM', 'סאמרסט', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SFK', 'סאפוק', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'ENG', 'אנגליה', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-TWH', 'טאוור האמלטס', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'NIR', 'צפון אירלנד', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'SCT', 'סקוטלנד', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SWA', 'סוונסי', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'WLS', 'ויילס', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WAR', 'ווריקשייר', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WSM', 'וסטמינסטר', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WLV', 'וולברהמפטון', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WRX', 'רקסהאם', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-YOR', 'יורק', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AL', 'אלבמה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AK', 'אלסקה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AS', 'סמואה האמריקנית', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AZ', 'אריזונה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AR', 'ארקנסו', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-CA', 'קליפורניה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-CO', 'קולורדו', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-CT', 'קונטיקט', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-DE', 'דלאוור', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-FL', 'פלורידה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-GU', 'גואם', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-HI', 'הוואי', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-ID', 'איידהו', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-IL', 'אילינוי', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-IN', 'אינדיאנה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-IA', 'איווה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-KS', 'קנזס', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-KY', 'קנטקי', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-LA', 'לואיזיאנה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-ME', 'מיין', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MD', 'מרילנד', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MI', 'מישיגן', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MN', 'מינסוטה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MS', 'מיסיסיפי', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MO', 'מיזורי', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MT', 'מונטנה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NE', 'נברסקה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NV', 'נבדה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NH', 'ניו המפשייר', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NM', 'ניו מקסיקו', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NY', 'ניו יורק', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NC', 'קרוליינה הצפונית', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-ND', 'דקוטה הצפונית', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MP', 'איי מריאנה הצפוניים', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-OH', 'אוהיו', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-OK', 'אוקלהומה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-OR', 'אורגון', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-PA', 'פנסילבניה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-PR', 'פוארטו ריקו', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-RI', 'רוד איילנד', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-SC', 'קרוליינה הדרומית', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-SD', 'דקוטה הדרומית', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-TN', 'טנסי', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-TX', 'טקסס', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-UT', 'יוטה', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-DC', 'וושינגטון די. סי.', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-VT', 'ורמונט', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-VI', 'איי הבתולה', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-WA', 'וושינגטון', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-WI', 'ויסקונסין', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-WY', 'ויומינג', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-03', 'בירגו', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-04', 'בירקירקארה', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-09', 'פלוריאנה', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-25', 'לואה', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-29', 'מדינה', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-41', 'פייטה', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-20', 'סנגלאה', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-45', 'ויקטוריה', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-56', 'סליאמה', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-60', 'ולטה', 'local council');
  