-
Data Collection (2017)
Origin: The data was collected by the Behavioral Risk Factor Surveillance System (BRFSS), a system of health-related telephone surveys conducted by the CDC.
Data Type: The data includes health-related risk behaviors, chronic health conditions, and use of preventive services.
Collection Method: More than 400,000 adult interviews were completed annually across all 50 states, the District of Columbia, and three U.S. territories. -
Initial Storage (2017)
Format: The data was stored in CSV format.
Security Measures: The data was stored on a secure hard drive in a securely locked room.
Initial Analysis: The data was analyzed to determine if a lack of medical care was a problem in Alabama. -
Physical Transfer (2018)
Process: The data set and codebook were copied to a flash drive and delivered to the new location for the client's business expansion.
Transition: The data was physically transferred and imported into a new SQL database at the new location. -
Data Migration Issue (June 2018)
Problem Identified: During the data import into the SQL database, unreadable characters caused some rows of data to be lost.
Impact: The quantity of data in the SQL database did not match the original CSV file, leading to data loss and potential issues with data integrity.