U.S. flag
      An official website of the United States government, Department of Justice.
        Here's how you know
      Here's how you know**Official websites use .gov**
            
            A **.gov** website belongs to an official government organization in the United States.
      **Secure .gov websites use HTTPS**
            
            A **lock** (
            A locked padlock
            ) or **https://** means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites. Menu

      
        close

            
            
                                              About NIJ
        
                    
  
          About NIJ
      
    
          The NIJ Director
          How NIJ Is Organized
          Mission and Guiding Principles
          Research and Development Process
          Strategic Framework
          Assessments of NIJ
          Annual Reports & Reports to Congress
          Staff Directory
          Funding & Awards
        
                    
  
          Funding & Awards
      
    
          Current Funding
          Forthcoming Funding
          Expired Funding
          Awards: Listing of Funded Projects
          Guidance for Applicants and Awardees
          Fellowship & Student Programs
          Travel Scholarships
          NIJ Challenge Program
          Library & Multimedia
        
                    
  
          Library & Multimedia
      
    
          NIJ Journal
          Podcasts
          Publications Listing
          Multimedia Listing
          Rated Practices on CrimeSolutions
          Rated Programs on CrimeSolutions
          Software & Databases
          Datasets
          Patents
          Topics
        
                    
  
          Topics
      
    
          Article Listing
          Corrections
          Courts
          Crime Prevention
          Crimes
          Drugs and Crime
          Equipment and Technology
          Forensic Sciences
          Youth Justice
          Justice System Reform
          Law Enforcement
          Tribal Crime and Justice
          Victims of Crime
          Events
        
                    
  
          Events
      
    
          NIJ 2024 Research Conference
          Scheduled Events
          On-Demand Events
          Research Meetings & Workshops
          NIJ-Hosted Online Training

                            
                                About
          Contact Us
          Subscribe
          Topics A-Z
                  Share
FacebookXLinkedInRedditPinterestEmail Home
                            Library & Multimedia
 Making UCR Data Useful and Accessible
NCJ Number
              205171

Author(s)
          Michael D. Maltz;
                        Joseph Targonski
Date Published

February 2004
Length
              114 pages
Annotation
              This paper reports on how the Federal Bureau of Investigation’s (FBI) Uniform Crime Reporting (UCR) data were cleaned and gaps were accounted for, as well as how the data were made more accessible by combining the data from 1977 through 2000 into a single dataset.
Abstract
              FBI Uniform Crime Reporting data are widely used in decisions regarding the allocation of Federal funds and in varied types of research. However, UCR data may be problematic because gaps in the data exist that affect the accuracy of the analyses that had used the UCR. There were originally three goals of this project: (1) to clean and account for the gaps in the UCR data, and to annotate the data so that the type of problem each gap represented is indicated; (2) to make the data more accessible by combining data from 1977 through 2000; and (3) to develop and test methods of imputing the missing data. The first two goals are addressed in this paper; the first two goals proved so time consuming that the third goal was not attempted. The result is a set of 51 Excel files, 50 of which are State files containing annotated crime and ancillary information. Following an introduction in section 1, section 2 describes the data sources used to prepare the State UCR files, which were obtained primarily through the National Archives of Criminal Justice Data (NACJD). Section 3 describes the software used for preparing the crime data. SPSS database software was used to organize the data in preparation for exportation to Excel. Section 4 discusses the missing value codes used in the analysis of the UCR data, which involved the use of large negative numbers. Section 5 describes the procedures used to clean, analyze, and plot the data. After obtaining and aggregating the annual crime data files, the files were converted from SPSS to Excel. Next, the authors used exploratory data analysis techniques to identify gaps and anomalies in the data. Finally, section 6 offers a listing of additional tasks that should be undertaken in order to further enhance the monthly data series of Crime in the United States, including adding the ability to copy and plot the data onto another spreadsheet and developing a way to allocate statewide crime data to counties. Appendices include information on SPSS syntax for creating Excel files and the Microsoft Excel Visual Basic Macros used to clean the UCR crime data. Tables, figures, appendix
      
  
          Additional Details
Grant Number(s)
        2001-IJ-CX-0006


  
  
        
  Agencies
        NIJ-Sponsored


  
  
        
  Publication Type
        Research (Applied/Empirical)


  
  
        
  Award
        Enhancing Imputation Methodologies for County-Level UCR Data
    
  
  
Date Published: February 1, 2004
    
          Downloads
        
                      PDF

Side navigation
  

        

  
  
              NIJ Journal
    
      
            
            
            
      Podcasts
    
      
            
            
            
      Publications Listing
    
      
            
            
            
      Multimedia Listing
    
      
            
            
            
      Rated Practices on CrimeSolutions
    
      
            
            
            
      Rated Programs on CrimeSolutions
    
      
            
            
            
      Software & Databases
    
      
            
            
            
      Datasets
    
      
            
            
            
      PatentsRelated Topics
        
                Crime data files
        Data analysis
        Databases
        Justice system
        NIJ Grant-related Documents



  
Similar Publications
        
                      Analysis of Desomorphine in Urine Using Liquid Chromatography-Tandem Mass Spectrometry
                  Examining Officer Support for and Perceived Effects of Police Consolidation
                  Nanomanipulation-Coupled to Nanospray Mass Spectrometry Applied to Document and Ink Analysis
 Top

      National Institute of Justice

        
        
                        About NIJ
                    About NIJ
      
    
                  How NIJ Is Organized
      
    
                  NIJ Director
      
    
                  Research Disclaimer
      
    
                  Funding & Awards
                    Funding & Awards Home
      
    
                  Awards Listing
      
    
                  Current Funding
      
    
                  Guidance for Applicants and Awardees
      
    
                  Resources
                    Events
      
    
                  Podcasts
      
    
                  Publications
      
    
                  Topics
      
    
                  Multimedia
      
    
                  Reuse Policy
      
    
                  Contacts
                    Contact NIJ
      
    
                  Staff Directory
      
    
                  Submit a FOIA Request
      
    
                  File a Civil Rights ComplaintFacebook
          
                      X
          
                      YouTube
  

      810 7th St. NW, Washington, D.C. 20531
      
              Secondary Footer link menu
            Accessibility
              Plain Language
              Privacy Policy
              Legal Policies and Disclaimer
              No FEAR Act
              Freedom of Information Act
              USA.gov
              Justice.gov