From a 500-row sample across 25 columns.
es_commodityestimatededp+22estimatededpservice_start_date+19estimatededpservice_start_date+17Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| development_name | borough | account_name | location | meter_amr | tds | edp | rc_code | funding_source | amp | vendor_name | umis_bill_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ALLEN STREET | MANHATTAN | ALLEN STREET | BLD 01 | NONE | 265 | 380 | M026500 | FEDERAL | NY005011000P | CONSOLIDATED EDISON COMPANY OF NY | 15801359 |
| ALLEN STREET | MANHATTAN |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
development_name | text | Development Name | 0% | SAMUEL (CITY)BUSHWICK II (GROUPS A & …BUSHWICK II (GROUPS B & … |
borough | categorical | Borough | 0% | BROOKLYNMANHATTANBRONXof 7 |
account_name | text | name of all the development an account supplies | 0% | SAMUEL (CITY)BUSHWICK II (GROUPS A & …BUSHWICK II (GROUPS B & … |
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. | 2% |
GET /api/datasets/it56-eyq4 GET /api/datasets/it56-eyq4/quality GET /api/datasets/it56-eyq4/related GET /api/columns?dataset=it56-eyq4
estimatededpservice_start_date+19estimatededpservice_start_date+19boroughtdsboroughborough| ALLEN STREET |
| BLD 01 |
| NONE |
| 265 |
| 380 |
| M026500 |
| FEDERAL |
| NY005011000P |
| CONSOLIDATED EDISON COMPANY OF NY |
| 15821441 |
| ALBANY II | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 04 | Not Applicable | 85 | 524 | K008500 | FEDERAL | NY005010310P | NRG Business Marketing (32179) | 15978438 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 04 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | National Grid NYC | 15890363 |
| ALLEN STREET | MANHATTAN | ALLEN STREET | BLD 01 | Not Applicable | 265 | 380 | M026500 | FEDERAL | NY005011000P | NRG Business Marketing (32179) | 15977615 |
| ADAMS | BRONX | ADAMS | BLD 04 | Not Applicable | 118 | 248 | B011800 | FEDERAL | NY005001180P | NRG Business Marketing (32179) | 15977917 |
| ALBANY II | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 04 | AMR | 85 | 524 | K008500 | FEDERAL | NY005010310P | National Grid NYC | 15890363 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 04 | Not Applicable | 31 | 524 | K003100 | FEDERAL | NY005010310P | NRG Business Marketing (32179) | 15978438 |
| ADAMS | BRONX | ADAMS | BLD 04 | NONE | 118 | 248 | B011800 | FEDERAL | NY005001180P | CONSOLIDATED EDISON COMPANY OF NY | 15806851 |
| ALLEN STREET | MANHATTAN | ALLEN STREET | BLD 01 | Not Applicable | 265 | 380 | M026500 | FEDERAL | NY005011000P | NRG Business Marketing (32179) | 15977789 |
Showing 12 of 25 columns. All of them are listed below.
BLD 01BLD 02BLD 04 |
meter_amr | categorical | Is the meter Automatic Meter Reading (AMR), Interval or none | 1% | Not ApplicableNONEAMRof 4 |
meter_scope | text | The buildings or areas the account and meter supply | 80% | Community CenterBLD 1-3BLD 1 |
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. | 1% | 377303302 |
edp | integer | 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. | 0% | 650566565 |
rc_code | text | NYCHA budget responsibility code. Code representing a specific development. | 0% | M037700K030200K030300 |
funding_source | categorical | 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. | 0% | FEDERALMIXED FINANCE/LLC1NON-DEVELOPMENTof 8 |
amp | text | Abbreviation for Asset Management Project (AMP) numbers. HUD Development asset tracking number. An AMP number can consist of more than one development. | 1% | NY005012470PNY005011670PNY005023770P |
vendor_name | categorical | Utility vendor name | 0% | CONSOLIDATED EDISON COMP…National Grid NYCDIRECT ENERGY BUSINESS (…of 11 |
umis_bill_id | integer | is utility management information system unique bill ID number. | 0% | 249570625698648925838 |
revenue_month | text | Year and month of bill: 2016-01 | 0% | 2012-092012-102012-08 |
service_start_date | datetime | Bill start date | 0% | 2020-02-25T00:00:00.0002012-03-26T00:00:00.0002011-12-23T00:00:00.000 |
service_end_date | datetime | Bill end date | 0% | 2012-03-26T00:00:00.0002012-01-25T00:00:00.0002020-02-25T00:00:00.000 |
days | integer | Number of days on bill | 0% | 293028 |
meter_number | text | Meter Number | 0% | 4.95E+143.95E+142.95E+14 |
estimated | categorical | 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) | 0% | NYNAof 3 |
current_charges | float | Total costs | 0% | 022.7321.94 |
rate_class | text | The rate applied to the account. Details about each rate (dollar value) are available on the vendor web site. | 0% | NAT3 TRAN MULT FAMTrans Res MultiDwell Hea… |
bill_analyzed | categorical | The bill was analyzed for billing errors by NYCHA's Utility Management system during the billing period. | 0% | YesExceptionInvestigatingof 3 |
consumption_therms | integer | Total therm consumption | 0% | 0110 |
es_commodity | categorical | NYCHA procures brokered gas from the Energy market and is still billed by the utility. Each month an account will have brokered gas bill and a utility gas bill. Consumption is listed on both bills, only use utility consumption values when analyzing the data. | 0% | UTILITY GASBROKERED GASELECTRICof 3 |
underlying_utility | categorical | Is the utility National Grid or Con edison | 1% | ConEdNatGrid NYCNatGrid LIof 6 |