Contract snapshot

meta:
  profile: charts_source
  category: crime-justice
  version: '1.0'
  title: Murder Arrests
  info: Arrests for [[murder]], by Florida county and year, with rates per 100,000 residents.
  tags:
  - murder
  - arrests
  - florida
  - county
  source:
    data_provider: Florida Department of Law Enforcement (FDLE)
    indicator_id: '0305'
    url: https://www.flhealthcharts.gov/ChartsDashboards/rdPage.aspx?rdReport=NonVitalIndNoGrp.Dataviewer&cid=0305
    name: Florida Health CHARTS
    publisher: Florida Department of Health
    update_frequency: annual
  methodology:
    counts: Arrests for [[murder]]. Each arrest is counted once, however many murder charges it has. If an arrest also has a charge in another crime category, it is counted there too.
    excludes:
    - Attempted murder, which falls under [[aggravated_assault|aggravated assault]].
    - 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:
  murder:
    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 murder.
      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 murder 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: Murder Arrests by Florida County
    info: Annual county-level counts of murder 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
  murder:
    definition: One human killing another.
    label: Murder
    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