IPRangeByCountry-01

mysql> select CountryCode, CountryName, COUNT(*) as RangeCount from IPRangeByCountry group by CountryCode order by RangeCount ASC;
+-------------+----------------------------------------------+------------+
| CountryCode | CountryName                                  | RangeCount |
+-------------+----------------------------------------------+------------+
| TF          | French Southern Territories                  |          1 |
| GS          | South Georgia and the South Sandwich Islands |          1 |
| CX          | Christmas Island                             |          1 |
| SH          | Saint Helena                                 |          1 |
| CC          | Cocos (Keeling) Islands                      |          1 |
| PN          | Pitcairn Islands                             |          1 |
| WF          | Wallis and Futuna                            |          2 |
| EH          | Western Sahara                               |          2 |
| TV          | Tuvalu                                       |          2 |
| KI          | Kiribati                                     |          3 |
| NR          | Nauru                                        |          3 |
| NU          | Niue                                         |          3 |
| SJ          | Svalbard and Jan Mayen                       |          3 |
| NF          | Norfolk Island                               |          4 |
| YT          | Mayotte                                      |          4 |
| PM          | Saint Pierre and Miquelon                    |          4 |
| KP          | Korea, Democratic People's Republic of       |          4 |
| PW          | Palau                                        |          4 |
| SB          | Solomon Islands                              |          5 |
| FK          | Falkland Islands (Malvinas)                  |          5 |
| TO          | Tonga                                        |          5 |
| ST          | Sao Tome and Principe                        |          5 |
| GW          | Guinea-Bissau                                |          5 |
| TL          | Timor-Leste                                  |          5 |
| KM          | Comoros                                      |          6 |
| CK          | Cook Islands                                 |          6 |
| MF          | Saint Martin                                 |          7 |
| MP          | Northern Mariana Islands                     |          7 |
| RE          | Reunion                                      |          7 |
| FM          | Micronesia, Federated States of              |          8 |
| VU          | Vanuatu                                      |          8 |
| IO          | British Indian Ocean Territory               |          9 |
| DJ          | Djibouti                                     |          9 |
| MH          | Marshall Islands                             |          9 |
| BT          | Bhutan                                       |         10 |
| MM          | Myanmar                                      |         10 |
| UM          | United States Minor Outlying Islands         |         10 |
| GM          | Gambia                                       |         11 |
| TM          | Turkmenistan                                 |         12 |
| CV          | Cape Verde                                   |         12 |
| GY          | Guyana                                       |         13 |
| PF          | French Polynesia                             |         13 |
| TK          | Tokelau                                      |         13 |
| GL          | Greenland                                    |         13 |
| TC          | Turks and Caicos Islands                     |         14 |
| ER          | Eritrea                                      |         14 |
| LS          | Lesotho                                      |         15 |
| CF          | Central African Republic                     |         15 |
| FO          | Faroe Islands                                |         16 |
| MS          | Montserrat                                   |         16 |
| ET          | Ethiopia                                     |         16 |
| GF          | French Guiana                                |         16 |
| BV          | Bouvet Island                                |         16 |
| LA          | Lao People's Democratic Republic             |         17 |
| RW          | Rwanda                                       |         18 |
| BN          | Brunei Darussalam                            |         19 |
| AI          | Anguilla                                     |         19 |
| CU          | Cuba                                         |         19 |
| BI          | Burundi                                      |         20 |
| TG          | Togo                                         |         20 |
| MV          | Maldives                                     |         22 |
| TN          | Tunisia                                      |         23 |
| FJ          | Fiji                                         |         24 |
| VA          | Holy See (Vatican City State)                |         24 |
| MG          | Madagascar                                   |         24 |
| AD          | Andorra                                      |         24 |
| SM          | San Marino                                   |         24 |
| YE          | Yemen                                        |         24 |
| WS          | Samoa                                        |         24 |
| ML          | Mali                                         |         24 |
| GQ          | Equatorial Guinea                            |         24 |
| SN          | Senegal                                      |         25 |
| DM          | Dominica                                     |         25 |
| MR          | Mauritania                                   |         25 |
| PG          | Papua New Guinea                             |         26 |
| SZ          | Swaziland                                    |         27 |
| AW          | Aruba                                        |         27 |
| TD          | Chad                                         |         29 |
| VC          | Saint Vincent and the Grenadines             |         29 |
| LC          | Saint Lucia                                  |         29 |
| AQ          | Antarctica                                   |         30 |
| TJ          | Tajikistan                                   |         31 |
| MO          | Macau                                        |         31 |
| BF          | Burkina Faso                                 |         31 |
| KY          | Cayman Islands                               |         32 |
| GD          | Grenada                                      |         33 |
| SR          | Suriname                                     |         34 |
| NC          | New Caledonia                                |         35 |
| AS          | American Samoa                               |         35 |
| HT          | Haiti                                        |         36 |
| BW          | Botswana                                     |         36 |
| BJ          | Benin                                        |         36 |
| OM          | Oman                                         |         37 |
| MQ          | Martinique                                   |         39 |
| GU          | Guam                                         |         39 |
| TT          | Trinidad and Tobago                          |         39 |
| CG          | Congo                                        |         41 |
| NE          | Niger                                        |         44 |
| MC          | Monaco                                       |         46 |
| PY          | Paraguay                                     |         47 |
| MW          | Malawi                                       |         48 |
| QA          | Qatar                                        |         48 |
| MZ          | Mozambique                                   |         49 |
| GA          | Gabon                                        |         49 |
| MU          | Mauritius                                    |         51 |
| BS          | Bahamas                                      |         51 |
| SL          | Sierra Leone                                 |         52 |
| GP          | Guadeloupe                                   |         52 |
| SO          | Somalia                                      |         52 |
| CI          | Cote D'Ivoire                                |         53 |
| KG          | Kyrgyzstan                                   |         55 |
| GN          | Guinea                                       |         56 |
| PS          | Palestinian Territory, Occupied              |         59 |
| KN          | Saint Kitts and Nevis                        |         61 |
| MN          | Mongolia                                     |         61 |
| UZ          | Uzbekistan                                   |         63 |
| SY          | Syrian Arab Republic                         |         64 |
| ME          | Montenegro                                   |         67 |
| SC          | Seychelles                                   |         67 |
| CM          | Cameroon                                     |         69 |
| GI          | Gibraltar                                    |         71 |
| DZ          | Algeria                                      |         72 |
| NP          | Nepal                                        |         73 |
| ZM          | Zambia                                       |         73 |
| A1          | Anonymous Proxy                              |         75 |
| AZ          | Azerbaijan                                   |         76 |
| BO          | Bolivia                                      |         79 |
| SD          | Sudan                                        |         80 |
| NI          | Nicaragua                                    |         80 |
| BM          | Bermuda                                      |         82 |
| LR          | Liberia                                      |         85 |
| BB          | Barbados                                     |         88 |
| UY          | Uruguay                                      |         88 |
| LI          | Liechtenstein                                |         89 |
| ZW          | Zimbabwe                                     |         89 |
| AN          | Netherlands Antilles                         |         90 |
| LK          | Sri Lanka                                    |         90 |
| KH          | Cambodia                                     |         91 |
| SV          | El Salvador                                  |         91 |
| JM          | Jamaica                                      |         92 |
| GG          | Guernsey                                     |         93 |
| BH          | Bahrain                                      |         95 |
| GT          | Guatemala                                    |         97 |
| AM          | Armenia                                      |         97 |
| UG          | Uganda                                       |         97 |
| BY          | Belarus                                      |         99 |
| MK          | Macedonia                                    |         99 |
| BZ          | Belize                                       |        102 |
| DO          | Dominican Republic                           |        102 |
| HN          | Honduras                                     |        102 |
| VG          | Virgin Islands, British                      |        105 |
| IS          | Iceland                                      |        109 |
| AG          | Antigua and Barbuda                          |        112 |
| JO          | Jordan                                       |        115 |
| LY          | Libyan Arab Jamahiriya                       |        118 |
| MA          | Morocco                                      |        126 |
| GE          | Georgia                                      |        129 |
| AO          | Angola                                       |        129 |
| IM          | Isle of Man                                  |        131 |
| MT          | Malta                                        |        136 |
| VI          | Virgin Islands, U.S.                         |        136 |
| CR          | Costa Rica                                   |        138 |
| AX          | Aland Islands                                |        145 |
| GH          | Ghana                                        |        147 |
| MD          | Moldova, Republic of                         |        148 |
| PE          | Peru                                         |        150 |
| JE          | Jersey                                       |        157 |
| BA          | Bosnia and Herzegovina                       |        160 |
| TZ          | Tanzania, United Republic of                 |        161 |
| KE          | Kenya                                        |        177 |
| NA          | Namibia                                      |        178 |
| AL          | Albania                                      |        187 |
| KW          | Kuwait                                       |        190 |
| PA          | Panama                                       |        197 |
| AP          | Asia/Pacific Region                          |        202 |
| VN          | Vietnam                                      |        202 |
| CD          | Congo, The Democratic Republic of the        |        202 |
| EC          | Ecuador                                      |        204 |
| KZ          | Kazakhstan                                   |        217 |
| HR          | Croatia                                      |        218 |
| EE          | Estonia                                      |        234 |
| LB          | Lebanon                                      |        241 |
| AF          | Afghanistan                                  |        262 |
| VE          | Venezuela                                    |        266 |
| EG          | Egypt                                        |        272 |
| PK          | Pakistan                                     |        303 |
| CY          | Cyprus                                       |        311 |
| LV          | Latvia                                       |        347 |
| AE          | United Arab Emirates                         |        353 |
| BD          | Bangladesh                                   |        362 |
| RS          | Serbia                                       |        402 |
| SK          | Slovakia                                     |        405 |
| LU          | Luxembourg                                   |        410 |
| TH          | Thailand                                     |        421 |
| CL          | Chile                                        |        427 |
| SA          | Saudi Arabia                                 |        435 |
| IR          | Iran, Islamic Republic of                    |        439 |
| SI          | Slovenia                                     |        479 |
| TW          | Taiwan                                       |        487 |
| PH          | Philippines                                  |        496 |
| CO          | Colombia                                     |        500 |
| LT          | Lithuania                                    |        520 |
| MY          | Malaysia                                     |        550 |
| BG          | Bulgaria                                     |        567 |
| IQ          | Iraq                                         |        582 |
| HU          | Hungary                                      |        587 |
| MX          | Mexico                                       |        620 |
| GR          | Greece                                       |        632 |
| BR          | Brazil                                       |        648 |
| ZA          | South Africa                                 |        661 |
| NZ          | New Zealand                                  |        693 |
| KR          | Korea, Republic of                           |        703 |
| IL          | Israel                                       |        776 |
| AR          | Argentina                                    |        779 |
| TR          | Turkey                                       |        846 |
| PT          | Portugal                                     |        864 |
| PR          | Puerto Rico                                  |        868 |
| ID          | Indonesia                                    |        877 |
| SG          | Singapore                                    |        983 |
| NG          | Nigeria                                      |       1023 |
| CZ          | Czech Republic                               |       1088 |
| FI          | Finland                                      |       1165 |
| HK          | Hong Kong                                    |       1190 |
| RO          | Romania                                      |       1201 |
| DK          | Denmark                                      |       1239 |
| NO          | Norway                                       |       1269 |
| IE          | Ireland                                      |       1428 |
| CN          | China                                        |       1608 |
| A2          | Satellite Provider                           |       1757 |
| AT          | Austria                                      |       1798 |
| IN          | India                                        |       1822 |
| JP          | Japan                                        |       1873 |
| SE          | Sweden                                       |       2634 |
| UA          | Ukraine                                      |       2675 |
| CH          | Switzerland                                  |       2874 |
| AU          | Australia                                    |       3086 |
| EU          | Europe                                       |       3221 |
| IT          | Italy                                        |       3569 |
| ES          | Spain                                        |       3703 |
| PL          | Poland                                       |       4076 |
| BE          | Belgium                                      |       4272 |
| RU          | Russian Federation                           |       5065 |
| CA          | Canada                                       |       8057 |
| FR          | France                                       |       8085 |
| NL          | Netherlands                                  |       8150 |
| DE          | Germany                                      |      12737 |
| GB          | United Kingdom                               |      14718 |
| US          | United States                                |      22371 |
+-------------+----------------------------------------------+------------+
248 rows in set (0.16 sec)

mysql> select * from IPRangeByCountry where CountryCode = 'TF';
+---------------+---------------+-----------+-----------+-------------+-----------------------------+------+
| FromIP        | ToIP          | FromInt   | ToInt     | CountryCode | CountryName                 | _id  |
+---------------+---------------+-----------+-----------+-------------+-----------------------------+------+
| 46.36.200.101 | 46.36.200.110 | 774162533 | 774162542 | TF          | French Southern Territories | 4197 |
+---------------+---------------+-----------+-----------+-------------+-----------------------------+------+
1 row in set (0.06 sec)