{"main_topic":"health","sub_topic":"dph","topic":"hiv_new_diagnoses","key":"health/dph/hiv_new_diagnoses","version":"1.0.0","year_min":2019,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","states"],"default_detail":"counties","path_template":"health/hiv_new_diagnoses/year={year}/{detail}.parquet","grain":["year","county_fips","tract_geoid"],"title":"New HIV Diagnoses","summary":"New HIV diagnoses per 100,000 residents and diagnoses, Georgia and its 159 counties, 2019-2024 (Georgia DPH HIV surveillance).","description":"New HIV diagnoses (any stage, including people first diagnosed at stage 3, AIDS) among Georgia residents in each calendar year 2019-2024, for Georgia and each of its 159 counties (the county of residence at diagnosis): the number of diagnoses and diagnoses per 100,000 residents, from the Georgia Department of Public Health's annual HIV Surveillance Summary Reports. DPH censors counts of 1 to 4 and calculates no rate under 12 diagnoses.","explorer":true,"search_aliases":{"en":["new HIV cases","HIV infections","newly diagnosed HIV","HIV incidence","AIDS cases","stage 3 HIV","HIV surveillance","infectious disease","DPH HIV report"],"es":["nuevos casos de VIH","infecciones por VIH","diagnósticos de VIH","enfermedades infecciosas","casos de SIDA","incidencia de VIH","vigilancia del VIH","enfermedad infecciosa","VIH etapa 3"]},"source":"Georgia Department of Public Health, HIV Epidemiology Unit, HIV Surveillance Summary Report, Georgia, 2019-2024 (annual PDF reports, from the enhanced HIV/AIDS Reporting System, eHARS): the county table (Table 29 in 2019-2022, Table 35 in 2023-2024), Table 1 and the general population table, as retrieved 2026-10-24","source_url":"https://dph.georgia.gov/epidemiology/hiv-epidemiology-unit/hiv-case-surveillance-and-care-continuum","endpoint":"/api/v1/health/hiv_new_diagnoses","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Calendar year of HIV diagnosis (2019-2024), each year as published in DPH's HIV Surveillance Summary Report for that year.","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":true,"label":"County FIPS","short_description":"","description":"5-digit county FIPS code (FK to the counties dimension): the county of residence DPH assigns. NULL on the Georgia (state) row.","valid_values":null,"example":"13121","unit":null,"value_min":null,"value_max":null,"null_meaning":"The Georgia (state) row.","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: DPH publishes these figures by county and for Georgia. 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 and state rows only).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_hiv_diagnoses","type":"integer","role":"metric","nullable":true,"label":"New HIV Diagnoses","short_description":"","description":"Number of people newly diagnosed with HIV in the year (any stage) whose address at diagnosis was in the county, or in Georgia on the state row, as DPH publishes it. DPH censors 1 to 4 (printed '<5'; NULL here); a published 0 is a real zero. Georgia row: Table 1's statewide total (the county table's 'Georgia (Total)' row in 2023-2024 is equal to it). County values add up only where none is NULL, and even then fall short of the Georgia row: some cases are assigned to no county.","valid_values":null,"example":481,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Censored by DPH: the county had 1 to 4 new diagnoses (printed '<5'). Never a zero, and never backed out of a total.","key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"hiv_diagnoses_per_100k","type":"number","role":"metric","nullable":true,"label":"New HIV Diagnoses per 100,000","short_description":"New HIV diagnoses per 100,000 residents in the year (crude). NULL under 12 diagnoses (DPH's rule; the rates DPH's 2019-2021 reports printed on 5-11 are removed). Georgia 2019-2022: our calculation from DPH's count and population.","description":"New HIV diagnoses per 100,000 residents in the year, crude (all ages, not age-adjusted), over DPH's population estimate for the same year (OASIS), rounded to 0.1. County rows: DPH's printed rate, published only where the county had 0 (rate 0.0) or at least 12 diagnoses. Georgia row: DPH's printed rate in 2023-2024; in 2019-2022, when the reports print no state rate, our calculation: Table 1's count / the Georgia population the same report prints x 100,000 (the same calculation reproduces DPH's 2023 and 2024 Georgia rates exactly). Rates never add or average across counties and no county population is published to weight them: the Georgia row is the statewide rate. Correctional facilities can inflate a county's rate. The highest is 112.6 (Butts County, 13035, 2022: 30 diagnoses), preserved as published.","valid_values":null,"example":44.1,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"No rate: DPH calculates none under 12 diagnoses, so the county had 1 to 11 (or a censored 1 to 4, num_hiv_diagnoses NULL). The 2019-2021 rates DPH printed on 5 to 11 are NULL here too, so every year follows the same rule. Never a zero.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"hiv_diagnoses_per_100k","numeric_filter_columns":["num_hiv_diagnoses","hiv_diagnoses_per_100k"],"usage":"Compare counties, or follow one county or Georgia over 2019-2024, with hiv_diagnoses_per_100k (NULL where DPH calculates no rate: 1 to 11 diagnoses, or a censored count). For Georgia use the state row (county_fips NULL): never add or average county rates (no county population is published), and county num_hiv_diagnoses values do not add up to it. The Georgia rate for 2019-2022 is our calculation from DPH's own count and population; 2023-2024 are DPH's. Read 2020 with caution (COVID-19 disrupted testing). Counties with prisons or the Stewart County immigration detention facility can have inflated rates. Read directly with DuckDB over Parquet.","limitations":"New HIV diagnoses by county of residence; 2020 is low because COVID-19 cut HIV testing, and the Georgia rate for 2019-2022 is our calculation. DPH censors counts of 1 to 4 (printed '<5': NULL here, never a zero or backed out of a total) and calculates no rate under 12 cases. People living in correctional facilities are included, which DPH warns may inflate rates where many inmates have HIV; in Stewart County many cases are associated with a federal immigration detention facility. Most counties have fewer than 12 diagnoses in a year, so no rate; DPH's 2019-2021 reports printed rates on counts of 5 to 11 anyway, and those are NULL here too, so every year follows the same rule. The Georgia row's count is DPH's statewide total (Table 1); its rate is DPH's for 2023-2024, and for 2019-2022, when DPH printed no state rate, it is our calculation: the count divided by the Georgia population the same report prints (OASIS), x 100,000, which reproduces DPH's 2023 and 2024 rates exactly. County figures do not add up to the Georgia row: censored counts are missing from any county sum, and some cases are assigned to no county (DPH does not say why). Rates are crude (diagnoses per 100,000 residents of all ages), not age-adjusted, and cannot be pooled or averaged across counties from this table (no county population is published): use the Georgia row for the state. A diagnosis depends on testing, so diagnoses are not new infections. Each year is as DPH's report for that year published it (DPH waits for late reports before publishing); later reports are not used to revise earlier years. DPH's statewide splits by gender identity, race and ethnicity, age and transmission category, and its late and stage 3 (AIDS) diagnoses, are not in this table (they carry no rates); people living with diagnosed HIV are the separate topic people_living_with_hiv. 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":"d3775c93c7985052da8ba83e6f752e6f4aff514ad412756ab9039ce8891df142","tags":["health","georgia department of public health, hiv epidemiology unit, hiv surveillance summary report, georgia, 2019-2024","hiv_new_diagnoses"],"granularity_description":"One row per year, county_fips, tract_geoid (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), counties detail","query":"SELECT * FROM hiv_new_diagnoses WHERE 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","states"],"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}],"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/hiv_new_diagnoses/values"}