Template:Testing for COVID-19/doc
 | This is a documentation subpage for Template:Testing for COVID-19. It may contain usage information, categories and other content that is not part of the original template page. |
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])
- ^ "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.
- ^ "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.