Name: Water Consumption And Cost (2013 - Feb 2025)
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Water Consumption And Cost (2013 - Feb 2025)

Monthly consumption and cost data by borough and development. Data set includes utility vendor and meter information.
Organization: City of New York
Last updated: 2020-11-10T17:00:56.611146
Tags: 2018od4a-video, water-consumption-and-cost-2012-2016

Tables

Table 1

@usgov.city_of_new_york_water_consumption_and_cost_2013_2020.table_1

929.1 kB
64,298 rows
25 columns

CREATE TABLE table_1 (
  "development_name" VARCHAR,
  "borough" VARCHAR,
  "account_name" VARCHAR,
  "location" VARCHAR,
  "meter_amr" VARCHAR,
  "meter_scope" VARCHAR,
  "tds" VARCHAR  -- TDS #,
  "edp" BIGINT,
  "rc_code" VARCHAR,
  "funding_source" VARCHAR,
  "amp" VARCHAR  -- AMP #,
  "vendor_name" VARCHAR,
  "umis_bill_id" BIGINT,
  "revenue_month" TIMESTAMP,
  "service_start_date" TIMESTAMP,
  "service_end_date" TIMESTAMP,
  "n__days" DOUBLE  -- # Days,
  "meter_number" VARCHAR,
  "estimated" VARCHAR,
  "current_charges" DOUBLE,
  "rate_class" VARCHAR,
  "bill_analyzed" VARCHAR,
  "consumption_hcf" DOUBLE  -- Consumption (HCF),
  "water_sewer_charges" DOUBLE,
  "other_charges" DOUBLE
);