EXASOL’s MPP in-memory analytic database used to find fast insights into 602 million rows of prescription data, uncovering antibiotic prescription trends ahead of European Antibiotic Awareness Day 2015
London, 12 November 2015 — Today, EXASOL, developer of the world’s fastest analytic database, reveals research it conducted in partnership with Antibiotic Research UK, the world’s first charity created to develop new antibiotics in the fight against superbugs. Using the power of its fast analytic database and prescription data spanning 5 years, EXASOL found that while antibiotic prescriptions are coming down across England, struggling GP practices in the most deprived parts of the country are prescribing 20% more and, worryingly, antibiotic prescriptions are on the increase in these deprived areas. For instance, in Clacton-on-Sea, the UK’s most deprived area, antibiotic prescribing rates of almost twice the national average.
EXASOL analyzed data released by the Government’s Health and Social Care Information Centre and sourced from the NHS Business Services Authority. The data runs over 5 years from August 2010 to July 2015 and contains 602 million rows of data. The data was analyzed by a data scientist working for EXASOL, using its high performance in-memory analytic database. The data reveals antibiotic prescribing hotspots and interesting correlations against areas of deprivation. It also shows seasonal variation in antibiotic prescribing. The data is grouped by Lower Layer Super Output Areas (LSOA)*.
Sean Jackson, chief marketing officer, EXASOL says: “Awareness of antibiotics overuse is critical. With the right data and the right technology, you can turn any problem into a data problem and uncover information to help address it. We worked with Antibiotic Research UK to find information that is useful in their quest to reduce antibiotic use and find new antibiotics in the fight against the superbug. To analyze such enormous data-sets fast, returning answers from the data within seconds, requires the right tool and we hope the findings help to further reduce this serious issue.”
Key findings include:
- Prescriptions per head peaked in 2012 with a total of 3.8 million prescriptions to English patients, but have dropped 5.6% since
- However, there is a widening deprivation gap: The gap between prescriptions in the least and most deprived areas of England is widening and the difference in prescribing between the bottom and top 1% by deprivation is 20%
- Doctors prescribe 59% more antibiotics in December than they do in August, despite the fact that illnesses treated by antibiotics are not seasonal
- London doctors prescribe 21% fewer antibiotics than the North. The data also reveals that the most deprived coastal towns in Lincolnshire, Norfolk and Essex are prescribing the most antibiotics in the country, with Clacton-on-Sea, the UK’s most deprived area, almost twice the national average
Sean Jackson continues: “When analyzing the data we are seeing a widening deprivation gap in antibiotic prescriptions. The gap between prescriptions in the 1% least and most deprived areas of England is 20%. We also see significant regional differences, for example London prescriptions are 21% lower than areas in the North.”
Professor Colin Garner, chief executive of Antibiotic Research UK Says: “Londoners and the Thames Valley region have the best access to healthcare and are also on average younger and healthier than the rest of the country. However, we would not expect to see such a large variation in prescriptions around the country. If we look at the detailed heat map it shows hotspots of antibiotic prescription, more generally around areas of deprivation.”
The data also highlighted seasonal variation in prescription levels with 59% more prescriptions in December than in August with no logical reason. Professor Colin Garner of Antibiotic Research UK says: “It is true that colds and flus sometimes lead to bacterial infections due to suppressed immune systems and so we would expect a minor increase in antibiotic prescription in the winter months, however the data shows us a 59% jump in four months and this is far too high. One explanation is that patients are requesting antibiotics from their GPs for simple coughs and colds and GPs are acceding to these requests despite the advice they have been given not to prescribe antibiotics for this condition”.
An increased resistance by bacteria to antibiotics could change surgery as we know it today. As a consequence, new hips, knees, organ transplantation, open heart surgery and many cancer treatments will become high risk. It is estimated that there are 400,000 cases of reported antibiotic resistant infections with 25,000 deaths each year in the European Union; in the UK the figure is close to 5,000 deaths per year. 35,000 people die each year from sepsis of which a proportion can be directly linked to infection with antibiotic resistant bacteria. Even a simple scratch can kill without effective antibiotics.
Notes to editors:
*LSOA: Lower Layer Super Output Areas are built from groups of contiguous Output Areas and have been automatically generated to be as consistent in population size as possible, and typically contain from four to six Output Areas. The Minimum population is 1000 and the mean is 1500. There is a Lower Layer Super Output Area for each POSTCODE in England.
Lists of datasets used:
- Prescribing data from http://www.hscic.gov.uk/gpprescribingdata – a list of all prescriptions given by GPs and subsequently dispensed in England (5 years – from August 2010 to July 2015). This is the largest dataset, amounts to about 602 million rows or 83 GB of uncompressed data. The data is grouped by month, roughly 1 million prescriptions per month.
- Practice codes, names and addresses (June 2015) – http://www.hscic.gov.uk/article/2021/Website-Search?productid=18541 – a lookup for the addresses of the practices listed above. In total 9,897 practices are listed (England only).
- Numbers of Patients Registered at a GP Practice (July 2015) http://www.hscic.gov.uk/catalogue/PUB17927 – gives a breakdown of the patients registered with each practice by age, sex, LSOA (lower level super output area – small geographic areas with a maximum population of 1000).
- English Indices of Deprivation 2010 – a generated index of deprivation by LSOA (32,482 rows)
EXASOL is passionate about helping companies to run their businesses smarter and drive profit by analyzing data and information at unprecedented speeds. The company develops the world’s fastest database for analytics and data warehousing, and offers first-class know-how and expertise in data insight and analytics. The in-memory analytic database is the first database to combine in-memory, columnar compression and massively parallel processing, and is proven to be the world’s FASTEST, topping the list in the TPC-H Benchmark tests for performance. Companies that depend on EXASOL to analyze their data in real-time include Adidas Group, GfK, IMS Health, King, Olympus, myThings, Sony Music and Xing. Follow EXASOL on Twitter at @EXASOLAG.
About Antibiotic Research UK
Antibiotic Research UK is the world’s first charity to tackle the problem of antibiotic resistant infections. We aim to develop one new antibiotic therapy by the early 2020’s with further antibiotics being introduced over the next decade. To reach our goals we need to raise £30 million over the next 5-7 years. Antibiotic Research UK has the support of some of the United Kingdom’s leading scientific and clinical experts in antibiotic resistance, drawn from 14 of the country’s top universities and 12 specialty pharmaceutical or support companies.
The problem of antibiotic resistance (superbugs) has been highlighted by the World Health Organisation, the UK Prime Minister, the President of the USA, the UK Chief Medical Officer Dame Sally Davies and Lord Jim O’Neill, chair of the Government’s Review of Antimicrobial Resistance. David Cameron talked about medicine going back to the ‘dark ages’ if we didn’t tackle this impending health disaster. Antibiotic Research UK is a registered charity (no 1157884) and is uniquely placed to develop new therapies which would be made available to all affected by antibiotic resistant infections throughout the world. Its first scientific programme has been developed by the charity’s Scientific and Technical Advisory Committee, a group of national antibiotic resistance experts. Further details can be found here.