Water Quality - Every Drop Matters.

Water water everywhere, but not a drop to drink!

@kaggle.patricklford_water_and_air_quality

Cities1

@kaggle.patricklford_water_and_air_quality.cities1

city City	region Region	country Country	airquality AirQuality	waterpollution WaterPollution
New York City	New York	United States of America	46.81603774	49.5049505
Washington, D.C.	District of Columbia	United States of America	66.12903226	49.10714286
San Francisco	California	United States of America	60.51401869	43
Berlin	nan	Germany	62.36413043	28.61271676
Los Angeles	California	United States of America	36.62162162	61.29943503
Bern	Canton of Bern	Switzerland	94.31818182	12.5
Geneva	Canton of Geneva	Switzerland	71.53846154	17.37288136
Zurich	Canton of Zurich	Switzerland	83.80952381	10.71428571
Basel	nan	Switzerland	81.66666667	26.92307692
London	England	United Kingdom	37.04225352	40.71637427


CREATE TABLE cities1 (
  "city" VARCHAR,
  "region" VARCHAR,
  "country" VARCHAR,
  "airquality" DOUBLE,
  "waterpollution" DOUBLE
);