Contract snapshot

meta:
  profile: charts_source
  version: '1.0'
  title: Motor Vehicle Traffic Crashes
  info: '[[motor_vehicle_crash|Motor vehicle crashes]], by Florida county and year, with rates per 100,000 residents.'
  tags:
  - traffic crashes
  - florida
  - county
  source:
    data_provider: Florida Department of Highway Safety and Motor Vehicles (HSMV)
    indicator_id: '0301'
    url: https://www.flhealthcharts.gov/ChartsDashboards/rdPage.aspx?rdReport=NonVitalIndNoGrp.Dataviewer&cid=0301
    name: Florida Health CHARTS
    publisher: Florida Department of Health
    update_frequency: annual
  methodology:
    counts: '[[motor_vehicle_crash|Motor vehicle crashes]].'
    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.
    - 2016 data is as of June 30, 2017.
    rules:
      parent_child_reconciliation:
        affects:
        - geography_name
        - crashes_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.
  category: health-medicine
tables:
  motor_vehicle_traffic_crashes:
    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: crashes_count
        cast_to: int
        meta:
          description: Motor vehicle crashes.
      Denom:
        rename_to: population_denominator
        cast_to: int
        meta:
          description: Estimated population used to calculate the rate.
      Rate:
        rename_to: crashes_per_100000_population
        cast_to: decimal(12,1)
        meta:
          description: Motor vehicle crashes 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: crashes_count
      residual:
        label_column: geography_name
        label_value: Unallocated
      remove_parent: true
      negative_difference: fail
    canonical_order:
    - geography_name
    - crashes_count
    - population_denominator
    - crashes_per_100000_population
    - rate_measure_of_variability
    - reporting_year
    display_name: Motor Vehicle Traffic Crashes by Florida County
    info: Annual county-level counts of motor vehicle traffic crashes, population denominators, rates and measures of variability.

glossary:
  motor_vehicle_crash:
    definition: A crash involving at least one motor vehicle on a roadway open to the public.
    label: Motor vehicle crash
    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