variables
Data license: CC-BY
31 rows where datasetId = 5679 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 524258 | num_chemweapons_hist_use | The variable identifies the number of countries that used chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524257 | num_chemweapons_hist_alleuse | The variable identifies the number of countries that allegedly used chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524256 | num_chemweapons_hist_poss | The variable identifies the number of countries that possessed chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524255 | num_chemweapons_hist_alleposs | The variable identifies the number of countries that allegedly possessed chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524254 | num_chemweapons_hist_pur | The variable identifies the number of countries that pursued chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524253 | num_chemweapons_hist_neither | The variable identifies the number of countries that neither pursued nor possessed chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524252 | num_chemweapons_curr_use | The variable identifies the number of countries that recently used chemical weapons. 'Recent' means in the previous ten years. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524251 | num_chemweapons_curr_alleuse | The variable identifies the number of countries that recently allegedly used chemical weapons. 'Recent' means in the previous ten years. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524250 | num_chemweapons_curr_poss | The variable identifies the number of countries that currently allegedly possess chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524249 | num_chemweapons_curr_allepur | The variable identifies the number of countries that currently allegedly pursue chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524248 | num_chemweapons_curr_neither | The variable identifies the number of countries that currently neither pursue nor possess chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524247 | num_bioweapons_hist_use | The variable identifies the number of countries that used biological weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524246 | num_bioweapons_hist_poss | The variable identifies the number of countries that possessed biological weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524245 | num_bioweapons_hist_alleposs | The variable identifies the number of countries that allegedly possessed biological weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524244 | num_bioweapons_hist_pur | The variable identifies the number of countries that pursued biological weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524243 | num_bioweapons_hist_allepur | The variable identifies the number of countries that allegedly pursued biological weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524242 | num_bioweapons_hist_neither | The variable identifies the number of countries that neither pursued nor possessed biological weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524241 | num_bioweapons_curr_allepur | The variable identifies the number of countries that currently allegedly pursue biological weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524240 | num_bioweapons_curr_neither | The variable identifies the number of countries that currently neither pursue nor possess biological weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524239 | chemweapons_convention_num | The variable identifies whether a country ratified the Chemical Weapons Convention (score of 2), signed it (score of 1), or neither signed nor ratified it (score of 0), using data from the United Nations (2022). | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524238 | chemweapons_convention | The variable identifies whether a country ratified the Chemical Weapons Convention, signed it, or neither signed nor ratified it, using data from the United Nations (2022). | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524237 | chemweapons_status_hist_num | The variable identifies whether a country ever pursued, possessed, or used chemical weapons, using information from Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022). A country is coded as having pursued chemical weapons if it was increasing its capabilities or had a dedicated program. A country is coded as having possessed chemical weapons if it has weapons which it can deliver. The closest a country got to using chemical weapons ever is recorded. The variable also identifies when a country was alleged by another country of pursuing, possessing, or using chemical weapons, but these allegations have not been confirmed by the country itself or impartial observers. A country receives a score of 0 if it neither pursued nor possessed chemical weapons, a score of 1 if it pursued them, score of 2 if it allegedly possessed them, a score of 3 if it possessed them, a score of 4 if it allegedly used them, and a score of 5 if it used chemical weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524236 | chemweapons_status_hist | The variable identifies whether a country ever pursued, possessed, or used chemical weapons, using information from Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022). A country is coded as having pursued chemical weapons if it was increasing its capabilities or had a dedicated program. A country is coded as having possessed chemical weapons if it has weapons which it can deliver. The closest a country got to using biological weapons ever is recorded. The variable also identifies when a country was alleged by another country of pursuing, possessing, or using chemical weapons, but these allegations have not been confirmed by the country itself or impartial observers. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524235 | chemweapons_status_current_num | The variable identifies whether a country pursues, possesses, or has recently used chemical weapons, using information from Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022). A country is coded as having recently used chemical weapons if it did so in the previous ten years. A country is coded as pursuing chemical weapons if it is increasing its capabilities or has a dedicated program. A country is coded as possessing chemical weapons if it has weapons which it can deliver. 'Recent' means the country used or allegedly used them within the last decade. The variable also identifies when a country was alleged by another country of pursuing, possessing, or using chemical weapons, but these allegations have not been confirmed by the country itself or impartial observers. A country receives a score of 0 if it neither pursues nor possesses chemical weapons, a score of 1 if it allegedly pursues them, score of 2 if it possesses them, a score of 3 if it allegedly recently used them, and a score of 4 if it recently used them. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524234 | chemweapons_status_current | The variable identifies whether a country pursues, possesses, or has recently used chemical weapons, using information from Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022). A country is coded as having recently used chemical weapons if it did so in the previous ten years. A country is coded as pursuing chemical weapons if it is increasing its capabilities or has a dedicated program. A country is coded as possessing chemical weapons if it has weapons which it can deliver. 'Recent' means the country used or allegedly used them within the last decade. The variable also identifies when a country was alleged by another country of pursuing, possessing, or using chemical weapons, but these allegations have not been confirmed by the country itself or impartial observers. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524233 | bioweapons_convention_num | The variable identifies whether a country ratified the Biological Weapons Convention (score of 2), signed it (score of 1), or neither signed nor ratified it (score of 0), using data from the United Nations (2022). | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524232 | bioweapons_convention | The variable identifies whether a country ratified the Biological Weapons Convention, signed it, or neither signed nor ratified it, using data from the United Nations (2022). | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524231 | bioweapons_status_hist_num | The variable identifies whether a country ever pursued, possessed, or used biological weapons, using information from Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022). A country is coded as having pursued biological weapons if it increased its capabilities or had a dedicated program. A country is coded as having possessed biological weapons if it had weapons which it could have delivered. The closest a country got to using biological weapons ever is recorded. The variable also identifies when a country was alleged by another country of pursuing, possessing, or using biological weapons, but these allegations have not been confirmed by the country itself or impartial observers. A country receives a score of 0 if it neither pursued nor possessed biological weapons, a score of 1 if it allegedly pursued them, a score of 2 if it pursued them, a score of 3 if it allegedly possessed them, a score of 4 if it possessed them, and a score of 5 if it used biological weapons. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524230 | bioweapons_status_hist | The variable identifies whether a country ever pursued, possessed, or used biological weapons, using information from Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022). A country is coded as having pursued biological weapons if it increased its capabilities or had a dedicated program. A country is coded as having possessed biological weapons if it had weapons which it could have delivered. The closest a country got to using biological weapons ever is recorded. The variable also identifies when a country was alleged by another country of pursuing, possessing, or using biological weapons, but these allegations have not been confirmed by the country itself or impartial observers. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524229 | bioweapons_status_current_num | The variable identifies whether a country pursues, possesses, or has recently used biological weapons, using information from Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022). A country is coded as pursuing biological weapons if it is increasing its capabilities or has a dedicated program. A country is coded as possessing biological weapons if it has weapons which it can deliver. The variable also identifies when a country was alleged by another country of pursuing, possessing, or using biological weapons, but these allegations have not been confirmed by the country itself or impartial observers. A country receives a score of 0 if it neither pursues nor possesses biological weapons, and a score of 1 if it allegedly pursues them. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 524228 | bioweapons_status_current | The variable identifies whether a country pursues, possesses, or has recently used biological weapons, using information from Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022). A country is coded as pursuing biological weapons if it is increasing its capabilities or has a dedicated program. A country is coded as possessing biological weapons if it has weapons which it can deliver. The variable also identifies when a country was alleged by another country of pursuing, possessing, or using biological weapons, but these allegations have not been confirmed by the country itself or impartial observers. | 2022-09-05 12:05:28 | 2023-06-15 05:05:42 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) 5679 | Our World in Data based on ACA (2022), NTI (2022), CNS (2008), UN (2022) 26703 | {
"includeInTable": true
} |
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");