Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Certification of No Harassment (CONH) Pilot Building List

bzxi-2tswHousing & Development22 columns
List of buildings subject to Certification of No Harassment (CONH) Pilot Program. Data is current as of the update date shown below. To see the latest status of a building, visit HPD Online at https://www1.nyc.gov/site/hpd/about/hpdonline.page.
View on NYC Open Data↗

Quality

A93.1 / 100

From a 500-row sample across 22 columns.

completeness100/ 25% weight
consistency70/ 20% weight
accuracy96/ 20% weight
timeliness99/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Buildings Selected for the Alternative Enforcement Program (AEP)0.43
    joins onstreet_addresslatitudecommunity_board+6
  • DOB Safety Violations0.40
    joins onlatitudeboroughcommunity_board+6
  • DOB NOW: Certificate of Occupancy0.39
    joins onlatitudeboroughcommunity_board+5
  • Order to Repair/Vacate Orders0.39
    joins onlatitudecommunity_boardbbl+5

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

building_idbinstreet_addressborocodeblocklotbqiaep_orderdischarged_7ahpd_vacate_orderdob_vacate_orderharassment_finding
5610453141134 1 AVENUE114573NoYesNoNoNoNo
2481005896158 1 AVENUE

Columns

22 queryable · 22 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
building_idintegerUnique identifier of building (HPD)0%4846194413726885
binintegerUnique identifier of building (DOB)0%303950710631033118229
street_addresstextStreet name; part of building address0%50 MANHATTAN AVENUE199 HOWARD AVENUE495 WEST 186 STREET
borocodecategoricalBorough where the building is located0%321of 5

Query this from your own app

GET /api/datasets/bzxi-2tsw
GET /api/datasets/bzxi-2tsw/quality
GET /api/datasets/bzxi-2tsw/related
GET /api/columns?dataset=bzxi-2tsw
  • Housing Litigations0.37
    joins onlatitudelotbbl+5
  • Housing Maintenance Code Complaints and Problems0.37
    joins onlatitudeboroughcommunity_board+8
  • Open Market Order (OMO) Charges0.37
    joins onlatitudecommunity_boardlot+6
  • Bedbug Reporting0.36
    joins onlatitudeboroughcommunity_board+4
    • 1
    437
    6
    No
    Yes
    No
    No
    No
    No
    2721005898162 1 AVENUE14378YesYesNoNoNoNo
    85110439931403 2 AVENUE1142821YesNoNoNoNoNo
    110210503411854 2 AVENUE1155849NoNoNoNoYesNo
    15211020357707 2 AVENUE191927NoNoNoNoNoYes
    22591018481478 3 AVENUE188841NoYesNoNoNoNo
    337610549741845 ADAM C POWELL BOULEVARD118227502YesYesNoNoNoNo
    339310550571917 ADAM C POWELL BOULEVARD1182563YesNoNoNoNoNo
    341110584271974 ADAM C POWELL BOULEVARD1192436NoYesNoNoNoNo

    Showing 12 of 22 columns. All of them are listed below.

    block
    integer
    Tax block
    0%
    213619886715
    lotintegerTax lot0%1621
    bqicategoricalBuilding Qualification Index; building meets threshold of calculated BQI0%YesNoof 2
    aep_ordercategoricalBuilding was discharged from the HPD Alternative Enforcement Program (AEP)0%NoYesof 2
    discharged_7acategoricalBuilding was discharged from the HPD 7A program0%NoYesof 2
    hpd_vacate_ordercategoricalBuilding was issued HPD Order to Vacate0%NoYesof 2
    dob_vacate_ordercategoricalBuilding was issued Department of Buildings (DOB) Order to Vacate0%NoYesof 2
    harassment_findingcategoricalBuilding was the subject of a finding of harassment by a court or by New York State Homes and Community Renewal0%NoYesof 2
    date_addeddatetimeDate added to CONH Pilot Program List0%2022-06-24T00:00:00.0002024-04-02T00:00:00.0002024-07-05T00:00:00.000
    boroughcategoricalBorough where the building is located0%BROOKLYNBRONXMANHATTANof 5
    zipcodeintegerZipcode where the building is located0%112261123710458
    latitudefloatEstimated location based on the street segment and address range.0%40.86293140.67067940.867358
    longitudefloatEstimated location based on the street segment and address range.0%-73.921727-73.924462-73.953438
    community_boardtextNew York City Community District where building is located0%112317304
    council_districtintegerNew York City Council District where building is located0%151040
    bblintegerBorough, block, lot - the unique identifier for each tax lot in NYC0%406715000210224800923066650025
    census_tractintegerThe 2020 US Census Tract where building is located0%283269225
    nta_neighborhood_tabulationtextNew York City Neighborhood Tabulation Area where the building is located0%BK1401MN1201BK0401