From a 500-row sample across 25 columns.
edpdevelopment_nameaccount_name+20edpdevelopment_nameaccount_name+19edpdevelopment_nameaccount_name+19Has 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CLAREMONT REHAB (GROUP 4) | BRONX | CLAREMONT REHAB (GROUP 4) | BLD 03 | AMR | 335 | 751 | B033500 | FEDERAL | NY005013080P | NEW YORK CITY WATER BOARD | 15343610 |
| CONLON LIHFE TOWER |
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% | FHA REPOSSESSED HOUSES (…SAMUEL (CITY)FHA REPOSSESSED HOUSES (… |
borough | categorical | Bronx, Brooklyn, Manhattan, Queens, or Staten Island. | 0% | FHABROOKLYNMANHATTANof 7 |
account_name | text | The name of the housing development as listed in the Development Data Boo | 0% | FHA REPOSSESSED HOUSES (…SAMUEL (CITY)FHA REPOSSESSED HOUSES (… |
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" |
GET /api/datasets/66be-66yr GET /api/datasets/66be-66yr/quality GET /api/datasets/66be-66yr/related GET /api/columns?dataset=66be-66yr
edpdevelopment_nameaccount_name+19edpdevelopment_nameaccount_name+17boroughboroughborough| QUEENS |
| CONLON LIHFE TOWER |
| BLD 01 |
| AMR |
| 232 |
| 347 |
| Q023200 |
| FEDERAL |
| NY005010910P |
| NEW YORK CITY WATER BOARD |
| 15346521 |
| CLAREMONT REHAB (GROUP 2) | BRONX | CLAREMONT REHAB (GROUP 2) | BLD 06 | NONE | 307 | 330 | B030700 | FEDERAL | NY005013080P | NEW YORK CITY WATER BOARD | 15344825 |
| CLAREMONT REHAB (GROUP 2) | BRONX | CLAREMONT REHAB (GROUP 2) | BLD 06 | NONE | 307 | 330 | B030700 | FEDERAL | NY005013080P | NEW YORK CITY WATER BOARD | 15344825 |
| BAISLEY PARK | QUEENS | BAISLEY PARK | BLD 09 | AMR | 91 | 240 | Q009100 | FEDERAL | NY005010910P | NEW YORK CITY WATER BOARD | 15345353 |
| CLAREMONT REHAB (GROUP 4) | BRONX | CLAREMONT REHAB (GROUP 4) | BLD 03 | AMR | 335 | 751 | B033500 | FEDERAL | NY005013080P | NEW YORK CITY WATER BOARD | 15343610 |
| BAISLEY PARK | QUEENS | BAISLEY PARK | BLD 09 | AMR | 91 | 240 | Q009100 | FEDERAL | NY005010910P | NEW YORK CITY WATER BOARD | 15345353 |
| CLAREMONT REHAB (GROUP 2) | BRONX | CLAREMONT REHAB (GROUP 2) | BLD 06 | NONE | 307 | 330 | B030700 | FEDERAL | NY005013080P | NEW YORK CITY WATER BOARD | 15344825 |
| CLAREMONT REHAB (GROUP 2) | BRONX | CLAREMONT REHAB (GROUP 2) | BLD 06 | NONE | 307 | 330 | B030700 | FEDERAL | NY005013080P | NEW YORK CITY WATER BOARD | 15344825 |
| CONLON LIHFE TOWER | QUEENS | CONLON LIHFE TOWER | BLD 01 | AMR | 232 | 347 | Q023200 | FEDERAL | NY005010910P | NEW YORK CITY WATER BOARD | 15346521 |
Showing 12 of 25 columns. All of them are listed below.
| 6% |
BLD 01BLD 03BLD 02 |
meter_amr | categorical | Is the meter Automatic Meter Reading (AMR), Interval or none | 2% | AMRNONENot Applicableof 3 |
meter_scope | text | The buildings or areas the account and meter supply | 73% | Community CenterSTORE 01-02BLD 01 |
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% | 260377209 |
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% | 397650324 |
rc_code | text | "NYCHA budget responsibility code. Code representing a specific development. " | 0% | Q026000M037700Q020900 |
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/LLC1MHOPof 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. | 0% | NY005012090PNY005023770PNY005011670P |
vendor_name | text | Utility vendor name | 0% | NEW YORK CITY WATER BOAR…of 1 |
umis_bill_id | integer | — | 0% | 140627291367972615109969 |
revenue_month | text | Year and month of bill: 2016-01 | 0% | 2024-062021-062022-06 |
service_start_date | datetime | Bill start date | 0% | 2020-07-01T00:00:00.0002021-07-01T00:00:00.0002022-07-01T00:00:00.000 |
service_end_date | datetime | Bill end date | 0% | 2021-06-30T00:00:00.0002022-06-30T00:00:00.0002023-06-30T00:00:00.000 |
days | integer | Number of days on bill | 0% | 293032 |
meter_number | text | Meter number | 5% | UN-METEREDE09010097E09010099 |
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) | 5% | NYNAof 3 |
current_charges | float | Total costs | 0% | 36.838.0740.61 |
rate_class | categorical | The rate applied to the account. Details about each rate (dollar value) are available on the vendor web site. | 0% | Basic Water and SewerMWW SWRMWW W CFof 18 |
bill_analyzed | categorical | The bill was analyzed for billing errors by NYCHA's Utility Management system during the billing period | 0% | YesExceptionof 2 |
consumption_hcf | integer | Total HCF (Hundred Cubic Feet) consumption | 1% | 014 |
water_sewer_charges | float | Total water & sewer charges | 5% | 036.838.07 |
other_charges | float | Total other charges | 1% | 036.838.07 |