How to Use Google Refine to Fill Gaps in a Dataset

This post also appears on Extract-A-Fact In our first video training session, we presented a walkthrough of how to organize USEITI data for use in the open source mapping software QGIS. Fortunately, that dataset included geographic identifiers called Federal Information Processing Standard (FIPS) county codes–five digit codes identifying counties and county equivalents throughout the United States. However, not every dataset…

Oil, Gas and Mining Transparency Advocates Join the Data Revolution

This post originally appeared on the 2016 International Open Data Conference blog on October 5, 2016. This post also appears on Extract-A-Fact ​2016 is an historic year for transparency advocates and data geeks alike. After fourteen years of campaigning by the global Publish What You Pay (PWYP) coalition, laws requiring oil, gas and mining companies to publicly disclose project-level payments…

Extract-A-Fact Newsletter – August 2016

August 2016 Finding UK mandatory disclosure reports in one simple step Read on for an easy way to see the full list of mandatory disclosure reports submitted to Companies House Extractives Service in the United Kingdom. Read more… Guest Post – Aleph and beneficial ownership: working up from the ground Financial regulators in many countries already require companies to disclose…

How PWYP-Indonesia is Turning Extractives Transparency into Accountability

The Importance of Project by Project Disclosure Indonesia’s vast natural resources wealth includes oil, gas, bauxite, silver, and gold. Indonesia is the world’s second largest tin producer, and one of the top five producers of copper and nickel. The extractives sector plays an outsized role in the Indonesian economy: in 2014, oil, gas, and minerals were responsible for a third…

PWYP-US kicks off data skills training series

On May 19, PWYP-US hosted the first of two data skills training workshops to explore ways of using the USEITI data with the open source QGIS mapping software. In the first session, our trainer, University of Maryland Geographical Sciences PhD candidate, Diana Parker, introduced the basics of organizing data as well as an introductory understanding of geographic information systems (GIS)….

PWYP-US kicks off data skills training series: Workshop 1 – Data Organization and GIS Basics

This post originally appeared on www.extractafact.org on June 3, 2016 On May 19, PWYP-US hosted the first of two data skills training workshops to explore ways of using the USEITI data with the open source QGIS mapping software. In the first session, our trainer, University of Maryland Geographical Sciences PhD candidate, Diana Parker, introduced the basics of organizing data as…