variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

12 rows where datasetId = 6150 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, timespan, type, createdAt (date), updatedAt (date)

id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata grapherConfigAdmin shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license grapherConfigETL type sort dataChecksum metadataChecksum
738519 testing_observations   Countries for which we attempted to find data are not included. 2023-07-24 09:57:12 2024-07-31 15:42:03       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{
    "name": "Number of testing observations",
    "yearIsDay": true
}
 0     testing_observations grapher/covid/latest/testing_time_series/testing_time_series#testing_observations   1                 
[]
         int 
[]
 120d514df0be5485be5a9065c37972af ec43b7be4f44073b43791be6b919c9f1
738518 short_term_positivity_rate %   2023-07-24 09:57:11 2024-07-31 15:42:03       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951 % 
{
    "name": "Short-term positivity rate",
    "unit": "%",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "conversionFactor": 100
}
 0     short_term_positivity_rate grapher/covid/latest/testing_time_series/testing_time_series#short_term_positivity_rate   1                 
[]
         float 
[]
 a50beaa48597c1d140c0bc0ee0368d32 1287ee97c083967ca66b23885a4b772a
738517 short_term_tests_per_case tests per confirmed case The number of tests each day divided by the number of confirmed cases each day. The series is smoothed by averaging daily figures over a rolling 7-day window. Not all countries report testing data on a daily basis. To generate this series we assume that testing changed equally on a daily basis over any periods in which no data was reported. 2023-07-24 09:57:10 2024-07-31 15:42:03       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{
    "name": "Tests per confirmed case \u2013 daily",
    "unit": "tests per confirmed case",
    "yearIsDay": true,
    "includeInTable": true
}
 0     short_term_tests_per_case grapher/covid/latest/testing_time_series/testing_time_series#short_term_tests_per_case   1                 
[]
         float 
[]
 e90fe1f2aab1e74ac1e634a47be1ab6b 9ac429265bcd24953bbe1383b8b38904
738516 cumulative_tests_per_case tests per confirmed case The total number of tests to date divided by the total number of confirmed cases. Tests may refer to the number of tests performed or the number of people tested – depending on which is reported by the particular country. 2023-07-24 09:57:10 2024-07-31 15:42:02       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{
    "name": "Tests per confirmed case \u2013 total",
    "unit": "tests per confirmed case",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0     cumulative_tests_per_case grapher/covid/latest/testing_time_series/testing_time_series#cumulative_tests_per_case   1                 
[]
         float 
[]
 523c288f0843da05603faacf8eb21ebe 29b1c8468237fb41ec83b114080af80c
738515 cumulative_positivity_rate % The total number of confirmed cases to date divided by the total number of tests to date, expressed as a percentage. Tests may refer to the number of tests performed or the number of people tested – depending on which is reported by the particular country. 2023-07-24 09:57:10 2024-07-31 15:42:02       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951 % 
{
    "name": "Cumulative positivity rate",
    "unit": "%",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "conversionFactor": 100
}
 0     cumulative_positivity_rate grapher/covid/latest/testing_time_series/testing_time_series#cumulative_positivity_rate   1                 
[]
         float 
[]
 b28ba89e2b97ce6c20d15360b7f207b2 541f77980f02e27512b12d4d8d2eea0a
738514 new_tests_per_thousand_7day_smoothed tests per thousand The series is smoothed by averaging daily figures over a rolling 7-day window. Not all countries report testing data on a daily basis. To generate this series we assume that testing changed equally on a daily basis over any periods in which no data was reported. This produces a complete series of daily figures, which is then averaged over a rolling 7-day window. Tests may refer to the number of tests performed or the number of people tested – depending on which is reported by the particular country. 2023-07-24 09:57:09 2024-07-31 15:42:02       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{
    "name": "Daily tests per thousand people (7-day smoothed)",
    "unit": "tests per thousand",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Albania: tests performed\nAndorra: people tested\nAngola: tests performed\nAntigua and Barbuda: tests performed\nArgentina: tests performed\nArmenia: tests performed\nAustralia: tests performed\nAustria: tests performed\nAzerbaijan: tests performed\nBahamas: tests performed\nBahrain: units unclear\nBangladesh: tests performed\nBelarus: tests performed\nBelgium: tests performed\nBelize: tests performed\nBenin: tests performed\nBhutan: samples tested\nBolivia: tests performed\nBosnia and Herzegovina: tests performed\nBotswana: tests performed\nBrazil: tests performed\nBulgaria: tests performed\nBurkina Faso: tests performed\nBurundi: tests performed\nCambodia: tests performed\nCanada: tests performed\nCape Verde: tests performed\nCentral African Republic: tests performed\nChad: tests performed\nChile: tests performed\nChina: tests performed\nColombia: tests performed\nCosta Rica: people tested\nCote d'Ivoire: tests performed\nCroatia: people tested\nCuba: tests performed\nCyprus: tests performed\nCzechia: tests performed\nDemocratic Republic of Congo: samples tested\nDenmark: tests performed\nDominican Republic: samples tested\nEcuador: people tested\nEl Salvador: tests performed\nEquatorial Guinea: tests performed\nEstonia: tests performed\nEthiopia: tests performed\nFaeroe Islands: people tested\nFiji: tests performed\nFinland: tests performed\nFrance: people tested\nGabon: tests performed\nGambia: tests performed\nGeorgia: tests performed\nGermany: tests performed\nGhana: tests performed\nGreece: samples tested\nGuatemala: people tested\nGuyana: tests performed\nHaiti: tests performed\nHong Kong: tests performed\nHungary: tests performed\nIceland: tests performed\nIndia: samples tested\nIndonesia: people tested\nIran: tests performed\nIraq: samples tested\nIreland: tests performed\nIsrael: tests performed\nItaly: tests performed\nJamaica: samples tested\nJapan: people tested\nJordan: tests performed\nKazakhstan: tests performed\nKenya: tests performed\nKosovo: tests performed\nKuwait: tests performed\nLaos: tests performed\nLatvia: tests performed\nLebanon: tests performed\nLibya: samples tested\nLiechtenstein: tests performed\nLithuania: tests performed\nLuxembourg: tests performed\nMadagascar: tests performed\nMalawi: tests performed\nMalaysia: people tested\nMaldives: samples tested\nMalta: tests performed\nMauritania: tests performed\nMexico: people tested\nMoldova: tests performed\nMongolia: samples tested\nMorocco: people tested\nMozambique: tests performed\nMyanmar: samples tested\nNamibia: tests performed\nNepal: tests performed\nNetherlands: tests performed\nNew Zealand: tests performed\nNigeria: samples tested\nNorth Macedonia: tests performed\nNorway: people tested\nOman: units unclear\nPakistan: tests performed\nPalestine: tests performed\nPanama: tests performed\nPapua New Guinea: tests performed\nParaguay: tests performed\nPeru: tests performed\nPhilippines: people tested\nPoland: people tested\nPortugal: tests performed\nQatar: people tested\nRomania: tests performed\nRussia: tests performed\nRwanda: samples tested\nSaint Kitts and Nevis: people tested\nSaint Vincent and the Grenadines: tests performed\nSaudi Arabia: tests performed\nSenegal: tests performed\nSerbia: people tested\nSingapore: samples tested\nSlovakia: tests performed\nSlovenia: tests performed\nSouth Africa: people tested\nSouth Korea: people tested\nSouth Sudan: tests performed\nSpain: tests performed\nSri Lanka: tests performed\nSuriname: tests performed\nSweden: tests performed\nSwitzerland: tests performed\nTaiwan: people tested\nThailand: tests performed\nTimor: tests performed\nTogo: tests performed\nTrinidad and Tobago: people tested\nTunisia: people tested\nTurkey: tests performed\nUganda: tests performed\nUkraine: tests performed\nUnited Arab Emirates: tests performed\nUnited Kingdom: tests performed\nUnited States: tests performed\nUruguay: people tested\nVietnam: samples tested\nZambia: tests performed\nZimbabwe: tests performed"
}
 0     new_tests_per_thousand_7day_smoothed grapher/covid/latest/testing_time_series/testing_time_series#new_tests_per_thousand_7day_smoothed   1                 
[]
         float 
[]
 43dd0201bc948c7123f9bef36ac06396 19bf9a6b9073fa67db4018b9330113c5
738513 new_tests_7day_smoothed tests The series is smoothed by averaging daily figures over a rolling 7-day window. Not all countries report testing data on a daily basis. To generate this series we assume that testing changed equally on a daily basis over any periods in which no data was reported. Tests may refer to the number of tests performed or the number of people tested – depending on which is reported by the particular country. 2023-07-24 09:57:09 2024-07-31 15:42:02       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{
    "name": "Daily tests (7-day smoothed)",
    "unit": "tests",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Albania: tests performed\nAndorra: people tested\nAngola: tests performed\nAntigua and Barbuda: tests performed\nArgentina: tests performed\nArmenia: tests performed\nAustralia: tests performed\nAustria: tests performed\nAzerbaijan: tests performed\nBahamas: tests performed\nBahrain: units unclear\nBangladesh: tests performed\nBelarus: tests performed\nBelgium: tests performed\nBelize: tests performed\nBenin: tests performed\nBhutan: samples tested\nBolivia: tests performed\nBosnia and Herzegovina: tests performed\nBotswana: tests performed\nBrazil: tests performed\nBulgaria: tests performed\nBurkina Faso: tests performed\nBurundi: tests performed\nCambodia: tests performed\nCanada: tests performed\nCape Verde: tests performed\nCentral African Republic: tests performed\nChad: tests performed\nChile: tests performed\nChina: tests performed\nColombia: tests performed\nCosta Rica: people tested\nCote d'Ivoire: tests performed\nCroatia: people tested\nCuba: tests performed\nCyprus: tests performed\nCzechia: tests performed\nDemocratic Republic of Congo: samples tested\nDenmark: tests performed\nDominican Republic: samples tested\nEcuador: people tested\nEl Salvador: tests performed\nEquatorial Guinea: tests performed\nEstonia: tests performed\nEthiopia: tests performed\nFaeroe Islands: people tested\nFiji: tests performed\nFinland: tests performed\nFrance: people tested\nGabon: tests performed\nGambia: tests performed\nGeorgia: tests performed\nGermany: tests performed\nGhana: tests performed\nGreece: samples tested\nGuatemala: people tested\nGuyana: tests performed\nHaiti: tests performed\nHong Kong: tests performed\nHungary: tests performed\nIceland: tests performed\nIndia: samples tested\nIndonesia: people tested\nIran: tests performed\nIraq: samples tested\nIreland: tests performed\nIsrael: tests performed\nItaly: tests performed\nJamaica: samples tested\nJapan: people tested\nJordan: tests performed\nKazakhstan: tests performed\nKenya: tests performed\nKosovo: tests performed\nKuwait: tests performed\nLaos: tests performed\nLatvia: tests performed\nLebanon: tests performed\nLibya: samples tested\nLiechtenstein: tests performed\nLithuania: tests performed\nLuxembourg: tests performed\nMadagascar: tests performed\nMalawi: tests performed\nMalaysia: people tested\nMaldives: samples tested\nMalta: tests performed\nMauritania: tests performed\nMexico: people tested\nMoldova: tests performed\nMongolia: samples tested\nMorocco: people tested\nMozambique: tests performed\nMyanmar: samples tested\nNamibia: tests performed\nNepal: tests performed\nNetherlands: tests performed\nNew Zealand: tests performed\nNigeria: samples tested\nNorth Macedonia: tests performed\nNorway: people tested\nOman: units unclear\nPakistan: tests performed\nPalestine: tests performed\nPanama: tests performed\nPapua New Guinea: tests performed\nParaguay: tests performed\nPeru: tests performed\nPhilippines: people tested\nPoland: people tested\nPortugal: tests performed\nQatar: people tested\nRomania: tests performed\nRussia: tests performed\nRwanda: samples tested\nSaint Kitts and Nevis: people tested\nSaint Vincent and the Grenadines: tests performed\nSaudi Arabia: tests performed\nSenegal: tests performed\nSerbia: people tested\nSingapore: samples tested\nSlovakia: tests performed\nSlovenia: tests performed\nSouth Africa: people tested\nSouth Korea: people tested\nSouth Sudan: tests performed\nSpain: tests performed\nSri Lanka: tests performed\nSuriname: tests performed\nSweden: tests performed\nSwitzerland: tests performed\nTaiwan: people tested\nThailand: tests performed\nTimor: tests performed\nTogo: tests performed\nTrinidad and Tobago: people tested\nTunisia: people tested\nTurkey: tests performed\nUganda: tests performed\nUkraine: tests performed\nUnited Arab Emirates: tests performed\nUnited Kingdom: tests performed\nUnited States: tests performed\nUruguay: people tested\nVietnam: samples tested\nZambia: tests performed\nZimbabwe: tests performed"
}
 0     new_tests_7day_smoothed grapher/covid/latest/testing_time_series/testing_time_series#new_tests_7day_smoothed   1                 
[]
         int 
[]
 2baaf39e476a782ef297a783ad97cd95 2e5e69ed97c7cf7a943f56a0ce236fcc
738512 new_tests_per_thousand     2023-07-24 09:57:09 2024-07-31 15:42:01       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{
    "name": "New tests per thousand",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Albania: tests performed\nAndorra: people tested\nAngola: tests performed\nAntigua and Barbuda: tests performed\nArgentina: tests performed\nArmenia: tests performed\nAustralia: tests performed\nAustria: tests performed\nAzerbaijan: tests performed\nBahamas: tests performed\nBahrain: units unclear\nBangladesh: tests performed\nBelarus: tests performed\nBelgium: tests performed\nBelize: tests performed\nBenin: tests performed\nBhutan: samples tested\nBolivia: tests performed\nBosnia and Herzegovina: tests performed\nBotswana: tests performed\nBrazil: tests performed\nBulgaria: tests performed\nBurkina Faso: tests performed\nBurundi: tests performed\nCambodia: tests performed\nCanada: tests performed\nCape Verde: tests performed\nCentral African Republic: tests performed\nChad: tests performed\nChile: tests performed\nChina: tests performed\nColombia: tests performed\nCosta Rica: people tested\nCote d'Ivoire: tests performed\nCroatia: people tested\nCuba: tests performed\nCyprus: tests performed\nCzechia: tests performed\nDemocratic Republic of Congo: samples tested\nDenmark: tests performed\nDominican Republic: samples tested\nEcuador: people tested\nEl Salvador: tests performed\nEquatorial Guinea: tests performed\nEstonia: tests performed\nEthiopia: tests performed\nFaeroe Islands: people tested\nFiji: tests performed\nFinland: tests performed\nFrance: people tested\nGabon: tests performed\nGambia: tests performed\nGeorgia: tests performed\nGermany: tests performed\nGhana: tests performed\nGreece: samples tested\nGuatemala: people tested\nGuyana: tests performed\nHaiti: tests performed\nHong Kong: tests performed\nHungary: tests performed\nIceland: tests performed\nIndia: samples tested\nIndonesia: people tested\nIran: tests performed\nIraq: samples tested\nIreland: tests performed\nIsrael: tests performed\nItaly: tests performed\nJamaica: samples tested\nJapan: people tested\nJordan: tests performed\nKazakhstan: tests performed\nKenya: tests performed\nKosovo: tests performed\nKuwait: tests performed\nLaos: tests performed\nLatvia: tests performed\nLebanon: tests performed\nLibya: samples tested\nLiechtenstein: tests performed\nLithuania: tests performed\nLuxembourg: tests performed\nMadagascar: tests performed\nMalawi: tests performed\nMalaysia: people tested\nMaldives: samples tested\nMalta: tests performed\nMauritania: tests performed\nMexico: people tested\nMoldova: tests performed\nMongolia: samples tested\nMorocco: people tested\nMozambique: tests performed\nMyanmar: samples tested\nNamibia: tests performed\nNepal: tests performed\nNetherlands: tests performed\nNew Zealand: tests performed\nNigeria: samples tested\nNorth Macedonia: tests performed\nNorway: people tested\nOman: units unclear\nPakistan: tests performed\nPalestine: tests performed\nPanama: tests performed\nPapua New Guinea: tests performed\nParaguay: tests performed\nPeru: tests performed\nPhilippines: people tested\nPoland: people tested\nPortugal: tests performed\nQatar: people tested\nRomania: tests performed\nRussia: tests performed\nRwanda: samples tested\nSaint Kitts and Nevis: people tested\nSaint Vincent and the Grenadines: tests performed\nSaudi Arabia: tests performed\nSenegal: tests performed\nSerbia: people tested\nSingapore: samples tested\nSlovakia: tests performed\nSlovenia: tests performed\nSouth Africa: people tested\nSouth Korea: people tested\nSouth Sudan: tests performed\nSpain: tests performed\nSri Lanka: tests performed\nSuriname: tests performed\nSweden: tests performed\nSwitzerland: tests performed\nTaiwan: people tested\nThailand: tests performed\nTimor: tests performed\nTogo: tests performed\nTrinidad and Tobago: people tested\nTunisia: people tested\nTurkey: tests performed\nUganda: tests performed\nUkraine: tests performed\nUnited Arab Emirates: tests performed\nUnited Kingdom: tests performed\nUnited States: tests performed\nUruguay: people tested\nVietnam: samples tested\nZambia: tests performed\nZimbabwe: tests performed"
}
 0     new_tests_per_thousand grapher/covid/latest/testing_time_series/testing_time_series#new_tests_per_thousand   1                 
[]
         float 
[]
 25af1675a251ffa19c15a8133cbb266e c36d4be7daa46dded89711ddb28f6d94
738511 new_tests     2023-07-24 09:57:09 2024-07-31 15:42:01       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{
    "name": "New tests",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Albania: tests performed\nAndorra: people tested\nAngola: tests performed\nAntigua and Barbuda: tests performed\nArgentina: tests performed\nArmenia: tests performed\nAustralia: tests performed\nAustria: tests performed\nAzerbaijan: tests performed\nBahamas: tests performed\nBahrain: units unclear\nBangladesh: tests performed\nBelarus: tests performed\nBelgium: tests performed\nBelize: tests performed\nBenin: tests performed\nBhutan: samples tested\nBolivia: tests performed\nBosnia and Herzegovina: tests performed\nBotswana: tests performed\nBrazil: tests performed\nBulgaria: tests performed\nBurkina Faso: tests performed\nBurundi: tests performed\nCambodia: tests performed\nCanada: tests performed\nCape Verde: tests performed\nCentral African Republic: tests performed\nChad: tests performed\nChile: tests performed\nChina: tests performed\nColombia: tests performed\nCosta Rica: people tested\nCote d'Ivoire: tests performed\nCroatia: people tested\nCuba: tests performed\nCyprus: tests performed\nCzechia: tests performed\nDemocratic Republic of Congo: samples tested\nDenmark: tests performed\nDominican Republic: samples tested\nEcuador: people tested\nEl Salvador: tests performed\nEquatorial Guinea: tests performed\nEstonia: tests performed\nEthiopia: tests performed\nFaeroe Islands: people tested\nFiji: tests performed\nFinland: tests performed\nFrance: people tested\nGabon: tests performed\nGambia: tests performed\nGeorgia: tests performed\nGermany: tests performed\nGhana: tests performed\nGreece: samples tested\nGuatemala: people tested\nGuyana: tests performed\nHaiti: tests performed\nHong Kong: tests performed\nHungary: tests performed\nIceland: tests performed\nIndia: samples tested\nIndonesia: people tested\nIran: tests performed\nIraq: samples tested\nIreland: tests performed\nIsrael: tests performed\nItaly: tests performed\nJamaica: samples tested\nJapan: people tested\nJordan: tests performed\nKazakhstan: tests performed\nKenya: tests performed\nKosovo: tests performed\nKuwait: tests performed\nLaos: tests performed\nLatvia: tests performed\nLebanon: tests performed\nLibya: samples tested\nLiechtenstein: tests performed\nLithuania: tests performed\nLuxembourg: tests performed\nMadagascar: tests performed\nMalawi: tests performed\nMalaysia: people tested\nMaldives: samples tested\nMalta: tests performed\nMauritania: tests performed\nMexico: people tested\nMoldova: tests performed\nMongolia: samples tested\nMorocco: people tested\nMozambique: tests performed\nMyanmar: samples tested\nNamibia: tests performed\nNepal: tests performed\nNetherlands: tests performed\nNew Zealand: tests performed\nNigeria: samples tested\nNorth Macedonia: tests performed\nNorway: people tested\nOman: units unclear\nPakistan: tests performed\nPalestine: tests performed\nPanama: tests performed\nPapua New Guinea: tests performed\nParaguay: tests performed\nPeru: tests performed\nPhilippines: people tested\nPoland: people tested\nPortugal: tests performed\nQatar: people tested\nRomania: tests performed\nRussia: tests performed\nRwanda: samples tested\nSaint Kitts and Nevis: people tested\nSaint Vincent and the Grenadines: tests performed\nSaudi Arabia: tests performed\nSenegal: tests performed\nSerbia: people tested\nSingapore: samples tested\nSlovakia: tests performed\nSlovenia: tests performed\nSouth Africa: people tested\nSouth Korea: people tested\nSouth Sudan: tests performed\nSpain: tests performed\nSri Lanka: tests performed\nSuriname: tests performed\nSweden: tests performed\nSwitzerland: tests performed\nTaiwan: people tested\nThailand: tests performed\nTimor: tests performed\nTogo: tests performed\nTrinidad and Tobago: people tested\nTunisia: people tested\nTurkey: tests performed\nUganda: tests performed\nUkraine: tests performed\nUnited Arab Emirates: tests performed\nUnited Kingdom: tests performed\nUnited States: tests performed\nUruguay: people tested\nVietnam: samples tested\nZambia: tests performed\nZimbabwe: tests performed"
}
 0     new_tests grapher/covid/latest/testing_time_series/testing_time_series#new_tests   1                 
[]
         int 
[]
 24521e34a4034acf6db0d4341affd882 91fcc6b4ee4e41423f9cd591738cd910
738510 total_tests_per_thousand     2023-07-24 09:57:09 2024-07-31 15:42:00       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{
    "name": "Total tests per thousand",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Albania: tests performed\nAndorra: people tested\nAngola: tests performed\nAntigua and Barbuda: tests performed\nArgentina: tests performed\nArmenia: tests performed\nAustralia: tests performed\nAustria: tests performed\nAzerbaijan: tests performed\nBahamas: tests performed\nBahrain: units unclear\nBangladesh: tests performed\nBelarus: tests performed\nBelgium: tests performed\nBelize: tests performed\nBenin: tests performed\nBhutan: samples tested\nBolivia: tests performed\nBosnia and Herzegovina: tests performed\nBotswana: tests performed\nBrazil: tests performed\nBulgaria: tests performed\nBurkina Faso: tests performed\nBurundi: tests performed\nCambodia: tests performed\nCanada: tests performed\nCape Verde: tests performed\nCentral African Republic: tests performed\nChad: tests performed\nChile: tests performed\nChina: tests performed\nColombia: tests performed\nCosta Rica: people tested\nCote d'Ivoire: tests performed\nCroatia: people tested\nCuba: tests performed\nCyprus: tests performed\nCzechia: tests performed\nDemocratic Republic of Congo: samples tested\nDenmark: tests performed\nDominican Republic: samples tested\nEcuador: people tested\nEl Salvador: tests performed\nEquatorial Guinea: tests performed\nEstonia: tests performed\nEthiopia: tests performed\nFaeroe Islands: people tested\nFiji: tests performed\nFinland: tests performed\nFrance: people tested\nGabon: tests performed\nGambia: tests performed\nGeorgia: tests performed\nGermany: tests performed\nGhana: tests performed\nGreece: samples tested\nGuatemala: people tested\nGuyana: tests performed\nHaiti: tests performed\nHong Kong: tests performed\nHungary: tests performed\nIceland: tests performed\nIndia: samples tested\nIndonesia: people tested\nIran: tests performed\nIraq: samples tested\nIreland: tests performed\nIsrael: tests performed\nItaly: tests performed\nJamaica: samples tested\nJapan: people tested\nJordan: tests performed\nKazakhstan: tests performed\nKenya: tests performed\nKosovo: tests performed\nKuwait: tests performed\nLaos: tests performed\nLatvia: tests performed\nLebanon: tests performed\nLibya: samples tested\nLiechtenstein: tests performed\nLithuania: tests performed\nLuxembourg: tests performed\nMadagascar: tests performed\nMalawi: tests performed\nMalaysia: people tested\nMaldives: samples tested\nMalta: tests performed\nMauritania: tests performed\nMexico: people tested\nMoldova: tests performed\nMongolia: samples tested\nMorocco: people tested\nMozambique: tests performed\nMyanmar: samples tested\nNamibia: tests performed\nNepal: tests performed\nNetherlands: tests performed\nNew Zealand: tests performed\nNigeria: samples tested\nNorth Macedonia: tests performed\nNorway: people tested\nOman: units unclear\nPakistan: tests performed\nPalestine: tests performed\nPanama: tests performed\nPapua New Guinea: tests performed\nParaguay: tests performed\nPeru: tests performed\nPhilippines: people tested\nPoland: people tested\nPortugal: tests performed\nQatar: people tested\nRomania: tests performed\nRussia: tests performed\nRwanda: samples tested\nSaint Kitts and Nevis: people tested\nSaint Vincent and the Grenadines: tests performed\nSaudi Arabia: tests performed\nSenegal: tests performed\nSerbia: people tested\nSingapore: samples tested\nSlovakia: tests performed\nSlovenia: tests performed\nSouth Africa: people tested\nSouth Korea: people tested\nSouth Sudan: tests performed\nSpain: tests performed\nSri Lanka: tests performed\nSuriname: tests performed\nSweden: tests performed\nSwitzerland: tests performed\nTaiwan: people tested\nThailand: tests performed\nTimor: tests performed\nTogo: tests performed\nTrinidad and Tobago: people tested\nTunisia: people tested\nTurkey: tests performed\nUganda: tests performed\nUkraine: tests performed\nUnited Arab Emirates: tests performed\nUnited Kingdom: tests performed\nUnited States: tests performed\nUruguay: people tested\nVietnam: samples tested\nZambia: tests performed\nZimbabwe: tests performed"
}
 0     total_tests_per_thousand grapher/covid/latest/testing_time_series/testing_time_series#total_tests_per_thousand   1                 
[]
         float 
[]
 d42d2012ca884544b9bafea22b3efe4f 2d3ffa3be7f92b5798ee48f22e9295cd
738509 total_tests     2023-07-24 09:57:09 2024-07-31 15:42:00       COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{
    "name": "Total tests",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Albania: tests performed\nAndorra: people tested\nAngola: tests performed\nAntigua and Barbuda: tests performed\nArgentina: tests performed\nArmenia: tests performed\nAustralia: tests performed\nAustria: tests performed\nAzerbaijan: tests performed\nBahamas: tests performed\nBahrain: units unclear\nBangladesh: tests performed\nBelarus: tests performed\nBelgium: tests performed\nBelize: tests performed\nBenin: tests performed\nBhutan: samples tested\nBolivia: tests performed\nBosnia and Herzegovina: tests performed\nBotswana: tests performed\nBrazil: tests performed\nBulgaria: tests performed\nBurkina Faso: tests performed\nBurundi: tests performed\nCambodia: tests performed\nCanada: tests performed\nCape Verde: tests performed\nCentral African Republic: tests performed\nChad: tests performed\nChile: tests performed\nChina: tests performed\nColombia: tests performed\nCosta Rica: people tested\nCote d'Ivoire: tests performed\nCroatia: people tested\nCuba: tests performed\nCyprus: tests performed\nCzechia: tests performed\nDemocratic Republic of Congo: samples tested\nDenmark: tests performed\nDominican Republic: samples tested\nEcuador: people tested\nEl Salvador: tests performed\nEquatorial Guinea: tests performed\nEstonia: tests performed\nEthiopia: tests performed\nFaeroe Islands: people tested\nFiji: tests performed\nFinland: tests performed\nFrance: people tested\nGabon: tests performed\nGambia: tests performed\nGeorgia: tests performed\nGermany: tests performed\nGhana: tests performed\nGreece: samples tested\nGuatemala: people tested\nGuyana: tests performed\nHaiti: tests performed\nHong Kong: tests performed\nHungary: tests performed\nIceland: tests performed\nIndia: samples tested\nIndonesia: people tested\nIran: tests performed\nIraq: samples tested\nIreland: tests performed\nIsrael: tests performed\nItaly: tests performed\nJamaica: samples tested\nJapan: people tested\nJordan: tests performed\nKazakhstan: tests performed\nKenya: tests performed\nKosovo: tests performed\nKuwait: tests performed\nLaos: tests performed\nLatvia: tests performed\nLebanon: tests performed\nLibya: samples tested\nLiechtenstein: tests performed\nLithuania: tests performed\nLuxembourg: tests performed\nMadagascar: tests performed\nMalawi: tests performed\nMalaysia: people tested\nMaldives: samples tested\nMalta: tests performed\nMauritania: tests performed\nMexico: people tested\nMoldova: tests performed\nMongolia: samples tested\nMorocco: people tested\nMozambique: tests performed\nMyanmar: samples tested\nNamibia: tests performed\nNepal: tests performed\nNetherlands: tests performed\nNew Zealand: tests performed\nNigeria: samples tested\nNorth Macedonia: tests performed\nNorway: people tested\nOman: units unclear\nPakistan: tests performed\nPalestine: tests performed\nPanama: tests performed\nPapua New Guinea: tests performed\nParaguay: tests performed\nPeru: tests performed\nPhilippines: people tested\nPoland: people tested\nPortugal: tests performed\nQatar: people tested\nRomania: tests performed\nRussia: tests performed\nRwanda: samples tested\nSaint Kitts and Nevis: people tested\nSaint Vincent and the Grenadines: tests performed\nSaudi Arabia: tests performed\nSenegal: tests performed\nSerbia: people tested\nSingapore: samples tested\nSlovakia: tests performed\nSlovenia: tests performed\nSouth Africa: people tested\nSouth Korea: people tested\nSouth Sudan: tests performed\nSpain: tests performed\nSri Lanka: tests performed\nSuriname: tests performed\nSweden: tests performed\nSwitzerland: tests performed\nTaiwan: people tested\nThailand: tests performed\nTimor: tests performed\nTogo: tests performed\nTrinidad and Tobago: people tested\nTunisia: people tested\nTurkey: tests performed\nUganda: tests performed\nUkraine: tests performed\nUnited Arab Emirates: tests performed\nUnited Kingdom: tests performed\nUnited States: tests performed\nUruguay: people tested\nVietnam: samples tested\nZambia: tests performed\nZimbabwe: tests performed"
}
 0     total_tests grapher/covid/latest/testing_time_series/testing_time_series#total_tests   1                 
[]
         int 
[]
 d589362f61d90e24f88300256c74d583 4ad3e74a0b627880753ff9fde9860264
738508 annotation     2023-07-24 09:57:09 2024-07-31 15:42:00     -20-884 COVID testing time series data 6150 Official data collated by Our World in Data – Last updated 30 July 2024 30951   
{}
 0     annotation grapher/covid/latest/testing_time_series/testing_time_series#annotation   1                 
[]
         string 
[]
 0cd00a2d09e0a1141a718d0fa0b685d4 8e459e7c09f56c06d024319f6f1fbe2b

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "variables" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(750) NULL  ,
	"unit" VARCHAR(255) NOT NULL  ,
	"description" TEXT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"code" VARCHAR(255) NULL  ,
	"coverage" VARCHAR(255) NOT NULL  ,
	"timespan" VARCHAR(255) NOT NULL  ,
	"datasetId" INTEGER NOT NULL  ,
	"sourceId" INTEGER NULL  ,
	"shortUnit" VARCHAR(255) NULL  ,
	"display" TEXT NOT NULL  ,
	"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
	"originalMetadata" TEXT NULL  ,
	"grapherConfigAdmin" TEXT NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"catalogPath" VARCHAR(767) NULL  ,
	"dimensions" TEXT NULL  ,
	"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
	"processingLevel" VARCHAR(30) NULL  ,
	"processingLog" TEXT NULL  ,
	"titlePublic" VARCHAR(512) NULL  ,
	"titleVariant" VARCHAR(255) NULL  ,
	"attributionShort" VARCHAR(512) NULL  ,
	"attribution" TEXT NULL  ,
	"descriptionShort" TEXT NULL  ,
	"descriptionFromProducer" TEXT NULL  ,
	"descriptionKey" TEXT NULL  ,
	"descriptionProcessing" TEXT NULL  ,
	"licenses" TEXT NULL  ,
	"license" TEXT NULL  ,
	"grapherConfigETL" TEXT NULL  ,
	"type" TEXT NULL  ,
	"sort" TEXT NULL  ,
	"dataChecksum" VARCHAR(64) NULL  ,
	"metadataChecksum" VARCHAR(64) NULL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");