Skip Standard Navigation Links
Centers for Disease Control and Prevention
Navigation Bar Graphic
Navigation Bar Graphic Navigation Bar Graphic CDC Home Search Health Topics A-Z Navigation Bar Graphic Navigation Bar Graphic
   NIOSH Logo
NIOSH Home NIOSH Search Site Index Contact Us
Navigation Bar Graphic Navigation Bar Graphic
Contents
Arrow Indicates Focus Work-RISQS Home
 
Queries
Arrow Indicates Focus Injury Estimates
Arrow Indicates Focus Injury Rates
 
Help
Arrow Indicates Focus Help With Queries
Arrow Indicates Focus The Query Screen
Arrow Indicates Focus Technical Info
 
Resources
Arrow Indicates Focus Data Links
Arrow Indicates Focus FAQ's
Arrow Indicates Focus Publications
 
Horizontal Rule
spacer
Work-RISQS Query Help

Work-RISQS lets you query for specific injury estimates (number of cases) or rates (number of cases per 100 full-time workers). Both queries work similarly. First, select a specific time period and any demographic or injury characteristics you wish to focus on. Then, Click the button. Results from your query will be displayed in a table that may be printed or downloaded.

How to.....

Back To Top How to select query parameters

Open the pull-down list and Click on your choice. Multiple choices may be selected in parameter lists marked with (s) after the variable name and with the symbol Multiple selection (hold the Ctrl key down while clicking on individual items or hold the Shift key when clicking on the first and last item of a continuous list). Click the Multiple selection for examples.

NOTE: Queries with the default parameter of "ALL" selected for all variables will produce a national injury estimate or rate that is the grand total for all workers and injury types for the year. Selecting specific parameters will produce an estimate or rate for a narrower subset such as setting SEX = MALE to get the number of male workers injured or DIAGNOSIS = FRACTURE to get the number workers with fracture injuries. Specifically selecting SEX = MALE, DIAGNOSIS = FRACTURE, and EVENT = 1* FALLS will produce the number of male workers with fractures from falls.

TIP: Click on the variable name for more details about a specific parameter.

Important Caution: the more restrictive your query choices, the less likely you will be to obtain reportable results.



  Back To Top How to select event, source, or secondary source categories

The BLS classification system for incident event, source, and secondary source has a hierarchical structure with division, major group, group, and subgroup categories expressed as 1, 2, 3, and 4 digit codes, respectively. Individual cases are coded to the maximum detail level possible in 2 to 4 digit categories. Division level (1 digit) categories are always the sum of all 2-4 digit subcategories. To facilitate analysis, aggregate categories that are the sum of all subcategories are indicated with 1 to 3 digits followed by an asterisk (e.g., Event = 1* Falls is the sum of all subcategories [2-4 digits codes] within the Falls division; Event = 11* Fall to lower level is the sum of all subcategories [3-4 digits codes] within the Fall to lower level major group).

    To select codes
  • Click the Select Button button to display the coding tree. A list of division titles will appear in a new window.
  • Click on the plus symbol to expand the tree to see lower branches
  • Click on the minus symbol to hide lower branches
  • Lower branches are automatically hidden when a new branch is expanded for viewing

Example Tree Search

    To search for a specific code
  • Enter a word or text string into the Search box to find specific codes within the tree that contain the text in the code description.
  • Text matches will appear in a clickable list below the Search box. Click on an item to move to that section of the tree.
  • If you are looking for a specific code number, enter the number into the Search box to move quickly to the specific part of the tree.


Example Tree Search

    To select a specific code group or an individual code
  • Click on an open box to select a group (when the code number is followed by an asterisk) or an individual code
  • Code groups that are partially or fully selected will be marked with a hash Half checked code button
  • Individual codes that are selected will be marked with an X Checked code button


    To undo selections
  • Click on the Clear button button to undo all selections lower on that particular tree branch
  • Click on the Checked code button to undo an individual code selection

    To view selected code(s)
  • Click on the "View Selections" button to display the specific code or codes that you have selected for your query.
  • To modify your selections, click on the "Select Codes" to return to the code tree window.
  • If you select codes, the status indicator on the main query screen will change from All Events to Selected Codes.
  • On the main query screen, clicking the
    View Button button will return you to the list of specific codes that you have selected.

    To return to main query page
  • Click the "Close" button from either the "Select codes" or "View selections" windows to return to the main query page
On the main query page, the pull-down list will display the specific items you selected. To unselect an item you must go back to the Show Tree window or use the clear all selections button near the bottom of the main query page.

NOTE: Because the coding structure is unbalanced, individual categories may not have a complete complement of subcategories to the 4 digit level. The user should have some familiarity with the coding structure prior to reporting the results from this system (see Tech Info).

TIP: Click and remember! The hash mark indicates that some or all codes have been selected along a tree branch. Only one branch within a division is visible at a time. Remember what you select and verify your selections in the results output table.




  Back To Top How to get more than one estimate at a time

Use the Group Results By pull-down lists to produce a table of estimates for each subcategory within a parameter. Up to two categories may be selected by using the First and Second Category lists. The results table will have a row for each estimate by subcategory and a final row with the query total. If First and Secondary Categories are a selected, a subtotal row will also be given for the First Category items.

NOTE: The group by feature produces tables similar to the common CROSS-TAB output from many statistical programs. If SEX were selected as the first group by option, the results table would have estimates for males, females, and all workers (grand total). If, in addition, AGE GROUP were selected as the second group by option, the results table would have estimates for males by age group with a subtotal for males, similar estimates for females. If AGE GROUP were the first option selected and SEX the second option, the estimates would be the same as in the preceding table, but the order of estimates would be rearranged. A Second Category may be selected with no First Category selected.

TIP: If EVENT (tree), SOURCE (tree), or SECONDARY SOURCE (tree) is selected as the First Category, a specially formatted output table displays the code tree structure. If EVENT (list), SOURCE (list), or SECONDARY SOURCE (list) is selected as the Second Category, a simple list without the special formatting is output.

Important Caution: When using the GROUP RESULTS BY feature many of the subcategories may not have reportable results.




  Back To Top How to format the results output

You may select one of three output options to change how the query results page looks. Under the Output Type pull-down list select:

  • HTML, the default choice, to display the standard results page with all navigation bars
  • HTML No Left Menu to display the results page without the left-hand navigation bar
  • Printer Friendly HTML to display the results page that is most likely to print from your browser without a problem (top & left-hand navigation bars are omitted).

Select the fourth output option:

  • Comma Separated Values to obtain a results file for download to your PC. In this output the results page lists the query parameters (without any estimates or rates displayed), the download file name, and data notes

NOTE: In the results table, the number and column format is fixed. Download the results file to your PC to change these formats.

TIP: Before down-loading the csv file, PRINT your results page!




  Back To Top How to view titles for categories that have non-reportable results

To simplify the output table, the Display Non-reportable Results default setting (No) visually hides rows with non-reportable estimates in the results table. Click Yes in the pull-down list to display in the results table the titles and asterisks (*****) for the non-reportable categories. Categories with very few cases among the sample hospitals are always suppressed and never displayed regardless of the Display Non-reportable Results setting. Non-reportable/suppressed data are included in subtotals and the query total although estimates for the individual subcategories are not shown.

NOTE: In the results table, to maintain result reliability, answers are non-reportable when there are too few cases among the sample hospitals, the national estimate is too small, or the error about the estimate is too large (i.e., the coefficient of variation is >33%).

TIP: If Display Non-reportable Results = Yes, a group total may appear with asterisks, although no individual categories are shown, because of the way very small results are suppressed.




  Back To Top How to get results

Click the button to submit your query. Queries typically take several seconds to more than a minute.

TIP: Queries with Event, Source, or Secondary Source chosen as Group Results By categories require the longest calculation times. Use Event (division) or Source (division) group by categories in a preliminary query.




  Back To Top How to understand the results table

The results table includes a list of your specific query parameters. At the bottom of the table are a series of data notes specific to your query because of the parameters chosen and general notes that apply to all queries.

Injury/illness estimates: the body of the table has group by subcategories (if this feature was used), the number of injuries and illnesses in thousands, the 95% confidence bounds expressed as a value in thousands to be added and subtracted from the national estimate to get the confidence interval, and the percentage of the grand total for the year.

Injury/illness rates: the body of the table has group by subcategories (if used), the number of injuries and illnesses in thousands, the number of full time equivalent (FTE) workers in thousands for the time period selected, the injury/illness rate in incidents per 100 FTE, and the 95% confidence bounds expressed as a plus/minus value in incidents per 100 FTE.




  Back To Top How to print the results

Select the Output Type = Printer Friendly HTML to minimize printing problems. However, all Work-RISQS output formats are printable using your browser print function. There are no frames used in this webpage.

TIP: Some tables may require your browser to be set to print in landscape mode (change your settings under the browser menu File-Page setup).




  Back To Top How to download the results

The Download Data option produces a comma-separated-value (.csv) formatted file for you to import into software such as a spreadsheet.

Internet Explorer Users: When you click the Download Results Table link choose "Save this file to disk" and click "OK". Then, choose a directory location, and click "Save".

If the extension assigned is ".htm", your version of Internet Explorer has a known bug that causes the HTML document to download rather than the CSV file. If so, right-click on the Download Results Table button and select "Save Target As" to download the CSV file or see Microsoft Support.

Netscape Users: If you are given four options "More Info, Pick App, Save File, or Cancel", choose "Save File" and in the next dialog box choose "Save file to disk".




  Back To Top How to do another query

Use the navigation bar at the left or bottom of the results page or use your browser's Back button.

TIP: If you use the Back button, your previous parameter selections may be retained (depending on your browser setup). Use the button at the bottom of the query page to reset all parameters to their default values. This also resets the Treatment Year to 1998.




  Back To Top Troubleshooting queries

Not all subcategories are displayed when using the Group Results By feature (e.g., selected Group by sex, but results only list males): You probably restricted all results by choosing an individual parameter such as Sex = Male then used Group by = Sex in the current or a previous query. Check all query parameters selected (the Group By feature does not override other selected parameters that restrict the query). Also, check the status of the suppress non-reportable categories option. A missing subcategory may not have reportable results.

Right side of result table doesn't print properly: Select the Printer Friendly HTML output type, try setting your browser to print in landscape mode (e.g., under File-Page setup), or download the results and print from a spreadsheet program.

National estimates for individual categories do not sum to the Grand Total (e.g., male + female Grand Total): the grand total includes cases with unknown characteristics (such as sex) that are not displayed in the results table (see the data notes).

National estimate from injury estimate page is not equal to the national estimate from the injury rate page: The injury estimate queries include all ages (unless user restricted), whereas injury rate queries include only workers 15 yrs. and older.

You received a "Timeout" or other error message instead of a results table: Try the query again now or at another time of day; or do not group by parameters with lots of subcategories such as Injury Source.

Contact Us
Work-RISQS
NIOSH
 
 
 
Work-RISQS Home | Injury Estimates | Injury Rates | Tech Info | FAQ's | HELP
 
NIOSH Home | NIOSH Search | Site Index | Contact Us
 
Centers for Disease Control and Prevention
National Institute for Occupational Safety and Health
Division of Safety Research
 
Page last updated: Dec 25, 2008
Page last reviewed: Dec 25, 2008
Content Source: National Institute for Occupational Safety and Health (NIOSH) Division of Safety Research