Dataset: HPD Handyman Work Order (HWO) Charges
The hpd_hwo_charges dataset can be added to NYCDB by running:
> nycdb --download hpd_hwo_charges
> nycdb --load hpd_hwo_charges
The dataset comes from the NYC Open Data portal:
Dataset published by HPD and updated as of January 20, 2024. Contains information about work orders created to conduct emergency repair work when an owner fails to address a hazardous condition pursuant to the requirements of an HPD issued violation. HPD issues violations when an owner fails to address a condition pursuant New York City Housing Maintenance Code (HMC) or the New York State Multiple Dwelling Law (MDL), a Department of Buildings Declaration of Emergency, a Department of Health Commissioner's Order to Abate or an emergency violation issued by another City Agency. The work orders were carried out by agency staff.
Click to Expand the hpd_hwo_charges Data Dictionary
| column_name | data_type | description |
|---|---|---|
| HWOID | integer | Handyman Work Order ID |
| HWONumber | text | Handyman Work Order Number |
| BuildingID | integer | Building ID |
| BoroID | integer | Boro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island) |
| Boro | text | Borough |
| HouseNumber | text | House Number |
| StreetName | text | Street Name |
| Zip | char(5) | ZIP Code |
| Block | integer | Block |
| Lot | integer | Lot |
| LifeCycle | text | The stage in the building life cycle |
| WorkTypeGeneral | text | General description of type of work performed by this HWO |
| HWOStatusReason | text | Reason this HWO was closed |
| HWOCreateDate | date | Date HWO was created by system |
| IsAEP | text | Indicates if this HWO was created thru the Alternative Enforcement program |
| IsCommercialDemolition | integer | Indicates if this HWO was for the demolition of commercial property |
| FEMAEventID | numeric | unique identifier of FEMA event |
| FEMAEvent | text | Name of FEMA reimbursable event |
| HWODescription | text | Description of HWO |
| HWOApprovedAmount | numeric | The total cost of the HWO (labor + materials) |
| SalesTax | numeric | Imputed sales tax for this HWO |
| AdminFee | numeric | HPD's current administrative cost charged for this HWO |
| ChargeAmoun | numeric | Total lienable amount to be transferred to DoF |
| DateTransferDoF | date | Date this charge was transferred to DoF to be liened |
| Latitude | numeric | Latitude |
| Longitude | numeric | Longitude |
| CommunityBoard | numeric | CommunityBoard |
| CouncilDistrict | text | CouncilDistrict |
| CensusTract | text | CensusTract |
| BIN | char(7) | BIN |
| BBL | char(10) | Borough Block Lot |
| NTA | text | Neighborhood Tabulation Area |
This dataset has the following tables:
-
hpd_hwo_chargesis the only table in this dataset
TBD
*TBD