Warwickshire County Council

  • 100+ Hours of manual effort automated

Warwickshire County Council gained a better understanding of its health and social care services by automating the retrieval of public health data.

Warwickshire County Council depended on manual data downloads to retrieve new health care data. The process was time-consuming, took away from other tasks, and often meant that data was not as up-to-date as it could be.

To enable better decision making and to measure the effectiveness of services, Warwickshire County Council needed to automate the retrieval of public health data from multiple online sources, including Hospital Episode Statistics (HES), Find open data - data.gov.uk , Fingertips, and NaPTAN.

How they made it possible – no code required.

Using FME, they built workflows to download new data from APIs, extract a full history of data, generate schemas, analyze the data, and send it to their PSQL relational database. They leveraged FME’s repeatable workflows to reduce the effort of manually refreshing datasets, plus minimize network traffic through batch calls and bulk downloads. They used HTTP, JSON, and SQL scripting functionality to connect a variety of REST APIs to their relational database. FME handled massive ~60 GB text files and gathered schema information from HES data where other software could not.

Warwickshire County Council now has multiple health data sources loaded into their PSQL infrastructure in a formatted, user-friendly structure. FME has automated hundreds of hours of manual effort with a few straightforward workflows, freeing their analysts to work on more critical tasks.

Warwickshire County Council governs five districts and boroughs in England. The council manages roads, social services, education, libraries, and other local government services.

FME Products Used:

If you want to replace manual data processes, FME can help. Spend more time making data-driven decisions instead of fighting with your data. Try FME for free.

  • FME Desktop

  • FME Cloud

“FME has allowed hundreds of hours of work to be automated” - Joe Ellerington, Warwickshire County Council