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

10 rows where datasetId = 4185 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
104606 Share of social protection in government expenditure (OECD (2017))   Social protection expenditures are divided into nine sub-functions including sickness and disability; old age (pensions); survivors; family and children; unemployment; housing; social exclusion not elsewhere classified (n.e.c); R&D social protection; and social protection n.e.c. 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
104605 Share spent on education in government expenditure (OECD (2017))   Education spending includes pre-primary and primary education; secondary education; post-secondary non-tertiary education; tertiary education; education not definable by level; subsidiary services to education; R&D education; and education not elsewhere classified (n.e.c). 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%"
}
 0           1                                  
104604 Share spent on recreation culture and religion in government expenditure (OECD (2017))   Spending on recreation culture and religion includes recreational and sporting services; cultural services; broadcasting and publishing services; religious and other community services; R&D creation, culture, and religion; Recreation, culture and religion not elsewhere classified (n.e.c). 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%"
}
 0           1                                  
104603 Share spent on health in government expenditure (OECD (2017))   Health spending includes medical products, appliances, and equipment; outpatient services; hospital services; public health services; R&D health, and Health not elsewhere classified (n.e.c). 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%"
}
 0           1                                  
104602 Share of housing and community amenities in government expenditure (OECD (2017))   Housing and community amenities including spending on housing development; community development; water supply; street lighting; R&D housing and community amenities; and Housing and amenities not elsewhere classified (n.e.c). 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%"
}
 0           1                                  
104601 Share of environmental protection in government expenditure (OECD (2017))   Spending on environmental protection includes waste management; waster water management; pollution abatement; protection of biodiversity and landscape; R&D environmental protection; and environmental protection not elsewhere classified (n.e.c). 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%"
}
 0           1                                  
104600 Share of economic affairs in government expenditure (OECD (2017))   Spending on economic affairs includes general economic, commercial, and labour affairs; agriculture, forestry, fishing and hunting; fuel and energy; mining, manufacturing, and construction; transport; communication; other industries; R&D economic affairs; and economic affairs not elsewhere classified (n.e.c). For a comprehensive breakdown, see Annex C of the Government at a Glance (2017) report available <a href="https://www.oecd-ilibrary.org/docserver/gov_glance-2017-en.pdf? 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%"
}
 0           1                                  
104599 Share of public order and safety in government expenditure (OECD (2017))   Spending on public order and safety includes police services; fire-protection services; law courts; prisons; R&D public order and safety; and public order and safety not elsewhere classified (n.e.c). 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%"
}
 0           1                                  
104598 Share of defence in government expenditure (OECD (2017))   Defence spending includes military defence; civil defence; foreign military aid; R&D defence; and defence not elsewhere classified (n.e.c). 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%"
}
 0           1                                  
104597 Share of general public services in government expenditure (OECD (2017))   Spending on general public services include executive and legislative organs, financial and fiscal affairs, external affairs; foreign economic aid; general services; basic research; R&D general public services; general public services not elsewhere classified (n.e.c); public debt transactions; and transfers of a general character between different levels of government. 2019-08-14 22:26:09 2023-06-15 05:05:42       Structure of general government expenditures by function - OECD (2017) 4185 Structure of general government expenditures by function - OECD (2017) 17013   
{
    "unit": "%"
}
 0           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");