From a 500-row sample across 21 columns.
boroughrevenue_monthestimated+17boroughrevenue_monthestimated+17boroughrevenue_monthestimated+17Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| development_name | borough | account_name | meter_amr | tds | edp | rc_code | funding_source | amp | vendor_name | umis_bill_id | revenue_month |
|---|---|---|---|---|---|---|---|---|---|---|---|
| AMSTERDAM | MANHATTAN | AMSTERDAM | Not Applicable | 22 | 530 | M002200 | FEDERAL | NY005010220P | East River Energy | 9678345 | 2020-02 |
| AMSTERDAM | MANHATTAN |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
development_name | text | The name of the housing development as listed in the Development Data Book. | 0% | TAFTLINCOLNPELHAM PARKWAY |
borough | categorical | — | 0% | BROOKLYNMANHATTANBRONXof 7 |
account_name | text | The name of the housing development as listed in the Development Data Book. | 0% | TAFTLINCOLNPELHAM PARKWAY |
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" | 83% |
GET /api/datasets/bhwu-wuzu GET /api/datasets/bhwu-wuzu/quality GET /api/datasets/bhwu-wuzu/related GET /api/columns?dataset=bhwu-wuzu
boroughrevenue_monthestimated+17boroughrevenue_monthestimated+17boroughboroughtdsborough| AMSTERDAM |
| Not Applicable |
| 22 |
| 530 |
| M002200 |
| FEDERAL |
| NY005010220P |
| East River Energy |
| 9678380 |
| 2020-05 |
| ARMSTRONG I | BROOKLYN | ARMSTRONG I | Not Applicable | 210 | 325 | K021000 | FEDERAL | NY005012100P | East Coast Petroleum, Inc. | 9678333 | 2020-01 |
| ARMSTRONG I | BROOKLYN | ARMSTRONG I | Not Applicable | 210 | 325 | K021000 | FEDERAL | NY005012100P | East Coast Petroleum, Inc. | 8522510 | 2020-01 |
| ASTORIA | QUEENS | ASTORIA | Not Applicable | 26 | 517 | Q002600 | FEDERAL | NY005000260P | East Coast Petroleum, Inc. | 8572961 | 2020-01 |
| ASTORIA | QUEENS | ASTORIA | Not Applicable | 26 | 517 | Q002600 | FEDERAL | NY005000260P | East Coast Petroleum, Inc. | 8619962 | 2020-02 |
| ASTORIA | QUEENS | ASTORIA | Not Applicable | 26 | 517 | Q002600 | FEDERAL | NY005000260P | East Coast Petroleum, Inc. | 8640424 | 2020-02 |
| ASTORIA | QUEENS | ASTORIA | Not Applicable | 26 | 517 | Q002600 | FEDERAL | NY005000260P | East Coast Petroleum, Inc. | 8640426 | 2020-02 |
| ASTORIA | QUEENS | ASTORIA | Not Applicable | 26 | 517 | Q002600 | FEDERAL | NY005000260P | East Coast Petroleum, Inc. | 8720253 | 2020-03 |
| ASTORIA | QUEENS | ASTORIA | Not Applicable | 26 | 517 | Q002600 | FEDERAL | NY005000260P | East Coast Petroleum, Inc. | 8720257 | 2020-03 |
Showing 12 of 20 columns. All of them are listed below.
2130 Madison AveBLD 01953 Dekalb Avenuemeter_amr | categorical | Is the meter Automatic Meter Reading (AMR), Interval or none | 16% | Not ApplicableOIL-DELIVERYNONEof 6 |
meter_scope | categorical | The buildings or areas the account and meter supply | 100% | Community CenterBLD 01BLD 1-6of 3 |
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% | 51326167 |
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% | 0261513 |
rc_code | text | "NYCHA budget responsibility code. Code representing a specific development. " | 0% | M009700M002000B003900 |
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." | 8% | FEDERALMIXED FINANCE/LLC1MIXED FINANCE/LLC2of 7 |
amp | text | Abbreviation for Asset Management Project (AMP) numbers. HUD Development asset tracking number. An AMP number can consist of more than one development. | 12% | NY005010970PNY005000200PNY005010390P |
vendor_name | categorical | Utility vendor name | 0% | S.J. Fuel Co., Inc.East Coast Petroleum, In…East River Energyof 9 |
umis_bill_id | integer | — | 0% | 424314942448794244874 |
revenue_month | text | Year and month of bill: 2016-01 | 0% | 2020-032020-012020-02 |
service_start_date | datetime | Bill start date | 0% | 2016-08-23T00:00:00.0002016-10-24T00:00:00.0002016-09-22T00:00:00.000 |
service_end_date | datetime | Bill end date | 0% | 2016-09-22T00:00:00.0002016-11-22T00:00:00.0002016-10-24T00:00:00.000 |
days | integer | Number of days on bill | 0% | 12930 |
meter_number | text | Meter number | 0% | 794717946220676C-136 |
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% | NYof 2 |
current_charges | float | Total costs, calculated from oil delivery charges | 0% | 010811.7811236.92 |
consumption_gal | float | Total Number 2 oil gallons consumption | 0% | 01160010000 |