Data on COVID-19 testing has been merged into Wikidata

Time-series data with the daily number of tests for COVID-19 by country.

UPDATE: I merged the data into Wikidata. This way everybody can easily help expand coverage to more countries and help keep up-to-date with the latest published numbers. Get the lastest available data from Wikidata.

• Temporal coverage: 27. January 2020 -- 26. March 2020.
• Spatial coverage: 29 European countries.
• Units/Measurement:
  • Number of people tested:
    • Sweden (SE)
    • Norway (NO)
    • Denmark (DK)
    • United Kingdom (UK)
    • Latvia (LV)
    • Slovenia (SI)
    • Portugal (PT)
  • Number of samples tested:
    • Austria (AT)
    • Finland (FI)
    • Iceland (IS)
    • France (FR)
    • Croatia (HR)
    • Czech Republic (CZ)
    • Estonia (EE)
    • Hungary (HU)
    • Ireland (IE)
    • Lithuania (LT)
    • Poland (PL)
    • Romania (RO)
    • Slovakia (SK)
    • Italy (IT)
• Missing data: Official numbers are missing for the following European countries.
  • Belgium (BE)
  • Ireland (IE)
  • Netherlands (NL)
  • Spain (ES)
  • Switzerland (CH)
  • Germany (DE)
  • Malta (MT)
• Data sources: Official numbers from government agencies or health organisations. In the dataset, each number has a reference.

Useful resources

Data sources: These resources are useful when tracking down official data sources for the number of for COVID-19 tests in different countries.

• List of coronavirus testing data sources compiled by Esteban Ortiz-Ospina at Our World in Data.
• References in the Wikipedia page on COVID-19 testing.

Retrieve numbers from Wikidata: Download the latest data as a CSV file through the Wikidata query service.

Wikidata query to retrieve the number of clinical tests by country:

SELECT ?dates ?testNo ?countryLabel ?itemLabel ?item WHERE {
  ?item wdt:P361 wd:Q83741704.
  ?item p:P8011 ?test. 
  ?test pq:P585 ?dates;
    ps:P8011 ?testNo
  OPTIONAL { ?item wdt:P17 ?country. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY (?countryLabel) (?itemLabel) (?dates)

Wikidata query to retrieve the number of cases, deaths, clinical tests and recoveries by country:

SELECT ?item ?itemLabel ?countryLabel ?locationLabel ?dates ?caseNo ?deathNo ?testNo ?recoverNo  WHERE {
  ?item wdt:P361 wd:Q83741704.
  OPTIONAL { ?item wdt:P17 ?country. }
  OPTIONAL { ?item wdt:P276 ?location. }
  OPTIONAL {
    ?item p:P1603 ?cases.
    ?cases pq:P585 ?dates;
      ps:P1603 ?caseNo.
  }
  OPTIONAL {
    ?item p:P1120 ?deaths.
    ?deaths pq:P585 ?dates;
      ps:P1120 ?deathNo.
  }
  OPTIONAL { 
    ?item p:P8011 ?test. 
    ?test pq:P585 ?dates;
      ps:P8011 ?testNo
  }
  OPTIONAL { 
    ?item p:P8010 ?recover. 
    ?recover pq:P585 ?dates;
      ps:P8010 ?recoverNo
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  FILTER (!isBlank(?caseNo) || !isBlank(?deathNo) || !isBlank(?testNo) || !isBlank(?recoverNo))
}
ORDER BY (?countryLabel) (?locationLabel) (?dates)

Contribute

Please consider contributing your time (or data) to the Wikidata project on COVID-19, fore instance by adding the latest official numbers in your country.

---