Injuries And Illness Dataset

Unique code used to identify a specific geographic region. Choose combination of ownership (all, private, state, local, or state and local) and state . See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.area.

varchar (3)

Describes the specific geographic region. Choose combination of ownership (all, private, state, local, or state and local) and state . See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.area.

varchar (100)

A hierarchy of various levels. A proprietary nesting scheme.

varchar (2)

A permission to choose (T) a variable in which reasonable data is assured.

varchar (1)

Order in which variables are displayed.

varchar (5)

The code identifies the type of case for which data are available. Choose total recordable cases (all, poisoning, skin disease, hearing loss, respiratory illeness, or all other) or involving days away from work, days of job transfer and restriction, or all three. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.case_type. Definitions for days away from work, job transfer, and job restriction are listed below.

Varchar (1)

Describes case for which data are available. Choose total recordable cases (all, poisoning, skin disease, hearing loss, respiratory illeness, or all other) or involving days away from work, days of job transfer and restriction, or all three. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.case_type. Definitions for days away from work, job transfer, and job restriction are listed below.

Varchar(100)

Code identifying the specific series. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.data.1.AllData

Varchar (17)

Identifies year of observation between 2003-2010 for every Series ID.

Varchar(4)

Identifies the period of the observation (annual, monthly, quarterly).

Varchar(3)

Data values for series.

Varchar(12)

Identifies footnote for the data series.

Varchar(10)

Code identifying the datatype of the observation. Choose rate or number of illness or injury cases or illness and injury cases. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.data_type.

Varchar (1)

Describes the datatype of the observation. Choose rate or number of illness or injury cases or illness and injury cases. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.data_type.

Varchar(100)

Identifies footnote for the data series. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.footnote.

Varchar (1)

Contains the text of the footnote. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.footnote

Varchar(100)

Abbreviations for type of case component (industry, occupation, source, event, occupation)

Varchar (3)

The code identifies the type of case for which data are available. Choose total recordable cases (all, poisoning, skin disease, hearing loss, respiratory illeness, or all other) or involving days away from work, days of job transfer and restriction, or all three. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.case_type. Definitions for days away from work, job transfer, and job restriction are listed below.

Varchar(1)

Describes case for which data are available. Choose total recordable cases (all, poisoning, skin disease, hearing loss, respiratory illeness, or all other) or involving days away from work, days of job transfer and restriction, or all three. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.case_type. Definitions for days away from work, job transfer, and job restriction are listed below.

Varchar (50)

Describes the database tables to reference for the application based on code and component.

Varchar(50)

Describes the table columns to display from the CASE_TABLE_NAME

Varchar (50)

Contains the generic case selection

Varchar(50)

Order in which variables are displayed

Varchar (20)

whether CASE_CODE is displayed or not

Int 64

Code Display

Int 64

Describes to the application the Report format to display selected information.

Varchar (1)

The code identifies the type of case for which data are available. Choose total recordable cases (all, poisoning, skin disease, hearing loss, respiratory illeness, or all other) or involving days away from work, days of job transfer and restriction, or all three. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.case_type. Definitions for days away from work, job transfer, and job restriction are listed below.

Varchar(1)

Abbreviations for type of case component.

Varchar (3)

Unique code used to identify a specific ownership type (private, state government, local government).

Varchar (1)

Describes the ownership type for the observation (private, state government, local government, all).

Varchar(50)

Display order of ownership for application.

Varchar (5)

Unique code used to identify the state or area associated with the observation.

Varchar (2)

State or area name associated with the observation.

Varchar(50)

Order in which variables are displayed.

Varchar (5)

Identifies year of observation between 2003-2010 for every Series ID.

Varchar (4)

Unique code used to identify a specific ownership type (private, state government, local government)

Varchar(1)

Unique code used to identify the state or area associated with the observation.

Varchar (3)

State or area name associated with the observation.

Varchar(50)

Order in which variables are displayed.

Varchar (5)

Unique code use to identify the supersectors (Cobstruction, Education & Health Services, Financial Activities, Information, Leisure & Hospitality, Manufacturing, Natural Resources & Mining, Trade Transportation & Utilities, or Professional & Business Services). Definition of supersector is provided below.

Varchar (3)

The code identifies the industry for which data are observed. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.industry. See industry definition below.

Varchar(6)

Describes the industry for which data are observed. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.industry. See industry definition below.

Varchar (100)

A hierarchy of various levels. A proprietary nesting scheme.

Varchar (2)

A permission to choose (T) a variable in which reasonable data is assured.

Varchar(1)

Order in which variables are displayed.

Varchar (5)

Code identifying the specific series. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.series.

Varchar (17)

Unique code use to identify the supersectors (Cobstruction, Education & Health Services, Financial Activities, Information, Leisure & Hospitality, Manufacturing, Natural Resources & Mining, Trade Transportation & Utilities, or Professional & Business Services). Definition of supersector is provided below.

Varchar (3)

The code identifies the industry for which data are observed. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.industry. See industry definition below.

Varchar(6)

Code identifying the datatype of the observation. Choose rate or number of illness or injury cases or illness and injury cases. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.data_type.

Varchar (1)

The code identifies the type of case for which data are available. Choose total recordable cases (all, poisoning, skin disease, hearing loss, respiratory illeness, or all other) or involving days away from work, days of job transfer and restriction, or all three. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.case_type. Definitions for days away from work, job transfer, and job restriction are listed below.

Varchar (1)

Unique code used to identify a specific geographic region. Choose combination of ownership (all, private, state, local, or state and local) and state . See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.area.

Varchar(3)

Identifies footnote for the data series. See list at ftp://ftp.bls.gov/pub/time.series/ii/ii.footnote.

Varchar (10)

Identifies first year for which data are available (2003-2008).

Varchar(4)

Identifies first data observation within the first year for which data are available.

Varchar(3)

Identifies last year for which data are available (2005-2010).

Varchar (4)

Identifies last data observation within the first year for which data are available.

Varchar (3)

Unique code use to identify the supersectors (Cobstruction, Education & Health Services, Financial Activities, Information, Leisure & Hospitality, Manufacturing, Natural Resources & Mining, Trade Transportation & Utilities, or Professional & Business Services). Definition of supersector is provided below.

Varchar (3)

Name identifying the type of supersector (Cobstruction, Education & Health Services, Financial Activities, Information, Leisure & Hospitality, Manufacturing, Natural Resources & Mining, Trade Transportation & Utilities, or Professional & Business Services). Definition of supersector is provided below.

Varchar (100)

A hierarchy of various levels. A proprietary nesting scheme.

Varchar (2)

A permission to choose (T) a variable in which reasonable data is assured.

Varchar(1)

Order in which variables are displayed.

Varchar (5)