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

2 rows where sourceId = 29842 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date), descriptionKey (array)

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
804008 6.2.1 - Proportion of population using safely managed sanitation services, by urban/rural (%) - SH_SAN_SAFE - All areas % Proportion of population using safely managed sanitation services, by urban/rural (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-06-02-01a.pdf and https://unstats.un.org/sdgs/metadata/files/Metadata-06-02-01b.pdf 2023-08-17 17:25:01 2024-07-08 16:18:30     2000-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 United Nations (2023) 29842 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _6_2_1__sh_san_safe__all_areas grapher/un/2023-08-16/un_sdg/_6_2_1__sh_san_safe__all_areas#_6_2_1__sh_san_safe__all_areas   2 minor   Share of the population using safely managed sanitation facilities All areas WHO/UNICEF JMP   Proportion of the total population using safely managed sanitation services Indicator 6.2.1a tracks the proportion of population that is using an improved sanitation facility, which is not shared with other households, and where the excreta produced is either: - treated and disposed in situ; - stored temporarily and then emptied and transported to treatment off-site; - or transported through a sewer with wastewater and then treated off-site. Improved sanitation facilities include flush/pour flush to piped sewer system, septic tanks or pit latrines; ventilated improved pit latrines, composting toilets or pit latrines with slabs. 
[
    "Safely managed sanitation is improved facilities which are not shared with other households and where excreta are safely disposed in situ or transported and treated off-site.",
    "Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-06-02-01a.pdf and https://unstats.un.org/sdgs/metadata/files/Metadata-06-02-01b.pdf"
]
       
{
    "map": {
        "colorScale": {
            "baseColorScheme": "Greens",
            "binningStrategy": "manual",
            "customNumericValues": [
                10,
                20,
                30,
                40,
                50,
                60,
                70,
                80,
                90,
                100
            ],
            "customNumericMinValue": 0
        }
    },
    "tab": "map",
    "title": "Share of the population using safely managed sanitation facilities",
    "yAxis": {
        "max": 100,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.003.json",
    "subtitle": "Safely managed sanitation is improved facilities which are not shared with other households and where excreta are safely disposed in situ or transported and treated off-site.",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/sanitation",
    "sourceDesc": "WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (JMP)",
    "selectedEntityNames": [
        "Northern Africa (UN)",
        "Sub-Saharan Africa (UN)",
        "Central and Southern Asia (UN)",
        "Latin America and the Caribbean (UN)",
        "World",
        "Oceania (UN)",
        "Europe and Northern America (UN)",
        "Eastern and South-Eastern Asia (UN)"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 float 
[]
 a0c3cfe3bc6a7093f38bd07dacd6c40a c4f28145789c10264490f54728a6b71f
803999 6.1.1 - Proportion of population using safely managed drinking water services, by urban/rural (%) - SH_H2O_SAFE - All areas % Proportion of population using safely managed drinking water services, by urban/rural (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-06-01-01.pdf 2023-08-17 17:24:57 2024-07-08 16:18:29     2000-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 United Nations (2023) 29842 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _6_1_1__sh_h2o_safe__all_areas grapher/un/2023-08-16/un_sdg/_6_1_1__sh_h2o_safe__all_areas#_6_1_1__sh_h2o_safe__all_areas   2 minor   Share of the population using safely managed drinking water   WHO/UNICEF JMP   A safely managed drinking water service is defined as one located on premises, available when needed and free from contamination. "The proportion of the population using safely managed drinking water services is defined as the proportion of population using an improved drinking water source which is accessible on premises, available when needed and free from faecal and priority chemical contamination. ‘Improved’ drinking water sources include: piped supplies, boreholes and tubewells, protected dug wells, protected springs, rainwater, water kiosks, and packaged and delivered water." 
[]
       
{
    "map": {
        "colorScale": {
            "baseColorScheme": "PuBu",
            "binningStrategy": "manual",
            "customNumericValues": [
                10,
                20,
                30,
                40,
                50,
                60,
                70,
                80,
                90,
                100
            ],
            "customNumericMinValue": 0
        },
        "timeTolerance": 3
    },
    "tab": "map",
    "title": "Share of the population using safely managed drinking water",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.003.json",
    "subtitle": "A safely managed drinking water service is defined as one located on premises, available when needed and free from contamination.",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/water-access",
    "sourceDesc": "WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (JMP)",
    "selectedEntityNames": [
        "Northern Africa (UN)",
        "Sub-Saharan Africa (UN)",
        "Central and Southern Asia (UN)",
        "Latin America and the Caribbean (UN)",
        "World",
        "Oceania (UN)",
        "Europe and Northern America (UN)",
        "Eastern and South-Eastern Asia (UN)"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 float 
[]
 346d7e93530514eeae4f6287b353f7ce 10f0fb6905f6ca81daa78196ad2211de

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