Data Extractors Programme

Data Extractors Programme
  • Studies include: Convincing parliamentarians of the negative financial impact of passing a new law

  • Studies include: Engaging community members with complex data

    Engaging community members with complex data
  • Studies include: Assessing the wide reach of extractives companies in Africa

Data Extractor Case Studies

Why mandatory disclosures matter for Indonesia

by Meliana Lumbantoruan, PWYP Indonesia

The global transparency wave has reached Indonesia. Initiatives such as the Extractive Industries Transparency Initiative (EITI) are bringing more transparency to Indonesia and the mandatory disclosures laws of the EU have led to more data on extractive activities in Indonesia becoming available.

Read more and download PDF here

Making DATA work for communities project

by Marco Zaplan, previously with Bantay Kita-PWYP Philippines

Citizens and communities in extractive areas have the right to know how their finite natural resources are governed. As more and more extractives data is opened to the public, the more challenging it becomes to make these disclosures relevant to local communities.

Read more and download PDF here

Community data literacy for demand driven change

by Mukasiri Sibanda, PWYP Zimbabwe

The need for this pilot stemmed from the realisation that calls by CSOs and CBOs for improved transparency and accountability in the management of mineral wealth tends to generally overshadow the use of available data to demand accountability. There was also the realisation that publicly available data from local sources, such as local government budgets and financial statements, has so far not been used to its full extent to empower citizen participation in local public financial management systems. The data from the EU, UK and Canada mandatory disclosure of payments made to governments by Multinational Corporations (MNCs) in the extractives also needs to be used more thoroughly.

Read more and download PDF here

Developing a handbook for using project-level data

by Dominic Eagleton, Global Witness, member of PWYP UK

Laws compelling extractive companies to report their payments to governments at the project level have been adopted in the EU, the US, Canada and Norway. The EITI has agreed to roll out project-level reporting across all 51 of its implementing countries. Early adoption of the regulations in the UK, France and Norway resulted in dozens of companies reporting in 2014 and 2015, with thousands more set to publish reports in the coming years.

Read more and download PDF here

Sapin II: a very opaque transparency bill in France

by Quentin Parrinello, PWYP France

Between 2012 and 2014, France was considered a champion of corporate transparency by its European peers. In 2013, the French Parliament passed a law setting a public country-by-country reporting (CBCR) for banks which likely influenced the vote for the EU Capital Requirements Directives (CRD) a few months later. Public CBCR is widely seen as an efficient way to monitor tax strategies of multinational companies, forcing them to disclose information on their operations (turnover, profits, taxes, subsidiaries, etc) on a country-by-country breakdown (including tax havens). In 2014, France was one of the first countries to transpose the EU Transparency and Accounting Directives, setting up public reporting for extractive companies, different from CBCR but equally useful, commonly known as Payment to Government reporting (PtG reporting).

Read more and download PDF here

Using UK company data as an accountability tool

by Miles Litvinoff, PWYP UK

After well over a decade-and-a-half of campaigning by the Publish What You Pay (PWYP) anti-corruption movement, oil, gas and mining companies are starting to report payments to governments under long-awaited mandatory disclosure rules. By 2019 an estimated 84% or more of the world’s 100 largest oil and gas companies, and at least 58% of the largest 100 mining companies, will be required by law to disclose their payments. The global extractives transparency standard will have well and truly arrived.

Read more and download PDF here

Is the United States getting a good deal on its natural resources? A taxing question.

by Jana Morgan, PWYP US

This case study began with a not-so-simple question: Is the United States getting a good deal for the depletion of its natural resources? Publish What You Pay – United States (PWYP-US) has worked for 13 years to open the books of oil, gas and mining companies to create a more open and accountable extractives sector. More than a decade into this effort, many of the world’s largest oil, gas and mining companies now disclose their project-level payments to governments, either voluntarily or in compliance with legal requirements. Yet, a few major US oil companies – namely ExxonMobil, Chevron and ConocoPhillips – remain strongly opposed to these simple financial disclosures.

Read more and download PDF here

Resources

Find:

UK Companies House extractives service

Payments to governments’ reports from extractive companies listed or headquartered in the UK.

Canada Extractive Sector Transparency Measures Act

Payments to governments’ reports from extractive companies listed or headquartered in Canada.

EITI country reports

EITI compliant countries and those implementing procedures reports produce annual EITI reports that include government revenue and company payments.

NRGI ResourceData.org

ResourceData.org is an online repository of timely datasets on extractives sector governance, and is hosted and maintained by the Natural Resource Governance Institute (NRGI).

Open Oil repository

This is a repositiory for the world’s oil contracts, making them easily available.

OpenCorporates

OpenCorporates is an open database of companies and company data in the world, with in excess of 100 million companies in a similarly large number of jurisdictions.

Wayback machine

This internet archive is a digital library of internet pages through which you can find previous versions of web pages, and thus information that may be no longer available or outdated.

Google Search, and other web search engines.

Search engines are designed to search for information on the World Wide Web. Targeted searching, through keywords and the use of quotation marks, can help find specific information and data.

Get:

Google Chrome scraper

Scraper gets data out of web pages and into spreadsheets.

Tabula

Tabula is a tool for extracting data from PDF files into CSV and Excel files.

Google Forms

Google Forms can be used to collect and organise specific information.

Kobo Toolbox

KoBo Toolbox is a free open-source tool for mobile data collection, available to all. It allows you to collect data in the field using mobile devices.

Clean:

Cleaning data is an essential step in increasing the quality of data. Spreadsheets are one of the most commonly used tools to do so:

Google Sheets

Apache OpenOffice Calc

Microsoft Excel

OpenRefine

OpenRefine is a powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data.

Analyse:

Tableau

Tableau Public is free software that can allow anyone to connect to a spreadsheet or file and create interactive data visualizations for the web.

CartoDB

CARTO, formerly CatroDB, is an online map maker that makes it easy for anyone to communicate information with a map.

Onodo

An open source network visualization and analysis tool for non-tech users.

Google Fusion tables

Fusion Tables is an experimental data visualization web application to gather, visualize, and share data tables.

Gephi

A visualization and exploration software for all kinds of graphs and networks. Gephi is open-source and free.