-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: rykfglntimonix.mysql.db
-- Generation Time: Wrz 30, 2024 at 11:21 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),
(42, '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.7942000, -47.8822000, 212559417, 320, 1, '177.32.0.0 - 177.63.255.255', 13, 6),
(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),
(50, 'Canada', 'Canada', 'English', 'English', 'CA', 'EN', 'CAN', 'ENG', 'en-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, 37742157, 487, 1, '24.36.0.0 - 24.36.255.255', 20, 38),
(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),
(54, '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, 1402112000, 60, 1, '1.0.1.0 - 1.0.3.255', 2, 1),
(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),
(69, '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, '1952-06-18', NULL, NULL, '<svg>...</svg>', 'Cairo', 30.0444000, 31.2357000, 104124440, 180, 1, '41.34.0.0 - 41.35.255.255', 85, 14),
(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),
(81, '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, 263, 1, '91.0.0.0 - 91.255.255.255', 4, 19),
(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),
(93, 'India', '????', 'Hindi', '??????', 'IN', 'HI', 'IND', 'HIN', 'hi-IN', 'Hindi, English', '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, 1407563842, 160, 1, '117.192.0.0 - 117.255.255.255', 143, 2),
(94, '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, 263, 1, '91.0.0.0 - 91.255.255.255', 4, 19),
(95, '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),
(96, '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),
(97, '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),
(98, 'Guatemala', 'Guatemala', 'Spanish', 'Espa', '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),
(99, 'Guinea', 'Guin', 'French', 'Fran', '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),
(100, 'Guinea-Bissau', 'Guin', '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),
(101, '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),
(102, 'Haiti', 'Ha', 'French', 'Fran', '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),
(103, 'Honduras', 'Honduras', 'Spanish', 'Espa', '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),
(104, 'Hungary', 'Magyarország', '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),
(105, 'Iceland', 'Ísland', 'Icelandic', 'Íslenska', '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),
(106, 'India', '????', 'Hindi', '??????', 'IN', 'HI', 'IND', 'HIN', 'hi-IN', 'Hindi, English', '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, 1407563842, 160, 1, '117.192.0.0 - 117.255.255.255', 143, 2),
(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),
(112, '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, 200, 1, '2.16.0.0 - 2.19.255.255', 9, 23),
(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),
(114, '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, '1947-05-03', NULL, NULL, '<svg>...</svg>', 'Tokyo', 35.6762000, 139.6503000, 125836021, 438, 1, '133.0.0.0 - 133.255.255.255', 3, 11),
(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),
(131, '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.5078000, 1.5211000, 77265, 1023, 0, '194.158.64.0 - 194.158.95.255', 34, 201),
(132, '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, 393248, 10, 1, '65.48.0.0 - 65.48.127.255', 39, 179),
(133, '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, 287025, 336, 1, '72.22.0.0 - 72.22.127.255', 52, 183),
(134, '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.2514000, -88.7669000, 432516, 32, 1, '186.2.192.0 - 186.2.255.255', 66, 177),
(135, '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, '1907-12-17', NULL, NULL, '<svg>...</svg>', 'Thimphu', 27.4728000, 89.6393000, 771608, 2400, 0, '119.2.96.0 - 119.2.127.255', 115, 165),
(136, 'Brunei', 'بروني', 'Malay', 'Melayu', 'BN', 'MS', 'BRN', 'MSA', '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, 90, 1, '119.160.0.0 - 119.160.127.255', 30, 176);
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
(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),
(138, '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.2976000, -61.3907000, 71991, 3, 1, '192.243.32.0 - 192.243.63.255', 85, 202),
(139, 'Fiji', 'Fiji', 'Fijian', 'Na Vosa Vakaviti', 'FJ', 'FJ', 'FJI', 'FIJ', 'fj-FJ', 'English, Fijian, Hindi', '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.1248000, 178.4501000, 889953, 132, 1, '202.62.128.0 - 202.62.159.255', 50, 164),
(140, '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>', 'Saint George\'s', 12.0561000, -61.7486000, 112519, 30, 1, '72.22.128.0 - 72.22.159.255', 51, 197),
(141, '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, '1974-09-24', NULL, NULL, '<svg>...</svg>', 'Bissau', 11.8636000, -15.5977000, 1604528, 300, 1, '197.214.96.0 - 197.214.127.255', 163, 151),
(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),
(163, '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.5078000, 1.5211000, 77265, 1996, 0, '194.158.64.0 - 194.158.95.255', 65, 210),
(164, '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, '1907-12-17', NULL, NULL, '<svg>...</svg>', 'Thimphu', 27.4720000, 89.6390000, 771608, 2200, 0, '202.144.128.0 - 202.144.191.255', 128, 164),
(165, 'Brunei', 'Brunei Darussalam', 'Malay', 'Bahasa Melayu', 'BN', 'MS', 'BRN', 'MSA', '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, 460345, 80, 1, '202.160.0.0 - 202.160.63.255', 34, 177),
(166, '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_cape_verde.png', 'Atlantic/Cape_Verde', 'Africa', 0, '1975-07-05', NULL, NULL, '<svg>...</svg>', 'Praia', 14.9167000, -23.5167000, 483628, 282, 1, '197.244.0.0 - 197.244.255.255', 166, 178),
(167, 'Comoros', 'Komori', 'Comorian', 'Shikomor', 'KM', 'AR', 'COM', 'COM', 'ar-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.7022000, 43.2551000, 850886, 236, 1, '197.255.192.0 - 197.255.223.255', 188, 160),
(168, '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.5880000, 43.1450000, 1078373, 155, 1, '196.201.192.0 - 196.201.223.255', 170, 161),
(169, '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-17', NULL, NULL, '<svg>...</svg>', 'Libreville', 0.4162000, 9.4673000, 2230282, 300, 1, '154.66.0.0 - 154.66.255.255', 113, 146),
(170, '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.0500000, -61.7500000, 113019, 70, 1, '173.212.240.0 - 173.212.255.255', 149, 205),
(171, 'Lesotho', 'Lesotho', 'English', 'English', 'LS', 'EN', 'LSO', 'ENG', 'en-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.3167000, 27.4833000, 2007201, 2160, 0, '102.32.0.0 - 102.32.127.255', 127, 144),
(172, 'Liechtenstein', 'Liechtenstein', 'German', 'Deutsch', 'LI', 'DE', 'LIE', 'DEU', 'de-LI', 'German', 'CHF', '+423', '🇱🇮', 'U+1F1F1 U+', 'D83C DDF1 ', 'https://example.com/flag_of_liechtenstein.png', 'Europe/Vaduz', 'Europe', 0, '1806-07-12', NULL, NULL, '<svg>...</svg>', 'Vaduz', 47.1416000, 9.5215000, 38749, 450, 0, '80.66.192.0 - 80.66.223.255', 19, 212),
(173, '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, 521021, 2, 1, '202.21.176.0 - 202.21.191.255', 192, 182),
(174, 'Eswatini', 'Eswatini', 'English', 'English', 'SZ', 'EN', 'SWZ', 'ENG', 'en-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.3167000, 31.1333000, 1160164, 500, 0, '160.119.0.0 - 160.119.127.255', 176, 162),
(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);

--
-- 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=177;
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 */;
