building_complaints
Retrieve HPD building complaints and problems by house number, street, and borough. Get open/closed counts and recent details including category, status, and dates.
Instructions
HPD complaints and problems for one building (dataset ygpa-z7cr; one row per reported problem within a complaint). Give the house number, street, and borough. Returns an open/closed count summary plus the most recent matching problems (category, status, dates). Street is matched as an uppercase substring; house number exactly. Keyless.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max detail rows to return (1-500, default 100). The status summary counts all matches. | |
| since | No | Only problems received on/after this ISO date (YYYY-MM-DD). | |
| street | Yes | Street name (matched case-insensitively as a substring). | |
| borough | Yes | NYC borough: Manhattan, Bronx, Brooklyn, Queens, or Staten Island (also accepts MN/BX/BK/QN/SI or 1-5). | |
| open_only | No | Only complaints still open (default false). | |
| house_number | Yes | Building house number, e.g. "1520". |