Back Industry: Public Sector

Automating collation of COVID-19 patient data for State Government

COVID-19 Challenge

As the testing  ramped up, so was the collation of patient data

State authorities have been carrying out vigorous COVID-19 testing of patients throughout the state on a large scale. The ground staff and healthcare workers collect data of patients being tested and past test samples. This patient data goes directly into a centralized repository via the National Authority portal. With the State Government planning to ramp up the COVID-19 testing, it became a large task of collating the state’s data from the National Authority website and then adding to the State Governments database. As the number of patient testing increased beyond 2000 per day, the manual task of collating the daily patient data after downloading it as an excel sheet from the National Authority portal became too time-consuming.

The State Authorities team wanted to have a quick  automation in place where the COVID-19 patient testing data downloads from the National Authority portal and then collates on the State Government  portal to the database almost real time. The data collated in the State Government's database would then help the state to make quick real time  decisions and dynamically change the course of action depending on the patient's test results.


The tested patients’ data  downloads from the National Authority website in the form of an excel sheet. The State Authority  creates an online web form and an API  fills in the patient data, which includes new patient data and old patient data to be updated. All the latest patient data needed to be collated multiple times in the day. The amount of patient data was proportional to the testing volume in the state.

The team at Auxiliobits Technologies Pvt Ltd quickly created this process automation through which the UiPath software robot downloads the patient data from the National Authority portal, then picks up the records of tested patients and sends those patient data records to the respective State Government portal through an API. This helps the State Authorities deliver updated data and to be ready for actionable insights.