Contract snapshot

meta:
  profile: charts_source
  category: crime-justice
  version: '1.0'
  title: Violent Crime Arrests
  info: Arrests for [[violent_crime|violent crimes]], by Florida county and year, with rates per 100,000 residents.
  tags:
  - violent crime
  - arrests
  - florida
  - county
  source:
    data_provider: Florida Department of Law Enforcement (FDLE)
    indicator_id: '9914'
    url: https://www.flhealthcharts.gov/ChartsDashboards/rdPage.aspx?rdReport=NonVitalIndNoGrp.Dataviewer&cid=9914
    name: Florida Health CHARTS
    publisher: Florida Department of Health
    update_frequency: annual
  methodology:
    counts: Arrests for [[violent_crime|violent crimes]]. Where an arrest resulted in more than one charge under a single crime category, it is counted once; an arrest may be counted under more than one of the crime categories.
    excludes: Records involving a notice to appear, direct files or sworn complaints where no physical arrest was made, unless fingerprints were taken at a later stage in the criminal justice process.
    limitations:
    - The [[variability_measure]] is not given for counts under 5, for populations under 20, or for suppressed values.
    - Do not use the [[variability_measure]] to compare two counties or two years.
    - Population, rate and [[variability_measure]] are empty when no county can be assigned, and on [[unallocated]] rows.
    - Population-based rates use July 1 population estimates from Florida’s Office of Economic and Demographic Research.
    - '[[fdle|FDLE]] does not warrant that the records are complete or accurate. They contain what contributing agencies reported to FDLE; errors brought to its attention are investigated and corrected as needed. The source advises caution in drawing conclusions from the data.'
    - All records, including those with unknown county, are part of the state total, so the state total may exceed the sum of the counties.
    reference_period: Arrests as recorded in FDLE's Computerized Criminal History as of July 1, 2024. [[fdle|FDLE]] updates the data for all years from 2001 annually.
    rules:
      parent_child_reconciliation:
        affects:
        - geography_name
        - arrests_count
        description: The source has a statewide row (geography_name = Florida). It is compared with the sum of all other rows of the same year, the counties, and then removed so it is not counted twice. If the statewide row is higher, the difference is published as an [[unallocated]] row. If it is lower, the table is not published.
tables:
  violent_crime:
    profile: county_count_rate
    columns:
      County:
        rename_to: geography_name
        cast_to: string
        meta:
          description: Florida county name, or the derived [[unallocated|Unallocated]] row.
      Count:
        rename_to: arrests_count
        cast_to: int
        meta:
          description: Arrests for violent crimes.
      Denom:
        rename_to: population_denominator
        cast_to: int
        meta:
          description: Estimated population used to calculate the rate.
      Rate:
        rename_to: arrests_per_100000_population
        cast_to: decimal(12,1)
        meta:
          description: Arrests for violent crimes per 100,000 residents.
      MOV:
        rename_to: rate_measure_of_variability
        cast_to: decimal(12,1)
        meta:
          description: '[[variability_measure|Measure of variability]] of the rate.'
      reporting_year:
        rename_to: reporting_year
        cast_to: int
        meta:
          description: Year the value refers to.
    parent_child_reconciliation:
      group_by:
      - reporting_year
      parent:
        column: geography_name
        equals: Florida
      measure_column: arrests_count
      residual:
        label_column: geography_name
        label_value: Unallocated
      remove_parent: true
      negative_difference: fail
    canonical_order:
    - geography_name
    - arrests_count
    - population_denominator
    - arrests_per_100000_population
    - rate_measure_of_variability
    - reporting_year
    display_name: Violent Crime Arrests by Florida County
    info: Annual county-level counts of violent crime arrests, population denominators, rates and measures of variability.

glossary:
  aggravated_assault:
    definition: An attack or threat of attack on another person with a weapon, or with any object used as one, that could cause great bodily injury. Hands, feet, teeth and other body parts do not count as weapons.
    label: Aggravated assault
    scope: source
  fdle:
    definition: Florida Department of Law Enforcement.
    label: FDLE
    scope: source
  larceny:
    definition: Unlawfully taking, carrying, or riding away with another person's property, for example pocket picking, purse snatching, shoplifting, or stealing from vehicles.
    label: Larceny
    scope: source
  murder:
    definition: One human killing another.
    label: Murder
    scope: source
  robbery:
    definition: Taking another person's property by force or fear, with the intent to deprive them of it permanently. Unlike [[larceny]], embezzlement and other theft, it uses force or the threat of force against the person who has the property.
    label: Robbery
    scope: source
  unallocated:
    definition: 'A row added by Metrka: the statewide total minus the sum of the counties. It is not a county.'
    label: Unallocated
    scope: metrka
  variability_measure:
    definition: How much a rate could change by chance. If a county rate differs from the statewide rate by more than this, the difference is statistically significant at the 5% level. Not given for small counts.
    label: Measure of variability
    scope: source
  violent_crime:
    definition: Includes [[murder]], rape, [[robbery]], and [[aggravated_assault|aggravated assault]].
    label: Violent crime
    scope: source