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 = 5075 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
142755 short_term_positivity_rate     2020-05-18 18:43:40 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "name": "Short-term positivity rate",
    "unit": "%",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "conversionFactor": 100
}
 0           1                                  
142754 short_term_tests_per_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. 2020-05-18 18:43:40 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "name": "Tests per confirmed case \u2013 daily",
    "unit": "tests per confirmed case",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142753 new_tests_per_thousand_7day_smoothed   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. 2020-05-04 19:26:27 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "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\n"
}
 0           1                                  
142752 new_tests_7day_smoothed   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. 2020-05-04 19:26:27 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "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\n"
}
 0           1                                  
142723 testing_observations   Countries for which we attempted to find data are not included. 2020-04-26 11:11:51 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "name": "Number of testing observations",
    "yearIsDay": true
}
 0           1                                  
142721 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. 2020-04-22 20:45:24 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "name": "Cumulative positivity rate",
    "unit": "%",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "conversionFactor": 100
}
 0           1                                  
142711 cumulative_tests_per_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. 2020-04-08 22:05:32 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "name": "Tests per confirmed case \u2013 total",
    "unit": "tests per confirmed case",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142702 annotation     2020-04-06 20:58:37 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{}
 0           1                                  
142606 new_tests_per_thousand     2020-03-27 11:53:33 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "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\n"
}
 0           1                                  
142605 total_tests_per_thousand     2020-03-27 11:53:33 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "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\n"
}
 0           1                                  
142602 new_tests     2020-03-25 19:28:02 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "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\n"
}
 0           1                                  
142601 total_tests     2020-03-25 19:28:02 2023-06-15 05:05:42       COVID testing time series data 5075 Official data collated by Our World in Data – Last updated 14 June 2023 17805   
{
    "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\n"
}
 0           1                                  

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");