text: CREATE TABLE subdivision_FR (id VARCHAR(6) NOT NULL, name VARCHAR(255), level VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-01', E'Ен', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-02', E'Ен', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-03', E'Алије', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-06', E'Приморски Алпи', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-04', E'Горњопровансалски Алпи', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-A', E'Алзас', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-B', E'Аквитанија', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-08', E'Ардени', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-07', E'Ардеш', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-09', E'Арјеж', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-10', E'Об', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-11', E'Од', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-12', E'Аверон', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-67', E'Доња Рајна', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-13', E'Ушће Роне', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-14', E'Калвадос', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-15', E'Кантал', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-F', E'Центар', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-G', E'Шампања-Ардени', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-16', E'Шарант', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-17', E'Приморски Шарант', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-18', E'Шер', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-CP', E'Острво Клипертон', E'dependency');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-19', E'Корез', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-2A', E'Јужна Корзика', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-H', E'Корзика', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-23', E'Крез', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-21', E'Златна обала', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-22', E'Обале Армора', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-79', E'Де Севр', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-24', E'Дордоња', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-25', E'Ду', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-26', E'Дром', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-91', E'Есон', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-27', E'Ер', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-28', E'Ер и Лоар', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-29', E'Финистер', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-I', E'Франш-Конте', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-30', E'Гар', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-32', E'Жерс', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-33', E'Жиронда', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-GP', E'Гваделуп', E'overseas regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-68', E'Горња Рајна', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-2B', E'Горња Корзика', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-31', E'Горња Гарона', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-P', E'Доња Нормандија', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-GF', E'Француска Гвајана', E'overseas regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-43', E'Горња Лоара', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-52', E'Горња Марна', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-74', E'Горња Савоја', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-70', E'Горња Саона', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-87', E'Горњи Вијен', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-05', E'Горњи Алпи', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-65', E'Високи Пиринеји', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-92', E'Сенски висови', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-34', E'Еро', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-35', E'Ил и Вилен', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-36', E'Ендр', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-37', E'Ендр и Лоара', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-38', E'Изер', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-39', E'Јура', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-K', E'Лангдок-Русијон', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-41', E'Лоар и Шер', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-42', E'Лоара', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-44', E'Атлантска Лоара', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-45', E'Лоаре', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-46', E'Лот', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-47', E'Лот и Гарона', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-48', E'Лозер', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-49', E'Мен и Лоара', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-50', E'Манш', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-51', E'Марна', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-MQ', E'Мартиник', E'overseas regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-53', E'Мајен', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-YT', E'Мајот', E'territorial collectivity');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-54', E'Мерт и Мозел', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-55', E'Меза', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-N', E'Миди Пирене', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-56', E'Морбијан', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-57', E'Мозел', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-58', E'Нијевр', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-O', E'Нор Па де Кале', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-60', E'Оаза', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-61', E'Орн', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-75', E'Париз', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-62', E'Па де Кале', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-R', E'Регион Лоара', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-S', E'Пикардија', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-T', E'Поату-Шарант', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-Q', E'Горња Нормандија', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-PF', E'Француска Полинезија', E'overseas territory');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-NC', E'Нова Каледонија', E'overseas territory');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-RE', E'Реинион', E'overseas regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-U', E'Прованса-Алпи-Азурна обала', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-63', E'Пиј де Дом', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-64', E'Атлантски Пиринеји', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-66', E'Источни Пиринеји', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-69', E'Рона', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-V', E'Рона-Алпи', E'metropolitan regions');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-72', E'Сарт', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-73', E'Савоја', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-71', E'Саона и Лоара', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-76', E'Приморска Сена', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-93', E'Сена-Сен Дени', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-77', E'Сена и Марна', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-80', E'Сома', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-82', E'Тарн и Гарона', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-90', E'Територија Белфор', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-95', E'Долина Оазе', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-94', E'Долина Марне', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-84', E'Воклиз', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-85', E'Вандеја', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-86', E'Вијен', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-88', E'Вогези', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-89', E'Јон', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-78', E'Ивлин', E'metropolitan department');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-BL', E'Острво Свети Бартоломеј', E'overseas territorial collectivity');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-PM', E'Свети Пјер и Микелон', E'territorial collectivity');
  INSERT INTO "subdivision_FR" ("id", "name", "level") VALUES (E'FR-WF', E'Валис и Футуна', E'overseas territory');
  