< Return to Datasets Menu

Fatal Occupational Injuries

Fatal Occupational Injuries

http://api.dol.gov/V1/Safety/FatalOccupationalInjuries

Allows users to search nonfatal and fatal data for the nation and for States from the most current Survey of Occupational Injuries and Illnesses and the Census of Fatal Occupational Injuries programs. Users can search by industry, demographic characteristics, and case characteristics. Historical data for years prior to the current year. More information and details about the data provided can be found at http://www.bls.gov/data/#injuries.

Browse Metadata Explore This Data

Dataset Tables

FI_AREA Table

Area
Column Name Data Type Column Description
Column Name AREA_CODE Data Type varchar (3) Column Description Unique code used to identify a specific geographic region. Choose major MSAs, states, or US. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.area
Column Name AREA_NAME Data Type varchar (100) Column Description Describes the specific geographic region. Choose major MSAs, states, or US. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.area
Column Name DISPLAY_LEVEL Data Type varchar (2) Column Description A hierarchy of various levels. A proprietary nesting scheme.
Column Name SELECTABLE Data Type varchar (1) Column Description A permission to choose (T) a variable in which reasonable data is assured.
Column Name SORT_SEQUENCE Data Type varchar (5) Column Description Order in which variables are displayed.

FI_CASE Table

Case
Column Name Data Type Column Description
Column Name CASE_TYPE Data Type Varchar (1) Column Description The code identifies the type of case for which data are available. Fatalities in all sectors, detailed industry (private, federal, local, state, or government), event/exposure, detailed occupation (government, all sectors, or private), or source of injury (primary or secondary).See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.case. Definitions pertaining to Case are provided below.
Column Name CASE_TEXT Data Type Varchar(100) Column Description Describes case for which data are available. Fatalities in all sectors, detailed industry (private, federal, local, state, or government), event/exposure, detailed occupation (government, all sectors, or private), or source of injury (primary or secondary). See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.case

FI_CATEGORY Table

Category
Column Name Data Type Column Description
Column Name CASE_CODE Data Type Varchar (1) Column Description The code identifies the type of case for which data are available. Fatalities in all sectors, detailed industry (private, federal, local, state, or government), event/exposure, detailed occupation (government, all sectors, or private), or source of injury (primary or secondary).See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.case
Column Name CATEGORY_CODE Data Type Varchar(3) Column Description The code identifies the category of the observation. Choose combination of Case Code and all ownership, age group, event/exposure, gender, nature, occupations, part, race, primary source of injury, secondary source of injury, worker status (wage/salary or self-employed), worker activity, or worker location (See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.category). Definitions for event/exposure, nature, occupation, part, primary source of injury, secondary source of injury, worker activity, and worker location are provided below.
Column Name CATEGORY_TEXT Data Type Varchar (100) Column Description Describes the category of the observation. (See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.category). Definitions for event/exposure, nature, occupation, part, primary source of injury, secondary source of injury, worker activity, and worker location are provided below.

FI_CATEGORY2 Table

Category2
Column Name Data Type Column Description
Column Name CATEGORY_CODE Data Type Varchar(3) Column Description The code identifies the category of the observation. Choose combination of Case Code and all ownership, age group, event/exposure, gender, nature, occupations, part, race, primary source of injury, secondary source of injury, worker status (wage/salary or self-employed), worker activity, or worker location (See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.category2). Definitions for event/exposure, nature, occupation, part, primary source of injury, secondary source of injury, worker activity, and worker location are provided below.
Column Name CATEGORY_TEXT Data Type Varchar (100) Column Description Describes the category of the observation. (See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.category2). Definitions for event/exposure, nature, occupation, part, primary source of injury, secondary source of injury, worker activity, and worker location are provided below.

FI_DATA_PUB Table

Data Pub
Column Name Data Type Column Description
Column Name SERIES_ID Data Type Varchar (30) Column Description Code identifying the specific series. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.data.0.Current.
Column Name YEAR Data Type Varchar(4) Column Description Identifies year of observation for 2003-2008 intervals for every Series ID.
Column Name PERIOD Data Type Varchar(3) Column Description Identifies the reference period (annual, quarterly, monthly).
Column Name VALUE Data Type Varchar(12) Column Description Data values for series.
Column Name FOOTNOTE_CODES Data Type Varchar(10) Column Description Identifies footnote for the data series.

FI_DATA_TYPE Table

Data Type
Column Name Data Type Column Description
Column Name DATATYPE_CODE Data Type Varchar (1) Column Description Code identifying the datatype of the observation. Only Fatal Injuries (count).
Column Name DATATYPE_TEXT Data Type Varchar(100) Column Description Describes the datatype of the observation. Only Fatal Injuries (count).

FI_EVENT Table

Event
Column Name Data Type Column Description
Column Name EVENT_CODE Data Type varchar (6) Column Description Names the event which resulted in the reported injury. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.event. Definition of event provided below.
Column Name EVENT_TEXT Data Type varchar (100) Column Description Describes the event which resulted in the reported injury. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.event. Definition of event provided below.
Column Name DISPLAY_LEVEL Data Type varchar (2) Column Description A hierarchy of various levels. A proprietary nesting scheme.
Column Name SELECTABLE Data Type varchar (1) Column Description A permission to choose (T) a variable in which reasonable data is assured.
Column Name SORT_SEQUENCE Data Type varchar (5) Column Description Order in which variables are displayed.

FI_FOOTNOTE Table

Footnote
Column Name Data Type Column Description
Column Name FOOTNOTE_CODE Data Type Varchar (2) Column Description Identifies footnote for the data series.
Column Name FOOTNOTE_TEXT Data Type Varchar(200) Column Description Contains the text of the footnote.

FI_GQT_CASE Table

GQT Case
Column Name Data Type Column Description
Column Name GQT_CASE_COMPONENT Data Type Varchar (3) Column Description Abbreviations for type of case component (industry, occupation, source, event, occupation)
Column Name GQT_CASE_CODE Data Type Varchar(1) Column Description Alpha-numerical code to describe the case attributes (Industry, occupation, source, event and government or private occupation)
Column Name GQT_CASE_TEXT Data Type Varchar (50) Column Description Describes the case code
Column Name GQT_CASE_TABLE_NAME Data Type Varchar(50) Column Decsciption Describes the database tables to reference for the application based on code and component
Column Name GQT_CASE_COLUMN_NAMES Data Type Varchar (50) Column Description Describes the table columns to display from the CASE_TABLE_NAME
Column Name GQT_CASE_TITLE Varchar(50) Data Type Column Description Contains the generic case selection
Column Name GQT_ORDER Data Type Varchar (20) Column Description Order in which column is sorted
Column Name GQT_DISPLAY Data Type Int 64 Column Name Indicate if CASE_CODE is displayed or not
Column Name GQT_CODE_DISPLAY Data Type Int 64 Column Description GQT Code Display

FI_GQT_CHAR Table

GQT Char
Column Name Data Type Column Descrpition
Column Name GQT_REPORT_ID Data Type Varchar (1) Column Description Describes to the application the Report format to display selected information.
Column Name GQT_CASE_CODE Data Type Varchar(1) Column Description Alpha-numerical code describes the case attributes (Industry, occupation, source, event and government or private occupation)
Column Name GQT_CASE_COMPONENT Data Type Varchar (3) Column Description Abbreviations for type of case component (industry, occupation, source, event, occupation)

FI_GQT_CHAR_OWNERSHIP Table

GQT Char Ownership
Column Name Data Type Column Description
Column Name GQT_CASE_CODE Data Type Varchar (1) Column Description Alpha-numerical code describes the case attributes (Industry, occupation, source, event and government or private occupation).
Column Name OWNERSHIP_CODE Data Type Varchar(1) Column Description Codes for ownership types (All, Private, Government, Federal, State, etc.).
Column Name UNIQUE_CODE Data Type Varchar (1) Column Description Combination of case and ownership code for application.
Column Name PRIVATE_CODE Data Type Varchar (1) Column Description Combination of case and ownership code for application.

FI_GQT_OWNERSHIP Table

GQT Ownership
Column Name Data Type Column Description
Column Name OWNERSHIP_CODE Data Type Varchar (1) Column Description Codes for ownership types (All, Private, Government, Federal, State, etc.).
Column Name OWNERSHIP_NAME Data Type Varchar(50) Column Description Text describing ownership code.
Column Name SORT_SEQUENCE Data Type Varchar (5) Column Description Display order of ownership for application.

FI_GQT_STATE Table

GQT State
Column Name Data Type Column Description
Column Name STATE_CODE Data Type Varchar (3) Column Description S+state code and M+metro area codes.
Column Name STATE_NAME Data Type Varchar(50) Column Description State and metro area names.
Column Name SORT_SEQUENCE Data Type Varchar (5) Column Description Display order of state/areas for application.

FI_GQT_STATE_OWNERSHIP Table

GQT State Ownership
Column Name Data Type Column Description
Column Name YEAR Data Type Varchar (4) Column Description Available years for data.
Column Name OWNERSHIP_CODE Data Type Varchar(1) Column Description Codes for ownership types (All, Private, Government, Federal, State, etc.).
Column Name STATE_CODE Data Type Varchar (3) Column Description S+state code and M+metro area codes.
Column Name STATE_NAME Data Type Varchar(50) Column Description State and metro area names.
Column Name SORT_SEQUENCE Data Type Varchar (5) Column Description Display order of state/areas for application.

FI_INDUSTRY Table

Industry
Column Name Data Type Column Description
Column Name INDUSTRY_CODE Data Type Varchar (6) Column Description The code identifies the industry for which data are observed. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.industry. See industry definition below.
Column Name INDUSTRY_TEXT Data Type Varchar(100) Column Description Describes the industry for which data are observed. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.industry. See industry definition below.
Column Name DISPLAY_LEVEL Data Type Varchar (2) Column Description A hierarchy of various levels. A proprietary nesting scheme.
Column Name SELECTABLE Data Type Varchar(1) Column Description A permission to choose (T) a variable in which reasonable data is assured.
Column Name SORT_SEQUENCE Data Type Varchar (5) Column Description Order in which variables are displayed.

FI_SERIES Table

Series
Column Name Data Type Column Description
Column Name SERIES_ID Data Type Varchar (30) Column Description Code identifying the specific series. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.series.
Column Name CATEGORY_CODE Data Type Varchar (3) Column Description The code identifies the category of the observation. Choose combination of Case Code and all ownership, age group, event/exposure, gender, nature, occupations, part, race, primary source of injury, secondary source of injury, worker status (wage/salary or self-employed), worker activity, or worker location (See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.category). Definitions for event/exposure, nature, occupation, part, primary source of injury, secondary source of injury, worker activity, and worker location are provided below.
Column Name DATATYPE_CODE Data Type Varchar (1) Column Description Code identifying the datatype of the observation. Only Fatal Injuries (count).
Column Name CASE_CODE Data Type Varchar (1) Column Description The code identifies the type of case for which data are available. Fatalities in all sectors or detailed industry (private, federal, local, state, or government), event/exposure, detailed occupation (government, all sectors, or private), or source of injury (primary or secondary).See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.case
Column Name INDUSTRY_CODE Data Type Varchar(6) Column Description The code identifies the industry for which data are observed. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.industry. See industry definition below.
Column Name EVENT_CODE Data Type Varchar(6) Column Description Names the event which resulted in the reported injury. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.event. Definition of event provided below.
Column Name SOURCE_CODE Data Type Varchar (6) Column Description The code identifies the source of injury. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.source. Definition of source is provided below
Column Name OCCUPATION_CODE Data Type Varchar (6) Column Description The code identifies the occupation of the person experiencing the injury. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.occupation. Definition of occupation can be found below.
Column Name AREA_CODE Data Type Varchar(3) Column Description Unique code used to identify a specific geographic region. Choose major MSAs, states, or US. See list at ftp://ftp.bls.gov/pub/time.series/fi/fi.area
Column Name FOOTNOTE_CODES Data Type Varchar (10) Column Description Identifies footnote for the data series.
Column Name BEGIN_YEAR Data Type Varchar(4) Column Description Identifies first year for which data are available.
Column Name BEGIN_PERIOD Data Type Varchar(3) Column Description Identifies first data observation within the first year for which data are available.
Column Name END_YEAR Data Type Varchar (4) Column Description Identifies last year for which data are available.
Column Name END_PERIOD Data Type Varchar (3) Identifies last data observation within the first year for which data are available.