Dataset: Water Consumption And Cost (2013 - Feb 2025)

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

907.33 KB
64298 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,
  "edp" BIGINT,
  "rc_code" VARCHAR,
  "funding_source" VARCHAR,
  "amp" VARCHAR,
  "vendor_name" VARCHAR,
  "umis_bill_id" BIGINT,
  "revenue_month" TIMESTAMP,
  "service_start_date" TIMESTAMP,
  "service_end_date" TIMESTAMP,
  "n__days" DOUBLE,
  "meter_number" VARCHAR,
  "estimated" VARCHAR,
  "current_charges" DOUBLE,
  "rate_class" VARCHAR,
  "bill_analyzed" VARCHAR,
  "consumption_hcf" DOUBLE,
  "water_sewer_charges" DOUBLE,
  "other_charges" DOUBLE
);