{"id":751,"date":"2013-02-19T18:05:06","date_gmt":"2013-02-19T18:05:06","guid":{"rendered":"http:\/\/helpmeinvestigate.com\/health\/?p=751"},"modified":"2021-10-22T07:03:43","modified_gmt":"2021-10-22T07:03:43","slug":"hospital-food-hygiene-ratings-how-to-find-them-in-your-area","status":"publish","type":"post","link":"http:\/\/helpmeinvestigate.com\/health\/2013\/02\/19\/hospital-food-hygiene-ratings-how-to-find-them-in-your-area\/","title":{"rendered":"Hospital food hygiene ratings: how to find them in your area"},"content":{"rendered":"

A version of this post covering schools<\/a> appears on Help Me Investigate Education.<\/em><\/p>\n

With food hygiene in the news following the horsemeat scandal, I thought I’d put together a quick guide on getting information about your own local hospitals’ hygiene ratings.<\/p>\n

You can download\u00a0FSA ratings of food hygiene for each local authority<\/a>. This includes hospitals and other healthcare providers.<\/p>\n

However, the downloads are in XML format, so you’ll need to first convert it to a spreadsheet. There are\u00a0online tools to help you do this<\/a>\u00a0and you can also\u00a0use the free data cleaning tool Google Refine<\/a>.<\/p>\n

Once you’ve done that, you’ll need to drill down to the hospitals.<\/p>\n

Finding the hospitals<\/h2>\n

Create a new column, called ‘Hospitals?’ – this is best done between the current columns C and D (I’ll explain why).<\/p>\n

In the first cell under that heading, type this formula:<\/p>\n

=COUNTIF(G2, “*hospital*”)<\/strong><\/p>\n

When you press Enter, this will give you ‘1’ if the named cell (G2) contains ‘hospital’ and 0 if it doesn’t.<\/p>\n

Why? The * is a wildcard: it means ‘zero or more of any character’. So “*hospital*” translated into computer-speak means ‘any character, followed by the string of characters ‘hospital’, followed by any character.<\/p>\n

Now\u00a0copy that down the whole column<\/strong>\u00a0– the quickest way to do this is:<\/p>\n

    \n
  1. Select the cell with that formula (don’t double-click, just a single click to select)<\/li>\n
  2. Hover over the bottom right corner until the cursor turns to a\u00a0black cross<\/strong>.<\/li>\n
  3. When it’s a black cross, double-click. This will copy that formula down the whole column until there’s a blank cell to the left (this is why we put this column after column C, which is always full)<\/li>\n<\/ol>\n

    You can now sort this data (Data > Sort<\/strong>) so that the 1s come to the top and you can copy that data into another sheet to analyse, map etc.<\/p>\n

    PS: You can repeat this for the column H (the column that was G before you added a new one) so that you find any mentions in the address (it’s not always in the business name column)<\/p>\n

    Other filters<\/h2>\n

    Of course, names or addresses with ‘hospital’ in them might include ‘Hospital Road’, so you might want to filter it further.<\/p>\n

    For example, you could repeat the process above to find any mention of terms you don’t want, or omit the second asterisk so that your formula only finds names that end in ‘*hospital’ without any characters following.<\/p>\n

    You can also select the ‘business type’ column and use\u00a0Data > Filter…<\/strong>\u00a0and then select only ‘Hospitals\/Childcare\/Caring Premises’.<\/p>\n

    What next?<\/h2>\n

    Once you’ve identified the hospitals, there are a number of things you might do. Here are just some:<\/p>\n