...
Pinger data explorer is primarily used to visualize the trends in the Internet end-to-end performance statistics measured over 200 170 countries from +90 active PingER monitoring hosts. Having gathered data since 1998, the explorer graphs enable the users to study the trends, step changes, significant improvements/degradations.
...
With all the metric files in the above format, a file has to be generated with data for allmetrics altogether as below:
Code Block |
---|
#countryountry,year,population,average_rtt,ipdv,minimum_rtt,MOS,nthroughput,throughput,unreachability,packet_loss,internetusers, #Internet_Penetration, DOI, HDI, CPI, IDI AFG,1998,22441529 FG,1998,18511480, , , , , , , , ,,0.1,0,0,0,0 AFG FG,1999,2302825419038420, , , , , , , , ,,0.1,0,0,0,0 AFGFG,2000,2363032019701940, , , , , , , , ,,0.1,0,0,0,0 AFG FG,2001,2423221920531160, , , , , , , , ,1000,0.1,0,0,0,0 AFG,2002,2484944921487079, , , , , , , , ,1000 AFG,0.12003,022507368,0 , , , , , , , ,20000 AFG,2004,23499850, , , , , , , , ,25000 AFG,2005,24399948, , , , , , , , ,300000 AFG,2006,25183615, , , , , , , , ,535000 AFG,2007,25877544,766.542,14.959,684.521, , ,104.390,12.784,12.784,500000 AFG,2008,26528741,732.168,11.963,688.990, , ,185.696,6.971,6.971,500000 AFG,2009,27207291,757.940,15.615,679.949, , ,162.520,9.399,9.399,100000 AFG,2010,27962207,758.457,16.102,673.438, , ,145.039,4.791,4.791,900472.2222 AFG,2011,28809167,748.252,12.247,695.982, , ,182.375,1.448,1.448,1016522.222 AFG,2012,29726803,742.298,12.135,696.738, , ,289.165,27.145,27.145, AFG,2013,30682500,729.152,13.043,561.894, , ,335.934,37.886,37.886, AFG,2014,31627506,506.886,5.919,306.091, , ,303.197,0.232,0.232, AFG,2015,32510236,334.816,2.335,161.226, , ,392.257,0.214,0.214, AFG,2016,34832396,310.830,2.485,275.268, , ,585.247,0.572,0.572, AFG,2017,69664776,289.552,0.982,256.032, , ,694.266,0.580,0.580, AFG,2018,71406395,290.077,3.220,263.951, , ,865.366,16.359,16.359, AFG,2019,73148014,272.802,1.064,232.858, , ,800.593,0.255,0.255, ALB,1998,3128530, , , , , , , , ,2000 ALB,1999,3108778, , , , , , , , ,2500 ALB,2000,3089027, , , , , , , , ,3500 ALB,2001,3060173, , , , , , , , ,10000 ALB,2002,3051010, , , , , , , , ,12000 ALB,2003,3039616, , , , , , , , ,30000 ALB,2004,3026939, , , , , , , , ,75000 ALB,2005,3011487, , , , , , , , ,188000 ALB,2006,2992547, , , , , , , , ,300000 ALB,2007,2970017, , , , , , , , ,471000 ALB,2008,2947314,234.798,1.700,211.463, , ,692.675,1.204,1.204,750000 ALB,2009,2927519,227.456,2.672,201.217, , ,478.448,2.437,2.437,1300000 ALB,2010,2913021,240.834,4.107,210.101, , ,323.681,2.985,2.985,719805.7143 ALB,2011,2904780,219.940,0.858,192.671, , ,669.506,0.476,0.476,783557.6786 ALB,2012,2900489,217.436,0.661,183.491, , ,1324.090,0.839,0.839, ALB,2013,2897366,215.515,7.396,178.691, , ,503.866,0.086,0.086, ALB,2014,2894475,210.308,1.616,176.654, , ,839.650,0.126,0.126, ALB,2015,3540536,209.244,0.606,191.528, , ,868.063,0.111,0.111, ALB,2016,3793431,199.113,2.030,182.726, , ,915.164,0.240,0.240, ALB,2017,11949284,203.075,5.471,176.711, , ,837.439,0.932,0.932, ALB,2018,12138955,183.536,1.630,175.506, , ,816.885,0.315,0.315, ALB,2019,12328626,187.683,1.180,179.347, , ,991.819,0.471,0.471, DZA,1998,30336880, , , , , , , , ,6000 DZA,1999,30766551, , , , , , , , ,60000 |
Code Block |
---|
#country,year,population,average_rtt,ipdv,minimum_rtt,MOS,nthroughput,throughput,unreachability,packet_loss,internetusers, #Internet_Penetration, DOI, HDI, CPI, IDI AFG,1998,22441529, , , , , , , , ,,0.1,0,0,0,0 AFG,1999,23028254, , , , , , , , ,,0.1,0,0,0,0 AFG,2000,23630320, , , , , , , , ,,0.1,0,0,0,0 AFG,2001,24232219, , , , , , , , ,1000,0.1,0,0,0,0 AFG,2002,24849449, , , , , , , , ,1000,0.1,0,0,0,0,0 AFG,2003,25482401, , , , , , , , ,20000,0.1,0,0,0,0 AFG,2004,26131476, , , , , , , , ,25000,0.1,0,0.347,0,0 AFG,2005,26797083, , , , , , , , ,300000,0.1,0,0.347,2.5,0 AFG,2006,27518809, , , , , , , , ,535000,0.1,0,0.35,0,0 AFG,2007,28259973,767.453,13.43,697.938,1.2,100.822,100.822,12.859,2.279,500000,0.1,0,0.352,1.8,0 AFG,2008,29021099,732.841,8.295,696.396,1.5,175.8,175.8,4.813,0.836,500000,0.1,0,0.352,1.5,0 AFG,2009,29802724,728.492,6.604,687.919,1.6,216.936,216.936,9.495,0.564,1000000,1.5,0,0.352,1.3,0 AFG,2010,30175351,750.94,10.811,675.284,1.5,128.965,128.965,7.024,2.279,900472.2222,1.5,0,0.352,1.3,0 AFG,2011,30823706,743.08,9.967,684.141,1.7,142.843,142.843,9.709,1.534,1016522.222,1.5,0,0.352,1.3,0 ALB,1998,3075628, , , , , , , , ,2000,2.4,0.36,0.784,0,0 ALB,1999,3069856, , , , , , , , ,2500,2.4,0.36,0.784,0,0 ALB,2000,3067556, , , , , , , , ,3500,2.4,0.36,0.784,0,0 ALB,2001,3069383, , , , , , , , ,10000,2.4,0.36,0.784,0,0 ALB,2002,3076282, , , , , , , , ,12000,2.4,0.36,0.801,2.5,1.92 ALB,2003,3086736, , , , , , , , ,30000,2.4,0.36,0.801,2.5,1.92 ALB,2004,3098677, , , , , , , , ,75000,2.4,0.36,0.811,2.5,1.92 ALB,2005,3110579, , , , , , , , ,188000,2.4,0.36,0.811,2.4,1.92 ALB,2006,3121751, , , , , , , , ,300000,2.4,0.37,0.814,2.6,1.92 ALB,2007,3132458, , , , , , , , ,471000,2.4,0.37,0.818,2.9,2.73 ALB,2008,3143291,234.933,5.869,204.462,4,584.968,584.968,8.125,0.728,750000,2.4,0.37,0.818,3.4,2.73 ALB,2009,3155271,235.681,7.91,197.166,3.9,527.683,527.683,7.358,0.884,1300000,16,0.37,0.818,3.2,2.73 ALB,2010,3140420,254.324,10.106,199.379,3.8,406.381,406.381,4.935,1.613,719805.7143,16,0.37,0.818,3.2,2.73 ALB,2011,3145807,225.474,1.847,200.22,4,602.674,602.674,24.037,0.759,783557.6786,16,0.37,0.818,3.2,2.73 DZA,1998,29646386, , , , , , , , ,6000,2.6,0.39,0.713,0,0 DZA,1999,30071594, , , , , , , , ,60000,2.6,0.39,0.713,0,0 DZA,2000,30506054, , , , , , , , ,150000,2.6,0.39,0.713,0,0 |
This is the format required by Google data Explorer. The file in above format is generated by running the script /afs/slac.stanford.edu/package/pinger/explorer/generate-alldata-file-for-pinger-data-explorer.pl which takes the files generated by/afs/slac.stanford.edu/package/pinger/explorergenerate-metric-files-for-explorer.pl as input files and outputs a file named 'file.csv' with all the metric data in the format required by Google Data Explorer.
...
- Tool: The interactive graph was generated using the Google Public Data Explorer. Also see https://www.google.com/publicdata/directory
- Now the data for Pinger Data Explorer is under pinger.slac@gmail.com (May/2016).
- Data: The data presented here was collected by the PingER project, processed by prmout. The same data is available in tabular format. The statistics of Population and internet users were acquired from the World bank , the country to region mapping was obtained by the geographical database maintained by the PingER project, the Corruption Perception Index (CPI) was taken from Transparency International and extracted from Wikipedia , the Digital Opportunity Index (DOI) is obtained from ITU's ICT Statistics , Human Development Index (HDI) is obtained from UNDP Human development reports and ICT Development Index (IDI) is obtained from ITU Reports .
- Please note that while all the statistics were acquired over several years (i.e. since 1998), the Internet usage statistics were documented in Nov. 2007.
- Loading: The time to load and render the web page is largely determined speed of the link, the file length (about a MByte that is determined by the number of metrics and frequency of data points and the number of metrics) and the speed of the client rendering.
- Metrics: Average RTT (ms), Normalized Throughput (Kbps), Throughput (Kbps), Internet Users (#), Population (#), Minimum RTT (ms), Packet Loss (%), Unreachability (%), IPDV (ms), MOS, IDI, HDI, DOI, CPI and Internet penetration Index.Now the data for Pinger Data Explorer is under pinger.slac@gmail.com (May/2016).
- Authors: Faisal Zahid & Amber Zeb 29/8/2011. Idea champion: Faisal Zahid.
...