Template:Testing for COVID-19

%5B%5BWikipedia%3ATemplates+for+discussion%2FLog%2F2026+January+13%23Template%3ATesting+for+COVID-19%5D%5D

Template documentation[view] [edit] [history] [purge]

Information

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

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])

The above documentation is transcluded from Template:Testing for COVID-19/doc. (edit | history)
Editors can experiment in this template's sandbox (create | mirror) and testcases (create) pages.
Add categories to the /doc subpage. Subpages of this template.

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.