{"main_topic":"health","sub_topic":"cdc_miov","topic":"firearm_deaths","key":"health/cdc_miov/firearm_deaths","version":"1.0.0","year_min":2019,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties"],"default_detail":"counties","path_template":"health/firearm_deaths/year={year}/{detail}.parquet","grain":["year","county_fips","tract_geoid"],"title":"Firearm Deaths","summary":"Firearm death rates per 100,000 (every intent) and deaths, by Georgia county, 2019-2024 (CDC MIOV).","description":"Firearm deaths of every intent (suicide, homicide, unintentional injury, legal intervention and undetermined) among the residents of each of Georgia's 159 counties, 2019-2024: CDC's crude death rate per 100,000 residents (the observed rate, or an estimate from CDC's Bayesian model with its 95% credible interval where the county had 1-9 deaths) and the number of deaths, from CDC's Mapping Injury, Overdose, and Violence (MIOV) dashboard (National Vital Statistics System death records). Counts of 1-9 are withheld by CDC. Firearm suicides and firearm homicides are also in suicide_deaths and homicide_deaths.","explorer":true,"search_aliases":{"en":["gun deaths","gun violence","shooting deaths","gunshot deaths","firearm suicide","gun suicides","firearm homicides","firearm mortality","death by gun","people dying from guns"],"es":["muertes por armas","muerte por arma","violencia con armas","tiroteos","suicidio con armas","homicidios con armas","defunciones por armas","mortalidad por armas","armas de fuego"]},"source":"Centers for Disease Control and Prevention, National Center for Injury Prevention and Control, Mapping Injury, Overdose, and Violence (MIOV), county dataset (data.cdc.gov psx4-wq38), based on National Center for Health Statistics National Vital Statistics System death records, as retrieved 2026-10-24; final annual data as of 2026-05-14","source_url":"https://www.cdc.gov/injury-violence-data/data-vis/index.html","endpoint":"/api/v1/health/firearm_deaths","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Calendar year of death (2019-2024), final as CDC publishes it. CDC's provisional trailing 12 months (June 2025 to May 2026) are not included.","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":false,"label":"County FIPS","short_description":"","description":"5-digit county FIPS code as published (FK to the counties dimension): the decedent's county of residence. Every row is a county; CDC publishes no Georgia total in this dataset.","valid_values":null,"example":"13121","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"tract_geoid","type":"string","role":"fk_tract","nullable":true,"label":"Tract GEOID","short_description":"","description":"Always NULL: this dataset is by county. Kept for the health domain's standard key shape.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":"Always NULL (county rows only).","key_metric_grain_contributor":false,"metric_component":null},{"name":"death_rate_per_100k","type":"number","role":"metric","nullable":true,"label":"Firearm Death Rate (per 100,000)","short_description":"Firearm deaths of any intent per 100,000 residents a year (crude); an estimate from CDC's model where the county had 1-9 deaths.","description":"Firearm deaths of any intent per 100,000 residents of the county in the year, crude (all ages, not age-adjusted), as CDC publishes it (rounded to 0.1). With 0 or 10 or more deaths it is the observed rate (deaths / population x 100,000; 0 with no deaths). With 1 to 9 deaths it is an estimate from CDC's Bayesian model, which borrows strength from neighboring counties to steady small counts and protect privacy (rate_modeled true), with a 95% credible interval: not deaths / population, and never 0. Rates never add or average across counties, and no population is published to weight them. Any intent: suicide, homicide, unintentional injury, legal intervention or undetermined. The highest is 65.4 (Jefferson County, 13163, 2022: 10 deaths), preserved as published: a few deaths in a small county give a high observed rate.","valid_values":null,"example":23.2,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"No rate: the county had 1 to 9 deaths (rate_modeled true) and CDC flags the modeled rate as unstable and does not publish it (-999 in the source). Never a zero.","key_metric_grain_contributor":false,"metric_component":null},{"name":"death_rate_per_100k_ci_lower","type":"number","role":"metric","nullable":true,"label":"Modeled Rate 95% Credible Interval Lower Bound","short_description":"","description":"Lower bound of the 95% credible interval of death_rate_per_100k, as CDC publishes it, for modeled rates only (rate_modeled true): under CDC's model, the true rate lies in the interval with 95% probability. Wide for small counties. The interval belongs to CDC's model estimate (rate_modeled true), not to an observed rate.","valid_values":null,"example":null,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"No interval: the rate is observed (rate_modeled false: 0 or 10 or more deaths), and CDC publishes credible intervals only for modeled rates; or the county had 1 to 9 deaths (rate_modeled true) and CDC flags the modeled rate as unstable and does not publish it or its interval (-999 in the source).","key_metric_grain_contributor":false,"metric_component":null},{"name":"death_rate_per_100k_ci_upper","type":"number","role":"metric","nullable":true,"label":"Modeled Rate 95% Credible Interval Upper Bound","short_description":"","description":"Upper bound of the 95% credible interval of death_rate_per_100k, as CDC publishes it, for modeled rates only (rate_modeled true). The interval belongs to CDC's model estimate (rate_modeled true), not to an observed rate.","valid_values":null,"example":null,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"No interval: the rate is observed (rate_modeled false: 0 or 10 or more deaths), and CDC publishes credible intervals only for modeled rates; or the county had 1 to 9 deaths (rate_modeled true) and CDC flags the modeled rate as unstable and does not publish it or its interval (-999 in the source).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_deaths","type":"integer","role":"metric","nullable":true,"label":"Deaths","short_description":"","description":"Number of firearm deaths of any intent among residents of the county in the year, as CDC publishes it: 0, or 10 and more; CDC withholds 1 to 9 (NULL here, rate_modeled true). A published 0 is a real zero. Adds across counties only where none is NULL, so a sum over counties with a NULL is an undercount: there is no Georgia total in this dataset. Firearm suicides and firearm homicides are counted here and again, as method 'firearm', in suicide_deaths and homicide_deaths, so never add counts across the MIOV topics.","valid_values":null,"example":250,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Withheld by CDC: the county had 1 to 9 deaths in the year (shown as '1-9'); its rate is CDC's modeled estimate (rate_modeled true). Never a zero, and never backed out of a total.","key_metric_grain_contributor":false,"metric_component":null},{"name":"rate_modeled","type":"boolean","role":"categorical","nullable":false,"label":"Rate Is Modeled","short_description":"True when the rate is CDC's model estimate (1-9 deaths, count withheld).","description":"CDC's modeled-rate flag (rate_m): true where the county had 1 to 9 deaths, so num_deaths is withheld and death_rate_per_100k is an estimate from CDC's Bayesian model with a 95% credible interval (rate and interval NULL where CDC flags the modeled rate as unstable and does not publish it, -999 in the source); false where the rate is observed (0 or 10 or more deaths). Describes the row, not part of its key.","valid_values":null,"example":false,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"death_rate_per_100k","numeric_filter_columns":["death_rate_per_100k","death_rate_per_100k_ci_lower","death_rate_per_100k_ci_upper","num_deaths"],"usage":"Compare counties or follow one county over 2019-2024 with death_rate_per_100k (firearm deaths of every intent); where rate_modeled is true it is an estimate from CDC's model for a county with 1-9 deaths, best read with its 95% credible interval (death_rate_per_100k_ci_lower, death_rate_per_100k_ci_upper). For firearm suicides or firearm homicides use method='firearm' in suicide_deaths or homicide_deaths; those deaths are also counted here, so never add figures across the MIOV topics. Do not add or average rates across counties (no population is published); there is no Georgia total in this table. num_deaths adds across counties only where none is NULL (1-9). Read directly with DuckDB over Parquet.","limitations":"Firearm deaths of every intent by county of residence: suicide, homicide, unintentional injury, legal intervention and undetermined intent. Counties with 1 to 9 deaths get a CDC model estimate in place of an observed rate (rate_modeled true), so many county rates are estimates. Firearm suicides and firearm homicides are also served, as method 'firearm', in suicide_deaths and homicide_deaths: each is counted both there and here, so never add figures across the MIOV topics. This total covers more intents than firearm suicides plus firearm homicides: where all three counts are published (172 county-years, 2019-2024) it is never below their sum, and of the 87 with any firearm death it exceeds the sum in 65 (by 1 to 10 deaths) and equals it in 22. Modeled rates come from separate model fits, so a modeled firearm suicide or homicide rate in suicide_deaths or homicide_deaths can exceed this total's rate (in 2 county-years: Terrell County 2023, firearm homicides 47.0 (modeled) against 39.2 (modeled) here; Columbia County 2019, firearm suicides 7.4 (modeled) against 7.0 (observed, 11 deaths) here); observed rates never do. No figure for the other intents is served: where any of the three counts is withheld, it would back that count out of the others. Where a county had 1 to 9 deaths CDC withholds the count (shown as '1-9': num_deaths NULL, never a zero, never backed out of a total) and publishes instead an estimate from its Bayesian model, which borrows strength from neighboring counties (rate_modeled true), with a 95% credible interval; a modeled rate is not deaths divided by population, and where CDC flags the modeled rate as unstable and does not publish it (-999 in the source) the rate and interval are NULL. 63% of county-years had 1-9 deaths (a modeled estimate, or no rate on 43). So county counts do not add up to a Georgia total, and rates cannot be pooled or averaged across counties from this table: no population is published, and modeled estimates are not deaths divided by population. This county dataset has no Georgia row (CDC publishes state totals in its separate MIOV state dataset, data.cdc.gov fpsi-y8tj, which is not part of this table). Rates are crude (deaths per 100,000 residents of all ages), not age-adjusted, so places with older or younger populations are not directly comparable. Final annual data as of 2026-05-14. Not included: CDC's provisional trailing 12 months (June 2025 to May 2026), which CDC revises and rolls forward monthly; every row here is a calendar year. The intents covered are from CDC's MIOV data dictionary (not part of this source file), which also holds the cause-of-death definitions. No breakdown by intent, demographics or nonfatal firearm injuries in this table. tract_geoid is always NULL.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2019,2020,2021,2022,2023,2024],"schema_hash":"60815cc0b3fff72f6c09a94ecdd6e46c83e862ba271741fc3df4af38826bde22","tags":["health","centers for disease control and prevention, national center for injury prevention and control, mapping injury, overdose, and violence","firearm_deaths"],"granularity_description":"One row per year, county_fips, tract_geoid.","example_queries":[{"description":"Latest year (2024), counties detail","query":"SELECT * FROM firearm_deaths WHERE year = 2024 LIMIT 100"},{"description":"Filter by rate_modeled = False","query":"SELECT * FROM firearm_deaths WHERE rate_modeled = 'False' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"tract_geoid","target_object":"tracts","target_columns":["tract_geoid"],"attribute_columns_added":["tract_name"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["counties"],"default":"counties"},{"param":"county_fips","kind":"foreign_key","column":"county_fips","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"tract_geoid","kind":"foreign_key","column":"tract_geoid","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"rate_modeled","kind":"categorical","column":"rate_modeled","type":"boolean","multi_value":true,"enum_enforced":false,"values":null,"has_total":false,"total_value":null,"requires_single_value":false,"nullable":false,"null_filter_token":null}],"filter_hints":[],"non_additive":[],"partitions":[],"value_implications":[],"year_meaning":null,"pooled_rates":[],"series_breaks":[],"year_window":null,"pooled_min_count":null,"values_endpoint":"/api/v1/health/firearm_deaths/values"}