Monthly consumption and cost data by borough and development. Data set includes utility vendor and meter information.
This dataset has the following 23 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Development Name | development_name | text | The name of the housing development as listed in the Development Data Book. | WSUR (BROWNSTONES) POLO GROUNDS TOWERS CAMPOS PLAZA II STRAUS DE HOSTOS APARTMENTS view top 100 |
Borough | borough | text | Bronx, Brooklyn, Manhattan, Queens, or Staten Island. | MANHATTAN view top 100 |
Account Name | account_name | text | The name of the housing development as listed in the Development Data Book. | WEST SIDE URBAN RENEWAL (BROWNSTONES) CAMPOS PLAZA I/CAMPOS PLAZA II DE HOSTOS APARTMENTS THOMAS APARTMENTS STRAUS view top 100 |
Location | location | text | "Building number. In order to run an analysis by building, you can use a combination of TDS and building number which gives a unique identifier for each building" | BLD 01 CAMPOS PLAZA I BLD 02 BLD 19 BLD 05 BLD 03 view top 100 |
Meter AMR | meter_amr | text | Is the meter Automatic Meter Reading (AMR), Interval or none | AMR view top 100 |
Meter Scope | meter_scope | text | The buildings or areas the account and meter supply | CAMPOS PLAZA II ALL CAMPOS PLAZA I ALL view top 100 |
TDS # | tds | number | TDS (Tenant Data System) number is the unique identifier for all NCYHA developments. It is recommended to use it in order to run analysis by development. The TDS is also the unique link between NYCHA data sets. | 178 268 155 153 192 view top 100 |
EDP | edp | number | NYCHA Electronic Data Processing. Number used to identify individual NYCHA developments. EDP is used by NYCHA only to link data issued from a different system (the energy management system that was used by NYCHA before 2010). It is recommended to use the TDS # as a unique identifier of each development. | 259 279 265 387 263 view top 100 |
RC Code | rc_code | text | "NYCHA budget responsibility code. Code representing a specific development. " | M017800 M015500 M026800 M015300 M018700 view top 100 |
Funding Source | funding_source | text | "The development’s funding source including Federal, Mixed Finance, or an indication that the facility is a non development facility which means a non residential facility." | FEDERAL MIXED FINANCE/LLC2 MIXED FINANCE/LLC1 SECTION 8 view top 100 |
AMP # | amp | text | Abbreviation for Asset Management Project (AMP) numbers. HUD Development asset tracking number. An AMP number can consist of more than one development. | NY005011270P NY005011000P NY005012570P NY005011530P NY005021870P view top 100 |
Vendor Name | vendor_name | text | Utility vendor name | CONSOLIDATED EDISON COMPANY OF NY view top 100 |
UMIS BILL ID | umis_bill_id | number | 8577120 8682382 9836084 10926222 8760414 view top 100 | |
Revenue Month | revenue_month | text | Year and month of bill: 2016-01 | 2020-03 2020-01 2020-04 2020-02 2022-01 view top 100 |
Service Start Date | service_start_date | calendar_date | Bill start date | 2020-01-31T00:00:00.000 2019-12-31T00:00:00.000 2020-02-28T00:00:00.000 2020-03-31T00:00:00.000 2021-12-30T00:00:00.000 view top 100 |
Service End Date | service_end_date | calendar_date | Bill end date | 2020-04-29T00:00:00.000 2020-02-28T00:00:00.000 2020-03-31T00:00:00.000 2020-01-31T00:00:00.000 2022-01-31T00:00:00.000 view top 100 |
# days | days | number | Number of days on bill | 29 30 32 31 28 view top 100 |
Meter Number | meter_number | text | Meter number | 331058 321136 321190 322052 321178 view top 100 |
Estimated | estimated | text | Meter was not read for the time period. The consumption and cost are estimated. (Data is updated with actual reads once the meter is read) | N Y view top 100 |
Current Charges | current_charges | number | Total costs | 0 13279.06 2738.19 2980.28 3962.39 view top 100 |
Rate Class | rate_class | text | The rate applied to the account. Details about each rate (dollar value) are available on the vendor web site. | SC3 SC4 view top 100 |
Bill Analyzed | bill_analyzed | text | The bill was analyzed for billing errors by NYCHA's Utility Management system during the billing period | Yes Exception view top 100 |
Consumption (Mlbs) | consumption_mlbs | number | Total Mlbs consumption | 0 0.12 0.24 0.53 0.1 view top 100 |