From a 500-row sample across 24 columns.
locationes_commodityaccount_name+22locationaccount_namemeter_amr+19locationaccount_namemeter_amr+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ALBANY II | BROOKLYN | ALBANY/ALBANY II | ALBANY II BLD 09 | AMR | 85 | 524 | K008500 | FEDERAL | NY005010310P | National Grid NYC | 8566316 |
| ALBANY II | BROOKLYN |
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% | MARLBOROSAMUEL (CITY)BUSHWICK II (GROUPS A & … |
borough | categorical | Borough | 0% | BROOKLYNBRONXMANHATTANof 6 |
account_name | text | Account Name | 0% | MARLBORORIIS/RIIS II/WALD/BARUCHSAMUEL (CITY) |
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 | 10% |
GET /api/datasets/avhb-5jhc GET /api/datasets/avhb-5jhc/quality GET /api/datasets/avhb-5jhc/related GET /api/columns?dataset=avhb-5jhc
locationaccount_namemeter_amr+19locationaccount_namemeter_amr+19boroughtdsboroughborough| ALBANY/ALBANY II |
| ALBANY II BLD 09 |
| AMR |
| 85 |
| 524 |
| K008500 |
| FEDERAL |
| NY005010310P |
| National Grid NYC |
| 8566316 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY II BLD 07 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | National Grid NYC | 8664879 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 03 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | National Grid NYC | 8664879 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 04 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | National Grid NYC | 8664879 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 04 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | National Grid NYC | 8664879 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 05 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | National Grid NYC | 8664879 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 05 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | National Grid NYC | 8664879 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 02 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | National Grid NYC | 8664879 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 02 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | National Grid NYC | 8664879 |
Showing 12 of 24 columns. All of them are listed below.
BLD 01BLD 02BLD 03meter_amr | categorical | Is the meter Automatic Meter Reading (AMR), Interval or none | 0% | NONEAMRNot Applicableof 5 |
meter_scope | categorical | The buildings or areas the account and meter supply | 99% | BLD 01Community CenterBLD 02of 17 |
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. | 0% | 83377302 |
edp | text | 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% | 426650565 |
rc_code | text | NYCHA budget responsibility code. Code representing a specific development. | 0% | K008300M037700K030200 |
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/LLC1MIXED FINANCE/LLC2of 7 |
amp | text | Abreviation for Asset Management Project (AMP) numbers. HUD Development asset tracking number. An AMP number can consist of more than one development. | 0% | NY005012470PNY005013510PNY005020830P |
vendor_name | categorical | Utility vendor name | 0% | CONSOLIDATED EDISON COMP…National Grid NYCDIRECT ENERGY BUSINESS (…of 11 |
umis_bill_id | text | — | 0% | 865941087773718550257 |
revenue_month | datetime | Year and month of bill: 2016-01 | 0% | 2020-062010-06-01T00:00:00.0002014-06-01T00:00:00.000 |
service_start_date | datetime | Bill start date | 0% | 2020-02-25T00:00:00.0002010-06-30T00:00:00.0002020-06-30T00:00:00.000 |
service_end_date | datetime | Bill end date | 0% | 2020-02-25T00:00:00.0002020-03-26T00:00:00.0002011-05-24T00:00:00.000 |
days | integer | Number of days on bill | 0% | 293032 |
meter_number | integer | Meter number | 1% | 395000000000000495000000000000295000000000000 |
estimated | categorical | Yes means that meter was not read for the time period. The consumption and cost are estimated. No means that the meter was read or the data was updated with actual reads once the meter was read. | 0% | NYNAof 3 |
current_charges | float | Total costs of the bill. | 0% | 00.760.43 |
rate_class | text | The rate applied to the account. Details about each rate (dollar value) are available on the vendor web site. | 0% | T1A TRAN RES N-HtTrans Gen Non-ResNA |
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 | float | Total therm consumption | 0% | 01.031.04 |
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 GASof 2 |
underlying_utility | categorical | Is the utility National Grid or Con edison | 0% | ConEdNatGrid NYCNatGrid LIof 4 |