-
Data Collection Begins
The Behavioral Risk Factor Surveillance System (BRFSS) began collecting health-related data from U.S. adults via phone interviews. -
Data Stored on Secure Drive
Survey data from Alabama was stored in CSV format on a secure hard drive located in a locked room to maintain confidentiality and data integrity. -
Data Transferred to New Facility
The data set and codebook were copied to a flash drive and physically delivered to the client's new location as part of an expansion effort. -
Data Imported Into SQL Database
The dataset was imported into an SQL database at the new facility. However, some unreadable characters caused certain rows to fail during import, resulting in partial data loss. -
Data Analyst Reviews Import Results
A newly hired data analyst discovered that the number of rows in the SQL database did not match the original CSV file due to unreadable characters. This initiated a review for missing data and integrity issues. -
Current Status of Data
The dataset is currently stored in an SQL database with partial data loss. Analysts are using the codebook and CSV file to identify integrity issues and support ongoing research for healthy heart initiatives in Alabama.