From a 500-row sample across 27 columns.
inspection_type:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+12inspection_dateblockbbl+10boroughbininspection_typeinspection_dateMappable — Socrata point column `location`.
Open on the map →| job_id | inspection_date | inspection_type | zip_code | borough | result | boro_code | block | lot | house_number | street_name | latitude |
|---|---|---|---|---|---|---|---|---|---|---|---|
| PC8178739 | 2023-09-21T10:54:00.000 | Stoppage | 11216 | Brooklyn | Stoppage done | 3 | 1793 | 94 | — | — | — |
| PC8129591 | 2023-06-25T15:20:41.000 |
The machine field names SoQL needs, with the publisher's own description of each. Profiling runs nightly; null rates and sample values appear once it has.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
job_id | text | Internal DOHMH administrative number to identify a job, Case ID | — | — |
inspection_date | datetime | Date of the inspection. | — | — |
inspection_type | text | Includes the types of inspections and health department actions: Initial Inspection - Inspection conducted in response to a 311 complaint, or a proactive inspection conducted through our neighborhood indexing program. Compliance Inspection - If a property fails its initial inspection, the Health Department will conduct a follow up (Compliance) inspection. Baiting - Application of rodenticide, or monitoring visit by a Health Department Pest Control Professional. Clean Up - The removal of garbage | — | — |
house_number | text | The address number of a building on the tax lot that was inspected. | — | — |
street_name | text | The street name portion of the address of the tax lot that was inspected. |
GET /api/datasets/p937-wjvj GET /api/datasets/p937-wjvj/quality GET /api/datasets/p937-wjvj/related GET /api/columns?dataset=p937-wjvj
bblbblcommunity_boardborough+6bblcommunity_boardborough+5bblboroughlongitude+3bblcommunity_boardlongitude+5| Treatments |
| 11237 |
| Brooklyn |
| Bait applied |
| 3 |
| 3392 |
| 51 |
| — |
| — |
| — |
| PC8566721 | 2025-07-02T09:19:28.000 | Initial | 11206 | Brooklyn | Passed | 3 | 1754 | 27 | MYRTLE | AVENUE | — |
| PC7687990 | 2021-03-26T11:10:01.000 | Initial | 11206 | Brooklyn | Passed | 3 | 1759 | 13 | — | — | — |
| PC8647961 | 2026-01-08T11:26:00.000 | Initial | 10451 | Bronx | Passed | 2 | 2421 | 135 | TELLER | AVENUE | — |
| PC8670759 | 2026-02-27T08:13:28.000 | Initial | 10458 | Bronx | Passed | 2 | 3091 | 71 | — | nul | — |
| PC8226842 | 2024-04-22T11:50:51.000 | Treatments | 11232 | Brooklyn | Bait applied | 3 | 660 | 34 | — | — | — |
| PC8293457 | 2024-03-29T08:59:21.000 | Initial | — | Brooklyn | Passed | 3 | 1299 | 47 | 398B | KINGSTON AVENUE | 0.00000000000000000000 |
| PC7614429 | 2020-07-06T08:05:51.000 | Initial | 10009 | Manhattan | Passed | 1 | 379 | 1 | AVENUE | C | — |
| PC8725623 | 2026-06-04T11:09:00.000 | Initial | 10451 | Bronx | Passed | 2 | 2539 | 175 | MAJ | WM DEEGAN BLVD | — |
Showing 12 of 14 columns. All of them are listed below.
| — |
| — |
zip_code | text | The postal zipcode of the tax lot that was inspected. | — | — |
borough | text | The name of the NYC borough. | — | — |
result | text | Result of the inspection, including: Active Rat Signs (ARS) - ARS include any of six different signs: 1) fresh tracks, 2) fresh droppings, 3) active burrows, 4) active runways and rub marks, 5) fresh gnawing marks, and 6) live rats. Problem Conditions - Problem conditions include garbage (poor containerization of food waste resulting in the feeding of rats), harborage (clutter and dense vegetation promoting the nesting of rats), and mice. | — | — |
letter_type | text | Records any violation notices or orders to address rat conditions that were issued following an inspection. | — | — |
observations | text | All inspector observations of rat activity or conditions that attract rats, from the inspection. | — | — |
bbl | numeric | Borough, Block, and Lot code, which is a unique identifier of NYC Taxlots. Every NYC property has its own BBL code, and inspections are conducted at the taxlot level. This dataset can be mapped by joining these inspectional results to a taxlot geography file such as the Department of City Planning’s PLUTO dataset. | — | — |
boro_code | numeric | The code assigned to the NYC borough, this code can also be found as the first digit in the BBL tax lot code above. | — | — |
block | text | The block number for the inspected tax lot; block numbers repeat in different boroughs. | — | — |
lot | text | The lot number for the inspected tax lot; lot numbers can repeat in different blocks. | — | — |
x_coord | numeric | X coordinate of the inspected tax lot in NY State Plane Long Island Coordinate system. | — | — |
y_coord | numeric | Y coordinate of the inspected tax lot in NY State Plane Long Island Coordinate system. | — | — |
latitude | numeric | Latitude in decimal degrees of the inspected tax lot (WGS 1984). | — | — |
longitude | numeric | Longitude in decimal degrees of the inspected tax lot (WGS 1984). | — | — |
location | coordinate | Coordinates (latitude, longitude) of the inspected tax lot (WGS 1984). | — | — |
community_board | text | Community Board of the location. | — | — |
council_district | text | Council District of the location. | — | — |
census_tract | text | Census Tract of the location. | — | — |
bin | text | Department of Buildings (DOB) Building Identification Number. | — | — |
nta | text | NTA (Neighborhood Tabulation Area) code of the location. | — | — |