INSERT INTO "public"."countries"("id","name","code","geo","region","population")
VALUES
(2,E'China',E'CN',E'(35,105)',E'Asia',1371590000),
(3,E'India',E'IN',E'(20,77)',E'Asia',1275840000),
(4,E'United States',E'US',E'(38,-97)',E'Americas',321645000),
(5,E'Indonesia',E'ID',E'(-5,120)',E'Asia',255461700),
(6,E'Brazil',E'BR',E'(-10,-55)',E'Americas',204772000),
(7,E'Pakistan',E'PK',E'(30,70)',E'Asia',190668000),
(8,E'Nigeria',E'NG',E'(10,8)',E'Africa',182202000),
(9,E'Bangladesh',E'BD',E'(24,90)',E'Asia',158875000),
(10,E'Russia',E'RU',E'(60,100)',E'Europe',146556330),
(11,E'Japan',E'JP',E'(36,138)',E'Asia',126865000),
(12,E'Mexico',E'MX',E'(23,-102)',E'Americas',121740000),
(13,E'Philippines',E'PH',E'(13,122)',E'Asia',101920000),
(14,E'Vietnam',E'VN',E'(16.1666667000000004,107.833332999999996)',E'Asia',91812000),
(15,E'Ethiopia',E'ET',E'(8,38)',E'Africa',90076012),
(16,E'Egypt',E'EG',E'(27,30)',E'Africa',89335600),
(17,E'Germany',E'DE',E'(51,9)',E'Europe',81083600),
(18,E'Iran',E'IR',E'(32,53)',E'Asia',78572500),
(19,E'Turkey',E'TR',E'(39,35)',E'Asia',77695904),
(20,E'Democratic Republic of the Congo',E'CD',E'(0,25)',E'Africa',77267000),
(21,E'France',E'FR',E'(46,2)',E'Europe',66186000),
(22,E'Thailand',E'TH',E'(15,100)',E'Asia',65104000),
(23,E'United Kingdom',E'GB',E'(54,-2)',E'Europe',64800000),
(24,E'Italy',E'IT',E'(42.8333332999999996,12.8333332999999996)',E'Europe',60753794),
(25,E'South Africa',E'ZA',E'(-29,24)',E'Africa',54956900),
(26,E'Myanmar',E'MM',E'(22,98)',E'Asia',53897000),
(27,E'Tanzania',E'TZ',E'(-6,35)',E'Africa',53470000),
(28,E'South Korea',E'KR',E'(37,127.5)',E'Asia',51448183),
(29,E'Colombia',E'CO',E'(4,-72)',E'Americas',48266600),
(30,E'Spain',E'ES',E'(40,-4)',E'Europe',46439864),
(31,E'Kenya',E'KE',E'(1,38)',E'Africa',46050000),
(32,E'Argentina',E'AR',E'(-34,-64)',E'Americas',43131966),
(33,E'Ukraine',E'UA',E'(49,32)',E'Europe',42836922),
(34,E'Algeria',E'DZ',E'(28,3)',E'Africa',39500000),
(35,E'Poland',E'PL',E'(52,20)',E'Europe',38484000),
(36,E'Sudan',E'SD',E'(15,30)',E'Africa',38435252),
(37,E'Iraq',E'IQ',E'(33,44)',E'Asia',36004552),
(38,E'Canada',E'CA',E'(60,-95)',E'Americas',35749600),
(39,E'Uganda',E'UG',E'(1,32)',E'Africa',34856813),
(40,E'Morocco',E'MA',E'(32,-5)',E'Africa',33337529),
(41,E'Saudi Arabia',E'SA',E'(25,45)',E'Asia',31521418),
(42,E'Peru',E'PE',E'(-10,-76)',E'Americas',31151643),
(43,E'Uzbekistan',E'UZ',E'(41,64)',E'Asia',31022500),
(44,E'Malaysia',E'MY',E'(2.5,112.5)',E'Asia',30678800),
(45,E'Venezuela',E'VE',E'(8,-66)',E'Americas',30620404),
(46,E'Nepal',E'NP',E'(28,84)',E'Asia',28037904),
(47,E'Ghana',E'GH',E'(8,-2)',E'Africa',27043093),
(48,E'Afghanistan',E'AF',E'(33,65)',E'Asia',26023100),
(49,E'Yemen',E'YE',E'(15,48)',E'Asia',25956000),
(50,E'Mozambique',E'MZ',E'(-18.25,35)',E'Africa',25727911),
(51,E'North Korea',E'KP',E'(40,127)',E'Asia',25155000),
(52,E'Angola',E'AO',E'(-12.5,18.5)',E'Africa',24383301),
(53,E'Australia',E'AU',E'(-27,133)',E'Oceania',23868800),
(54,E'Taiwan',E'TW',E'(23.5,121)',E'Asia',23461708),
(55,E'Cameroon',E'CM',E'(6,12)',E'Africa',23344000),
(56,E'Syria',E'SY',E'(35,38)',E'Asia',23339517),
(57,E'Ivory Coast',E'CI',E'(8,-5)',E'Africa',22671331),
(58,E'Madagascar',E'MG',E'(-20,47)',E'Africa',22434363),
(59,E'Sri Lanka',E'LK',E'(7,81)',E'Asia',20675000),
(60,E'Romania',E'RO',E'(46,25)',E'Europe',19942642),
(61,E'Niger',E'NE',E'(16,8)',E'Africa',19899000),
(62,E'Burkina Faso',E'BF',E'(13,-2)',E'Africa',18450494),
(63,E'Chile',E'CL',E'(-30,-71)',E'Americas',18006407),
(64,E'Mali',E'ML',E'(17,-4)',E'Africa',17600000),
(65,E'Kazakhstan',E'KZ',E'(48,68)',E'Asia',17541200),
(66,E'Netherlands',E'NL',E'(52.5,5.75)',E'Europe',16916000),
(67,E'Malawi',E'MW',E'(-13.5,34)',E'Africa',16310431),
(68,E'Guatemala',E'GT',E'(15.5,-90.25)',E'Americas',16176133),
(69,E'Ecuador',E'EC',E'(-2,-77.5)',E'Americas',16027500),
(70,E'Zambia',E'ZM',E'(-15,30)',E'Africa',15473905),
(71,E'Cambodia',E'KH',E'(13,105)',E'Asia',15405157),
(72,E'Chad',E'TD',E'(15,19)',E'Africa',14037000),
(73,E'Senegal',E'SN',E'(14,-14)',E'Africa',13508715),
(74,E'Zimbabwe',E'ZW',E'(-20,30)',E'Africa',13061239),
(75,E'South Sudan',E'SS',E'(7,30)',E'Africa',11892934),
(76,E'Bolivia',E'BO',E'(-17,-65)',E'Americas',11410651),
(77,E'Rwanda',E'RW',E'(-2,30)',E'Africa',11262564),
(78,E'Belgium',E'BE',E'(50.8333332999999996,4)',E'Europe',11248330),
(79,E'Cuba',E'CU',E'(21.5,-80)',E'Americas',11238317),
(80,E'Tunisia',E'TN',E'(34,9)',E'Africa',10982754),
(81,E'Haiti',E'HT',E'(19,-72.4166670000000039)',E'Americas',10911819),
(82,E'Greece',E'GR',E'(39,22)',E'Europe',10846979),
(83,E'Somalia',E'SO',E'(10,49)',E'Africa',10787000),
(84,E'Guinea',E'GN',E'(11,-10)',E'Africa',10628972),
(85,E'Czech Republic',E'CZ',E'(49.75,15.5)',E'Europe',10537818),
(86,E'Dominican Republic',E'DO',E'(19,-70.6666670000000039)',E'Americas',10528000),
(87,E'Portugal',E'PT',E'(39.5,-8)',E'Europe',10374822),
(88,E'Benin',E'BJ',E'(9.5,2.25)',E'Africa',10315244),
(89,E'Hungary',E'HU',E'(47,20)',E'Europe',9849000),
(90,E'Burundi',E'BI',E'(-3.5,30)',E'Africa',9823827),
(91,E'Sweden',E'SE',E'(62,15)',E'Europe',9793172),
(92,E'Azerbaijan',E'AZ',E'(40.5,47.5)',E'Asia',9636300),
(93,E'Belarus',E'BY',E'(53,28)',E'Europe',9485300),
(94,E'United Arab Emirates',E'AE',E'(24,54)',E'Asia',9157000),
(95,E'Honduras',E'HN',E'(15,-86.5)',E'Americas',8725111),
(96,E'Austria',E'AT',E'(47.3333332999999996,13.3333332999999996)',E'Europe',8602112),
(97,E'Israel',E'IL',E'(31.5,34.75)',E'Asia',8371600),
(98,E'Tajikistan',E'TJ',E'(39,71)',E'Asia',8354000),
(99,E'Switzerland',E'CH',E'(47,8)',E'Europe',8256000),
(100,E'Papua New Guinea',E'PG',E'(-6,147)',E'Oceania',7398500),
(101,E'Togo',E'TG',E'(8,1.16666665999999997)',E'Africa',7305000),
(102,E'Hong Kong',E'HK',E'(22.25,114.166667000000004)',E'Asia',7298600),
(103,E'Bulgaria',E'BG',E'(43,25)',E'Europe',7202198),
(104,E'Serbia',E'RS',E'(44,21)',E'Europe',7114393),
(105,E'Paraguay',E'PY',E'(-23,-58)',E'Americas',7003406),
(106,E'Laos',E'LA',E'(18,105)',E'Asia',6802000),
(107,E'Jordan',E'JO',E'(31,36)',E'Asia',6767600),
(108,E'Sierra Leone',E'SL',E'(8.5,-11.5)',E'Africa',6453000),
(109,E'El Salvador',E'SV',E'(13.8333332999999996,-88.9166670000000039)',E'Americas',6401240),
(110,E'Republic of Ireland',E'IE',E'(53,-8)',E'Europe',6378000),
(111,E'Libya',E'LY',E'(25,17)',E'Africa',6278000),
(112,E'Nicaragua',E'NI',E'(13,-85)',E'Americas',6198154),
(113,E'Kyrgyzstan',E'KG',E'(41,75)',E'Asia',5944400),
(114,E'Denmark',E'DK',E'(56,10)',E'Europe',5678348),
(115,E'Finland',E'FI',E'(64,26)',E'Europe',5485215),
(116,E'Singapore',E'SG',E'(1.36666665999999992,103.799999999999997)',E'Asia',5469700),
(117,E'Slovakia',E'SK',E'(48.6666667000000004,19.5)',E'Europe',5421349),
(118,E'Eritrea',E'ER',E'(15,39)',E'Africa',5228000),
(119,E'Norway',E'NO',E'(62,10)',E'Europe',5176998),
(120,E'Central African Republic',E'CF',E'(7,21)',E'Africa',4900000),
(121,E'Costa Rica',E'CR',E'(10,-84)',E'Americas',4773130),
(122,E'Turkmenistan',E'TM',E'(40,60)',E'Asia',4751120),
(123,E'Palestine',E'PS',E'(31.8999999999999986,35.2000000000000028)',E'Asia',4682467),
(124,E'Republic of the Congo',E'CG',E'(-1,15)',E'Africa',4620000),
(125,E'New Zealand',E'NZ',E'(-41,174)',E'Oceania',4609440),
(126,E'Liberia',E'LR',E'(6.5,-9.5)',E'Africa',4503000),
(127,E'Croatia',E'HR',E'(45.1666667000000004,15.5)',E'Europe',4246800),
(128,E'Oman',E'OM',E'(21,57)',E'Asia',4185440),
(129,E'Lebanon',E'LB',E'(33.8333332999999996,35.8333332999999996)',E'Asia',4104000),
(130,E'Bosnia and Herzegovina',E'BA',E'(44,18)',E'Europe',3791622),
(131,E'Panama',E'PA',E'(9,-80)',E'Americas',3764166),
(132,E'Georgia',E'GE',E'(42,43.5)',E'Asia',3729500),
(133,E'Mauritania',E'MR',E'(20,-12)',E'Africa',3631775),
(134,E'Moldova',E'MD',E'(47,29)',E'Europe',3555200),
(135,E'Puerto Rico',E'PR',E'(18.25,-66.5)',E'Americas',3548397),
(136,E'Uruguay',E'UY',E'(-33,-56)',E'Americas',3415866),
(137,E'Kuwait',E'KW',E'(29.5,45.75)',E'Asia',3268431),
(138,E'Mongolia',E'MN',E'(46,105)',E'Asia',3031099),
(139,E'Armenia',E'AM',E'(40,45)',E'Asia',3006800),
(140,E'Lithuania',E'LT',E'(56,24)',E'Europe',2900787),
(141,E'Albania',E'AL',E'(41,20)',E'Europe',2893005),
(142,E'Jamaica',E'JM',E'(18.25,-77.5)',E'Americas',2717991),
(143,E'Namibia',E'NA',E'(-22,17)',E'Africa',2280700),
(144,E'Lesotho',E'LS',E'(-29.5,28.5)',E'Africa',2135000),
(145,E'Qatar',E'QA',E'(25.5,51.25)',E'Asia',2120129),
(146,E'Botswana',E'BW',E'(-22,24)',E'Africa',2070984),
(147,E'Slovenia',E'SI',E'(46.1166667000000032,14.8166667000000007)',E'Europe',2067683),
(148,E'Republic of Macedonia',E'MK',E'(41.8333332999999996,22)',E'Europe',2058539),
(149,E'Latvia',E'LV',E'(57,25)',E'Europe',1980700),
(150,E'The Gambia',E'GM',E'(13.4666666999999993,-16.5666669999999989)',E'Africa',1882450),
(151,E'Guinea-Bissau',E'GW',E'(12,-15)',E'Africa',1844000),
(152,E'Republic of Kosovo',E'XK',E'(42.6666669999999968,21.1666670000000003)',E'Europe',1733842),
(153,E'Gabon',E'GA',E'(-1,11.75)',E'Africa',1725000),
(154,E'Equatorial Guinea',E'GQ',E'(2,10)',E'Africa',1430000),
(155,E'Bahrain',E'BH',E'(26,50.5499999999999972)',E'Asia',1359800),
(156,E'Trinidad and Tobago',E'TT',E'(11,-61)',E'Americas',1340557),
(157,E'Estonia',E'EE',E'(59,26)',E'Europe',1313271),
(158,E'Mauritius',E'MU',E'(-20.2833329999999989,57.5499999999999972)',E'Africa',1261208),
(159,E'East Timor',E'TL',E'(-8.83333329999999961,125.916667000000004)',E'Asia',1212107),
(160,E'Swaziland',E'SZ',E'(-26.5,31.5)',E'Africa',1119375),
(161,E'Djibouti',E'DJ',E'(11.5,43)',E'Africa',888000),
(162,E'Fiji',E'FJ',E'(-18,175)',E'Oceania',859178),
(163,E'Cyprus',E'CY',E'(35,33)',E'Europe',858000),
(164,E'Réunion',E'RE',E'(-21.1499999999999986,55.5)',E'Africa',840974),
(165,E'Comoros',E'KM',E'(-12.1666670000000003,44.25)',E'Africa',784745),
(166,E'Bhutan',E'BT',E'(27.5,90.5)',E'Asia',763920),
(167,E'Guyana',E'GY',E'(5,-59)',E'Americas',746900),
(168,E'Macau',E'MO',E'(22.1666667000000004,113.549999999999997)',E'Asia',642900),
(169,E'Montenegro',E'ME',E'(42.5,19.3000000000000007)',E'Europe',621207),
(170,E'Solomon Islands',E'SB',E'(-8,159)',E'Oceania',581344),
(171,E'Luxembourg',E'LU',E'(49.75,6.16666665999999974)',E'Europe',562958),
(172,E'Suriname',E'SR',E'(4,-56)',E'Americas',534189),
(173,E'Cape Verde',E'CV',E'(16,-24)',E'Africa',524833),
(174,E'Western Sahara',E'EH',E'(24.5,-13)',E'Africa',510713),
(175,E'Malta',E'MT',E'(35.8333332999999996,14.5833332999999996)',E'Europe',445426),
(176,E'Guadeloupe',E'GP',E'(16.25,-61.5833330000000032)',E'Americas',403750),
(177,E'Brunei',E'BN',E'(4.5,114.666667000000004)',E'Asia',393372),
(178,E'Martinique',E'MQ',E'(14.6666670000000003,-61)',E'Americas',381326),
(179,E'The Bahamas',E'BS',E'(24.25,-76)',E'Americas',368390),
(180,E'Belize',E'BZ',E'(17.25,-88.75)',E'Americas',368310),
(181,E'Maldives',E'MV',E'(3.25,73)',E'Asia',341256),
(182,E'Iceland',E'IS',E'(65,-18)',E'Europe',330610),
(183,E'Barbados',E'BB',E'(13.1666667000000004,-59.5333329999999989)',E'Americas',285000),
(184,E'New Caledonia',E'NC',E'(-21.5,165.5)',E'Oceania',268767),
(185,E'French Polynesia',E'PF',E'(-15,-140)',E'Oceania',268270),
(186,E'Vanuatu',E'VU',E'(-16,167)',E'Oceania',264652),
(187,E'French Guiana',E'GF',E'(4,-53)',E'Americas',239648),
(188,E'Mayotte',E'YT',E'(-12.8333329999999997,45.1666667000000004)',E'Africa',212645),
(189,E'Samoa',E'WS',E'(-13.5833329999999997,-172.333329999999989)',E'Oceania',187820),
(190,E'São Tomé and Príncipe',E'ST',E'(1,7)',E'Africa',187356),
(191,E'Saint Lucia',E'LC',E'(13.8833333000000003,-60.9666670000000011)',E'Americas',185000),
(192,E'Guam',E'GU',E'(13.4666666999999993,144.783332999999999)',E'Oceania',159358),
(193,E'Curaçao',E'CW',E'(12.1166669999999996,-68.9333330000000046)',E'Americas',154843),
(194,E'Virgin Islands (U.S.)',E'VI',E'(18.3399999999999999,-64.9300000000000068)',E'Americas',114743),
(195,E'Saint Vincent and the Grenadines',E'VC',E'(13.25,-61.2000000000000028)',E'Americas',109991),
(196,E'Aruba',E'AW',E'(12.5,-69.9666670000000011)',E'Americas',107394),
(197,E'Kiribati',E'KI',E'(1.41666665999999997,173)',E'Oceania',106461),
(198,E'Grenada',E'GD',E'(12.1166666999999997,-61.6666669999999968)',E'Americas',103328),
(199,E'Tonga',E'TO',E'(-20,-175)',E'Oceania',103252),
(200,E'Federated States of Micronesia',E'FM',E'(6.91666665999999974,158.25)',E'Oceania',101351),
(201,E'Jersey',E'JE',E'(49.25,-2.16666669999999995)',E'Europe',99000),
(202,E'Seychelles',E'SC',E'(-4.58333329999999961,55.6666667000000004)',E'Africa',89949),
(203,E'Antigua and Barbuda',E'AG',E'(17.0500000000000007,-61.7999999999999972)',E'Americas',86295),
(204,E'Isle of Man',E'IM',E'(54.25,-4.5)',E'Europe',84497),
(205,E'Andorra',E'AD',E'(42.5,1.5)',E'Europe',76949),
(206,E'Dominica',E'DM',E'(15.4166667000000004,-61.3333330000000032)',E'Americas',71293),
(207,E'Guernsey',E'GG',E'(49.4666666999999975,-2.58333330000000005)',E'Europe',65150),
(208,E'Bermuda',E'BM',E'(32.3333332999999996,-64.75)',E'Americas',64237),
(209,E'Cayman Islands',E'KY',E'(19.5,-80.5)',E'Americas',58238),
(210,E'Greenland',E'GL',E'(72,-40)',E'Americas',56114),
(211,E'Marshall Islands',E'MH',E'(9,168)',E'Oceania',56086),
(212,E'Saint Kitts and Nevis',E'KN',E'(17.3333332999999996,-62.75)',E'Americas',56000),
(213,E'American Samoa',E'AS',E'(-14.3333329999999997,-170)',E'Oceania',55519),
(214,E'Northern Mariana Islands',E'MP',E'(15.1999999999999993,145.75)',E'Oceania',53883),
(215,E'Faroe Islands',E'FO',E'(62,-7)',E'Europe',48846),
(216,E'Monaco',E'MC',E'(43.7333332999999982,7.40000000000000036)',E'Europe',37800),
(217,E'Sint Maarten',E'SX',E'(18.0333329999999989,-63.0499999999999972)',E'Americas',37429),
(218,E'Liechtenstein',E'LI',E'(47.2666667000000018,9.53333332999999961)',E'Europe',37370),
(219,E'Saint Martin',E'MF',E'(18.0833332999999996,-63.9500000000000028)',E'Americas',36979),
(220,E'San Marino',E'SM',E'(43.7666667000000018,12.4166667000000004)',E'Europe',32831),
(221,E'Gibraltar',E'GI',E'(36.1333332999999968,-5.34999999999999964)',E'Europe',32734),
(222,E'Turks and Caicos Islands',E'TC',E'(21.75,-71.5833329999999961)',E'Americas',31458),
(223,E'Åland Islands',E'AX',E'(60.1166669999999996,19.8999999999999986)',E'Europe',28875),
(224,E'Virgin Islands (British)',E'VG',E'(18.4313830000000003,-64.6230500000000063)',E'Americas',28054),
(225,E'Palau',E'PW',E'(7.5,134.5)',E'Oceania',20901),
(226,E'Bonaire',E'BQ',E'(12.1500000000000004,-68.2666669999999982)',E'Americas',17408),
(227,E'Cook Islands',E'CK',E'(-21.2333329999999982,-159.766670000000005)',E'Oceania',14974),
(228,E'Anguilla',E'AI',E'(18.25,-63.1666669999999968)',E'Americas',13452),
(229,E'Wallis and Futuna',E'WF',E'(-13.3000000000000007,-176.199999999999989)',E'Oceania',13135),
(230,E'Tuvalu',E'TV',E'(-8,178)',E'Oceania',10640),
(231,E'Nauru',E'NR',E'(-0.53333330000000001,166.91666699999999)',E'Oceania',10084),
(232,E'Saint Barthélemy',E'BL',E'(18.5,-63.4166669999999968)',E'Americas',9269),
(233,E'Saint Pierre and Miquelon',E'PM',E'(46.8333332999999996,-56.3333330000000032)',E'Americas',6069),
(234,E'Montserrat',E'MS',E'(16.75,-62.2000000000000028)',E'Americas',4922),
(235,E'Saint Helena',E'SH',E'(-15.9499999999999993,-5.70000000000000018)',E'Africa',4255),
(236,E'British Indian Ocean Territory',E'IO',E'(-6,71.5)',E'Africa',3000),
(237,E'Falkland Islands',E'FK',E'(-51.75,-59)',E'Americas',3000),
(238,E'Svalbard and Jan Mayen',E'SJ',E'(78,20)',E'Europe',2562),
(239,E'Norfolk Island',E'NF',E'(-29.0333329999999989,167.949999999999989)',E'Oceania',2302),
(240,E'Christmas Island',E'CX',E'(-10.5,105.666667000000004)',E'Oceania',2072),
(241,E'Niue',E'NU',E'(-19.0333329999999989,-169.866669999999999)',E'Oceania',1613),
(242,E'Tokelau',E'TK',E'(-9,-172)',E'Oceania',1411),
(243,E'Antarctica',E'AQ',E'(-74.6500000000000057,4.48000000000000043)',E'Polar',1000),
(244,E'Cocos (Keeling) Islands',E'CC',E'(-12.5,96.8333333000000067)',E'Oceania',550),
(245,E'Holy See',E'VA',E'(41.8999999999999986,12.4499999999999993)',E'Europe',451),
(246,E'United States Minor Outlying Islands',E'UM',NULL,E'Americas',300),
(247,E'French Southern and Antarctic Lands',E'TF',NULL,NULL,140),
(248,E'Pitcairn Islands',E'PN',NULL,E'Oceania',56),
(249,E'South Georgia',E'GS',NULL,E'Americas',30),
(250,E'Bouvet Island',E'BV',NULL,NULL,0),
(251,E'Heard Island and McDonald Islands',E'HM',NULL,NULL,0);