{"id":10762,"date":"2024-03-24T12:07:56","date_gmt":"2024-03-24T12:07:56","guid":{"rendered":"https:\/\/davelevy.info\/wiki\/?p=10762"},"modified":"2025-08-10T15:07:55","modified_gmt":"2025-08-10T15:07:55","slug":"measuring-political-donations","status":"publish","type":"post","link":"https:\/\/davelevy.info\/wiki\/measuring-political-donations\/","title":{"rendered":"Measuring Political Donations"},"content":{"rendered":"\n<p>I have been to a couple of Campaign Lab &#8220;Hack Days&#8221; and picked up a project on measuring political donations. I decided to take an innovate, don&#8217;t invent approach, i.e. improve what&#8217;s already there. <\/p>\n\n\n\n<p>I revisited this page to see if we could measure the donations made by private sector and foreign owned businesses. Here are my notes &#8230;<\/p>\n\n\n\n<!--more-->\n\n\n\n<h3 class=\"wp-block-heading\">What I found<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>On the first day, found <a href=\"https:\/\/github.com\/neilhawkins\/political-donations\">the code for such a web page<\/a>; I have reverse engineered the data model and database, and have made a <a title=\"Neil Hawkin's web site, donations for 2012\/13\" href=\"http:\/\/davelevy.info\/nh\/\">landing page for my implementations<\/a> of this tool; I have inserted my data file into Neil\u2019s code and it can be <a href=\"http:\/\/davelevy.info\/nh\/Q423\/\">viewed here for Q4 23<\/a> and also <a href=\"https:\/\/davelevy.info\/nh\/2023\/\">for all 2023<\/a>, although I need to do some work with the javascript; this page&#8217;s presentation is not very satisfactory. I made <a href=\"https:\/\/github.com\/dfl1955\/political-donations\">a fork of Neil&#8217;s code<\/a>. NB I should have created a data file for H1 24 but didn&#8217;t.<\/li>\n\n\n\n<li>On my third visit, I met the author of donation whistle, who posted his <a href=\"https:\/\/github.com\/willthong\/donation-whistle\">code on github<\/a>. When I first met Will, he had the site up and running at <s>https:\/\/donationwhistle.willthong.com\/<\/s>, but when I looked at it yesterday <em>9 Aug 2025<\/em>, it seems to have been taken down, but he now <a href=\"https:\/\/www.willthong.com\/donation-whistle.html\">has a blog page<\/a>. I really like this; it has a real time feed from the EC and answers some of the questions one wants to ask really well. I have starred it in github and raised one issue already.<\/li>\n\n\n\n<li>I was later pointed at <a href=\"https:\/\/www.mysociety.org\/democracy\/who-funds-them\/\">who funds them<\/a> at mysociety.org<\/li>\n\n\n\n<li>In addition, Campaign Lab has incubated <a href=\"https:\/\/conservativepartyfunding.co.uk\/\">Who funds the Conservative Party?<\/a><\/li>\n<\/ol>\n\n\n\n<p>I have worked with my 2023 extract to prototype some of the queries I plan to run and report on. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">April 2024<\/h3>\n\n\n\n<p>I think there are three dimensions we want to measure, and my experience is that this may be best done by quarter. As it the moment, I am restricting myself to chart formats supported by excel. I am also restricting myself to the three big parties. These restrictions are because of the difficulty in handling the large and small scales required. The charts are,<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The amount of money by top three parties, by quarter<\/li>\n\n\n\n<li>Neil&#8217;s buckets by quarter, as the year doesn&#8217;t scale within the infographic<\/li>\n\n\n\n<li>a size of donation frequency distribution by party<\/li>\n\n\n\n<li>funding by source, both volume and as a proportion of total; it might be good if we could build dynamic charts to turn public funding on\/off. <\/li>\n<\/ul>\n\n\n\n<p>The screen  might look like this, or the front page could have buttons to second pages to deal with Money, Neil&#8217;s buckets, frequency within Party and by source. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2024\/04\/draft-political-funding.png\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"475\" src=\"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2024\/04\/draft-political-funding.png\" alt=\"\" class=\"wp-image-10901\" srcset=\"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2024\/04\/draft-political-funding.png 750w, https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2024\/04\/draft-political-funding-300x190.png 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p>At the moment, I plan to make the charts, and use the code to present them. <strong>NB <\/strong>(I didn&#8217;t).<\/p>\n\n\n\n<p>The best I did was the last image on <a href=\"https:\/\/davelevy.info\/wiki\/political-donations-2023\/\">https:\/\/davelevy.info\/wiki\/political-donations-2023\/<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">WordPress Charting<\/h3>\n\n\n\n<p>I found these pages<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/crocoblock.com\/blog\/best-wordpress-chart-plugins\/\">https:\/\/crocoblock.com\/blog\/best-wordpress-chart-plugins\/<\/a> an antholoogy review<\/li>\n\n\n\n<li>And two plugins <a href=\"https:\/\/en-gb.wordpress.org\/plugins\/wpdatatables\/\">https:\/\/en-gb.wordpress.org\/plugins\/wpdatatables\/<\/a> &amp; <a href=\"https:\/\/en-gb.wordpress.org\/plugins\/visualizer\/\">https:\/\/en-gb.wordpress.org\/plugins\/visualizer\/<\/a><\/li>\n<\/ol>\n\n\n\n<p>The <a title=\"web widgets data table charts wordpress plugin\" href=\"https:\/\/letmegooglethat.com\/?q=web+widgets+data+table+charts+wordpress+plugin\">query<\/a> I used to find the tools. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">My data sources<\/h3>\n\n\n\n<p>Mainly the <a href=\"https:\/\/www.electoralcommission.org.uk\/\">EC<\/a>, <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Their<a href=\"https:\/\/search.electoralcommission.org.uk\/\/?currentPage=0&amp;rows=10&amp;sort=AcceptedDate&amp;order=desc&amp;tab=1&amp;et=pp&amp;et=ppm&amp;et=tp&amp;et=perpar&amp;et=rd&amp;isIrishSourceYes=true&amp;isIrishSourceNo=true&amp;prePoll=false&amp;postPoll=true\u00aeister=gb\u00aeister=ni\u00aeister=none&amp;optCols=Register&amp;optCols=CampaigningName&amp;optCols=AccountingUnitsAsCentralParty&amp;optCols=IsSponsorship&amp;optCols=IsIrishSource&amp;optCols=RegulatedDoneeType&amp;optCols=CompanyRegistrationNumber&amp;optCols=Postcode&amp;optCols=NatureOfDonation&amp;optCols=PurposeOfVisit&amp;optCols=DonationAction&amp;optCols=ReportedDate&amp;optCols=IsReportedPrePoll&amp;optCols=ReportingPeriodName&amp;optCols=IsBequest&amp;optCols=IsAggregation\"> search portal<\/a>, with filters set<\/li>\n\n\n\n<li>Their <a href=\"https:\/\/www.electoralcommission.org.uk\/2019-candidate-spending?section=data&amp;filters=%255B%257B%2522candidate%2522%253A%257B%2522id%2522%253A1716%252C%2522value%2522%253A%2522vicky%2520foxcroft%2522%252C%2522label%2522%253A%2522Vicky%2520Foxcroft%2522%252C%2522meta%2522%253A%255B%2522Labour%2520Party%2522%252C%2522Lewisham%252C%2520Deptford%2522%255D%257D%257D%255D\">candidate spending page for 2019<\/a>, does this do all, or only those that spend more than an amount<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>I have been to a couple of Campaign Lab &#8220;Hack Days&#8221; and picked up a project on measuring political donations. I decided to take an innovate, don&#8217;t invent approach, i.e. improve what&#8217;s already there. I revisited this page to see if we could measure the donations made by private sector and foreign owned businesses. Here&#8230;<\/p>\n","protected":false},"author":1,"featured_media":10460,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_share_on_mastodon":"0"},"categories":[140],"tags":[2050,2045,141],"class_list":["post-10762","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-politics","tag-campaignlab","tag-donations","tag-politics-2"],"share_on_mastodon":{"url":"https:\/\/mastodon.social\/@davelevy_eu\/112150582302426634","error":""},"jetpack_featured_media_url":"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2024\/02\/sterling-christopherbill-unsplash-w1080.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/10762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/comments?post=10762"}],"version-history":[{"count":12,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/10762\/revisions"}],"predecessor-version":[{"id":12812,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/10762\/revisions\/12812"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media\/10460"}],"wp:attachment":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media?parent=10762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/categories?post=10762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/tags?post=10762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}