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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, display, 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
738593 Biweekly deaths per million people     2023-07-24 09:57:48 2024-07-31 15:42:12       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     biweekly_deaths_per_million_people grapher/covid/latest/ecdc/ecdc#biweekly_deaths_per_million_people   1                 
[]
         float 
[]
 291c8dd26070362ed1fc8e8de92a6e53 c6616e44f5fba2e45b55f3209a544a92
738592 Biweekly cases per million people     2023-07-24 09:57:48 2024-07-31 15:42:12       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     biweekly_cases_per_million_people grapher/covid/latest/ecdc/ecdc#biweekly_cases_per_million_people   1                 
[]
         float 
[]
 aaa0338eb9fd160d476c0a547ca6ee75 9cb13eda078f8235e68ad0596cb3b5af
738591 Weekly deaths per million people     2023-07-24 09:57:48 2024-07-31 15:42:11       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     weekly_deaths_per_million_people grapher/covid/latest/ecdc/ecdc#weekly_deaths_per_million_people   1                 
[]
         float 
[]
 81235b93c5d16819980dfc302483c355 abee39bb2fe109912761baa924fd3f43
738590 Weekly cases per million people     2023-07-24 09:57:48 2024-07-31 15:42:11       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     weekly_cases_per_million_people grapher/covid/latest/ecdc/ecdc#weekly_cases_per_million_people   1                 
[]
         float 
[]
 9ab1f6c422947860247b8553ef73c9fc 9b627a229992e60a3d07170275147f57
738589 Biweekly death growth (%) %   2023-07-24 09:57:47 2024-07-31 15:42:11       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947 % 
{
    "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     biweekly_death_growth__pct grapher/covid/latest/ecdc/ecdc#biweekly_death_growth__pct   1                 
[]
         float 
[]
 dece425f7aab685aa414d9675697c78c 6d8b18b3b779800eb70bc26209691791
738588 Biweekly case growth (%) %   2023-07-24 09:57:47 2024-07-31 15:42:11       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947 % 
{
    "name": "Biweekly growth in cases",
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     biweekly_case_growth__pct grapher/covid/latest/ecdc/ecdc#biweekly_case_growth__pct   1                 
[]
         float 
[]
 f4b59bf960313aa103a6b455c56596c2 8e01638591335a899d19f4b62dad4180
738587 Biweekly deaths deaths   2023-07-24 09:57:46 2024-07-31 15:42:11       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "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     biweekly_deaths grapher/covid/latest/ecdc/ecdc#biweekly_deaths   1                 
[]
         int 
[]
 4549c4436230cb9d084c77ba6fe13d0e 2d9f2ca760251cbc9334a87de8c2083d
738586 Biweekly cases cases   2023-07-24 09:57:46 2024-07-31 15:42:10       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "name": "Biweekly cases",
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     biweekly_cases grapher/covid/latest/ecdc/ecdc#biweekly_cases   1                 
[]
         int 
[]
 34541f0eb46208fbbcdcaf813e355c26 719baafae755fc9b1f301d7b85877d0a
738585 Weekly death growth (%) %   2023-07-24 09:57:46 2024-07-31 15:42:10       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947 % 
{
    "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     weekly_death_growth__pct grapher/covid/latest/ecdc/ecdc#weekly_death_growth__pct   1                 
[]
         float 
[]
 206a1498caac5b1c26c9b372e9a3930b 74d2ded95bb2385805d021d210a3e581
738584 Weekly case growth (%) %   2023-07-24 09:57:46 2024-07-31 15:42:10       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947 % 
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 1,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     weekly_case_growth__pct grapher/covid/latest/ecdc/ecdc#weekly_case_growth__pct   1                 
[]
         float 
[]
 39dc7bcf23d6b6e83c4e389cee49a5aa f458db8b3c74c8af6d13da06600e30c4
738583 Weekly deaths     2023-07-24 09:57:46 2024-07-31 15:42:10       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     weekly_deaths grapher/covid/latest/ecdc/ecdc#weekly_deaths   1                 
[]
         int 
[]
 448423b887788919dd8ae8ee51c61991 9158d1300be4a13483fcfe794e77d642
738582 Weekly cases     2023-07-24 09:57:46 2024-07-31 15:42:09       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     weekly_cases grapher/covid/latest/ecdc/ecdc#weekly_cases   1                 
[]
         int 
[]
 04f1d0e026f37c393c9d6efd738fe58a 68a365e2da0d19cf69b7b494a5429298
738581 Doubling days of total confirmed deaths (7 day period)     2023-07-24 09:57:45 2024-07-31 15:42:09       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     doubling_days_of_total_confirmed_deaths__7_day_period grapher/covid/latest/ecdc/ecdc#doubling_days_of_total_confirmed_deaths__7_day_period   1                 
[]
         float 
[]
 a8cabb672e09e65c43ad9f622324080d ad45480fb44b0f16764a035305aa9efa
738580 Doubling days of total confirmed deaths (3 day period)     2023-07-24 09:57:44 2024-07-31 15:42:09       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     doubling_days_of_total_confirmed_deaths__3_day_period grapher/covid/latest/ecdc/ecdc#doubling_days_of_total_confirmed_deaths__3_day_period   1                 
[]
         float 
[]
 354e491fc0f531eb2e85c58b375454ea f6e039c07fb97df41598a22ee0a055ca
738579 Doubling days of total confirmed cases (7 day period)     2023-07-24 09:57:44 2024-07-31 15:42:09       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     doubling_days_of_total_confirmed_cases__7_day_period grapher/covid/latest/ecdc/ecdc#doubling_days_of_total_confirmed_cases__7_day_period   1                 
[]
         float 
[]
 478d42ad4601480fcbf22407fd55fec8 1c8ea62d76e2d84b3ce3c644b4742445
738578 Doubling days of total confirmed cases (3 day period)     2023-07-24 09:57:44 2024-07-31 15:42:09       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     doubling_days_of_total_confirmed_cases__3_day_period grapher/covid/latest/ecdc/ecdc#doubling_days_of_total_confirmed_cases__3_day_period   1                 
[]
         float 
[]
 e032d821889defb2f3db1a34cfb7c8ab 2c6ad43db765825466e66023927ae434
738577 Has population ≥ 5M AND had ≥100 cases ≥21 days ago AND has testing data     2023-07-24 09:57:44 2024-07-31 15:42:08       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true
}
 0     has_population__gte__5m_and_had__gte_100_cases__gte_21_days_ago_and_has_testing_data grapher/covid/latest/ecdc/ecdc#has_population__gte__5m_and_had__gte_100_cases__gte_21_days_ago_and_has_testing_data   1                 
[]
         int 
[]
 38fa0597da55353e2f0f1865ac2f3e7d 94f18472bac9bf88a24b2cc7805ea02f
738576 Days since the total confirmed cases of COVID-19 reached 100 (with population ≥ 5M)     2023-07-24 09:57:44 2024-07-31 15:42:08       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_the_total_confirmed_cases_of_covid_19_reached_100__with_population__gte__5m grapher/covid/latest/ecdc/ecdc#days_since_the_total_confirmed_cases_of_covid_19_reached_100__with_population__gte__5m   1                 
[]
         int 
[]
 6924ba41d6413233d002a6fdfb8d516b 0b01ed08720d3b4851864c580ef08018
738575 Case fatality rate of COVID-19 (%) (Short-term)     2023-07-24 09:57:44 2024-07-31 15:42:08       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     case_fatality_rate_of_covid_19__pct__short_term grapher/covid/latest/ecdc/ecdc#case_fatality_rate_of_covid_19__pct__short_term   1                 
[]
         float 
[]
 e094770a9fcafbf79d124fc2f4432af1 b0fc521c97357b8f2b9f23fdf66008f2
738574 Case fatality rate of COVID-19 (%) (Only observations with ≥100 cases) %   2023-07-24 09:57:43 2024-07-31 15:42:08       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947 % 
{
    "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     case_fatality_rate_of_covid_19__pct__only_observations_with__gte_100_cases grapher/covid/latest/ecdc/ecdc#case_fatality_rate_of_covid_19__pct__only_observations_with__gte_100_cases   1                 
[]
         float 
[]
 980b1ea9d9763643dc5d25813e232fd5 784784f96e836524997351c607cd825b
738573 Case fatality rate of COVID-19 (%) %   2023-07-24 09:57:43 2024-07-31 15:42:08       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "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     case_fatality_rate_of_covid_19__pct grapher/covid/latest/ecdc/ecdc#case_fatality_rate_of_covid_19__pct   1                 
[]
         float 
[]
 4dd236a070a32f1c63457d59f7f9fe3b d72ce683b636df8bf0942dcc04e2a5ef
738572 Daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned)     2023-07-24 09:57:43 2024-07-31 15:42:07       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_7_day_average__right_aligned grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_7_day_average__right_aligned   1                 
[]
         float 
[]
 4f8efe6f6b1e24a529699209c21df40e 6fac0814b137448bb59e9b34febfbd93
738571 Daily new confirmed cases of COVID-19 per million people (rolling 7-day average, right-aligned)     2023-07-24 09:57:42 2024-07-31 15:42:07       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     daily_new_confirmed_cases_of_covid_19_per_million_people__rolling_7_day_average__right_aligned grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_cases_of_covid_19_per_million_people__rolling_7_day_average__right_aligned   1                 
[]
         float 
[]
 d2f6adc4cfbd0116b8a0fb4f1d81d2c6 1166b18538bdc59c54ce9d667a00bb89
738570 Daily new confirmed deaths due to COVID-19 per million people (rolling 3-day average, right-aligned)     2023-07-24 09:57:42 2024-07-31 15:42:07       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_3_day_average__right_aligned grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_3_day_average__right_aligned   1                 
[]
         float 
[]
 00a225ad5838b70803120c9efbdb33f3 086b07d00f914bb7fb105737f8d432ab
738569 Daily new confirmed cases of COVID-19 per million people (rolling 3-day average, right-aligned)     2023-07-24 09:57:42 2024-07-31 15:42:07       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     daily_new_confirmed_cases_of_covid_19_per_million_people__rolling_3_day_average__right_aligned grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_cases_of_covid_19_per_million_people__rolling_3_day_average__right_aligned   1                 
[]
         float 
[]
 7bb97425930cada3e8aecc5ea83eeec1 c8f75eccea99eba5bbb164626fd3cfe0
738568 Daily new confirmed deaths due to COVID-19 (rolling 7-day average, right-aligned)     2023-07-24 09:57:42 2024-07-31 15:42:07       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     daily_new_confirmed_deaths_due_to_covid_19__rolling_7_day_average__right_aligned grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_deaths_due_to_covid_19__rolling_7_day_average__right_aligned   1                 
[]
         float 
[]
 0e29b325d2751b8ffbdc412d6de4d773 153a7a636804fe54039ba9713d22a95d
738567 Daily new confirmed deaths due to COVID-19 (rolling 3-day average, right-aligned)     2023-07-24 09:57:41 2024-07-31 15:42:07       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     daily_new_confirmed_deaths_due_to_covid_19__rolling_3_day_average__right_aligned grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_deaths_due_to_covid_19__rolling_3_day_average__right_aligned   1                 
[]
         float 
[]
 7adfb81a96d398c102b708123f2c7f91 a6847fc1303a549a13e57d60d108a421
738566 Daily new confirmed cases due to COVID-19 (rolling 7-day average, right-aligned)     2023-07-24 09:57:41 2024-07-31 15:42:06       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     daily_new_confirmed_cases_due_to_covid_19__rolling_7_day_average__right_aligned grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_cases_due_to_covid_19__rolling_7_day_average__right_aligned   1                 
[]
         float 
[]
 05a17d3c8b295b52f400c42b87eea0f2 6ae1e57f82daae9c9f9e2e83bab3e09a
738565 Daily new confirmed cases of COVID-19 (rolling 3-day average, right-aligned)     2023-07-24 09:57:41 2024-07-31 15:42:06       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     daily_new_confirmed_cases_of_covid_19__rolling_3_day_average__right_aligned grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_cases_of_covid_19__rolling_3_day_average__right_aligned   1                 
[]
         float 
[]
 3fb98f9722f7453c664eefa062e9c125 77eb385d0207d766171cf3995d50bf06
738564 Days since daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned) reached 0.01     2023-07-24 09:57:40 2024-07-31 15:42:06       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_7_day_average__right_aligned__reached_0_01 grapher/covid/latest/ecdc/ecdc#days_since_daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_7_day_average__right_aligned__reached_0_01   1                 
[]
         int 
[]
 d42a1e388c2402c2f7b036c728fb985f 9a7733b49d901720466a32d52d5c6646
738563 Days since daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned) reached 0.1     2023-07-24 09:57:40 2024-07-31 15:42:06       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_7_day_average__right_aligned__reached_0_1 grapher/covid/latest/ecdc/ecdc#days_since_daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_7_day_average__right_aligned__reached_0_1   1                 
[]
         int 
[]
 51e0a6d279bf02277d31381c1a63e544 8a9c5474025bc340dcbac0ae56e86040
738562 Days since daily new confirmed cases of COVID-19 per million people (rolling 7-day average, right-aligned) reached 1     2023-07-24 09:57:40 2024-07-31 15:42:05       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_daily_new_confirmed_cases_of_covid_19_per_million_people__rolling_7_day_average__right_aligned__reached_1 grapher/covid/latest/ecdc/ecdc#days_since_daily_new_confirmed_cases_of_covid_19_per_million_people__rolling_7_day_average__right_aligned__reached_1   1                 
[]
         int 
[]
 8ca063c083f75443c1c86341a19bd2b9 b7d62c1bfdd920473566c41f29f8b29d
738561 Days since daily new confirmed deaths due to COVID-19 (rolling 7-day average, right-aligned) reached 5     2023-07-24 09:57:40 2024-07-31 15:42:05       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_daily_new_confirmed_deaths_due_to_covid_19__rolling_7_day_average__right_aligned__reached_5 grapher/covid/latest/ecdc/ecdc#days_since_daily_new_confirmed_deaths_due_to_covid_19__rolling_7_day_average__right_aligned__reached_5   1                 
[]
         int 
[]
 11eb596f90f1d2c04865a406175f7a67 55e75789a344f3b3bddcf7f3c4131056
738560 Days since daily new confirmed cases of COVID-19 (rolling 7-day average, right-aligned) reached 30     2023-07-24 09:57:39 2024-07-31 15:42:05       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_daily_new_confirmed_cases_of_covid_19__rolling_7_day_average__right_aligned__reached_30 grapher/covid/latest/ecdc/ecdc#days_since_daily_new_confirmed_cases_of_covid_19__rolling_7_day_average__right_aligned__reached_30   1                 
[]
         int 
[]
 1e994ec6752717ad6ea4280761fdd299 6a58b2c612060dac996bf1ee04f767fa
738559 Days since 3 daily new confirmed deaths recorded     2023-07-24 09:57:39 2024-07-31 15:42:05       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_3_daily_new_confirmed_deaths_recorded grapher/covid/latest/ecdc/ecdc#days_since_3_daily_new_confirmed_deaths_recorded   1                 
[]
         int 
[]
 63fad451422c3f0fc34c4582df168db3 709aa5fd171fb20469d8cf2f3627c5a0
738558 Days since 5 daily new confirmed deaths recorded     2023-07-24 09:57:38 2024-07-31 15:42:05       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_5_daily_new_confirmed_deaths_recorded grapher/covid/latest/ecdc/ecdc#days_since_5_daily_new_confirmed_deaths_recorded   1                 
[]
         int 
[]
 6ce047c1e890e6c85811caaf3bac4877 c40ca4c6bab51f1c57577dcee399a825
738557 Days since 10 daily new confirmed deaths recorded     2023-07-24 09:57:38 2024-07-31 15:42:04       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_10_daily_new_confirmed_deaths_recorded grapher/covid/latest/ecdc/ecdc#days_since_10_daily_new_confirmed_deaths_recorded   1                 
[]
         int 
[]
 5a9029f8332adf04aa0a0a0c4924bb06 b642630b7685532e80ff342b44b9409c
738556 Days since 50 daily new confirmed cases recorded     2023-07-24 09:57:38 2024-07-31 15:42:04       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_50_daily_new_confirmed_cases_recorded grapher/covid/latest/ecdc/ecdc#days_since_50_daily_new_confirmed_cases_recorded   1                 
[]
         int 
[]
 ada50a6d219be28e6c8a683115efe6d4 860ede073b55c91514479acb60bf2328
738555 Days since 30 daily new confirmed cases recorded     2023-07-24 09:57:38 2024-07-31 15:42:04       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_30_daily_new_confirmed_cases_recorded grapher/covid/latest/ecdc/ecdc#days_since_30_daily_new_confirmed_cases_recorded   1                 
[]
         int 
[]
 7033dd88041a4e52d80bde03b1df8a24 45550b0d470876bcb6ba9235d1931303
738554 Days since the total confirmed deaths of COVID-19 per million people reached 0.1     2023-07-24 09:57:37 2024-07-31 15:42:04       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_the_total_confirmed_deaths_of_covid_19_per_million_people_reached_0_1 grapher/covid/latest/ecdc/ecdc#days_since_the_total_confirmed_deaths_of_covid_19_per_million_people_reached_0_1   1                 
[]
         int 
[]
 06b4e1df41779928e0a7a908152f60a3 959a45db16f11410ff31575845a3b9af
738553 Days since the total confirmed cases of COVID-19 per million people reached 1 days   2023-07-24 09:57:37 2024-07-31 15:42:03       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "name": "Days since the total confirmed cases per million people reached 1",
    "unit": "days",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_the_total_confirmed_cases_of_covid_19_per_million_people_reached_1 grapher/covid/latest/ecdc/ecdc#days_since_the_total_confirmed_cases_of_covid_19_per_million_people_reached_1   1                 
[]
         int 
[]
 1e2d1dd9190337fb3c5a582dddedc1a3 7da1c25db9a29e4907840e79e17f5e8a
738552 Days since the total confirmed deaths of COVID-19 reached 5     2023-07-24 09:57:37 2024-07-31 15:42:03       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_the_total_confirmed_deaths_of_covid_19_reached_5 grapher/covid/latest/ecdc/ecdc#days_since_the_total_confirmed_deaths_of_covid_19_reached_5   1                 
[]
         int 
[]
 ccac93da2ce570cec8c9f2e66e9bb548 da713a9b6afd3b9cca491006ab99f1be
738551 Days since the total confirmed cases of COVID-19 reached 100     2023-07-24 09:57:36 2024-07-31 15:42:03       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0     days_since_the_total_confirmed_cases_of_covid_19_reached_100 grapher/covid/latest/ecdc/ecdc#days_since_the_total_confirmed_cases_of_covid_19_reached_100   1                 
[]
         int 
[]
 f15ba0b7775c6157bd1ad336e7a5db3e ea80249668828e50228b29fc9aa69383
738550 Total confirmed deaths due to COVID-19 per million people deaths per million   2023-07-24 09:57:36 2024-07-31 15:42:03       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "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     total_confirmed_deaths_due_to_covid_19_per_million_people grapher/covid/latest/ecdc/ecdc#total_confirmed_deaths_due_to_covid_19_per_million_people   1                 
[]
         float 
[]
 e8d6e955e8ddd4e236e8dc613dcbb0f9 7436249c82fb6ecc5ac56280b6342ca8
738549 Total confirmed cases of COVID-19 per million people cases per million   2023-07-24 09:57:36 2024-07-31 15:42:03       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "unit": "cases per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     total_confirmed_cases_of_covid_19_per_million_people grapher/covid/latest/ecdc/ecdc#total_confirmed_cases_of_covid_19_per_million_people   1                 
[]
         float 
[]
 197c66a8f24d38c738cf290ba4bd60b5 12926a3665e6fc4684f1d8b7c8fb0503
738548 Daily new confirmed deaths due to COVID-19 per million people deaths per million   2023-07-24 09:57:36 2024-07-31 15:42:02       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "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     daily_new_confirmed_deaths_due_to_covid_19_per_million_people grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_deaths_due_to_covid_19_per_million_people   1                 
[]
         float 
[]
 f2d9fb4805222e9de06b72797ddf3773 95e8526ec9deea0f813e5dd055fd1794
738547 Daily new confirmed cases of COVID-19 per million people cases   2023-07-24 09:57:36 2024-07-31 15:42:01       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     daily_new_confirmed_cases_of_covid_19_per_million_people grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_cases_of_covid_19_per_million_people   1                 
[]
         float 
[]
 28d356989d70594009960b6023f38042 cfc02c69d701f9da32f0507848bd2eb5
738546 Total confirmed deaths due to COVID-19 deaths   2023-07-24 09:57:36 2024-07-31 15:42:02       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Sweden: recent days may undercount deaths\nSpain: Nov 4: earlier deaths added"
}
 0     total_confirmed_deaths_due_to_covid_19 grapher/covid/latest/ecdc/ecdc#total_confirmed_deaths_due_to_covid_19   1                 
[]
         int 
[]
 db28f64d341f3dc7410bfc0fe1e16e0d d091843899e5af81ac095790f153c1c0
738545 Total confirmed cases of COVID-19 cases   2023-07-24 09:57:36 2024-07-31 15:42:01       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     total_confirmed_cases_of_covid_19 grapher/covid/latest/ecdc/ecdc#total_confirmed_cases_of_covid_19   1                 
[]
         int 
[]
 79266d73a54b7907d7427b93a4c31add 67615e0f1b27f33ca24deca9db59d241
738544 Daily new confirmed deaths due to COVID-19 deaths   2023-07-24 09:57:36 2024-07-31 15:42:01       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "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     daily_new_confirmed_deaths_due_to_covid_19 grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_deaths_due_to_covid_19   1                 
[]
         int 
[]
 559ab6986cba52cec446d449f04d04cd 7d6be74c4ca69aade0995288e7778589
738543 Daily new confirmed cases of COVID-19 cases   2023-07-24 09:57:36 2024-07-31 15:42:01       COVID-2019 - ECDC (2020) 6152 European CDC – Situation Update Worldwide – Last updated 30 July 2024 30947   
{
    "name": "Daily confirmed cases",
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Mexico: Oct 9: probable/earlier cases added"
}
 0     daily_new_confirmed_cases_of_covid_19 grapher/covid/latest/ecdc/ecdc#daily_new_confirmed_cases_of_covid_19   1                 
[]
         int 
[]
 0b89701701cff04aa40928509d4cfc99 42fde40760c0734d044ad56470629688

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