-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: rykfglntimonix.mysql.db
-- Generation Time: Paź 01, 2024 at 12:55 PM
-- Wersja serwera: 8.0.37-29
-- Wersja PHP: 8.1.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `rykfglntimonix`
--

-- --------------------------------------------------------

--
-- Struktura tabeli dla tabeli `countries`
--

CREATE TABLE `countries` (
  `id` int NOT NULL,
  `country_name_english` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `country_name_local` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `language_english` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `language_local` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `language_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `iso_country_code` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `iso_language_code` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `web_country_language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `official_languages` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `calling_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `iso_flag` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `unicode_flag` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `utf8_flag` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `flag_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `timezone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `continent` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `in_eu` tinyint(1) DEFAULT NULL,
  `country_foundation_date` date DEFAULT NULL,
  `reappearance_dates` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `removal_dates` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `svg_country_shape` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `capital` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `population` bigint DEFAULT NULL,
  `average_elevation` int DEFAULT NULL,
  `has_ocean_access` tinyint(1) DEFAULT NULL,
  `ip_range` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `income_rank` int DEFAULT NULL,
  `population_rank` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `country_name_english`, `country_name_local`, `language_english`, `language_local`, `country_code`, `language_code`, `iso_country_code`, `iso_language_code`, `web_country_language`, `official_languages`, `currency`, `calling_code`, `iso_flag`, `unicode_flag`, `utf8_flag`, `flag_image_url`, `timezone`, `continent`, `in_eu`, `country_foundation_date`, `reappearance_dates`, `removal_dates`, `svg_country_shape`, `capital`, `latitude`, `longitude`, `population`, `average_elevation`, `has_ocean_access`, `ip_range`, `income_rank`, `population_rank`) VALUES
(1, 'Poland', 'Polska', 'Polish', 'Polski', 'PL', 'PL', 'POL', 'POL', 'pl-PL', 'Polish', 'PLN', '+48', '🇵🇱', 'U+1F1F5 U+', 'D83C DDF5 ', 'https://example.com/flag_of_poland.png', 'Europe/Warsaw', 'Europe', 1, '0966-07-22', NULL, NULL, '<svg>...</svg>', 'Warsaw', 52.2297000, 21.0122000, 38386000, 173, 1, '83.0.0.0 - 83.7.255.255', 37, 38),
(2, 'Germany', 'Deutschland', 'German', 'Deutsch', 'DE', 'DE', 'DEU', 'DEU', 'de-DE', 'German', 'EUR', '+49', '🇩🇪', 'U+1F1E9 U+', 'D83C DDE9 ', 'https://example.com/flag_of_germany.png', 'Europe/Berlin', 'Europe', 1, '1871-01-18', NULL, NULL, '<svg>...</svg>', 'Berlin', 52.5200000, 13.4050000, 83149300, 160, 1, '80.128.0.0 - 80.135.255.255', 4, 19),
(3, 'United States', 'United States of America', 'English', 'English', 'US', 'EN', 'USA', 'ENG', 'en-US', 'English', 'USD', '+1', '🇺🇸', 'U+1F1FA U+', 'D83C DDFA ', 'https://example.com/flag_of_usa.png', 'America/New_York', 'North America', 0, '1776-07-04', NULL, NULL, '<svg>...</svg>', 'Washington D.C.', 38.8951000, -77.0364000, 331002651, 760, 1, '3.0.0.0 - 3.255.255.255', 1, 3),
(4, 'Canada', 'Canada', 'English, French', 'English, Fran', 'CA', 'EN, FR', 'CAN', 'ENG', 'en-CA, fr-CA', 'English, French', 'CAD', '+1', '🇨🇦', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_canada.png', 'America/Toronto', 'North America', 0, '1867-07-01', NULL, NULL, '<svg>...</svg>', 'Ottawa', 45.4215000, -75.6972000, 37742154, 487, 1, '24.48.0.0 - 24.49.255.255', 18, 39),
(5, 'France', 'France', 'French', 'Fran', 'FR', 'FR', 'FRA', 'FRA', 'fr-FR', 'French', 'EUR', '+33', '🇫🇷', 'U+1F1EB U+', 'D83C DDEB ', 'https://example.com/flag_of_france.png', 'Europe/Paris', 'Europe', 1, '0843-10-03', NULL, NULL, '<svg>...</svg>', 'Paris', 48.8566000, 2.3522000, 65273511, 243, 1, '2.0.0.0 - 2.31.255.255', 6, 22),
(6, 'Japan', '日本', 'Japanese', '日本語', 'JP', 'JA', 'JPN', 'JPN', 'ja-JP', 'Japanese', 'JPY', '+81', '🇯🇵', 'U+1F1EF U+', 'D83C DDEF ', 'https://example.com/flag_of_japan.png', 'Asia/Tokyo', 'Asia', 0, '0660-02-11', NULL, NULL, '<svg>...</svg>', 'Tokyo', 35.6762000, 139.6503000, 126476461, 438, 1, '133.0.0.0 - 133.127.255.255', 3, 11),
(7, 'Australia', 'Australia', 'English', 'English', 'AU', 'EN', 'AUS', 'ENG', 'en-AU', 'English', 'AUD', '+61', '🇦🇺', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_australia.png', 'Australia/Sydney', 'Oceania', 0, '1901-01-01', NULL, NULL, '<svg>...</svg>', 'Canberra', -35.2809000, 149.1300000, 25499884, 330, 1, '1.0.0.0 - 1.127.255.255', 13, 55),
(8, 'Brazil', 'Brasil', 'Portuguese', 'Português', 'BR', 'PT', 'BRA', 'POR', 'pt-BR', 'Portuguese', 'BRL', '+55', '🇧🇷', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_brazil.png', 'America/Sao_Paulo', 'South America', 0, '1822-09-07', NULL, NULL, '<svg>...</svg>', 'Brasilia', -15.8267000, -47.9218000, 212559417, 320, 1, '200.0.0.0 - 200.63.255.255', 9, 6),
(9, 'South Africa', 'South Africa', 'English, Afrikaans', 'English, Afrikaans', 'ZA', 'EN, AF', 'ZAF', 'ENG', 'en-ZA, af-ZA', 'English, Afrikaans', 'ZAR', '+27', '🇿🇦', 'U+1F1FF U+', 'D83C DDFF ', 'https://example.com/flag_of_south_africa.png', 'Africa/Johannesburg', 'Africa', 0, '1910-05-31', NULL, NULL, '<svg>...</svg>', 'Pretoria', -25.7479000, 28.2293000, 59308690, 1030, 1, '102.128.0.0 - 102.255.255.255', 25, 24),
(10, 'China', '中国', 'Chinese', '中文', 'CN', 'ZH', 'CHN', 'CHI', 'zh-CN', 'Chinese', 'CNY', '+86', '🇨🇳', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_china.png', 'Asia/Shanghai', 'Asia', 0, '1949-10-01', NULL, NULL, '<svg>...</svg>', 'Beijing', 39.9042000, 116.4074000, 1444216107, 38, 1, '1.0.1.0 - 1.0.2.255', 2, 1),
(11, 'India', 'भारत', 'Hindi', 'हिंदी', 'IN', 'HI', 'IND', 'HIN', 'hi-IN', 'Hindi', 'INR', '+91', '🇮🇳', 'U+1F1EE U+', 'D83C DDEE ', 'https://example.com/flag_of_india.png', 'Asia/Kolkata', 'Asia', 0, '1947-08-15', NULL, NULL, '<svg>...</svg>', 'New Delhi', 28.6139000, 77.2090000, 1393409038, 160, 1, '103.0.0.0 - 103.3.255.255', 5, 2),
(12, 'Russia', 'Россия', 'Russian', 'Русский', 'RU', 'RU', 'RUS', 'RUS', 'ru-RU', 'Russian', 'RUB', '+7', '🇷🇺', 'U+1F1F7 U+', 'D83C DDF7 ', 'https://example.com/flag_of_russia.png', 'Europe/Moscow', 'Europe', 0, '1991-12-25', NULL, NULL, '<svg>...</svg>', 'Moscow', 55.7558000, 37.6173000, 145912025, 144, 1, '5.0.0.0 - 5.255.255.255', 12, 9),
(13, 'Mexico', 'México', 'Spanish', 'Español', 'MX', 'ES', 'MEX', 'SPA', 'es-MX', 'Spanish', 'MXN', '+52', '🇲🇽', 'U+1F1F2 U+', 'D83C DDF2 ', 'https://example.com/flag_of_mexico.png', 'America/Mexico_City', 'North America', 0, '1810-09-16', NULL, NULL, '<svg>...</svg>', 'Mexico City', 19.4326000, -99.1332000, 126190788, 2250, 1, '187.160.0.0 - 187.191.255.255', 14, 10),
(14, 'United Kingdom', 'United Kingdom', 'English', 'English', 'GB', 'EN', 'GBR', 'ENG', 'en-GB', 'English', 'GBP', '+44', '🇬🇧', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_uk.png', 'Europe/London', 'Europe', 0, '1707-05-01', NULL, NULL, '<svg>...</svg>', 'London', 51.5074000, -0.1278000, 66834405, 35, 1, '2.16.0.0 - 2.31.255.255', 8, 21),
(15, 'Italy', 'Italia', 'Italian', 'Italiano', 'IT', 'IT', 'ITA', 'ITA', 'it-IT', 'Italian', 'EUR', '+39', '🇮🇹', 'U+1F1EE U+', 'D83C DDEE ', 'https://example.com/flag_of_italy.png', 'Europe/Rome', 'Europe', 1, '1861-03-17', NULL, NULL, '<svg>...</svg>', 'Rome', 41.9028000, 12.4964000, 60317116, 538, 1, '2.32.0.0 - 2.47.255.255', 10, 23),
(16, 'Argentina', 'Argentina', 'Spanish', 'Espa', 'AR', 'ES', 'ARG', 'SPA', 'es-AR', 'Spanish', 'ARS', '+54', '🇦🇷', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_argentina.png', 'America/Argentina/Buenos_Aires', 'South America', 0, '1816-07-09', NULL, NULL, '<svg>...</svg>', 'Buenos Aires', -34.6037000, -58.3816000, 45195774, 595, 1, '181.0.0.0 - 181.31.255.255', 21, 31),
(17, 'Egypt', 'مصر', 'Arabic', 'العربية', 'EG', 'AR', 'EGY', 'ARA', 'ar-EG', 'Arabic', 'EGP', '+20', '🇪🇬', 'U+1F1EA U+', 'D83C DDEA ', 'https://example.com/flag_of_egypt.png', 'Africa/Cairo', 'Africa', 0, '1922-02-28', NULL, NULL, '<svg>...</svg>', 'Cairo', 30.0444000, 31.2357000, 104258327, 23, 1, '156.192.0.0 - 156.223.255.255', 30, 14),
(18, 'South Korea', '대한민국', 'Korean', '한국어', 'KR', 'KO', 'KOR', 'KOR', 'ko-KR', 'Korean', 'KRW', '+82', '🇰🇷', 'U+1F1F0 U+', 'D83C DDF0 ', 'https://example.com/flag_of_south_korea.png', 'Asia/Seoul', 'Asia', 0, '1948-08-15', NULL, NULL, '<svg>...</svg>', 'Seoul', 37.5665000, 126.9780000, 51780579, 282, 1, '59.0.0.0 - 59.63.255.255', 11, 29),
(19, 'Turkey', 'Türkiye', 'Turkish', 'Türkçe', 'TR', 'TR', 'TUR', 'TUR', 'tr-TR', 'Turkish', 'TRY', '+90', '🇹🇷', 'U+1F1F9 U+', 'D83C DDF9 ', 'https://example.com/flag_of_turkey.png', 'Europe/Istanbul', 'Asia', 0, '1923-10-29', NULL, NULL, '<svg>...</svg>', 'Ankara', 39.9334000, 32.8597000, 84339067, 1132, 1, '78.160.0.0 - 78.167.255.255', 17, 19),
(20, 'Nigeria', 'Nigeria', 'English', 'English', 'NG', 'EN', 'NGA', 'ENG', 'en-NG', 'English', 'NGN', '+234', '🇳🇬', 'U+1F1F3 U+', 'D83C DDF3 ', 'https://example.com/flag_of_nigeria.png', 'Africa/Lagos', 'Africa', 0, '1960-10-01', NULL, NULL, '<svg>...</svg>', 'Abuja', 9.0765000, 7.3986000, 206139589, 380, 1, '41.58.0.0 - 41.63.255.255', 27, 7),
(21, 'Afghanistan', 'افغانستان', 'Pashto', 'پښتو', 'AF', 'PS', 'AFG', 'PSH', 'ps-AF', 'Pashto, Dari', 'AFN', '+93', '🇦🇫', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_afghanistan.png', 'Asia/Kabul', 'Asia', 0, '1919-08-19', NULL, NULL, '<svg>...</svg>', 'Kabul', 34.5289000, 69.1726000, 38928346, 1880, 0, '103.224.0.0 - 103.224.255.255', 173, 37),
(22, 'Albania', 'Shqipëria', 'Albanian', 'Shqip', 'AL', 'SQ', 'ALB', 'ALB', 'sq-AL', 'Albanian', 'ALL', '+355', '🇦🇱', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_albania.png', 'Europe/Tirane', 'Europe', 0, '1912-11-28', NULL, NULL, '<svg>...</svg>', 'Tirana', 41.3275000, 19.8189000, 2877797, 708, 1, '141.0.0.0 - 141.0.0.255', 136, 141),
(23, 'Algeria', 'الجزائر', 'Arabic', 'العربية', 'DZ', 'AR', 'DZA', 'ARA', 'ar-DZ', 'Arabic, Berber', 'DZD', '+213', '🇩🇿', 'U+1F1E9 U+', 'D83C DDE9 ', 'https://example.com/flag_of_algeria.png', 'Africa/Algiers', 'Africa', 0, '1962-07-05', NULL, NULL, '<svg>...</svg>', 'Algiers', 36.7529000, 3.0420000, 43851044, 800, 1, '41.108.0.0 - 41.111.255.255', 53, 34),
(24, 'Andorra', 'Andorra', 'Catalan', 'Catal', 'AD', 'CA', 'AND', 'CAT', 'ca-AD', 'Catalan', 'EUR', '+376', '🇦🇩', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_andorra.png', 'Europe/Andorra', 'Europe', 0, '1278-09-08', NULL, NULL, '<svg>...</svg>', 'Andorra la Vella', 42.5063000, 1.5218000, 77265, 1996, 0, '80.24.0.0 - 80.24.127.255', 50, 211),
(25, 'Angola', 'Angola', 'Portuguese', 'Português', 'AO', 'PT', 'AGO', 'POR', 'pt-AO', 'Portuguese', 'AOA', '+244', '🇦🇴', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_angola.png', 'Africa/Luanda', 'Africa', 0, '1975-11-11', NULL, NULL, '<svg>...</svg>', 'Luanda', -8.8383000, 13.2344000, 32866272, 1050, 1, '102.72.0.0 - 102.79.255.255', 85, 44),
(26, 'Antigua and Barbuda', 'Antigua and Barbuda', 'English', 'English', 'AG', 'EN', 'ATG', 'ENG', 'en-AG', 'English', 'XCD', '+1-268', '🇦🇬', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_antigua.png', 'America/Antigua', 'North America', 0, '1981-11-01', NULL, NULL, '<svg>...</svg>', 'St. John\'s', 17.1274000, -61.8468000, 97929, 15, 1, '208.94.0.0 - 208.94.127.255', 69, 213),
(27, 'Armenia', 'Հայաստան', 'Armenian', 'Հայերեն', 'AM', 'HY', 'ARM', 'HYE', 'hy-AM', 'Armenian', 'AMD', '+374', '🇦🇲', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_armenia.png', 'Asia/Yerevan', 'Asia', 0, '1991-09-21', NULL, NULL, '<svg>...</svg>', 'Yerevan', 40.1792000, 44.4991000, 2963234, 900, 0, '5.32.192.0 - 5.32.223.255', 136, 138),
(28, 'Austria', 'Österreich', 'German', 'Deutsch', 'AT', 'DE', 'AUT', 'GER', 'de-AT', 'German', 'EUR', '+43', '🇦🇹', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_austria.png', 'Europe/Vienna', 'Europe', 1, '1955-10-26', NULL, NULL, '<svg>...</svg>', 'Vienna', 48.2082000, 16.3738000, 8901064, 443, 0, '80.120.0.0 - 80.127.255.255', 16, 94),
(29, 'Azerbaijan', 'Azərbaycan', 'Azerbaijani', 'Azərbaycan', 'AZ', 'AZ', 'AZE', 'AZE', 'az-AZ', 'Azerbaijani', 'AZN', '+994', '🇦🇿', 'U+1F1E6 U+', 'D83C DDE6 ', 'https://example.com/flag_of_azerbaijan.png', 'Asia/Baku', 'Asia', 0, '1991-10-18', NULL, NULL, '<svg>...</svg>', 'Baku', 40.4093000, 49.8671000, 10139177, 384, 1, '5.197.0.0 - 5.197.255.255', 106, 90),
(30, 'Bahamas', 'Bahamas', 'English', 'English', 'BS', 'EN', 'BHS', 'ENG', 'en-BS', 'English', 'BSD', '+1-242', '🇧🇸', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_bahamas.png', 'America/Nassau', 'North America', 0, '1973-07-10', NULL, NULL, '<svg>...</svg>', 'Nassau', 25.0343000, -77.3963000, 393244, 5, 1, '24.51.64.0 - 24.51.127.255', 54, 179),
(31, 'Bahrain', 'البحرين', 'Arabic', 'العربية', 'BH', 'AR', 'BHR', 'ARA', 'ar-BH', 'Arabic', 'BHD', '+973', '🇧🇭', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_bahrain.png', 'Asia/Bahrain', 'Asia', 0, '1971-12-16', NULL, NULL, '<svg>...</svg>', 'Manama', 26.2285000, 50.5861000, 1701575, 10, 1, '77.69.0.0 - 77.69.255.255', 26, 150),
(32, 'Bangladesh', 'বাংলাদেশ', 'Bengali', 'বাংলা', 'BD', 'BN', 'BGD', 'BEN', 'bn-BD', 'Bengali', 'BDT', '+880', '🇧🇩', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_bangladesh.png', 'Asia/Dhaka', 'Asia', 0, '1971-03-26', NULL, NULL, '<svg>...</svg>', 'Dhaka', 23.8103000, 90.4125000, 164689383, 85, 1, '103.36.0.0 - 103.39.255.255', 146, 8),
(33, 'Barbados', 'Barbados', 'English', 'English', 'BB', 'EN', 'BRB', 'ENG', 'en-BB', 'English', 'BBD', '+1-246', '🇧🇧', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_barbados.png', 'America/Barbados', 'North America', 0, '1966-11-30', NULL, NULL, '<svg>...</svg>', 'Bridgetown', 13.0975000, -59.6167000, 287375, 336, 1, '72.22.0.0 - 72.22.31.255', 63, 207),
(34, 'Belarus', 'Беларусь', 'Belarusian', 'Беларуская', 'BY', 'BE', 'BLR', 'BEL', 'be-BY', 'Belarusian, Russian', 'BYN', '+375', '🇧🇾', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_belarus.png', 'Europe/Minsk', 'Europe', 0, '1991-08-25', NULL, NULL, '<svg>...</svg>', 'Minsk', 53.9006000, 27.5590000, 9449323, 160, 0, '37.44.0.0 - 37.47.255.255', 69, 91),
(35, 'Belgium', 'Belgi', 'Dutch', 'Nederlands', 'BE', 'NL', 'BEL', 'NED', 'nl-BE', 'Dutch, French, German', 'EUR', '+32', '🇧🇪', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_belgium.png', 'Europe/Brussels', 'Europe', 1, '1830-10-04', NULL, NULL, '<svg>...</svg>', 'Brussels', 50.8503000, 4.3517000, 11589623, 67, 1, '2.16.0.0 - 2.31.255.255', 25, 83),
(36, 'Belize', 'Belize', 'English', 'English', 'BZ', 'EN', 'BLZ', 'ENG', 'en-BZ', 'English', 'BZD', '+501', '🇧🇿', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_belize.png', 'America/Belize', 'North America', 0, '1981-09-21', NULL, NULL, '<svg>...</svg>', 'Belmopan', 17.2510000, -88.7590000, 419199, 173, 1, '190.197.0.0 - 190.197.255.255', 73, 180),
(37, 'Benin', 'Bénin', 'French', 'Français', 'BJ', 'FR', 'BEN', 'FRA', 'fr-BJ', 'French', 'XOF', '+229', '🇧🇯', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_benin.png', 'Africa/Porto-Novo', 'Africa', 0, '1960-08-01', NULL, NULL, '<svg>...</svg>', 'Porto-Novo', 6.4969000, 2.6289000, 12123200, 200, 1, '41.74.0.0 - 41.75.255.255', 147, 79),
(38, 'Bhutan', 'འབྲུག་ཡུལ', 'Dzongkha', 'རྫོང་ཁ', 'BT', 'DZ', 'BTN', 'DZO', 'dz-BT', 'Dzongkha', 'BTN', '+975', '🇧🇹', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_bhutan.png', 'Asia/Thimphu', 'Asia', 0, '1949-08-08', NULL, NULL, '<svg>...</svg>', 'Thimphu', 27.4712000, 89.6339000, 771612, 2400, 0, '103.250.0.0 - 103.250.63.255', 164, 165),
(39, 'Bolivia', 'Bolivia', 'Spanish', 'Español', 'BO', 'ES', 'BOL', 'SPA', 'es-BO', 'Spanish, Quechua, Aymara', 'BOB', '+591', '🇧🇴', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_bolivia.png', 'America/La_Paz', 'South America', 0, '1825-08-06', NULL, NULL, '<svg>...</svg>', 'Sucre', -19.0196000, -65.2619000, 11673021, 1192, 0, '181.224.0.0 - 181.224.255.255', 98, 81),
(40, 'Bosnia and Herzegovina', 'Bosna i Hercegovina', 'Bosnian', 'Bosanski', 'BA', 'BS', 'BIH', 'BOS', 'bs-BA', 'Bosnian, Serbian, Croatian', 'BAM', '+387', '🇧🇦', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_bosnia.png', 'Europe/Sarajevo', 'Europe', 0, '1992-03-01', NULL, NULL, '<svg>...</svg>', 'Sarajevo', 43.8563000, 18.4131000, 3280815, 500, 1, '80.65.64.0 - 80.65.127.255', 82, 135),
(41, 'Botswana', 'Botswana', 'English', 'English', 'BW', 'EN', 'BWA', 'ENG', 'en-BW', 'English, Tswana', 'BWP', '+267', '🇧🇼', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_botswana.png', 'Africa/Gaborone', 'Africa', 0, '1966-09-30', NULL, NULL, '<svg>...</svg>', 'Gaborone', -24.6282000, 25.9231000, 2351627, 1010, 0, '168.167.0.0 - 168.167.255.255', 89, 145),
(43, 'Brunei', 'Negara Brunei Darussalam', 'Malay', 'Bahasa Melayu', 'BN', 'MS', 'BRN', 'MAY', 'ms-BN', 'Malay', 'BND', '+673', '🇧🇳', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_brunei.png', 'Asia/Brunei', 'Asia', 0, '1984-01-01', NULL, NULL, '<svg>...</svg>', 'Bandar Seri Begawan', 4.9031000, 114.9398000, 437483, 45, 1, '103.4.160.0 - 103.4.191.255', 53, 177),
(44, 'Bulgaria', 'България', 'Bulgarian', 'български език', 'BG', 'BG', 'BGR', 'BUL', 'bg-BG', 'Bulgarian', 'BGN', '+359', '🇧🇬', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_bulgaria.png', 'Europe/Sofia', 'Europe', 1, '1908-09-22', NULL, NULL, '<svg>...</svg>', 'Sofia', 42.6975000, 23.3242000, 6927288, 470, 0, '62.44.96.0 - 62.44.127.255', 67, 107),
(45, 'Burkina Faso', 'Burkina Faso', 'French', 'Fran', 'BF', 'FR', 'BFA', 'FRA', 'fr-BF', 'French', 'XOF', '+226', '🇧🇫', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_burkina.png', 'Africa/Ouagadougou', 'Africa', 0, '1960-08-05', NULL, NULL, '<svg>...</svg>', 'Ouagadougou', 12.3714000, -1.5197000, 20903278, 305, 0, '156.96.0.0 - 156.96.255.255', 177, 59),
(46, 'Burundi', 'Burundi', 'Kirundi', 'Ikirundi', 'BI', 'RN', 'BDI', 'RUN', 'rn-BI', 'Kirundi, French, English', 'BIF', '+257', '🇧🇮', 'U+1F1E7 U+', 'D83C DDE7 ', 'https://example.com/flag_of_burundi.png', 'Africa/Bujumbura', 'Africa', 0, '1962-07-01', NULL, NULL, '<svg>...</svg>', 'Gitega', -3.4284000, 29.9246000, 11890784, 1500, 0, '154.117.0.0 - 154.117.255.255', 184, 78),
(47, 'Cabo Verde', 'Cabo Verde', 'Portuguese', 'Português', 'CV', 'PT', 'CPV', 'POR', 'pt-CV', 'Portuguese', 'CVE', '+238', '🇨🇻', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_cabo_verde.png', 'Atlantic/Cape_Verde', 'Africa', 0, '1975-07-05', NULL, NULL, '<svg>...</svg>', 'Praia', 14.9331000, -23.5133000, 555988, 348, 1, '196.216.0.0 - 196.216.255.255', 137, 165),
(48, 'Cambodia', 'កម្ពុជា', 'Khmer', 'ខ្មែរ', 'KH', 'KM', 'KHM', 'KHM', 'km-KH', 'Khmer', 'KHR', '+855', '🇰🇭', 'U+1F1F0 U+', 'D83C DDF0 ', 'https://example.com/flag_of_cambodia.png', 'Asia/Phnom_Penh', 'Asia', 0, '1953-11-09', NULL, NULL, '<svg>...</svg>', 'Phnom Penh', 11.5564000, 104.9282000, 16718965, 126, 1, '103.23.144.0 - 103.23.159.255', 116, 71),
(49, 'Cameroon', 'Cameroun', 'French', 'Français', 'CM', 'FR', 'CMR', 'FRA', 'fr-CM', 'French, English', 'XAF', '+237', '🇨🇲', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_cameroon.png', 'Africa/Douala', 'Africa', 0, '1960-01-01', NULL, NULL, '<svg>...</svg>', 'Yaound', 3.8480000, 11.5021000, 26545863, 667, 1, '154.73.0.0 - 154.73.255.255', 153, 52),
(51, 'Central African Republic', 'République centrafricaine', 'French', 'Français', 'CF', 'FR', 'CAF', 'FRA', 'fr-CF', 'French, Sango', 'XAF', '+236', '🇨🇫', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_car.png', 'Africa/Bangui', 'Africa', 0, '1960-08-13', NULL, NULL, '<svg>...</svg>', 'Bangui', 4.3947000, 18.5582000, 4829767, 635, 0, '41.79.192.0 - 41.79.223.255', 196, 123),
(52, 'Chad', 'Tchad', 'French', 'Français', 'TD', 'FR', 'TCD', 'FRA', 'fr-TD', 'French, Arabic', 'XAF', '+235', '🇹🇩', 'U+1F1F9 U+', 'D83C DDFF ', 'https://example.com/flag_of_chad.png', 'Africa/Ndjamena', 'Africa', 0, '1960-08-11', NULL, NULL, '<svg>...</svg>', 'N\'Djamena', 12.1348000, 15.0557000, 16425859, 286, 1, '102.136.0.0 - 102.136.255.255', 198, 72),
(53, 'Chile', 'Chile', 'Spanish', 'Español', 'CL', 'ES', 'CHL', 'SPA', 'es-CL', 'Spanish', 'CLP', '+56', '🇨🇱', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_chile.png', 'America/Santiago', 'South America', 0, '1818-02-12', NULL, NULL, '<svg>...</svg>', 'Santiago', -33.4489000, -70.6693000, 19116201, 187, 1, '201.220.0.0 - 201.223.255.255', 56, 63),
(55, 'Colombia', 'Colombia', 'Spanish', 'Español', 'CO', 'ES', 'COL', 'SPA', 'es-CO', 'Spanish', 'COP', '+57', '🇨🇴', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_colombia.png', 'America/Bogota', 'South America', 0, '1810-07-20', NULL, NULL, '<svg>...</svg>', 'Bogot', 4.7110000, -74.0721000, 50882891, 2640, 1, '181.56.0.0 - 181.56.255.255', 97, 29),
(56, 'Comoros', 'Komori', 'Comorian', 'Shikomori', 'KM', 'CO', 'COM', 'COM', 'co-KM', 'Comorian, Arabic, French', 'KMF', '+269', '🇰🇲', 'U+1F1F0 U+', 'D83C DDF0 ', 'https://example.com/flag_of_comoros.png', 'Indian/Comoro', 'Africa', 0, '1975-07-06', NULL, NULL, '<svg>...</svg>', 'Moroni', -11.7172000, 43.2473000, 869601, 2361, 1, '197.255.0.0 - 197.255.255.255', 205, 161),
(57, 'Congo (Congo-Brazzaville)', 'République du Congo', 'French', 'Français', 'CG', 'FR', 'COG', 'FRA', 'fr-CG', 'French, Kituba, Lingala', 'XAF', '+242', '🇨🇬', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_congo.png', 'Africa/Brazzaville', 'Africa', 0, '1960-08-15', NULL, NULL, '<svg>...</svg>', 'Brazzaville', -4.2634000, 15.2429000, 5518087, 320, 1, '41.138.0.0 - 41.138.127.255', 170, 115),
(58, 'Costa Rica', 'Costa Rica', 'Spanish', 'Español', 'CR', 'ES', 'CRI', 'SPA', 'es-CR', 'Spanish', 'CRC', '+506', '🇨🇷', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_costa_rica.png', 'America/Costa_Rica', 'North America', 0, '1821-09-15', NULL, NULL, '<svg>...</svg>', 'San Jos', 9.9281000, -84.0907000, 5094114, 1190, 1, '201.192.0.0 - 201.192.127.255', 85, 123),
(59, 'Croatia', 'Hrvatska', 'Croatian', 'Hrvatski', 'HR', 'HR', 'HRV', 'CRO', 'hr-HR', 'Croatian', 'HRK', '+385', '🇭🇷', 'U+1F1ED U+', 'D83C DDED ', 'https://example.com/flag_of_croatia.png', 'Europe/Zagreb', 'Europe', 1, '1991-06-25', NULL, NULL, '<svg>...</svg>', 'Zagreb', 45.8150000, 15.9819000, 4076246, 331, 1, '161.53.0.0 - 161.53.127.255', 54, 130),
(60, 'Cuba', 'Cuba', 'Spanish', 'Español', 'CU', 'ES', 'CUB', 'SPA', 'es-CU', 'Spanish', 'CUP', '+53', '🇨🇺', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_cuba.png', 'America/Havana', 'North America', 0, '1902-05-20', NULL, NULL, '<svg>...</svg>', 'Havana', 23.1136000, -82.3666000, 11326616, 108, 1, '190.6.128.0 - 190.6.255.255', 116, 83),
(61, 'Cyprus', 'Κύπρος', 'Greek', 'Ελληνικά', 'CY', 'EL', 'CYP', 'ELL', 'el-CY', 'Greek, Turkish', 'EUR', '+357', '🇨🇾', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_cyprus.png', 'Asia/Nicosia', 'Europe', 1, '1960-08-16', NULL, NULL, '<svg>...</svg>', 'Nicosia', 35.1856000, 33.3823000, 1207359, 91, 1, '194.154.128.0 - 194.154.255.255', 40, 159),
(62, 'Czech Republic', 'Česká republika', 'Czech', 'Čeština', 'CZ', 'CS', 'CZE', 'CES', 'cs-CZ', 'Czech', 'CZK', '+420', '🇨🇿', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_czech_republic.png', 'Europe/Prague', 'Europe', 1, '1993-01-01', NULL, NULL, '<svg>...</svg>', 'Prague', 50.0755000, 14.4378000, 10708981, 433, 0, '62.240.0.0 - 62.240.127.255', 35, 85),
(63, 'Denmark', 'Danmark', 'Danish', 'Dansk', 'DK', 'DA', 'DNK', 'DAN', 'da-DK', 'Danish', 'DKK', '+45', '🇩🇰', 'U+1F1E9 U+', 'D83C DDE9 ', 'https://example.com/flag_of_denmark.png', 'Europe/Copenhagen', 'Europe', 1, '1397-06-17', NULL, NULL, '<svg>...</svg>', 'Copenhagen', 55.6761000, 12.5683000, 5814461, 34, 1, '2.104.0.0 - 2.107.255.255', 17, 113),
(64, 'Djibouti', 'Djibouti', 'French', 'Français', 'DJ', 'FR', 'DJI', 'FRA', 'fr-DJ', 'French, Arabic', 'DJF', '+253', '🇩🇯', 'U+1F1E9 U+', 'D83C DDE9 ', 'https://example.com/flag_of_djibouti.png', 'Africa/Djibouti', 'Africa', 0, '1977-06-27', NULL, NULL, '<svg>...</svg>', 'Djibouti', 11.8251000, 42.5903000, 1078373, 155, 1, '154.117.128.0 - 154.117.191.255', 208, 160),
(65, 'Dominica', 'Dominica', 'English', 'English', 'DM', 'EN', 'DMA', 'ENG', 'en-DM', 'English', 'XCD', '+1-767', '🇩🇲', 'U+1F1E9 U+', 'D83C DDE9 ', 'https://example.com/flag_of_dominica.png', 'America/Dominica', 'North America', 0, '1978-11-03', NULL, NULL, '<svg>...</svg>', 'Roseau', 15.3092000, -61.3794000, 71808, 447, 1, '69.61.112.0 - 69.61.119.255', 220, 213),
(66, 'Dominican Republic', 'República Dominicana', 'Spanish', 'Spanish', 'DO', 'ES', 'DOM', 'SPA', 'es-DO', 'Spanish', 'DOP', '+1-809', '🇩🇴', 'U+1F1E9 U+', 'D83C DDE9 ', 'https://example.com/flag_of_dominican_republic.png', 'America/Santo_Domingo', 'North America', 0, '1844-02-27', NULL, NULL, '<svg>...</svg>', 'Santo Domingo', 18.4861000, -69.9312000, 10847910, 17, 1, '152.168.0.0 - 152.168.255.255', 88, 85),
(67, 'East Timor', 'Timor-Leste', 'Tetum', 'Tetum', 'TL', 'TE', 'TLS', 'TET', 'te-TL', 'Tetum, Portuguese', 'USD', '+670', '🇹🇱', 'U+1F1F9 U+', 'D83C DDFF ', 'https://example.com/flag_of_timor_leste.png', 'Asia/Dili', 'Asia', 0, '2002-05-20', NULL, NULL, '<svg>...</svg>', 'Dili', -8.5569000, 125.5603000, 1387149, 600, 1, '118.97.0.0 - 118.97.255.255', 167, 158),
(68, 'Ecuador', 'Ecuador', 'Spanish', 'Español', 'EC', 'ES', 'ECU', 'SPA', 'es-EC', 'Spanish', 'USD', '+593', '🇪🇨', 'U+1F1EA U+', 'D83C DDEA ', 'https://example.com/flag_of_ecuador.png', 'America/Guayaquil', 'South America', 0, '1830-05-13', NULL, NULL, '<svg>...</svg>', 'Quito', -0.1807000, -78.4678000, 17643060, 800, 1, '190.152.0.0 - 190.152.255.255', 100, 67),
(70, 'El Salvador', 'El Salvador', 'Spanish', 'Español', 'SV', 'ES', 'SLV', 'SPA', 'es-SV', 'Spanish', 'USD', '+503', '🇬🇶', 'U+1F1F8 U+', 'D83C DDFA ', 'https://example.com/flag_of_el_salvador.png', 'America/El_Salvador', 'North America', 0, '1841-01-15', NULL, NULL, '<svg>...</svg>', 'San Salvador', 13.6929000, -89.2182000, 6486201, 443, 1, '190.87.128.0 - 190.87.159.255', 130, 111),
(71, 'Equatorial Guinea', 'Guinea Ecuatorial', 'Spanish', 'Español', 'GQ', 'ES', 'GNQ', 'SPA', 'es-GQ', 'Spanish, French, Portuguese', 'XAF', '+240', '🇬🇶', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_equatorial_guinea.png', 'Africa/Malabo', 'Africa', 0, '1968-10-12', NULL, NULL, '<svg>...</svg>', 'Malabo', 3.7500000, 8.7833000, 1442223, 577, 1, '105.235.0.0 - 105.235.255.255', 121, 149),
(72, 'Eritrea', 'ኤርትራ', 'Tigrinya', 'ትግርኛ', 'ER', 'TI', 'ERI', 'TIR', 'ti-ER', 'Tigrinya, Arabic, English', 'ERN', '+291', '🇪🇷', 'U+1F1EA U+', 'D83C DDEA ', 'https://example.com/flag_of_eritrea.png', 'Africa/Asmara', 'Africa', 0, '1993-05-24', NULL, NULL, '<svg>...</svg>', 'Asmara', 15.3229000, 38.9251000, 3546000, 2328, 1, '197.156.64.0 - 197.156.95.255', 181, 132),
(73, 'Estonia', 'Eesti', 'Estonian', 'Eesti', 'EE', 'ET', 'EST', 'EST', 'et-EE', 'Estonian', 'EUR', '+372', '🇪🇪', 'U+1F1EA U+', 'D83C DDEA ', 'https://example.com/flag_of_estonia.png', 'Europe/Tallinn', 'Europe', 1, '1918-02-24', NULL, NULL, '<svg>...</svg>', 'Tallinn', 59.4370000, 24.7535000, 1328976, 50, 1, '5.44.192.0 - 5.44.223.255', 38, 158),
(74, 'Eswatini', 'Eswatini', 'Swazi', 'siSwati', 'SZ', 'SW', 'SWZ', 'SWA', 'sw-SZ', 'Swazi, English', 'SZL', '+268', '🇸🇿', 'U+1F1F8 U+', 'D83C DDF8 ', 'https://example.com/flag_of_eswatini.png', 'Africa/Mbabane', 'Africa', 0, '1968-09-06', NULL, NULL, '<svg>...</svg>', 'Mbabane', -26.5225000, 31.4659000, 1160164, 1, 0, '196.200.32.0 - 196.200.63.255', 190, 156),
(75, 'Ethiopia', 'ኢትዮጵያ', 'Amharic', 'አማርኛ', 'ET', 'AM', 'ETH', 'AMH', 'am-ET', 'Amharic', 'ETB', '+251', '🇪🇹', 'U+1F1EA U+', 'D83C DDEA ', 'https://example.com/flag_of_ethiopia.png', 'Africa/Addis_Ababa', 'Africa', 0, '1995-08-21', NULL, NULL, '<svg>...</svg>', 'Addis Ababa', 9.0331000, 38.7636000, 120812698, 2450, 1, '197.156.32.0 - 197.156.63.255', 168, 12),
(76, 'Fiji', 'Fiji', 'English', 'English', 'FJ', 'EN', 'FJI', 'ENG', 'en-FJ', 'English, Fijian', 'FJD', '+679', '🇫🇯', 'U+1F1EB U+', 'D83C DDEB ', 'https://example.com/flag_of_fiji.png', 'Pacific/Fiji', 'Oceania', 0, '1970-10-10', NULL, NULL, '<svg>...</svg>', 'Suva', -18.1416000, 178.4419000, 926276, 122, 1, '123.120.64.0 - 123.120.127.255', 118, 161),
(77, 'Finland', 'Suomi', 'Finnish', 'Suomi', 'FI', 'FI', 'FIN', 'FIN', 'fi-FI', 'Finnish, Swedish', 'EUR', '+358', '🇫🇮', 'U+1F1EB U+', 'D83C DDEB ', 'https://example.com/flag_of_finland.png', 'Europe/Helsinki', 'Europe', 1, '1917-12-06', NULL, NULL, '<svg>...</svg>', 'Helsinki', 60.1695000, 24.9354000, 5540720, 170, 1, '85.76.0.0 - 85.76.255.255', 9, 115),
(78, 'Gabon', 'Gabon', 'French', 'Français', 'GA', 'FR', 'GAB', 'FRA', 'fr-GA', 'French', 'XAF', '+241', '🇬🇦', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_gabon.png', 'Africa/Libreville', 'Africa', 0, '1960-08-16', NULL, NULL, '<svg>...</svg>', 'Libreville', 0.4162000, 9.4673000, 2343846, 215, 1, '154.72.0.0 - 154.75.255.255', 113, 146),
(79, 'Gambia', 'The Gambia', 'English', 'English', 'GM', 'EN', 'GMB', 'ENG', 'en-GM', 'English', 'GMD', '+220', '🇬🇲', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_gambia.png', 'Africa/Banjul', 'Africa', 0, '1965-02-18', NULL, NULL, '<svg>...</svg>', 'Banjul', 13.4549000, -16.5790000, 2416668, 34, 1, '196.223.192.0 - 196.223.223.255', 190, 141),
(80, 'Georgia', 'საქართველო', 'Georgian', 'ქართული', 'GE', 'KA', 'GEO', 'GEO', 'ka-GE', 'Georgian', 'GEL', '+995', '🇬🇪', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_georgia.png', 'Asia/Tbilisi', 'Asia', 0, '1991-04-09', NULL, NULL, '<svg>...</svg>', 'Tbilisi', 41.7151000, 44.8271000, 3714000, 380, 0, '176.221.128.0 - 176.221.255.255', 102, 132),
(82, 'Ghana', 'Ghana', 'English', 'English', 'GH', 'EN', 'GHA', 'ENG', 'en-GH', 'English', 'GHS', '+233', '🇬🇭', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_ghana.png', 'Africa/Accra', 'Africa', 0, '1957-03-06', NULL, NULL, '<svg>...</svg>', 'Accra', 5.6037000, -0.1870000, 31072945, 190, 1, '154.160.0.0 - 154.163.255.255', 112, 47),
(83, 'Greece', 'Ελλάδα', 'Greek', 'Ελληνικά', 'GR', 'EL', 'GRC', 'ELL', 'el-GR', 'Greek', 'EUR', '+30', '🇬🇷', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_greece.png', 'Europe/Athens', 'Europe', 1, '1830-02-03', NULL, NULL, '<svg>...</svg>', 'Athens', 37.9838000, 23.7275000, 10724599, 498, 1, '2.16.0.0 - 2.19.255.255', 29, 84),
(84, 'Grenada', 'Grenada', 'English', 'English', 'GD', 'EN', 'GRD', 'ENG', 'en-GD', 'English', 'XCD', '+1-473', '🇬🇩', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_grenada.png', 'America/Grenada', 'North America', 0, '1974-02-07', NULL, NULL, '<svg>...</svg>', 'St. George\'s', 12.0561000, -61.7486000, 112003, 840, 1, '192.147.208.0 - 192.147.223.255', 191, 203),
(85, 'Guatemala', 'Guatemala', 'Spanish', 'Español', 'GT', 'ES', 'GTM', 'SPA', 'es-GT', 'Spanish', 'GTQ', '+502', '🇬🇹', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_guatemala.png', 'America/Guatemala', 'North America', 0, '1821-09-15', NULL, NULL, '<svg>...</svg>', 'Guatemala City', 14.6349000, -90.5069000, 18503424, 1500, 1, '168.234.0.0 - 168.234.255.255', 105, 67),
(86, 'Guinea', 'Guinée', 'French', 'Français', 'GN', 'FR', 'GIN', 'FRA', 'fr-GN', 'French', 'GNF', '+224', '🇬🇳', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_guinea.png', 'Africa/Conakry', 'Africa', 0, '1958-10-02', NULL, NULL, '<svg>...</svg>', 'Conakry', 9.6412000, -13.5784000, 13630238, 300, 1, '154.142.128.0 - 154.142.159.255', 149, 74),
(87, 'Guinea-Bissau', 'Guiné-Bissau', 'Portuguese', 'Português', 'GW', 'PT', 'GNB', 'POR', 'pt-GW', 'Portuguese', 'XOF', '+245', '🇬🇼', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_guinea_bissau.png', 'Africa/Bissau', 'Africa', 0, '1973-09-24', NULL, NULL, '<svg>...</svg>', 'Bissau', 11.8636000, -15.5977000, 1604528, 39, 1, '197.149.192.0 - 197.149.255.255', 197, 154),
(88, 'Guyana', 'Guyana', 'English', 'English', 'GY', 'EN', 'GUY', 'ENG', 'en-GY', 'English', 'GYD', '+592', '🇬🇾', 'U+1F1EC U+', 'D83C DDEC ', 'https://example.com/flag_of_guyana.png', 'America/Guyana', 'South America', 0, '1966-05-26', NULL, NULL, '<svg>...</svg>', 'Georgetown', 6.8013000, -58.1551000, 794045, 200, 1, '190.80.0.0 - 190.83.255.255', 155, 165),
(89, 'Haiti', 'Haïti', 'French', 'Français', 'HT', 'FR', 'HTI', 'FRA', 'fr-HT', 'French, Haitian Creole', 'HTG', '+509', '🇭🇹', 'U+1F1ED U+', 'D83C DDED ', 'https://example.com/flag_of_haiti.png', 'America/Port-au-Prince', 'North America', 0, '1804-01-01', NULL, NULL, '<svg>...</svg>', 'Port-au-Prince', 18.5944000, -72.3074000, 11577779, 444, 1, '148.102.0.0 - 148.102.255.255', 147, 81),
(90, 'Honduras', 'Honduras', 'Spanish', 'Español', 'HN', 'ES', 'HND', 'SPA', 'es-HN', 'Spanish', 'HNL', '+504', '🇭🇳', 'U+1F1ED U+', 'D83C DDED ', 'https://example.com/flag_of_honduras.png', 'America/Tegucigalpa', 'North America', 0, '1821-09-15', NULL, NULL, '<svg>...</svg>', 'Tegucigalpa', 14.0723000, -87.1921000, 10256399, 500, 1, '181.115.0.0 - 181.115.255.255', 143, 95),
(91, 'Hungary', 'Magyarorsz', 'Hungarian', 'Magyar', 'HU', 'HU', 'HUN', 'HUN', 'hu-HU', 'Hungarian', 'HUF', '+36', '🇭🇺', 'U+1F1ED U+', 'D83C DDED ', 'https://example.com/flag_of_hungary.png', 'Europe/Budapest', 'Europe', 1, '1918-11-16', NULL, NULL, '<svg>...</svg>', 'Budapest', 47.4979000, 19.0402000, 9749763, 143, 1, '62.68.0.0 - 62.75.255.255', 39, 90),
(92, 'Iceland', '', 'Icelandic', '', 'IS', 'IS', 'ISL', 'ICE', 'is-IS', 'Icelandic', 'ISK', '+354', '🇮🇸', 'U+1F1EE U+', 'D83C DDEE ', 'https://example.com/flag_of_iceland.png', 'Atlantic/Reykjavik', 'Europe', 0, '1944-06-17', NULL, NULL, '<svg>...</svg>', 'Reykjavik', 64.1466000, -21.9426000, 376248, 557, 1, '82.221.0.0 - 82.221.255.255', 13, 176),
(107, 'Indonesia', 'Indonesia', 'Indonesian', 'Bahasa Indonesia', 'ID', 'ID', 'IDN', 'IND', 'id-ID', 'Indonesian', 'IDR', '+62', '🇮🇩', 'U+1F1EE U+', 'D83C DDEE ', 'https://example.com/flag_of_indonesia.png', 'Asia/Jakarta', 'Asia', 0, '1945-08-17', NULL, NULL, '<svg>...</svg>', 'Jakarta', -6.2088000, 106.8456000, 273523621, 29, 1, '36.65.0.0 - 36.70.255.255', 106, 4),
(108, 'Iran', 'भारत', 'Persian', 'हिन्दी', 'IR', 'FA', 'IRN', 'PER', 'fa-IR', 'Persian', 'IRR', '+98', '🇮🇷', 'U+1F1EE U+', 'D83C DDEE ', 'https://example.com/flag_of_iran.png', 'Asia/Tehran', 'Asia', 0, '1979-02-11', NULL, NULL, '<svg>...</svg>', 'Tehran', 35.6892000, 51.3890000, 83992953, 1000, 0, '5.52.0.0 - 5.52.255.255', 95, 18),
(109, 'Iraq', 'العراق', 'Arabic', 'العربية', 'IQ', 'AR', 'IRQ', 'ARA', 'ar-IQ', 'Arabic', 'IQD', '+964', '🇮🇶', 'U+1F1EE U+', 'D83C DDEE ', 'https://example.com/flag_of_iraq.png', 'Asia/Baghdad', 'Asia', 0, '1932-10-03', NULL, NULL, '<svg>...</svg>', 'Baghdad', 33.3152000, 44.3661000, 40222503, 312, 1, '37.236.0.0 - 37.236.255.255', 144, 36),
(110, 'Ireland', 'Éire', 'Irish', 'Gaeilge', 'IE', 'GA', 'IRL', 'GLE', 'ga-IE', 'Irish, English', 'EUR', '+353', '🇮🇪', 'U+1F1EE U+', 'D83C DDEE ', 'https://example.com/flag_of_ireland.png', 'Europe/Dublin', 'Europe', 1, '1922-12-06', NULL, NULL, '<svg>...</svg>', 'Dublin', 53.3498000, -6.2603000, 4977400, 118, 1, '5.8.0.0 - 5.11.255.255', 5, 122),
(111, 'Israel', 'יִשְׂרָאֵל\'', 'Hebrew', 'עברית\'', 'IL', 'HE', 'ISR', 'HEB', 'he-IL', 'Hebrew, Arabic', 'ILS', '+972', '🇮🇱', 'U+1F1EE U+', 'D83C DDEE ', 'https://example.com/flag_of_israel.png', 'Asia/Jerusalem', 'Asia', 0, '1948-05-14', NULL, NULL, '<svg>...</svg>', 'Jerusalem', 31.7683000, 35.2137000, 9216900, 760, 1, '2.53.0.0 - 2.55.255.255', 29, 99),
(113, 'Jamaica', 'Jamaica', 'English', 'English', 'JM', 'EN', 'JAM', 'ENG', 'en-JM', 'English', 'JMD', '+1-876', '🇯🇲', 'U+1F1EF U+', 'D83C DDEF ', 'https://example.com/flag_of_jamaica.png', 'America/Jamaica', 'North America', 0, '1962-08-06', NULL, NULL, '<svg>...</svg>', 'Kingston', 17.9712000, -76.7936000, 2961167, 18, 1, '74.114.0.0 - 74.115.255.255', 100, 136),
(115, 'Jordan', 'الأردن', 'Arabic', 'العربية', 'JO', 'AR', 'JOR', 'ARA', 'ar-JO', 'Arabic', 'JOD', '+962', '🇯🇴', 'U+1F1EF U+', 'D83C DDEF ', 'https://example.com/flag_of_jordan.png', 'Asia/Amman', 'Asia', 0, '1946-05-25', NULL, NULL, '<svg>...</svg>', 'Amman', 31.9454000, 35.9284000, 10355000, 850, 0, '176.28.0.0 - 176.31.255.255', 90, 88),
(116, 'Kazakhstan', 'Қазақстан', 'Kazakh', 'Қазақша', 'KZ', 'KK', 'KAZ', 'KAZ', 'kk-KZ', 'Kazakh, Russian', 'KZT', '+7', '🇰🇿', 'U+1F1F0 U+', 'D83C DDF0 ', 'https://example.com/flag_of_kazakhstan.png', 'Asia/Almaty', 'Asia', 0, '1991-12-16', NULL, NULL, '<svg>...</svg>', 'Nur-Sultan', 51.1694000, 71.4491000, 18816232, 320, 1, '2.72.0.0 - 2.75.255.255', 75, 63),
(117, 'Kenya', 'Kenya', 'English', 'English', 'KE', 'EN', 'KEN', 'ENG', 'en-KE', 'English, Swahili', 'KES', '+254', '🇰🇪', 'U+1F1F0 U+', 'D83C DDF0 ', 'https://example.com/flag_of_kenya.png', 'Africa/Nairobi', 'Africa', 0, '1963-12-12', NULL, NULL, '<svg>...</svg>', 'Nairobi', -1.2921000, 36.8219000, 53771300, 762, 1, '41.57.0.0 - 41.57.255.255', 144, 29),
(118, 'Kuwait', 'الكويت', 'Arabic', 'العربية', 'KW', 'AR', 'KWT', 'ARA', 'ar-KW', 'Arabic', 'KWD', '+965', '🇰🇼', 'U+1F1F0 U+', 'D83C DDF0 ', 'https://example.com/flag_of_kuwait.png', 'Asia/Kuwait', 'Asia', 0, '1961-06-19', NULL, NULL, '<svg>...</svg>', 'Kuwait City', 29.3759000, 47.9774000, 4270563, 30, 1, '62.150.0.0 - 62.150.255.255', 18, 134),
(119, 'Kyrgyzstan', 'Кыргызстан', 'Kyrgyz', 'Kyrgyz', 'KG', 'KY', 'KGZ', 'KYR', 'ky-KG', 'Kyrgyz, Russian', 'KGS', '+996', '🇰🇬', 'U+1F1F0 U+', 'D83C DDF0 ', 'https://example.com/flag_of_kyrgyzstan.png', 'Asia/Bishkek', 'Asia', 0, '1991-08-31', NULL, NULL, '<svg>...</svg>', 'Bishkek', 42.8746000, 74.5698000, 6591600, 275, 0, '212.42.96.0 - 212.42.127.255', 138, 111),
(120, 'Laos', 'ປະເທດລາວ', 'Lao', 'ລາວ', 'LA', 'LO', 'LAO', 'LAO', 'lo-LA', 'Lao', 'LAK', '+856', '🇱🇦', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_laos.png', 'Asia/Vientiane', 'Asia', 0, '1949-10-22', NULL, NULL, '<svg>...</svg>', 'Vientiane', 17.9757000, 102.6331000, 7275556, 281, 0, '202.62.64.0 - 202.62.79.255', 157, 105),
(121, 'Latvia', 'Latvija', 'Latvian', 'Latviešu', 'LV', 'LV', 'LVA', 'LAV', 'lv-LV', 'Latvian', 'EUR', '+371', '🇱🇻', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_latvia.png', 'Europe/Riga', 'Europe', 1, '1918-11-18', NULL, NULL, '<svg>...</svg>', 'Riga', 56.9496000, 24.1052000, 1860000, 87, 1, '213.175.64.0 - 213.175.127.255', 37, 149),
(122, 'Lebanon', 'لبنان', 'Arabic', 'العربية', 'LB', 'AR', 'LBN', 'ARA', 'ar-LB', 'Arabic, French', 'LBP', '+961', '🇱🇧', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_lebanon.png', 'Asia/Beirut', 'Asia', 0, '1943-11-22', NULL, NULL, '<svg>...</svg>', 'Beirut', 33.8938000, 35.5018000, 6825445, 870, 1, '93.185.64.0 - 93.185.127.255', 86, 107),
(123, 'Lesotho', 'Lesotho', 'Sotho', 'Sesotho', 'LS', 'ST', 'LSO', 'SOT', 'st-LS', 'English, Sesotho', 'LSL', '+266', '🇱🇸', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_lesotho.png', 'Africa/Maseru', 'Africa', 0, '1966-10-04', NULL, NULL, '<svg>...</svg>', 'Maseru', -29.3155000, 27.4844000, 2142249, 2200, 0, '41.223.32.0 - 41.223.47.255', 142, 147),
(124, 'Liberia', 'Liberia', 'English', 'English', 'LR', 'EN', 'LBR', 'ENG', 'en-LR', 'English', 'LRD', '+231', '🇱🇷', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_liberia.png', 'Africa/Monrovia', 'Africa', 0, '1847-07-26', NULL, NULL, '<svg>...</svg>', 'Monrovia', 6.3008000, -10.7977000, 5253910, 243, 1, '41.57.224.0 - 41.57.239.255', 151, 123),
(125, 'Libya', 'ليبيا', 'Arabic', 'العربية', 'LY', 'AR', 'LBY', 'ARA', 'ar-LY', 'Arabic', 'LYD', '+218', '🇱🇾', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_libya.png', 'Africa/Tripoli', 'Africa', 0, '1951-12-24', NULL, NULL, '<svg>...</svg>', 'Tripoli', 32.8872000, 13.1913000, 6871287, 400, 1, '41.254.64.0 - 41.254.127.255', 100, 105),
(126, 'Liechtenstein', 'Liechtenstein', 'German', 'Deutsch', 'LI', 'DE', 'LIE', 'GER', 'de-LI', 'German', 'CHF', '+423', '🇱🇮', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_liechtenstein.png', 'Europe/Vaduz', 'Europe', 0, '1719-01-23', NULL, NULL, '<svg>...</svg>', 'Vaduz', 47.1416000, 9.5215000, 39296, 450, 0, '82.117.0.0 - 82.117.255.255', 2, 213),
(127, 'Lithuania', 'Lietuva', 'Lithuanian', 'Lietuvių', 'LT', 'LT', 'LTU', 'LIT', 'lt-LT', 'Lithuanian', 'EUR', '+370', '🇱🇹', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_lithuania.png', 'Europe/Vilnius', 'Europe', 1, '1918-02-16', NULL, NULL, '<svg>...</svg>', 'Vilnius', 54.6872000, 25.2797000, 2794700, 160, 1, '82.135.128.0 - 82.135.159.255', 34, 139),
(128, 'Luxembourg', 'Lëtzebuerg', 'Luxembourgish', 'Lëtzebuergesch', 'LU', 'LU', 'LUX', 'LUX', 'lb-LU', 'Luxembourgish, French, German', 'EUR', '+352', '🇱🇺', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_luxembourg.png', 'Europe/Luxembourg', 'Europe', 1, '1815-03-15', NULL, NULL, '<svg>...</svg>', 'Luxembourg City', 49.6117000, 6.1319000, 634730, 200, 0, '212.47.192.0 - 212.47.255.255', 1, 170),
(129, 'Madagascar', 'Madagasikara', 'Malagasy', 'Malagasy', 'MG', 'MG', 'MDG', 'MLG', 'mg-MG', 'Malagasy, French', 'MGA', '+261', '🇲🇬', 'U+1F1F2 U+', 'D83C DDF2 ', 'https://example.com/flag_of_madagascar.png', 'Indian/Antananarivo', 'Africa', 0, '1960-06-26', NULL, NULL, '<svg>...</svg>', 'Antananarivo', -18.8792000, 47.5079000, 26262368, 614, 1, '41.188.32.0 - 41.188.63.255', 135, 52),
(130, 'Malawi', 'Malawi', 'Chichewa', 'Chichewa', 'MW', 'CH', 'MWI', 'CHI', 'ch-MW', 'Chichewa, English', 'MWK', '+265', '🇲🇼', 'U+1F1F2 U+', 'D83C DDF2 ', 'https://example.com/flag_of_malawi.png', 'Africa/Blantyre', 'Africa', 0, '1964-07-06', NULL, NULL, '<svg>...</svg>', 'Lilongwe', -13.9833000, 33.7833000, 19129952, 800, 1, '102.68.64.0 - 102.68.95.255', 159, 59),
(137, 'Cape Verde', 'Cabo Verde', 'Portuguese', 'Português', 'CV', 'PT', 'CPV', 'POR', 'pt-CV', 'Portuguese', 'CVE', '+238', '🇨🇻', 'U+1F1E8 U+', 'D83C DDE8 ', 'https://example.com/flag_of_cape_verde.png', 'Atlantic/Cape_Verde', 'Africa', 0, '1975-07-05', NULL, NULL, '<svg>...</svg>', 'Praia', 14.9331000, -23.5133000, 555987, 282, 1, '197.157.96.0 - 197.157.111.255', 97, 169),
(142, 'Kiribati', 'Kiribati', 'English', 'English', 'KI', 'EN', 'KIR', 'ENG', 'en-KI', 'English', 'AUD', '+686', '🇰🇮', 'U+1F1F0 U+', 'D83C DDF0 ', 'https://example.com/flag_of_kiribati.png', 'Pacific/Tarawa', 'Oceania', 0, '1979-07-12', NULL, NULL, '<svg>...</svg>', 'South Tarawa', 1.3278000, 172.9780000, 119446, 2, 1, '202.6.128.0 - 202.6.159.255', 160, 201),
(143, 'Maldives', 'Dhivehi Raajje', 'Dhivehi', 'ދިވެހި', 'MV', 'DV', 'MDV', 'DIV', 'dv-MV', 'Dhivehi', 'MVR', '+960', '🇲🇻', 'U+1F1F2 U+', 'D83C DDF2 ', 'https://example.com/flag_of_maldives.png', 'Indian/Maldives', 'Asia', 0, '1965-07-26', NULL, NULL, '<svg>...</svg>', 'Malé', 4.1755000, 73.5093000, 540542, 1, 1, '202.21.224.0 - 202.21.255.255', 49, 171),
(144, 'Malta', 'Malta', 'Maltese', 'Malti', 'MT', 'MT', 'MLT', 'MLT', 'mt-MT', 'Maltese, English', 'EUR', '+356', '🇲🇹', 'U+1F1F2 U+', 'D83C DDF2 ', 'https://example.com/flag_of_malta.png', 'Europe/Malta', 'Europe', 1, '1964-09-21', NULL, NULL, '<svg>...</svg>', 'Valletta', 35.8997000, 14.5146000, 514564, 150, 1, '217.30.192.0 - 217.30.255.255', 28, 175),
(145, 'Marshall Islands', 'Aelōn̄ in M̧ajeļ', 'Marshallese', 'Kajin M̧ajeļ', 'MH', 'MH', 'MHL', 'MH', 'mh-MH', 'Marshallese, English', 'USD', '+692', '🇲🇭', 'U+1F1F2 U+', 'D83C DDF2 ', 'https://example.com/flag_of_marshall_islands.png', 'Pacific/Majuro', 'Oceania', 0, '1986-10-21', NULL, NULL, '<svg>...</svg>', 'Majuro', 7.1167000, 171.3667000, 59190, 3, 1, '119.252.128.0 - 119.252.255.255', 184, 208),
(146, 'Mauritius', 'Moris', 'English', 'English', 'MU', 'EN', 'MUS', 'ENG', 'en-MU', 'English', 'MUR', '+230', '🇲🇺', 'U+1F1F2 U+', 'D83C DDF2 ', 'https://example.com/flag_of_mauritius.png', 'Indian/Mauritius', 'Africa', 0, '1968-03-12', NULL, NULL, '<svg>...</svg>', 'Port Louis', -20.1609000, 57.5012000, 1265740, 500, 1, '102.63.0.0 - 102.63.63.255', 51, 160),
(147, 'Micronesia', 'Micronesia', 'English', 'English', 'FM', 'EN', 'FSM', 'ENG', 'en-FM', 'English', 'USD', '+691', '🇫🇲', 'U+1F1EB U+', 'D83C DDEB ', 'https://example.com/flag_of_micronesia.png', 'Pacific/Pohnpei', 'Oceania', 0, '1986-11-03', NULL, NULL, '<svg>...</svg>', 'Palikir', 6.9248000, 158.1617000, 115021, 7, 1, '119.252.64.0 - 119.252.127.255', 185, 198),
(148, 'Monaco', 'Monaco', 'French', 'Français', 'MC', 'FR', 'MCO', 'FRA', 'fr-MC', 'French', 'EUR', '+377', '🇲🇨', 'U+1F1F2 U+', 'D83C DDF2 ', 'https://example.com/flag_of_monaco.png', 'Europe/Monaco', 'Europe', 1, '1297-01-08', NULL, NULL, '<svg>...</svg>', 'Monaco', 43.7333000, 7.4167000, 39244, 0, 1, '212.129.0.0 - 212.129.127.255', 8, 210),
(149, 'Nauru', 'Naoero', 'Nauruan', 'Dorerin Naoero', 'NR', 'NA', 'NRU', 'NAU', 'na-NR', 'Nauruan, English', 'AUD', '+674', '🇳🇷', 'U+1F1F3 U+', 'D83C DDF3 ', 'https://example.com/flag_of_nauru.png', 'Pacific/Nauru', 'Oceania', 0, '1968-01-31', NULL, NULL, '<svg>...</svg>', 'Yaren', -0.5477000, 166.9209000, 10834, 61, 1, '203.98.224.0 - 203.98.239.255', 161, 213),
(150, 'Palau', 'Beluu er a Belau', 'Palauan', 'a tekoi ra Belau', 'PW', 'PL', 'PLW', 'PLW', 'pl-PW', 'Palauan, English', 'USD', '+680', '🇵🇼', 'U+1F1F5 U+', 'D83C DDF5 ', 'https://example.com/flag_of_palau.png', 'Pacific/Palau', 'Oceania', 0, '1994-10-01', NULL, NULL, '<svg>...</svg>', 'Ngerulmud', 7.5000000, 134.6242000, 18094, 242, 1, '202.124.224.0 - 202.124.255.255', 183, 209),
(151, 'Papua New Guinea', 'Papua Niugini', 'Tok Pisin', 'Tok Pisin', 'PG', 'TP', 'PNG', 'TPI', 'tp-PG', 'Tok Pisin, English', 'PGK', '+675', '🇵🇬', 'U+1F1F5 U+', 'D83C DDF5 ', 'https://example.com/flag_of_papua_new_guinea.png', 'Pacific/Port_Moresby', 'Oceania', 0, '1975-09-16', NULL, NULL, '<svg>...</svg>', 'Port Moresby', -9.4438000, 147.1803000, 8935000, 1600, 1, '202.5.128.0 - 202.5.159.255', 143, 98),
(152, 'Samoa', 'Samoa', 'Samoan', 'Gagana Samoa', 'WS', 'WS', 'WSM', 'SMO', 'sm-WS', 'Samoan, English', 'WST', '+685', '🇼🇸', 'U+1F1FC U+', 'D83C DDFC ', 'https://example.com/flag_of_samoa.png', 'Pacific/Apia', 'Oceania', 0, '1962-01-01', NULL, NULL, '<svg>...</svg>', 'Apia', -13.8333000, -171.7667000, 198410, 2, 1, '202.65.32.0 - 202.65.63.255', 155, 199),
(153, 'San Marino', 'San Marino', 'Italian', 'Italiano', 'SM', 'IT', 'SMR', 'ITA', 'it-SM', 'Italian', 'EUR', '+378', '🇸🇲', 'U+1F1F8 U+', 'D83C DDF8 ', 'https://example.com/flag_of_san_marino.png', 'Europe/San_Marino', 'Europe', 1, '0301-09-03', NULL, NULL, '<svg>...</svg>', 'San Marino', 43.9333000, 12.4500000, 33600, 755, 0, '185.53.128.0 - 185.53.159.255', 6, 211),
(154, 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 'English', 'English', 'KN', 'EN', 'KNA', 'ENG', 'en-KN', 'English', 'XCD', '+1-869', '🇰🇳', 'U+1F1F0 U+', 'D83C DDF0 ', 'https://example.com/flag_of_saint_kitts_and_nevis.png', 'America/St_Kitts', 'North America', 0, '1983-09-19', NULL, NULL, '<svg>...</svg>', 'Basseterre', 17.3000000, -62.7167000, 52823, 15, 1, '198.48.0.0 - 198.48.31.255', 144, 202),
(155, 'Saint Lucia', 'Saint Lucia', 'English', 'English', 'LC', 'EN', 'LCA', 'ENG', 'en-LC', 'English', 'XCD', '+1-758', '🇱🇨', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_saint_lucia.png', 'America/St_Lucia', 'North America', 0, '1979-02-22', NULL, NULL, '<svg>...</svg>', 'Castries', 14.0100000, -60.9875000, 179857, 15, 1, '216.10.240.0 - 216.10.255.255', 169, 204),
(156, 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'English', 'English', 'VC', 'EN', 'VCT', 'ENG', 'en-VC', 'English', 'XCD', '+1-784', '🇻🇨', 'U+1F1FB U+', 'D83C DDFB ', 'https://example.com/flag_of_saint_vincent.png', 'America/St_Vincent', 'North America', 0, '1979-10-27', NULL, NULL, '<svg>...</svg>', 'Kingstown', 13.1578000, -61.2270000, 110000, 10, 1, '209.94.192.0 - 209.94.207.255', 173, 207),
(157, 'Seychelles', 'Seychelles', 'French', 'Français', 'SC', 'FR', 'SYC', 'FRA', 'fr-SC', 'French, English', 'SCR', '+248', '🇸🇨', 'U+1F1F8 U+', 'D83C DDF8 ', 'https://example.com/flag_of_seychelles.png', 'Indian/Mahe', 'Africa', 0, '1976-06-29', NULL, NULL, '<svg>...</svg>', 'Victoria', -4.6167000, 55.4500000, 107650, 90, 1, '196.13.160.0 - 196.13.191.255', 108, 205),
(158, 'Solomon Islands', 'Solomon Islands', 'English', 'English', 'SB', 'EN', 'SLB', 'ENG', 'en-SB', 'English', 'SBD', '+677', '🇸🇧', 'U+1F1F8 U+', 'D83C DDF8 ', 'https://example.com/flag_of_solomon_islands.png', 'Pacific/Guadalcanal', 'Oceania', 0, '1978-07-07', NULL, NULL, '<svg>...</svg>', 'Honiara', -9.4333000, 159.9500000, 652858, 30, 1, '202.1.64.0 - 202.1.95.255', 176, 153),
(159, 'Suriname', 'Suriname', 'Dutch', 'Nederlands', 'SR', 'NL', 'SUR', 'NLD', 'nl-SR', 'Dutch', 'SRD', '+597', '🇸🇷', 'U+1F1F8 U+', 'D83C DDF8 ', 'https://example.com/flag_of_suriname.png', 'America/Paramaribo', 'South America', 0, '1975-11-25', NULL, NULL, '<svg>...</svg>', 'Paramaribo', 5.8667000, -55.1667000, 618040, 10, 1, '200.9.96.0 - 200.9.127.255', 100, 152),
(160, 'Tonga', 'Tonga', 'Tongan', 'Lea Faka-Tonga', 'TO', 'TO', 'TON', 'TON', 'to-TO', 'Tongan, English', 'TOP', '+676', '🇹🇴', 'U+1F1F9 U+', 'D83C DDF9 ', 'https://example.com/flag_of_tonga.png', 'Pacific/Tongatapu', 'Oceania', 0, '1970-06-04', NULL, NULL, '<svg>...</svg>', 'Nuku\'alofa', -21.1333000, -175.2000000, 100651, 2, 1, '202.128.96.0 - 202.128.127.255', 190, 206),
(161, 'Tuvalu', 'Tuvalu', 'Tuvaluan', 'Te Ggana Tuuvalu', 'TV', 'TV', 'TUV', 'TVL', 'tv-TU', 'Tuvaluan, English', 'AUD', '+688', '🇹🇻', 'U+1F1F9 U+', 'D83C DDF9 ', 'https://example.com/flag_of_tuvalu.png', 'Pacific/Funafuti', 'Oceania', 0, '1978-10-01', NULL, NULL, '<svg>...</svg>', 'Funafuti', -8.5167000, 179.2167000, 11646, 2, 1, '202.11.192.0 - 202.11.223.255', 186, 214),
(162, 'Vanuatu', 'Vanuatu', 'Bislama', 'Bislama', 'VU', 'BI', 'VUT', 'BIS', 'bi-VU', 'Bislama, English', 'VUV', '+678', '🇻🇺', 'U+1F1FB U+', 'D83C DDFB ', 'https://example.com/flag_of_vanuatu.png', 'Pacific/Efate', 'Oceania', 0, '1980-07-30', NULL, NULL, '<svg>...</svg>', 'Port Vila', -17.7333000, 168.3167000, 307815, 10, 1, '202.80.32.0 - 202.80.63.255', 158, 181),
(175, 'Timor-Leste', 'Timor-Leste', 'Portuguese', 'Português', 'TL', 'PT', 'TLS', 'POR', 'pt-TL', 'Portuguese, Tetum', 'USD', '+670', '🇹🇱', 'U+1F1F9 U+', 'D83C DDF9 ', 'https://example.com/flag_of_timor_leste.png', 'Asia/Dili', 'Asia', 0, '2002-05-20', NULL, NULL, '<svg>...</svg>', 'Dili', -8.5586000, 125.5736000, 1387149, 50, 1, '202.147.160.0 - 202.147.191.255', 143, 149),
(176, 'Sao Tome and Principe', 'São Tomé e Príncipe', 'Portuguese', 'Português', 'ST', 'PT', 'STP', 'POR', 'pt-ST', 'Portuguese', 'STD', '+239', '🇸🇹', 'U+1F1F8 U+', 'D83C DDF8 ', 'https://example.com/flag_of_sao_tome.png', 'Africa/Sao_Tome', 'Africa', 0, '1975-07-12', NULL, NULL, '<svg>...</svg>', 'São Tomé', 0.3333000, 6.7333000, 223364, 300, 1, '197.242.128.0 - 197.242.159.255', 195, 206),
(177, 'Afghanistan', 'افغانستان', 'English', 'Pashto', 'AF', 'ps', 'AF', 'ps', 'af-ps', 'Pashto, Dari', 'AFN', '+93', '🇦🇫', 'U+1F1E6 U+', 'E1 94 AF', 'af_flag.png', 'UTC+4:30', 'Asia', 0, '1747-08-19', NULL, NULL, 'path_to_svg', 'Kabul', 34.5553000, 69.2075000, 30419928, 1880, 0, 'Afghanistan IP Range', 172, 40),
(178, 'Albania', 'Shqipëria', 'English', 'Albanian', 'AL', 'sq', 'AL', 'sq', 'al-sq', 'Albanian', 'ALL', '+355', '🇦🇱', 'U+1F1E6 U+', 'E1 94 B1', 'al_flag.png', 'UTC+1', 'Europe', 0, '1912-11-28', NULL, NULL, 'path_to_svg', 'Tirana', 41.3275000, 19.8189000, 3195000, 708, 0, 'Albania IP Range', 113, 136),
(179, 'Algeria', 'الجزائر', 'English', 'Arabic', 'DZ', 'ar', 'DZ', 'ar', 'dz-ar', 'Arabic, Berber', 'DZD', '+213', '🇩🇿', 'U+1F1E9 U+', 'E1 94 BF', 'dz_flag.png', 'UTC+1', 'Africa', 0, '1962-07-05', NULL, NULL, 'path_to_svg', 'Algiers', 36.7372000, 3.0869000, 34178188, 800, 0, 'Algeria IP Range', 56, 34);
INSERT INTO `countries` (`id`, `country_name_english`, `country_name_local`, `language_english`, `language_local`, `country_code`, `language_code`, `iso_country_code`, `iso_language_code`, `web_country_language`, `official_languages`, `currency`, `calling_code`, `iso_flag`, `unicode_flag`, `utf8_flag`, `flag_image_url`, `timezone`, `continent`, `in_eu`, `country_foundation_date`, `reappearance_dates`, `removal_dates`, `svg_country_shape`, `capital`, `latitude`, `longitude`, `population`, `average_elevation`, `has_ocean_access`, `ip_range`, `income_rank`, `population_rank`) VALUES
(180, 'Andorra', 'Andorra', 'English', 'Catalan', 'AD', 'ca', 'AD', 'ca', 'ad-ca', 'Catalan', 'EUR', '+376', '🇦🇩', 'U+1F1E6 U+', 'E1 94 A9', 'ad_flag.png', 'UTC+1', 'Europe', 0, '1278-09-08', NULL, NULL, 'path_to_svg', 'Andorra', 42.5078000, 1.5211000, 84525, 1996, 0, 'Andorra IP Range', 130, 191),
(181, 'Angola', 'Angola', 'English', 'Portuguese', 'AO', 'pt', 'AO', 'pt', 'ao-pt', 'Portuguese', 'AOA', '+244', '🇦🇴', 'U+1F1E6 U+', 'E1 94 B4', 'ao_flag.png', 'UTC+1', 'Africa', 0, '1975-11-11', NULL, NULL, 'path_to_svg', 'Luanda', -8.8383000, 13.2344000, 17312000, 1200, 0, 'Angola IP Range', 126, 70),
(182, 'Antigua and Barbuda', 'Antigua i Barbuda', 'English', 'English', 'AG', 'en', 'AG', 'en', 'ag-en', 'English', 'XCD', '+1-268', '🇦🇬', 'U+1F1E6 U+', 'E1 94 AC', 'ag_flag.png', 'UTC-4', 'North America', 0, NULL, NULL, NULL, 'path_to_svg', 'Saint John’s', 17.1274000, -61.8468000, 85420, 0, 1, 'Antigua IP Range', NULL, 196),
(183, 'Saudi Arabia', 'المملكة العربية السعودية', 'Arabic', 'Arabic', 'SA', 'ar', 'SA', 'ar', 'sa-ar', 'Arabic', 'SAR', '+966', '🇸🇦', 'U+1F1F8 U+', 'E1 94 A6', 'sa_flag.png', 'UTC+3', 'Asia', 0, '1932-09-23', NULL, NULL, 'path_to_svg', 'Riyadh', 24.7136000, 46.6753000, 28686633, 0, 0, 'Saudi Arabia IP Range', 18, 45),
(184, 'Argentina', 'Argentina', 'Spanish', 'Español', 'AR', 'es', 'AR', 'es', 'ar-es', 'Spanish', 'ARS', '+54', '🇦🇷', 'U+1F1E6 U+', 'E1 94 B7', 'ar_flag.png', 'UTC-3', 'South America', 0, '1816-07-09', NULL, NULL, 'path_to_svg', 'Buenos Aires', -34.6037000, -58.3816000, 40913584, 595, 1, 'Argentina IP Range', 25, 31),
(185, 'Armenia', 'Հայաստան', 'Armenian', 'Հայերեն', 'AM', 'hy', 'AM', 'hy', 'am-hy', 'Armenian', 'AMD', '+374', '🇦🇲', 'U+1F1E6 U+', 'E1 94 B2', 'am_flag.png', 'UTC+4', 'Asia', 0, '1991-09-21', NULL, NULL, 'path_to_svg', 'Yerevan', 40.1792000, 44.4991000, 3259100, 0, 0, 'Armenia IP Range', 93, 138),
(186, 'Australia', 'Australia', 'English', 'English', 'AU', 'en', 'AU', 'en', 'au-en', 'English', 'AUD', '+61', '🇦🇺', 'U+1F1E6 U+', 'E1 94 FA', 'au_flag.png', 'UTC+10', 'Oceania', 0, '1901-01-01', NULL, NULL, 'path_to_svg', 'Canberra', -35.2809000, 149.1300000, 22343203, 330, 1, 'Australia IP Range', 13, 53),
(187, 'Austria', 'Österreich', 'German', 'Deutsch', 'AT', 'de', 'AT', 'de', 'at-de', 'German', 'EUR', '+43', '🇦🇹', 'U+1F1E6 U+', 'E1 94 F9', 'at_flag.png', 'UTC+1', 'Europe', 1, '1918-11-12', NULL, NULL, 'path_to_svg', 'Vienna', 48.2082000, 16.3738000, 8402549, 0, 0, 'Austria IP Range', 21, 99),
(188, 'Azerbaijan', 'Azərbaycan', 'Azerbaijani', 'Azərbaycan dili', 'AZ', 'az', 'AZ', 'az', 'az-az', 'Azerbaijani', 'AZN', '+994', '🇦🇿', 'U+1F1E6 U+', 'E1 94 FF', 'az_flag.png', 'UTC+4', 'Asia', 0, '1991-10-18', NULL, NULL, 'path_to_svg', 'Baku', 40.4093000, 49.8671000, 9493600, 0, 0, 'Azerbaijan IP Range', 76, 91),
(189, 'Bahamas', 'Bahamas', 'English', 'English', 'BS', 'en', 'BS', 'en', 'bs-en', 'English', 'BSD', '+1-242', '🇧🇸', 'U+1F1E7 U+', 'E1 94 F8', 'bs_flag.png', 'UTC-5', 'North America', 0, '1973-07-10', NULL, NULL, 'path_to_svg', 'Nassau', 25.0343000, -77.3963000, 307451, 0, 1, 'Bahamas IP Range', 142, 187),
(190, 'Bahrain', 'البحرين', 'Arabic', 'العربية', 'BH', 'ar', 'BH', 'ar', 'bh-ar', 'Arabic', 'BHD', '+973', '🇧🇭', 'U+1F1E7 U+', 'E1 94 ED', 'bh_flag.png', 'UTC+3', 'Asia', 0, '1971-12-16', NULL, NULL, 'path_to_svg', 'Manama', 26.2235000, 50.5876000, 1323535, 0, 0, 'Bahrain IP Range', 61, 137),
(191, 'Bangladesh', 'বাংলাদেশ', 'Bengali', 'বাংলা', 'BD', 'bn', 'BD', 'bn', 'bd-bn', 'Bengali', 'BDT', '+880', '🇧🇩', 'U+1F1E7 U+', 'E1 94 E9', 'bd_flag.png', 'UTC+6', 'Asia', 0, '1971-12-16', NULL, NULL, 'path_to_svg', 'Dhaka', 23.8103000, 90.4125000, 162221000, 0, 0, 'Bangladesh IP Range', 151, 8),
(192, 'Barbados', 'Barbados', 'English', 'English', 'BB', 'en', 'BB', 'en', 'bb-en', 'English', 'BBD', '+1-246', '🇧🇧', 'U+1F1E7 U+', 'E1 94 E7', 'bb_flag.png', 'UTC-4', 'North America', 0, '1966-11-30', NULL, NULL, 'path_to_svg', 'Bridgetown', 13.1939000, -59.5432000, 281968, 0, 1, 'Barbados IP Range', 123, 147),
(193, 'Belgium', 'België', 'Dutch', 'Nederlands', 'BE', 'nl', 'BE', 'nl', 'be-nl', 'Dutch, French, German', 'EUR', '+32', '🇧🇪', 'U+1F1E7 U+', 'E1 94 EA', 'be_flag.png', 'UTC+1', 'Europe', 1, '1830-10-04', NULL, NULL, 'path_to_svg', 'Brussels', 50.8503000, 4.3517000, 10584534, 0, 1, 'Belgium IP Range', 26, 10),
(194, 'Belize', 'Belize', 'English', 'English', 'BZ', 'en', 'BZ', 'en', 'bz-en', 'English', 'BZD', '+501', '🇧🇿', 'U+1F1E7 U+', 'E1 94 FF', 'bz_flag.png', 'UTC-6', 'North America', 0, '1981-09-21', NULL, NULL, 'path_to_svg', 'Belmopan', 17.2514000, -88.7667000, 266440, 0, 1, 'Belize IP Range', 135, 101),
(195, 'Benin', 'Bénin', 'French', 'Français', 'BJ', 'fr', 'BJ', 'fr', 'bj-fr', 'French', 'XOF', '+229', '🇧🇯', 'U+1F1E7 U+', 'E1 94 EF', 'bj_flag.png', 'UTC+1', 'Africa', 0, '1960-08-01', NULL, NULL, 'path_to_svg', 'Porto-Novo', 6.4969000, 2.6289000, 8295000, 0, 0, 'Benin IP Range', 163, 132),
(196, 'Bhutan', 'འབྲུག་ཡུལ', 'Dzongkha', 'རྫོང་ཁ', 'BT', 'dz', 'BT', 'dz', 'bt-dz', 'Dzongkha', 'BTN', '+975', '🇧🇹', 'U+1F1E7 U+', 'E1 94 F9', 'bt_flag.png', 'UTC+6', 'Asia', 0, '1907-12-17', NULL, NULL, 'path_to_svg', 'Thimphu', 27.4728000, 89.6393000, 682321, 0, 0, 'Bhutan IP Range', 175, 149),
(197, 'Belarus', 'Беларусь', 'Belarusian', 'беларуская', 'BY', 'be', 'BY', 'be', 'by-be', 'Belarusian', 'BYN', '+375', '🇧🇾', 'U+1F1E7 U+', 'E1 94 FE', 'by_flag.png', 'UTC+3', 'Europe', 0, '1991-08-25', NULL, NULL, 'path_to_svg', 'Minsk', 53.9006000, 27.5590000, 9474200, 0, 0, 'Belarus IP Range', 118, 91),
(198, 'Bolivia', 'Bolivia', 'Spanish', 'Español', 'BO', 'es', 'BO', 'es', 'bo-es', 'Spanish', 'BOB', '+591', '🇧🇴', 'U+1F1E7 U+', 'E1 94 F4', 'bo_flag.png', 'UTC-4', 'South America', 0, '1825-08-06', NULL, NULL, 'path_to_svg', 'Sucre, La Paz', -19.0196000, -65.2619000, 9248000, 0, 0, 'Bolivia IP Range', 164, 109),
(199, 'Bosnia and Herzegovina', 'Bosna i Hercegovina', 'Bosnian', 'bosanski', 'BA', 'bs', 'BA', 'bs', 'ba-bs', 'Bosnian, Serbian, Croatian', 'BAM', '+387', '🇧🇦', 'U+1F1E7 U+', 'E1 94 E6', 'ba_flag.png', 'UTC+1', 'Europe', 0, '1992-03-01', NULL, NULL, 'path_to_svg', 'Sarajevo', 43.8563000, 18.4131000, 4590310, 0, 0, 'Bosnia IP Range', 167, 132),
(200, 'Botswana', 'Botswana', 'English', 'English', 'BW', 'en', 'BW', 'en', 'bw-en', 'English', 'BWP', '+267', '🇧🇼', 'U+1F1E7 U+', 'E1 94 FC', 'bw_flag.png', 'UTC+2', 'Africa', 0, '1966-09-30', NULL, NULL, 'path_to_svg', 'Gaborone', -24.6282000, 25.9231000, 1842000, 0, 0, 'Botswana IP Range', 143, 61),
(201, 'Brazil', 'Brasil', 'Portuguese', 'Português', 'BR', 'pt', 'BR', 'pt', 'br-pt', 'Portuguese', 'BRL', '+55', '🇧🇷', 'U+1F1E7 U+', 'E1 94 F7', 'br_flag.png', 'UTC-3', 'South America', 0, '1822-09-07', NULL, NULL, 'path_to_svg', 'Brasília', -15.7801000, -47.9292000, 201103330, 0, 1, 'Brazil IP Range', 9, 5),
(202, 'Brunei', 'Brunei Darussalam', 'Malay', 'Bahasa Melayu', 'BN', 'ms', 'BN', 'ms', 'bn-ms', 'Malay', 'BND', '+673', '🇧🇳', 'U+1F1E7 U+', 'E1 94 F3', 'bn_flag.png', 'UTC+8', 'Asia', 0, '1984-01-01', NULL, NULL, 'path_to_svg', 'Bandar Seri Begawan', 4.9031000, 114.9398000, 381371, 0, 0, 'Brunei IP Range', 78, 92),
(203, 'Bulgaria', 'България', 'Bulgarian', 'български', 'BG', 'bg', 'BG', 'bg', 'bg-bg', 'Bulgarian', 'BGN', '+359', '🇧🇬', 'U+1F1E7 U+', 'E1 94 EC', 'bg_flag.png', 'UTC+2', 'Europe', 0, '1908-09-22', NULL, NULL, 'path_to_svg', 'Sofia', 42.6977000, 23.3219000, 7531000, 0, 0, 'Bulgaria IP Range', 103, 65),
(204, 'Burkina Faso', 'Burkina Faso', 'French', 'Français', 'BF', 'fr', 'BF', 'fr', 'bf-fr', 'French', 'XOF', '+226', '🇧🇫', 'U+1F1E7 U+', 'E1 94 EB', 'bf_flag.png', 'UTC+0', 'Africa', 0, '1960-08-05', NULL, NULL, 'path_to_svg', 'Ouagadougou', 12.3689000, -1.5279000, 15746232, 0, 0, 'Burkina Faso IP Range', 144, 123),
(205, 'Burundi', 'Uburundi', 'Kirundi', 'Ikirundi', 'BI', 'rn', 'BI', 'rn', 'bi-rn', 'Kirundi', 'BIF', '+257', '🇧🇮', 'U+1F1E7 U+', 'E1 94 EE', 'bi_flag.png', 'UTC+2', 'Africa', 0, '1962-07-01', NULL, NULL, 'path_to_svg', 'Gitega', -3.4264000, 29.9306000, 8691000, 0, 0, 'Burundi IP Range', 179, 176),
(206, 'Chile', 'Chile', 'Spanish', 'Español', 'CL', 'es', 'CL', 'es', 'cl-es', 'Spanish', 'CLP', '+56', '🇨🇱', 'U+1F1E8 U+', 'E1 94 F1', 'cl_flag.png', 'UTC-4', 'South America', 0, '1818-02-12', NULL, NULL, 'path_to_svg', 'Santiago', -33.4489000, -70.6693000, 16601707, 0, 1, 'Chile IP Range', 52, 58),
(207, 'China', '中国', 'Chinese', '中文', 'CN', 'zh', 'CN', 'zh', 'cn-zh', 'Chinese', 'CNY', '+86', '🇨🇳', 'U+1F1E8 U+', 'E1 94 F3', 'cn_flag.png', 'UTC+8', 'Asia', 0, '1949-10-01', NULL, NULL, 'path_to_svg', 'Beijing', 39.9042000, 116.4074000, 1347374752, 0, 1, 'China IP Range', 1, 1),
(208, 'Croatia', 'Hrvatska', 'Croatian', 'Hrvatski', 'HR', 'hr', 'HR', 'hr', 'hr-hr', 'Croatian', 'HRK', '+385', '🇭🇷', 'U+1F1ED U+', 'E1 94 F7', 'hr_flag.png', 'UTC+1', 'Europe', 0, '1991-06-25', NULL, NULL, 'path_to_svg', 'Zagreb', 45.8150000, 15.9819000, 4437460, 0, 0, 'Croatia IP Range', 128, 95),
(209, 'Cyprus', 'Κύπρος', 'Greek', 'Ελληνικά', 'CY', 'el', 'CY', 'el', 'cy-el', 'Greek, Turkish', 'EUR', '+357', '🇨🇾', 'U+1F1E8 U+', 'E1 94 FE', 'cy_flag.png', 'UTC+2', 'Europe', 0, '1960-08-16', NULL, NULL, 'path_to_svg', 'Nicosia', 35.1856000, 33.3823000, 794600, 0, 0, 'Cyprus IP Range', 167, 106),
(210, 'Chad', 'تشاد', 'Arabic', 'العربية', 'TD', 'ar', 'TD', 'ar', 'td-ar', 'French, Arabic', 'XAF', '+235', '🇹🇩', 'U+1F1F9 U+', 'E1 94 E9', 'td_flag.png', 'UTC+1', 'Africa', 0, '1960-08-11', NULL, NULL, 'path_to_svg', 'N\'Djamena', 12.1348000, 15.0557000, 10758945, 0, 0, 'Chad IP Range', 174, 136),
(211, 'Montenegro', 'Црна Гора', 'Montenegrin', 'црногорски', 'ME', 'sr', 'ME', 'sr', 'me-sr', 'Montenegrin, Serbian', 'EUR', '+382', '🇲🇪', 'U+1F1F2 U+', 'E1 94 EA', 'me_flag.png', 'UTC+1', 'Europe', 0, '2006-06-03', NULL, NULL, 'path_to_svg', 'Podgorica', 42.4304000, 19.2594000, 672180, 0, 0, 'Montenegro IP Range', 178, 167),
(212, 'Czech Republic', 'Česká republika', 'Czech', 'čeština', 'CZ', 'cs', 'CZ', 'cs', 'cz-cs', 'Czech', 'CZK', '+420', '🇨🇿', 'U+1F1E8 U+', 'E1 94 FF', 'cz_flag.png', 'UTC+1', 'Europe', 0, '1993-01-01', NULL, NULL, 'path_to_svg', 'Prague', 50.0755000, 14.4378000, 10532770, 0, 0, 'Czech Republic IP Range', 102, 72),
(213, 'Denmark', 'Danmark', 'Danish', 'Dansk', 'DK', 'da', 'DK', 'da', 'dk-da', 'Danish', 'DKK', '+45', '🇩🇰', 'U+1F1E9 U+', 'E1 94 F0', 'dk_flag.png', 'UTC+1', 'Europe', 0, '1849-06-05', NULL, NULL, 'path_to_svg', 'Copenhagen', 55.6761000, 12.5683000, 5540241, 0, 1, 'Denmark IP Range', 99, 73),
(214, 'Democratic Republic of the Congo', 'République démocratique du Congo', 'French', 'Français', 'CD', 'fr', 'CD', 'fr', 'cd-fr', 'French', 'CDF', '+243', '🇨🇩', 'U+1F1E8 U+', 'E1 94 E9', 'cd_flag.png', 'UTC+2', 'Africa', 0, '1960-06-30', NULL, NULL, 'path_to_svg', 'Kinshasa', -4.4419000, 15.2663000, 66515000, 0, 1, 'Congo IP Range', 97, 82),
(215, 'Dominica', 'Dominica', 'English', 'English', 'DM', 'en', 'DM', 'en', 'dm-en', 'English', 'XCD', '+1 767', '🇩🇲', 'U+1F1E9 U+', 'E1 94 F2', 'dm_flag.png', 'UTC-4', 'North America', 0, '1978-11-03', NULL, NULL, 'path_to_svg', 'Roseau', 15.3092000, -61.3794000, 72000, 0, 0, 'Dominica IP Range', 186, 142),
(216, 'Dominican Republic', 'República Dominicana', 'Spanish', 'Español', 'DO', 'es', 'DO', 'es', 'do-es', 'Spanish', 'DOP', '+1 809', '🇩🇴', 'U+1F1E9 U+', 'E1 94 F4', 'do_flag.png', 'UTC-4', 'North America', 0, '1844-02-27', NULL, NULL, 'path_to_svg', 'Santo Domingo', 18.4861000, -69.9312000, 9049595, 0, 1, 'Dominican Republic IP Range', 86, 102),
(217, 'Djibouti', 'جيبوتي', 'Arabic', 'العربية', 'DJ', 'ar', 'DJ', 'ar', 'dj-ar', 'French, Arabic', 'DJF', '+253', '🇩🇯', 'U+1F1E9 U+', 'E1 94 EF', 'dj_flag.png', 'UTC+3', 'Africa', 0, '1977-06-27', NULL, NULL, 'path_to_svg', 'Djibouti', 11.5721000, 43.1456000, 506221, 0, 0, 'Djibouti IP Range', 172, 144),
(218, 'Egypt', 'مصر', 'Arabic', 'العربية', 'EG', 'ar', 'EG', 'ar', 'eg-ar', 'Arabic', 'EGP', '+20', '🇪🇬', 'U+1F1EA U+', 'E1 94 EC', 'eg_flag.png', 'UTC+2', 'Africa', 0, '1953-06-18', NULL, NULL, 'path_to_svg', 'Cairo', 30.0444000, 31.2357000, 80471869, 0, 1, 'Egypt IP Range', 14, 3),
(219, 'Ecuador', 'Ecuador', 'Spanish', 'Español', 'EC', 'es', 'EC', 'es', 'ec-es', 'Spanish', 'USD', '+593', '🇪🇨', 'U+1F1EA U+', 'E1 94 E8', 'ec_flag.png', 'UTC-5', 'South America', 0, '1822-05-24', NULL, NULL, 'path_to_svg', 'Quito', -0.1807000, -78.4678000, 17643054, 0, 1, 'Ecuador IP Range', 66, 89),
(220, 'El Salvador', 'El Salvador', 'Spanish', 'Español', 'SV', 'es', 'SV', 'es', 'sv-es', 'Spanish', 'USD', '+503', '🇸🇻', 'U+1F1F8 U+', 'E1 94 FB', 'sv_flag.png', 'UTC-6', 'North America', 0, '1821-09-15', NULL, NULL, 'path_to_svg', 'San Salvador', 13.6929000, -89.2182000, 6486201, 0, 0, 'El Salvador IP Range', 117, 88),
(221, 'Eritrea', 'ኤርትራ', 'Tigrinya', 'ትግርኛ', 'ER', 'ti', 'ER', 'ti', 'er-ti', 'Tigrinya, Arabic, English', 'ERN', '+291', '🇪🇷', 'U+1F1EA U+', 'E1 94 F7', 'er_flag.png', 'UTC+3', 'Africa', 0, '1993-05-24', NULL, NULL, 'path_to_svg', 'Asmara', 15.3229000, 38.9251000, 5028000, 0, 0, 'Eritrea IP Range', 181, 123),
(222, 'Estonia', 'Eesti', 'Estonian', 'eesti keel', 'EE', 'et', 'EE', 'et', 'ee-et', 'Estonian', 'EUR', '+372', '🇪🇪', 'U+1F1EA U+', 'E1 94 EA', 'ee_flag.png', 'UTC+2', 'Europe', 0, '1918-02-24', NULL, NULL, 'path_to_svg', 'Tallinn', 59.4370000, 24.7536000, 1340122, 0, 0, 'Estonia IP Range', 99, 81),
(223, 'Eswatini', 'Eswatini', 'Swati', 'siSwati', 'SZ', 'ss', 'SZ', 'ss', 'sz-ss', 'Swati, English', 'SZL', '+268', '🇸🇿', 'U+1F1F8 U+', 'E1 94 FF', 'sz_flag.png', 'UTC+2', 'Africa', 0, '1968-09-06', NULL, NULL, 'path_to_svg', 'Mbabane', -26.3054000, 31.1367000, 1138227, 0, 0, 'Eswatini IP Range', 193, 156),
(224, 'Ethiopia', 'ኢትዮጵያ', 'Amharic', 'አማርኛ', 'ET', 'am', 'ET', 'am', 'et-am', 'Amharic', 'ETB', '+251', '🇪🇹', 'U+1F1EA U+', 'E1 94 F9', 'et_flag.png', 'UTC+3', 'Africa', 0, '1941-05-05', NULL, NULL, 'path_to_svg', 'Addis Ababa', 9.1450000, 40.4897000, 81238000, 0, 1, 'Ethiopia IP Range', 12, 4),
(225, 'Fiji', 'Fiji', 'Fijian', 'Viti', 'FJ', 'fj', 'FJ', 'fj', 'fj-fj', 'Fijian, English', 'FJD', '+679', '🇫🇯', 'U+1F1EB U+', 'E1 94 EF', 'fj_flag.png', 'UTC+12', 'Oceania', 0, '1970-10-10', NULL, NULL, 'path_to_svg', 'Suva', -18.1248000, 178.4501000, 849000, 0, 0, 'Fiji IP Range', 157, 109),
(226, 'Philippines', 'Pilipinas', 'Filipino', 'Filipino', 'PH', 'fil', 'PH', 'fil', 'ph-fil', 'Filipino, English', 'PHP', '+63', '🇵🇭', 'U+1F1F5 U+', 'E1 94 ED', 'ph_flag.png', 'UTC+8', 'Asia', 0, '1946-07-04', NULL, NULL, 'path_to_svg', 'Manila', 14.5995000, 120.9842000, 92681000, 0, 1, 'Philippines IP Range', 47, 13),
(227, 'Finland', 'Suomi', 'Finnish', 'suomi', 'FI', 'fi', 'FI', 'fi', 'fi-fi', 'Finnish, Swedish', 'EUR', '+358', '🇫🇮', 'U+1F1EB U+', 'E1 94 EE', 'fi_flag.png', 'UTC+2', 'Europe', 0, '1917-12-06', NULL, NULL, 'path_to_svg', 'Helsinki', 60.1695000, 24.9355000, 5313026, 0, 0, 'Finland IP Range', 18, 16),
(228, 'France', 'France', 'French', 'français', 'FR', 'fr', 'FR', 'fr', 'fr-fr', 'French', 'EUR', '+33', '🇫🇷', 'U+1F1EB U+', 'E1 94 F7', 'fr_flag.png', 'UTC+1', 'Europe', 0, '0843-08-10', NULL, NULL, 'path_to_svg', 'Paris', 48.8566000, 2.3522000, 66000000, 0, 0, 'France IP Range', 98, 22),
(229, 'Gabon', 'Gabon', 'French', 'français', 'GA', 'fr', 'GA', 'fr', 'ga-fr', 'French', 'XAF', '+241', '🇬🇦', 'U+1F1EC U+', 'E1 94 E6', 'ga_flag.png', 'UTC+1', 'Africa', 0, '1960-08-17', NULL, NULL, 'path_to_svg', 'Libreville', 0.4162000, 9.4673000, 1454867, 0, 0, 'Gabon IP Range', 5, 123),
(230, 'Gambia', 'The Gambia', 'English', 'English', 'GM', 'en', 'GM', 'en', 'gm-en', 'English', 'GMD', '+220', '🇬🇲', 'U+1F1EC U+', 'E1 94 F2', 'gm_flag.png', 'UTC+0', 'Africa', 0, '1965-02-18', NULL, NULL, 'path_to_svg', 'Banjul', 13.4549000, -16.5790000, 1690000, 0, 0, 'Gambia IP Range', 150, 122),
(231, 'Ghana', 'Ghana', 'English', 'English', 'GH', 'en', 'GH', 'en', 'gh-en', 'English', 'GHS', '+233', '🇬🇭', 'U+1F1EC U+', 'E1 94 ED', 'gh_flag.png', 'UTC+0', 'Africa', 0, '1957-03-06', NULL, NULL, 'path_to_svg', 'Accra', 5.6037000, -0.1870000, 23000000, 0, 0, 'Ghana IP Range', 96, 47),
(232, 'Greece', 'Ελλάδα', 'Greek', 'ελληνικά', 'GR', 'el', 'GR', 'el', 'gr-el', 'Greek', 'EUR', '+30', '🇬🇷', 'U+1F1EC U+', 'E1 94 F7', 'gr_flag.png', 'UTC+2', 'Europe', 0, '1830-02-03', NULL, NULL, 'path_to_svg', 'Athens', 37.9838000, 23.7275000, 11216708, 0, 0, 'Greece IP Range', 85, 34),
(233, 'Grenada', 'Grenada', 'English', 'English', 'GD', 'en', 'GD', 'en', 'gd-en', 'English', 'XCD', '+1-473', '🇬🇩', 'U+1F1EC U+', 'E1 94 E9', 'gd_flag.png', 'UTC-4', 'North America', 0, '1974-02-07', NULL, NULL, 'path_to_svg', 'Saint George’s', 12.0561000, -61.7486000, 89258, 0, 0, 'Grenada IP Range', 262, 191),
(234, 'Georgia', 'საქართველო', 'Georgian', 'ქართული', 'GE', 'ka', 'GE', 'ka', 'ge-ka', 'Georgian', 'GEL', '+995', '🇬🇪', 'U+1F1EC U+', 'E1 94 EA', 'ge_flag.png', 'UTC+4', 'Asia', 0, '1991-04-09', NULL, NULL, 'path_to_svg', 'Tbilisi', 41.7151000, 44.8271000, 4630841, 0, 0, 'Georgia IP Range', 67, 34),
(235, 'Guyana', 'Guyana', 'English', 'English', 'GY', 'en', 'GY', 'en', 'gy-en', 'English', 'GYD', '+592', '🇬🇾', 'U+1F1EC U+', 'E1 94 FE', 'gy_flag.png', 'UTC-4', 'South America', 0, '1966-05-26', NULL, NULL, 'path_to_svg', 'Georgetown', 6.8013000, -58.1551000, 769095, 0, 0, 'Guyana IP Range', 4, 25),
(236, 'Guatemala', 'Guatemala', 'Spanish', 'Español', 'GT', 'es', 'GT', 'es', 'gt-es', 'Spanish', 'GTQ', '+502', '🇬🇹', 'U+1F1EC U+', 'E1 94 F9', 'gt_flag.png', 'UTC-6', 'North America', 0, '1821-09-15', NULL, NULL, 'path_to_svg', 'Guatemala City', 14.6349000, -90.5069000, 12013907, 0, 0, 'Guatemala IP Range', 119, 72),
(237, 'Guinea', 'Guinée', 'French', 'français', 'GN', 'fr', 'GN', 'fr', 'gn-fr', 'French', 'GNF', '+224', '🇬🇳', 'U+1F1EC U+', 'E1 94 F3', 'gn_flag.png', 'UTC+0', 'Africa', 0, '1958-10-02', NULL, NULL, 'path_to_svg', 'Conakry', 9.6412000, -13.5784000, 9950670, 0, 0, 'Guinea IP Range', 41, 112),
(238, 'Guinea-Bissau', 'Guiné-Bissau', 'Portuguese', 'português', 'GW', 'pt', 'GW', 'pt', 'gw-pt', 'Portuguese', 'XOF', '+245', '🇬🇼', 'U+1F1EC U+', 'E1 94 FC', 'gw_flag.png', 'UTC+0', 'Africa', 0, '1974-09-24', NULL, NULL, 'path_to_svg', 'Bissau', 11.8596000, -15.5844000, 1475000, 0, 0, 'Guinea-Bissau IP Range', 41, 68),
(239, 'Equatorial Guinea', 'Guinea Ecuatorial', 'Spanish', 'Español', 'GQ', 'es', 'GQ', 'es', 'gq-es', 'Spanish, French, Portuguese', 'XAF', '+240', '🇬🇶', 'U+1F1EC U+', 'E1 94 F6', 'gq_flag.png', 'UTC+1', 'Africa', 0, '1968-10-12', NULL, NULL, 'path_to_svg', 'Malabo', 3.7500000, 8.7833000, 616459, 0, 0, 'Equatorial Guinea IP Range', 22, 13),
(240, 'Haiti', 'Haïti', 'French', 'français', 'HT', 'fr', 'HT', 'fr', 'ht-fr', 'French, Haitian Creole', 'HTG', '+509', '🇭🇹', 'U+1F1EC U+', 'E1 94 ED', 'ht_flag.png', 'UTC-5', 'North America', 0, '1804-01-01', NULL, NULL, 'path_to_svg', 'Port-au-Prince', 18.5944000, -72.3074000, 8925000, 0, 0, 'Haiti IP Range', 322, 212),
(241, 'Spain', 'España', 'Spanish', 'Español', 'ES', 'es', 'ES', 'es', 'es-es', 'Spanish', 'EUR', '+34', '🇪🇸', 'U+1F1EA U+', 'E1 94 F8', 'es_flag.png', 'UTC+1', 'Europe', 0, '1469-10-19', NULL, NULL, 'path_to_svg', 'Madrid', 40.4168000, -3.7038000, 47150819, 0, 0, 'Spain IP Range', 93, 30),
(242, 'Netherlands', 'Nederland', 'Dutch', 'Nederlands', 'NL', 'nl', 'NL', 'nl', 'nl-nl', 'Dutch', 'EUR', '+31', '🇳🇱', 'U+1F1F3 U+', 'E1 94 F1', 'nl_flag.png', 'UTC+1', 'Europe', 0, '1815-03-16', NULL, NULL, 'path_to_svg', 'Amsterdam', 52.3676000, 4.9041000, 16509303, 0, 0, 'Netherlands IP Range', 398, 17),
(243, 'Honduras', 'Honduras', 'Spanish', 'Español', 'HN', 'es', 'HN', 'es', 'hn-es', 'Spanish', 'HNL', '+504', '🇭🇳', 'U+1F1ED U+', 'E1 94 F3', 'hn_flag.png', 'UTC-6', 'North America', 0, '1821-09-15', NULL, NULL, 'path_to_svg', 'Tegucigalpa', 14.0723000, -87.1921000, 7325000, 0, 0, 'Honduras IP Range', 65, 69),
(244, 'India', 'भारत', 'Hindi', 'हिन्दी', 'IN', 'hi', 'IN', 'hi', 'in-hi', 'Hindi, English', 'INR', '+91', '🇮🇳', 'U+1F1EE U+', 'E1 94 F3', 'in_flag.png', 'UTC+5:30', 'Asia', 0, '1947-08-15', NULL, NULL, 'path_to_svg', 'New Delhi', 28.6139000, 77.2090000, 1166079217, 0, 0, 'India IP Range', 355, 2),
(245, 'Indonesia', 'Indonesia', 'Indonesian', 'Bahasa Indonesia', 'ID', 'id', 'ID', 'id', 'id-id', 'Indonesian', 'IDR', '+62', '🇮🇩', 'U+1F1EE U+', 'E1 94 E9', 'id_flag.png', 'UTC+7', 'Asia', 0, '1945-08-17', NULL, NULL, 'path_to_svg', 'Jakarta', -6.2088000, 106.8456000, 242968342, 0, 0, 'Indonesia IP Range', 124, 4),
(246, 'Iraq', 'العراق', 'Arabic', 'العربية', 'IQ', 'ar', 'IQ', 'ar', 'iq-ar', 'Arabic', 'IQD', '+964', '🇮🇶', 'U+1F1EE U+', 'E1 94 F6', 'iq_flag.png', 'UTC+3', 'Asia', 0, '1932-10-03', NULL, NULL, 'path_to_svg', 'Baghdad', 33.3152000, 44.3661000, 30399572, 0, 0, 'Iraq IP Range', 70, 36),
(247, 'Iran', 'ایران', 'Persian', 'فارسی', 'IR', 'fa', 'IR', 'fa', 'ir-fa', 'Persian', 'IRR', '+98', '🇮🇷', 'U+1F1EE U+', 'E1 94 F7', 'ir_flag.png', 'UTC+3:30', 'Asia', 0, '1979-04-01', NULL, NULL, 'path_to_svg', 'Tehran', 35.6892000, 51.3890000, 70495782, 0, 0, 'Iran IP Range', 43, 18),
(248, 'Ireland', 'Éire', 'Irish', 'Gaeilge', 'IE', 'ga', 'IE', 'ga', 'ie-ga', 'Irish, English', 'EUR', '+353', '🇮🇪', 'U+1F1EE U+', 'E1 94 EA', 'ie_flag.png', 'UTC+0', 'Europe', 0, '1922-12-06', NULL, NULL, 'path_to_svg', 'Dublin', 53.3498000, -6.2603000, 4581269, 0, 0, 'Ireland IP Range', 63, 41),
(249, 'Iceland', 'Ísland', 'Icelandic', 'Íslenska', 'IS', 'is', 'IS', 'is', 'is-is', 'Icelandic', 'ISK', '+354', '🇮🇸', 'U+1F1EE U+', 'E1 94 F8', 'is_flag.png', 'UTC+0', 'Europe', 0, '1944-06-17', NULL, NULL, 'path_to_svg', 'Reykjavík', 64.1466000, -21.9426000, 306694, 0, 0, 'Iceland IP Range', 3, 206),
(250, 'Israel', 'ישראל', 'Hebrew', 'עברית', 'IL', 'he', 'IL', 'he', 'il-he', 'Hebrew', 'ILS', '+972', '🇮🇱', 'U+1F1EE U+', 'E1 94 F1', 'il_flag.png', 'UTC+2', 'Asia', 0, '1948-05-14', NULL, NULL, 'path_to_svg', 'Jerusalem', 31.7683000, 35.2137000, 7653600, 0, 0, 'Israel IP Range', 351, 100),
(251, 'Jamaica', 'Jamaica', 'English', 'English', 'JM', 'en', 'JM', 'en', 'jm-en', 'English', 'JMD', '+1-876', '🇯🇲', 'U+1F1EF U+', 'E1 94 F2', 'jm_flag.png', 'UTC-5', 'North America', 0, '1962-08-06', NULL, NULL, 'path_to_svg', 'Kingston', 17.9712000, -76.7936000, 2700000, 0, 0, 'Jamaica IP Range', 245, 91),
(252, 'Japan', '日本', 'Japanese', '日本語', 'JP', 'ja', 'JP', 'ja', 'jp-ja', 'Japanese', 'JPY', '+81', '🇯🇵', 'U+1F1EF U+', 'E1 94 F5', 'jp_flag.png', 'UTC+9', 'Asia', 0, '1947-05-03', NULL, NULL, 'path_to_svg', 'Tokyo', 35.6762000, 139.6503000, 126475664, 0, 0, 'Japan IP Range', 336, 11),
(253, 'Yemen', 'اليمن', 'Arabic', 'العربية', 'YE', 'ar', 'YE', 'ar', 'ye-ar', 'Arabic', 'YER', '+967', '🇾🇪', 'U+1F1FE U+', 'E1 94 EA', 'ye_flag.png', 'UTC+3', 'Asia', 0, '1990-05-22', NULL, NULL, 'path_to_svg', 'Sana’a', 15.3694000, 44.1910000, 23495361, 0, 0, 'Yemen IP Range', 44, 48),
(254, 'Jordan', 'الأردن', 'Arabic', 'العربية', 'JO', 'ar', 'JO', 'ar', 'jo-ar', 'Arabic', 'JOD', '+962', '🇯🇴', 'U+1F1EF U+', 'E1 94 F4', 'jo_flag.png', 'UTC+2', 'Asia', 0, '1946-05-25', NULL, NULL, 'path_to_svg', 'Amman', 31.9539000, 35.9106000, 5759732, 0, 0, 'Jordan IP Range', 62, 69),
(255, 'Cambodia', 'កម្ពុជា', 'Khmer', 'ភាសាខ្មែរ', 'KH', 'km', 'KH', 'km', 'kh-km', 'Khmer', 'KHR', '+855', '🇰🇭', 'U+1F1F0 U+', 'E1 94 ED', 'kh_flag.png', 'UTC+7', 'Asia', 0, '1953-11-09', NULL, NULL, 'path_to_svg', 'Phnom Penh', 11.5564000, 104.9282000, 14140900, 0, 0, 'Cambodia IP Range', 25, 78),
(256, 'Canada', 'Canada', 'English', 'English', 'CA', 'en', 'CA', 'en', 'ca-en', 'English, French', 'CAD', '+1', '🇨🇦', 'U+1F1E8 U+', 'E1 94 E6', 'ca_flag.png', 'UTC-5', 'North America', 0, '1867-07-01', NULL, NULL, 'path_to_svg', 'Ottawa', 45.4215000, -75.6972000, 37894799, 0, 0, 'Canada IP Range', 36, 19),
(257, 'Spain', 'España', 'Spanish', 'Español', 'ES', 'es', 'ES', 'es', 'es-es', 'Spanish', 'EUR', '+34', '🇪🇸', 'U+1F1EA U+', 'E1 94 F8', 'es_flag.png', 'UTC+1', 'Europe', 0, '1469-10-19', NULL, NULL, 'path_to_svg', 'Madrid', 40.4168000, -3.7038000, 47150819, 0, 0, 'Spain IP Range', 93, 30),
(258, 'Netherlands', 'Nederland', 'Dutch', 'Nederlands', 'NL', 'nl', 'NL', 'nl', 'nl-nl', 'Dutch', 'EUR', '+31', '🇳🇱', 'U+1F1F3 U+', 'E1 94 F1', 'nl_flag.png', 'UTC+1', 'Europe', 0, '1815-03-16', NULL, NULL, 'path_to_svg', 'Amsterdam', 52.3676000, 4.9041000, 16509303, 0, 0, 'Netherlands IP Range', 398, 17),
(259, 'Honduras', 'Honduras', 'Spanish', 'Español', 'HN', 'es', 'HN', 'es', 'hn-es', 'Spanish', 'HNL', '+504', '🇭🇳', 'U+1F1ED U+', 'E1 94 F3', 'hn_flag.png', 'UTC-6', 'North America', 0, '1821-09-15', NULL, NULL, 'path_to_svg', 'Tegucigalpa', 14.0723000, -87.1921000, 7325000, 0, 0, 'Honduras IP Range', 65, 69),
(260, 'India', 'भारत', 'Hindi', 'हिन्दी', 'IN', 'hi', 'IN', 'hi', 'in-hi', 'Hindi, English', 'INR', '+91', '🇮🇳', 'U+1F1EE U+', 'E1 94 F3', 'in_flag.png', 'UTC+5:30', 'Asia', 0, '1947-08-15', NULL, NULL, 'path_to_svg', 'New Delhi', 28.6139000, 77.2090000, 1166079217, 0, 0, 'India IP Range', 355, 2),
(261, 'Indonesia', 'Indonesia', 'Indonesian', 'Bahasa Indonesia', 'ID', 'id', 'ID', 'id', 'id-id', 'Indonesian', 'IDR', '+62', '🇮🇩', 'U+1F1EE U+', 'E1 94 E9', 'id_flag.png', 'UTC+7', 'Asia', 0, '1945-08-17', NULL, NULL, 'path_to_svg', 'Jakarta', -6.2088000, 106.8456000, 242968342, 0, 0, 'Indonesia IP Range', 124, 4),
(262, 'Iraq', 'العراق', 'Arabic', 'العربية', 'IQ', 'ar', 'IQ', 'ar', 'iq-ar', 'Arabic', 'IQD', '+964', '🇮🇶', 'U+1F1EE U+', 'E1 94 F6', 'iq_flag.png', 'UTC+3', 'Asia', 0, '1932-10-03', NULL, NULL, 'path_to_svg', 'Baghdad', 33.3152000, 44.3661000, 30399572, 0, 0, 'Iraq IP Range', 70, 36),
(263, 'Iran', 'ایران', 'Persian', 'فارسی', 'IR', 'fa', 'IR', 'fa', 'ir-fa', 'Persian', 'IRR', '+98', '🇮🇷', 'U+1F1EE U+', 'E1 94 F7', 'ir_flag.png', 'UTC+3:30', 'Asia', 0, '1979-04-01', NULL, NULL, 'path_to_svg', 'Tehran', 35.6892000, 51.3890000, 70495782, 0, 0, 'Iran IP Range', 43, 18),
(264, 'Ireland', 'Éire', 'Irish', 'Gaeilge', 'IE', 'ga', 'IE', 'ga', 'ie-ga', 'Irish, English', 'EUR', '+353', '🇮🇪', 'U+1F1EE U+', 'E1 94 EA', 'ie_flag.png', 'UTC+0', 'Europe', 0, '1922-12-06', NULL, NULL, 'path_to_svg', 'Dublin', 53.3498000, -6.2603000, 4581269, 0, 0, 'Ireland IP Range', 63, 41),
(265, 'Iceland', 'Ísland', 'Icelandic', 'Íslenska', 'IS', 'is', 'IS', 'is', 'is-is', 'Icelandic', 'ISK', '+354', '🇮🇸', 'U+1F1EE U+', 'E1 94 F8', 'is_flag.png', 'UTC+0', 'Europe', 0, '1944-06-17', NULL, NULL, 'path_to_svg', 'Reykjavík', 64.1466000, -21.9426000, 306694, 0, 0, 'Iceland IP Range', 3, 206),
(266, 'Israel', 'ישראל', 'Hebrew', 'עברית', 'IL', 'he', 'IL', 'he', 'il-he', 'Hebrew', 'ILS', '+972', '🇮🇱', 'U+1F1EE U+', 'E1 94 F1', 'il_flag.png', 'UTC+2', 'Asia', 0, '1948-05-14', NULL, NULL, 'path_to_svg', 'Jerusalem', 31.7683000, 35.2137000, 7653600, 0, 0, 'Israel IP Range', 351, 100),
(267, 'Jamaica', 'Jamaica', 'English', 'English', 'JM', 'en', 'JM', 'en', 'jm-en', 'English', 'JMD', '+1-876', '🇯🇲', 'U+1F1EF U+', 'E1 94 F2', 'jm_flag.png', 'UTC-5', 'North America', 0, '1962-08-06', NULL, NULL, 'path_to_svg', 'Kingston', 17.9712000, -76.7936000, 2700000, 0, 0, 'Jamaica IP Range', 245, 91),
(268, 'Japan', '日本', 'Japanese', '日本語', 'JP', 'ja', 'JP', 'ja', 'jp-ja', 'Japanese', 'JPY', '+81', '🇯🇵', 'U+1F1EF U+', 'E1 94 F5', 'jp_flag.png', 'UTC+9', 'Asia', 0, '1947-05-03', NULL, NULL, 'path_to_svg', 'Tokyo', 35.6762000, 139.6503000, 126475664, 0, 0, 'Japan IP Range', 336, 11),
(269, 'Yemen', 'اليمن', 'Arabic', 'العربية', 'YE', 'ar', 'YE', 'ar', 'ye-ar', 'Arabic', 'YER', '+967', '🇾🇪', 'U+1F1FE U+', 'E1 94 EA', 'ye_flag.png', 'UTC+3', 'Asia', 0, '1990-05-22', NULL, NULL, 'path_to_svg', 'Sana’a', 15.3694000, 44.1910000, 23495361, 0, 0, 'Yemen IP Range', 44, 48),
(270, 'Jordan', 'الأردن', 'Arabic', 'العربية', 'JO', 'ar', 'JO', 'ar', 'jo-ar', 'Arabic', 'JOD', '+962', '🇯🇴', 'U+1F1EF U+', 'E1 94 F4', 'jo_flag.png', 'UTC+2', 'Asia', 0, '1946-05-25', NULL, NULL, 'path_to_svg', 'Amman', 31.9539000, 35.9106000, 5759732, 0, 0, 'Jordan IP Range', 62, 69),
(271, 'Cambodia', 'កម្ពុជា', 'Khmer', 'ភាសាខ្មែរ', 'KH', 'km', 'KH', 'km', 'kh-km', 'Khmer', 'KHR', '+855', '🇰🇭', 'U+1F1F0 U+', 'E1 94 ED', 'kh_flag.png', 'UTC+7', 'Asia', 0, '1953-11-09', NULL, NULL, 'path_to_svg', 'Phnom Penh', 11.5564000, 104.9282000, 14140900, 0, 0, 'Cambodia IP Range', 25, 78),
(272, 'Canada', 'Canada', 'English', 'English', 'CA', 'en', 'CA', 'en', 'ca-en', 'English, French', 'CAD', '+1', '🇨🇦', 'U+1F1E8 U+', 'E1 94 E6', 'ca_flag.png', 'UTC-5', 'North America', 0, '1867-07-01', NULL, NULL, 'path_to_svg', 'Ottawa', 45.4215000, -75.6972000, 37894799, 0, 0, 'Canada IP Range', 36, 19),
(273, 'Qatar', 'قطر', 'Arabic', 'العربية', 'QA', 'ar', 'QA', 'ar', 'qa-ar', 'Arabic', 'QAR', '+974', '🇶🇦', 'U+1F1F6 U+', 'E1 94 E6', 'qa_flag.png', 'UTC+3', 'Asia', 0, '1971-09-03', NULL, NULL, 'path_to_svg', 'Doha', 25.2769870, 51.5200080, 928635, 0, 0, 'Qatar IP Range', 81, 30),
(274, 'Kazakhstan', 'Қазақстан', 'Kazakh', 'Қазақ', 'KZ', 'kk', 'KZ', 'kk', 'kz-kk', 'Kazakh, Russian', 'KZT', '+7', '🇰🇿', 'U+1F1F0 U+', 'E1 94 FF', 'kz_flag.png', 'UTC+6', 'Asia, Europe', 0, '1991-12-16', NULL, NULL, 'path_to_svg', 'Astana', 51.1693920, 71.4490740, 15399437, 0, 0, 'Kazakhstan IP Range', 6, 12),
(275, 'Kenya', 'Kenya', 'English', 'English', 'KE', 'en', 'KE', 'en', 'ke-en', 'English, Swahili', 'KES', '+254', '🇰🇪', 'U+1F1F0 U+', 'E1 94 EA', 'ke_flag.png', 'UTC+3', 'Africa', 0, '1963-12-12', NULL, NULL, 'path_to_svg', 'Nairobi', -1.2920660, 36.8219450, 37953840, 0, 0, 'Kenya IP Range', 69, 32),
(276, 'Kyrgyzstan', 'Кыргызстан', 'Kyrgyz', 'Кыргыз', 'KG', 'ky', 'KG', 'ky', 'kg-ky', 'Kyrgyz, Russian', 'KGS', '+996', '🇰🇬', 'U+1F1F0 U+', 'E1 94 EC', 'kg_flag.png', 'UTC+6', 'Asia', 0, '1991-08-31', NULL, NULL, 'path_to_svg', 'Bishkek', 42.8746210, 74.5697620, 5357000, 0, 0, 'Kyrgyzstan IP Range', 27, 40),
(277, 'Kiribati', 'Kiribati', 'English', 'English', 'KI', 'en', 'KI', 'en', 'ki-en', 'English', 'AUD', '+686', '🇰🇮', 'U+1F1F0 U+', 'E1 94 EE', 'ki_flag.png', 'UTC+12', 'Oceania', 0, '1979-07-12', NULL, NULL, 'path_to_svg', 'Bairiki', -1.9856860, 157.3765870, 103092, 0, 0, 'Kiribati IP Range', 127, 174),
(278, 'Colombia', 'Colombia', 'Spanish', 'Español', 'CO', 'es', 'CO', 'es', 'co-es', 'Spanish', 'COP', '+57', '🇨🇴', 'U+1F1E8 U+', 'E1 94 F4', 'co_flag.png', 'UTC-5', 'South America', 0, '1810-07-20', NULL, NULL, 'path_to_svg', 'Bogota', 4.7110000, -74.0721000, 45730834, 0, 0, 'Colombia IP Range', 40, 29),
(279, 'Comoros', 'Comores', 'Comorian', 'Shikomori', 'KM', 'ar', 'KM', 'ar', 'km-ar', 'Comorian, Arabic, French', 'KMF', '+269', '🇰🇲', 'U+1F1F0 U+', 'E1 94 F2', 'km_flag.png', 'UTC+3', 'Africa', 0, '1975-07-06', NULL, NULL, 'path_to_svg', 'Moroni', -11.7172160, 43.2473150, 671247, 0, 0, 'Comoros IP Range', 309, 7),
(280, 'Congo', 'République du Congo', 'French', 'Français', 'CG', 'fr', 'CG', 'fr', 'cg-fr', 'French', 'XAF', '+242', '🇨🇬', 'U+1F1E8 U+', 'E1 94 EC', 'cg_flag.png', 'UTC+1', 'Africa', 0, '1960-08-15', NULL, NULL, 'path_to_svg', 'Brazzaville', -4.2633600, 15.2428850, 3756000, 0, 0, 'Congo IP Range', 11, 15),
(281, 'South Korea', '대한민국', 'Korean', '한국어', 'KR', 'ko', 'KR', 'ko', 'kr-ko', 'Korean', 'KRW', '+82', '🇰🇷', 'U+1F1F0 U+', 'E1 94 F7', 'kr_flag.png', 'UTC+9', 'Asia', 0, '1948-08-15', NULL, NULL, 'path_to_svg', 'Seoul', 37.5665000, 126.9780000, 50062000, 0, 0, 'South Korea IP Range', 500, 1),
(282, 'North Korea', '조선민주주의인민공화국', 'Korean', '한국어', 'KP', 'ko', 'KP', 'ko', 'kp-ko', 'Korean', 'KPW', '+850', '🇰🇵', 'U+1F1F0 U+', 'E1 94 F5', 'kp_flag.png', 'UTC+9', 'Asia', 0, '1948-09-09', NULL, NULL, 'path_to_svg', 'Pyongyang', 39.0392000, 125.7625000, 22757275, 0, 0, 'North Korea IP Range', 189, 19),
(283, 'Costa Rica', 'Costa Rica', 'Spanish', 'Español', 'CR', 'es', 'CR', 'es', 'cr-es', 'Spanish', 'CRC', '+506', '🇨🇷', 'U+1F1E8 U+', 'E1 94 F7', 'cr_flag.png', 'UTC-6', 'North America', 0, '1821-09-15', NULL, NULL, 'path_to_svg', 'San José', 9.9281000, -84.0907000, 4325000, 0, 0, 'Costa Rica IP Range', 85, 34),
(284, 'Cuba', 'Cuba', 'Spanish', 'Español', 'CU', 'es', 'CU', 'es', 'cu-es', 'Spanish', 'CUP', '+53', '🇨🇺', 'U+1F1E8 U+', 'E1 94 FA', 'cu_flag.png', 'UTC-5', 'North America', 0, '1902-05-20', NULL, NULL, 'path_to_svg', 'Havana', 23.1136000, -82.3666000, 11424000, 0, 0, 'Cuba IP Range', 103, 31),
(285, 'Kuwait', 'الكويت', 'Arabic', 'العربية', 'KW', 'ar', 'KW', 'ar', 'kw-ar', 'Arabic', 'KWD', '+965', '🇰🇼', 'U+1F1F0 U+', 'E1 94 FC', 'kw_flag.png', 'UTC+3', 'Asia', 0, '1961-06-19', NULL, NULL, 'path_to_svg', 'Kuwait City', 29.3759000, 47.9774000, 2597000, 0, 0, 'Kuwait IP Range', 122, 40),
(286, 'Laos', 'ປະເທດລາວ', 'Lao', 'ລາວ', 'LA', 'lo', 'LA', 'lo', 'la-lo', 'Lao', 'LAK', '+856', '🇱🇦', 'U+1F1F1 U+', 'E1 94 E6', 'la_flag.png', 'UTC+7', 'Asia', 0, '1953-10-22', NULL, NULL, 'path_to_svg', 'Vientiane', 17.9757000, 102.6331000, 6521998, 0, 0, 'Laos IP Range', 26, 35),
(287, 'Lesotho', 'Lesotho', 'English', 'English', 'LS', 'en', 'LS', 'en', 'ls-en', 'English, Sesotho', 'LSL', '+266', '🇱🇸', 'U+1F1F1 U+', 'E1 94 F8', 'ls_flag.png', 'UTC+2', 'Africa', 0, '1966-10-04', NULL, NULL, 'path_to_svg', 'Maseru', -29.3152000, 27.4869000, 2031348, 0, 0, 'Lesotho IP Range', 67, 17),
(288, 'Lebanon', 'لبنان', 'Arabic', 'العربية', 'LB', 'ar', 'LB', 'ar', 'lb-ar', 'Arabic', 'LBP', '+961', '🇱🇧', 'U+1F1F1 U+', 'E1 94 E7', 'lb_flag.png', 'UTC+2', 'Asia', 0, '1943-11-22', NULL, NULL, 'path_to_svg', 'Beirut', 33.8886000, 35.4955000, 3925502, 0, 0, 'Lebanon IP Range', 376, 12),
(289, 'Liberia', 'Liberia', 'English', 'English', 'LR', 'en', 'LR', 'en', 'lr-en', 'English', 'LRD', '+231', '🇱🇷', 'U+1F1F1 U+', 'E1 94 F7', 'lr_flag.png', 'UTC+0', 'Africa', 0, '1847-07-26', NULL, NULL, 'path_to_svg', 'Monrovia', 6.3005400, -10.7969000, 3200000, 0, 0, 'Liberia IP Range', 29, 38),
(290, 'Libya', 'ليبيا', 'Arabic', 'العربية', 'LY', 'ar', 'LY', 'ar', 'ly-ar', 'Arabic', 'LYD', '+218', '🇱🇾', 'U+1F1F1 U+', 'E1 94 FE', 'ly_flag.png', 'UTC+2', 'Africa', 0, '1951-12-24', NULL, NULL, 'path_to_svg', 'Tripoli', 32.8872000, 13.1913000, 6310434, 0, 0, 'Libya IP Range', 4, 13),
(291, 'Liechtenstein', 'Liechtenstein', 'German', 'Deutsch', 'LI', 'de', 'LI', 'de', 'li-de', 'German', 'CHF', '+423', '🇱🇮', 'U+1F1F1 U+', 'E1 94 EE', 'li_flag.png', 'UTC+1', 'Europe', 0, '1806-07-12', NULL, NULL, 'path_to_svg', 'Vaduz', 47.1416000, 9.5215000, 34761, 0, 0, 'Liechtenstein IP Range', 215, 18),
(292, 'Lithuania', 'Lietuva', 'Lithuanian', 'Lietuvių', 'LT', 'lt', 'LT', 'lt', 'lt-lt', 'Lithuanian', 'EUR', '+370', '🇱🇹', 'U+1F1F1 U+', 'E1 94 F9', 'lt_flag.png', 'UTC+2', 'Europe', 0, '1990-03-11', NULL, NULL, 'path_to_svg', 'Vilnius', 54.6872000, 25.2797000, 3225346, 0, 0, 'Lithuania IP Range', 52, 24),
(293, 'Luxembourg', 'Luxembourg', 'French', 'Français', 'LU', 'fr', 'LU', 'fr', 'lu-fr', 'French, Luxembourgish, German', 'EUR', '+352', '🇱🇺', 'U+1F1F1 U+', 'E1 94 FA', 'lu_flag.png', 'UTC+1', 'Europe', 0, '1839-04-19', NULL, NULL, 'path_to_svg', 'Luxembourg City', 49.6117000, 6.1319000, 474413, 0, 0, 'Luxembourg IP Range', 183, 7),
(294, 'Latvia', 'Latvija', 'Latvian', 'Latviešu', 'LV', 'lv', 'LV', 'lv', 'lv-lv', 'Latvian', 'EUR', '+371', '🇱🇻', 'U+1F1F1 U+', 'E1 94 FB', 'lv_flag.png', 'UTC+2', 'Europe', 0, '1991-08-21', NULL, NULL, 'path_to_svg', 'Riga', 56.9496000, 24.1052000, 2224400, 0, 0, 'Latvia IP Range', 35, 10),
(295, 'North Macedonia', 'Северна Македонија', 'Macedonian', 'Македонски', 'MK', 'mk', 'MK', 'mk', 'mk-mk', 'Macedonian', 'MKD', '+389', '🇲🇰', 'U+1F1F1 U+', 'E1 94 F0', 'mk_flag.png', 'UTC+1', 'Europe', 0, '1991-09-08', NULL, NULL, 'path_to_svg', 'Skopje', 41.9981000, 21.4254000, 2061000, 0, 0, 'North Macedonia IP Range', 81, 16),
(296, 'Madagascar', 'Madagasikara', 'Malagasy', 'Malagasy', 'MG', 'mg', 'MG', 'mg', 'mg-mg', 'Malagasy, French', 'MGA', '+261', '🇲🇬', 'U+1F1F1 U+', 'E1 94 EC', 'mg_flag.png', 'UTC+3', 'Africa', 0, '1960-06-26', NULL, NULL, 'path_to_svg', 'Antananarivo', -18.8792000, 47.5079000, 20653556, 0, 0, 'Madagascar IP Range', 34, 25),
(297, 'Malawi', 'Malawi', 'English', 'English', 'MW', 'en', 'MW', 'en', 'mw-en', 'English, Chichewa', 'MWK', '+265', '🇲🇼', 'U+1F1F1 U+', 'E1 94 FC', 'mw_flag.png', 'UTC+2', 'Africa', 0, '1964-07-06', NULL, NULL, 'path_to_svg', 'Lilongwe', -13.9631000, 33.7741000, 13600000, 0, 0, 'Malawi IP Range', 115, 8),
(298, 'Maldives', 'ދިވެހިރާއްޖޭގެ', 'Dhivehi', 'ދިވެހި', 'MV', 'dv', 'MV', 'dv', 'mv-dv', 'Dhivehi', 'MVR', '+960', '🇲🇻', 'U+1F1F2 U+', 'E1 94 FB', 'mv_flag.png', 'UTC+5', 'Asia', 0, '1965-07-26', NULL, NULL, 'path_to_svg', 'Malé', 4.1755000, 73.5093000, 396334, 0, 0, 'Maldives IP Range', 1321, 32),
(299, 'Malaysia', 'Malaysia', 'Malay', 'Bahasa Melayu', 'MY', 'ms', 'MY', 'ms', 'my-ms', 'Malay', 'MYR', '+60', '🇲🇾', 'U+1F1F2 U+', 'E1 94 FE', 'my_flag.png', 'UTC+8', 'Asia', 0, '1957-08-31', NULL, NULL, 'path_to_svg', 'Kuala Lumpur', 3.1390000, 101.6869000, 27730000, 0, 0, 'Malaysia IP Range', 83, 16),
(300, 'Mali', 'Mali', 'French', 'Français', 'ML', 'fr', 'ML', 'fr', 'ml-fr', 'French', 'XOF', '+223', '🇲🇱', 'U+1F1F2 U+', 'E1 94 F1', 'ml_flag.png', 'UTC+0', 'Africa', 0, '1960-09-22', NULL, NULL, 'path_to_svg', 'Bamako', 12.6392000, -8.0029000, 12666987, 0, 0, 'Mali IP Range', 10, 12),
(301, 'Malta', 'Malta', 'Maltese', 'Malti', 'MT', 'mt', 'MT', 'mt', 'mt-mt', 'Maltese, English', 'EUR', '+356', '🇲🇹', 'U+1F1F1 U+', 'E1 94 F9', 'mt_flag.png', 'UTC+1', 'Europe', 0, '1964-09-21', NULL, NULL, 'path_to_svg', 'Valletta', 35.8997000, 14.5146000, 403532, 0, 0, 'Malta IP Range', 1277, 6),
(302, 'Morocco', 'المغرب', 'Arabic', 'العربية', 'MA', 'ar', 'MA', 'ar', 'ma-ar', 'Arabic, Berber', 'MAD', '+212', '🇲🇦', 'U+1F1F2 U+', 'E1 94 E6', 'ma_flag.png', 'UTC+1', 'Africa', 0, '1956-03-02', NULL, NULL, 'path_to_svg', 'Rabat', 34.0209000, -6.8416000, 34859364, 0, 0, 'Morocco IP Range', 78, 15),
(303, 'Mauritania', 'موريتانيا', 'Arabic', 'العربية', 'MR', 'ar', 'MR', 'ar', 'mr-ar', 'Arabic', 'MRU', '+222', '🇲🇷', 'U+1F1F2 U+', 'E1 94 F7', 'mr_flag.png', 'UTC+0', 'Africa', 0, '1960-11-28', NULL, NULL, 'path_to_svg', 'Nouakchott', 18.0735000, -15.9582000, 3250000, 0, 0, 'Mauritania IP Range', 3, 37),
(304, 'Mauritius', 'Maurice', 'French', 'Français', 'MU', 'fr', 'MU', 'fr', 'mu-fr', 'French, English', 'MUR', '+230', '🇲🇺', 'U+1F1F2 U+', 'E1 94 FA', 'mu_flag.png', 'UTC+4', 'Africa', 0, '1968-03-12', NULL, NULL, 'path_to_svg', 'Port Louis', -20.1609000, 57.5012000, 1230602, 0, 0, 'Mauritius IP Range', 601, 18),
(305, 'Mexico', 'México', 'Spanish', 'Español', 'MX', 'es', 'MX', 'es', 'mx-es', 'Spanish', 'MXN', '+52', '🇲🇽', 'U+1F1F2 U+', 'E1 94 FD', 'mx_flag.png', 'UTC-6', 'North America', 0, '1821-09-16', NULL, NULL, 'path_to_svg', 'Mexico City', 19.4326000, -99.1332000, 112336538, 0, 0, 'Mexico IP Range', 57, 33),
(306, 'Micronesia', 'Micronesia', 'English', 'English', 'FM', 'en', 'FM', 'en', 'fm-en', 'English', 'USD', '+691', '🇫🇲', 'U+1F1F2 U+', 'E1 94 F2', 'fm_flag.png', 'UTC+10', 'Oceania', 0, '1986-11-03', NULL, NULL, 'path_to_svg', 'Palikir', 6.9177000, 158.1856000, 135000, 0, 0, 'Micronesia IP Range', 171, 20),
(307, 'Myanmar', 'မြန်မာ', 'Burmese', 'ဗမာစာ', 'MM', 'my', 'MM', 'my', 'mm-my', 'Burmese', 'MMK', '+95', '🇲🇲', 'U+1F1F2 U+', 'E1 94 F2', 'mm_flag.png', 'UTC+6:30', 'Asia', 0, '1948-01-04', NULL, NULL, 'path_to_svg', 'Naypyidaw', 19.7633000, 96.0785000, 53414374, 0, 0, 'Myanmar IP Range', 79, 15),
(308, 'Moldova', 'Moldova', 'Romanian', 'Română', 'MD', 'ro', 'MD', 'ro', 'md-ro', 'Romanian', 'MDL', '+373', '🇲🇩', 'U+1F1F2 U+', 'E1 94 E9', 'md_flag.png', 'UTC+2', 'Europe', 0, '1991-08-27', NULL, NULL, 'path_to_svg', 'Chisinau', 47.0105000, 28.8638000, 4324450, 0, 0, 'Moldova IP Range', 128, 36),
(309, 'Monaco', 'Monaco', 'French', 'Français', 'MC', 'fr', 'MC', 'fr', 'mc-fr', 'French', 'EUR', '+377', '🇲🇨', 'U+1F1F2 U+', 'E1 94 E8', 'mc_flag.png', 'UTC+1', 'Europe', 0, '1297-01-08', NULL, NULL, 'path_to_svg', 'Monaco', 43.7384000, 7.4246000, 32796, 0, 0, 'Monaco IP Range', 16818, 39),
(310, 'Mongolia', 'Монгол Улс', 'Mongolian', 'Монгол', 'MN', 'mn', 'MN', 'mn', 'mn-mn', 'Mongolian', 'MNT', '+976', '🇲🇳', 'U+1F1F2 U+', 'E1 94 F3', 'mn_flag.png', 'UTC+8', 'Asia', 0, '1921-07-11', NULL, NULL, 'path_to_svg', 'Ulaanbaatar', 47.8864000, 106.9057000, 2736800, 0, 0, 'Mongolia IP Range', 2, 26),
(311, 'Mozambique', 'Moçambique', 'Portuguese', 'Português', 'MZ', 'pt', 'MZ', 'pt', 'mz-pt', 'Portuguese', 'MZN', '+258', '🇲🇿', 'U+1F1F2 U+', 'E1 94 FF', 'mz_flag.png', 'UTC+2', 'Africa', 0, '1975-06-25', NULL, NULL, 'path_to_svg', 'Maputo', -25.9686000, 32.5804000, 21000000, 0, 0, 'Mozambique IP Range', 26, 28),
(312, 'Namibia', 'Namibia', 'English', 'English', 'NA', 'en', 'NA', 'en', 'na-en', 'English', 'NAD', '+264', '🇳🇦', 'U+1F1F2 U+', 'E1 94 E6', 'na_flag.png', 'UTC+2', 'Africa', 0, '1990-03-21', NULL, NULL, 'path_to_svg', 'Windhoek', -22.5597000, 17.0832000, 2089000, 0, 0, 'Namibia IP Range', 2, 17),
(313, 'Nauru', 'Nauru', 'Nauruan', 'Nauruan', 'NR', 'na', 'NR', 'na', 'nr-na', 'Nauruan, English', 'AUD', '+674', '🇳🇷', 'U+1F1F3 U+', 'E1 94 F7', 'nr_flag.png', 'UTC+12', 'Oceania', 0, '1968-01-31', NULL, NULL, 'path_to_svg', 'Yaren', -0.5477000, 166.9209000, 14019, 0, 0, 'Nauru IP Range', 621, 30),
(314, 'Nepal', 'नेपाल', 'Nepali', 'नेपाली', 'NP', 'ne', 'NP', 'ne', 'np-ne', 'Nepali', 'NPR', '+977', '🇳🇵', 'U+1F1F3 U+', 'E1 94 F5', 'np_flag.png', 'UTC+5:45', 'Asia', 0, '1768-09-25', NULL, NULL, 'path_to_svg', 'Kathmandu', 27.7172000, 85.3240000, 28635000, 0, 0, 'Nepal IP Range', 203, 10),
(315, 'Germany', 'Deutschland', 'German', 'Deutsch', 'DE', 'de', 'DE', 'de', 'de-de', 'German', 'EUR', '+49', '🇩🇪', 'U+1F1E9 U+', 'E1 94 EA', 'de_flag.png', 'UTC+1', 'Europe', 0, '1871-01-18', NULL, NULL, 'path_to_svg', 'Berlin', 52.5200000, 13.4050000, 81772000, 0, 0, 'Germany IP Range', 229, 3),
(316, 'Niger', 'Niger', 'French', 'Français', 'NE', 'fr', 'NE', 'fr', 'ne-fr', 'French', 'XOF', '+227', '🇳🇪', 'U+1F1F3 U+', 'E1 94 EA', 'ne_flag.png', 'UTC+1', 'Africa', 0, '1960-08-03', NULL, NULL, 'path_to_svg', 'Niamey', 13.5116000, 2.1254000, 15306252, 0, 0, 'Niger IP Range', 12, 45),
(317, 'Nigeria', 'Nigeria', 'English', 'English', 'NG', 'en', 'NG', 'en', 'ng-en', 'English', 'NGN', '+234', '🇳🇬', 'U+1F1F3 U+', 'E1 94 EC', 'ng_flag.png', 'UTC+1', 'Africa', 0, '1960-10-01', NULL, NULL, 'path_to_svg', 'Abuja', 9.0765000, 7.3986000, 154729000, 0, 0, 'Nigeria IP Range', 168, 18),
(318, 'Nicaragua', 'Nicaragua', 'Spanish', 'Español', 'NI', 'es', 'NI', 'es', 'ni-es', 'Spanish', 'NIO', '+505', '🇳🇮', 'U+1F1F3 U+', 'E1 94 EE', 'ni_flag.png', 'UTC-6', 'North America', 0, '1821-09-15', NULL, NULL, 'path_to_svg', 'Managua', 12.1364000, -86.2514000, 5570000, 0, 0, 'Nicaragua IP Range', 43, 38),
(319, 'Norway', 'Norge', 'Norwegian', 'Norsk', 'NO', 'no', 'NO', 'no', 'no-no', 'Norwegian', 'NOK', '+47', '🇳🇴', 'U+1F1F3 U+', 'E1 94 F4', 'no_flag.png', 'UTC+1', 'Europe', 0, '1905-06-07', NULL, NULL, 'path_to_svg', 'Oslo', 59.9139000, 10.7522000, 4769000, 0, 0, 'Norway IP Range', 15, 5),
(320, 'New Zealand', 'New Zealand', 'English', 'English', 'NZ', 'en', 'NZ', 'en', 'nz-en', 'English, Māori', 'NZD', '+64', '🇳🇿', 'U+1F1F3 U+', 'E1 94 FF', 'nz_flag.png', 'UTC+12', 'Oceania', 0, '1907-09-26', NULL, NULL, 'path_to_svg', 'Wellington', -41.2865000, 174.7762000, 4393500, 0, 0, 'New Zealand IP Range', 16, 8),
(321, 'Oman', 'عمان', 'Arabic', 'العربية', 'OM', 'ar', 'OM', 'ar', 'om-ar', 'Arabic', 'OMR', '+968', '🇴🇲', 'U+1F1F4 U+', 'E1 94 F2', 'om_flag.png', 'UTC+4', 'Asia', 0, '1970-07-23', NULL, NULL, 'path_to_svg', 'Muscat', 23.5880000, 58.3829000, 3312000, 0, 0, 'Oman IP Range', 11, 40),
(322, 'Pakistan', 'پاکستان', 'Urdu', 'اردو', 'PK', 'ur', 'PK', 'ur', 'pk-ur', 'Urdu, English', 'PKR', '+92', '🇵🇰', 'U+1F1F5 U+', 'E1 94 F0', 'pk_flag.png', 'UTC+5', 'Asia', 0, '1947-08-14', NULL, NULL, 'path_to_svg', 'Islamabad', 33.6844000, 73.0479000, 176242949, 0, 0, 'Pakistan IP Range', 219, 7),
(323, 'Palau', 'Palau', 'English', 'English', 'PW', 'en', 'PW', 'en', 'pw-en', 'English, Palauan', 'USD', '+680', '🇵🇼', 'U+1F1F5 U+', 'E1 94 FC', 'pw_flag.png', 'UTC+9', 'Oceania', 0, '1994-10-01', NULL, NULL, 'path_to_svg', 'Ngerulmud', 7.5000000, 134.6242000, 20800, 0, 0, 'Palau IP Range', 44, 12),
(324, 'Panama', 'Panamá', 'Spanish', 'Español', 'PA', 'es', 'PA', 'es', 'pa-es', 'Spanish', 'PAB', '+507', '🇵🇦', 'U+1F1F5 U+', 'E1 94 E6', 'pa_flag.png', 'UTC-5', 'North America', 0, '1903-11-03', NULL, NULL, 'path_to_svg', 'Panama City', 8.9824000, -79.5199000, 3293000, 0, 0, 'Panama IP Range', 42, 35),
(325, 'Papua New Guinea', 'Papua New Guinea', 'English', 'English', 'PG', 'en', 'PG', 'en', 'pg-en', 'English, Tok Pisin, Hiri Motu', 'PGK', '+675', '🇵🇬', 'U+1F1F5 U+', 'E1 94 EC', 'pg_flag.png', 'UTC+10', 'Oceania', 0, '1975-09-16', NULL, NULL, 'path_to_svg', 'Port Moresby', -9.4438000, 147.1803000, 5932000, 0, 0, 'Papua New Guinea IP Range', 13, 23),
(326, 'Paraguay', 'Paraguay', 'Spanish', 'Español', 'PY', 'es', 'PY', 'es', 'py-es', 'Spanish, Guarani', 'PYG', '+595', '🇵🇾', 'U+1F1F5 U+', 'E1 94 FE', 'py_flag.png', 'UTC-4', 'South America', 0, '1811-05-14', NULL, NULL, 'path_to_svg', 'Asunción', -25.2637000, -57.5759000, 6670000, 0, 0, 'Paraguay IP Range', 16, 21),
(327, 'Peru', 'Perú', 'Spanish', 'Español', 'PE', 'es', 'PE', 'es', 'pe-es', 'Spanish, Quechua', 'PEN', '+51', '🇵🇪', 'U+1F1F5 U+', 'E1 94 EA', 'pe_flag.png', 'UTC-5', 'South America', 0, '1821-07-28', NULL, NULL, 'path_to_svg', 'Lima', -12.0464000, -77.0428000, 29181000, 0, 0, 'Peru IP Range', 23, 9),
(328, 'Poland', 'Polska', 'Polish', 'Polski', 'PL', 'pl', 'PL', 'pl', 'pl-pl', 'Polish', 'PLN', '+48', '🇵🇱', 'U+1F1F5 U+', 'E1 94 F1', 'pl_flag.png', 'UTC+1', 'Europe', 0, '1918-11-11', NULL, NULL, 'path_to_svg', 'Warsaw', 52.2297000, 21.0122000, 38200037, 0, 0, 'Poland IP Range', 121, 4),
(329, 'South Africa', 'South Africa', 'Afrikaans', 'Afrikaans', 'ZA', 'af', 'ZA', 'af', 'za-af', 'Afrikaans, English', 'ZAR', '+27', '🇿🇦', 'U+1F1FF U+', 'E1 94 E6', 'za_flag.png', 'UTC+2', 'Africa', 0, '1910-05-31', NULL, NULL, 'path_to_svg', 'Pretoria', -25.7461000, 28.1881000, 48783000, 0, 0, 'South Africa IP Range', 40, 20),
(330, 'Portugal', 'Portugal', 'Portuguese', 'Português', 'PT', 'pt', 'PT', 'pt', 'pt-pt', 'Portuguese', 'EUR', '+351', '🇵🇹', 'U+1F1F5 U+', 'E1 94 F9', 'pt_flag.png', 'UTC+0', 'Europe', 0, '1143-10-05', NULL, NULL, 'path_to_svg', 'Lisbon', 38.7223000, -9.1393000, 10677000, 0, 0, 'Portugal IP Range', 116, 17),
(331, 'Central African Republic', 'République centrafricaine', 'French', 'Français', 'CF', 'fr', 'CF', 'fr', 'cf-fr', 'French', 'XAF', '+236', '🇨🇫', 'U+1F1E8 U+', 'E1 94 EB', 'cf_flag.png', 'UTC+1', 'Africa', 0, '1960-08-13', NULL, NULL, 'path_to_svg', 'Bangui', 4.3947000, 18.5582000, 4370000, 0, 0, 'CAR IP Range', 7, 46),
(332, 'Cape Verde', 'Cabo Verde', 'Portuguese', 'Português', 'CV', 'pt', 'CV', 'pt', 'cv-pt', 'Portuguese', 'CVE', '+238', '🇨🇻', 'U+1F1E8 U+', 'E1 94 FB', 'cv_flag.png', 'UTC-1', 'Africa', 0, '1975-07-05', NULL, NULL, 'path_to_svg', 'Praia', 14.9330000, -23.5133000, 499796, 0, 0, 'Cape Verde IP Range', 118, 43),
(333, 'Russia', 'Россия', 'Russian', 'Русский', 'RU', 'ru', 'RUS', 'rus', 'ru', 'Russian', 'Ruble', '+7', 'RU.png', '🇷🇺', 'U+1F1F7 U+', 'https://upload.wikimedia.org/wikipedia/commons/f/f3/Flag_of_Russia.svg', 'GMT+3', 'Asia, Europe', 0, NULL, NULL, NULL, NULL, 'Moscow', 55.7558000, 37.6173000, 142914136, 600, 0, NULL, 8, 1),
(334, 'Romania', 'România', 'Romanian', 'Română', 'RO', 'ro', 'ROU', 'ron', 'ro', 'Romanian', 'Leu', '+40', 'RO.png', '🇷🇴', 'U+1F1F7 U+', 'https://upload.wikimedia.org/wikipedia/commons/9/9c/Flag_of_Romania.svg', 'GMT+2', 'Europe', 0, '1866-12-01', NULL, NULL, NULL, 'Bucharest', 44.4268000, 26.1025000, 22215421, 100, 0, NULL, 91, 41),
(335, 'Rwanda', 'Rwanda', 'Kinyarwanda', 'Ikinyarwanda', 'RW', 'rw', 'RWA', 'kin', 'rw', 'Kinyarwanda, French, English', 'Rwandan franc', '+250', 'RW.png', '🇷🇼', 'U+1F1F7 U+', 'https://upload.wikimedia.org/wikipedia/commons/1/17/Flag_of_Rwanda.svg', 'GMT+2', 'Africa', 0, NULL, NULL, NULL, NULL, 'Kigali', -1.9706000, 30.1044000, 10186000, 1470, 0, NULL, 387, 136),
(336, 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 'English', 'English', 'KN', 'en', 'KNA', 'eng', 'kn', 'English', 'East Caribbean dollar', '+1 869', 'KN.png', '🇰🇳', 'U+1F1F0 U+', 'https://upload.wikimedia.org/wikipedia/commons/f/f9/Flag_of_Saint_Kitts_and_Nevis.svg', 'GMT-4', 'North America', 0, NULL, NULL, NULL, NULL, 'Basseterre', 17.3026000, -62.7177000, 38819, 0, 0, NULL, 149, 197),
(337, 'Saint Lucia', 'Saint Lucia', 'English', 'English', 'LC', 'en', 'LCA', 'eng', 'lc', 'English', 'East Caribbean dollar', '+1 758', 'LC.png', '🇱🇨', 'U+1F1F1 U+', 'https://upload.wikimedia.org/wikipedia/commons/e/e7/Flag_of_Saint_Lucia.svg', 'GMT-4', 'North America', 0, NULL, NULL, NULL, NULL, 'Castries', 13.9928000, -61.0938000, 164213, 0, 0, NULL, 267, 183),
(338, 'Saint Vincent and the Grenadines', 'Saint Vincent i Grenadyny', 'English', 'English', 'VC', 'en', 'VCT', 'eng', 'vc', 'English', 'East Caribbean dollar', '+1 784', 'VC.png', '🇻🇨', 'U+1F1FB U+', 'https://upload.wikimedia.org/wikipedia/commons/d/d0/Flag_of_Saint_Vincent_and_the_Grenadines.svg', 'GMT-4', 'North America', 0, NULL, NULL, NULL, NULL, 'Kingstown', 13.1570000, -61.2248000, 119000, 0, 0, NULL, 307, 195),
(339, 'El Salvador', 'El Salvador', 'Spanish', 'Español', 'SV', 'es', 'SLV', 'spa', 'sv', 'Spanish', 'United States dollar', '+503', 'SV.png', '🇸🇻', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/0/0b/Flag_of_El_Salvador.svg', 'GMT-6', 'North America', 0, '1821-09-15', NULL, NULL, NULL, 'San Salvador', 13.6773000, -89.2182000, 6820000, 600, 0, NULL, 324, 130),
(340, 'Samoa', 'Samoa', 'Samoan', 'Sāmoan', 'WS', 'sm', 'WSM', 'smo', 'ws', 'Samoan, English', 'Tala', '+685', 'WS.png', '🇼🇸', 'U+1F1FC U+', 'https://upload.wikimedia.org/wikipedia/commons/d/d0/Flag_of_Samoa.svg', 'GMT+13', 'Oceania', 0, NULL, NULL, NULL, NULL, 'Apia', -13.8333000, -171.5500000, 177714, 0, 0, NULL, 60, 207);
INSERT INTO `countries` (`id`, `country_name_english`, `country_name_local`, `language_english`, `language_local`, `country_code`, `language_code`, `iso_country_code`, `iso_language_code`, `web_country_language`, `official_languages`, `currency`, `calling_code`, `iso_flag`, `unicode_flag`, `utf8_flag`, `flag_image_url`, `timezone`, `continent`, `in_eu`, `country_foundation_date`, `reappearance_dates`, `removal_dates`, `svg_country_shape`, `capital`, `latitude`, `longitude`, `population`, `average_elevation`, `has_ocean_access`, `ip_range`, `income_rank`, `population_rank`) VALUES
(341, 'San Marino', 'San Marino', 'Italian', 'Italiano', 'SM', 'it', 'SMR', 'ita', 'sm', 'Italian', 'Euro', '+378', 'SM.png', '🇸🇲', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/4/4c/Flag_of_San_Marino.svg', 'GMT+1', 'Europe', 0, NULL, NULL, NULL, NULL, 'San Marino', 43.9333000, 12.4460000, 31817, 0, 0, NULL, 487, 200),
(342, 'Senegal', 'Sénégal', 'French', 'Français', 'SN', 'fr', 'SEN', 'fra', 'sn', 'French', 'CFA franc', '+221', 'SN.png', '🇸🇳', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/f/fc/Flag_of_Senegal.svg', 'GMT', 'Africa', 0, NULL, NULL, NULL, NULL, 'Dakar', 14.6928000, -17.4467000, 12521851, 0, 0, NULL, 64, 67),
(343, 'Serbia', 'Србија', 'Serbian', 'Српски', 'RS', 'sr', 'SRB', 'srp', 'rs', 'Serbian', 'Serbian dinar', '+381', 'RS.png', '🇷🇸', 'U+1F1F7 U+', 'https://upload.wikimedia.org/wikipedia/commons/f/ff/Flag_of_Serbia.svg', 'GMT+1', 'Europe', 0, NULL, NULL, NULL, NULL, 'Belgrade', 44.7866000, 20.4489000, 7498001, 0, 0, NULL, 95, 92),
(344, 'Seychelles', 'Seychelles', 'French', 'Français', 'SC', 'fr', 'SYC', 'fra', 'sc', 'French, English, Seychellois Creole', 'Seychellois rupee', '+248', 'SC.png', '🇸🇨', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/f/fc/Flag_of_Seychelles.svg', 'GMT+4', 'Africa', 0, NULL, NULL, NULL, NULL, 'Victoria', -4.6167000, 55.4500000, 86525, 0, 0, NULL, 190, 175),
(345, 'Sierra Leone', 'Sierra Leone', 'English', 'English', 'SL', 'en', 'SLE', 'eng', 'sl', 'English', 'Leone', '+232', 'SL.png', '🇸🇱', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/0/0d/Flag_of_Sierra_Leone.svg', 'GMT', 'Africa', 0, NULL, NULL, NULL, NULL, 'Freetown', 8.4657000, -13.2295000, 6150000, 0, 0, NULL, 86, 83),
(346, 'Singapore', 'Singapore', 'English', 'English', 'SG', 'en', 'SGP', 'eng', 'sg', 'English, Malay, Mandarin, Tamil', 'Singapore dollar', '+65', 'SG.png', '🇸🇬', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/4/4e/Flag_of_Singapore.svg', 'GMT+8', 'Asia', 0, NULL, NULL, NULL, NULL, 'Singapore', 1.3521000, 103.8198000, 4608000, 15, 0, NULL, 6652, 112),
(347, 'Slovakia', 'Slovensko', 'Slovak', 'Slovenčina', 'SK', 'sk', 'SVK', 'slk', 'sk', 'Slovak', 'Euro', '+421', 'SK.png', '🇸🇰', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/b/b9/Flag_of_Slovakia.svg', 'GMT+1', 'Europe', 0, NULL, NULL, NULL, NULL, 'Bratislava', 48.1482000, 17.1067000, 5455000, 0, 0, NULL, 111, 91),
(348, 'Slovenia', 'Slovenija', 'Slovene', 'Slovenščina', 'SI', 'sl', 'SVN', 'slv', 'si', 'Slovene', 'Euro', '+386', 'SI.png', '🇸🇮', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/f/f0/Flag_of_Slovenia.svg', 'GMT+1', 'Europe', 0, NULL, NULL, NULL, NULL, 'Ljubljana', 46.0569000, 14.5051000, 2039399, 0, 0, NULL, 99, 112),
(349, 'Somalia', 'Soomaaliya', 'Somali', 'Soomaali', 'SO', 'so', 'SOM', 'som', 'so', 'Somali, Arabic', 'Somali shilling', '+252', 'SO.png', '🇸🇴', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/3/3d/Flag_of_Somalia.svg', 'GMT+3', 'Africa', 0, NULL, NULL, NULL, NULL, 'Mogadishu', 2.0469000, 45.3182000, 9559000, 0, 0, NULL, 15, 57),
(350, 'Sri Lanka', 'ශ්‍රී ලංකා', 'Sinhalese', 'සිංහල', 'LK', 'si', 'LKA', 'sin', 'lk', 'Sinhalese, Tamil', 'Sri Lankan rupee', '+94', 'LK.png', '🇱🇰', 'U+1F1F1 U+', 'https://upload.wikimedia.org/wikipedia/commons/3/3c/Flag_of_Sri_Lanka.svg', 'GMT+5:30', 'Asia', 0, NULL, NULL, NULL, NULL, 'Sri Jayawardenepura Kotte', 6.9271000, 79.9585000, 20010000, 0, 0, NULL, 320, 36),
(351, 'United States', 'United States', 'English', 'English', 'US', 'en', 'USA', 'eng', 'us', 'English', 'United States dollar', '+1', 'US.png', '🇺🇸', 'U+1F1FA U+', 'https://upload.wikimedia.org/wikipedia/commons/a/a4/Flag_of_the_United_States.svg', 'GMT-5', 'North America', 0, NULL, NULL, NULL, NULL, 'Washington, D.C.', 38.9072000, -77.0369000, 311280492, 0, 0, NULL, 32, 3),
(352, 'Sudan', 'السودان', 'Arabic', 'العربية', 'SD', 'ar', 'SDN', 'ara', 'sd', 'Arabic', 'Sudanese pound', '+249', 'SD.png', '🇸🇩', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/5/5c/Flag_of_Sudan.svg', 'GMT+2', 'Africa', 0, NULL, NULL, NULL, NULL, 'Khartoum', 15.5000000, 32.5599000, 30894000, 0, 0, NULL, 16, 65),
(353, 'South Sudan', 'جنوب السودان', 'English', 'الإنجليزية', 'SS', 'en', 'SSD', 'eng', 'ss', 'English', 'South Sudanese pound', '+211', 'SS.png', '🇸🇸', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/2/29/Flag_of_South_Sudan.svg', 'GMT+3', 'Africa', 0, '2011-07-09', NULL, NULL, NULL, 'Juba', 4.8517000, 31.5820000, 8260490, 0, 0, NULL, NULL, 166),
(354, 'Suriname', 'Suriname', 'Dutch', 'Nederlands', 'SR', 'nl', 'SUR', 'nld', 'sr', 'Dutch', 'Surinamese dollar', '+597', 'SR.png', '🇸🇷', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/6/60/Flag_of_Suriname.svg', 'GMT-3', 'South America', 0, NULL, NULL, NULL, NULL, 'Paramaribo', 5.8664000, -55.1724000, 476000, 0, 0, NULL, 3, 177),
(355, 'Syria', 'سوريا', 'Arabic', 'العربية', 'SY', 'ar', 'SYR', 'ara', 'sy', 'Arabic', 'Syrian pound', '+963', 'SY.png', '🇸🇾', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/6/65/Flag_of_Syria.svg', 'GMT+2', 'Asia', 0, NULL, NULL, NULL, NULL, 'Damascus', 33.5138000, 36.2765000, 19748000, 0, 0, NULL, 107, 57),
(356, 'Switzerland', 'Schweiz', 'German, French, Italian', 'Deutsch, Français, Italiano', 'CH', 'de, fr, it', 'CHE', 'deu', 'ch', 'German, French, Italian', 'Swiss franc', '+41', 'CH.png', '🇨🇭', 'U+1F1E8 U+', 'https://upload.wikimedia.org/wikipedia/commons/8/89/Flag_of_Switzerland.svg', 'GMT+1', 'Europe', 0, NULL, NULL, NULL, NULL, 'Bern', 46.8182000, 8.2275000, 7725200, 0, 0, NULL, 186, 96),
(357, 'Sweden', 'Sverige', 'Swedish', 'Svenska', 'SE', 'sv', 'SWE', 'swe', 'se', 'Swedish', 'Swedish krona', '+46', 'SE.png', '🇸🇪', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/4/4c/Flag_of_Sweden.svg', 'GMT+1', 'Europe', 0, NULL, NULL, NULL, NULL, 'Stockholm', 59.3293000, 18.0686000, 9331523, 0, 0, NULL, 20, 88),
(358, 'Tajikistan', 'Тоҷикистон', 'Tajik', 'Тоҷикӣ', 'TJ', 'tg', 'TJK', 'tgk', 'tj', 'Tajik', 'Somoni', '+992', 'TJ.png', '🇹🇯', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/d/d5/Flag_of_Tajikistan.svg', 'GMT+5', 'Asia', 0, NULL, NULL, NULL, NULL, 'Dushanbe', 38.5594000, 68.7870000, 7100000, 0, 0, NULL, 50, 135),
(359, 'Thailand', 'ประเทศไทย', 'Thai', 'ไทย', 'TH', 'th', 'THA', 'tha', 'th', 'Thai', 'Baht', '+66', 'TH.png', '🇹🇭', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/a/a9/Flag_of_Thailand.svg', 'GMT+7', 'Asia', 0, NULL, NULL, NULL, NULL, 'Bangkok', 13.7563000, 100.5018000, 65493000, 0, 0, NULL, 127, 20),
(360, 'Tanzania', 'Tanzania', 'Swahili', 'Kiswahili', 'TZ', 'sw', 'TZA', 'swa', 'tz', 'Swahili, English', 'Tanzanian shilling', '+255', 'TZ.png', '🇹🇿', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/3/38/Flag_of_Tanzania.svg', 'GMT+3', 'Africa', 0, NULL, NULL, NULL, NULL, 'Dodoma', -6.7924000, 39.2083000, 39384223, 0, 0, NULL, 42, 24),
(361, 'East Timor', 'Timor-Leste', 'Tetum, Portuguese', 'Tetum, Português', 'TL', 'tet, pt', 'TLS', 'tet', 'tl', 'Tetum, Portuguese', 'United States dollar', '+670', 'TL.png', '🇹🇱', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/5/5c/Flag_of_East_Timor.svg', 'GMT+9', 'Asia', 0, NULL, NULL, NULL, NULL, 'Dili', -8.5569000, 125.5603000, 1109000, 0, 0, NULL, 74, 173),
(362, 'Togo', 'Togo', 'French', 'Français', 'TG', 'fr', 'TGO', 'fra', 'tg', 'French', 'West African CFA franc', '+228', 'TG.png', '🇹🇬', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/1/19/Flag_of_Togo.svg', 'GMT', 'Africa', 0, NULL, NULL, NULL, NULL, 'Lomé', 6.1319000, 1.2223000, 5400000, 0, 0, NULL, 95, 107),
(363, 'Tonga', 'Tonga', 'Tongan', 'Tonga', 'TO', 'to', 'TON', 'ton', 'to', 'Tongan, English', 'Tongan paʻanga', '+676', 'TO.png', '🇹🇴', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/2/2c/Flag_of_Tonga.svg', 'GMT+13', 'Oceania', 0, NULL, NULL, NULL, NULL, 'Nukuʻalofa', -21.1399000, -175.2048000, 119009, 0, 0, NULL, 144, 210),
(364, 'Trinidad and Tobago', 'Trinidad i Tobago', 'English', 'English', 'TT', 'en', 'TTO', 'eng', 'tt', 'English', 'Trinidad and Tobago dollar', '+1 868', 'TT.png', '🇹🇹', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/2/28/Flag_of_Trinidad_and_Tobago.svg', 'GMT-4', 'South America', 0, NULL, NULL, NULL, NULL, 'Port-of-Spain', 10.6528000, -61.5091000, 1229000, 0, 0, NULL, 206, 157),
(365, 'Tunisia', 'تونس', 'Arabic', 'العربية', 'TN', 'ar', 'TUN', 'ara', 'tn', 'Arabic', 'Tunisian dinar', '+216', 'TN.png', '🇹🇳', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/f/f9/Flag_of_Tunisia.svg', 'GMT+1', 'Africa', 0, NULL, NULL, NULL, NULL, 'Tunis', 33.8869000, 9.5375000, 10384000, 0, 0, NULL, 64, 71),
(366, 'Turkey', 'Türkiye', 'Turkish', 'Türkçe', 'TR', 'tr', 'TUR', 'tur', 'tr', 'Turkish', 'Turkish lira', '+90', 'TR.png', '🇹🇷', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/b/b4/Flag_of_Turkey.svg', 'GMT+3', 'Asia', 0, NULL, NULL, NULL, NULL, 'Ankara', 39.9334000, 32.8597000, 77804122, 0, 0, NULL, 92, 17),
(367, 'Turkmenistan', 'Türkmenistan', 'Turkmen', 'Türkmençe', 'TM', 'tk', 'TKM', 'tuk', 'tm', 'Turkmen', 'Turkmenistan manat', '+993', 'TM.png', '🇹🇲', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/1/1e/Flag_of_Turkmenistan.svg', 'GMT+5', 'Asia', 0, NULL, NULL, NULL, NULL, 'Ashgabat', 39.0044000, 58.9690000, 5180000, 0, 0, NULL, 11, 134),
(368, 'Tuvalu', 'Tuvalu', 'Tuvaluan, English', 'Te Tavalu, English', 'TV', 'tv, en', 'TUV', 'tvl', 'tv', 'Tuvaluan, English', 'Australian dollar', '+688', 'TV.png', '🇹🇻', 'U+1F1F9 U+', 'https://upload.wikimedia.org/wikipedia/commons/b/b8/Flag_of_Tuvalu.svg', 'GMT+12', 'Oceania', 0, NULL, NULL, NULL, NULL, 'Funafuti', -7.1095000, 179.1945000, 12373, 0, 0, NULL, 476, 195),
(369, 'Uganda', 'Uganda', 'English', 'English', 'UG', 'en', 'UGA', 'eng', 'ug', 'English, Swahili', 'Ugandan shilling', '+256', 'UG.png', '🇺🇬', 'U+1F1FA U+', 'https://upload.wikimedia.org/wikipedia/commons/4/4e/Flag_of_Uganda.svg', 'GMT+3', 'Africa', 0, NULL, NULL, NULL, NULL, 'Kampala', -1.2864000, 32.5822000, 32369558, 0, 0, NULL, 136, 44),
(370, 'Ukraine', 'Україна', 'Ukrainian', 'Українська', 'UA', 'uk', 'UKR', 'ukr', 'ua', 'Ukrainian', 'Hryvnia', '+380', 'UA.png', '🇺🇦', 'U+1F1FA U+', 'https://upload.wikimedia.org/wikipedia/commons/4/49/Flag_of_Ukraine.svg', 'GMT+2', 'Europe', 0, NULL, NULL, NULL, NULL, 'Kyiv', 50.4501000, 30.5234000, 45706126, 0, 0, NULL, 77, 50),
(371, 'Uruguay', 'Uruguay', 'Spanish', 'Español', 'UY', 'es', 'URY', 'spa', 'uy', 'Spanish', 'Uruguayan peso', '+598', 'UY.png', '🇺🇾', 'U+1F1FA U+', 'https://upload.wikimedia.org/wikipedia/commons/f/fe/Flag_of_Uruguay.svg', 'GMT-3', 'South America', 0, NULL, NULL, NULL, NULL, 'Montevideo', -34.9011000, -56.1645000, 3477779, 0, 0, NULL, 20, 123),
(372, 'Uzbekistan', 'Oʻzbekiston', 'Uzbek', 'Oʻzbek', 'UZ', 'uz', 'UZB', 'uzb', 'uz', 'Uzbek', 'Uzbekistani som', '+998', 'UZ.png', '🇺🇿', 'U+1F1FA U+', 'https://upload.wikimedia.org/wikipedia/commons/8/8d/Flag_of_Uzbekistan.svg', 'GMT+5', 'Asia', 0, NULL, NULL, NULL, NULL, 'Tashkent', 41.2995000, 69.2401000, 27610000, 0, 0, NULL, 62, 56),
(373, 'Vanuatu', 'Vanuatu', 'Bislama, English, French', 'Bislama, English, Français', 'VU', 'bi, en, fr', 'VUT', 'bis', 'vu', 'Bislama, English, French', 'Vanuatu vatu', '+678', 'VU.png', '🇻🇺', 'U+1F1FB U+', 'https://upload.wikimedia.org/wikipedia/commons/b/b8/Flag_of_Vanuatu.svg', 'GMT+11', 'Oceania', 0, NULL, NULL, NULL, NULL, 'Port Vila', -17.7333000, 168.3226000, 243304, 0, 0, NULL, 20, 182),
(374, 'Vatican City', 'Città del Vaticano', 'Italian', 'Italiano', 'VA', 'it', 'VAT', 'ita', 'va', 'Italian', 'Euro', '+39', 'VA.png', '🇻🇦', 'U+1F1FB U+', 'https://upload.wikimedia.org/wikipedia/commons/0/0f/Flag_of_the_Vatican_City.svg', 'GMT+1', 'Europe', 0, NULL, NULL, NULL, NULL, 'Vatican City', 41.9029000, 12.4534000, 824, 0, 0, NULL, 1873, 201),
(375, 'Venezuela', 'Venezuela', 'Spanish', 'Español', 'VE', 'es', 'VEN', 'spa', 've', 'Spanish', 'Venezuelan bolívar', '+58', 'VE.png', '🇻🇪', 'U+1F1FB U+', 'https://upload.wikimedia.org/wikipedia/commons/0/06/Flag_of_Venezuela.svg', 'GMT-4', 'South America', 0, NULL, NULL, NULL, NULL, 'Caracas', 10.4880000, -66.8983000, 30102382, 0, 0, NULL, 33, 42),
(376, 'Hungary', 'Magyarország', 'Hungarian', 'Magyar', 'HU', 'hu', 'HUN', 'hun', 'hu', 'Hungarian', 'Hungarian forint', '+36', 'HU.png', '🇭🇺', 'U+1F1ED U+', 'https://upload.wikimedia.org/wikipedia/commons/c/c1/Flag_of_Hungary.svg', 'GMT+1', 'Europe', 0, NULL, NULL, NULL, NULL, 'Budapest', 47.4979000, 19.0402000, 9982000, 0, 0, NULL, 107, 60),
(377, 'United Kingdom', 'United Kingdom', 'English', 'English', 'GB', 'en', 'GBR', 'eng', 'gb', 'English', 'Pound sterling', '+44', 'GB.png', '🇬🇧', 'U+1F1EC U+', 'https://upload.wikimedia.org/wikipedia/commons/a/ae/Flag_of_the_United_Kingdom.svg', 'GMT+0', 'Europe', 0, NULL, NULL, NULL, NULL, 'London', 51.5098000, -0.1180000, 62222000, 0, 0, NULL, 254, 23),
(378, 'Vietnam', 'Việt Nam', 'Vietnamese', 'Tiếng Việt', 'VN', 'vi', 'VNM', 'vie', 'vn', 'Vietnamese', 'Vietnamese đồng', '+84', 'VN.png', '🇻🇳', 'U+1F1FB U+', 'https://upload.wikimedia.org/wikipedia/commons/2/21/Flag_of_Vietnam.svg', 'GMT+7', 'Asia', 0, NULL, NULL, NULL, NULL, 'Hanoi', 14.0583000, 108.2772000, 86024600, 0, 0, NULL, 260, 15),
(379, 'Italy', 'Italia', 'Italian', 'Italiano', 'IT', 'it', 'ITA', 'ita', 'it', 'Italian', 'Euro', '+39', 'IT.png', '🇮🇹', 'U+1F1EE U+', 'https://upload.wikimedia.org/wikipedia/commons/0/03/Flag_of_Italy.svg', 'GMT+1', 'Europe', 0, NULL, NULL, NULL, NULL, 'Rome', 41.9028000, 12.4964000, 60418711, 0, 0, NULL, 200, 28),
(380, 'Ivory Coast', 'Côte d\'Ivoire', 'French', 'Français', 'CI', 'fr', 'CIV', 'fra', 'ci', 'French', 'West African CFA franc', '+225', 'CI.png', '🇨🇮', 'U+1F1E8 U+', 'https://upload.wikimedia.org/wikipedia/commons/b/b8/Flag_of_Côte_d\'Ivoire.svg', 'GMT', 'Africa', 0, NULL, NULL, NULL, NULL, 'Yamoussoukro', 6.8276000, -5.2892000, 18373000, 0, 0, NULL, 57, 73),
(381, 'Marshall Islands', 'M̧ajeļ', 'Marshallese, English', 'M̧ajeļ, English', 'MH', 'mh, en', 'MHL', 'mah', 'mh', 'Marshallese, English', 'United States dollar', '+692', 'MH.png', '🇲🇭', 'U+1F1F2 U+', 'https://upload.wikimedia.org/wikipedia/commons/9/9c/Flag_of_the_Marshall_Islands.svg', 'GMT+12', 'Oceania', 0, NULL, NULL, NULL, NULL, 'Majuro', 7.0944000, 171.3833000, 59071, 0, 0, NULL, 326, 183),
(382, 'Solomon Islands', 'Solomon Islands', 'English', 'English', 'SB', 'en', 'SLB', 'eng', 'sb', 'English', 'Solomon Islands dollar', '+677', 'SB.png', '🇸🇧', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/b/bc/Flag_of_the_Solomon_Islands.svg', 'GMT+11', 'Oceania', 0, NULL, NULL, NULL, NULL, 'Honiara', -9.4280000, 160.7020000, 552000, 0, 0, NULL, 20, 194),
(383, 'São Tomé and Príncipe', 'São Tomé e Príncipe', 'Portuguese', 'Português', 'ST', 'pt', 'STP', 'por', 'st', 'Portuguese', 'Dobra', '+239', 'ST.png', '🇸🇹', 'U+1F1F8 U+', 'https://upload.wikimedia.org/wikipedia/commons/4/4a/Flag_of_S%C3%A3o_Tom%C3%A9_and_Pr%C3%ADncipe.svg', 'GMT+0', 'Africa', 0, NULL, NULL, NULL, NULL, 'São Tomé', 0.3350000, 6.7333000, 193410, 0, 0, NULL, 187, 179),
(384, 'Zambia', 'Zambia', 'English', 'English', 'ZM', 'en', 'ZMB', 'eng', 'zm', 'English', 'Zambian kwacha', '+260', 'ZM.png', '🇿🇲', 'U+1F1FF U+', 'https://upload.wikimedia.org/wikipedia/commons/0/0f/Flag_of_Zambia.svg', 'GMT+2', 'Africa', 0, NULL, NULL, NULL, NULL, 'Lusaka', -15.3875000, 28.3228000, 11500000, 0, 0, NULL, 15, 87),
(385, 'Zimbabwe', 'Zimbabwe', 'English', 'English', 'ZW', 'en', 'ZWE', 'eng', 'zw', 'English, Shona, Sindebele', 'Zimbabwean dollar', '+263', 'ZW.png', '🇿🇼', 'U+1F1FF U+', 'https://upload.wikimedia.org/wikipedia/commons/f/f0/Flag_of_Zimbabwe.svg', 'GMT+2', 'Africa', 0, NULL, NULL, NULL, NULL, 'Harare', -17.8292000, 31.0522000, 12383000, 0, 0, NULL, 32, 60),
(386, 'United Arab Emirates', 'الإمارات العربية المتحدة', 'Arabic', 'العربية', 'AE', 'ar', 'ARE', 'ara', 'ae', 'Arabic', 'UAE dirham', '+971', 'AE.png', '🇦🇪', 'U+1F1E6 U+', 'https://upload.wikimedia.org/wikipedia/commons/f/fe/Flag_of_the_United_Arab_Emirates.svg', 'GMT+4', 'Asia', 0, NULL, NULL, NULL, NULL, 'Abu Dhabi', 24.4539000, 54.3773000, 4621000, 0, 0, NULL, 55, 48);

--
-- Indeksy dla zrzutów tabel
--

--
-- Indeksy dla tabeli `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=387;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
