{"main_topic":"health","sub_topic":"dph","topic":"child_immunization_coverage","key":"health/dph/child_immunization_coverage","version":"1.0.0","year_min":2018,"year_max":2025,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","states"],"default_detail":"counties","path_template":"health/child_immunization_coverage/year={year}/{detail}.parquet","grain":["year","county_fips","tract_geoid","race","ethnicity","age_bracket","insurance_type","vaccine"],"title":"Child Immunization Coverage (19-35 Months)","summary":"Share of Georgia children aged 19-35 months up to date on each vaccine and the 7-vaccine series, by county and statewide group.","description":"The share of Georgia children aged 19 through 35 months who are up to date on each recommended vaccine (DTaP, polio, MMR, Hib, hepatitis B, varicella, pneumococcal, hepatitis A, rotavirus) and on the combined 7-vaccine series, from the Georgia Department of Public Health's annual coverage studies of the GRITS immunization registry, report years 2018-2025. Statewide and for all 159 counties, plus statewide breakdowns by race, ethnicity, age band and insurance type. A child is up to date when every dose was correctly given by 36 months of age. County figures cover only children with a Georgia address in the registry, about half of them.","explorer":true,"search_aliases":{"en":["childhood vaccines","baby shots","toddler vaccination","MMR vaccine","DTaP vaccine","chickenpox vaccine","vaccines by insurance","uninsured kids vaccines","GRITS registry"],"es":["vacunas infantiles","vacunas de bebés","vacunación infantil","vacuna triple viral","vacuna DTaP","vacuna de la varicela","vacunas por seguro","registro GRITS","asegurados y sin seguro","vacunas de niños"]},"source":"Georgia Department of Public Health, Immunization Program: Child Immunization Report (children 19-35 months, from the Georgia Registry of Immunization Transactions and Services, GRITS), report years 2018-2025, as retrieved 2026-10-24","source_url":"https://dph.georgia.gov/immunizations/immunization-data","endpoint":"/api/v1/health/child_immunization_coverage","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"DPH report year: the year the cohort of children was 19 through 35 months old (see year_meaning for the birth window and the 36-month rule).","valid_values":null,"example":2025,"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, matched from DPH's county name through the counties dimension: the county of the first complete Georgia address on the child's registry record. NULL on statewide rows. Children with no Georgia address (DPH's 'unknown' county, 44-48% of each year's children) have no county row and are counted in the statewide rows only.","valid_values":null,"example":"13121","unit":null,"value_min":null,"value_max":null,"null_meaning":"Statewide row (Georgia as a whole).","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 state and county figures only. 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 (no tract figures in the source).","key_metric_grain_contributor":false,"metric_component":null},{"name":"race","type":"string","role":"categorical","nullable":false,"label":"Race","short_description":"DPH race group (any ethnicity: each includes Hispanic children); 'all' is every child.","description":"Child's race as recorded in GRITS, DPH's statewide race table (topic-specific, not the shared demographic axis): white, black (Black or African American), asian, native_american (American Indian or Alaska Native), pacific_islander (Native Hawaiian or Other Pacific Islander), other (Other Race) and unknown; 'all' is every child. Each race group includes Hispanic children (white is White of any ethnicity, not non-Hispanic White), so a race group is never added to or compared as a share with the ethnicity column's 'hispanic'. The groups are mutually exclusive and their counts sum to the 'all' total. DPH publishes no two-or-more-races group. Statewide rows only; every county row and every non-race statewide row is 'all'.","valid_values":["all","white","black","asian","native_american","pacific_islander","other","unknown"],"example":"black","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"ethnicity","type":"string","role":"categorical","nullable":false,"label":"Ethnicity","short_description":"Hispanic or Latino, not Hispanic, or unknown; 'all' is every child.","description":"Child's ethnicity as recorded in GRITS, DPH's statewide ethnicity table: hispanic (Hispanic or Latino, of any race), not_hispanic and unknown; 'all' is every child. Separate from race (DPH never crosses them): a Hispanic child is also in one of the race groups. The three groups are mutually exclusive and sum to 'all'. Statewide rows only; every other row is 'all'.","valid_values":["all","hispanic","not_hispanic","unknown"],"example":"hispanic","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"age_bracket","type":"string","role":"categorical","nullable":false,"label":"Age Band","short_description":"Child's age band, 19-24 or 25-35 months; 'all' is every child.","description":"Child's age band as DPH publishes it: 19_24_months (19 through 24 months) or 25_35_months (25 through 35 months, about four in five children); 'all' is every child. The report does not say on which date age is measured. The two bands are mutually exclusive and sum to 'all'. Statewide rows only; every other row is 'all'.","valid_values":["all","19_24_months","25_35_months"],"example":"25_35_months","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"insurance_type","type":"string","role":"categorical","nullable":false,"label":"Insurance Type","short_description":"Who covered the child's vaccine doses; any_public_insurance overlaps only_public and multiple_insurance_types.","description":"How the child's vaccine doses were covered, in DPH's words (statewide insurance table): only_public (public insurance only: Medicaid, PeachCare, and insurance for American Indians and Alaska Natives), only_private (any non-public insurance), multiple_insurance_types (some doses covered by private insurance and some by public), only_insured_without_vaccine_coverage (private insurance that does not cover vaccines without a copayment or coinsurance), uninsured, unknown, and any_public_insurance (at least one dose covered by public insurance), which contains every only_public child and overlaps multiple_insurance_types (in DPH's adolescent report, which publishes counts, some children with multiple types have no publicly covered dose): never add it to the others. 'all' is every child. DPH publishes no child count for these groups (num_children is NULL). Statewide rows only; every other row is 'all'.","valid_values":["all","only_private","only_public","multiple_insurance_types","only_insured_without_vaccine_coverage","uninsured","unknown","any_public_insurance"],"example":"only_public","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"vaccine","type":"string","role":"categorical","nullable":false,"label":"Vaccine","short_description":"Vaccine, or the combined 7-vaccine series (the headline); pick one, there is no total.","description":"What the child is up to date on, with the doses DPH requires by 36 months: seven_vaccine_series (the combined series: 4 DTaP, 3 IPV, 1 MMR, 3 Hib, 3 HepB, 1 varicella and 4 PCV; the headline, and never above any of those seven), dtap (4 doses of diphtheria, tetanus and acellular pertussis), ipv (3 doses of inactivated polio), mmr (1 dose of measles, mumps and rubella), hib (3 doses of Haemophilus influenzae type b), hepb (3 doses of hepatitis B), varicella (1 dose of chickenpox vaccine), pcv (4 doses of pneumococcal conjugate), hepa (2 doses of hepatitis A) and rotavirus (2 or 3 doses). No total value: pick one vaccine.","valid_values":["seven_vaccine_series","dtap","ipv","mmr","hib","hepb","varicella","pcv","hepa","rotavirus"],"example":"seven_vaccine_series","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"pct_up_to_date","type":"number","role":"metric","nullable":true,"label":"Share Up to Date","short_description":"Share of the group's children aged 19-35 months up to date on the vaccine (all doses by 36 months).","description":"Share of the group's children (num_children) up to date on the vaccine: every required dose correctly given by 36 months of age, per the GRITS registry. DPH's published percent (one decimal) divided by 100, so 0.752 = 75.2%. County figures are DPH estimates for the children with a Georgia address in the county; small counties (from 20 children) are published as is, including 1.0.","valid_values":null,"example":0.752,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL: DPH publishes every figure for every group, with no suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_children","type":"integer","role":"metric","nullable":true,"label":"Children","short_description":"","description":"Children in the group: the GRITS records of the report's birth window after DPH removed records with no childhood vaccine, out-of-state, duplicate, test and birth-placeholder records and those of children who died, as published ('Total by ...'; the Georgia total is the N in the report's chart title). The denominator of pct_up_to_date. The same count on all ten vaccine rows of a group, so never add it across vaccines. A county's count covers only children DPH assigned to it by address, not its population; the Georgia total (286,826 in 2025) also holds the children with no Georgia address, so the counties never add up to it.","valid_values":null,"example":286826,"unit":"count","value_min":null,"value_max":null,"null_meaning":"NULL on the insurance rows only: the child report's insurance table publishes coverage without a count of children.","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"population_mismatch_flag","type":"boolean","role":"categorical","nullable":true,"label":"Population Mismatch Flag","short_description":"True when DPH flags the county: its registry count is 20% or more off the expected number of children.","description":"DPH's Flag (an asterisk in the report): true when the number of children the GRITS registry assigns to the county from addresses is at least 20% more or fewer than the number of children aged 19 through 35 months expected from that year's population data in DPH's OASIS, which DPH attributes to inaccurate or incomplete address data; false otherwise. A flagged county's figures are less reliable, and DPH asks that all county figures be read as estimates, flagged or not. Describes the county-year (the same on all ten vaccine rows), not part of the row's key.","valid_values":null,"example":false,"unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL on statewide rows: DPH flags counties only.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"pct_up_to_date","numeric_filter_columns":["pct_up_to_date","num_children"],"usage":"Star-schema fact table at state and county grain. Join the counties dimension on county_fips; tract_geoid is always NULL. Pick one vaccine (seven_vaccine_series is the headline: the combined 7-vaccine series). Pin race, ethnicity, age_bracket and insurance_type to 'all' except the one breakdown you want: they are never crossed, and county rows carry 'all' on all four. The statewide row (all four at 'all', county_fips NULL) is the Georgia total; county rows never add up to it. To combine counties or groups, weight pct_up_to_date by num_children, SUM(pct_up_to_date * num_children) / SUM(num_children), which reproduces DPH's combined figure to within 0.1 percentage point (rounding); never average the shares unweighted, and never add num_children across vaccines. Read directly with DuckDB over Parquet.","limitations":"County rows cover only children with a Georgia address in the GRITS registry: 44-48% of each year's children have none (DPH's UNKNOWN county) and count in the statewide rows only, so counties never add up to Georgia. DPH asks that county figures be read as estimates and flags 52-88 counties a year (population_mismatch_flag) whose registry count is 20% or more off the expected number of children. Every race group includes Hispanic children and ethnicity is a separate table (not the platform's demographic codes, whose race groups are non-Hispanic); the race, ethnicity, age and insurance breakdowns are statewide only and never crossed. County counts are not county populations. num_children repeats on every vaccine row of a group: never add it across vaccines. The insurance rows have no count (DPH publishes none), and any_public_insurance overlaps only_public and multiple_insurance_types. Figures count doses recorded in GRITS, not a survey: doses given out of state or never entered are missed, so coverage is understated where records are sparse (on the 7-vaccine series the unknown race and unknown ethnicity groups are below the statewide figure in every year), and DPH chose the 19-35 month ages to match CDC's National Immunization Survey (NIS-Child), whose survey estimates these are not. The cohort is the registry records DPH kept (records with no childhood vaccine, out-of-state, duplicate, test and birth-placeholder records and children who died removed). A county is the first complete Georgia address on the child's record; DPH notes that counties bordering other states may have children vaccinated out of state, and counties with much moving in and out (military bases) may show lower coverage because children leave before finishing their vaccines. DPH suppresses nothing: county cohorts as small as 20 children are published as they are, some at 100% coverage, so small counties swing from year to year. Percents are published to 0.1 point. The registry cohort shrank relative to births over 2018-2025 (about 1.37 times the births of its birth window in 2018 and 0.98 in 2025, our check against OASIS births), so each year counts a different mix of records and trends partly reflect registry cleaning, not only vaccination. All eight reports (2018-2025) use one method, all registry records; DPH's studies before 2018 sampled children and are not in this series. DPH regenerates the reports in place; these are as retrieved 2026-10-24. The public health district table is not served. tract_geoid is always NULL.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2018,2019,2020,2021,2022,2023,2024,2025],"schema_hash":"1bd00e38c1bfd5d7d182def197c1c51a92a85e3e30799bed1cf6f52793c06ceb","tags":["health","georgia department of public health, immunization program: child immunization report","child_immunization_coverage"],"granularity_description":"One row per year, county_fips, tract_geoid, race, ethnicity, age_bracket, insurance_type, vaccine (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), counties detail","query":"SELECT * FROM child_immunization_coverage WHERE year = 2025 LIMIT 100"},{"description":"Filter by race = black","query":"SELECT * FROM child_immunization_coverage WHERE race = 'black' AND year = 2025 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},{"param":"race","kind":"categorical","column":"race","type":"string","multi_value":true,"enum_enforced":true,"values":["all","white","black","asian","native_american","pacific_islander","other","unknown"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"ethnicity","kind":"categorical","column":"ethnicity","type":"string","multi_value":true,"enum_enforced":true,"values":["all","hispanic","not_hispanic","unknown"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"age_bracket","kind":"categorical","column":"age_bracket","type":"string","multi_value":true,"enum_enforced":true,"values":["all","19_24_months","25_35_months"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"insurance_type","kind":"categorical","column":"insurance_type","type":"string","multi_value":true,"enum_enforced":true,"values":["all","only_private","only_public","multiple_insurance_types","only_insured_without_vaccine_coverage","uninsured","unknown","any_public_insurance"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"vaccine","kind":"categorical","column":"vaccine","type":"string","multi_value":true,"enum_enforced":true,"values":["seven_vaccine_series","dtap","ipv","mmr","hib","hepb","varicella","pcv","hepa","rotavirus"],"has_total":false,"total_value":null,"requires_single_value":true,"nullable":false,"null_filter_token":null},{"param":"population_mismatch_flag","kind":"categorical","column":"population_mismatch_flag","type":"boolean","multi_value":true,"enum_enforced":false,"values":null,"has_total":false,"total_value":null,"requires_single_value":false,"nullable":true,"null_filter_token":null}],"filter_hints":[],"non_additive":[{"column":"vaccine","reason":"num_children is the group's cohort count, repeated on each of the ten vaccine rows (the children evaluated, not the children vaccinated), so summed across vaccines it counts every child ten times.","metrics":["num_children"]},{"column":"insurance_type","reason":"any_public_insurance (at least one vaccine dose paid by public insurance) contains every only_public child and overlaps multiple_insurance_types: in DPH's adolescent report, which uses the same classification and publishes counts, it is smaller than only_public plus multiple_insurance_types every year, so some children with multiple types had no publicly covered dose. Never add it to the others; the six other types do not overlap each other.","values":["any_public_insurance","only_public","multiple_insurance_types"]}],"partitions":[],"value_implications":[],"year_meaning":"year is the DPH report year. Its children are those aged 19 through 35 months during that year, born February 1 three years before through May 31 of the year before (2025: born 2022-02-01 to 2024-05-31), and a child counts as up to date on a vaccine when every dose was correctly given by 36 months of age.","pooled_rates":[],"series_breaks":[],"year_window":null,"pooled_min_count":null,"values_endpoint":"/api/v1/health/child_immunization_coverage/values"}