https://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 https://www.bls.gov/data/#injuries.
Browse Metadata
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_DATATYPE 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.
|
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. |
