Kansas

The State of Kansas received $399,885 through cooperative agreement EH21-2102 from the Centers for Disease Control and Prevention (CDC) in FY 2022. The funds address childhood lead poisoning prevention and surveillance programmatic activities being conducted from September 30, 2022 to September 29, 2023.

The strategies focus on

  • Ensuring blood lead testing and reporting
  • Enhancing blood lead surveillance
  • Improving linkages to recommended services

To learn more about these efforts in Kansas, contact the program below.

Kansas Department of Health & Environment
Kansas Childhood Lead Poisoning Prevention Program
1000 SW Jackson St.,
Topeka, KS 66612
Phone: 866-865-3233

Success Story 2023

Improving Data Processing in Kansas

Challenge

Kansas uses a disease surveillance system called EpiTrax to collect, store, and manage blood lead level test results and perform case management oversight. This system was designed for infectious diseases and modified to accept reportable conditions such as blood lead. Approximately 60,000 records are entered into the dynamic system each year by reporting healthcare facilities and laboratories. Hundreds of users access the system, including local health departments.

Although much work has been done to improve data processing and quality, transforming records collected by the EpiTrax surveillance system into usable data products is complex and has historically been inefficient. Data standardization and formatting issues result in errors, variations, and missing or misplaced values. Furthermore, up to one third of all records are duplicates and difficult to identify. The existing process was functional but needed to be objectively evaluated and significantly improved.

Intervention

In October 2022, a new data analyst reviewed the workflow process with assistance from the programmatic team. Two main areas were targeted for quality improvement: duplicate records and address cleaning and geocoding. New coding packages were written to accurately identify duplicate records and resolve differences among duplicates with conflicting values. A new method of comparing the prevalence of duplicates and data ambiguities across quarters was instituted. Scripts for address cleaning and geocoding, which is the most time and resource intensive part of the workflow process, were assessed and redesigned. Because addresses are not standardized or validated by the system, scripts had to be created to anticipate many different types of potential errors and deviations from the acceptable address formats that were imported into the system.

Cleaned addresses are processed through a contracted vendor’s application programming interface for geocoding. The geocoding vendor assesses charges for each address submitted, therefore it is important to submit only unique addresses that will likely geocode. Advanced software tools were created to rapidly search the EpiTrax system for a valid address and to pre-validate addresses in bulk using the online U.S. Postal Service address lookup tool as a new step in the process. This helped to reduce the number of addresses that were submitted but failed geocoding. Additional improvements to the data processing workflow included consolidating and streamlining all data and scripts and creating a written procedure manual that details the data processing steps and allows for versioning.

Impact

The program enhanced blood lead surveillance through the application of continuous quality improvement to plans and processes for surveillance data collections, quality, and dissemination. As a result

  • staff hours needed to process quarterly data for submissions to the CDC were reduced,
  • processing time was reduced by approximately 50%,
  • quarterly lead data are now more readily available for routine and descriptive analyses,
  • data quality control processes have been improved through a multi-phased assessment process,
  • the percentage of addresses geocoded with high accuracy increased from 20% to 25%,
  • costs decreased, and
  • numerous data issues were resolved as part of the initial in-depth evaluation.

This success story was supported by the Cooperative Agreement Number, CDC-RFA-EH21-2102, funded by the Centers for Disease Control and Prevention. Its contents are solely the responsibility of the authors and do not necessarily represent the official views of the Centers for Disease Control and Prevention or the Department of Health and Human Services; nor does mention of trade names, commercial practices, or organizations imply endorsement by the U.S. Government.

Success Story 2021

Automating Processes for Strengthening Surveillance in Kansas

Challenge

Blood lead test results are required to be submitted to the Kansas Department of Health and Environment (KDHE) as a notifiable condition. Test results at or above 5 μg/dL were entered into the disease surveillance system called EpiTrax that was developed to manage infectious disease surveillance. Affected children were then referred to local health departments for investigation. Non-elevated tests, which accounted for most of the test results, were stored separately in a makeshift MS-Access database with limited ability to retrieve information. Conducting epidemiological surveillance was very challenging because a consolidated and cleaned dataset to capture the extent of the childhood lead poisoning problem in Kansas was not available.

Intervention

New tools, processes, and optimized queries were created to make the elevated blood lead test results retrievable from the databases. The Kansas Environmental Public Health Tracking senior epidemiologist provided in-kind support to create scripts to automate the collection, cleaning, and management of the disparate blood lead data sets. Non-elevated blood lead test results were cleaned and stored in a newly created database to ensure that the test results would be accessible and properly formatted for analysis and data submission purposes. A new epidemiologist was hired in September 2019 to use the updated and cleaned blood lead dataset to conduct analyses to identify high-risk areas, work on predictive modeling, create data stories for stakeholders, and provide epidemiological support for local health departments.

Impact

A large volume of previously disorganized and non-analyzed data was cleaned, properly formatted, and consolidated into a new database capable of being queried. Approximately 90% of the blood lead data for the past 4 years is now accessible and can be used for surveillance and analytical purposes. Because of this effort, the program can provide additional information to partners to make better-informed decisions to prevent childhood blood lead poisoning.

Funding for this work was made possible in part by [NUE2EH001406] from the Centers for Disease Control and Prevention (CDC). The views expressed in this material do not necessarily reflect the official policies of the Department of Health and Human Services; nor does mention of trade names, commercial practices, or organizations imply endorsement by the U.S. Government.