From a 500-row sample across 29 columns.
Mappable — Socrata point column `location`.
Open on the map →| crash_date | crash_time | on_street_name | off_street_name | number_of_persons_injured | number_of_persons_killed | number_of_pedestrians_injured | number_of_pedestrians_killed | number_of_cyclist_injured | number_of_cyclist_killed | number_of_motorist_injured | number_of_motorist_killed |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021-09-11T00:00:00.000 | 2:39 | WHITESTONE EXPRESSWAY | 20 AVENUE | 2 | 0 | 0 | 0 | 0 | 0 | 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
crash_date | datetime | Occurrence date of collision | 0% | 2014-01-21T00:00:00.0002018-11-15T00:00:00.0002017-12-15T00:00:00.000 |
crash_time | text | Occurrence time of collision | 0% | 16:0015:0017:00 |
borough | categorical | Borough where collision occurred | 30% | BROOKLYNQUEENSMANHATTANof 5 |
zip_code | text | Postal code of incident occurrence | 30% | 112071123611101 |
GET /api/datasets/h9gi-nx95 GET /api/datasets/h9gi-nx95/quality GET /api/datasets/h9gi-nx95/related GET /api/columns?dataset=h9gi-nx95
collision_idcrash_datecrash_timecollision_idcrash_datecrash_timelatitudelongitudelatitudelongitudelatitudelongitudelatitudelongitudelatitudelongitudelocationlatitudelongitude| 0 |
| 2022-03-26T00:00:00.000 | 11:45 | QUEENSBORO BRIDGE UPPER | — | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 2023-11-01T00:00:00.000 | 1:29 | OCEAN PARKWAY | AVENUE K | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 2022-06-29T00:00:00.000 | 6:55 | THROGS NECK BRIDGE | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2022-09-21T00:00:00.000 | 13:21 | BROOKLYN BRIDGE | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2023-04-26T00:00:00.000 | 13:30 | WEST 54 STREET | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2023-11-01T00:00:00.000 | 7:12 | HUTCHINSON RIVER PARKWAY | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2023-11-01T00:00:00.000 | 8:01 | WEST 35 STREET | HENRY HUDSON RIVER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2023-04-26T00:00:00.000 | 22:20 | — | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2021-09-11T00:00:00.000 | 9:35 | — | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Showing 12 of 25 columns. All of them are listed below.
latitude | float | Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 11% | 0E-740.86186240.608757 |
longitude | float | Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 11% | 0E-7-74.038086-73.89063 |
location | coordinate | Latitude , Longitude pair | — | — |
on_street_name | text | Street on which the collision occurred | 22% | BROADWAY …ATLANTIC AVENUE …BELT PARKWAY … |
off_street_name | text | Nearest cross street to the collision | 38% | 3 AVENUE …BROADWAY …2 AVENUE … |
cross_street_name | text | Street address if known | 82% | 772 EDGEWATER ROAD…110-00 ROCKAWAY BOULE…2800 VICTORY BOULEV… |
number_of_persons_injured | integer | Number of persons injured | 0% | 012 |
number_of_persons_killed | categorical | Number of persons killed | 0% | 012of 7 |
number_of_pedestrians_injured | categorical | Number of pedestrians injured | 0% | 012of 14 |
number_of_pedestrians_killed | categorical | Number of pedestrians killed | 0% | 012of 6 |
number_of_cyclist_injured | categorical | Number of cyclists injured | 0% | 012of 5 |
number_of_cyclist_killed | categorical | Number of cyclists killed | 0% | 012of 3 |
number_of_motorist_injured | integer | Number of vehicle occupants injured | 0% | 012 |
number_of_motorist_killed | categorical | Number of vehicle occupants killed | 0% | 012of 6 |
contributing_factor_vehicle_1 | text | Factors contributing to the collision for designated vehicle | 0% | UnspecifiedDriver Inattention/Distr…Failure to Yield Right-o… |
contributing_factor_vehicle_2 | text | Factors contributing to the collision for designated vehicle | 16% | UnspecifiedDriver Inattention/Distr…Other Vehicular |
contributing_factor_vehicle_3 | text | Factors contributing to the collision for designated vehicle | 93% | UnspecifiedOther VehicularFollowing Too Closely |
contributing_factor_vehicle_4 | text | Factors contributing to the collision for designated vehicle | 98% | UnspecifiedOther VehicularFollowing Too Closely |
contributing_factor_vehicle_5 | text | Factors contributing to the collision for designated vehicle | 100% | UnspecifiedOther VehicularFollowing Too Closely |
collision_id | integer | Unique record code generated by system. Primary Key for Crash table. | 0% | 376542442374354705403 |
vehicle_type_code1 | text | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | 1% | SedanStation Wagon/Sport Util…PASSENGER VEHICLE |
vehicle_type_code2 | text | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | 20% | SedanStation Wagon/Sport Util…PASSENGER VEHICLE |
vehicle_type_code_3 | text | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | 93% | SedanStation Wagon/Sport Util…PASSENGER VEHICLE |
vehicle_type_code_4 | text | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | 98% | SedanStation Wagon/Sport Util…PASSENGER VEHICLE |
vehicle_type_code_5 | text | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | 100% | SedanStation Wagon/Sport Util…PASSENGER VEHICLE |