UN Global Water Data 2012-2022

A Decade of Water and Well-being

@kaggle.kanchana1990_un_global_water_data_2012_2022

Table List

1 table(293.3 KB)

Water

@kaggle.kanchana1990_un_global_water_data_2012_2022.water

293.3 KB
36519 rows
22 columns

dataflow DATAFLOW	ref_area_geographic_area REF AREA:Geographic Area	indicator_indicator INDICATOR:Indicator	sex_sex SEX:Sex	time_period_time_period TIME PERIOD:Time Period	obs_value_observation_value OBS VALUE:Observation Value	unit_measure_unit_of_measure UNIT MEASURE:Unit Of Measure	data_source_data_source DATA SOURCE:Data Source	age_current_age AGE:Current Age
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2012	30.77731323242188	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2013	28.22406578063965	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2014	25.67915534973145	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2015	23.14249038696289	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2016	20.61433029174805	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2017	18.09334373474121	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2018	15.58011531829834	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2019	13.07561874389648	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2020	10.58074951171875	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total
UNICEF:GLOBAL_DATAFLOW(1.0): Cross-sector indicators	AFG: Afghanistan	WS_PPL_H-N: Proportion of population with no handwashing facility at home	_T: Total	2021	8.096185684204102	PCNT: %	WHO/UNICEF Joint Monitoring Programme (2023)	_T: Total


CREATE TABLE water (
  "dataflow" VARCHAR,
  "ref_area_geographic_area" VARCHAR,
  "indicator_indicator" VARCHAR,
  "sex_sex" VARCHAR,
  "time_period_time_period" BIGINT,
  "obs_value_observation_value" DOUBLE,
  "unit_multiplier_unit_multiplier" VARCHAR,
  "unit_measure_unit_of_measure" VARCHAR,
  "obs_status_observation_status" VARCHAR,
  "obs_conf_observation_confidentaility" VARCHAR,
  "lower_bound_lower_bound" VARCHAR,
  "upper_bound_upper_bound" VARCHAR,
  "wgtd_sampl_size_weighted_sample_size" VARCHAR,
  "obs_footnote_observation_footnote" VARCHAR,
  "series_footnote_series_footnote" VARCHAR,
  "data_source_data_source" VARCHAR,
  "source_link_citation_of_or_link_to_the_data_source" VARCHAR,
  "custodian_custodian" VARCHAR,
  "time_period_method_time_period_activity_related_to_whe_d2bb0daa" VARCHAR,
  "ref_period_reference_period" VARCHAR,
  "coverage_time_the_period_of_time_for_which_data_are_provided" VARCHAR,
  "age_current_age" VARCHAR
);