Name: Drinking Water Quality Distribution-Monitoring
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Drinking Water Quality Distribution-Monitoring

Description

The data tables summarize the turbidity values, coliform, fluoride and chlorine found at sides in distribution.

SUMMARY

The data tables summarize the turbidity values, coliform, fluoride and chlorine found at sides in distribution each month.

Source: https://data.cityofnewyork.us/d/bkwf-xfky
Last updated at https://data.cityofnewyork.us/data.json : 2020-09-15
Attribution is encouraged by New York City. Please visit New York City's open data portal for more information about the Terms of Use.

Tables

Drinking Water Quality Distribution Monitoring Data 1–1

@kaggle.meetnagadia_drinking_water_quality_distributionmonitoring.drinking_water_quality_distribution_monitoring_data_1_1

519.7 kB
51,327 rows
11 columns

CREATE TABLE drinking_water_quality_distribution_monitoring_data_1_1 (
  "sample_number" DOUBLE,
  "sample_date" TIMESTAMP,
  "sample_time" VARCHAR,
  "sample_site" VARCHAR,
  "sample_class" VARCHAR,
  "location" VARCHAR,
  "residual_free_chlorine_mg_l" DOUBLE  -- Residual Free Chlorine (mg/L),
  "turbidity_ntu" DOUBLE  -- Turbidity (NTU),
  "fluoride_mg_l" DOUBLE  -- Fluoride (mg/L),
  "coliform_quanti_tray_mpn_100ml" VARCHAR  -- Coliform (Quanti-Tray) (MPN /100mL),
  "e_coli_quanti_tray_mpn_100ml" VARCHAR  -- E.coli(Quanti-Tray) (MPN/100mL)
);