From a 500-row sample across 12 columns.
typedateboroughMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| date | borough | direction | main_street | cross_street | type | truck_route | struck_overpass | state_of_operators_license | bin | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2013-01-07T00:00:00.000 | BRONX | S/B | HUTCHINSON RIVER PARKWAY | WESTCHESTER AVENUE | STRIKE | NO | YES | N/A | 2075837 | 40.843025 | -73.837796 |
| 2013-01-10T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
date | datetime | Date of Occurrence | 0% | 2015-05-22T00:00:00.0002013-06-04T00:00:00.0002020-11-20T00:00:00.000 |
borough | categorical | Borough in which the strike was recorded | 0% | QUEENSBRONXMANHATTANof 5 |
direction | categorical | Direction of travel | 0% | S/BE/BN/Bof 4 |
main_street | text | The on street in which the incident was recorded | 0% | BELT PARKWAYFDR DRIVE |
GET /api/datasets/jdn9-td9w GET /api/datasets/jdn9-td9w/quality GET /api/datasets/jdn9-td9w/related GET /api/columns?dataset=jdn9-td9w
latitudelongitudebintype| QUEENS |
| S/B |
| CROSS ISLAND PARKWAY |
| UNION TURNPIKE |
| STRIKE |
| NO |
| YES |
| N/A |
| 2231850 |
| 40.74087 |
| -73.726832 |
| 2013-01-11T00:00:00.000 | MANHATTAN | N/B | PARK AVENUE TUNNEL | EAST 39th STREET | STRIKE | NO | NO | N/A | 2246550 | 40.750227 | -73.979071 |
| 2013-01-28T00:00:00.000 | MANHATTAN | — | 79th STREET | TRANSVERSE ROAD | STRIKE | YES | NO | N/A | 2246440 | 40.778809 | -73.968183 |
| 2013-02-11T00:00:00.000 | MANHATTAN | N/B | FDR DRIVE | EAST 58th STREET | STRIKE | NO | YES | N/A | 2233040 | 40.757719 | -73.959396 |
| 2013-02-13T00:00:00.000 | QUEENS | — | CROSS ISLAND PARKWAY | UNION TURNPIKE | STRIKE | NO | YES | N/A | 1076050 | 40.74087 | -73.726832 |
| 2013-02-22T00:00:00.000 | MANHATTAN | S/B | FDR DRIVE | EAST 59th STREET | STRIKE | NO | YES | N/A | 2233040 | 40.758362 | -73.958978 |
| 2013-03-06T00:00:00.000 | BROOKLYN | E/B | BELT PARKWAY | BAY 8th STREET | STRIKE | NO | NO | N/A | 2231290 | 40.603714 | -74.019181 |
| 2013-03-13T00:00:00.000 | BRONX | S/B | HUTCHINSON RIVER PARKWAY | EAST TREMONT AVENUE | STRIKE | NO | YES | N/A | 2075820 | 40.840729 | -73.83848 |
| 2013-03-19T00:00:00.000 | QUEENS | E/B | BELT PARKWAY | FARMERS BOULEVARD | STRIKE | NO | YES | N/A | 2231620 | 40.666941 | -73.767092 |
HUTCHINSON RIVER PARKWAYcross_street | text | The cross street where strike occurred. | 1% | WESTCHESTER AVENUEEAST 90th STREET17th AVENUE |
type | text | Indicates the incident type (i.e. strike) | 0% | STRIKEof 1 |
truck_route | categorical | Identifies if the corridor is a truck route or not | 0% | NOYESof 2 |
struck_overpass | categorical | Confirms an overhead structure was struck | 0% | YESNOof 2 |
state_of_operators_license | text | Indicates the state in which the truck operator receives their license | 0% | N/ANYFL |
bin | text | The number that identifies the actual structure that was struck | 4% | 207583722321672231290 |
latitude | float | An angular distance (coordinates) in degrees north or south of the equator | 0% | 40.84296340.77749240.601674 |
longitude | float | An angular distance (coordinates) in degrees east or west of the equator | 0% | -73.837802-73.942847-74.011772 |