Throughout the data collection process, the SQLite database was updated every time a new note on a programmer action was made, and each row of the database contained a different note. Once I finished the manual rebuilding process, the entire data collection process for the YouTube video was complete, and the SQLite database was also filled with all pertinent columns and information. The figure below shows a snippet of the final SQLite database, where the timed_url column is the URL of the YouTube video (which stays the same in all rows), time is the timestamp of the video the note was taken at, img_file denotes the name of the local PNG file of the screenshot, the notes column contains the activity type and details of the note made, and the code_text column is the code text as derived from the corresponding screenshot.
