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

36 rows where datasetId = 5855 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, timespan, display, 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
540298 Total homicides where the victim was male per 100,000 population homicides per 100,000 people   2023-01-18 12:13:41 2023-10-27 12:25:39     1990-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides per 100,000 people",
    "shortUnit": null,
    "numDecimalPlaces": 2
}
 0     male_all_ages_rate_per_100_000_population grapher/homicide/2023-01-27/unodc/unodc#male_all_ages_rate_per_100_000_population   1                                  
540297 Total homicides where the victim was female per 100,000 population homicides per 100,000 people   2023-01-18 12:13:41 2023-10-27 12:25:39     1990-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides per 100,000 people",
    "shortUnit": null,
    "numDecimalPlaces": 2
}
 0     female_all_ages_rate_per_100_000_population grapher/homicide/2023-01-27/unodc/unodc#female_all_ages_rate_per_100_000_population   1                                  
540295 Total homicides where the victim was male and aged 20-24 homicides   2023-01-18 12:13:41 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_20_24_counts grapher/homicide/2023-01-27/unodc/unodc#male_20_24_counts   1                                  
540294 Total homicides where the victim was male and aged 25-29 homicides   2023-01-18 12:13:41 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_25_29_counts grapher/homicide/2023-01-27/unodc/unodc#male_25_29_counts   1                                  
540293 Total homicides where the victim was male and aged 18-19 homicides   2023-01-18 12:13:41 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_18_19_counts grapher/homicide/2023-01-27/unodc/unodc#male_18_19_counts   1                                  
540292 Total homicides where the victim was male and aged 15-17 homicides   2023-01-18 12:13:41 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_15__17_counts grapher/homicide/2023-01-27/unodc/unodc#male_15__17_counts   1                                  
540291 Total homicides where the victim was male and aged 60+ homicides   2023-01-18 12:13:40 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_60_and_older_counts grapher/homicide/2023-01-27/unodc/unodc#male_60_and_older_counts   1                                  
540290 Total homicides where the victim was male and aged 10-14 homicides   2023-01-18 12:13:41 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_10__14_counts grapher/homicide/2023-01-27/unodc/unodc#male_10__14_counts   1                                  
540289 Total homicides where the victim was male and aged 0-9 homicides   2023-01-18 12:13:40 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_0_9_counts grapher/homicide/2023-01-27/unodc/unodc#male_0_9_counts   1                                  
540288 Total homicides where the victim was male and aged 45-59 homicides   2023-01-18 12:13:40 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_45_59_counts grapher/homicide/2023-01-27/unodc/unodc#male_45_59_counts   1                                  
540287 Total homicides where the victim was male and aged 30-44 homicides   2023-01-18 12:13:40 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_30_44_counts grapher/homicide/2023-01-27/unodc/unodc#male_30_44_counts   1                                  
540286 Total homicides where the victim was male homicides   2023-01-18 12:13:39 2023-10-27 12:25:39     1990-2021 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     male_all_ages_counts grapher/homicide/2023-01-27/unodc/unodc#male_all_ages_counts   1                                  
540285 Total homicides where the victim was female and aged 25-29 homicides   2023-01-18 12:13:39 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_25_29_counts grapher/homicide/2023-01-27/unodc/unodc#female_25_29_counts   1                                  
540284 Total homicides where the victim was female and aged 20-24 homicides   2023-01-18 12:13:39 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_20_24_counts grapher/homicide/2023-01-27/unodc/unodc#female_20_24_counts   1                                  
540283 Total homicides where the victim was female and aged 18-19 homicides   2023-01-18 12:13:39 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_18_19_counts grapher/homicide/2023-01-27/unodc/unodc#female_18_19_counts   1                                  
540282 Total homicides where the victim was female and aged 15-17 homicides   2023-01-18 12:13:39 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_15__17_counts grapher/homicide/2023-01-27/unodc/unodc#female_15__17_counts   1                                  
540281 Total homicides where the victim was female and aged 0-9 homicides   2023-01-18 12:13:39 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_0_9_counts grapher/homicide/2023-01-27/unodc/unodc#female_0_9_counts   1                                  
540280 Total homicides where the victim was female and aged 10-14 homicides   2023-01-18 12:13:39 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_10__14_counts grapher/homicide/2023-01-27/unodc/unodc#female_10__14_counts   1                                  
540279 Total homicides where the victim was female and aged 60+ homicides   2023-01-18 12:13:39 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_60_and_older_counts grapher/homicide/2023-01-27/unodc/unodc#female_60_and_older_counts   1                                  
540278 Total homicides where the victim was female and aged 45-59 homicides   2023-01-18 12:13:38 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_45_59_counts grapher/homicide/2023-01-27/unodc/unodc#female_45_59_counts   1                                  
540277 Total homicides where the victim was female homicides   2023-01-18 12:13:38 2023-10-27 12:25:39     1990-2021 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_all_ages_counts grapher/homicide/2023-01-27/unodc/unodc#female_all_ages_counts   1                                  
540276 Total homicides where the victim was female and aged 30-44 homicides   2023-01-18 12:13:38 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     female_30_44_counts grapher/homicide/2023-01-27/unodc/unodc#female_30_44_counts   1                                  
540271 Homicides by firearms or explosives per 100,000 population homicides per 100,000 people   2023-01-18 12:13:38 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides per 100,000 people",
    "shortUnit": null,
    "numDecimalPlaces": 2
}
 0     firearms_or_explosives_rate_per_100_000_population grapher/homicide/2023-01-27/unodc/unodc#firearms_or_explosives_rate_per_100_000_population   1                                  
540270 Homicides by sharp or blunt objects, including motor vehicles, per 100,000 population homicides per 100,000 people   2023-01-18 12:13:38 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides per 100,000 people",
    "shortUnit": null,
    "numDecimalPlaces": 2
}
 0     another_weapon_rate_per_100_000_population grapher/homicide/2023-01-27/unodc/unodc#another_weapon_rate_per_100_000_population   1                                  
540268 Homicides by unspecified means per 100,000 population homicides per 100,000 people   2023-01-18 12:13:37 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides per 100,000 people",
    "shortUnit": null,
    "numDecimalPlaces": 2
}
 0     unspecified_means_rate_per_100_000_population grapher/homicide/2023-01-27/unodc/unodc#unspecified_means_rate_per_100_000_population   1                                  
540267 Homicides by without a weapon per 100,000 population homicides per 100,000 people   2023-01-18 12:13:37 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides per 100,000 people",
    "shortUnit": null,
    "numDecimalPlaces": 2
}
 0     without_a_weapon__other_mechanism_rate_per_100_000_population grapher/homicide/2023-01-27/unodc/unodc#without_a_weapon__other_mechanism_rate_per_100_000_population   1                                  
540266 Homicides by sharp object per 100,000 population homicides per 100,000 people   2023-01-18 12:13:37 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides per 100,000 people",
    "shortUnit": null,
    "numDecimalPlaces": 2
}
 0     sharp_object_rate_per_100_000_population grapher/homicide/2023-01-27/unodc/unodc#sharp_object_rate_per_100_000_population   1                                  
540265 Total homicides by firearms or explosives homicides   2023-01-18 12:13:37 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     firearms_or_explosives_counts grapher/homicide/2023-01-27/unodc/unodc#firearms_or_explosives_counts   1                                  
540264 Total homicides by sharp object homicides   2023-01-18 12:13:37 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     sharp_object_counts grapher/homicide/2023-01-27/unodc/unodc#sharp_object_counts   1                                  
540263 Total homicides by any object used as weapon, including sharp and blunt objects and motor vehicles homicides   2023-01-18 12:13:37 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     another_weapon_counts grapher/homicide/2023-01-27/unodc/unodc#another_weapon_counts   1                                  
540262 Total homicides without a weapon homicides   2023-01-18 12:13:37 2023-10-27 12:25:39     2013-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     without_a_weapon__other_mechanism_counts grapher/homicide/2023-01-27/unodc/unodc#without_a_weapon__other_mechanism_counts   1                                  
540261 Total homicides by unspecified means homicides   2023-01-18 12:13:37 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     unspecified_means_counts grapher/homicide/2023-01-27/unodc/unodc#unspecified_means_counts   1                                  
540260 Homicides by firearm per 100,000 population homicides per 100,000 people   2023-01-18 12:13:37 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides per 100,000 people",
    "shortUnit": null,
    "numDecimalPlaces": 2
}
 0     firearms_rate_per_100_000_population grapher/homicide/2023-01-27/unodc/unodc#firearms_rate_per_100_000_population   1                                  
540259 Total homicides by firearm homicides   2023-01-18 12:13:37 2023-10-27 12:25:39     2005-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     firearms_counts grapher/homicide/2023-01-27/unodc/unodc#firearms_counts   1                                  
540228 Homicides homicides   2023-01-09 15:48:41 2023-10-27 12:25:39     1990-2021 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides",
    "shortUnit": null,
    "numDecimalPlaces": 0
}
 0     counts grapher/homicide/2023-01-27/unodc/unodc#counts   1                                  
540227 Homicides per 100,000 population homicides per 100,000 people   2023-01-09 15:48:41 2023-10-27 12:25:39     1990-2020 United Nations Office on Drugs and Crime - Intentional Homicides 5855 United Nations Office on Drugs and Crime (2022) 27273   
{
    "unit": "homicides per 100,000 people",
    "shortUnit": null,
    "numDecimalPlaces": 2
}
 0     rate_per_100_000_population grapher/homicide/2023-01-27/unodc/unodc#rate_per_100_000_population   1                                  

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