Water Quality - Every Drop Matters.

Water water everywhere, but not a drop to drink!

@kaggle.patricklford_water_and_air_quality

Table List

2 tables(368.13 KB)

Who Pm

@kaggle.patricklford_water_and_air_quality.who_pm

282.53 KB
9450 rows
34 columns

indicatorcode IndicatorCode	indicator Indicator	valuetype ValueType	parentlocationcode ParentLocationCode	parentlocation ParentLocation	location_type Location Type	spatialdimvaluecode SpatialDimValueCode	location Location	period_type Period Type	period Period	islatestyear IsLatestYear	dim1_type Dim1 Type	dim1 Dim1	dim1valuecode Dim1ValueCode	factvaluenumeric FactValueNumeric	factvaluenumericlow FactValueNumericLow	factvaluenumerichigh FactValueNumericHigh	value Value	language Language	datemodified DateModified
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	AFR	Africa	Country	KEN	Kenya	Year	2019	true	Residence Area Type	Cities	RESIDENCEAREATYPE_CITY	10.01	6.29	13.74	10.01 [6.29-13.74]	EN	2022-08-11T23:00:00.000Z
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	AMR	Americas	Country	TTO	Trinidad and Tobago	Year	2019	true	Residence Area Type	rural	RESIDENCEAREATYPE_RUR	10.02	7.44	12.55	10.02 [7.44-12.55]	EN	2022-08-11T23:00:00.000Z
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	EUR	Europe	Country	GBR	United Kingdom of Great Britain and Northern Ireland	Year	2019	true	Residence Area Type	Cities	RESIDENCEAREATYPE_CITY	10.06	9.73	10.39	10.06 [9.73-10.39]	EN	2022-08-11T23:00:00.000Z
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	AMR	Americas	Country	GRD	Grenada	Year	2019	true	Residence Area Type	Total	RESIDENCEAREATYPE_TOTL	10.08	7.07	13.2	10.08 [7.07-13.20]	EN	2022-08-11T23:00:00.000Z
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	AMR	Americas	Country	BRA	Brazil	Year	2019	true	Residence Area Type	Towns	RESIDENCEAREATYPE_TOWN	10.09	8.23	12.46	10.09 [8.23-12.46]	EN	2022-08-11T23:00:00.000Z
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	EUR	Europe	Country	DNK	Denmark	Year	2019	true	Residence Area Type	Urban	RESIDENCEAREATYPE_URB	10.12	9.37	10.97	10.12 [9.37-10.97]	EN	2022-08-11T23:00:00.000Z
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	EUR	Europe	Country	RUS	Russian Federation	Year	2019	true	Residence Area Type	Cities	RESIDENCEAREATYPE_CITY	10.19	8.58	12.57	10.19 [8.58-12.57]	EN	2022-08-11T23:00:00.000Z
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	EUR	Europe	Country	ESP	Spain	Year	2019	true	Residence Area Type	Cities	RESIDENCEAREATYPE_CITY	10.19	9.94	10.38	10.19 [9.94-10.38]	EN	2022-08-11T23:00:00.000Z
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	AMR	Americas	Country	GRD	Grenada	Year	2019	true	Residence Area Type	Towns	RESIDENCEAREATYPE_TOWN	10.22	7.15	13.37	10.22 [7.15-13.37]	EN	2022-08-11T23:00:00.000Z
SDGPM25	Concentrations of fine particulate matter (PM2.5)	text	AMR	Americas	Country	GRD	Grenada	Year	2019	true	Residence Area Type	Urban	RESIDENCEAREATYPE_URB	10.22	7.15	13.37	10.22 [7.15-13.37]	EN	2022-08-11T23:00:00.000Z


CREATE TABLE who_pm (
  "indicatorcode" VARCHAR,
  "indicator" VARCHAR,
  "valuetype" VARCHAR,
  "parentlocationcode" VARCHAR,
  "parentlocation" VARCHAR,
  "location_type" VARCHAR,
  "spatialdimvaluecode" VARCHAR,
  "location" VARCHAR,
  "period_type" VARCHAR,
  "period" BIGINT,
  "islatestyear" BOOLEAN,
  "dim1_type" VARCHAR,
  "dim1" VARCHAR,
  "dim1valuecode" VARCHAR,
  "dim2_type" VARCHAR,
  "dim2" VARCHAR,
  "dim2valuecode" VARCHAR,
  "dim3_type" VARCHAR,
  "dim3" VARCHAR,
  "dim3valuecode" VARCHAR,
  "datasourcedimvaluecode" VARCHAR,
  "datasource" VARCHAR,
  "factvaluenumericprefix" VARCHAR,
  "factvaluenumeric" DOUBLE,
  "factvalueuom" VARCHAR,
  "factvaluenumericlowprefix" VARCHAR,
  "factvaluenumericlow" DOUBLE,
  "factvaluenumerichighprefix" VARCHAR,
  "factvaluenumerichigh" DOUBLE,
  "value" VARCHAR,
  "factvaluetranslationid" VARCHAR,
  "factcomments" VARCHAR,
  "language" VARCHAR,
  "datemodified" VARCHAR
);