NYC Open Data, HPD Housing Maintenance Code Violations (dataset wvxf-dwi5), pulled 2026-10-14 read-only.
Query: {"$select": "zip,boro,count(*) as open_pest_violations", "$where": "violationstatus='Open' AND boro in('BRONX','BROOKLYN','MANHATTAN') AND (upper(novdescription) like '%ROACH%' OR upper(novdescription) like '%MICE%' OR upper(novdescription) like '%RATS%' OR upper(novdescription) like '%BED BUG%' OR upper(novdescription) like '%BEDBUG%' OR upper(novdescription) like '%VERMIN%')", "$group": "zip,boro", "$order": "open_pest_violations DESC", "$limit": "500"}
URL: https://data.cityofnewyork.us/resource/wvxf-dwi5.csv?%24select=zip%2Cboro%2Ccount%28%2A%29+as+open_pest_violations&%24where=violationstatus%3D%27Open%27+AND+boro+in%28%27BRONX%27%2C%27BROOKLYN%27%2C%27MANHATTAN%27%29+AND+%28upper%28novdescription%29+like+%27%25ROACH%25%27+OR+upper%28novdescription%29+like+%27%25MICE%25%27+OR+upper%28novdescription%29+like+%27%25RATS%25%27+OR+upper%28novdescription%29+like+%27%25BED+BUG%25%27+OR+upper%28novdescription%29+like+%27%25BEDBUG%25%27+OR+upper%28novdescription%29+like+%27%25VERMIN%25%27%29&%24group=zip%2Cboro&%24order=open_pest_violations+DESC&%24limit=500