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

5 rows where sourceId = 30133 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updatedAt, 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
687095 Possibly adequate treatment % Share who met the criteria for having an anxiety disorder in the past 12 months and received potentially adequate treatment for it. "Potentially adequate treatment" was defined as pharmacological medication, psychotherapy, or complementary alternative medicine. 2023-05-11 15:30:58 2024-07-08 17:24:06     2002-2017 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 6006 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 30133 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     possibly_adequate_treatment grapher/fasttrack/latest/treatment_gap_anxiety_disorders_world_mental_health_surveys/treatment_gap_anxiety_disorders_world_mental_health_surveys#possibly_adequate_treatment   1                 
[]
         float 
[]
 2fdaa34c024e5baa4e94b7420921bb44 ab2a747528e7532dd35396ee48a61922
687094 Any treatment % Share who met the criteria for having an anxiety disorder in the past 12 months and received any treatment for it. 2023-05-11 15:30:58 2024-07-08 17:24:06     2002-2017 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 6006 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 30133 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     any_treatment grapher/fasttrack/latest/treatment_gap_anxiety_disorders_world_mental_health_surveys/treatment_gap_anxiety_disorders_world_mental_health_surveys#any_treatment   1                 
[]
         float 
[]
 773228124e39a25e1c3dbcddbd030c77 0c47968bb4aecf6f2d1d0172e997077e
687093 Possibly adequate treatment, conditional % Share who received potentially adequate treatment, among those who met the criteria for an anxiety disorder in the past 12 months. "Potentially adequate treatment" was defined as pharmacological medication, psychotherapy, or complementary alternative medicine. 2023-05-11 15:30:58 2024-07-08 17:24:06     2002-2017 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 6006 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 30133 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     possibly_adequate_treatment__conditional grapher/fasttrack/latest/treatment_gap_anxiety_disorders_world_mental_health_surveys/treatment_gap_anxiety_disorders_world_mental_health_surveys#possibly_adequate_treatment__conditional   1                 
[]
         float 
[]
 43841b9ebe3230a892901dae61a3f883 aa5b7ab1fe4ae0ce2e36cad3eb59ae37
687092 Any treatment, conditional % Share who received any treatment, among those who met the criteria for an anxiety disorder in the past 12 months. 2023-05-11 15:30:58 2024-07-08 17:24:05     2002-2017 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 6006 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 30133 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     any_treatment__conditional grapher/fasttrack/latest/treatment_gap_anxiety_disorders_world_mental_health_surveys/treatment_gap_anxiety_disorders_world_mental_health_surveys#any_treatment__conditional   1                 
[]
         float 
[]
 ca8a8471ec8d01934b26f9a5fbaf7440 af8b04854d20a8d914912e30843a048d
687091 12 month anxiety disorder % Share who met the criteria for having an anxiety disorder in the past 12 months. The Composite International Diagnostic Interview (CIDI) was used to interview participants about symptoms of anxiety. 2023-05-11 15:30:58 2024-07-08 17:24:05     2002-2017 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 6006 Treatment gap for anxiety disorders - World Mental Health Surveys - Alonso et al. 2017 30133 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _12_month_anxiety_disorder grapher/fasttrack/latest/treatment_gap_anxiety_disorders_world_mental_health_surveys/treatment_gap_anxiety_disorders_world_mental_health_surveys#_12_month_anxiety_disorder   1                 
[]
         float 
[]
 c21fb21c6b09ba2a667ad994f805792e 960abfb8b555708b496dd9825d366af9

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