From a 500-row sample across 27 columns.
boroughboroughboroughboroughHas 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 | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 01 | AMR | 31 | 524 | K003100 | FEDERAL | NY005010310P | NEW YORK POWER AUTHORITY | 15921441 |
| ALBANY | 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% | EDENWALDWILLIAMSBURGRAVENSWOOD |
borough | categorical | Borough | 0% | BROOKLYNMANHATTANBRONXof 7 |
account_name | text | — | 0% | EDENWALDWILLIAMSBURGRAVENSWOOD |
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. | 3% | BLD 01BLD 02 |
GET /api/datasets/jr24-e7cr GET /api/datasets/jr24-e7cr/quality GET /api/datasets/jr24-e7cr/related GET /api/columns?dataset=jr24-e7cr
tds| ALBANY/ALBANY II |
| ALBANY BLD 03 |
| NONE |
| 31 |
| 524 |
| K003100 |
| FEDERAL |
| NY005010310P |
| NEW YORK POWER AUTHORITY |
| 15921441 |
| ADAMS | BRONX | ADAMS | BLD 06 | NONE | 118 | 248 | B011800 | FEDERAL | NY005001180P | NEW YORK POWER AUTHORITY | 15922117 |
| ADAMS | BRONX | ADAMS | BLD 02 | NONE | 118 | 248 | B011800 | FEDERAL | NY005001180P | NEW YORK POWER AUTHORITY | 15921381 |
| ADAMS | BRONX | ADAMS | BLD 03 | NONE | 118 | 248 | B011800 | FEDERAL | NY005001180P | NEW YORK POWER AUTHORITY | 15921065 |
| ADAMS | BRONX | ADAMS | BLD 04 | NONE | 118 | 248 | B011800 | FEDERAL | NY005001180P | NEW YORK POWER AUTHORITY | 15921297 |
| ADAMS | BRONX | ADAMS | BLD 01 | NONE | 118 | 248 | B011800 | FEDERAL | NY005001180P | NEW YORK POWER AUTHORITY | 15921749 |
| ADAMS | BRONX | ADAMS | BLD 07 | NONE | 118 | 248 | B011800 | FEDERAL | NY005001180P | NEW YORK POWER AUTHORITY | 15921782 |
| ADAMS | BRONX | ADAMS | BLD 05 | NONE | 118 | 248 | B011800 | FEDERAL | NY005001180P | NEW YORK POWER AUTHORITY | 15921196 |
| ALBANY | BROOKLYN | ALBANY/ALBANY II | ALBANY BLD 04 | NONE | 31 | 524 | K003100 | FEDERAL | NY005010310P | NEW YORK POWER AUTHORITY | 15921441 |
Showing 12 of 27 columns. All of them are listed below.
BLD 03meter_amr | categorical | Is the meter Automatic Meter Reading (AMR), Interval or none. | 0% | AMRINTERVALNONEof 9 |
meter_scope | text | The buildings or areas the account and meter supply | 95% | Community CenterBLD 01BLD 02 |
tds | integer | 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% | 57248 |
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% | 214200369 |
rc_code | text | NYCHA budget responsibility code. Code representing a specific development. | 0% | B005700Q004800K000200 |
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 10 |
amp | text | Abbreviation for Asset Management Project (AMP) numbers. HUD Development asset tracking number. An AMP number can consist of more than one development. | 0% | #REF!NY005012470PNY005000570P |
vendor_name | categorical | Utility vendor name. | 0% | NEW YORK POWER AUTHORITYPSEG Long IslandCONSOLIDATED EDISON COMP…of 5 |
umis_bill_id | integer | — | 0% | 879789887096538888737 |
revenue_month | text | Year and month of bill: 2016-01. | 0% | 2020-042020-022020-03 |
service_start_date | datetime | Bill start date | 0% | 2020-03-25T00:00:00.0002020-02-25T00:00:00.0002019-12-24T00:00:00.000 |
service_end_date | datetime | Bill end date | 0% | 2020-03-25T00:00:00.0002020-04-23T00:00:00.0002020-02-25T00:00:00.000 |
days | integer | Number of days on bill | 0% | 293032 |
meter_number | text | Meter Number | 0% | 769404077191337424138 |
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% | 03.913.59 |
rate_class | text | The rate applied to the account. Details about each rate (dollar value) are available on the vendor web site. | 0% | GOV/NYC/068GOV/NYC/068 TODGOV/NYC/062 |
bill_analyzed | categorical | The bill was analyzed for billing errors by NYCHA's Utility Management system during the billing period. | 0% | YesExceptionInvestigatingof 3 |
consumption_kwh | integer | Total KWH consumption | 0% | 03360060000 |
kwh_charges | float | Total KWH charges | 0% | 03579.262037.43 |
consumption_kw | float | Total KW consumption | 0% | 012072 |
kw_charges | float | Total KW charges | 0% | 01872936 |
other_charges | float | Total other charges | 0% | 03.913.59 |