Mixed results have been published on the impact of the 2019 coronavirus (COVID-19) pandemic and its associated lockdown periods on academic functioning, mood, and health correlates such as alcohol consumption. Whereas a number of students report an impaired academic performance and increased alcohol intake during lockdown periods, other students report no change or an improvement in academic functioning and a reduced alcohol consumption. This data descriptor article describes the dataset of a study investigating the impact of the COVID-19 pandemic on academic functioning. To investigate this, an online survey was conducted among Dutch pharmacy students, PhD candidates and postdoctoral researchers (postdocs) of Utrecht University, the Netherlands. Compared to before the COVID-19 pandemic, the survey assessed possible changes in self-reported academic functioning, mood and health correlates such as alcohol consumption, perceived immune functioning and sleep quality. Retrospective assessments were made for four periods, including (1) the year 2019 (the period before COVID-19), (2) the first lockdown period (15 March–11 May 2020), (3) summer 2020 (no lockdown) and (4) the second lockdown (November 2020–April 2021). This article describes the content of the survey and corresponding dataset. The survey had a response rate of 24.3% and was completed by 345 participants.