WISQARS™ Tutorials: Years of Potential Life Lost

Years of Potential Life Lost

Report Options
Advanced Options
Practice Question

WISQARS YPLL Reports calculate the years lost, by region or state, based on race and type of death.

This image shows all of the Years of Potential Life Lost (YPLL) report options. You are asked to define the following elements, which will be displayed on the finished map: Census Region/State, Race, Sex, Calculate YPLL before Age, Year(s) of Report, and Hispanic Origin.

Report Options

Under Report Options, the first choice is for Census Region/State. For our example we will choose the state of Arizona.

This image shows the Census Region/State option. The state of Arizona is selected.

Next we will choose the Race. For our example we will select American Indian/Alaska Native.

This image shows the Race option. American Indian/Alaska Native is selcted.

For the next report option, Sex, we will leave the default of Both Sexes.

This image shows the Sex option. The option for Both Sexes is selected.

The option of Calculate YPLL before Age allows you to designate the age before which a premature death results in YPLL. For our example we will select the age of 70.

This images shows the Calculate YPLL before Age option. 70 is selected.

Next we can choose the Year(s) of Report. Since we are limiting our results by selecting only one state, for our example we will increase our sampling by choosing the years 2000 to 2010.

This image shows the Year(s) of Report option. The ragne of 2000 to 2010 is selected.

Finally under Hispanic Origin we will retain the default selection of All.

You have the option at this point to submit your request, reset your options, or proceed to a series of optional Advanced Options. We will skip the submit step for now and take a closer look at the Advanced Options.

Advanced Options

The Statistics Reported option allows you to request one of the following statistics: the YPLL, the crude rate of YPLL per 100,000 population, and the age-adjusted rate of YPLL per 100,000. For our example we will keep the default of YPLL. We will also retain the default year of 2000 for the Standard Year (for age-adjusting).

This image shows the following Advanced options: Statistic Reported and Standard Year (for age-adjusting. In this example, the default of YPLL is selected along with the default year of 2000 for the Standard Year (for age-adjusting).

The next option is to Choose the subject of the report. The choice is given between Leading Causes of Death and the Number of Causes, or to compile data from Specific Injury Category. The options for Leading Causes of Death are shown here, but we will forego this option and select the Specific Injury Category.

This images shows the option Choose the subject of the report. The choice is given between Leading Causes of Death and the Number of Causes, or to compile data from Specific Injury Category.

Once we have opted for the Specific Injury Category, we must answer two questions. First, What was the intent or manner of the injury? For our example we will select Unintentional.

Specific Injury Category is selected. This images shows the question: What was the intent or manner of the injury? Unintentional is selected.

Second, What was the cause or mechanism of the injury? We will choose Motor vehicle, overall.

This image shows the question: What was the cause or mechanism of the injury? Motor vehicle, overall is selected.

Now that all our selections have been made, we can submit our request.

This image shows the option to Submit Request selected.

The resulting data look like this. Results can be downloaded in a spreadsheet as a CSV file.

This images shows the query results: YPLL Before Age 65, 2010 Arizona, Am Indian/AK Native, Both Sexes, All Deaths.

Practice Question

Now that you have familiarized yourself with the YPLL module of the WISQARS tutorial, put your knowledge to the test by answering the following questions:

Question 1: What are the top two causes of death (highest number of YPLL) for default options in the year 2010?

Hint: Find this by selecting the default options in the year 2010 and clicking the “submit request” button.

Answer: 1) Unintentional Injuries, and 2) Malignant Neoplasms (cancer).

Question 2: What are the top two causes of death (highest number of YPLL) for American Indians and Alaska Natives in the year 2010?

Answer: 1) Unintentional Injuries, 2) Suicide.

RETURN TO TOP OF YPLL TUTORIAL