From a 500-row sample across 5 columns.
borough_nameinspection_categoryinspection_date+1inspection_dateHas borough codes (`borough_name`) — joinable, but needs boundary shapes to draw.
| school_code | borough_name | inspection_category | inspection_date | request_status_description |
|---|---|---|---|---|
| PS149Q | QUEENS | WINDOW | 2026-08-20T10:00:00.000 | SCHEDULED |
| JS047M | MANHATTAN | ROOFING | 2026-08-06T15:00:00.000 | COMPLETED |
| PS261K | BROOKLYN | PLUMBING | 2026-08-26T16:00:00.000 | COMPLETED |
| OS000K | BROOKLYN |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
school_code | text | — | 0% | OS000QOS000KJS216Q |
borough_name | categorical | — | 0% | BROOKLYNQUEENSBRONXof 5 |
dob | text | — | 100% | — |
inspection_category | categorical | — | 0% | PLUMBINGROOFINGMASONRYof 16 |
inspection_date | datetime | — | 0% |
GET /api/datasets/n4tc-j6kh GET /api/datasets/n4tc-j6kh/quality GET /api/datasets/n4tc-j6kh/related GET /api/columns?dataset=n4tc-j6kh
| HVAC |
| 2026-08-18T16:00:00.000 |
| COMPLETED |
| PS012K | BROOKLYN | MASONRY | 2026-08-04T17:30:00.000 | COMPLETED |
| IS074Q | QUEENS | MASONRY | 2026-08-18T13:00:00.000 | COMPLETED |
| OS000Q | QUEENS | ROOFING | 2026-08-06T13:00:00.000 | COMPLETED |
| HS492Q | QUEENS | PLUMBING | 2026-08-05T13:00:00.000 | COMPLETED |
| OS000K | BROOKLYN | MASONRY | 2026-08-05T13:00:00.000 | COMPLETED |
| PS754X | BRONX | ARCHITECTURAL | 2026-08-24T14:00:00.000 | CANCELLED |
2026-08-21T10:00:00.0002026-08-13T10:00:00.0002026-08-10T10:00:00.000 |
date_requested | datetime | — | 100% | — |
request_status_description | categorical | — | 0% | COMPLETEDCANCELLEDSCHEDULEDof 7 |