variables
Data license: CC-BY
71 rows where datasetId = 2684 sorted by id descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95529 | Indicator:Government health budget (USD) | 2018-03-23 12:44:42 | 2023-06-15 05:05:42 | Malaria 2684 | Government health budget (USD) 15402 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95524 | Indicator:All-cause outpatient cases | 2018-03-23 12:44:42 | 2023-06-15 05:05:42 | Malaria 2684 | All-cause outpatient cases 15399 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95523 | Indicator:All-cause outpatient cases - Age Group:0-4 years | 2018-03-23 12:44:42 | 2023-06-15 05:05:42 | Malaria 2684 | All-cause outpatient cases 15399 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95507 | Indicator:Government budget for malaria (USD) | 2018-03-23 12:44:41 | 2023-06-15 05:05:42 | Malaria 2684 | Government budget for malaria (USD) 15388 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95477 | Indicator:Children with fever - Percentage of children who took drug: Combination with artemisinin | 2018-03-23 12:44:41 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug: Combination with artemisinin 15375 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95476 | Indicator:Children with fever - Percentage of children who took drug: Combination with artemisinin - Residence Area Type:Rural | 2018-03-23 12:44:41 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug: Combination with artemisinin 15375 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95475 | Indicator:Children with fever - Percentage of children who took drug: Combination with artemisinin - Residence Area Type:Total | 2018-03-23 12:44:41 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug: Combination with artemisinin 15375 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95457 | Indicator:Number of conventional insecticide-treated nets (ITNs) sold or delivered | 2018-03-23 12:44:40 | 2023-06-15 05:05:42 | Malaria 2684 | Number of conventional insecticide-treated nets (ITNs) sold or delivered 15363 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95374 | Indicator:IPT and Anti-malarial Treatment - Percentage who took 2+ doses SP/Fansidar | 2018-03-23 12:44:30 | 2023-06-15 05:05:42 | Malaria 2684 | IPT and Anti-malarial Treatment - Percentage who took 2+ doses SP/Fansidar 15344 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95373 | Indicator:IPT and Anti-malarial Treatment - Percentage who took 2+ doses SP/Fansidar - Residence Area Type:Rural | 2018-03-23 12:44:30 | 2023-06-15 05:05:42 | Malaria 2684 | IPT and Anti-malarial Treatment - Percentage who took 2+ doses SP/Fansidar 15344 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95372 | Indicator:IPT and Anti-malarial Treatment - Percentage who took 2+ doses SP/Fansidar - Residence Area Type:Total | 2018-03-23 12:44:30 | 2023-06-15 05:05:42 | Malaria 2684 | IPT and Anti-malarial Treatment - Percentage who took 2+ doses SP/Fansidar 15344 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95174 | Indicator:Household Net Possession - Percentage with more than one (Any type of mosquito net ) | 2018-03-23 12:44:07 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with more than one (Any type of mosquito net ) 15285 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95173 | Indicator:Household Net Possession - Percentage with more than one (Any type of mosquito net ) - Residence Area Type:Rural | 2018-03-23 12:44:07 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with more than one (Any type of mosquito net ) 15285 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95172 | Indicator:Household Net Possession - Percentage with more than one (Any type of mosquito net ) - Residence Area Type:Total | 2018-03-23 12:44:07 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with more than one (Any type of mosquito net ) 15285 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95132 | Indicator:Gov. expenditure on malaria (USD) | 2018-03-23 12:44:03 | 2023-06-15 05:05:42 | Malaria 2684 | Gov. expenditure on malaria (USD) 15265 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95107 | Indicator:Children with fever - Percentage of children who took drug the same or next day: Chloroquine | 2018-03-23 12:44:02 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug the same or next day: Chloroquine 15251 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95106 | Indicator:Children with fever - Percentage of children who took drug the same or next day: Chloroquine - Residence Area Type:Rural | 2018-03-23 12:44:02 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug the same or next day: Chloroquine 15251 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95105 | Indicator:Children with fever - Percentage of children who took drug the same or next day: Chloroquine - Residence Area Type:Total | 2018-03-23 12:44:02 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug the same or next day: Chloroquine 15251 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95020 | Indicator:Number of mixed infections | 2018-03-23 12:43:52 | 2023-06-15 05:05:42 | Malaria 2684 | Number of mixed infections 15226 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95015 | Indicator:Use of mosquito nets - Percentage of all women age 15-49 who Slept under any net last night | 2018-03-23 12:43:52 | 2023-06-15 05:05:42 | Malaria 2684 | Use of mosquito nets - Percentage of all women age 15-49 who Slept under any net last night 15223 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95014 | Indicator:Use of mosquito nets - Percentage of all women age 15-49 who Slept under any net last night - Residence Area Type:Rural | 2018-03-23 12:43:52 | 2023-06-15 05:05:42 | Malaria 2684 | Use of mosquito nets - Percentage of all women age 15-49 who Slept under any net last night 15223 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95013 | Indicator:Use of mosquito nets - Percentage of all women age 15-49 who Slept under any net last night - Residence Area Type:Total | 2018-03-23 12:43:52 | 2023-06-15 05:05:42 | Malaria 2684 | Use of mosquito nets - Percentage of all women age 15-49 who Slept under any net last night 15223 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94995 | Indicator:Household Net Possession - Percentage with at least one (Ever treated mosquito net ) | 2018-03-23 12:43:51 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with at least one (Ever treated mosquito net ) 15218 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94994 | Indicator:Household Net Possession - Percentage with at least one (Ever treated mosquito net ) - Residence Area Type:Rural | 2018-03-23 12:43:51 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with at least one (Ever treated mosquito net ) 15218 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94993 | Indicator:Household Net Possession - Percentage with at least one (Ever treated mosquito net ) - Residence Area Type:Total | 2018-03-23 12:43:51 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with at least one (Ever treated mosquito net ) 15218 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94990 | Indicator:Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ITN last night | 2018-03-23 12:43:51 | 2023-06-15 05:05:42 | Malaria 2684 | Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ITN last night 15215 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94989 | Indicator:Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ITN last night - Residence Area Type:Rural | 2018-03-23 12:43:51 | 2023-06-15 05:05:42 | Malaria 2684 | Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ITN last night 15215 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94988 | Indicator:Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ITN last night - Residence Area Type:Total | 2018-03-23 12:43:51 | 2023-06-15 05:05:42 | Malaria 2684 | Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ITN last night 15215 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94967 | Indicator:Household Net Possession - Average number of ever treated nets per household (Ever treated mosquito net ) | 2018-03-23 12:43:50 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Average number of ever treated nets per household (Ever treated mosquito net ) 15206 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94966 | Indicator:Household Net Possession - Average number of ever treated nets per household (Ever treated mosquito net ) - Residence Area Type:Rural | 2018-03-23 12:43:50 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Average number of ever treated nets per household (Ever treated mosquito net ) 15206 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94965 | Indicator:Household Net Possession - Average number of ever treated nets per household (Ever treated mosquito net ) - Residence Area Type:Total | 2018-03-23 12:43:50 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Average number of ever treated nets per household (Ever treated mosquito net ) 15206 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94961 | Indicator:All-cause inpatient cases | 2018-03-23 12:43:50 | 2023-06-15 05:05:42 | Malaria 2684 | All-cause inpatient cases 15204 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94960 | Indicator:All-cause inpatient cases - Age Group:0-4 years | 2018-03-23 12:43:50 | 2023-06-15 05:05:42 | Malaria 2684 | All-cause inpatient cases 15204 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94957 | Indicator:Children with fever - Percentage of children who took drug the same or next day: Combination with artemisinin | 2018-03-23 12:43:50 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug the same or next day: Combination with artemisinin 15201 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94956 | Indicator:Children with fever - Percentage of children who took drug the same or next day: Combination with artemisinin - Residence Area Type:Rural | 2018-03-23 12:43:50 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug the same or next day: Combination with artemisinin 15201 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94955 | Indicator:Children with fever - Percentage of children who took drug the same or next day: Combination with artemisinin - Residence Area Type:Total | 2018-03-23 12:43:50 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug the same or next day: Combination with artemisinin 15201 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94879 | Indicator:Children aged <5 years with fever who received treatment with any antimalarial (%) | 2018-03-23 12:43:47 | 2023-06-15 05:05:42 | Malaria 2684 | Children aged <5 years with fever who received treatment with any antimalarial (%) 15167 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94870 | Indicator:Household Net Possession - Percentage with more than one (Insecticide treated mosquito nets (ITNs) ) | 2018-03-23 12:43:46 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with more than one (Insecticide treated mosquito nets (ITNs) ) 15160 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94869 | Indicator:Household Net Possession - Percentage with more than one (Insecticide treated mosquito nets (ITNs) ) - Residence Area Type:Rural | 2018-03-23 12:43:46 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with more than one (Insecticide treated mosquito nets (ITNs) ) 15160 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94868 | Indicator:Household Net Possession - Percentage with more than one (Insecticide treated mosquito nets (ITNs) ) - Residence Area Type:Total | 2018-03-23 12:43:46 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with more than one (Insecticide treated mosquito nets (ITNs) ) 15160 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94842 | Indicator:Household Net Possession - Average number of ITNs per household (Insecticide treated mosquito nets (ITNs) ) | 2018-03-23 12:43:46 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Average number of ITNs per household (Insecticide treated mosquito nets (ITNs) ) 15155 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94841 | Indicator:Household Net Possession - Average number of ITNs per household (Insecticide treated mosquito nets (ITNs) ) - Residence Area Type:Rural | 2018-03-23 12:43:46 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Average number of ITNs per household (Insecticide treated mosquito nets (ITNs) ) 15155 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94840 | Indicator:Household Net Possession - Average number of ITNs per household (Insecticide treated mosquito nets (ITNs) ) - Residence Area Type:Total | 2018-03-23 12:43:46 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Average number of ITNs per household (Insecticide treated mosquito nets (ITNs) ) 15155 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94784 | Indicator:Household Net Possession - Average number of nets per household (Any type of mosquito net ) | 2018-03-23 12:43:43 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Average number of nets per household (Any type of mosquito net ) 15130 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94783 | Indicator:Household Net Possession - Average number of nets per household (Any type of mosquito net ) - Residence Area Type:Rural | 2018-03-23 12:43:43 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Average number of nets per household (Any type of mosquito net ) 15130 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94782 | Indicator:Household Net Possession - Average number of nets per household (Any type of mosquito net ) - Residence Area Type:Total | 2018-03-23 12:43:43 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Average number of nets per household (Any type of mosquito net ) 15130 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94418 | Indicator:Children aged < 5 years sleeping under insecticide-treated nets (%) | 2018-03-23 12:43:31 | 2023-06-15 05:05:42 | Malaria 2684 | Children aged < 5 years sleeping under insecticide-treated nets (%) 15118 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94417 | Indicator:Children aged < 5 years sleeping under insecticide-treated nets (%) - Residence Area Type:Rural | 2018-03-23 12:43:31 | 2023-06-15 05:05:42 | Malaria 2684 | Children aged < 5 years sleeping under insecticide-treated nets (%) 15118 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94416 | Indicator:Children aged < 5 years sleeping under insecticide-treated nets (%) - Residence Area Type:Urban | 2018-03-23 12:43:31 | 2023-06-15 05:05:42 | Malaria 2684 | Children aged < 5 years sleeping under insecticide-treated nets (%) 15118 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94415 | Indicator:Children aged < 5 years sleeping under insecticide-treated nets (%) - Residence Area Type:Total | 2018-03-23 12:43:31 | 2023-06-15 05:05:42 | Malaria 2684 | Children aged < 5 years sleeping under insecticide-treated nets (%) 15118 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94393 | Indicator:Number of households sprayed at least once | 2018-03-23 12:43:30 | 2023-06-15 05:05:42 | Malaria 2684 | Number of households sprayed at least once 15101 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94343 | Indicator:Contributions from the Global Fund (USD) | 2018-03-23 12:43:20 | 2023-06-15 05:05:42 | Malaria 2684 | Contributions from the Global Fund (USD) 15092 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94312 | Indicator:European Union (USD) | 2018-03-23 12:43:18 | 2023-06-15 05:05:42 | Malaria 2684 | European Union (USD) 15077 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94304 | Indicator:Number of ACT only treatment doses received (public facilities and community) | 2018-03-23 12:43:18 | 2023-06-15 05:05:42 | Malaria 2684 | Number of ACT only treatment doses received (public facilities and community) 15072 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94248 | Indicator:Number of households targeted for spraying | 2018-03-23 12:43:10 | 2023-06-15 05:05:42 | Malaria 2684 | Number of households targeted for spraying 15035 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94247 | Indicator:Malaria attributed deaths - Age Group:0-4 years | 2018-03-23 12:43:10 | 2023-06-15 05:05:42 | Malaria 2684 | Malaria attributed deaths 15034 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94246 | Indicator:Malaria attributed deaths | 2018-03-23 12:43:10 | 2023-06-15 05:05:42 | Malaria 2684 | Malaria attributed deaths 15034 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94167 | Indicator:Household Net Possession - Percentage with more than one (Ever treated mosquito net ) | 2018-03-23 12:42:57 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with more than one (Ever treated mosquito net ) 15003 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94166 | Indicator:Household Net Possession - Percentage with more than one (Ever treated mosquito net ) - Residence Area Type:Rural | 2018-03-23 12:42:57 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with more than one (Ever treated mosquito net ) 15003 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94165 | Indicator:Household Net Possession - Percentage with more than one (Ever treated mosquito net ) - Residence Area Type:Total | 2018-03-23 12:42:57 | 2023-06-15 05:05:42 | Malaria 2684 | Household Net Possession - Percentage with more than one (Ever treated mosquito net ) 15003 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94046 | Indicator:Contributions from the Wolrdbank (USD) | 2018-03-23 12:42:54 | 2023-06-15 05:05:42 | Malaria 2684 | Contributions from the Wolrdbank (USD) 14952 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94036 | Indicator:Children with fever - Percentage of children who took drug the same or next day: SP/ Fansidar | 2018-03-23 12:42:54 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug the same or next day: SP/ Fansidar 14945 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94035 | Indicator:Children with fever - Percentage of children who took drug the same or next day: SP/ Fansidar - Residence Area Type:Rural | 2018-03-23 12:42:54 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug the same or next day: SP/ Fansidar 14945 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94034 | Indicator:Children with fever - Percentage of children who took drug the same or next day: SP/ Fansidar - Residence Area Type:Total | 2018-03-23 12:42:54 | 2023-06-15 05:05:42 | Malaria 2684 | Children with fever - Percentage of children who took drug the same or next day: SP/ Fansidar 14945 | {} |
0 | 1 | ||||||||||||||||||||||||||||
93972 | Indicator:All-cause inpatient deaths - Age Group:0-4 years | 2018-03-23 12:42:51 | 2023-06-15 05:05:42 | Malaria 2684 | All-cause inpatient deaths 14925 | {} |
0 | 1 | ||||||||||||||||||||||||||||
93971 | Indicator:All-cause inpatient deaths | 2018-03-23 12:42:51 | 2023-06-15 05:05:42 | Malaria 2684 | All-cause inpatient deaths 14925 | {} |
0 | 1 | ||||||||||||||||||||||||||||
93968 | Indicator:Malaria outpatient cases - Age Group:0-4 years | 2018-03-23 12:42:51 | 2023-06-15 05:05:42 | Malaria 2684 | Malaria outpatient cases 14922 | {} |
0 | 1 | ||||||||||||||||||||||||||||
93967 | Indicator:Malaria outpatient cases | 2018-03-23 12:42:51 | 2023-06-15 05:05:42 | Malaria 2684 | Malaria outpatient cases 14922 | {} |
0 | 1 | ||||||||||||||||||||||||||||
93963 | Indicator:Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ever treated net last night | 2018-03-23 12:42:51 | 2023-06-15 05:05:42 | Malaria 2684 | Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ever treated net last night 14918 | {} |
0 | 1 | ||||||||||||||||||||||||||||
93962 | Indicator:Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ever treated net last night - Residence Area Type:Rural | 2018-03-23 12:42:51 | 2023-06-15 05:05:42 | Malaria 2684 | Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ever treated net last night 14918 | {} |
0 | 1 | ||||||||||||||||||||||||||||
93961 | Indicator:Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ever treated net last night - Residence Area Type:Total | 2018-03-23 12:42:51 | 2023-06-15 05:05:42 | Malaria 2684 | Use of mosquito nets - Percentage of all women age 15-49 who Slept under an ever treated net last night 14918 | {} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");