Jump to content

Template:Testing for COVID-19/doc

From Wikipedia, the free encyclopedia

Information

[edit]

This template was created in order to record the number of tests of COVID-19.

Here is the source used for testing.[1]

The testing statistics are taken from the GitHub page at https://github.com/owid/covid-19-data/tree/master/public/data/testing (The latest csv)

This is calculated using a Google Sheets file: https://docs.google.com/spreadsheets/d/1a4yZOdhgrwzqoDkW0nq7WtZCVhEZqGJ-rADHb3e10po

Here is how the calculation is done: the data is copied into the Sheets file. Then, all other columns are deleted save the 'Entity' and 'Cumulative total per thousand' columns. The 'cumulative total per column' is then used in a formula in another cell to calculate the percentage of population, and then the average and maximum of the percentage values is taken.

If you wish to contribute, please message the owner of the document at User_talk:sam1370 to gain access.

Usage

[edit]

Get average percentage of population that countries that have reported testing data have tested for COVID-19: {{Testing for COVID-19|avgtested}} (2.6)

Get maximum percentage of population: {{Testing for COVID-19|maxtested}} (17.3)

Get date updated (short): {{Testing for COVID-19|shortdate}} (24 May)

Get date updated (long): {{Testing for COVID-19|longdate}} (24 May 2020)

Get reference: {{Testing for COVID-19|ref}} ([2])

  1. ^ "To understand the global pandemic, we need global testing – the Our World in Data COVID-19 Testing dataset". Our World in Data. Retrieved 2020-04-12.
  2. ^ "To understand the global pandemic, we need global testing – the Our World in Data COVID-19 Testing dataset". Our World in Data. Retrieved 2020-04-12.