Dataset 311

From Data-gov Wiki

Jump to: navigation, search

Contents

Description

Dataset 311 is divided into several excel tables. Some contains the same information at different levels of aggregation (such as State, county city, etc...)

Tables

We show details of each table parsed that are not converted into RDF:

07tbl01 - Crime in the United States by Volume and Rate per 100,000 Inhabitants, 1988–2007

In column "Population" there is a footnote:

 1 Population figures are U.S. Census Bureau provisional estimates as of July 1 for each year except 1990 and 2000, which are decennial census counts.

In row "2001" there is a footnote:

  2 The murder and nonnegligent manslaughters that occurred as a result of the events of September 11, 2001, are not included in this table.

In row "2006" there is a note:

  3 The 2006 figures have been adjusted since publication of Crime in the United States, 2006.NOTES: .
Metadata
RDF data
Links


At the bottom there is a note:

   NOTE:  Although arson data are included in the trend and clearance tables, sufficient data are not available to estimate totals for this offense.  Therefore, no arson data are published in this table.

Finally, Table 1A "Crime in the United States" indicates "Percent Change in Volume and Rate per 100,000 Inhabitants for 2 years, 5 years, and 10 years" comparing year 2007 to 2006, 2003 and 1997.


07tbl02 - Crime in the United States by Community Type

Not yet parsed.

07tbl03 - Crime in the United States Offense and Population Percent Distribution by Region, 2007

Not yet parsed.

07tbl04 - Crime in the United States by Region, Geographic Division, and State, 2006–2007

  • Percent changes are not parsed
  • Column "Population" contains footnote 1.
  • Row "United States Totals" contains footnotes 2,3, 4 and 5
  • Rows "Northeast", "Middle Atlantic", "New Jersey", "West South central", "Louisiana", "West", "Pacific" and "California" contains footnote 2.
  • Rows "Midwest", "East North Central", "Illinois" contains footnote 3,4
  • Rows "West North Central", "Minnesota" contains footnote 4
  • Row "South" contains footnotes 2, 5
  • Rows "South Atlantic", "District of Columbia" contains footnote 5
  • Some values less that one-tenth of 1 percent are shown as *
 1 Populations are U.S. Census Bureau provisional estimates as of July 1, 2007, and July 1, 2006. 
 2 The 2006 crime figures have been adjusted.    
 3 Limited data for 2006 and 2007 were available for Illinois. 
 4 The data collection methodology for the offense of forcible rape used by the Illinois and the Minnesota state UCR Programs (with the exception of Rockford, Illinois, and Minneapolis and St. Paul, Minnesota) does not comply with national UCR guidelines.  Consequently, their state figures for forcible rape (with the exception of Rockford, Illinois, and Minneapolis and St. Paul, Minnesota) have been estimated for inclusion in this table.   
 5 Includes offenses reported by the Zoological Police and the Metro Transit Police.
 * Less than one-tenth of 1 percent.
 NOTE:  Although arson data are included in the trend and clearance tables, sufficient data are not available to estimate totals for this offense.  Therefore, no arson data are published in this table.


07tbl05 - Crime in the United States by State, 2007

Parsed only "Estimated Totals" for every state.

07tbl06 - Crime in the United States by Metropolitan Statistical Area, 2007

Not yet parsed

07tbl07 - Offense Analysis United States, 2003–2007

Not yet parsed

07tbl08 - Offenses Known to Law Enforcement by State by City, 2007

  • Column "Arson" contains footnote 1.
  • "Mobile, Alabama" contains footnote 2.
  • "Chino Valley, Arizona", "Sahuarita, Arizona", "Eureka, California", "Greenfield, California", "Grover Beach, "California", "Rio Vista, California", "Soledad, California", "Carrollton, Georgia", "Palmetto, Georgia", "St. Marys, Georgia", "Holly Springs, Mississippi", "Mount Holy, North Carolina", "Choctaw, Oklahoma", "Faifax, Oklahoma", "Heavener, Oklahoma", "Stilwell, Oklahoma" contains footnote 3.
  • "Tucson, Arizona", "Great Bend, Kansas", "Radcliff, Kentucky", "Warren, Michigan", "Mclaughlin, South Dakota" contains footnote 4.
  • "Tulare, California", "Buena Vista, Georgia", "Dalton, Georgia", "Covington, Kentucky", "South Brunswick Township, New Jersey" contains footnote 5.
  • "Illinois", "Minnesota" contains footnote 6.
  • "Rockford, Illinois", "East Chicago, Illinois", "Greendale, Illinois", "Knox, Illinois", "Marion, Illinois", "Cambridge, Massachusetts", "Greenville, Mississippi", "Las Cruces, New Mexico", "Sunland Park, New Mexico",

"Providence, Rhode Island", "Tacoma, Washington" contains footnote 7.

  • "Auburn, Massachusetts", "Avon, Massachusetts", "Brockton, Massachusetts", "Carver, Massachusetts", "Fitchburg, Massachusetts", "Greenfield, Massachusetts", "Hanson, Massachusetts", "Hinsdale, Massachusetts", "Leominster, Massachusetts", "Millbury, Massachusetts", "North Brookfield, Massachusetts", "Southampton, Massachusetts", "Westfield, Massachusetts", "Yarmouth, Massachusetts" contains footnote 8.
 1 The FBI does not publish arson data unless it receives data from either the agency or the state for all 12 months of the calendar year.
 2 The population for the city of Mobile, Alabama, includes 61,856 inhabitants from the jurisdiction of the Mobile County Sheriff's Department.												
 3 The FBI determined that the agency's data were overreported.  Consequently, affected data are not included in this table.												
 4 It was determined that the agency did not follow national Uniform Crime Reporting (UCR) Program guidelines for reporting an offense.  Consequently, this figure is not included in this table.  												
 5 The FBI determined that the agency's data were underreported.  Consequently, affected data are not included in this table.												
 6 The data collection methodology for the offense of forcible rape used by the Illinois and the Minnesota state UCR Programs (with the exception of Rockford, Illinois and Minneapolis and St. Paul, Minnesota) does not comply with national UCR Program guidelines.  Consequently, their figures for forcible rape and violent crime (of which forcible rape is a part) are not published in this table.												
 7 Because of changes in the state/local agency's reporting practices, figures are not comparable to previous years' data.												
 8 The data collection methodology for the offense of aggravated assault used by this agency does not comply with national UCR Program guidelines.  Consequently, the figures for aggravated assault and violent crime (of which aggravated assault is a part) are not included in this table.

07tbl09 - Offenses Known to Law Enforcement by State by University and College, 2007

  • Deleted colons (:) from university names
  • Column "Student enrollment" contains footnote 1.
  • Column "Arson" contains footnote 2.
  • Cell "California - California State University - San Jose", "California, University of California - Medical Center, Sacramento", "Colorado - University of Colorado - Health Sciences Center", "Colorado - University of Colorado - Health Sciences Center, Fitzsimons Campus", "Connecticut - University of Connecticut - Health Center", "Connecticut - University of Connecticut - Storrs, Avery Point, and Hartford", "Florida - Florida State University - Panama City", "Florida - University of South Florida - St. Petersburg", "Indiana - Indiana University - Indianapolis", "Louisiana - Louisiana State University - Baton Rouge", "Massachusetts - "Tuffts University - Suffolk", "Massachusetts - "Tuffts University - Worcester", "New Jersey - University of Medicine and Dentistry - Camden", "New Jersey - University of Medicine and Dentistry - New Brunswick", "New Jersey - University of Medicine and Dentistry - Piscataway", "New York - State University of New York - Downstate Medical Center", "New York - State University of New York - Upstate Medical Center", "New York - State University of New York Agricultural and Technical College - Farmingdale", "New York - State University of New York Agricultural and Technical College - Morrisville", "Oklahoma - Oklahoma State University - Tulsa", "Pennsylvania - Pennsylvania State University - McKeesport", "Tennessee - University of Tennessee - Memphis", "Texas - Alamo Community College District", "Texas - Baylor Health Care System", "Texas - University of Texas - Health Science Center, Tyler", "Texas - University of Texas - Houston", "Washington - Washington State University - Vancouver" contains footnote 3.
  • "Minnessota" contains footnote 4.
  • "Oklahoma - East Central University" contains footnote 5.
 1 The student enrollment figures provided by the United States Department of Education are for the 2006 school year, the most recent available.  The enrollment figures include full-time and part-time students.
 2 The FBI does not publish arson data unless it receives data from either the agency or the state for all 12 months of the calendar year.
 3 Student enrollment figures were not available.
 4 The data collection methodology for the offense of forcible rape used by the Minnesota state Uniform Crime Reporting (UCR) program does not comply with national UCR guidelines.  Consequently, their figures for forcible rape and violent crime (of which forcible rape is a part) are not published in this table.
 5 The FBI determined that the agency's data were overreported.  Consequently, affected data are not included in this table.
 NOTE:  Caution should be exercised in making any intercampus comparisons or ranking schools because university/college crime statistics are affected by a variety of factors.  These include demographic characteristics of the surrounding community, ratio of male to female students, number of on-campus residents, accessibility of the campus to outside visitors, size of enrollment, etc.

07tbl10 - Offenses Known to Law Enforcement by State by Metropolitan and Nonmetropolitan Counties, 2007

  • Modified strange character in alabama fields
  • Column "Arson" contians footnote 1.
  • "Cochise, Arizona" "Montgomery, Mississippi" contains footnote 2.
  • "Tulare, California" contains footnote 3.
  • "Plumas, California", "Nassau, Florida", "Lamar Georgia", "Walton, Georgia", "Sandoval, New Mexico", "Otero, New Mexico", "Davie, North Carolina", "Sequoyah, Oklahoma", "Pontotoc, Oklahoma" contains footnote 4.
  • "Gilchrist Florida", "Effingham, Georgia", "Cass, Minnessota", "White Pine, Nevada", "Pender, North Carolina" contains footnote 5.
  • "Noble, Indiana", "Wayne, Michigan", "Oktibbeha, Mississippi", "Moniteau, Missouri", "Cibola, New Mexico", "Pierce, Washington" contains footnote 6.
  • "Minnessota-Metropolitan Counties", "Minnessota-Nonmetropolitan Counties" contains footnote 7.
 1 The FBI does not publish arson data unless it receives data from either the agency or the state for all 12 months of the calendar year.
 2 It was determined that the agency did not follow national Uniform Crime Reporting (UCR) Program guidelines for reporting an offense.  Consequently, this figure is not included in this table.
 3 The motor vehicle thefts for this county are collected by the Tulare County Highway Patrol.  These data can be found in Table 11.
 4 The FBI determined that the agency's data were overreported.  Consequently, affected data are not included in this table.
 5 The FBI determined that the agency's data were underreported.  Consequently, affected data are not included in this table.
 6 Because of changes in the state/local agency's reporting practices, figures are not comparable to previous years' data.
 7 The data collection methodology for the offense of forcible rape used by the Minnesota state UCR Program does not comply with national UCR Program guidelines.  Consequently, its figures for forcible rape and violent crime (of which forcible rape is a part) are not published in this table.

07tbl11 - Offenses Known to Law Enforcement by State by State Agency and Other Agencies, 2007

Not yet parsed.

07tbl12 - Crime Trends by Population Group, 2006–2007

  • Percent changes not parsed
  • "Nonmetropolitan counties" contains footnote 1.
  • "Suburban area" contains footnote 2.
 1 Includes state police agencies that report aggregately for the entire state.
 2 Suburban area includes law enforcement agencies in cities with less than 50,000 inhabitants and county law enforcement agencies that are within a Metropolitan Statistical Area.  Suburban area excludes all metropolitan agencies associated with a principal city.  The agencies associated with suburban areas also appear in other groups within this table.
 * Less than one-tenth of 1 percent.

07tbl13 - Crime Trends by Suburban and Nonsuburban Cities1 by Population Group, 2006–2007

  • Percent changes not parsed
  • Title contains footnote 1
 1 Suburban cities include law enforcement agencies in cities with less than 50,000 inhabitants that are within a Metropolitan Statistical Area.  Suburban cities exclude all metropolitan agencies associated with a principal city.  Nonsuburban cities include law enforcement agencies in cities with less than 50,000 inhabitants that are not associated with a Metropolitan Statistical Area.
 * Less than one-tenth of 1 percent.

07tbl14 - Crime Trends by Metropolitan and Nonmetropolitan Counties1 by Population Group, 2006–2007

Not yet parsed

07tbl15 - Crime Trends Additional Information About Selected Offenses by Population Group, 2006–2007

Not yet parsed

07tbl16 - Rate: Number of Crimes per 100,000 Inhabitants by Population Group, 2007

Not yet parsed

07tbl17 - Rate: Number of Crimes per 100,000 Inhabitants by Suburban and Nonsuburban Cities1 by Population Group, 2007

Not yet parsed

07tbl18 - Rate: Number of Crimes per 100,000 Inhabitants by Metropolitan and Nonmetropolitan Counties1 by Population Group, 2007

Not yet parsed

07tbl19 - Rate: Number of Crimes per 100,000 Inhabitants Additional Information About Selected Offenses by Population Group, 2007

Not yet parsed

07tbl20 - Murder by State, Type of Weapon, 2007

  • "Total Murders" column contains footnote 1
  • "Hands, fists, feet, etc." column contains footnote 2
  • "Illinois" row contains footnote 3
 1 Total number of murders for which supplemental homicide data were received.
 2  Pushed is included in hands, fists, feet, etc.
 3 Limited supplemental homicide data were received.

07tbl21 - Robbery by State, Type of Weapon, 2007

  • "Total robberies" column contains footnote 1.
  • "Rows "Distrcit of Columbia" and "Illinois" contains footnote 2.
 1 The number of robberies for which breakdowns by type of weapon were received from agencies that submitted 12 months of data in 2007.
 2 Limited data were received.


07tbl22 - Aggravated Assault by State, Type of Weapon, 2007

  • "Total aggravated assaults" column contains footnote 1.
  • "Rows "Distrcit of Columbia" and "Illinois" contains footnote 2.
 1 The number of aggravated assaults for which breakdowns by type of weapon were received from agencies that submitted 12 months of data in 2007.
 2 Limited data were received.

07tbl23 - Offense Analysis, Number and Percent Change, 2006–2007

  • "Percent distribution" column contains footnote 1.
  • Added the field name "Subclassification" on column B
 1 Because of rounding, the percentages may not add to 100.0.


07tbl24 - Property Stolen and Recovered, by Type and Value, 2007

07tbl25 - Percent of Offenses Cleared by Arrest or Exceptional Means, by Population Group, 2007

  • "Arson" column contains footnote 1.
  • "SUBURBAN AREA" cell contains footnote 2.
  • Added name "type" to column B.
 1 Not all agencies submit reports for arson to the FBI.  As a result, the number of reports the FBI uses to compute the percent of offenses cleared for arson is less than the number it uses to compute the percent of offenses cleared for all other offenses.													
 2 Suburban area includes law enforcement agencies in cities with less than 50,000 inhabitants and county law enforcement agencies that are within a Metropolitan Statistical Area.  Suburban area excludes all metropolitan agencies associated with a principal city.  The agencies associated with suburban areas also appear in other groups within this table.

07tbl26 - Percent of Offenses Cleared by Arrest or Exceptional Means, by Geographic Region and Division, 2007

  • Cell "Arson" contains footnote 1.
  • Added name "type" to column B.
  • Changed slash (/) to "or" in column A header.
 1 Not all agencies submit reports for arson to the FBI.  As a result, the number of reports the FBI uses to compute the percent of offenses cleared for arson is less than the number it uses to compute the percent of offenses cleared for all other offenses.

07tbl27 - Percent of Offenses Cleared by Arrest or Exceptional Means, Additional Information About Selected Offenses, by Population Group 2007

  • Cell "Arson" contains footnote 1.
  • "SUBURBAN AREA" cell contains footnote 2.
  • Added name "type" to column B.
  • Modified table to reflect supercategories (such as "Forcible Rape") in predicates
 1 Not all agencies submit reports for arson to the FBI.  As a result the number of reports the FBI uses to compute the percent of offenses cleared for arson is less than the number it uses to compute the percent of offenses cleared for all other offenses.  Agencies must report arson clearances by detailed property classification as specified on the Monthly Return of Arson Offenses Known to Law Enforcement to be included in this table; therefore clearances in this table may differ from other clearance tables.
 2 Suburban area includes law enforcement agencies in cities with less than 50000 inhabitants and county law enforcement agencies that are within a Metropolitan Statistical Area.  Suburban area excludes all metropolitan agencies associated with a principal city.  The agencies associated with suburban areas also appear in other groups within this table.


07tbl28 - Number of Offenses Cleared by Arrest or Exceptional Means, Percent of Clearances Involving Persons Under 18 Years of Age, by Population Group, 2007

  • Cell "Arson" contains footnote 1.
  • Added name "type" to column B.
 1 Not all agencies submit reports for arson to the FBI.  As a result, the number of reports the FBI uses to compute the percent of offenses cleared for arson is less than the number it uses to compute the percent of offenses cleared for all other offenses.													
 2 Suburban area includes law enforcement agencies in cities with less than 50,000 inhabitants and county law enforcement agencies that are within a Metropolitan Statistical Area.  Suburban area excludes all metropolitan agencies associated with a principal city.  The agencies associated with suburban areas also appear in other groups within this table.

07tbl29 - Estimated Number of Arrests, United States, 2007

  • Cell "Total" contains footnote 1
  • Cells "Violent crime" and "Property crime" contains footnote 2.
  • Added name "type" to column A.
 1 Does not include suspicion.	
 2 Violent crimes are offenses of murder and nonnegligent manslaughter, forcible rape, robbery, and aggravated assault.  Property crimes are offenses of burglary, larceny-theft, motor vehicle theft, and arson.


07tbl30 - Number and Rate of Arrests, by Region 2007

Not yet parsed.

07tbl31 - Number and Rate of Arrests, by Population Group, 2007

Not yet parsed.

Facts about Dataset 311RDF feed
92/additional metadatahttp://www.fbi.gov/ucr/cius2007/about/index.html  +
92/agencyDepartment of Justice  +
92/agency data series pagehttp://www.fbi.gov/ucr/cius2007/documents/index.html  +
92/agency program pagehttp://www.fbi.gov/ucr/ucr.htm  +
92/applicable agency information quality guideline designationFBI
92/categoryLaw Enforcement, Courts, and Prisons  +
92/citationSource: United States Department of Justice, Federal Bureau of Investigation. (September 2008). Crime in the United States, 2007. Retrieved (insert date), from http://www.fbi.gov/ucr/cius2007/index.html.  +
92/collection modeother
92/data collection instrumenthttp://www.fbi.gov/ucr/ucr.htm
92/data dictionary variable listhttp://www.fbi.gov/ucr/cius2007/about/index.html  +
92/data gov data category typeRaw Data Catalog  +
92/data quality certificationYes  +
92/date releasedSep-08  +
92/date updatedSep-08  +
92/descriptionExtraction of offense, arrest, and clearance data as well as law enforcement staffing information from the FBI's Uniform Crime Reporting (UCR) Program.
92/frequencyAnnual  +
92/geographic coverageNation, State, Region, City, County, MSA,
92/granularityCity  +
92/keywordsFBI, Crime in the United States, Violent Crime, Murder, Forcible Rape, Robbery, Aggravated Assault, Property Crime, Burglary, Larceny Theft, Motor Vehicle Theft, Arson, Clearances, Arrests, Police Employees
92/privacy and confidentialityYes  +
92/specialized data category designationStatistical
92/subagencyFederal Bureau of Investigation  +
92/technical documentationhttp://www.fbi.gov/ucr/cius2007/about/table_methodology.html
92/time periodJanuary 2007 through December 2007
92/title2007 Crime in the United States  +
92/unique id311  +
92/unit of analysisOffense, arrest, clearance, or person (person is unit of count for police employee)
92/urlhttp://www.data.gov/details/311  +
92/xls access pointhttp://www2.fbi.gov/ucr/cius2007/documents/cius2007datatables.zip  +
92/xls file size3.2 MB  +
Datagov id311  +
Dc:identifierdgtwc311  +
Dcterms:identifierdgtwc311, and datagov311
Dcterms:publisherDepartment of Justice  +
Dcterms:relationURLSHA1/fef8ac69ad5f0ab6db699e29e9691ca57bdb36b3  +
Dcterms:sourcehttp://data-gov.tw.rpi.edu/raw/92/data-92.rdf#entry311  +
Dcterms:subjectFBI  +, Crime in the United States  +, Violent Crime  +, Murder  +, Forcible Rape  +, Robbery  +, Aggravated Assault  +, Property Crime  +, Burglary  +, Larceny Theft  +, Motor Vehicle Theft  +, Arson  +, Clearances  +, Arrests  +, and Police Employees  +
Dgtwc:linked data entry pointHttp://data-gov.tw.rpi.edu/vocab/Dataset 311  +
Dgtwc id311  +
Foaf:name2007 Crime in the United States
Has demoDemo: US and UK Crime Data  +
Personal tools
internal pages