Archive | Case Studies

GOV.UK – Contracts Finder… £1billion worth of carrots!

This post is about the government Contracts Finder website. This site has been created with a view to helping SMEs win government business by providing a “one-stop-shop” for public sector contracts. Government has been doing some great work transitioning their departments to GOV.UK and giving a range of online services a makeover. We’ve been involved […]

Henry Morris (CEO and social mobility start-up whizz) on getting contacts from PDF into his iPhone

Meet @henry__morris! He’s the inspirational serial entrepreneur that set up PiC and upReach.  They’re amazing businesses that focus on social mobility. We interviewed him for He’s been using it to convert delegate lists that come as PDF into Excel and then into his Apple iphone. It’s his preferred personal Customer Relationship Management (CRM) system, it’s […]

Horizon 2020–Project TIMON

ScraperWiki are members of a new EU Horizon 2020 project: TIMON “Enhanced real time services for optimized multimodal mobility relying on cooperative networks and open data”. This is a 3.5 year project, that commenced in June 2015, whose objectives are: to improve road safety; to provide greater transport flexibility in terms of journey planning across multiple modes […]

Number of prescriptions by location

There are 211 clinical commissioning groups (CCG’s) across England dispensing a range of medications every day. These CCG’s have demographic factors that could affect how much medication is dispensed. Therefore I thought it would interesting to compare the number of items dispensed in CCGs across England for a number of different medications, using the Clinical […]

Branded and Generic medication compared

According to the Office of Health Economics for the Association of the British Pharmaceutical Industry (ABPI), the total medicines bill in the UK was £13.6 billion in 2011 and £10.8 billion of this was spent on branded medication. Prescribers such as GPs are encouraged to prescribe generic medicine instead of its branded version. This is […]

Case study: Enrique Cocero getting political data from PDFs

Political strategy is international now. Enrique Cocero works from Madrid for his consultancy 7-50 Electoral Math, using data to understand voters and candidates in election campaigns across the world. He’s struggled with PDFs for a long time, and recently found PDF Tables via a Google search. He says: I used to have nightmares – I’m […]

Hi, I’m Leonisha

My name is Leonisha Barley, and I am the latest addition to  the people fortunate enough to have an internship opportunity at Scraperwiki. I just finished my 2nd year at The University of Manchester studying for a BA(Hons) degree in Sociology and Criminology and I am exciting about developing my skills further this summer. There […]

Which plane had the most accidents?

Searching by facets Last year, ScraperWiki helped migrate lots of specialist datasets to GOV.UK. This afternoon, we happened to notice that the Air Accidents Investigation Branch reports, which we scraped from their old site, are live. The user interface is called Finder Frontend, and is used by GOV.UK wherever the user needs to search for […]

Elasticsearch and elasticity: building a search for government documents

Based in Paris, the OECD is the Organisation for Economic Co-operation and Development. As the name suggests, the OECD’s job is to develop and promote new social and economic policies. One part of their work is researching how open countries trade. Their view is that fewer trade barriers benefit consumers, through lower prices, and companies, […]