From a 500-row sample across 21 columns.
| unique_id | collision_id | crash_date | crash_time | person_id | person_type | person_injury | vehicle_id | ped_role | person_sex | person_age | ejection |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10249006 | 4229554 | 2019-10-26T00:00:00.000 | 9:43 | 31aa2bc0-f545-444f-8cdb-f1cb5cf00b89 | Occupant | Unspecified | 19141108 | Registrant | U | — | — |
| 10255054 |
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 for Person table. | 0% | 111843931027560611761946 |
collision_id | integer | Crash identification code. Foreign Key, matches unique_id from the Crash table. | 0% | 396377546911583591272 |
crash_date | datetime | Occurrence date of collision | 0% | 2018-11-15T00:00:00.0002017-05-19T00:00:00.0002017-12-15T00:00:00.000 |
crash_time | text | Occurrence time of collision | 0% | 0:00 |
GET /api/datasets/f55k-p6yu GET /api/datasets/f55k-p6yu/quality GET /api/datasets/f55k-p6yu/related GET /api/columns?dataset=f55k-p6yu
contributing_factor_2unique_idcrash_date+4crash_datecollision_idcrash_time| 4230587 |
| 2019-10-25T00:00:00.000 |
| 15:15 |
| 4629e500-a73e-48dc-b8fb-53124d124b80 |
| Occupant |
| Unspecified |
| 19144075 |
| Passenger |
| F |
| 33 |
| Not Ejected |
| 10253177 | 4230550 | 2019-10-26T00:00:00.000 | 17:55 | ae48c136-1383-45db-83f4-2a5eecfb7cff | Occupant | Unspecified | 19143133 | Registrant | M | 55 | — |
| 6650180 | 3565527 | 2016-11-21T00:00:00.000 | 13:05 | 2782525 | Occupant | Unspecified | — | Notified Person | — | — | — |
| 10255516 | 4231168 | 2019-10-25T00:00:00.000 | 11:16 | e038e18f-40fb-4471-99cf-345eae36e064 | Occupant | Unspecified | 19144329 | Passenger | F | 7 | Not Ejected |
| 10253606 | 4230743 | 2019-10-24T00:00:00.000 | 19:15 | 84bcb3a7-d201-4c61-9e30-fe29268c1074 | Occupant | Injured | 19143343 | Driver | M | 27 | Not Ejected |
| 10251336 | 4230047 | 2019-10-26T00:00:00.000 | 16:45 | 21064a07-a945-49d0-af97-5446801b20ce | Occupant | Unspecified | 19142198 | Registrant | F | 41 | — |
| 10248708 | 4229547 | 2019-10-26T00:00:00.000 | 1:15 | a8904763-2870-42f3-865c-b53d8e5156e2 | Pedestrian | Injured | — | Pedestrian | F | 24 | — |
| 10250179 | 4229808 | 2019-10-26T00:00:00.000 | 13:04 | c3fc715e-203f-462d-9e8b-6a41fc378703 | Occupant | Unspecified | 19141630 | Driver | M | 36 | Not Ejected |
| 10253792 | 4230915 | 2019-10-24T00:00:00.000 | 8:20 | 793ac6c6-cbc7-4ab3-ab95-09f9312f1123 | Occupant | Unspecified | 19143438 | Registrant | U | — | — |
Showing 12 of 21 columns. All of them are listed below.
16:0017:00person_id | text | Person identification code assigned by system | 0% | 123 |
person_type | categorical | Bicyclist, Motor Vehicle Occupant, Pedestrian, | 0% | OccupantPedestrianBicyclistof 4 |
person_injury | categorical | Injured, killed, unspecified | 0% | UnspecifiedInjuredKilledof 3 |
vehicle_id | text | Unique vehicle record associated with person. Foreign Key to the vehicle table | 4% | 185907961733460117075216 |
person_age | integer | Automatically calculated based on date of birth | 11% | 03029 |
ejection | categorical | Indicates the following: Not ejected, partially ejected, or ejected from the vehicle | 49% | Not EjectedEjectedDoes Not Applyof 6 |
emotional_status | categorical | Apparent death, unconscious, semiconscious, etc. | 47% | Does Not ApplyConsciousShockof 8 |
bodily_injury | categorical | Injured body area (i.e. head, face, neck, etc.) | 47% | Does Not ApplyBackKnee-Lower Leg Footof 14 |
position_in_vehicle | categorical | Seating position #1-#8 (i.e. driver, front passenger, etc.) | 49% | DriverFront passenger, if two …Right rear passenger or …of 14 |
safety_equipment | text | Safety equipment being used (i.e. lap belt, harness, child restraint, air bag, etc.) | 49% | Lap Belt & HarnessUnknownLap Belt |
ped_location | categorical | Location of the pedestrian (i.e. at intersection, not at intersection) | 98% | Pedestrian/Bicyclist/Oth…Pedestrian/Bicyclist/Oth…Does Not Applyof 4 |
ped_action | text | What the pedestrian was doing at time of crash (i.e., walking with the signal, against the signal, etc.) | 98% | Crossing With SignalCrossing, No Signal, or …Crossing, No Signal, Mar… |
complaint | text | Type of physical complaint (ex. Concussion, severe burn, severe bleeding, etc.) | 47% | Does Not ApplyComplaint of Pain or Nau…Complaint of Pain |
ped_role | categorical | Pedestrian, witness, in-line skater, other, etc. | 3% | RegistrantDriverPassengerof 10 |
contributing_factor_1 | text | Factors contributing to the collision for designated vehicle | 98% | UnspecifiedPedestrian/Bicyclist/Oth…Driver Inattention/Distr… |
contributing_factor_2 | text | Factors contributing to the collision for designated vehicle | 98% | UnspecifiedPedestrian/Bicyclist/Oth…Driver Inattention/Distr… |
person_sex | categorical | Gender of person | 11% | MFUof 3 |