From a 500-row sample across 14 columns.
inspection_idcommentsinspection_idinspection_id| construction_id | full_capital | requirements | in_house | unknown_parks | non_parks | sign_present | area_clean | fenced_off | access | workers_present | inspection_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2146798269 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 199599 |
| 2146798271 | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
construction_id | integer | Unique identification number for inspection | 0% | 214677561721467740122146776300 |
full_capital | categorical | Indicates whether site is under capital reconstruction | 0% | 01of 2 |
requirements | categorical | Indicates whether site has requirements construction | 0% | 01of 2 |
in_house | categorical | Indicates whether site has in-house construction | 0% | 01of 2 |
GET /api/datasets/9yid-w4y8 GET /api/datasets/9yid-w4y8/quality GET /api/datasets/9yid-w4y8/related GET /api/columns?dataset=9yid-w4y8
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 199608 |
| 2146798275 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 199612 |
| 2146798272 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 199614 |
| 2146798276 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 199585 |
| 2146798267 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 199573 |
| 2146798264 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 199540 |
| 2146798265 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 199543 |
| 2146798266 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 199548 |
| 2146798261 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 199453 |
Showing 12 of 13 columns. All of them are listed below.
unknown_parks |
| categorical |
| Indicates whether site has unknown NYC Parks construction |
| 0% |
01of 2 |
non_parks | categorical | Indicates whether site has non-parks construction | 0% | 01of 2 |
who_non_parks | text | Comments related to non-parks construction | 96% | DOTMTADDC |
sign_present | categorical | Indicates whether site has sign present indicating construction | 0% | 10of 2 |
area_clean | categorical | Indicates whether site perimeter is clean | 0% | 10of 2 |
fenced_off | categorical | Indicates whether site is fenced off | 0% | 10of 2 |
access | categorical | Indicates whether site is locked | 0% | 10of 2 |
workers_present | categorical | Indicates whether workers present at time of inspection | 0% | 01of 2 |
comments | text | General comments related to construction | 84% | Closed, only SW rated.DOTSite locked. |
inspection_id | integer | Inspection identification number associated with construction event | 0% | 352674203342 |