Name: Fatality Analysis Reporting System (FARS) 2023 - Accidents Auxiliary File

Display Field: ST_CASE

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: The Fatality Analysis Reporting System (FARS) 2023 Initial Release - Fatal Motor Vehicle Accidents Auxiliary File dataset was compiled from January 1, 2023 to December 31, 2023 by the National Highway Traffic Safety Administration (NHTSA) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). This file contain elements derived from the FARS datasets to make it easier to extract certain data classifications and topical areas. This file downloaded from the open data catalog is synonymous with what USDOT/NHTSA releases for FARS as the ACC_AUX file. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529020

Copyright Text: This NTAD dataset is a work of the United States government as defined in 17 U.S.C. § 101 and as such are not protected by any U.S. copyrights. This work is available for unrestricted public use.

Max Record Count: 2000

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• YEAR (type: esriFieldTypeInteger, alias: YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATE (type: esriFieldTypeInteger, alias: STATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST_CASE (type: esriFieldTypeInteger, alias: ST_CASE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FATALS (type: esriFieldTypeInteger, alias: FATALS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_CRAINJ (type: esriFieldTypeInteger, alias: A_CRAINJ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_REGION (type: esriFieldTypeInteger, alias: A_REGION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_RU (type: esriFieldTypeInteger, alias: A_RU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_INTER (type: esriFieldTypeInteger, alias: A_INTER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_RELRD (type: esriFieldTypeInteger, alias: A_RELRD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_INTSEC (type: esriFieldTypeInteger, alias: A_INTSEC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_ROADFC (type: esriFieldTypeInteger, alias: A_ROADFC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_JUNC (type: esriFieldTypeInteger, alias: A_JUNC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_MANCOL (type: esriFieldTypeInteger, alias: A_MANCOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_TOD (type: esriFieldTypeInteger, alias: A_TOD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_DOW (type: esriFieldTypeInteger, alias: A_DOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_CT (type: esriFieldTypeInteger, alias: A_CT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_WEATHER (type: esriFieldTypeInteger, alias: A_WEATHER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_LT (type: esriFieldTypeInteger, alias: A_LT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_MC (type: esriFieldTypeInteger, alias: A_MC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_SPCRA (type: esriFieldTypeInteger, alias: A_SPCRA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_PED (type: esriFieldTypeInteger, alias: A_PED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_PED_F (type: esriFieldTypeInteger, alias: A_PED_F, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_PEDAL (type: esriFieldTypeInteger, alias: A_PEDAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_PEDAL_F (type: esriFieldTypeInteger, alias: A_PEDAL_F, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_ROLL (type: esriFieldTypeInteger, alias: A_ROLL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_POLPUR (type: esriFieldTypeInteger, alias: A_POLPUR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_POSBAC (type: esriFieldTypeInteger, alias: A_POSBAC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_D15_19 (type: esriFieldTypeInteger, alias: A_D15_19, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_D16_19 (type: esriFieldTypeInteger, alias: A_D16_19, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_D15_20 (type: esriFieldTypeInteger, alias: A_D15_20, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_D16_20 (type: esriFieldTypeInteger, alias: A_D16_20, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_D65PLS (type: esriFieldTypeInteger, alias: A_D65PLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_D21_24 (type: esriFieldTypeInteger, alias: A_D21_24, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_D16_24 (type: esriFieldTypeInteger, alias: A_D16_24, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_RD (type: esriFieldTypeInteger, alias: A_RD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_HR (type: esriFieldTypeInteger, alias: A_HR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_DIST (type: esriFieldTypeInteger, alias: A_DIST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_DROWSY (type: esriFieldTypeInteger, alias: A_DROWSY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_WRONGWAY (type: esriFieldTypeInteger, alias: A_WRONGWAY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIA (type: esriFieldTypeInteger, alias: BIA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPJ_INDIAN (type: esriFieldTypeInteger, alias: SPJ_INDIAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INDIAN_RES (type: esriFieldTypeInteger, alias: INDIAN_RES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CENSUS_2020_TRACT_FIPS (type: esriFieldTypeString, alias: CENSUS_2020_TRACT_FIPS, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
• TRACT (type: esriFieldTypeInteger, alias: TRACT, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Fatality Analysis Reporting System (FARS) 2023 - Accidents Auxiliary File
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/17/2025 9:05:58 PM

Schema Last Edit Date: 4/17/2025 9:05:58 PM

Data Last Edit Date: 4/17/2025 9:05:58 PM

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