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

4 rows where sourceId = 29468 sorted by id descending

✎ View and edit SQL

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
802616 17.6.1 - Fixed broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants) - IT_NET_BBND - Between 2 mbps and 10 mbps per 100 population Fixed broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-06-01.pdf 2023-08-17 17:14:16 2024-07-08 16:16:48     2006-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 International Telecommunication Union 29468   
{
    "unit": "per 100 population"
}
 0     _17_6_1__it_net_bbnd__between_2_mbps_and_10_mbps grapher/un/2023-08-16/un_sdg/_17_6_1__it_net_bbnd__between_2_mbps_and_10_mbps#_17_6_1__it_net_bbnd__between_2_mbps_and_10_mbps   1                 
[]
         float 
[]
 5100be48318691fc9607fbbec1c7b837 bc2fb130dcdda28ecbb58676034cf9ed
802615 17.6.1 - Fixed broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants) - IT_NET_BBND - Between 256 kbps and 2 mbps per 100 population Fixed broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-06-01.pdf 2023-08-17 17:14:15 2024-07-08 16:16:48     2004-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 International Telecommunication Union 29468   
{
    "unit": "per 100 population"
}
 0     _17_6_1__it_net_bbnd__between_256_kbps_and_2_mbps grapher/un/2023-08-16/un_sdg/_17_6_1__it_net_bbnd__between_256_kbps_and_2_mbps#_17_6_1__it_net_bbnd__between_256_kbps_and_2_mbps   1                 
[]
         float 
[]
 1128ddef61d7cbb69b90ce4460e8557c 7dcccf81f00da23b9e05767d15748aca
802614 17.6.1 - Fixed broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants) - IT_NET_BBND - Any speed per 100 population Fixed broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-06-01.pdf 2023-08-17 17:14:15 2024-07-08 16:16:48     2000-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 International Telecommunication Union 29468   
{
    "unit": "per 100 population"
}
 0     _17_6_1__it_net_bbnd__any_speed grapher/un/2023-08-16/un_sdg/_17_6_1__it_net_bbnd__any_speed#_17_6_1__it_net_bbnd__any_speed   1                 
[]
         float 
[]
 463ccdb9b658d7d625a492ac774438d1 59c030011749ac94a685fcd0ba296587
802613 17.6.1 - Fixed broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants) - IT_NET_BBND - 10 mbps and over per 100 population Fixed broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-06-01.pdf 2023-08-17 17:14:14 2024-07-08 16:16:48     2007-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 International Telecommunication Union 29468   
{
    "unit": "per 100 population"
}
 0     _17_6_1__it_net_bbnd__10_mbps_and_over grapher/un/2023-08-16/un_sdg/_17_6_1__it_net_bbnd__10_mbps_and_over#_17_6_1__it_net_bbnd__10_mbps_and_over   1                 
[]
         float 
[]
 f3bc6aab934f26f42dc31433965c8f75 c88bd407365b046d850e7aa01da11705

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