SDC’s Dodgy Data & the Man Responsible.

Shepway District Council’s (SDC) spending data webpage explains that:

For data protection reasons, payments to individuals have been redacted”

Instead of displaying redacted payments with text such as “Redacted personal information” in the supplier name field, Shepway DC has removed the name and left the field blank. This makes it difficult to assess whether it is a redacted supplier, or whether the blank is simply the same name as the supplier on the row above.

Over the six month period April – September 2016, 91 payments totalling £120,000 have no supplier name.

  1. Blank supplier name By major category

1

Judging by the categorisation above, some or most of these “redacted” payments would appear to have been redacted inappropriately. The table below shows all the payments above £1,000 with a blank supplier name.

2

With the exception of miscellaneous grants, training expenses and apprenticeships, most of these payments appear to be to made to commercial suppliers. Indeed, when sorted by description, the largest single category is payments for “Professional advice and fees”, followed by repairs and maintenance to buildings/plant. (see below).

3

A peculiar observation concerning these redacted payments is that where the payment amounts exceed £1,000, there is no comma separator to denote thousands, (see page above), whereas for all the payments where the supplier name is shown, there is a comma separator for values above £1,000. This is suggestive of a manual manipulation of the data to remove these suppliers’ names, rather than a systematic redaction process. Any manual intervention to redact payments is prone to abuse, and also to human error, such as accidentally and inconsistently redacting suppliers that ought not be redacted, and displaying the names of individuals who are not commercial suppliers, and therefore whose names should have been redacted.

Major category not displayed as separate column

The latest guidance on publishing spending data1 has the following to say about machine readable formats

4

1 “Local transparency guidance – publishing spending and procurement information” – June 2015

In Shepway’s datasets, all three published formats present the records in blocks with empty lines and total lines in between major category headings such as “Commercial & Technical Servs”. This arrangement makes it inconvenient for data users to work with because to analyse the datasets they are obliged to add a new column and place each major category in that column and copy the text down until the beginning of the next category.

5

It would be much easier for those wishing to work with the data if the datasets could be published with the major category already in a separate column, as shown below, and without empty lines or total lines.

6

Spending displayed inclusive of VAT

When councils were first asked to publish spending data in 2010, the guidelines specified that the published values be exclusive of VAT. The initiative became a statutory requirement in October 2014. The latest guidance for practitioners document, which can be found at Local transparency guidance contains the following guidance on VAT

7

Shepway DC’s spending data webpage announces that spending is shown excluding VAT, which is correct. However, the datasets themselves indicate that the values are inclusive of VAT. If they do include VAT the files ought to be corrected and the correct versions published as version 2, to show to other users that they have been amended.

Top 30 suppliers by value – April to Sept 2016

8

The top 30 suppliers make up 80% of the £18 million paid over the six month period.

So there you have it. Data which appears to have been tampered with, Data with VAT included when it shouldn’t and names either not redacted or redacted when they should not have been. It’s clear to us that SDC didn’t read the guidance which belongs to the Transparency Code. So some of the Data is Dodgy Data

Shepwayvox

Advertisements

6 Comments on SDC’s Dodgy Data & the Man Responsible.

  1. Excellent and detailed analysis by you-have you sent the dodgy dossier to the press? They must publish complete and transparent disclosure to ensure there are no ‘connections’ between suppliers and Councillors

    Like

  2. It is no surprise that this administration does whatever it wants.They have no effective opposition both inside and outside the council chamber.

    Like

  3. Got something of a ‘Head spin’ reading your data. But it does appear that SDC continue to draw the ‘Wool over the eyes’ of their electorate. Currently they do what they want without any credible opposition.

    Like

  4. SDC know that they have no credible opposition, therefore the time is rife for them to bulldoze all propositions before the Public/ interested factions and present a ‘Fait Accompli’ to support their Ill-thought decisions.

    On their building programme, I would remind them that this is a ‘Ten Year’ programme as opposed to a ten minute programme. You can take your time you know. Numbers given down from Government have to be met by a given date. not next Wednesday..

    Slow down, give your residents time to assimilate that their light, view, seperation from neighbours, are about to be destroyed by your plans.

    Or, you could look towards sites where there was no detriment to the existing residents

    Like

  5. Attending one of those “Consultations” on the future of Shepway, it was noticeable that whenever the leader of the councils name was mentioned with attached aggravation, cynicism, frustration, laughter at the ridiculous figure he sometimes cuts, mostly pure rage and hatred at the feeling of helplessness he often generates in his “flock”, that one of his representatives, there to keep an eye on proceedings, was seen to laugh, snigger, and obviously thought all this frustration was funny.

    In a generous moment, you may think that this representative was laughing in embarrassment at the home truths being hurled at the meeting. Another councillor was not seen to laugh and looked very uncomfortable at finding themselves observing the frustration of many good people who had been driven to venting their feelings in a public forum.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: