variables
Data license: CC-BY
9 rows where datasetId = 4186 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104615 | Social expenditure on active labor market policies (% of GDP) (OECD Stats (2019)) | Social expenditures on employment services, training, employment incentives, integration of the disabled, direct job creation, and start-up incentives. | 2019-08-15 14:01:29 | 2023-06-15 05:05:42 | Social expenditure by social policy area - OECD SOCX (2019) 4186 | Social expenditure by social policy area (SOCX) - OECD Stats (2019) 17014 | { "name": "Active labor market policies", "unit": "% of GDP" } |
0 | 1 | |||||||||||||||||||||||||||
104614 | Social expenditure on unemployment (% of GDP) (OECD Stats (2019)) | Social expenditure on unemployment includes unemployment compensation, and early retirement for labour market reasons. | 2019-08-15 13:34:19 | 2023-06-15 05:05:42 | Social expenditure by social policy area - OECD SOCX (2019) 4186 | Social expenditure by social policy area (SOCX) - OECD Stats (2019) 17014 | { "name": "Unemployment", "unit": "% of GDP" } |
0 | 1 | |||||||||||||||||||||||||||
104613 | Social expenditure on survivors (% of GDP) (OECD Stats (2019)) | Social expenditure relating to survivors refers to spending on pensions and funeral payments. | 2019-08-15 13:34:19 | 2023-06-15 05:05:42 | Social expenditure by social policy area - OECD SOCX (2019) 4186 | Social expenditure by social policy area (SOCX) - OECD Stats (2019) 17014 | { "name": "Survivors", "unit": "% of GDP" } |
0 | 1 | |||||||||||||||||||||||||||
104612 | Social expenditure on other social policy areas (% of GDP) (OECD Stats (2019)) | Other social policy areas expenditures include non-categorical cash benefits to low-income households, and/or other social services; e.g. legal aid in the Netherlands or the Supplemental Nutrition Assistance Program (SNAP), formerly Food Stamps in the United States. | 2019-08-15 13:34:19 | 2023-06-15 05:05:42 | Social expenditure by social policy area - OECD SOCX (2019) 4186 | Social expenditure by social policy area (SOCX) - OECD Stats (2019) 17014 | { "name": "Other social policy areas", "unit": "% of GDP" } |
0 | 1 | |||||||||||||||||||||||||||
104611 | Old age related social expenditures (% of GDP) (OECD Stats (2019)) | Old age related social expenditures include pensions, early retirement pensions, home-help and residential services for the elderly. For a more detailed definition see Box 2 on page 9 of the <a href="http://www.oecd.org/social/soc/SOCX_Manuel_2019.pdf">The OECD SOCX Manual - 2019 edition</a>. | 2019-08-15 13:34:19 | 2023-06-15 05:05:42 | Social expenditure by social policy area - OECD SOCX (2019) 4186 | Social expenditure by social policy area (SOCX) - OECD Stats (2019) 17014 | { "name": "Old age", "unit": "% of GDP" } |
0 | 1 | |||||||||||||||||||||||||||
104610 | Incapacity related social expenditures (% of GDP) (OECD Stats (2019)) | Incapacity related expenditures include care services, disability benefits, benefits accruing from occupational injury and accident legislation, and employee sickness payments. | 2019-08-15 13:34:19 | 2023-06-15 05:05:42 | Social expenditure by social policy area - OECD SOCX (2019) 4186 | Social expenditure by social policy area (SOCX) - OECD Stats (2019) 17014 | { "name": "Incapacity related", "unit": "% of GDP" } |
0 | 1 | |||||||||||||||||||||||||||
104609 | Social expenditure on housing (% of GDP) (OECD Stats (2019)) | Housing expenditures include housing allowances and rent subsidies. | 2019-08-15 13:34:19 | 2023-06-15 05:05:42 | Social expenditure by social policy area - OECD SOCX (2019) 4186 | Social expenditure by social policy area (SOCX) - OECD Stats (2019) 17014 | { "name": "Housing", "unit": "% of GDP" } |
0 | 1 | |||||||||||||||||||||||||||
104608 | Social expenditure on health (% of GDP) (OECD Stats (2019)) | Health expenditures include spending on in- and out-patient care, medical goods, and prevention. | 2019-08-15 13:34:19 | 2023-06-15 05:05:42 | Social expenditure by social policy area - OECD SOCX (2019) 4186 | Social expenditure by social policy area (SOCX) - OECD Stats (2019) 17014 | { "name": "Health", "unit": "% of GDP" } |
0 | 1 | |||||||||||||||||||||||||||
104607 | Social expenditure on family (% of GDP) (OECD Stats (2019)) | Social expenditures on family include child allowances and credits, childcare support, income support during leave, and single parent payments. | 2019-08-15 13:34:19 | 2023-06-15 05:05:42 | Social expenditure by social policy area - OECD SOCX (2019) 4186 | Social expenditure by social policy area (SOCX) - OECD Stats (2019) 17014 | { "name": "Family", "unit": "% of GDP" } |
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");