How we compiled the HIV-AIDS data

December 14, 2013

The date for this report came from the Centers for Disease Control and Prevention. The CDC has a website with data and maps on the prevalence of sexually transmitted diseases at the county level and the state level. The website allowed us to export the data. Then, using Microsoft Excel and Microsoft Access, we analyzed the prevalence of HIV/AIDs in Richmond compared with other localities in Virginia and the United States.

We also found data for metropolitan areas from the CDC’s HIV Surveillance reports. The CDC posts these reports as PDFs, but we were able to extract the data and analyze it with Excel and Access.

The two data sets were slightly different.  For example, the county-level and state-level data gave a rate based on those living with HIV per 100,000 residents. The HIV Surveillance report included people who had died from HIV/AIDS in 2010, as well as projected new diagnoses for 2011. We subtracted these two groups to give us only those living with HIV in each metropolitan area. We then were able calculate rates that had the same criteria as the county-level and state-level data. Below is a spreadsheet table via Google of the MSA-related data:

Supporting data for our story also came from Quarterly HIV Surveillance reports from the Virginia Department of Health. Below are three tables we constructed using VDH data:

Main story: Richmond’s HIV rate among highest in U.S.