illinois mapping
← All states
Crash fields (13)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
StateCode |
Constant |
Always Illinois (USStateNumericCode) |
StateUniqueCrashID |
Column |
Raw passthrough of column 'CrashID' |
AgencyOrPoliceJurisdiction |
Column |
Raw passthrough of column 'InvestigatingAgencyDescrip' (default "(not available in this source)" if blank) |
PoliceReportedCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
StateReportableCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
CrashDate |
EpochMillisDatePlusClockTimeSplit |
Unix epoch-milliseconds date from column 'CrashDate' + a separate 12-hour clock-time column 'TimeOfCrash' |
RoadwayClearanceDate |
SameAs |
Copies the already-computed value of 'CrashDate' |
RoadwayClearanceTime |
ConstantSentinel |
Always the sentinel RoadClearanceTimeExtCode.Unknown (no real source data for this field) |
AtmosphericConditionsCode |
ListLookup |
Crosswalk lookup (single value wrapped in a list): column 'WeatherCode' via weather.csv |
LightConditionCode |
Lookup |
Crosswalk lookup: column 'LightConditionCode' via light-condition.csv |
MannerofCollisionCode |
Lookup |
Crosswalk lookup: column 'CollisionTypeCode' via manner-of-collision.csv |
CrashCountyCode |
CountyLookup |
County FIPS lookup from column 'CountyCode' via county-crosswalk.csv |
GlobalPosition |
CoordinatePair |
Lat/long pair from 'TSCrashLatitude' (lat) / 'TSCrashLongitude' (lon) - (0,0) treated as "no location" |
Vehicle fields (0)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
Person fields (0)
Not mapped this pass - see the state's own StateMappingConfig source for why.