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

51 rows where datasetId = 5071 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, display, 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
143508 Case fatality rate of COVID-19 (%) (Short-term)     2020-08-18 14:15:39 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142986 Biweekly deaths per million people     2020-07-03 14:15:28 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142985 Biweekly cases per million people     2020-07-03 14:15:28 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142984 Weekly deaths per million people     2020-07-03 14:15:28 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142983 Weekly cases per million people     2020-07-03 14:15:28 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142795 Biweekly death growth (%)     2020-06-01 10:17:00 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "name": "Biweekly growth in deaths",
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142794 Biweekly case growth (%)     2020-06-01 10:17:00 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "name": "Biweekly growth in cases",
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142793 Biweekly deaths     2020-06-01 10:17:00 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "name": "Biweekly deaths",
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142792 Biweekly cases     2020-06-01 10:17:00 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "name": "Biweekly cases",
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142759 Weekly death growth (%)     2020-05-19 12:23:10 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 1,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142758 Weekly case growth (%)     2020-05-19 12:23:10 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 1,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142757 Weekly deaths     2020-05-19 12:23:10 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142756 Weekly cases     2020-05-19 12:23:10 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142745 Doubling days of total confirmed deaths (7 day period)     2020-04-30 21:44:57 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142744 Doubling days of total confirmed deaths (3 day period)     2020-04-30 21:44:57 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142743 Doubling days of total confirmed cases (7 day period)     2020-04-30 21:44:57 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142742 Doubling days of total confirmed cases (3 day period)     2020-04-30 21:44:57 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142735 Has population ≥ 5M AND had ≥100 cases ≥21 days ago AND has testing data     2020-04-28 17:38:45 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true
}
 0           1                                  
142734 Days since the total confirmed cases of COVID-19 reached 100 (with population ≥ 5M)     2020-04-28 17:38:45 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142716 Daily new confirmed deaths due to COVID-19 per million people (rolling 3-day average, right-aligned)     2020-04-13 23:17:19 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142715 Daily new confirmed cases of COVID-19 per million people (rolling 3-day average, right-aligned)     2020-04-13 23:17:19 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142714 Days since daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned) reached 0.01     2020-04-09 14:28:43 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142713 Days since daily new confirmed deaths due to COVID-19 (rolling 7-day average, right-aligned) reached 5     2020-04-09 14:28:43 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142712 Days since daily new confirmed cases of COVID-19 (rolling 7-day average, right-aligned) reached 30     2020-04-09 14:28:43 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142710 Daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned)     2020-04-08 13:56:20 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142709 Daily new confirmed cases of COVID-19 per million people (rolling 7-day average, right-aligned)     2020-04-08 13:56:20 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142708 Daily new confirmed deaths due to COVID-19 (rolling 3-day average, right-aligned)     2020-04-08 13:56:20 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142707 Daily new confirmed cases of COVID-19 (rolling 3-day average, right-aligned)     2020-04-08 13:56:20 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142706 Days since daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned) reached 0.1     2020-04-08 13:56:20 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142705 Days since daily new confirmed cases of COVID-19 per million people (rolling 7-day average, right-aligned) reached 1     2020-04-08 13:56:20 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142700 Daily new confirmed cases due to COVID-19 (rolling 7-day average, right-aligned)     2020-04-03 23:12:21 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142699 Daily new confirmed deaths due to COVID-19 (rolling 7-day average, right-aligned)     2020-04-03 14:32:00 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142681 Days since 3 daily new confirmed deaths recorded     2020-04-02 22:54:20 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142680 Days since 5 daily new confirmed deaths recorded     2020-04-02 22:48:55 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142659 Days since 10 daily new confirmed deaths recorded     2020-04-02 10:31:48 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142658 Days since 50 daily new confirmed cases recorded     2020-04-02 10:31:48 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142657 Days since 30 daily new confirmed cases recorded     2020-04-02 10:31:48 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142600 Case fatality rate of COVID-19 (%) (Only observations with ≥100 cases)     2020-03-24 10:51:57 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 1,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142599 Case fatality rate of COVID-19 (%)     2020-03-22 01:44:43 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "name": "Case fatality rate",
    "unit": "%",
    "zeroDay": "2020-01-21",
    "tolerance": 2,
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142592 Days since the total confirmed deaths of COVID-19 per million people reached 0.1     2020-03-20 12:54:46 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142591 Days since the total confirmed cases of COVID-19 per million people reached 1     2020-03-20 12:54:46 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "name": "Days since the total confirmed cases per million people reached 1",
    "unit": "days",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142590 Days since the total confirmed deaths of COVID-19 reached 5     2020-03-20 12:54:46 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142589 Days since the total confirmed cases of COVID-19 reached 100     2020-03-19 15:25:01 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
142587 Total confirmed deaths due to COVID-19 per million people     2020-03-19 15:25:01 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "unit": "deaths per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142586 Total confirmed cases of COVID-19 per million people     2020-03-19 15:25:01 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "unit": "cases per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142585 Daily new confirmed deaths due to COVID-19 per million people     2020-03-19 15:25:01 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "unit": "deaths per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142584 Daily new confirmed cases of COVID-19 per million people     2020-03-19 15:25:01 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142583 Total confirmed deaths due to COVID-19     2020-03-19 11:03:55 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142582 Total confirmed cases of COVID-19     2020-03-19 11:03:55 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\n"
}
 0           1                                  
142581 Daily new confirmed deaths due to COVID-19     2020-03-19 11:03:55 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "name": "Daily confirmed deaths",
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0           1                                  
142580 Daily new confirmed cases of COVID-19     2020-03-19 11:03:55 2023-06-15 05:05:42       COVID-2019 - ECDC (2020) 5071 European CDC – Situation Update Worldwide – Last updated 29 November, 10:06 (London time) 17801   
{
    "name": "Daily confirmed cases",
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added\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");