bckgound

You are viewing the article 'Help Me Turn The Tables On Government Surveillance' filed under 'about'

Welcome to Australia's biggest political and financial transparency project!

Click to view the options and mouseover buttons to see option displayed or click to select. Click on menu pinned to the top of each page to switch between projects.

Help me turn the tables on government surveillance

Rosie Williams


Commonwealth grants will help fill the blanks in understanding who gets what, but my work needs your support
Following general [focus group] discussion about ABS, its role and how it is perceived, the concept of the ‘evolution of the ABS’ was introduced by the moderator. This concept was explained as a transition from ‘snapshots in time’ featuring single data sets to ‘movies’ whereby data sets are linked either across time or across different data collections. (Colmar Brunton, 2014)

In a country where the government is hard at work joining administrative data from different agencies together to create a 'movie' of our lives, very little is being invested in the flip-side of this equation: tranpsarency and accountability of government and the reasons behind the decisions of the powerful. Apparently Australia's open data policy is about putting the poor and vulnerable under a microscope, not improving and increasing the data the public is most interested in- who and what is influencing decision-makers.

Today I launch a funding drive to add yet another project to my large and colourful pallette. In this article I'm going to overview the recent changes I've made across the entire site.

AusGov.info is a massive transparency project which is made up of multiple projects allowing the search and analysis of financial data published by the Commonwealth government. Theses projects allow search and analysis across multiple datasets to highlight potential links between say, political donations, tax deductions and government tenders. This type of research puts the focus back where it needs to be: on the people making the decisions and the people benefiting from them.

Each of these projects 'heros' a particular dataset- allowing search and totalling across a comprehensive range of variables. There are actually more projects than appear in the main menu (pinned to the top of each page) which now only features the main ones used by the public.

About

Launched at Linux Conference Australia in January 2018, this site has received well over 2 million hits from over 40,000 unique visitors with data used in campaigns from anti-racism to the transparency of religious charities. Click the green circle to read more or skip to articles.

Meetings

Find out who's meeting who with NSW Ministerial diaries data

Search by:
  • Date
  • Organisation Name
  • Agenda topic
  • Ministry

Interests

Search the pecuniary interests register for potential conflicts of interest and which politicians own property near you

Search by:
  • Representative
  • Keyword
  • Category
  • Party
  • Property Location

Donations & Tax

See tax paid by top-earning corps, relevent gifts, shares & tenders

Search by:
  • Revenue
  • Tax Paid
  • Donors
  • Party
  • All datasets

Tenders

Find out who gets the biggest tenders & which countries supply the govt

Search by:
  • Biggest tenders
  • Agency
  • Supplier
  • Description
  • Title
  • Country

Charities

Find out which charities receive the most in donations and where they operate

Search by:
  • Organisation
  • Assets
  • Revenue
  • Donations
  • Activity
  • Electorate
  • Operating Country

It is easy to get overwhelmed with the amount of information on the site. It is helpful to think of it as a library. If you go into a library expecting to get across every book, it is overwhelming so I've tried to simplify navigation within and between projects to improve usability. All the projects work the same way. There are two main buttons in each page. The main menu is pinned to the top of each page and is used to switch between the projects.

The second button reveals the search options within each specific project. These vary from project to project depending on the characteristics of the dataset it features. The Commonwealth tenders project only contains tenders data (integrated with mapping data) because it is such a huge and complex dataset.

Other projects hero certain datasets but also provide results from other projects. It is only by integrating data that patterns and relationships can be spotted. The example of this integration which is easiest to use and most powerful is the advanced search which provides matches from NSW Ministerial Meetings, pecuniary interests, AEC political donations, tax transparency data, Commonwealth tenders, ACNC charities data and DGR data. I've embedded an example search for records matching Woolworths.



NSW Ministerial Diary Meetings

DateOrg.ReasonMinistry
1 Nov 2018 Woolworths Group Agriculture issues Minister for Primary Industries Minister for Regional Water and Minister for Trade and Industry
2 Sep 2017 Woolworths Introductory meeting Minister for Finance and Services and Property
3 Mar 2017 Woolworths Limited Introductory meeting Minister for Environment Local Government and Heritage
4 May 2016 Woolworths Limited To discuss developments in the retail sector Premier
5 May 2016 Woolworths Limited Meeting with new Head of Corporate Affairs of SunRice Minister for Education
6 May 2016 United Petroleum, Woolworths Limited, 7-Eleven Stores To discuss NSW biofuels mandate Minister for Innovation Better Regulation
7 Mar 2016 Woolworths Limited To discuss NSW planning system Minister for Planning
8 Feb 2016 Woolworths Limited D To discuss the biofuels mandate Minister for Innovation and Better Regulation
9 Jan 2016 Woolworths Boardroom Lunch Treasurer
10 Dec 2015 Woolworths Ltd To discuss ethanol mandate Minister for Innovation and Better Regulation
11 Nov 2015 Woolworths Refugee Resettlement Corporate Stakeholder Roundtable Premier
12 Oct 2015 Woolworths Limited Lunch and tour of The Wine Quarter Deputy Premier
13 Jul 2015 Woolworths Ltd Introduce Director, Group Retail Services Minister for Roads, Maritime and Freight
14 Feb 2015 Woolworths Limited To discuss business in NSW Premier
15 Feb 2015 Woolworths Limited To discuss Macquarie Law School and Macquarie University programs and issues Minister for the Environment
16 Oct 2014 Woolworths Limited Roundtable with Western Sydney Business Chamber to discuss sustainable development in Western Sydney Minister for the Enivronment
17 Aug 2014 Woolworths Address Woolworths Agricultural Business Scholarships Program Minister for Primary Industries
18 Jul 2014 Woolworths Ltd Woolworths investment pipeline; Masters Home Improvement NSW rollout Minister for Planning
19 Jul 2014 Woolworths Liquor Group Introductory meeting and discussion about liquor licensing Minister for Hospitality Gaming Racing Arts



Pecuniary Interests Register

Angus Taylor
Liberal Party of Australia
Angus Taylor
Liberal Party of Australia
Gifts Tickets to Sydney Institute dinner - 2 x tickets (value $600) - guests of Woolworths - 22 May 2018
Dan Tehan
Liberal Party of Australia
Dan Tehan
Liberal Party of Australia
Travel/Hospitality Attendance at the fundraising 2018 Annual Dinner for The Melbourne Foundation for Business and Economics in Melbourne on 8 March 2018 as a guest of Woolworths Group - 15 Mar 2018
John Alexander
Liberal Party of Australia
John Alexander
Liberal Party of Australia
Shareholdings Woolworths - 01 Mar 2018
Mitch Fifield
Liberal Party of Australia
Mitch Fifield
Liberal Party of Australia
Gifts Bottle of wine, Riversdale Estate Crux NV - Woolworths Group, 16 August 2017 - 28 Aug 2017
Nigel Scullion
Country Liberal Party
Nigel Scullion
Country Liberal Party
Gifts Woolworths Flavours of Tasmania - Riversdale Estate CRUX NV Tasmania Bottle - 17/8/17 - $40 - 24 Aug 2017
Ted O'Brien
Liberal Party of Australia
Ted O'Brien
Liberal Party of Australia
Shareholdings Woolworths Limited - 05 Oct 2016
Ted O'Brien
Liberal Party of Australia
Ted O'Brien
Liberal Party of Australia
Shareholdings Woolworths Limited - 05 Oct 2016
David Gillespie
The Nationals
David Gillespie
The Nationals
Shareholdings Woolworths - 30 Sep 2016
David Gillespie
The Nationals
David Gillespie
The Nationals
Shareholdings Woolworths - 30 Sep 2016
Brian Mitchell
Australian Labor Party
Brian Mitchell
Australian Labor Party
Shareholdings Woolworths Limited FPO (WOW) - 27 Sep 2016
Ross Hart
Australian Labor Party
Ross Hart
Australian Labor Party
Shareholdings Woolworths Limited - Springford East Superannuation Fund - 22 Sep 2016
David Littleproud
The Nationals
David Littleproud
The Nationals
Shareholdings Woolworths - 16 Sep 2016
David Littleproud
The Nationals
David Littleproud
The Nationals
Shareholdings Woolworths - 16 Sep 2016
Jim Chalmers
Australian Labor Party
Jim Chalmers
Australian Labor Party
Gifts Press Gallery Ball (31 August 2016), Woolworths - 14 Sep 2016


AEC Annual Party Returns

Summary by Recipient

Count Recipient Value
1 Labor - Fed $27,500

Individual Payments

Year Donor Recipient Type
1 14-15Woolworths Limited Labor - Fed Subscription $27,500


Tax Transparency data is reported in December each year by the ATO and includes gross income, taxable income and tax payable. Australian public and foreign owned corporate tax entities with total income of $100 million or more Australian-owned resident private companies with total income of $200 million or more. This chart provides financal year revenue for matching entities on the ATO tax transparency list that match 'Woolworths'.


ATO Transparency Data

2 Top-Earning company name(s) matching Woolworths

Click on name to filter or show more details

Year Corps % of Taxable $ Tax $ Income $ Revenue $ AVG Revenue
13-14 1 28.76 0.911 3.167 49.679 49.679
14-15 1 28.93 0.899 3.107 49.481 49.481
15-16 1 26.82 0.497 1.853 49.414 49.414
16-17 1 27.60 0.522 1.890 50.184 50.184

The results above are expressed in billions can be affected by corps moving in and out of the top-earners dataset over the included years

YearName Tax Taxable Revenue
1 13-14 WOOLWORTHS LIMITED $910,864,515 $3,167,025,868 $49,679,048,321
2 14-15 WOOLWORTHS LIMITED $898,750,445 $3,107,162,066 $49,481,153,978
3 15-16 WOOLWORTHS LIMITED $496,872,267 $1,852,662,288 $49,414,150,955
4 16-17 WOOLWORTHS GROUP LIMITED $521,637,795 $1,889,950,092 $50,183,971,688



Commonwealth Tenders Data

Supplier Date Title Value
1 WOOLWORTHS Jul 2019 INCENTIVE GIFT CARDS JOB SEEKER SURVEY $142,700
2 WOOLWORTHS FINANCIAL SERVICES Jun 2019 SUPPLY OF GROCERIES $67,000
3 WOOLWORTHS FINANCIAL SERVICES Jun 2019 SUPPLY OF GROCERIES $55,000
4 WOOLWORTHS FINANCIAL SERVICES May 2018 SUPPLY OF GROCERIES SEAFOOD AND EGGS $50,000
5 WOOLWORTHS FINANCIAL SERVICES May 2018 SUPPLY OF GROCERIES $50,000
6 WOOLWORTHS Apr 2018 KATHERINE - BOTTLED WATER SOLUTION $281,280
7 WOOLWORTHS Sep 2017 KATHERINE - BOTTLED WATER SOLUTION. $620,000
8 WOOLWORTHS FINANCIAL SERVICES Jul 2017 SUPPLY OF GROCERIES $68,200
9 WOOLWORTHS FINANCIAL SERVICES Jul 2017 SUPPLY OF GROCERIES $71,000
10 WOOLWORTHS AND SAFEWAY SUPERMARKETS May 2017 SUPPLY OF GROCERIES EGGS AND SEAFOOD $71,000
11 WOOLWORTHS FINANCIAL SERVICES May 2017 SUPPLY OF GROCERIES $20,500
12 WOOLWORTHS AND SAFEWAY SUPERMARKETS Jul 2016 SUPPLY OF GROCERIES EGGS AND SEAFOOD $38,300
13 WOOLWORTHS FINANCIAL SERVICES Jun 2016 SUPPLY OF GROCERIES $50,500
14 WOOLWORTHS FINANCIAL SERVICES Mar 2016 SUPPLY OF FRESH RATIONS $20,000
15 WOOLWORTHS AND SAFEWAY SUPERMARKETS Aug 2015 FRESH RATIONS $35,090
16 WOOLWORTHS Jul 2015 GROCERY SUPPLIES FOR GILES AWS $43,875
17 WOOLWORTHS FINANCIAL SERVICES Jul 2015 SUPPLY OF FRESH RATIONS $30,500
18 WOOLWORTHS FINANCIAL SERVICES Sep 2014 FRESH RATION $72,700
19 WOOLWORTHS AND SAFEWAY SUPERMARKETS Aug 2014 FRESH RATIONS $54,600
20 WOOLWORTHS AND SAFEWAY SUPERMARKETS Sep 2013 FRESH RATIONS SUPPLIES $60,100
21 WOOLWORTHS FINANCIAL SERVICES Jul 2013 FRESH RATION $82,700
22 WOOLWORTHS FINANCIAL SERVICES Apr 2013 SUPPLY OF GROCERIES $61,000
23 WOOLWORTHS FINANCIAL SERVICES Jul 2012 FRESH RATIONS $136,500
24 WOOLWORTHS Jun 2012 FRESH RATIONS $45,000
25 WOOLWORTHS AND SAFEWAY SUPERMARKETS Sep 2011 SUPPLY OF FOOD ITEMS $11,565
26 WOOLWORTHS FINANCIAL SERVICES Jul 2011 FRESH RATIONS $138,500
27 WOOLWORTHS FINANCIAL SERVICES Jul 2011 FRESH RATIONS $15,300
28 WOOLWORTHS May 2011 GROCCERIES FOR STH QLD $29,540
29 WOOLWORTHS FINANCIAL SERVICES May 2011 FRESH RATIONS $19,800
30 WOOLWORTHS FINANCIAL SERVICES Apr 2011 PROCUREMENT OF FRESH RATIONS $32,200
31 WOOLWORTHS FINANCIAL SERVICES Mar 2011 FRESH RATIONS $19,000
32 WOOLWORTHS FINANCIAL SERVICES Dec 2010 FRESH RATIONS $25,100
33 WOOLWORTHS FINANCIAL SERVICES Aug 2010 FRESH RATIONS $25,500
34 WOOLWORTHS FINANCIAL SERVICES Aug 2010 RATIONS FY 10/11 $91,000
35 WOOLWORTHS Jan 2010 PROVISIONS WILLIS ISLAND DECEMBER 2009 $11,116
36 WOOLWORTHS Q’LAND Sep 2009 GROCERIES $10,382
37 WOOLWORTHS Q’LAND Sep 2009 SSUPPLY OF GROCERIES SE QLD $11,680
38 WOOLWORTHS FINANCIAL SERVICES Sep 2009 RATIONS $143,000
39 WOOLWORTHS FINANCIAL SERVICES Jul 2009 SUPPLY OF GROCERIES $54,900
40 WOOLWORTHS SA DIVISION Jul 2009 SUPPLY OF FRESH RATIONS $35,500
41 WOOLWORTHS FINANCIAL SERVICES Jun 2009 SUPPLY OF GROCERIES $15,000
42 WOOLWORTHS SA DIVISION May 2009 SUPPLY OF FRESH RATIONS $55,500
43 WOOLWORTHS Q’LAND Apr 2009 SUPPLY OF GROCERIES SE QLD $15,400
44 WOOLWORTHS FINANCIAL SERVICES Apr 2009 SUPPLY OF GROCERIES $46,099
45 WOOLWORTHS Feb 2009 PROVISIONS FOR WILLIS IS FACILITY DEC 2008 $12,151


ACNC Annual Information Statement Data

Total revenue for each matching charity is totalled over the years reported in Australian Information Statements to the Australian Charities and Not-for-Profit Commission.

Years NameActivityBRC Revenue



You are viewing results for Woolworths. Click on the tabs to display data or download results displayed as CSV.

Downloads are free up to 2000 rows (combined). For combined results of over 2000 rows charge for download is 0.001c per row.

79 rows matching 'Woolworths' is free

You can use the links that appear within each result tab to find further information on each individual result. This search is also embedded on the home page an appears at the top of every article (above) to make it easy to find. I recently took the step of adding CSV downloads to this cross search. I have added a small fee which applies to results which are over 2000 rows (combined across all datasets). The fee works out as $1 for every 1000 rows and is calculated on a row by row basis. I anticipate most results are under 2000 so will be free.

Today I also launch a funding drive to add Commonwealth grants. While Commonwealth tenders data across all agencies has been collated into a single dataset for download for years, it was a long road to have the same level of accountability implemented with Commonwealth grants. Grants.gov.au (a site similar to AusTenders) finally launched in January 2018.

You can get a good taste of what the Commonwealth grants data looks like in my just published article on religious charities although it's worth noting that the data has not been properly checked or cleaned.

Meet the religious charities who hide their wealth from public scrutiny

To create the project which allows search and analysis of Commonwealth grants, I will need to go back over the data I originally collected years ago from each of the agency sites and make sure it is as complete as I can get it. Grants.gov.au only contains grants reported from January 2018. Pior to this each agency published grants in their own format, schema, making integrating this data into a single dataset very labour intensive.

One big issue with the grants prior to Grants.gov.au is that (unlike with Commonwealth tenders), no ABN was included with any of the published data. Administrative datasets collected in the course of the government carrying out its functions (as opposed to those collected solely for research) have quality issues that make them very challenging to work with.

A main issue is that organisation names are spelled every which way that a human being can find to spell it. This is a major problem with Commonwealth tenders where organisations also have multiple ABNs because it hampers the capacity to find or total spending for each specific organisation. Finding ways to resolve these issues is technically difficult and often under-estimated. ABN was finally introduced to Commonwealth grants reporting with the launch of Grants.gov.au. (despite being specified in RMG 412 but ignored for years).

I have had to face a chicken and egg challenge with such a large and complex project in that people want to see the evidence of what comes at the end of a very long process of integrating multiple administrative datasets in the form of investigative journalism before they feel it is worth it to invest in this work or give credit where it is due.

In a context where the complexity of this work is too-often underestimated I struggle to solve all these problems at the same time in a time-frame that suits the 24 hour media cycle where articles are produced in hours, not the days, weeks or months that in-depth research requires.

Due to the scope and complexity of this task, I've only begun to demonstrate the value of the work in recent months in articles on the not-for-profit sector, particularly with the work on tranpsarency of religious charities. Please take a look at the about page and become a regular donor or make a one off payment. Support option are available at the foot of every page of the site.

In preparation for this funding drive, I did a wholesale re-design of every project with the aim of improving usability. This basically required me to unpick the most complex projects and stitch them back together in a way which reflected a new logic that I could apply to every project.

Usability is a huge challenge with this kind of project as the more data there is (all of which is requested by the public at some point) the more complex it is to interact with it. In a way, having so much information becomes confusing. At the same time, all the projects are here for a reason so I'm constantly trying to reconcile these conflicting ends.

The fact that this about as far from 'another Wordpress site' as you can get seems lost on a lot of people. I am not downloading code written by large groups of people, I am writing that code myself, because financial transparency through integrated data is not a content-management system and code to create it on this scale does not exist elsewhere on the web.

Each and every line of the original code and articles now constitutes over 150 MB (without the images). I believe hand-coding and maintaining a project of this size from scratch alone would be a considerable challenge for any developer. There are over 80 tables in the database totaling over 800 MB in data. While the government makes this data available, administrative data can't just be used as it is, it needs to be cleaned and often integrated with other datasets. This kind of functionality is unique to every dataset and on top of designing and creating the site, cleaning and updating the data, I have to do the investigative journalism on top of it!

I do like a challenge though and all I ask is that people help me to get from month to month so that I can continue what I have invested so much of my life in. I began crowdfunding in 2015 and there are donors who have been with me ever since. Thank you to all the people who have ever supported my work in whatever way you have done so. I am grateful for that support, and in turn, I hope that you are proud to know that you have helped make all this happen.


Copyright licence applies only to text of article (not videos, images and other included third-party content ). If you republish my work, a donation is appreciated. Click here for details.


Articles matching about


About
Meet The Maker

Published by Rosie Williams on 6th Oct 2019

There is a lot of information at this site, but where did it come from and who is responsible for it?

[33] Articles

[8] Privacy

[5] Charities

[3] Interests

[3] Security

[2] Thinktanks

[2] Budget

[2] Open Government Partnership

[2] About

[1] Tax

[1] Whistleblowing

[1] Welfare

[1] Racism

[1] Housing

[1] Immigration