From a 500-row sample across 23 columns.
vendor_namemeter_amrborough+19boroughboroughtdsboroughHas 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| STRAUS | MANHATTAN | STRAUS | AMR | 153 | 263 | M015300 | FEDERAL | NY005011530P | CONSOLIDATED EDISON COMPANY OF NY | 15855602 | 2025-09 |
| STRAUS | 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% | WEST SIDE URBAN RENEWAL …THOMAS APARTMENTSSEWARD PARK EXTENSION |
borough | text | Bronx, Brooklyn, Manhattan, Queens, or Staten Island. | 1% | MANHATTANof 1 |
account_name | categorical | The name of the housing development as listed in the Development Data Book. | 0% | WEST SIDE URBAN RENEWAL …CAMPOS PLAZA I/CAMPOS PL…THOMAS APARTMENTSof 16 |
location | categorical | "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" |
GET /api/datasets/smdw-73pj GET /api/datasets/smdw-73pj/quality GET /api/datasets/smdw-73pj/related GET /api/columns?dataset=smdw-73pj
borough| STRAUS |
| AMR |
| 153 |
| 263 |
| M015300 |
| FEDERAL |
| NY005011530P |
| CONSOLIDATED EDISON COMPANY OF NY |
| 15855602 |
| 2025-09 |
| SEWARD PARK EXTENSION | MANHATTAN | SEWARD PARK EXTENSION | AMR | 192 | 312 | M019200 | FEDERAL | NY005011000P | CONSOLIDATED EDISON COMPANY OF NY | 15855606 | 2025-09 |
| SEWARD PARK EXTENSION | MANHATTAN | SEWARD PARK EXTENSION | AMR | 192 | 312 | M019200 | FEDERAL | NY005011000P | CONSOLIDATED EDISON COMPANY OF NY | 15855606 | 2025-09 |
| AMSTERDAM ADDITION | MANHATTAN | AMSTERDAM ADDITION | AMR | 187 | 453 | M018700 | MIXED FINANCE/LLC1 | NY005021870P | CONSOLIDATED EDISON COMPANY OF NY | 15855615 | 2025-09 |
| AMSTERDAM ADDITION | MANHATTAN | AMSTERDAM ADDITION | AMR | 187 | 453 | M018700 | MIXED FINANCE/LLC1 | NY005021870P | CONSOLIDATED EDISON COMPANY OF NY | 15855615 | 2025-09 |
| CAMPOS PLAZA II | MANHATTAN | CAMPOS PLAZA I/CAMPOS PLAZA II | AMR | 286 | 593 | M028600 | FEDERAL | NY005012570P | CONSOLIDATED EDISON COMPANY OF NY | 15855874 | 2025-09 |
| CAMPOS PLAZA II | MANHATTAN | CAMPOS PLAZA I/CAMPOS PLAZA II | AMR | 286 | 593 | M028600 | FEDERAL | NY005012570P | CONSOLIDATED EDISON COMPANY OF NY | 15855874 | 2025-09 |
| CAMPOS PLAZA I | MANHATTAN | CAMPOS PLAZA I/CAMPOS PLAZA II | AMR | 257 | 544 | M025700 | SECTION 8 | NY005012570P | CONSOLIDATED EDISON COMPANY OF NY | 15855874 | 2025-09 |
| CAMPOS PLAZA I | MANHATTAN | CAMPOS PLAZA I/CAMPOS PLAZA II | AMR | 257 | 544 | M025700 | SECTION 8 | NY005012570P | CONSOLIDATED EDISON COMPANY OF NY | 15855874 | 2025-09 |
Showing 12 of 23 columns. All of them are listed below.
| 1% |
BLD 01CAMPOS PLAZA I BLD 02BLD 03of 9 |
meter_amr | categorical | Is the meter Automatic Meter Reading (AMR), Interval or none | 1% | AMRNONEof 2 |
meter_scope | categorical | The buildings or areas the account and meter supply | 90% | CAMPOS PLAZA II ALLCAMPOS PLAZA I ALLof 2 |
tds | categorical | 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% | 178151268of 18 |
edp | categorical | 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% | 259279387of 15 |
rc_code | categorical | "NYCHA budget responsibility code. Code representing a specific development. " | 0% | M017800M026800M019200of 17 |
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/LLC2MIXED FINANCE/LLC1of 6 |
amp | categorical | Abbreviation for Asset Management Project (AMP) numbers. HUD Development asset tracking number. An AMP number can consist of more than one development. | 0% | NY005011270PNY005011000PNY005012570Pof 18 |
vendor_name | categorical | Utility vendor name | 0% | CONSOLIDATED EDISON COMP…NEW YORK CITY WATER BOAR…of 2 |
umis_bill_id | integer | — | 0% | 876041485771208848483 |
revenue_month | text | Year and month of bill: 2016-01 | 0% | 2020-022020-032020-01 |
service_start_date | datetime | Bill start date | 0% | 2019-12-31T00:00:00.0002020-02-28T00:00:00.0002020-03-31T00:00:00.000 |
service_end_date | datetime | Bill end date | 0% | 2020-04-29T00:00:00.0002020-01-31T00:00:00.0002020-03-31T00:00:00.000 |
days | integer | Number of days on bill | 0% | 293032 |
meter_number | text | Meter number | 0% | 321190322052321178 |
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% | 03024.162179.18 |
rate_class | categorical | The rate applied to the account. Details about each rate (dollar value) are available on the vendor web site. | 0% | SC3Steam Cond w/24% Sewer A…SC4of 4 |
bill_analyzed | categorical | The bill was analyzed for billing errors by NYCHA's Utility Management system during the billing period | 0% | YesExceptionof 2 |
consumption_mlbs | float | Total Mlbs consumption | 0% | 00.120.24 |