From a 500-row sample across 25 columns.
| unique_id | collision_id | crash_date | crash_time | vehicle_id | state_registration | vehicle_type | contributing_factor_1 | vehicle_make | vehicle_year | travel_direction | vehicle_occupants |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10385780 | 100201 | 2012-09-07T00:00:00.000 | 9:03 | 1 | NY | PASSENGER VEHICLE | Unspecified | — | — | — | — |
| 19140702 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
unique_id | integer | Unique record code generated by system. Primary Key. | 0% | 179224721768117413755754 |
collision_id | integer | Crash identification code. Foreign Key, matches unique_id from the Crash table. | 0% | 469115845391334275782 |
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:0017:00 |
GET /api/datasets/bm4k-52h4 GET /api/datasets/bm4k-52h4/quality GET /api/datasets/bm4k-52h4/related GET /api/columns?dataset=bm4k-52h4
crash_timecollision_idcontributing_factor_1+4crash_timecollision_idcrash_date| 4213082 |
| 2019-09-23T00:00:00.000 |
| 8:15 |
| 0553ab4d-9500-4cba-8d98-f4d7f89d5856 |
| NY |
| Station Wagon/Sport Utility Vehicle |
| Driver Inattention/Distraction |
| TOYT -CAR/SUV |
| 2002 |
| North |
| 1 |
| 14887647 | 3307608 | 2015-10-02T00:00:00.000 | 17:18 | 2 | NY | TAXI | Driver Inattention/Distraction | — | — | — | — |
| 14889754 | 3308693 | 2015-10-04T00:00:00.000 | 20:34 | 1 | NY | PASSENGER VEHICLE | Unspecified | — | — | — | — |
| 14400270 | 297666 | 2013-04-25T00:00:00.000 | 21:15 | 1 | NY | PASSENGER VEHICLE | Other Vehicular | — | — | — | — |
| 17044639 | 3434155 | 2016-05-02T00:00:00.000 | 17:35 | 219456 | NY | 4 dr sedan | Driver Inattention/Distraction | MERZ -CAR/SUV | 2015 | East | 2 |
| 19138701 | 4229067 | 2019-10-24T00:00:00.000 | 13:15 | c53b43d9-419a-4ab1-9361-3f2979078d89 | NY | Bus | Unspecified | FRHT-TRUCK/BUS | 2006 | East | 13 |
| 17303317 | 3503027 | 2016-08-18T00:00:00.000 | 12:39 | 672828 | NY | Station Wagon/Sport Utility Vehicle | Driver Inattention/Distraction | FORD -CAR/SUV | 2005 | Southwest | 2 |
| 12254536 | 196425 | 2013-07-16T00:00:00.000 | 11:20 | 1 | NY | PASSENGER VEHICLE | Unspecified | — | — | — | — |
| 11804847 | 2975897 | 2012-11-26T00:00:00.000 | 18:12 | 2 | NY | PASSENGER VEHICLE | Driver Inattention/Distraction | — | — | — | — |
Showing 12 of 23 columns. All of them are listed below.
15:00vehicle_id | text | Vehicle identification code assigned by system | 0% | 123 |
state_registration | text | State where vehicle is registered. | 8% | NYNJPA |
vehicle_type | text | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | 6% | SedanStation Wagon/Sport Util…PASSENGER VEHICLE |
vehicle_make | text | Vehicle make | 43% | TOYT -CAR/SUVHOND -CAR/SUVNISS -CAR/SUV |
vehicle_model | text | Vehicle model | 99% | TOYT CAMHOND ACCNISS ALT |
vehicle_year | text | Year the vehicle was manufactured | 44% | 201620152017 |
travel_direction | categorical | Direction vehicle was traveling | 37% | NorthWestEastof 15 |
vehicle_occupants | integer | Number of vehicle occupants | 40% | 102 |
driver_sex | categorical | Gender of driver | 52% | MFUof 3 |
driver_license_status | categorical | License, permit, unlicensed | 54% | LicensedUnlicensedPermitof 15 |
driver_license_jurisdiction | text | State where driver license was issued. | 54% | NYNJPA |
pre_crash | categorical | Pre-crash action: Going straight, making right turn, passing, backing, etc. | 21% | Going Straight AheadParkedMaking Left Turnof 19 |
point_of_impact | categorical | Location on the vehicle of the initial point of impact (i.e. driver side, passenger side rear, etc.) | 38% | Center Front EndLeft Front BumperCenter Back Endof 19 |
vehicle_damage | categorical | Location on the vehicle where most of the damage occurred | 39% | Center Front EndLeft Front BumperCenter Back Endof 19 |
vehicle_damage_1 | categorical | Additional damage locations on the vehicle | 60% | No DamageLeft Front BumperCenter Front Endof 19 |
vehicle_damage_2 | categorical | Additional damage locations on the vehicle | 69% | No DamageRight Front BumperLeft Front Bumperof 19 |
vehicle_damage_3 | categorical | Additional damage locations on the vehicle | 76% | No DamageCenter Front EndOtherof 19 |
public_property_damage | categorical | Public property damaged (Yes or No) | 34% | NUnspecifiedYof 3 |
public_property_damage_type | text | Type of public property damaged (ex. Sign, fence, light post, etc.) | 99% | FENCELIGHT POLEUTILITY POLE |
contributing_factor_1 | text | Factors contributing to the collision for designated vehicle | 4% | UnspecifiedDriver Inattention/Distr…Failure to Yield Right-o… |
contributing_factor_2 | text | Factors contributing to the collision for designated vehicle | 38% | UnspecifiedDriver Inattention/Distr…Following Too Closely |