Skip to content

Instantly share code, notes, and snippets.

@imhalid
Last active February 20, 2024 21:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save imhalid/0efb9eca8bf18ab665515e06f59261c6 to your computer and use it in GitHub Desktop.
Save imhalid/0efb9eca8bf18ab665515e06f59261c6 to your computer and use it in GitHub Desktop.
worldwide_speed_league_data.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 8 columns, instead of 9. in line 1.
Position,country,CountryCode,Region,Mean download speed (Mbps),Unique IPs tested,Total tests,How long it takes to download a 5GB movie (HH:MM:SS)
1,Jersey,JE,WESTERN EUROPE,264,52,1336,45280,00:02:35
2,Liechtenstein,LI,WESTERN EUROPE,246,76,1060,4146,00:02:46
3,Macau,MO,ASIA (EX. NEAR EAST),231,40,1867,9505,00:02:57
4,Iceland,IS,WESTERN EUROPE,229,35,3472,70572,00:02:59
5,Gibraltar,GI,WESTERN EUROPE,206,27,628,6620,00:03:19
6,Andorra,AD,WESTERN EUROPE,190,40,1303,12038,00:03:35
7,Luxembourg,LU,WESTERN EUROPE,162,21,9147,107359,00:04:13
8,Taiwan,TW,ASIA (EX. NEAR EAST),153,51,72542,266095,00:04:27
9,France,FR,WESTERN EUROPE,152,45,7194414,17343867,00:04:29
10,Netherlands,NL,WESTERN EUROPE,142,49,1395688,7863959,00:04:47
11,Slovakia,SK,EASTERN EUROPE,138,03,16272,158855,00:04:57
12,United States,US,NORTHERN AMERICA,136,48,70660580,373607521,00:05:00
13,Canada,CA,NORTHERN AMERICA,136,08,7575481,28353832,00:05:01
14,Spain,ES,WESTERN EUROPE,133,66,3901466,21119333,00:05:06
15,San Marino,SM,WESTERN EUROPE,126,88,273,983,00:05:23
16,Monaco,MC,WESTERN EUROPE,126,30,936,10545,00:05:24
17,Cayman Islands,KY,CARIBBEAN,125,08,2451,23007,00:05:27
18,Japan,JP,ASIA (EX. NEAR EAST),124,70,13320585,38308684,00:05:28
19,Malta, Montana,MT,WESTERN EUROPE,123,85,4214,36981,00:05:31
20,Uruguay,UY,SOUTH AMERICA,111,46,36336,60015,00:06:07
21,Portugal,PT,WESTERN EUROPE,106,53,1639878,5211603,00:06:24
22,Belgium,BE,WESTERN EUROPE,102,33,1376172,4710726,00:06:40
23,Singapore,SG,ASIA (EX. NEAR EAST),101,75,746396,5979164,00:06:43
24,Norway,NO,WESTERN EUROPE,101,66,488087,2295463,00:06:43
25,Romania,RO,EASTERN EUROPE,100,66,47241,321440,00:06:47
26,North Macedonia,MK,EASTERN EUROPE,97,88,8452,22761,00:06:58
27,New Zealand,NZ,OCEANIA,97,09,634225,4176898,00:07:02
28,Slovenia,SI,EASTERN EUROPE,97,00,11179,70321,00:07:02
29,Puerto Rico,PR,CARIBBEAN,96,65,36396,225018,00:07:04
30,Bermuda,BM,NORTHERN AMERICA,95,58,1720,45476,00:07:09
31,Sweden,SE,WESTERN EUROPE,94,30,328650,2835862,00:07:14
32,Poland,PL,EASTERN EUROPE,94,10,79705,731684,00:07:15
33,South Korea,KR,ASIA (EX. NEAR EAST),94,00,30107,254109,00:07:16
34,United Kingdom,GB,WESTERN EUROPE,93,63,16484752,75308937,00:07:17
35,Barbados,BB,CARIBBEAN,93,50,2573,18758,00:07:18
36,Moldova,MD,EASTERN EUROPE,92,10,5730,23817,00:07:25
37,Lithuania,LT,BALTICS,87,09,10648,57470,00:07:50
38,Estonia,EE,BALTICS,86,39,8607,48012,00:07:54
39,Isle of Man,IM,WESTERN EUROPE,85,89,1896,22378,00:07:57
40,Chile,CL,SOUTH AMERICA,85,49,702023,2612113,00:07:59
41,Hong Kong,HK,ASIA (EX. NEAR EAST),83,05,34510,733808,00:08:13
42,Germany,DE,WESTERN EUROPE,81,73,21403228,51849465,00:08:21
43,Republic of Ireland,IE,WESTERN EUROPE,76,16,1295718,7567127,00:08:58
44,Switzerland,CH,WESTERN EUROPE,75,39,59842,4011480,00:09:03
45,Grenada,GD,CARIBBEAN,75,21,731,4582,00:09:05
46,Israel,IL,NEAR EAST,75,03,58312,348390,00:09:06
47,Aruba,AW,CARIBBEAN,73,42,4637,28182,00:09:18
48,Brazil,BR,SOUTH AMERICA,72,70,26553147,81598136,00:09:23
49,United States Virgin Islands,VI,CARIBBEAN,67,38,1322,24601,00:10:08
50,Latvia,LV,BALTICS,66,79,8329,39697,00:10:13
51,Dominica,DM,CARIBBEAN,66,24,684,2127,00:10:18
52,Guernsey,GG,WESTERN EUROPE,66,14,964,14130,00:10:19
53,Vatican City,VA,WESTERN EUROPE,65,46,103,310,00:10:26
54,Hungary,HU,EASTERN EUROPE,63,41,47841,1027317,00:10:46
55,Finland,FI,WESTERN EUROPE,62,82,31310,809529,00:10:52
56,Thailand,TH,ASIA (EX. NEAR EAST),62,75,2919421,9235972,00:10:53
57,Saint Pierre and Miquelon,PM,NORTHERN AMERICA,60,77,308,1449,00:11:14
58,Serbia,RS,EASTERN EUROPE,60,53,468608,3020848,00:11:17
59,British Virgin Islands,VG,CARIBBEAN,59,69,894,3342,00:11:26
60,The Bahamas,BS,CARIBBEAN,58,95,4479,41476,00:11:35
61,Italy,IT,WESTERN EUROPE,58,22,7460908,34406925,00:11:44
62,Russia,RU,CIS (FORMER USSR),57,95,257127,815239,00:11:47
63,Saint Vincent and the Grenadines,VC,CARIBBEAN,57,71,393,2611,00:11:50
64,Kosovo,XK,EASTERN EUROPE,57,32,8017,22859,00:11:55
65,Panama,PA,CENTRAL AMERICA,56,93,24230,117852,00:12:00
66,Trinidad and Tobago,TT,CARIBBEAN,56,08,7568,71326,00:12:10
67,Austria,AT,WESTERN EUROPE,55,82,1305232,5377013,00:12:14
68,Greece,GR,EASTERN EUROPE,53,85,193928,594041,00:12:41
69,Australia,AU,OCEANIA,51,27,6187694,28968105,00:13:19
70,Qatar,QA,NEAR EAST,50,68,26460,79800,00:13:28
71,Denmark,DK,WESTERN EUROPE,49,98,29376,2842360,00:13:39
72,Montenegro,ME,EASTERN EUROPE,49,46,4792,16397,00:13:48
73,Turks and Caicos Islands,TC,CARIBBEAN,48,95,1878,9357,00:13:57
74,India,IN,ASIA (EX. NEAR EAST),47,99,73757528,269318266,00:14:13
75,Bahrain,BH,NEAR EAST,47,72,9938,51016,00:14:18
76,Saint Kitts and Nevis,KN,CARIBBEAN,47,27,653,3475,00:14:27
77,Czech Republic,CZ,EASTERN EUROPE,46,81,393185,6580080,00:14:35
78,Guadeloupe,GP,CARIBBEAN,45,93,17607,62853,00:14:52
79,Réunion,RE,SUB-SAHARAN AFRICA,45,51,18754,58890,00:15:00
80,Colombia,CO,SOUTH AMERICA,45,13,1646284,7283446,00:15:08
81,Jamaica,JM,CARIBBEAN,45,07,10537,61405,00:15:09
82,Bosnia and Herzegovina,BA,EASTERN EUROPE,44,01,13949,37873,00:15:31
83,Saint Lucia,LC,CARIBBEAN,43,86,914,14534,00:15:34
84,United Arab Emirates,AE,NEAR EAST,43,62,130796,746023,00:15:39
85,Collectivity of Saint Martin,MF,CARIBBEAN,43,44,2215,10073,00:15:43
86,Philippines,PH,ASIA (EX. NEAR EAST),43,36,5120974,40835141,00:15:45
87,Argentina,AR,SOUTH AMERICA,43,02,1502271,6268045,00:15:52
88,Cyprus,CY,NEAR EAST,42,93,107564,628537,00:15:54
89,Paraguay,PY,SOUTH AMERICA,42,76,22252,78089,00:15:58
90,Costa Rica,CR,CENTRAL AMERICA,42,51,36848,211296,00:16:04
91,Malaysia,MY,ASIA (EX. NEAR EAST),42,20,118811,1177895,00:16:11
92,Faroe Islands,FO,WESTERN EUROPE,41,97,199,509,00:16:16
93,Curaçao,CW,CARIBBEAN,41,51,8350,41012,00:16:27
94,Saint Barthélemy,BL,CARIBBEAN,41,22,1066,2395,00:16:34
95,Greenland,GL,NORTHERN AMERICA,41,19,307,18925,00:16:34
96,Peru,PE,SOUTH AMERICA,41,04,850087,5409461,00:16:38
97,Kuwait,KW,NEAR EAST,41,02,35425,83481,00:16:38
98,Bulgaria,BG,EASTERN EUROPE,40,43,22983,696373,00:16:53
99,Rwanda,RW,SUB-SAHARAN AFRICA,39,89,2813,11698,00:17:07
100,Belize,BZ,CENTRAL AMERICA,38,86,2811,13327,00:17:34
101,Ukraine,UA,CIS (FORMER USSR),38,13,65651,402188,00:17:54
102,French Guiana,GF,SOUTH AMERICA,37,98,6066,21411,00:17:58
103,Marshall Islands,MH,OCEANIA,36,89,418,2274,00:18:30
104,South Africa,ZA,SUB-SAHARAN AFRICA,36,46,2046338,17623221,00:18:44
105,Martinique,MQ,CARIBBEAN,35,87,14117,43297,00:19:02
106,Mexico,MX,CENTRAL AMERICA,35,85,5387439,17623836,00:19:03
107,New Caledonia,NC,OCEANIA,35,72,6467,29923,00:19:07
108,Burkina Faso,BF,SUB-SAHARAN AFRICA,35,64,4133,20935,00:19:09
109,Belarus,BY,CIS (FORMER USSR),34,10,15212,39714,00:20:01
110,Northern Mariana Islands,MP,OCEANIA,34,03,202,888,00:20:03
111,Armenia,AM,CIS (FORMER USSR),33,63,11765,38678,00:20:18
112,Jordan,JO,NEAR EAST,33,63,39484,102145,00:20:18
113,Oman,OM,NEAR EAST,32,61,42748,116459,00:20:56
114,Saudi Arabia,SA,NEAR EAST,32,42,465974,826893,00:21:03
115,Brunei,BN,ASIA (EX. NEAR EAST),32,07,2574,15421,00:21:17
116,Guyana,GY,SOUTH AMERICA,31,45,4710,25436,00:21:42
117,Mauritius,MU,SUB-SAHARAN AFRICA,29,78,8652,36715,00:22:56
118,Vietnam,VN,ASIA (EX. NEAR EAST),29,25,476824,973382,00:23:20
119,Anguilla,AI,CARIBBEAN,29,15,406,3107,00:23:25
120,Antigua and Barbuda,AG,CARIBBEAN,27,03,1326,4822,00:25:15
121,Ecuador,EC,SOUTH AMERICA,26,56,113168,674328,00:25:42
122,Bonaire,BQ,CARIBBEAN,26,27,1933,7917,00:25:59
123,Guam,GU,OCEANIA,25,75,1752,19484,00:26:30
124,Croatia,HR,EASTERN EUROPE,25,72,43772,804260,00:26:33
125,Albania,AL,EASTERN EUROPE,25,36,11344,638445,00:26:55
126,Nicaragua,NI,CENTRAL AMERICA,25,28,11166,102968,00:27:00
127,Turkey,TR,NEAR EAST,24,84,286257,709443,00:27:29
128,El Salvador,SV,CENTRAL AMERICA,23,56,20417,148104,00:28:59
129,Guatemala,GT,CENTRAL AMERICA,23,26,29313,258011,00:29:21
130,American Samoa,AS,OCEANIA,22,01,129,2637,00:31:01
131,Uzbekistan,UZ,CIS (FORMER USSR),21,67,19639,455186,00:31:31
132,Sri Lanka,LK,ASIA (EX. NEAR EAST),21,23,30139,61665,00:32:10
133,Nigeria,NG,SUB-SAHARAN AFRICA,20,83,129594,1700144,00:32:46
134,Madagascar,MG,SUB-SAHARAN AFRICA,20,43,34608,221824,00:33:25
135,Bhutan,BT,ASIA (EX. NEAR EAST),20,08,689,1455,00:34:00
136,Nepal,NP,ASIA (EX. NEAR EAST),19,99,58044,274198,00:34:09
137,Dominican Republic,DO,CARIBBEAN,19,48,104291,331598,00:35:03
138,Seychelles,SC,SUB-SAHARAN AFRICA,18,75,1500,7796,00:36:24
139,Georgia,GE,CIS (FORMER USSR),18,54,27041,70315,00:36:49
140,Laos,LA,ASIA (EX. NEAR EAST),17,64,4438,11861,00:38:42
141,Mayotte,YT,SUB-SAHARAN AFRICA,17,34,1616,6417,00:39:22
142,Kyrgyzstan,KG,CIS (FORMER USSR),17,31,4802,11199,00:39:26
143,Honduras,HN,CENTRAL AMERICA,16,76,17804,144993,00:40:44
144,Morocco,MA,NORTHERN AFRICA,16,49,1967391,8614215,00:41:23
145,Ivory Coast,CI,SUB-SAHARAN AFRICA,16,45,8090,31461,00:41:30
146,Mongolia,MN,ASIA (EX. NEAR EAST),16,40,4930,58464,00:41:38
147,Sint Maarten,SX,CARIBBEAN,16,00,4572,14301,00:42:39
148,Bolivia,BO,SOUTH AMERICA,16,00,50271,339579,00:42:40
149,Cambodia,KH,ASIA (EX. NEAR EAST),14,68,15725,84178,00:46:30
150,French Polynesia,PF,OCEANIA,14,55,18122,45150,00:46:55
151,Republic of the Congo,CG,SUB-SAHARAN AFRICA,14,36,2967,11750,00:47:33
152,Indonesia,ID,ASIA (EX. NEAR EAST),14,30,5385571,49341766,00:47:44
153,Fiji,FJ,OCEANIA,13,96,1174,5794,00:48:55
154,Iran,IR,ASIA (EX. NEAR EAST),13,93,191428,277957,00:48:59
155,Kazakhstan,KZ,CIS (FORMER USSR),13,13,71138,251563,00:51:58
156,China,CN,ASIA (EX. NEAR EAST),12,66,91997,322892,00:53:55
157,Uganda,UG,SUB-SAHARAN AFRICA,12,64,44762,631667,00:54:00
158,Maldives,MV,ASIA (EX. NEAR EAST),12,49,2484,11717,00:54:40
159,Suriname,SR,SOUTH AMERICA,12,48,2894,11377,00:54:43
160,Kenya,KE,SUB-SAHARAN AFRICA,12,46,458693,8143334,00:54:48
161,Ghana,GH,SUB-SAHARAN AFRICA,12,33,39847,608035,00:55:22
162,Tanzania,TZ,SUB-SAHARAN AFRICA,11,92,46650,479395,00:57:15
163,Lesotho,LS,SUB-SAHARAN AFRICA,11,75,345,781,00:58:06
164,Palestinian National Authority,PS,NEAR EAST,11,59,49882,101640,00:58:54
165,Cape Verde,CV,SUB-SAHARAN AFRICA,11,49,1718,3967,00:59:25
166,Gabon,GA,SUB-SAHARAN AFRICA,11,22,12444,25502,01:00:51
167,Mozambique,MZ,SUB-SAHARAN AFRICA,11,06,45615,232367,01:01:43
168,Venezuela,VE,SOUTH AMERICA,10,92,325008,1238106,01:02:31
169,Namibia,NA,SUB-SAHARAN AFRICA,10,80,3661,13869,01:03:11
170,Haiti,HT,CARIBBEAN,10,75,3278,6773,01:03:29
171,Azerbaijan,AZ,CIS (FORMER USSR),10,20,36962,123226,01:06:54
172,Egypt,EG,NORTHERN AFRICA,9,75,973533,1464826,01:10:03
173,Botswana,BW,SUB-SAHARAN AFRICA,9,61,2092,35395,01:11:02
174,Tunisia,TN,NORTHERN AFRICA,9,60,1156021,3477430,01:11:06
175,Solomon Islands,SB,OCEANIA,9,51,137,447,01:11:48
176,Iraq,IQ,NEAR EAST,9,37,83628,522503,01:12:53
177,Senegal,SN,SUB-SAHARAN AFRICA,9,22,27628,70208,01:14:05
178,Zimbabwe,ZW,SUB-SAHARAN AFRICA,9,18,5456,22426,01:14:24
179,Angola,AO,SUB-SAHARAN AFRICA,9,13,6242,20128,01:14:48
180,Benin,BJ,SUB-SAHARAN AFRICA,9,12,2282,16713,01:14:53
181,Myanmar,MM,ASIA (EX. NEAR EAST),9,02,46167,435660,01:15:42
182,Mauritania,MR,NORTHERN AFRICA,8,95,3086,10605,01:16:17
183,Togo,TG,SUB-SAHARAN AFRICA,8,90,14704,33969,01:16:40
184,Papua New Guinea,PG,OCEANIA,8,75,723,4440,01:18:02
185,Guinea,GN,SUB-SAHARAN AFRICA,8,50,617,1645,01:20:20
186,Malawi,MW,SUB-SAHARAN AFRICA,8,26,769,3344,01:22:38
187,Algeria,DZ,NORTHERN AFRICA,7,73,347341,590449,01:28:19
188,Mali,ML,SUB-SAHARAN AFRICA,7,56,5427,12451,01:30:21
189,Sierra Leone,SL,SUB-SAHARAN AFRICA,7,00,1041,5220,01:37:30
190,Vanuatu,VU,OCEANIA,6,57,166,1069,01:43:59
191,Lebanon,LB,NEAR EAST,6,55,19908,179260,01:44:17
192,Zambia,ZM,SUB-SAHARAN AFRICA,6,53,2841,24036,01:44:31
193,São Tomé and Príncipe,ST,SUB-SAHARAN AFRICA,6,52,582,1463,01:44:41
194,Bangladesh,BD,ASIA (EX. NEAR EAST),6,41,117359,1460551,01:46:26
195,Libya,LY,NORTHERN AFRICA,6,32,13385,62233,01:48:05
196,Chad,TD,SUB-SAHARAN AFRICA,5,83,259,647,01:57:02
197,Eswatini,SZ,SUB-SAHARAN AFRICA,5,76,862,3607,01:58:34
198,Liberia,LR,SUB-SAHARAN AFRICA,5,60,593,3156,02:01:49
199,Niger,NE,SUB-SAHARAN AFRICA,5,50,1195,5202,02:04:12
200,Pakistan,PK,ASIA (EX. NEAR EAST),5,32,276947,700765,02:08:15
201,Sudan,SD,SUB-SAHARAN AFRICA,5,24,7123,14915,02:10:15
202,Guinea-Bissau,GW,SUB-SAHARAN AFRICA,5,09,188,524,02:14:13
203,Somalia,SO,SUB-SAHARAN AFRICA,5,00,2349,19656,02:16:32
204,Djibouti,DJ,SUB-SAHARAN AFRICA,4,66,979,2201,02:26:37
205,Democratic Republic of the Congo,CD,SUB-SAHARAN AFRICA,4,62,2451,10618,02:27:41
206,Turkmenistan,TM,CIS (FORMER USSR),4,49,127,206,02:31:55
207,The Gambia,GM,SUB-SAHARAN AFRICA,4,35,2609,8187,02:37:06
208,Federated States of Micronesia,FM,OCEANIA,4,25,177,1063,02:40:34
209,Cuba,CU,CARIBBEAN,4,14,7326,16858,02:44:46
210,South Sudan,SS,SUB-SAHARAN AFRICA,3,89,350,1207,02:55:40
211,Burundi,BI,SUB-SAHARAN AFRICA,3,70,264,864,03:04:33
212,Ethiopia,ET,SUB-SAHARAN AFRICA,3,54,26200,184186,03:12:48
213,Cameroon,CM,SUB-SAHARAN AFRICA,3,16,3864,18333,03:35:58
214,Tajikistan,TJ,CIS (FORMER USSR),2,98,1774,6995,03:49:05
215,Wallis and Futuna,WF,OCEANIA,2,72,159,629,04:11:12
216,Equatorial Guinea,GQ,SUB-SAHARAN AFRICA,2,70,369,5230,04:13:16
217,East Timor,TL,ASIA (EX. NEAR EAST),2,50,212,581,04:32:43
218,Syria,SY,NEAR EAST,2,30,37125,51559,04:56:42
219,Yemen,YE,NEAR EAST,1,79,57860,130983,06:20:55
220,Afghanistan,AF,ASIA (EX. NEAR EAST),1,71,8333,41286,06:38:36
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment