Name: Fatality Analysis Reporting System (FARS) 2022 - Person 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) 2022 Final Release - Persons Involved Auxiliary File dataset was compiled from January 1, 2022 to December 31, 2022 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). The final release data is published 12-15 months after the initial release of FARS, and could contain additional fatal accidents due to the delay in police reporting, toxicology reports, etc., along with changes to attribute information for previously reported fatal accidents. 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 PER_AUX file. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529022

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)
• A_AGE1 (type: esriFieldTypeInteger, alias: A_AGE1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AGE2 (type: esriFieldTypeInteger, alias: A_AGE2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AGE3 (type: esriFieldTypeInteger, alias: A_AGE3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AGE4 (type: esriFieldTypeInteger, alias: A_AGE4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AGE5 (type: esriFieldTypeInteger, alias: A_AGE5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AGE6 (type: esriFieldTypeInteger, alias: A_AGE6, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AGE7 (type: esriFieldTypeInteger, alias: A_AGE7, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AGE8 (type: esriFieldTypeInteger, alias: A_AGE8, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AGE9 (type: esriFieldTypeInteger, alias: A_AGE9, 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)
• VEH_NO (type: esriFieldTypeInteger, alias: VEH_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PER_NO (type: esriFieldTypeInteger, alias: PER_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YEAR (type: esriFieldTypeInteger, alias: YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_PTYPE (type: esriFieldTypeInteger, alias: A_PTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_RESTUSE (type: esriFieldTypeInteger, alias: A_RESTUSE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_HELMUSE (type: esriFieldTypeInteger, alias: A_HELMUSE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_ALCTES (type: esriFieldTypeInteger, alias: A_ALCTES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_HISP (type: esriFieldTypeInteger, alias: A_HISP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_RCAT (type: esriFieldTypeInteger, alias: A_RCAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_HRACE (type: esriFieldTypeInteger, alias: A_HRACE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_EJECT (type: esriFieldTypeInteger, alias: A_EJECT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_PERINJ (type: esriFieldTypeInteger, alias: A_PERINJ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_LOC (type: esriFieldTypeInteger, alias: A_LOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_DOA (type: esriFieldTypeInteger, alias: A_DOA, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Fatality Analysis Reporting System (FARS) 2022 - Person 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:02:19 PM

Schema Last Edit Date: 4/17/2025 9:02:07 PM

Data Last Edit Date: 4/17/2025 9:02:07 PM

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