Sample data
Real, de-identified public crash data from five states. Your decisions here are yours alone and reset when you leave.
dc mapping
← All states
Crash fields (10)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
StateCode |
Constant |
Always DistrictOfColumbia (USStateNumericCode) |
StateUniqueCrashID |
Column |
Raw passthrough of column 'CCN' |
AgencyOrPoliceJurisdiction |
Column |
Raw passthrough of column '__NO_AGENCY_FIELD__' (default "Metropolitan Police Department" if blank) |
PoliceReportedCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
StateReportableCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
CrashDate |
EpochMillisDateTimeSplit |
Unix epoch-milliseconds date/time split from column 'REPORTDATE' |
RoadwayClearanceDate |
SameAs |
Copies the already-computed value of 'CrashDate' |
RoadwayClearanceTime |
ConstantSentinel |
Always the sentinel RoadClearanceTimeExtCode.Unknown (no real source data for this field) |
CrashCountyCode |
CountyLookup |
County FIPS lookup from column 'COUNTY_CODE' via county-crosswalk.csv |
GlobalPosition |
CoordinatePair |
Lat/long pair from 'LATITUDE' (lat) / 'LONGITUDE' (lon) - (0,0) treated as "no location" |
Vehicle fields (2)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
VehicleNumber |
IntColumn |
Integer passthrough of column 'VEHICLE_SEQ' |
VehicleBodyCategory.VehicleBodyTypeCode |
Lookup |
Crosswalk lookup: column 'INVEHICLETYPE_CODE' via vehicle-body-style.csv |
Person fields (4)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
PersonTypeCode |
Lookup |
Crosswalk lookup: column 'PERSONTYPE_CODE' via person-type.csv (default PersonTypeCode.UnknownOccupantTypeInAMotorVehicleInTransport if unmapped) |
VehicleNumber |
IntColumn |
Integer passthrough of column 'VEHICLE_SEQ' |
InjuryStatusCode |
Lookup |
Crosswalk lookup: column 'INJURY_CODE' via injury-status.csv |
NonMotorist.VehicleNumberofMVStrikingNonMotorist |
IntColumn |
Integer passthrough of column 'VEHICLE_SEQ' |