Monthly consumption and cost data by borough and development. Data set includes utility vendor and meter information.
This dataset has the following 25 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. | FHA REPOSSESSED HOUSES (GROUP V) SAMUEL (CITY) FHA REPOSSESSED HOUSES (GROUP I) FHA REPOSSESSED HOUSES (GROUP X) SOUTH JAMAICA II view top 100 |
| Borough | borough | text | Bronx, Brooklyn, Manhattan, Queens, or Staten Island. | FHA BROOKLYN MANHATTAN BRONX QUEENS view top 100 |
| Account Name | account_name | text | The name of the housing development as listed in the Development Data Boo | FHA REPOSSESSED HOUSES (GROUP V) SAMUEL (CITY) FHA REPOSSESSED HOUSES (GROUP I) FHA REPOSSESSED HOUSES (GROUP X) SOUTH JAMAICA II 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 BLD 03 BLD 02 BLD 04 BLD 05 view top 100 |
| Meter AMR | meter_amr | text | Is the meter Automatic Meter Reading (AMR), Interval or none | AMR NONE Not Applicable view top 100 |
| Meter Scope | meter_scope | text | The buildings or areas the account and meter supply | Community Center STORE 01-02 BLD 01 BLD 05 BLD 02 view top 100 |
| TDS # | tds | text | 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. | 260 377 209 284 66 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. | 397 650 325 324 521 view top 100 |
| RC Code | rc_code | text | "NYCHA budget responsibility code. Code representing a specific development. " | Q026000 M037700 Q020900 Q028400 Q006600 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/LLC1 MHOP MIXED FINANCE/LLC2 NON-DEVELOPMENT 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. | NY005012090P NY005023770P NY005011670P NY005010080P NY005013510P view top 100 |
| Vendor Name | vendor_name | text | Utility vendor name | NEW YORK CITY WATER BOARD view top 100 |
| UMIS BILL ID | umis_bill_id | number | 9823626 7769080 8029576 7506175 7495245 view top 100 | |
| Revenue Month | revenue_month | text | Year and month of bill: 2016-01 | 2019-06 2020-03 2019-04 2020-01 2019-05 view top 100 |
| Service Start Date | service_start_date | calendar_date | Bill start date | 2019-03-24T00:00:00.000 2019-09-22T00:00:00.000 2019-11-24T00:00:00.000 2019-10-22T00:00:00.000 2019-06-20T00:00:00.000 view top 100 |
| Service End Date | service_end_date | calendar_date | Bill end date | 2019-03-24T00:00:00.000 2019-09-22T00:00:00.000 2019-11-24T00:00:00.000 2019-10-22T00:00:00.000 2019-07-23T00:00:00.000 view top 100 |
| # days | days | number | Number of days on bill | 29 30 32 31 33 view top 100 |
| Meter Number | meter_number | text | Meter number | UN-METERED E09010097 E09010099 E19354370 E20453240 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 | 38.07 36.8 40.61 39.34 41.88 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. | Basic Water and Sewer HOT OR COLD WATER IN STORE COMMERCIAL WATER-METER MULTIFAMILY 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 (HCF) | consumption_hcf | number | Total HCF (Hundred Cubic Feet) consumption | 0 204 1 4 3 view top 100 |
| Water&Sewer Charges | water_sewer_charges | number | Total water & sewer charges | 0 38.07 36.8 40.61 39.34 view top 100 |
| Other Charges | other_charges | number | Total other charges | 0 36.8 38.07 39.34 43.15 view top 100 |