Page History

...

We can cut and paste this table into Excel to enable further analysis and visualization. Also the summary data is analyzed on a regular basis and the results made available as CSV files at https://www-iepm.slac.stanford.edu/pinger/prmout/. The file names (e.g.average_rtt-EDU.SLAC.STANFORD.PINGER-continent-allmonthly.csv) provide the metric (average_rtt in example), the Monitoring Agent (EDU-SLAC.STANFORD.PINGER in example), the region (continent or country) and the time window of each data point (or Tick, e.g. monthly (=last 12 months), allmonthly, or allyearly).

Using Motion Charts to look at PingER data by metric versus Covid cases

One attempt to explore and correlate the impacts the impact of the Covid-19 virus on Internet responsiveness  is to use a Motion Charts tool to from https://www.charte.ca/ to look for correlations between say Covid-19 cases (cases, hospital admissions, deaths etc.) and PingER metrics as a function of time, by country, continent, plus population or density of population. The idea is that as Covid-19 cases pass say 100, the country will impose interventions such as school closing,  social distancing etc. which will change the usage patterns of the Internet which may have noticeable impacts on the PingER measurements. We use the PingER 'Lasat120daysLast120days' data measured from SLAC as provided and updated daily in https://www-iepm.slac.stanford.edu/pinger/prmout/. The data is available by metric, country Monitoring Agent (in this case pinger.slac.stanford.edu)' as Excel csv files, e.g. ipdv-EDU.SLAC.STANFORD.PINGER-country-last120days.csv.  By means of a script covid.pl we create Excel csv files available at https://www-iepm.slac.stanford.edu/pinger/covid/ by PingER Metric and Covid-19 Confirmation cases and or deaths, e.g. ipdv-confirmed.txt for the last 120 days. These covid/ files are suitable for copying into www.charte.ca to create motion charts for  for a selected Pinger metric's data vs Covid-19  case cases by country by day. N.b. both the PingER 'last120days' data and the tables of the Covid-19 versus the PingER metric are availble publicly via the web, so you can make your own motion charts.

See Using Chart.ca for how to make your own motion charts, and an example. Note since the Covid-19 data for the USA and Austrailia are only available by state and for China are only available by province we currently have not included those countries. Some examples are belowSee Using Chart.ca and an example.

...