-
BRFSS conducts a survey in Alabama outlining current health conditions, medications, and access to health care and insurance.
-
Survey data was transferred from the BRFSS database to a Heart Matters CSV file and stored on a secure hard drive in a locked room.
-
During expansions, the new location received funding to expand to an SQL database to store, manage, and analyze data. The data set was copied to a flash drive, delivered, and imported into the new system.
-
A new data analyst was hired to find the top three health concerns and discovered the file contained unreadable characters by SQL during migration. Some rows of data did not transfer properly and were lost in the transfer.