From a 500-row sample across 7 columns.
Has borough codes (`borough_name`) — joinable, but needs boundary shapes to draw.
| inspection_stage_description | school_code | borough_name | inspection_category | observation_description | inspection_date |
|---|---|---|---|---|---|
| Initial | HS520M | MANHATTAN | HVACSYSTEMSTESTING | Required Test | 2026-08-19T15:00:00.000 |
| Progress | IS053Q | QUEENS | LOWVOLTAGE | Project info | 2026-08-27T15:00:00.000 |
| Progress | PS125M | MANHATTAN | BOILER |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
inspection_stage_description | text | — | 0% | PeriodicProgressTest |
school_code | text | — | 0% | OS000QOS000KHS504K |
borough_name | categorical | — | 0% | BROOKLYNBRONXQUEENSof 5 |
tco_obtained_date | datetime | — | 98% | 2026-08-28 00:00:002026-08-19 00:00:002026-06-02 00:00:00of 14 |
GET /api/datasets/6246-94tp GET /api/datasets/6246-94tp/quality GET /api/datasets/6246-94tp/related GET /api/columns?dataset=6246-94tp
| Deficiency |
| 2026-08-11T09:07:00.000 |
| Emergency Sidewalk Bridge | HS557X | BRONX | SAFETY | Deficiency | 2026-08-12T07:00:00.000 |
| Periodic | PS627K | BROOKLYN | SAFETY | Deficiency | 2026-08-20T13:25:00.000 |
| SSP Review | PS025R | STATEN ISLAND | SAFETY | Comment | 2026-08-25T10:00:00.000 |
| Periodic | PS001K | BROOKLYN | SAFETY | Comment | 2026-08-03T13:50:00.000 |
| Test | PS194K | BROOKLYN | PLUMBING | Required Test | 2026-08-06T10:00:00.000 |
| Periodic | IS072R | STATEN ISLAND | SAFETY | Deficiency | 2026-08-03T12:15:00.000 |
| Progress | PS323K | BROOKLYN | PLUMBING | Project info | 2026-08-04T10:00:00.000 |
inspection_category |
| categorical |
| — |
| 0% |
SAFETYPLUMBINGFINALCONSTRUCTIONof 17 |
observation_description | categorical | — | 0% | DeficiencyCommentProject infoof 8 |
inspection_date | datetime | — | 0% | 2026-08-21T13:00:00.0002026-08-03T13:00:00.0002026-08-06T13:00:00.000 |