University of Tsukuba is provideing an open VPN service for academic research. http://www.vpngate.net/en/lastlog.aspx. This describes the country of requestors and the country of VPN providers in a 10 minute period.
library(XML); library(dplyr);library(RCurl);library(stringr);library(knitr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union## Loading required package: bitopslog_10min <- getURL("http://www.vpngate.net/en/lastlog.aspx")
log_table <- log_10min %>% htmlParse %>% readHTMLTable(header=F)
log_table <- log_table[[4]]
colnames(log_table) <- c("ID", "Start","End","Dur_min","Origin_of_request","VPN_provider","Protcol","Traffic")
log_table$Dur_min <- str_extract_all(log_table$Dur_min, "[0-9]+") %>% unlist %>% as.numericFollowing table describes the combination of vpn-requestor and vpn-provider in a descending order of session numbers:
vpn_sessions<-log_table %>% group_by(Origin_of_request,VPN_provider) %>% summarise(Num_Session=n(), Total_min=sum(Dur_min)) %>% arrange(desc(Num_Session)) %>% data.frame()
cat("Data acquisition time: ", as.character(Sys.time()))## Data acquisition time: 2017-01-14 15:24:12kable(vpn_sessions,format="markdown")| Origin_of_request | VPN_provider | Num_Session | Total_min |
|---|---|---|---|
| Philippines | Japan | 419 | 2035 |
| Philippines | Korea Republic of | 192 | 970 |
| Taiwan | Japan | 110 | 476 |
| Indonesia | Japan | 99 | 498 |
| China | Japan | 96 | 480 |
| Korea Republic of | Japan | 93 | 489 |
| Iran (ISLAMIC Republic Of) | Japan | 90 | 447 |
| Iran (ISLAMIC Republic Of) | United States | 81 | 368 |
| Viet Nam | Japan | 77 | 370 |
| Japan | Japan | 71 | 366 |
| Korea Republic of | Korea Republic of | 65 | 273 |
| Iran (ISLAMIC Republic Of) | United Kingdom | 63 | 108 |
| China | Korea Republic of | 61 | 238 |
| France | Japan | 61 | 409 |
| United States | United States | 55 | 362 |
| United States | Japan | 54 | 295 |
| Malaysia | Japan | 49 | 201 |
| France | Korea Republic of | 44 | 328 |
| Iran (ISLAMIC Republic Of) | Germany | 42 | 159 |
| China | China | 36 | 202 |
| Thailand | Japan | 34 | 168 |
| Ukraine | Japan | 34 | 167 |
| Hong Kong | Japan | 33 | 178 |
| Nigeria | United States | 32 | 214 |
| United Arab Emirates | Japan | 26 | 113 |
| Philippines | United Kingdom | 25 | 88 |
| Viet Nam | Viet Nam | 25 | 161 |
| Iran (ISLAMIC Republic Of) | Taiwan | 23 | 92 |
| Philippines | Taiwan | 23 | 81 |
| Saudi Arabia | Japan | 23 | 133 |
| Viet Nam | Korea Republic of | 23 | 159 |
| Japan | Korea Republic of | 22 | 106 |
| Thailand | Korea Republic of | 22 | 127 |
| Singapore | Japan | 18 | 88 |
| Germany | Japan | 17 | 37 |
| Indonesia | Korea Republic of | 17 | 99 |
| Iran (ISLAMIC Republic Of) | France | 17 | 59 |
| United States | Korea Republic of | 17 | 92 |
| Taiwan | Korea Republic of | 16 | 102 |
| Ukraine | Korea Republic of | 16 | 86 |
| United Arab Emirates | Germany | 15 | 19 |
| India | Japan | 14 | 82 |
| Syrian Arab Republic | United States | 14 | 36 |
| Canada | Japan | 13 | 72 |
| France | Thailand | 13 | 72 |
| Philippines | Canada | 13 | 80 |
| Venezuela | United States | 13 | 48 |
| France | United States | 12 | 83 |
| Philippines | United States | 12 | 83 |
| Syrian Arab Republic | Japan | 12 | 37 |
| Viet Nam | United States | 12 | 69 |
| Australia | Japan | 10 | 50 |
| Iran (ISLAMIC Republic Of) | Korea Republic of | 10 | 52 |
| Russian Federation | Japan | 10 | 77 |
| United States | Viet Nam | 10 | 37 |
| France | Viet Nam | 9 | 57 |
| Hong Kong | Korea Republic of | 9 | 47 |
| Iran (ISLAMIC Republic Of) | Canada | 9 | 49 |
| Malaysia | Korea Republic of | 9 | 43 |
| Mexico | Japan | 9 | 43 |
| Viet Nam | Taiwan | 9 | 29 |
| Germany | United States | 8 | 55 |
| Turkmenistan | Japan | 8 | 43 |
| Indonesia | Indonesia | 7 | 25 |
| Philippines | France | 7 | 53 |
| Turkey | United States | 7 | 31 |
| United States | France | 7 | 46 |
| France | Russian Federation | 6 | 31 |
| Hong Kong | Taiwan | 6 | 7 |
| Iran (ISLAMIC Republic Of) | Thailand | 6 | 17 |
| Iran (ISLAMIC Republic Of) | United Arab Emirates | 6 | 26 |
| Japan | Viet Nam | 6 | 32 |
| Netherlands | Japan | 6 | 18 |
| Russian Federation | Russian Federation | 6 | 40 |
| United States | Canada | 6 | 36 |
| Indonesia | United States | 5 | 29 |
| Japan | United States | 5 | 32 |
| Korea Republic of | United States | 5 | 19 |
| Macau | Hong Kong | 5 | 11 |
| Macau | Japan | 5 | 22 |
| Syrian Arab Republic | Korea Republic of | 5 | 43 |
| Thailand | Taiwan | 5 | 9 |
| Ukraine | Russian Federation | 5 | 35 |
| Canada | United States | 4 | 21 |
| China | Taiwan | 4 | 10 |
| Egypt | United States | 4 | 21 |
| France | France | 4 | 34 |
| France | Indonesia | 4 | 27 |
| Gambia | Japan | 4 | 18 |
| Germany | Canada | 4 | 14 |
| India | United States | 4 | 21 |
| Iran (ISLAMIC Republic Of) | Indonesia | 4 | 12 |
| Philippines | Norway | 4 | 29 |
| Philippines | Russian Federation | 4 | 31 |
| Taiwan | Viet Nam | 4 | 21 |
| Turkey | Japan | 4 | 33 |
| Ukraine | Thailand | 4 | 7 |
| United States | Venezuela | 4 | 19 |
| Bangladesh | Japan | 3 | 10 |
| Chile | Japan | 3 | 13 |
| Djibouti | Japan | 3 | 18 |
| Egypt | Korea Republic of | 3 | 17 |
| Germany | Norway | 3 | 15 |
| Ghana | United States | 3 | 11 |
| India | Korea Republic of | 3 | 0 |
| Iran (ISLAMIC Republic Of) | Australia | 3 | 14 |
| Israel | Thailand | 3 | 8 |
| Japan | Taiwan | 3 | 2 |
| Kazakhstan | Russian Federation | 3 | 0 |
| Korea Republic of | Viet Nam | 3 | 23 |
| Malaysia | Taiwan | 3 | 16 |
| Malaysia | United States | 3 | 16 |
| Mexico | Korea Republic of | 3 | 20 |
| New Zealand | Japan | 3 | 3 |
| Philippines | Indonesia | 3 | 9 |
| Philippines | Philippines | 3 | 29 |
| Russian Federation | Viet Nam | 3 | 26 |
| Sudan | Japan | 3 | 18 |
| Ukraine | Viet Nam | 3 | 21 |
| United Arab Emirates | France | 3 | 18 |
| United Arab Emirates | Russian Federation | 3 | 15 |
| United Arab Emirates | United Kingdom | 3 | 8 |
| Viet Nam | Germany | 3 | 8 |
| Viet Nam | Indonesia | 3 | 17 |
| Austria | Japan | 2 | 12 |
| Bangladesh | United States | 2 | 10 |
| Brunei Darussalam | Japan | 2 | 2 |
| Cambodia | Thailand | 2 | 9 |
| China | Hong Kong | 2 | 17 |
| Colombia | Japan | 2 | 16 |
| Colombia | United States | 2 | 17 |
| Cote D’ivoire | Korea Republic of | 2 | 6 |
| Dominican Republic | United States | 2 | 11 |
| Egypt | Japan | 2 | 14 |
| France | Canada | 2 | 10 |
| France | Taiwan | 2 | 12 |
| Gambia | Korea Republic of | 2 | 4 |
| Gambia | Ukraine | 2 | 9 |
| Germany | Germany | 2 | 15 |
| Iran (ISLAMIC Republic Of) | Russian Federation | 2 | 4 |
| Jamaica | United States | 2 | 11 |
| Japan | Indonesia | 2 | 3 |
| Korea Republic of | Thailand | 2 | 8 |
| Malaysia | Germany | 2 | 8 |
| Myanmar | United Kingdom | 2 | 2 |
| Oman | Hong Kong | 2 | 9 |
| Saudi Arabia | Greece | 2 | 3 |
| Saudi Arabia | Korea Republic of | 2 | 1 |
| Saudi Arabia | Spain | 2 | 6 |
| Saudi Arabia | United States | 2 | 13 |
| Saudi Arabia | Viet Nam | 2 | 8 |
| Singapore | Korea Republic of | 2 | 13 |
| South Africa | United States | 2 | 9 |
| Spain | United States | 2 | 17 |
| Syrian Arab Republic | France | 2 | 10 |
| Syrian Arab Republic | Germany | 2 | 0 |
| Syrian Arab Republic | Philippines | 2 | 8 |
| Syrian Arab Republic | Taiwan | 2 | 0 |
| Taiwan | Thailand | 2 | 4 |
| Tajikistan | Japan | 2 | 16 |
| Thailand | United States | 2 | 1 |
| Thailand | Viet Nam | 2 | 7 |
| Turkmenistan | Korea Republic of | 2 | 17 |
| Ukraine | Indonesia | 2 | 0 |
| Ukraine | Philippines | 2 | 8 |
| Ukraine | Taiwan | 2 | 8 |
| Ukraine | Venezuela | 2 | 13 |
| United Arab Emirates | Austria | 2 | 6 |
| United Arab Emirates | Korea Republic of | 2 | 10 |
| United Arab Emirates | Taiwan | 2 | 4 |
| United Kingdom | Korea Republic of | 2 | 5 |
| United Kingdom | Taiwan | 2 | 0 |
| United States | Brazil | 2 | 7 |
| United States | Germany | 2 | 17 |
| United States | Indonesia | 2 | 9 |
| United States | Russian Federation | 2 | 12 |
| United States | Sweden | 2 | 14 |
| United States | Taiwan | 2 | 4 |
| Venezuela | Japan | 2 | 6 |
| Venezuela | Korea Republic of | 2 | 10 |
| Viet Nam | Canada | 2 | 19 |
| Viet Nam | Hong Kong | 2 | 17 |
| Viet Nam | United Kingdom | 2 | 1 |
| Algeria | United States | 1 | 5 |
| Argentina | Indonesia | 1 | 6 |
| Argentina | Mexico | 1 | 9 |
| Argentina | Russian Federation | 1 | 9 |
| Argentina | United States | 1 | 7 |
| Australia | Korea Republic of | 1 | 9 |
| Austria | Canada | 1 | 7 |
| Austria | France | 1 | 9 |
| Azerbaijan | United States | 1 | 7 |
| Bolivia | Japan | 1 | 0 |
| Bolivia | United States | 1 | 9 |
| Bosnia and Herzegowina | Japan | 1 | 9 |
| Brazil | Brazil | 1 | 0 |
| Brazil | Canada | 1 | 0 |
| Brazil | Russian Federation | 1 | 9 |
| Bulgaria | Japan | 1 | 1 |
| Cambodia | Japan | 1 | 9 |
| Cameroon | Germany | 1 | 10 |
| Canada | Canada | 1 | 10 |
| Canada | Thailand | 1 | 8 |
| Chad | United States | 1 | 5 |
| Chile | Mexico | 1 | 1 |
| China | Canada | 1 | 10 |
| China | Dominican Republic | 1 | 1 |
| China | Russian Federation | 1 | 9 |
| China | Singapore | 1 | 9 |
| China | Viet Nam | 1 | 0 |
| Colombia | Korea Republic of | 1 | 10 |
| Costa Rica | Japan | 1 | 9 |
| Czech Republic | Japan | 1 | 6 |
| Denmark | Japan | 1 | 1 |
| Denmark | Korea Republic of | 1 | 1 |
| Egypt | Saudi Arabia | 1 | 1 |
| El Salvador | Viet Nam | 1 | 9 |
| Ethiopia | Japan | 1 | 8 |
| Ethiopia | Korea Republic of | 1 | 4 |
| France | Australia | 1 | 4 |
| France | Bangladesh | 1 | 10 |
| France | Bulgaria | 1 | 9 |
| France | Finland | 1 | 8 |
| France | Germany | 1 | 9 |
| France | India | 1 | 5 |
| France | Macau | 1 | 7 |
| France | Mexico | 1 | 5 |
| France | Morocco | 1 | 7 |
| France | Netherlands | 1 | 0 |
| France | Oman | 1 | 8 |
| France | Saudi Arabia | 1 | 2 |
| France | Singapore | 1 | 4 |
| France | Spain | 1 | 7 |
| France | Syrian Arab Republic | 1 | 6 |
| France | Tunisia | 1 | 10 |
| France | Ukraine | 1 | 3 |
| Gambia | Germany | 1 | 7 |
| Gambia | Taiwan | 1 | 7 |
| Germany | Greece | 1 | 5 |
| Germany | Italy | 1 | 5 |
| Germany | Slovakia (SLOVAK Republic) | 1 | 0 |
| Germany | Taiwan | 1 | 0 |
| Germany | United Kingdom | 1 | 0 |
| Ghana | Spain | 1 | 8 |
| Guatemala | Korea Republic of | 1 | 6 |
| Hong Kong | Hong Kong | 1 | 0 |
| India | Canada | 1 | 6 |
| India | Russian Federation | 1 | 0 |
| India | Taiwan | 1 | 6 |
| Indonesia | Russian Federation | 1 | 4 |
| Indonesia | Taiwan | 1 | 1 |
| Indonesia | Venezuela | 1 | 8 |
| Indonesia | Viet Nam | 1 | 7 |
| Iran (ISLAMIC Republic Of) | Hong Kong | 1 | 9 |
| Iran (ISLAMIC Republic Of) | Montenegro | 1 | 0 |
| Iran (ISLAMIC Republic Of) | New Zealand | 1 | 3 |
| Iran (ISLAMIC Republic Of) | Romania | 1 | 6 |
| Iran (ISLAMIC Republic Of) | Viet Nam | 1 | 7 |
| Japan | Canada | 1 | 5 |
| Japan | Russian Federation | 1 | 8 |
| Japan | Thailand | 1 | 0 |
| Japan | Trinidad and Tobago | 1 | 9 |
| Jordan | United States | 1 | 2 |
| Kenya | Lithuania | 1 | 6 |
| Korea Republic of | Argentina | 1 | 9 |
| Korea Republic of | Mexico | 1 | 10 |
| Korea Republic of | Singapore | 1 | 10 |
| Kuwait | Japan | 1 | 9 |
| Lao People’s Democratic Republic | Dominican Republic | 1 | 8 |
| Lao People’s Democratic Republic | Japan | 1 | 4 |
| Latvia | United States | 1 | 7 |
| Lithuania | Japan | 1 | 6 |
| Lithuania | Taiwan | 1 | 1 |
| Lithuania | Viet Nam | 1 | 0 |
| Macau | Taiwan | 1 | 5 |
| Malaysia | Hong Kong | 1 | 9 |
| Malaysia | Netherlands | 1 | 9 |
| Mexico | United States | 1 | 6 |
| Moldova Republic of | Japan | 1 | 8 |
| Mongolia | Japan | 1 | 8 |
| Morocco | Korea Republic of | 1 | 6 |
| Mozambique | Japan | 1 | 5 |
| Myanmar | Indonesia | 1 | 7 |
| Netherlands | Russian Federation | 1 | 7 |
| Nigeria | Australia | 1 | 7 |
| Nigeria | Germany | 1 | 7 |
| Nigeria | Japan | 1 | 4 |
| Norway | Korea Republic of | 1 | 5 |
| Norway | United States | 1 | 5 |
| Oman | Canada | 1 | 1 |
| Oman | Japan | 1 | 9 |
| Oman | Saudi Arabia | 1 | 9 |
| Pakistan | Canada | 1 | 9 |
| Pakistan | United States | 1 | 7 |
| Panama | Korea Republic of | 1 | 4 |
| Peru | Japan | 1 | 0 |
| Peru | Korea Republic of | 1 | 5 |
| Peru | Thailand | 1 | 9 |
| Philippines | Germany | 1 | 9 |
| Philippines | Hong Kong | 1 | 10 |
| Philippines | Latvia | 1 | 6 |
| Philippines | Morocco | 1 | 9 |
| Philippines | New Zealand | 1 | 4 |
| Philippines | Thailand | 1 | 4 |
| Poland | Japan | 1 | 9 |
| Qatar | United Kingdom | 1 | 10 |
| Qatar | United States | 1 | 8 |
| Reserved | Australia | 1 | 1 |
| Romania | Taiwan | 1 | 5 |
| Russian Federation | France | 1 | 9 |
| Russian Federation | India | 1 | 6 |
| Russian Federation | Korea Republic of | 1 | 0 |
| Russian Federation | Ukraine | 1 | 4 |
| Saudi Arabia | Argentina | 1 | 10 |
| Saudi Arabia | Hong Kong | 1 | 9 |
| Singapore | Thailand | 1 | 8 |
| Singapore | Viet Nam | 1 | 1 |
| Somalia | Korea Republic of | 1 | 4 |
| Spain | Korea Republic of | 1 | 7 |
| Switzerland | Japan | 1 | 9 |
| Syrian Arab Republic | Hong Kong | 1 | 0 |
| Syrian Arab Republic | Romania | 1 | 6 |
| Syrian Arab Republic | United Kingdom | 1 | 0 |
| Taiwan | Canada | 1 | 10 |
| Taiwan | United Kingdom | 1 | 7 |
| Taiwan | United States | 1 | 5 |
| Tajikistan | Korea Republic of | 1 | 8 |
| Thailand | Canada | 1 | 3 |
| Thailand | Hong Kong | 1 | 1 |
| Thailand | Russian Federation | 1 | 8 |
| Thailand | Thailand | 1 | 2 |
| Tunisia | Germany | 1 | 8 |
| Turkey | Israel | 1 | 10 |
| Turkey | United Kingdom | 1 | 10 |
| Turkmenistan | Netherlands | 1 | 1 |
| Turkmenistan | United Kingdom | 1 | 6 |
| Turkmenistan | United States | 1 | 0 |
| Ukraine | France | 1 | 3 |
| Ukraine | Hong Kong | 1 | 8 |
| Ukraine | United States | 1 | 8 |
| United Arab Emirates | Bulgaria | 1 | 0 |
| United Arab Emirates | Romania | 1 | 0 |
| United Arab Emirates | United Arab Emirates | 1 | 2 |
| United Arab Emirates | United States | 1 | 5 |
| United Kingdom | Canada | 1 | 3 |
| United Kingdom | Germany | 1 | 0 |
| United Kingdom | Japan | 1 | 4 |
| United States | Bangladesh | 1 | 7 |
| United States | Dominican Republic | 1 | 9 |
| United States | Jamaica | 1 | 0 |
| United States | Kyrgyzstan | 1 | 0 |
| United States | Netherlands | 1 | 5 |
| United States | Palestinian Territory Occupied | 1 | 9 |
| United States | Philippines | 1 | 8 |
| United States | Thailand | 1 | 10 |
| United States | Ukraine | 1 | 9 |
| United States | United Kingdom | 1 | 8 |
| Uruguay | Japan | 1 | 6 |
| Viet Nam | Brazil | 1 | 4 |
| Viet Nam | France | 1 | 8 |
| Viet Nam | Romania | 1 | 1 |
| Viet Nam | Russian Federation | 1 | 9 |