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

31 rows where datasetId = 6637 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
954558 Days since the total confirmed cases of COVID-19 reached 100 (with population ≥ 5M) days   2024-07-26 15:17:27 2024-07-31 15:43:09       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "days",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     days_since_100_total_cases_and_5m_pop grapher/covid/latest/cases_deaths/cases_deaths#days_since_100_total_cases_and_5m_pop   2                 
[]
         int 
[]
 9e245684a69c05059d36d070986cfd38 e0e1b7bd0cc6537f030fcfa061c52e1f
954557 Days since the total confirmed deaths of COVID-19 per million people reached 0.1 days   2024-07-26 15:17:26 2024-07-31 15:43:09       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "days",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     days_since_0_1_total_deaths_per_million grapher/covid/latest/cases_deaths/cases_deaths#days_since_0_1_total_deaths_per_million   2 major               
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     int 
[]
 d3da4ee77f55e61aaf39490da7ee032c 49cefc3ee4a786c7b1be1536a7a02790
954556 Days since the total confirmed cases of COVID-19 per million people reached 1 days   2024-07-26 15:17:25 2024-07-31 15:43:09       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "days",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     days_since_1_total_cases_per_million grapher/covid/latest/cases_deaths/cases_deaths#days_since_1_total_cases_per_million   2 major               
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     int 
[]
 c57d0b57bdbbb43f2138c50206835b07 1dc961e71b40a99422e9dc1c32e42cdf
954555 Days since the total confirmed deaths of COVID-19 reached 5 days   2024-07-26 15:17:25 2024-07-31 15:43:07       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "days",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     days_since_5_total_deaths grapher/covid/latest/cases_deaths/cases_deaths#days_since_5_total_deaths   2                 
[]
         int 
[]
 807f990341c51d1345754820fc029da1 ecd5929f84eed7451bb04b1c2fee52df
954554 Days since the total confirmed cases of COVID-19 reached 100 days   2024-07-26 15:17:23 2024-07-31 15:43:06       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "days",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     days_since_100_total_cases grapher/covid/latest/cases_deaths/cases_deaths#days_since_100_total_cases   2                 
[]
         int 
[]
 4339daa28198341878ff338a51ad758b 6d1b21e69bb0f1316f3f135ebec995b1
954553 Case fatality rate of COVID-19 (%) (Only observations with ≥100 cases) %   2024-07-26 15:17:22 2024-07-31 15:43:05       COVID-19, confirmed cases and deaths 6637   % 
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     cfr_100_cases grapher/covid/latest/cases_deaths/cases_deaths#cfr_100_cases   2                 
[]
         float 
[]
 d5e8bc22f1ab15d40c1915751ccc9443 e15986b0bc901654348b75a511dffd9e
954552 Case fatality rate of COVID-19 (%) %   2024-07-26 15:17:21 2024-07-31 15:43:04       COVID-19, confirmed cases and deaths 6637   % 
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     cfr grapher/covid/latest/cases_deaths/cases_deaths#cfr   2                 
[]
         float 
[]
 f6ebf9cd58c86614e39a8a4a3c997e8d 4c728f541ef0f83ebfa32af8cad13efa
954551 Daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned) deaths per million people   2024-07-26 15:17:20 2024-07-31 15:43:03       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     new_deaths_per_million_7_day_avg_right grapher/covid/latest/cases_deaths/cases_deaths#new_deaths_per_million_7_day_avg_right   2 major               
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 241956b83b3024cf1c25ae0a555d7c58 8d110d06fad1340637eae32ddcfb846e
954550 Daily new confirmed cases of COVID-19 per million people (rolling 7-day average, right-aligned) cases per million people   2024-07-26 15:17:19 2024-07-31 15:43:02       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     new_cases_per_million_7_day_avg_right grapher/covid/latest/cases_deaths/cases_deaths#new_cases_per_million_7_day_avg_right   2 major               
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 80ad69025eb09f3979711a2d400a7c6d c7317a6ed0de362b0ee6ebefb960f08e
954549 Daily new confirmed deaths due to COVID-19 (rolling 7-day average, right-aligned) deaths   2024-07-26 15:17:18 2024-07-31 15:43:00       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     new_deaths_7_day_avg_right grapher/covid/latest/cases_deaths/cases_deaths#new_deaths_7_day_avg_right   2                 
[]
         float 
[]
 8d3047d324afe4c36d626f9be35f4b19 50d078a164629edd3404e56485c359f8
954548 Daily new confirmed cases due to COVID-19 (rolling 7-day average, right-aligned) cases   2024-07-26 15:17:17 2024-07-31 15:42:59       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     new_cases_7_day_avg_right grapher/covid/latest/cases_deaths/cases_deaths#new_cases_7_day_avg_right   2                 
[]
         float 
[]
 8cf8e4778c657f67a490ea38b0c70eed e71bc08d89cdc75eabb36178f6c101d7
954547 Biweekly deaths per million people deaths per million people   2024-07-26 15:17:16 2024-07-31 15:42:58       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     biweekly_deaths_per_million grapher/covid/latest/cases_deaths/cases_deaths#biweekly_deaths_per_million   2 major               
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 b8d5161bc63114f6853d6f725ca811f6 cb0b7969501a34c52481d928dfd1be16
954546 Biweekly cases per million people cases per million people   2024-07-26 15:17:15 2024-07-31 15:42:57       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     biweekly_cases_per_million grapher/covid/latest/cases_deaths/cases_deaths#biweekly_cases_per_million   2 major               
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 5cdec473bdc858dbe780ba9e88110377 9494d571eaa5b8c2708e8619cc2e5a6a
954545 Weekly deaths per million people deaths per million people   2024-07-26 15:17:13 2024-07-31 15:42:56       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     weekly_deaths_per_million grapher/covid/latest/cases_deaths/cases_deaths#weekly_deaths_per_million   2 major               
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 62a5c48e7583dc4e9246b81e98259102 e713c0136642ae0e166c79b14d8ad101
954544 Weekly cases per million people cases per million people   2024-07-26 15:17:12 2024-07-31 15:42:55       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     weekly_cases_per_million grapher/covid/latest/cases_deaths/cases_deaths#weekly_cases_per_million   2 major               
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 bb06d3e7e9ec8f513039b90cd3b48120 b6e01e554d5cc513337c488bb0539399
954543 Total confirmed deaths due to COVID-19 per million people deaths per million people   2024-07-26 15:17:11 2024-07-31 15:42:54       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     total_deaths_per_million grapher/covid/latest/cases_deaths/cases_deaths#total_deaths_per_million   2 major           Total deaths attributed to COVID-19 per 1,000,000 people. Counts can include probable deaths, where reported.   
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 ca5f0cf43a75af8580d1473616ebab3d 028cd95f8eeeb73ddef0482c7c6a0ff4
954542 Daily new confirmed deaths due to COVID-19 per million people deaths per million people   2024-07-26 15:17:09 2024-07-31 15:42:52       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     new_deaths_per_million grapher/covid/latest/cases_deaths/cases_deaths#new_deaths_per_million   2 major           New deaths attributed to COVID-19 per 1,000,000 people. Counts can include probable deaths, where reported.   
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 26fc9b694b5a1d162dcbfb83b56a1a8d 1ecb809d6032c99cf045b91950517506
954541 Total confirmed cases of COVID-19 per million people cases per million people   2024-07-26 15:17:09 2024-07-31 15:42:53       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     total_cases_per_million grapher/covid/latest/cases_deaths/cases_deaths#total_cases_per_million   2 major           Total confirmed cases of COVID-19 per 1,000,000 people. Counts can include probable cases, where reported.   
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 1a0159f274f15ee186e9fa645c3b351e d0b5091961f5d93d136040f536aaeae5
954540 Daily new confirmed cases of COVID-19 per million people cases per million people   2024-07-26 15:17:08 2024-07-31 15:42:50       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases per million people",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     new_cases_per_million grapher/covid/latest/cases_deaths/cases_deaths#new_cases_per_million   2 major           New confirmed cases of COVID-19 per 1,000,000 people. Counts can include probable cases, where reported.   
[]
 This indicator is estimated by normalizing by population. We have used daily population estimates, which leads to changes in the denominator between datapoints from different days. For instance, the denominator for January 1st will be different to the one on January 2nd. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    }
]
     float 
[]
 b3d282f81a8c45bbad39c3265dd1a221 256aa13382867fa161037bf810617712
954539 Biweekly death growth (%) %   2024-07-26 15:17:07 2024-07-31 15:42:50       COVID-19, confirmed cases and deaths 6637   % 
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 1
}
 0     biweekly_pct_growth_deaths grapher/covid/latest/cases_deaths/cases_deaths#biweekly_pct_growth_deaths   2                 
[]
         float 
[]
 c6f369aa8de206eb1b847ccacfc5acaf 77020a578f25261818154f5641e9c384
954538 Biweekly case growth (%) %   2024-07-26 15:17:07 2024-07-31 15:42:49       COVID-19, confirmed cases and deaths 6637   % 
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 1
}
 0     biweekly_pct_growth_cases grapher/covid/latest/cases_deaths/cases_deaths#biweekly_pct_growth_cases   2                 
[]
         float 
[]
 e6bb76905d0e18786552be51e06630b9 c41f662372bfe7a297431996669739fe
954537 Biweekly deaths deaths   2024-07-26 15:17:04 2024-07-31 15:42:47       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     biweekly_deaths grapher/covid/latest/cases_deaths/cases_deaths#biweekly_deaths   2                 
[]
         int 
[]
 d92d256374ef1f9b3feeb5163943c3de 8484af438841233029ac35d1844aee9d
954536 Biweekly cases cases   2024-07-26 15:17:04 2024-07-31 15:42:47       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     biweekly_cases grapher/covid/latest/cases_deaths/cases_deaths#biweekly_cases   2                 
[]
         int 
[]
 2125507b52bd4cb46f177ce8028c26a6 94510e567337546b0c1138de5230e826
954535 Weekly death growth (%) %   2024-07-26 15:17:03 2024-07-31 15:42:44       COVID-19, confirmed cases and deaths 6637   % 
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     weekly_pct_growth_deaths grapher/covid/latest/cases_deaths/cases_deaths#weekly_pct_growth_deaths   2                 
[]
         float 
[]
 2bde554fd47b4909a13924324374ea4b 84411ef971415c28623d5d909e30cfb6
954534 Weekly deaths deaths   2024-07-26 15:17:03 2024-07-31 15:42:45       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     weekly_deaths grapher/covid/latest/cases_deaths/cases_deaths#weekly_deaths   2                 
[]
         int 
[]
 e69e776dede45dce3e1b9ba26b21f048 9ec4d708264a5b0e0c2949c350f204d3
954533 Weekly case growth (%) %   2024-07-26 15:17:02 2024-07-31 15:42:44       COVID-19, confirmed cases and deaths 6637   % 
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 3
}
 0     weekly_pct_growth_cases grapher/covid/latest/cases_deaths/cases_deaths#weekly_pct_growth_cases   2                 
[]
         float 
[]
 1eadd5b4d33a2c8030a4113a9ae1a96d 782ca1da1265b69090dac953cfbf2b7d
954532 Weekly cases cases   2024-07-26 15:16:58 2024-07-31 15:42:41       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     weekly_cases grapher/covid/latest/cases_deaths/cases_deaths#weekly_cases   2                 
[]
         int 
[]
 ba93521f5907e7331bd9af2f2ef140a8 1374c56b410659471ae5f880236e15a0
954531 Total confirmed deaths due to COVID-19 deaths   2024-07-26 15:16:57 2024-07-31 15:42:40       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     total_deaths grapher/covid/latest/cases_deaths/cases_deaths#total_deaths   2             Total deaths attributed to COVID-19. Counts can include probable deaths, where reported.   
[]
         int 
[]
 2aafafadcd43a3c718d130b460439497 afd9b2390e08e5b4a9f12c141ed45c43
954530 Daily new confirmed deaths due to COVID-19 deaths   2024-07-26 15:16:57 2024-07-31 15:42:40       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     new_deaths grapher/covid/latest/cases_deaths/cases_deaths#new_deaths   2             New deaths attributed to COVID-19. Counts can include probable deaths, where reported. In rare cases where our source reports a negative daily change due to a data correction, we set this metric to NA.   
[]
         int 
[]
 42b972d739c1bde80167507eb114682d 173b88bb44476547e7d9c669e76cb88c
954529 Daily new confirmed cases of COVID-19 cases   2024-07-26 15:16:57 2024-07-31 15:42:40       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     new_cases grapher/covid/latest/cases_deaths/cases_deaths#new_cases   2             New confirmed cases of COVID-19. Counts can include probable cases, where reported. In rare cases where our source reports a negative daily change due to a data correction, we set this metric to NA.   
[]
         int 
[]
 bebd7b78e4a88b2405691ccc0b188feb ba62caa178bd211a2c23e8d7a9671c2a
954528 Total confirmed cases of COVID-19 cases   2024-07-26 15:16:57 2024-07-31 15:42:39       COVID-19, confirmed cases and deaths 6637     
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     total_cases grapher/covid/latest/cases_deaths/cases_deaths#total_cases   2             Total confirmed cases of COVID-19. Counts can include probable cases, where reported.   
[]
         int 
[]
 26fe1d57a35eedf11cb23728894a4845 e1237f051ca997ea095e9235cbc93f99

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