The National Consortium on Violence Research – NCOVR

Violence in the United States—Data Workbooks
COUNTS AND POPULATION RATES

Two standard measures are commonly used to gauge the volume and risk of crime. Simple crime counts indicate the total volume of crime. Crime counts are important for assessing workload demands on police and other criminal justice agencies. Crime rates are scaled by population size and provide a measure of the risk of crime—either as offenders or victims—within a population. (“Crime clocks” are another indicator of risk.)

CALCULATE CRIME RATES

RATE PER CAPITA is:

Crime Rate per Capita = Number of Crimes/Total Population

Example: Police reported a total of 16,144 murders to the FBI for year 2002 in a US population of 268,282,065. The murder rate per capita that year was:

Murder Rate = 16,144 Murders/268,282,065 US Population = 0.000060 per capita

Change the scale units to a RATE PER 100,000 POPULATION by multiplying the per capita rate by 100,000.

Murder Rate = 100,000*(16,144 Murders/268,282,065 US Population) = 6.0 per 100,000 Population

Read more about police reporting to the FBI.

Population rates are the total count of crimes divided by the size of the population. An annual rate of 3 crimes per 1,000 population, for example, means that there are 3 crimes during a year for every 1,000 persons in the population. By changing the scale units in the denominator, the same rate can also be expressed as 0.003 crimes per capita or 300 crimes per 100,000 population. The per capita rate indicates the average risk of a crime during a year for each person in the population. Because crime is relatively rare for individuals, crime rates are usually reported as crimes per 100,000 population.

DATA ANALYSIS EXERCISES

1. a. What rate per 10,000 persons corresponds to a rate of 3 crimes per 1,000 population?

1. b. If there are 3,000 aggravated assaults during a year in a population of 1,000,000 persons, what is the annual rate of aggravated assaults per 100,000 persons?

Answers

EXPLORING DATA ON AGGRAVATED ASSAULT

Annual data on crimes reported to police are available from the Federal Bureau of Investigation’s Uniform Crime Reports (UCR) program. The data used in this workbook are based on offenses actually reported by police to the FBI and not the FBI’s adjusted estimate of total offenses that includes estimates for non-reporting agencies. The FBI’s UCR data will be used here to examine variations in crime counts and population rates over time and in different locations within the US.

MANIPULATE THE DATA

  • Go to Cognos Login page to open data table in a separate window. You can expand the data window without disturbing the workbook.
  • Log on using the special Workbook user account - Login: workbook and Password: ncovr.
  • Select the table named “UCR Offense Rates by Crime Type & City Size (Annual Averages).”

Having difficulty opening the data? Click here

The table reports annual average counts of aggravated assaults reported to the FBI by police agencies in different size cities and counties across the US. The counts are sums for all police agencies in a population group and the sums are then averaged over years. Annual averages are available for five-year intervals from 1980 to 1999. During the period from 1980 to 1984 there were an annual average total of 88,255.4 aggravated assaults reported each year in the collection of cities with populations of 1,000,000 or more. The collection of smaller cities with populations under 25,000 reported an annual average total of 101,102.4 aggravated assaults each year during the same 1980 to 1984 period. By the period 1995 to 1999 the number of aggravated assaults reported by police increased 62% to 142,943.4 annually in the largest cities with populations of 1,000,000 or more compared to an 18% increase to 119,522.0 annually in the smallest cities with populations under 25,000.

Print the table of aggravated assault counts for later use.

MANIPULATE THE DATA

  • Find the “File” icon next to "?" on menu bar at bottom of data table.
  • Click on up arrow and left click “Export PDF” to save table to a file for printing.
  • Show Me
  • Select “Landscape” orientation to increase portion of table or chart that fits on one page.
  • Click on "Export" button.
  • Click on “Save a Copy” or "Print" icon from PDF menu bar to save file to local computer or print the table.
  • You can also use the same “File” icon to export the file in “CSV” or “XLS” format that can be opened in Microsoft Excel.
  • Return to window with data table: click on down arrow on "Back" button and select "UCR Yearly Offense Data Cube..."

DATA ANALYSIS EXERCISES

2. a. Which population group (i.e., city or county type) experienced the largest annual number of aggravated assaults reported to police during the period 1995-99?

2. b. How many aggravated assaults were reported annually during the 1995-99 in this population group?

2. c. What was percentage growth in reported aggravated assaults in this population group between 1980-84 and 1995-99 periods?

Answers

3. a. What period experienced the highest volume of aggravated assaults in the nation?

3. b. Which city or county type was an exception to this pattern?

Answers

CHART OF AGGRAVATED ASSAULTS

It is easy to obtain a chart of the annual number of aggravated assaults directly from the table.

MANIPULATE THE DATA

Hide the item labeled “1980-84 to 1995-99 % Change” at the bottom of the table:

  • Right click in the label box of this row in table.
  • Left click "Hide Selection".
  • Show Me

Find the “Chart” icon at bottom left of the data window.

  • Left click on up arrow.
  • Left click on “Multiline” charts.
  • Show Me

Having difficulty with the chart? Click here

Does the chart display all the population groups on the same screen? If not, you can use chart options to configure the chart on visible screen page. Show Me

Each line in chart is a different time period. The legend to the left of the chart identifies the period represented by each line. For example, blue diamonds represent annual average counts in the period 1980-84 and yellow stars represent the period 1995-99. Each marker in a line represents the collection of police agencies from a different population group, starting from very large cities on the left and moving right to smaller cities and then Non-MSA and MSA counties. Both cities and counties are displayed because the main police agency in an area sometimes provides law enforcement services for an entire county, while other areas are policed by city-based agencies.
The vertical axis running up the left side of the chart indicates the annual average total counts in units of 1,000 offenses. For example, the line labeled 100 represents an annual average count of 100,000 (100*1,000) offenses in a year.

Counts of aggravated assaults are consistently high for MSA counties and consistently low for Non-MSA counties. Also as was evident in the data table, the annual average count of aggravated assaults was usually highest in the period 1990-94 (red triangles in the chart). Only one population group ever experiences an average close to 200,000 aggravated assaults in a year – cities with populations of 1,000,000 or more during the 1990-94 period.

DATA ANALYSIS EXERCISE

4. a. What population groups experience over 150,000 aggravated assaults annually and when did these levels occur?

4. b. Which period experiences the lowest average annual counts of aggravated assaults across all the population groups? What marker represents this period in the chart?

Answers

FACTORS INFLUENCING VARIATIONS IN COUNTS OF AGGRAVATED ASSAULTS

Factors other than crime risk can influence the variation in offense counts across population groups and over time. Simple differences in the size of the population included in the different population groups will affect the counts even if all population groups face the same risk of crime. It is easy to obtain the population covered by police agencies in each population group.

MANIPULATE THE DATA

To restore data table, find “Crosstab” icon at bottom of data window:

  • Left click on up arrow.
  • Left click on “Crosstab”.
  • Show Me

Change the content of table from count of aggravated assault offenses to population covered.

  • Right click in box labeled “Aggravated Assaults.”
  • Left click on “Hide/Show.” Show Me
  • Select “Population Covered” from list of “Hidden Categories” and click on left arrow to move it to “Visible Categories.”
  • Select “Aggravated Assaults” from “Visible Categories” and click on right arrow to move it to “Hidden Categories”.
  • Left click on “OK”.

Having difficulty with the data? Click here

If they are not already displayed, restore the percentage change values to the table.

MANIPULATE THE DATA

To restore percentage change values:

  • Right click in any “Annual Average” row label box.
  • Left click on “Hide/Show.” Show Me
  • Select “1980-84 to 1995-99 % Change” from list of “Hidden Categories” and click on left arrow to move it to “Visible Categories.”
  • Left click on “OK”.

Having difficulty opening the data? Click here

The table now reports the average annual population covered by police agencies in each population group. The populations policed by law enforcement agencies in MSA counties and cities with populations under 25,000 are largest at about 45-50 million persons annually over the period 1980 to 1999. The next largest population—numbering 25-30 million persons—is policed by law enforcement agencies in Non-MSA counties. Even if the risk of aggravated assault offenses were the same in all population groups, say 300 per 100,000 population, the count of aggravated assaults in MSA counties would be about twice that in cities with populations of 25,000-49,999 persons and about 4 times the count of aggravated assault offenses in cities with populations between 250,000 and 499,999.

These differences in the size of the population at risk could help explain the pattern of higher and lower counts of aggravated assaults observed earlier. For example, a portion of the increase in the count of aggravated assaults over time is likely to be due to the change in the size of the population over the same time periods.

Print the population covered table for later use.

MANIPULATE THE DATA

  • Find the “File” icon next to "?" on menu bar at bottom of data table.
  • Click on up arrow and left click “Export PDF” to save table or chart to a file for printing.
  • Show Me
  • Select “Landscape” orientation to increase portion of table or chart that fits on one page.
  • click on "Export" button.
  • Click on “Save a Copy” or "Print" icon from PDF menu bar to save file to local computer or print the table.
  • Return to window with data table: click on downarrow on "Back" button and select "UCR Yearly Offense Data Cube...".
  • You can also use the same “File” icon to export the file in “CSV” or “XLS” format that can be opened in Microsoft Excel.

DATA ANALYSIS EXERCISE

5. a. Which population group has the smallest total population covered?

5. b. What is the percentage change in population between the 1980-84 and 1995-99 time periods for that population group?

Answers

VARIATIONS IN AGGRAVATED ASSAULT RATES

Offense rates per population divide the number of offenses by the size of the population. This scales the count of offenses by the size of the population at risk and provides a more accurate comparison of risk across different size population groups. It is easy to display the aggravated assault rates in each population group.

MANIPULATE THE DATA

Change the content of table from population covered to aggravated assault rates.

  • Right click in box labeled “Population Covered.”
  • Left click on “Hide/Show”. Show Me
  • Select “Aggravated Assault Rate” from list of “Hidden Categories” and click on left arrow to move it to “Visible Categories.”
  • Select “Population Covered” from “Visible Categories” and click on right arrow to move it to “Hidden Categories.”
  • Left click on “OK”.

Having difficulty opening the data? Click here

The rates in the table show the varying risk of aggravated assaults in different population groups. As expected, when the population covered increases over time, the increases in rates over time are smaller than increases in counts of aggravated assaults. (Compare the percentage change values in the rate table to the same percentage change values in the aggravated assault count table printed earlier, especially the values for cities with populations over 1 million and cities with populations from 100,000-249,999).

DATA ANALYSIS EXERCISE

6. Compare percentage changes in rates to percentage changes in counts and population covered printed earlier.

6. a. Which population groups experience declines in population covered and what happens to change in rates compared to change in counts over time in these cases?

6. b. Which population groups experience little change in population covered and what happens to change in rates compared to change in counts over time in these cases?

Answers

Displaying the data in a chart provides an easy visual comparison of the variation in rates over population groups and over time.

MANIPULATE THE DATA

Hide the item labeled “1980-84 to 1995-99 % Change” at the bottom of the table:

  • Right click in the label box of this row in table.
  • Left click on “Hide Selection”.
  • Show Me

Find the “Chart” icon at bottom left of the data window.

  • Left click on up arrow.
  • Left click on “Multiline” charts.
  • Show Me

Having difficulty with the chart? Click here

As in the earlier chart of aggravated assault counts, each line represents a different time period and each marker represents a different population group. After adjusting the count of aggravated assaults by the population covered, the rates per population indicate the overall risk of aggravated assaults (either as offenders or victims) in different population groups and over time. Higher rates indicate a greater risk of aggravated assaults, while lower rates indicate a lower risk of aggravated assaults for persons residing in places in the different population groups.

DATA ANALYSIS EXERCISE

7. a. Which population group has the highest aggravated assault rates and which has the lowest rates?

7. b. In which population groups do persons face the greatest average risk of aggravated assault and which face the least risk of aggravated assault?

Answers

The chart is generally ordered by city size and level of urbanization with large cities on the left and then deceasing in size and urbanization as you move to the right. The one exception to this ordering is MSA counties. MSA counties include metropolitan areas in and around cities, while non-MSA counties include rural communities outside metropolitan areas. "Ranking Population Group"

Following the general pattern of decreasing aggravated assault rates as size and level of urbanization decline, non-MSA counties have the lowest rate of aggravated assaults—under 200 aggravated assaults per 100,000 population—in all time periods.
These are followed by the smallest cities with populations under 25,000. MSA counties—with substantial portions of their populations residing in suburbs around large cities — have aggravated assault rates that fall between those in cities with populations under 25,000 and cities with populations from 25,000 to 49,999.

The one clear exception to a systematic decline in rates as city size and level of urbanization decrease is in cities with populations 500,000-999,999. Rates in these large cities fall between those in cities with populations 250,000-499,999 and cities with populations 100,000-249,999. This exception is evident in all the displayed time periods.

EXPLORING DATA ON ROBBERY

The FBI classifies robbery as a violent crime because it involves the threat or use of force or violence in order to obtain something of value from victims. This offense type also shares elements with theft offenses because it involves the attempt or actual taking of property from another person. The same data that we have been using to examine variations in aggravated assault in the US also contains data on counts and rates per population for robbery. (Data are also available for other offense types included in the FBI’s category of serious index crimes.)

Change the data display from aggravated assault rate chart to “Robbery” count chart.

MANIPULATE THE DATA

Change the content of chart from “Aggravated Assault Rate” to “Robbery” counts:

  • Right click on the label for “Aggravated Assault Rate …” in the chart legend.
  • Left click on “Hide/Show.” Show Me
  • Select “Robbery” from list of “Hidden Categories” and click on left arrow to move it to “Visible Categories”.
  • Select “Aggravated Assault Rate” from “Visible Categories” and click on right arrow to move it to “Hidden Categories”.
  • Left click on “OK”.

Having difficulty opening the data? Click here

Does the chart display all the population groups on the same screen? If not, you can change the window size of chart. Show Me

Counts of robbery offenses are consistently high for the largest cities with populations of at least one million and consistently low for Non-MSA counties. Counts of robbery offenses reported to police consistently decline with city size and level of urbanization with distinctive exception for cities between 500,000 and 999,999 population.
Also like aggravated assault counts, the annual average count of robberies was usually highest in the period 1990-94 (red triangles in the chart). However, the closeness of lines in the chart indicates far less variation over time in robbery counts than was evident in aggravated assault counts.

STUDENT DATA ANALYSIS EXERCISE

8a. What population groups experience over 150,000 robberies annually and when did these levels occur?

8b. Which population group displays the largest variation over time periods in average annual counts of robberies?

Change from chart to data table by selecting “Crosstab” icon on left of menu bar at bottom of chart window.

Restore the “%Change” variable by right click in any “Annual Avg” label box and select “Hide/Show”. Select “% Change” variable and move it from “Hidden Categories” to “Visible Categories”.

9a. Which three population groups experienced the largest magnitude % changes in robbery counts between 1980-84 and 1995-99 time periods? (Consider magnitudes of both increases and declines.)

9b. Refer to printed table of aggravated assault counts. What was % change in aggravated assaults in the same population groups?

Change data table to display robbery rate per 100,000 population by right click in offense type label and select “Hide/Show”. Move offense count from “Visible Categories” to “Hidden Categories”. Select “Robbery Rate” variable and move it from “Hidden Categories” to “Visible Categories”

10a. Which time period experienced the lowest robbery rates in all but one population group?

10b. Which population group experienced the largest % decline in robbery rates?

10c. How many robberies were there for every 100,000 persons in cities with over 1 million populations in the 1980-84 period? How many in the same size cities in the 1995-99 time period?

10d. Compare the risk of robberies in the largest cities with populations over 1 million to the risk in the smallest cities with populations under 25,000. How many times larger was the big-city robbery risk in the 1980-84 period and in the 1995-99 period?

CLASS DISCUSSION

What attributes of different size cities might contribute to the variation in aggravated assault rates with city size and urbanization? Consider characteristics of the population residing in different size cities, differences in criminal justice resources and differences in the social fabric in different size cities.

STUDENTS ON YOUR OWN

1. Use the "Hide/Show" tool to examine variations in counts and rates for other crime types.

2. Select a single region of the country Show Me and examine variations on counts and rates over time and across population groups in that region. Are patterns like those observed in the nation?