 |
|
 |
 |
|
 |
|||||||
 |
|||||||||
FY02 Hawaii
1) Listing of Local Units of Government
- Download Spreadsheet File (xls format)
- What is a Local Unit of Government?
Technical Information for Configuring Your Browser to View Excel Files
2) Formula Calculations
- Local allocations for each state are provided based on a 75% pass-through of the state's
allocated funds. The spreadsheets are in Excel, and must be downloaded to be used.
Most spreadsheet programs (Lotus, QuattroPro) should be able to open these
spreadsheets. If you have difficulties opening or working with these files, please
e-mail us at jaibg@jrsa.org, and we will work with you
to produce the spreadsheets in a format compatible with the software available to you.
Three different files are available. The first does the formula calculations, and the other three summarize the resulting allocations. To download the spreadsheets, select a link below:
- JABG Formula Calculations Now Includes 2000 Crime Data!
- This spreadsheet calculates local allocations based on a 75% pass-through amount. You
can change the pass-through percentage, and the spreadsheet will automatically recalculate
the local allocations. Go to Definitions of
Terms and Formulas for an explanation of the entries in this spreadsheet.
- List of Localities and Allocations, Listed by Amount
- This file provides a list of locality names and allocation amounts, listed in descending
order of allocation amount.
- List of Localities and Allocations, Listed by Locality
- This file provides a list of locality names and allocation amounts, listed in
alphabetical order.
3) Combined Data File
- Download Master Data File (.xls format)
- This data file provides a spreadsheet of combined FBI UCR Part 1 Violent Offenses from 1990 to 2000 and 1997 Census Bureau Expenditure Data, matched for each locality using FBI and Census Bureau ID numbers.
4) FBI UCR Crime Data
- Download 2000 FBI UCR Crime Data (.xls format)
Download 1999 FBI UCR Crime Data (.xls format)
Download 1998 FBI UCR Crime Data (.xls format)
Download 1997 FBI UCR Crime Data (.xls format)
Download 1996 FBI UCR Crime Data (.xls format)
Download 1995 FBI UCR Crime Data (.xls format)
Download 1994 FBI UCR Crime Data (.xls format)
View Population Codes
Technical Information for Configuring Your Browser to View Excel Files
5) Census Bureau Expenditure Data
- Download 1997 Census of Governments Data (.xls format)
(.xls format)
Download a Listing of Localities with Imputed 1997 Data (.xls format) - For a discussion of imputed data, see Expenditure Methodology.
- Download 1996 Public Finances Data (.xls format)
Download 1995 Public Finances Data (.xls format)
Download 1994 Public Finances Data (.xls format)
Download 1993 Public Finances Data (.xls format)
Download 1992 Census of Governments Data (.xls format)
Download a Listing of Localities with Imputed 1992 Data (.xls format) - For a discussion of imputed data, see Expenditure Methodology.
- Technical Information for Configuring Your Browser to View Excel Files
- 6) Listing of Federally-Recognized Indian Tribes
- This is a listing of Indian Tribes for the state. For a complete listing of Federally-Recognized Indian Tribes for all states, download here. Note - this is a large file and may take up to five minutes to download.
- 7) BIA Annual Law Enforcement Program Report Data (.xls format)
- JRSA obtained the raw BIA expenditure and crime data for 1996 through 2000. These
data are presented by agency in a spreadsheet. States have the option of using the
data in the formula calculations or separately. If you would like to see data
aggregated by tribe, or would like this data incorporated into the allocation
spreadsheets, please contact JRSA. For more
information on these data, see FAQs: Tribal Data.
For the full dataset for all states, download here.
[JABG Technical Support Center Home] [jaibg@jrsa.org] [JRSA Home]