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

3 rows where datasetId = 6651 sorted by id descending

✎ View and edit SQL

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
960077 Homicide rate per 100,000 population - Eisner and WHO Mortality Database homicides per 100,000 people   2024-07-31 12:15:49 2024-07-31 12:15:49     1250-2022 Long run homicide rates (1250-2022; Eisner, WHO, UNODC) 6651 OWID based on Eisner (2014); United Nations Office of Drugs and Crime (2022); WHO Mortality Database (2024) 30959   
{
    "unit": "homicides per 100,000 people",
    "numDecimalPlaces": 2
}
 0     death_rate_per_100_000_population_eisner_who grapher/homicide/2024-07-30/homicide_long_run_omm/homicide_long_run_omm#death_rate_per_100_000_population_eisner_who   2                 
[]
 All homicide rate estimates from before 1950 are taken from: Table 4 in Eisner, M. (2014) “From Swords to Words: Does Macro-Level Change in Self-Control Predict Long-Term Variation in Levels of Homicide?” In Why Crime Rates Fall and Why They Don’t, edited by Michael Tonry. Vol. 43 of Crime and Justice: A Review of Research, edited by Michael Tonry. Chicago: University of Chicago Press. In Eisner (2014) homicide rates are given for a range of years - we allocate the homicide rate at the midpoint of the given period. Our data-management and -visualization system can currently only observations that happen in a particular year (or day), therefore we can't store the time-information as presented by the original source and instead allocate the observation the midpoint of the given period. Historical estimates of homicide rates are derived from national vital statistics and judicial archives. The older data is often fragmented and subject to a number of biases including: geographic bias, incomplete records, changing age structure, wound treatment, and the lethality of weapons. This variable is a combination of homicide rate estimates from Eisner (2014) and the WHO Mortality Database. For the following countries we use Eisner (2014) before the given date and the WHO Mortality Database for all later datapoints: * 1950: France, Ireland, Netherlands * 1951: Italy, Spain, Sweden, Switzerland * 1954: Belgium * 1990: Germany For Corsica and Sardinia; England and Wales and Sweden and Finland all datapoints are from Eisner (2014). All other datapoints not specified above are sourced from the WHO Mortality Database.       float 
[]
 10fd1c145719da743f7b6ad8bd97f9d9 ca1be71275847567da9af7ece8b472b9
960076 Homicide rate per 100,000 population - Eisner and UNODC homicides per 100,000 people   2024-07-31 12:15:49 2024-07-31 12:15:49     1250-2021 Long run homicide rates (1250-2022; Eisner, WHO, UNODC) 6651 OWID based on Eisner (2014); United Nations Office of Drugs and Crime (2022); WHO Mortality Database (2024) 30959   
{
    "unit": "homicides per 100,000 people",
    "numDecimalPlaces": 2
}
 0     death_rate_per_100_000_population_eisner_unodc grapher/homicide/2024-07-30/homicide_long_run_omm/homicide_long_run_omm#death_rate_per_100_000_population_eisner_unodc   2                 
[]
 All homicide rate estimates from before 1950 are taken from: Table 4 in Eisner, M. (2014) “From Swords to Words: Does Macro-Level Change in Self-Control Predict Long-Term Variation in Levels of Homicide?” In Why Crime Rates Fall and Why They Don’t, edited by Michael Tonry. Vol. 43 of Crime and Justice: A Review of Research, edited by Michael Tonry. Chicago: University of Chicago Press. In Eisner (2014) homicide rates are given for a range of years - we allocate the homicide rate at the midpoint of the given period. Our data-management and -visualization system can currently only observations that happen in a particular year (or day), therefore we can't store the time-information as presented by the original source and instead allocate the observation the midpoint of the given period. Historical estimates of homicide rates are derived from national vital statistics and judicial archives. The older data is often fragmented and subject to a number of biases including: geographic bias, incomplete records, changing age structure, wound treatment, and the lethality of weapons. This variable is a combination of homicide rate estimates from Eisner (2014) and the United Nations Office of Drugs and Crime. For the following countries we use Eisner (2014) before 1990 and the United Nations Office of Drugs and Crime for all later datapoints: France, Ireland, Netherlands, Italy, Spain, Sweden, Switzerland, Belgium, Germany. For Corsica and Sardinia; England and Wales and Sweden and Finland all datapoints are from Eisner (2014). All other datapoints not specified above are sourced from the United Nations Office of Drugs and Crime.       float 
[]
 2957ad18d53b3b183e625fdb43e7843e 06dd40f2e4c8316eb69a944f1ba6c191
960075 Homicide rate per 100,000 population - Eisner homicides per 100,000 people   2024-07-31 12:15:49 2024-07-31 12:15:49     1250-2006 Long run homicide rates (1250-2022; Eisner, WHO, UNODC) 6651 OWID based on Eisner (2014); United Nations Office of Drugs and Crime (2022); WHO Mortality Database (2024) 30959   
{
    "unit": "homicides per 100,000 people",
    "numDecimalPlaces": 2
}
 0     death_rate_per_100_000_population_eisner grapher/homicide/2024-07-30/homicide_long_run_omm/homicide_long_run_omm#death_rate_per_100_000_population_eisner   2                 
[]
 All homicide rate estimates from before 1950 are taken from: Table 4 in Eisner, M. (2014) “From Swords to Words: Does Macro-Level Change in Self-Control Predict Long-Term Variation in Levels of Homicide?” In Why Crime Rates Fall and Why They Don’t, edited by Michael Tonry. Vol. 43 of Crime and Justice: A Review of Research, edited by Michael Tonry. Chicago: University of Chicago Press. In Eisner (2014) homicide rates are given for a range of years - we allocate the homicide rate at the midpoint of the given period. Our data-management and -visualization system can currently only observations that happen in a particular year (or day), therefore we can't store the time-information as presented by the original source and instead allocate the observation the midpoint of the given period. Historical estimates of homicide rates are derived from national vital statistics and judicial archives. The older data is often fragmented and subject to a number of biases including: geographic bias, incomplete records, changing age structure, wound treatment, and the lethality of weapons.       float 
[]
 c29aa0205905f6f60e0f0a7cd008974f f7a56f081ecb126af0b0d236a5e724c3

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