Name: MCMIS_Data_2

Display Field:

Type: Table

Description: <p><span style="background-color:rgb(255,255,255); color:rgb(74,74,74); font-family:&quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;"><span style="display:inline !important; float:none; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; text-align:left; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; word-spacing:0px;">The Truck Crashes by County dataset was created by aggregating crash data obtained from the FHWA Motor Carrier Management System (MCMIS). The Motor Carrier Management Information System (MCMIS) is a database of crashes involving motor carriers with USDOT numbers. The database includes trucks, buses, passenger cars, and light trucks with hazardous materials placard. Data are available for only those crashes resulting in either a tow-away, injury, or fatality. Data are collected from all 50 states, the District of Columbia, and Puerto Rico. The data are transmitted electronically from the States, but are maintained and operated by the Federal Motor Carrier Safety Administration (FMCSA). The crash data may contain multiple records for a crash, but due to privacy restrictions, driver data are not included in any crash files released to the public. MCMIS data is valid from 2019 - mid 2025. FARS data, which is included in this dataset, is valid from 2019 - 2023</span></span></p>

Copyright Text: MCMIS, FHWA, FARS

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Non_Fatal_Truck_Crashes_2019 (type: esriFieldTypeInteger, alias: Non-Fatal Truck Crashes 2019, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Non_Fatal_Truck_Crashes_2020 (type: esriFieldTypeInteger, alias: Non-Fatal Truck Crashes 2020, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Non_Fatal_Truck_Crashes_2021 (type: esriFieldTypeInteger, alias: Non-Fatal Truck Crashes 2021, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Non_Fatal_Truck_Crashes_2022 (type: esriFieldTypeInteger, alias: Non-Fatal Truck Crashes 2022, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Non_Fatal_Truck_Crashes_2023 (type: esriFieldTypeInteger, alias: Non-Fatal Truck Crashes 2023, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Non_Fatal_Truck_Crashes_2024 (type: esriFieldTypeInteger, alias: Non-Fatal Truck Crashes 2024, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Non_Fatal_Truck_Crashes_2025 (type: esriFieldTypeInteger, alias: Non-Fatal Truck Crashes 2025, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Non_Fatal_Truck_Crashes_2019___2025 (type: esriFieldTypeInteger, alias: Non-Fatal Truck Crashes 2019 - 2025, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Fatal_Truck_Crashes_2019 (type: esriFieldTypeInteger, alias: Fatal Truck Crashes 2019, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Fatal_Truck_Crashes_2020 (type: esriFieldTypeInteger, alias: Fatal Truck Crashes 2020, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Fatal_Truck_Crashes_2021 (type: esriFieldTypeInteger, alias: Fatal Truck Crashes 2021, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Fatal_Truck_Crashes_2022 (type: esriFieldTypeInteger, alias: Fatal Truck Crashes 2022, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Fatal_Truck_Crashes_2023 (type: esriFieldTypeInteger, alias: Fatal Truck Crashes 2023, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Fatal_Truck_Crashes_2019___2023 (type: esriFieldTypeInteger, alias: Fatal Truck Crashes 2019 - 2023, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Fatal_and_Non_Fatal_Truck_Crashes_2019___2025 (type: esriFieldTypeInteger, alias: Total Fatal and Non-Fatal Truck Crashes 2019 - 2025, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Accidents_in_2019 (type: esriFieldTypeInteger, alias: Total Accidents in 2019, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Accidents_in_2020 (type: esriFieldTypeInteger, alias: Total Accidents in 2020, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Accidents_in_2021 (type: esriFieldTypeInteger, alias: Total Accidents in 2021, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Accidents_in_2022 (type: esriFieldTypeInteger, alias: Total Accidents in 2022, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Accidents_in_2023 (type: esriFieldTypeInteger, alias: Total Accidents in 2023, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Accidents_in_2024__Accidents_resulting_in_Fatality_not_yet_reported_for_this_year_ (type: esriFieldTypeInteger, alias: Total Accidents in 2024 (Accidents resulting in Fatality not yet reported for this year), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Accidents_in_2025__Accidents_resulting_in_Fatality_not_yet_reported_for_this_year_ (type: esriFieldTypeInteger, alias: Total Accidents in 2025 (Accidents resulting in Fatality not yet reported for this year), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/24/2025 2:30:40 PM

Schema Last Edit Date: 11/20/2025 3:16:41 PM

Data Last Edit Date: 11/20/2025 3:16:41 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat