VICTIM DEMOGRAPHIC INFORMATION
SOUTH DAKOTA STATISTICAL ANALYSIS CENTER
The purpose of South Dakota's project was to provide a detailed description of crime victims in the state based on an analysis of incident-based reports. Victim information is an important tool for use by law enforcement in preventing crime. It can also be used by the public for community policing and other efforts to prevent crime in their communities.
This is South Dakota's first attempt to use the incident-based crime data from NIBRS. We did not collect data specifically for this project, but used 1999 data as submitted by police departments, sheriffs' offices, and the Department of Criminal Investigation (DCI). Victim data were obtained from the NIBRS database. Information from the incident reports include victim and offender relationships; whether they are within the family or outside of the family; whether the offender is known or not known by the victim; indication of domestic abuse; rate of alcohol/drug involvement; common locations; and use and involvement of weapons. We contracted with a programmer to write queries against the victim segment of the NIBRS software and to design reports based on those queries. Data from the queries were combined with demographic information and other data elements to produce the reports. We have not yet been able to provide these types of reports to local law enforcement agencies or other outside entities, so we do not have any feedback on them. We continue to collect more incident-based data and improve on data quality.
Our goal is to provide extensive and detailed information on the victims of crime in the state of South Dakota. We hope to be able to produce reports such as these and make them available to treatment programs, counseling programs, prosecuting attorneys, and to policymakers and legislators who set enforcement policies for law enforcement agencies and create statutes for the punishment of offenders and the treatment of victims.
In 1991, the South Dakota Statistical Analysis Center (SAC) received a grant from the Bureau of Justice Statistics (BJS) for the South Dakota Uniform Crime Reporting Redesign Project. The purpose of the project was to develop and implement the reporting standards established by the Federal Bureau of Investigation (FBI) for the National Incident-Based Reporting System (NIBRS). The South Dakota NIBRS Advisory Committee, an advisory committee of local law enforcement representatives, was formed. Based on its recommendation, the state computer agency, Information Services (IS), was hired to write the NIBRS software.
A software system for mandatory data elements as well as the mandatory supplemental reporting was developed. This software was a DOS-based data entry package with search features and basic report features. South Dakota began its conversion from UCR (Uniform Crime Reporting) to NIBRS in the latter part of 1993. On January 1, 1994, the SAC began accepting NIBRS data from participating agencies. The South Dakota SAC is somewhat unusual in that it serves as the FBI clearinghouse for the submission of UCR /NIBRS data.
In July of 1995, the South Dakota SAC began testing the NIBRS software in conjunction with the FBI. Testing continues and progress is being made toward becoming a "NIBRS-certified" state. As the industry standard became a Windows-based environment, the software offered by the state needed to be changed. In 1998, a private vendor was hired to develop a Windows-based NIBRS software program. The newly designed software, which uses Access 2.0 as the basic format, is very user friendly, unlike the DOS-based software. Under the new system, the data must be error free prior to submission to the SAC, since the design of the screens will not allow the user to progress until the information is entered correctly. This process greatly decreases the amount of time the SAC spends correcting erroneous data. In March 1999, participating agencies began the beta testing of the new software, and the software was distributed during the summer. Software is provided free of charge and training will be offered either on-site or regionally. Testing of the system continues as South Dakota moves toward NIBRS certification by the FBI.
Participation in the local NIBRS program in South Dakota is voluntary. Reporting agencies may choose to submit crime statistics via UCR or NIBRS. When South Dakota becomes certified, however, all reporting agencies shall submit data via NIBRS. South Dakota's reporting agencies represent approximately 82% of the population. In both 1997 and 1998, the FBI reported South Dakota's population to be 738,000.
In 1999, the South Dakota SAC received NIBRS data from 32 local police departments (29%), 28 sheriff's offices (43%), and the South Dakota Division of Criminal Investigation (DCI), which provides statewide coverage for the reporting of NIBRS incidents by reporting only when the local jurisdiction does not participate. The SAC office receives data from the local agencies via hard copy, diskette, or modem. The data are accepted from agencies that use the old DOS-based NIBRS software, CLEM software (outside vendor that meets South Dakota NIBRS criteria), or the new Windows-based software. (The old DOS-based NIBRS software and CLEM software is imported into the new NIBRS software.) Reports are run against the data using Access 2.0 and report generators designed by our private vendor. These reports are sent to the agencies to verify their accuracy.
To demonstrate the potential uses of the NIBRS data, the SAC chose a sample topic, demographic information on victims, for analysis using this new software system. South Dakota does not report any information regarding victims except for the crime of murder. Increasingly, the SAC receives requests for information about the victims of crimes, especially domestic violence. Information on victims is an important resource for law enforcement when trying to prevent crime. Victim information is also important to the public as more and more communities use community policing and other means to prevent crime from happening to them, their families, and their neighbors. More data about crimes and, in particular, victims, arm law enforcement and the public with the power of knowledge to aid in crime prevention. In addition, funding sources available for victims of crime programs are increasing. It is important to have accurate, detailed statistics as resource material and underlying documentation.
Victim information may be obtained from the NIBRS database. For crimes against person or robbery, incident reports include victim and offender relationships; whether they are within the family or outside of the family; whether the offender is known or not known by the victim; indication of domestic abuse; rate of alcohol/drug involvement; common locations; and use and involvement of weapons.
Information on the relationship between offenders and their victims is useful to treatment programs that deal with violent offenders, outreach or counseling programs that serve abused children and battered spouses, prosecuting attorneys who are involved with victim-witness programs, and policymakers and legislators who set enforcement policies for law enforcement agencies and create statutes for the punishment of offenders and treatment of victims.
We contracted with a programmer to write queries against the victim segment of the new NIBRS software and to design reports based on those queries. The following reports were developed:
- Primary Location of Offense
- Victim Age by Crime Type
- Victim Gender by Crime Type
- Victim Race by Crime Type
- Victim Type by Crime Type
- Victim Residence by Crime Type
- Victim Injury Type by Crime Type
- Victim/Offender Relationship Type by Crime Type
- Victim Ethnicity by Crime Type
- Victim Gang Affiliation by Crime Type
- Victim Count by Crime Type
- Homicide Details
- Law Enforcement Victims
- Type of Activity by Assignment Type
- Type of Activity by Cleared Type
- Type of Activity by Weapon Type
- Personal Injury by Weapon Type
- Time of Assaults
- Victim Domestic Violence by Crime Type
The data from the queries can be combined with the demographic information (age, gender, race, etc.) and the other data elements (victim type, resident status, type of injury, etc.) to enable SAC staff to perform detailed analyses on these data collected by the victim segment of the State of South Dakota Incident Report.
Additionally, the victim data are linked to an offense code. By counting these offenses, we will be able to analyze the number of offenses not reported in the UCR program such as bribery; counterfeiting/forgery; vandalism/destruction/damage of property; drug/narcotic offenses; embezzlement; extortion/blackmail; fraud offenses; gambling; and kidnapping/abduction offenses.
As stated before, the South Dakota SAC is somewhat unusual in that the UCR and NIBRS databases are managed by SAC staff. Therefore, UCR and NIBRS information is readily available by merely turning on the desktop computer. We did not collect data specifically for this project; rather, we used 1999 data as submitted by police departments, sheriffs' offices, and the DCI.
The data and codes reside in two different databases. The administrative, offense, victim, property, and offender/arrestee data are contained in five separate tables. Relationships exist between the administrative segment and the four other segment tables for the ORI # and the incident # fields. If a particular ORI #/incident # record is deleted from the administrative segment, it is deleted from the other four segment tables. The administrative segment must contain the particular ORI # and incident # or the record cannot be added to any of the four segment tables.
Agencies access NIBRS with a user ID and password. Data are entered by agencies using forms. The forms do not allow entry unless the edit command is selected. This makes it difficult to inadvertently change data. The forms contain field and form edits. After an incident has been added to NIBRS or changes have been made, it must be error checked again or the incident will not be allowed to export to the state's database. Exports to the state are done via hard copy, diskette, or modem.
Our modus operandi regarding crime data is that we do not release an individual department's data without its permission. Once the annual report Crime in South Dakota is published (generally the fall of the year), aggregate numbers are available upon request.
NIBRS is programmed in Microsoft Access 2.0. To create queries, a grid called Query By Example is used. Using SQL, the queries link tables together, summarize data, include criteria parameters, and perform whatever function the user requests. The criteria parameters contained in the queries use values entered by the user on a form. Reports are generated based on the queries. The reports identify the criteria used to generate the report.
We are continuing to work the "bugs" out of the software until the FBI certifies South Dakota as a NIBRS state. Some of the issues/problems we have and continue to encounter include use of the occurrence date vs. reporting date, incidents with multiple offenses, and data quality checks.