{"id":2026,"date":"2012-01-26T00:02:58","date_gmt":"2012-01-26T00:02:58","guid":{"rendered":"http:\/\/www.haydnwilliams.com\/blog\/?p=2026"},"modified":"2022-04-11T21:33:44","modified_gmt":"2022-04-11T20:33:44","slug":"nhs-claims-dashboard","status":"publish","type":"post","link":"https:\/\/www.haydnwilliams.com\/blog\/nhs-claims-dashboard\/","title":{"rendered":"NHS Claims Dashboard"},"content":{"rendered":"<p>Time for a couple more NHS-related dashboards, this time looking at claims made against NHS organisations. There are three main schemes that are run &#8211; <a title=\"Clinical Negligence Scheme for Trusts - NHSLA\" href=\"http:\/\/www.nhsla.com\/Claims\/Pages\/Clinical.aspx\" target=\"_blank\" rel=\"noopener\">Clinical Negligence Scheme for Trusts<\/a> (CNST), <a title=\"Risk Pooling Scheme for Trusts - NHSLA\" href=\"http:\/\/www.nhsla.com\/Claims\/Pages\/NonClinical.aspx\" target=\"_blank\" rel=\"noopener\">Risk Pooling Scheme for Trusts<\/a> (RPST) and the <a title=\"Existing Liabilities Scheme - NHSLA\" href=\"http:\/\/www.nhsla.com\/Claims\/Pages\/Handling.aspx\" target=\"_blank\" rel=\"noopener\">Existing Liabilities Scheme<\/a> (ELS). CNST and ELS relate to clinical negligence claims post- and pre-1st April 1995 respectively, while RPST covers non-clinical claims. All three schemes fall under the umbrella of the <a title=\"NHS Litigation Authority\" href=\"http:\/\/www.nhsla.com\" target=\"_blank\" rel=\"noopener\">NHS Litigation Authority<\/a> (NHSLA).<\/p>\n<p>Handily, the NHSLA <a title=\"NHSLA Publications\" href=\"http:\/\/www.nhsla.com\/Claims\/Pages\/Publications.aspx\" target=\"_blank\" rel=\"noopener\">makes available data<\/a> relating to the number and value of claims, released each year as &#8220;<em>Factsheet 5<\/em>&#8221; in the &#8220;<em>NHSLA Factsheets<\/em>&#8221; section (doesn&#8217;t work in Safari). <em><a href=\"http:\/\/www.nhsla.com\/pages\/publications.aspx?library=currentactivity%7cfactsheets%7cfactsheet3claimsinformation\" target=\"_blank\" rel=\"noopener\">Factsheet 3<\/a><\/em> gives graphs by specialty, although not raw numbers it seems, and includes the possibly surprising fact that nearly 40% of claims last year were abandoned. I&#8217;ve combined the high-level raw data from 2003\/04 to 2010\/11 into one large dataset and then performed some extra manipulation to sanitise it a little (see the end of this post if you want the details).<\/p>\n<p>The number of claims has escalated in recent years, as has the <a title=\"Google News - NHSLA bailout\" href=\"http:\/\/news.google.co.uk\/news\/more?hl=en&amp;gl=uk&amp;q=nhs+claims&amp;gs_upl=265l668l0l3960l8l2l0l0l0l0l0l0ll0l0&amp;um=1&amp;ie=UTF-8&amp;ncl=duwG37Xnun0rqSMWXj_1DGrtH8jeM&amp;ei=io0gT5eNEtO7hAf4zajlBA&amp;sa=X&amp;oi=news_result&amp;ct=more-results&amp;resnum=4&amp;ved=0CEIQqgIwAw\" target=\"_blank\" rel=\"noopener\">amount of money being paid out<\/a>, \u00a0and hopefully the charts below show these trends in an easily-digestible format. One word of warning though: think carefully about the numbers involved. The second dashboard shows the amount paid out in total across all schemes, which last reached \u00a3860 <strong>million<\/strong> pounds, and the figures being circulated [edit: link no longer working, unfortunately] for potential liability across all current cases top \u00a316 <strong>billion<\/strong>. Numerous publications have <a title=\"Guardian - High risk healthcare 'will suffer if medical cover is privatised'\" href=\"http:\/\/www.guardian.co.uk\/politics\/2012\/jan\/12\/healthcare-nhs-medical-insurance-bma?newsfeed=true\" target=\"_blank\" rel=\"noopener\">looked into<\/a> the reasons behind the changes, ranging from increased numbers of claims in times of recession, to increased &#8211; or non-existant &#8211; upper limits to claim values. This isn&#8217;t my area of expertise, so I&#8217;ll leave it to others to interpret the stats accordingly.<\/p>\n<p>Speaking of stats, the NHSLA themselves put some good information on the front worksheet of each &#8220;factsheet&#8221; that they publish, and I would encourage anyone digging into these figures to read that blurb too. Note that, as discussed above, I have amended the data in the interests of collating it into a single dataset, so whilst I accept responsibility for any errors and\/or omissions resulting from that process, the raw data provided by the NHSLA \u00a0should always be taken as the gold standard for anyone drawing major conclusions from the information presented here.<\/p>\n<p>The first dashboard looks at the numbers of claims received, including a comparison of whether a PCT with a larger population has more claims, while the second focuses on the cost of these claims overall, and the damages paid out.<\/p>\n<p><script type=\"text\/javascript\" src=\"http:\/\/public.tableausoftware.com\/javascripts\/api\/viz_v1.js\"><\/script><\/p>\n<div class=\"tableauPlaceholder\" style=\"width: 654px; height: 929px;\"><noscript><a href=\"#\"><img decoding=\"async\" alt=\"NHSLA - Claims Received \" src=\"http:&#47;&#47;public.tableausoftware.com&#47;static&#47;images&#47;Cl&#47;ClaimsReceived&#47;NHSLA-ClaimsReceived&#47;1_rss.png\" style=\"border: none\" \/><\/a><\/noscript>&nbsp;<\/p>\n<\/div>\n<div style=\"width: 654px; height: 22px; padding: 0px 10px 0px 0px; color: black; font: normal 8pt verdana,helvetica,arial,sans-serif;\">\n<div style=\"float: right; padding-right: 8px;\"><a href=\"http:\/\/www.tableausoftware.com\/public?ref=http:\/\/public.tableausoftware.com\/views\/ClaimsReceived\/NHSLA-ClaimsReceived\" target=\"_blank\" rel=\"noopener\">Powered by Tableau<\/a><\/div>\n<\/div>\n<div class=\"tableauPlaceholder\" style=\"width: 654px; height: 929px;\"><noscript><a href=\"#\"><img decoding=\"async\" alt=\"NHSLA - Payments Made \" src=\"http:&#47;&#47;public.tableausoftware.com&#47;static&#47;images&#47;Cl&#47;Claims-PaymentsMade&#47;NHSLA-PaymentsMade&#47;1_rss.png\" style=\"border: none\" \/><\/a><\/noscript>&nbsp;<\/p>\n<\/div>\n<div style=\"width: 654px; height: 22px; padding: 0px 10px 0px 0px; color: black; font: normal 8pt verdana,helvetica,arial,sans-serif;\">\n<div style=\"float: right; padding-right: 8px;\"><a href=\"http:\/\/www.tableausoftware.com\/public?ref=http:\/\/public.tableausoftware.com\/views\/Claims-PaymentsMade\/NHSLA-PaymentsMade\" target=\"_blank\" rel=\"noopener\">Powered by Tableau<\/a><\/div>\n<\/div>\n<p><span style=\"text-decoration: underline;\">Notes on the Data:<\/span><\/p>\n<p>The standard data has been manipulated a bit to create my final version. \u00a0Note that the requirement to change the data shouldn&#8217;t necessarily be viewed as confirmation that it is inherently flawed; most of these amendments were made to facilitate analysis rather than correct errors. The revised dataset used to create the dashboards above can be downloaded <a href=\"http:\/\/www.haydnwilliams.com\/blog\/nhs-claims-dashboard\/nhsla_master_consolidated\" rel=\"attachment wp-att-2187\">here<\/a>(MS Excel spreadsheet, 3Mb).\u00a0The following changes have been performed:<\/p>\n<div>\n<ul>\n<li>Combined the &#8216;Trust&#8217; and &#8216;PCT&#8217; sheets<\/li>\n<li>Standardised organisation names, using the most recent name on a sheet (2010\/11). This is basically to harmonise name changes, <em>e.g.<\/em> a Trust becoming a Foundation Trust, and also deals with spelling errors and different abbreviations used across the years (<em>e.g.<\/em>\u00a0&#8220;Mental Health Trust&#8221; <em>vs.<\/em>\u00a0&#8220;MHT&#8221;). Some discrepancies will still be present where, for example, Trusts merged or split during the sample period.<\/li>\n<li>Filled in blanks for Strategic Health Authority using most recent values (one set of names is used to 2004\/05, all are blank for 2005\/06, a new set is used after that)<\/li>\n<li>Amended population values for 2010\/11 from 000s to actual number, <em>e.g.<\/em> 306.5 becomes 306,500<\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Time for a couple more NHS-related dashboards, this time looking&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[790,789,787,786,793,788,792,791],"class_list":["post-2026","post","type-post","status-publish","format-standard","hentry","category-it","tag-clinical-negligence-scheme-for-trusts","tag-cnst","tag-legal-action","tag-nhs-claims","tag-nhs-litigation","tag-nhsla","tag-risk-pooling-scheme-for-trusts","tag-rpst"],"_links":{"self":[{"href":"https:\/\/www.haydnwilliams.com\/blog\/wp-json\/wp\/v2\/posts\/2026","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.haydnwilliams.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.haydnwilliams.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.haydnwilliams.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.haydnwilliams.com\/blog\/wp-json\/wp\/v2\/comments?post=2026"}],"version-history":[{"count":0,"href":"https:\/\/www.haydnwilliams.com\/blog\/wp-json\/wp\/v2\/posts\/2026\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.haydnwilliams.com\/blog\/wp-json\/wp\/v2\/media?parent=2026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.haydnwilliams.com\/blog\/wp-json\/wp\/v2\/categories?post=2026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.haydnwilliams.com\/blog\/wp-json\/wp\/v2\/tags?post=2026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}