WISQARS™ NVDRS Additional Options

Additional options: Select Output Group(s) (if desired) and Report Format

Output Groups

This option allows you to request a report that includes cross tabulations (Down/Rows and Across/Columns features) of counts and/or rates by various selected data elements (age group, ethnicity, race, sex, state, year, intent, and mechanism).

For example, if you request sex as an output group then the report will separate the data by male and female:

NVDRS report results are displayed separately for male and female.

You can select up to four attributes, and the order in which you select them will affect presentation of data in the report.

For example, a user may want to see homicide counts and rates stratified by sex. ‘Homicide’ would be selected as the manner of death in Step 2:

Homicide as the intent or manner of death.

Then ‘Sex’ would be selected as an Output Group:

Select Sex in the Output Group to display options separately in results.

The resulting table would look like this:

Building on this, perhaps a user would want to query the frequency of homicide mechanisms by sex. Adding ‘Mechanism’ as an Output Group in the ‘Across/Columns’ position would result in a table like this:

NVDRS report results are displayed separately for Mechanism across columns and Sex down rows.

However, this may not be the most convenient layout, because Mechanism has more categories than Sex, resulting in having to scroll back and forth on the screen or resize it in order to see the full output. In this example, the user might instead choose to put ‘Mechanism’ in the ‘Down/Rows’ position and ‘Sex’ in the ‘Across/Columns’ position like this:

Select Mechanism and Sex in the Output Group to display options separately in results.

Resulting in a table like this:

NVDRS report results are displayed separately for Sex across columns and Mechanism down rows.

Then perhaps the user would like to see differences in homicide mechanism by sex and ethnicity. ‘Ethnicity’ could be added as an Output Group to ‘Across/Column’:

NVDRS additional output with down/rows Mechanism and across/columns sex and ethnicity selected.

Or to ‘Down/Row’:

Select Mechanism, Sex , Ethnicity in the Output Group to display options separately in results.

Users may want to run multiple queries to decide which table layout best reflects the data that they wish to display. Up to four Output Groups may be chosen.

Note that Output Group options are not available for report types that include circumstances, place of injury, homeless status, military status and pregnancy status (i.e., ‘Violent Death Counts and Percentages by Known Circumstances Of Death, Place of Injury, Pregnancy Status, Homeless Status, and Military Status’ and ‘Suicide Counts and Percentages by Known Circumstances Of Death’ (the latter being limited to suspected homicide followed by suicide perpetrators)).

Report Formats

At the bottom of the screen on the left-hand side is a ‘Select Report Format’ option:

Select Report Format options include HTML.

The user has four output options:

Spreadsheet
HTML
MS Word
PDF

The HTML format is the default, but the user can select any of the other formats. To download the data requested, the user should select the Spreadsheet option.

To execute: Run the query

Once all options are chosen in the above steps, the user can run the query by clicking the ‘Submit Request’ button in one of two places:

Select Submit Request to run the report.

Page last reviewed: July 28, 2021

Content source: Centers for Disease Control and Prevention, National Center for Injury Prevention and Control