Scenario 3: Improving how local populations engage with social spending data to ensure sustainable investments in their communities.

The scenario

Once upon a time... the mining sector of a resource-rich country was experiencing growing investor interest driven by strong global demand for minerals used in low-carbon technologies. Within this context, the populations living near mines wanted to understand if their communities really benefited from the mining sector’s activity. To answer that question, the Extractive Industries Transparency Initiative (EITI) published annual reports with detailed information about social spending by mining companies, which detailed the value of community payments made by companies as well as information on the intended purpose and beneficiaries of the payments. However, the EITI’s staff found that community members living near mining projects rarely read the reports.

Every day... EITI staff would wonder about the lack of interest in that data within communities. Speaking with community representatives, they found the explanation: many community members were not aware that EITI reports contained that data, and those who did had difficulty making sense of the information as it was buried in long data tables. This was a problem, because the data could help community members better assess if companies delivered on their promised social spending and the extent to which it aligned with community priorities. Chief among those priorities was making sure that the investments were making the community more resilient. But this wouldn’t be possible unless the information was presented in a more accessible and engaging way.

This is where your proposal comes in.

One day... (what will you do to address the problems and challenges being faced?)

Because of that... (what changes will your solution bring?)

Until finally... the EITI was able to present information on social payments in a much more compelling way. This allowed community members to better understand how company payments were impacting their lives. Community members started using EITI data to hold companies accountable when they were not making the payments they had committed themselves to or when money was being wasted on projects that communities did not want. This led to improvements in the governance of social payments, ensuring that they reached their intended beneficiaries, and genuinely improved the livelihoods of community members.


data visualisation EITI report local communities pedagogy actionable information social payments data

Scenario Starter Kit

Recommendations for your design process

Who will be your audience and users?

The key stakeholders for this scenario are:

Recommended data and resources

Data and resource documentation

Summary Data from EITI Reports

What is it?

Data files collected by using Summary Data Templates and organized in folders by country. These include a wide range of fiscal, legal and contextual data related extractive industries, including company-by-company revenue data.

Where to get it?

The data is shared freely in this Google Drive as per EITI's Open Data Policy.

Tips and advice about the resource

  • What's in the folders - The data files are organised in folders by country and contains:
    • Excel files of summary data for a specific year. Some are “proxy” files, with aggregate data, as the full summary data sheet from the implementing country are not yet available.
    • The EITI Report that is the basis of the Summary Data.
  • Summary data templates - the summary data spreadsheets available from the folder use two template versions depending on the year of the report—most reports from 2018 use version 2.0 while those prior to 2018 use version 1.1. Always refer to the Introduction tab (usually the first one) of each summary data spreadsheet to determine what version is used and what information each of the tabs contain.
  • Sources of the data - Recent data has been provided by Independent Administrators and National Secretariats of the EITI, while data from older reports are continuously being compiled by the International Secretariat itself.
  • Data quality - Implementing countries are responsible for ensuring that this data is accurate. For detailed information, you may consult the original reports. Where figures are not available in US dollars, the annual average exchange rate is used.
  • Not all files are in English - whenever applicable, the language used in the files is indicated in the file name by a two-letter code (e.g. EN - English, ES - Spanish, FR - French, DE - German).
  • Not all PDF reports have the same tables - not all reports have the same tables or have them on the same pages, utilize the table of contents and list of tables to determine if the data you are looking for is in the report.

Social and environmental expenditures

What is it?

Data on social and environmental expenditures disaggregated by companies, beneficiaries and spending.

Where to get it?

You can find this data in EITI reports and summary data files.
Examples include :

Tips and advice about the resource

  • Country-level data can be obtained from the summary data files which are commonly in spreadsheet format
  • Subnational data is available from EITI reports but scraping the data is needed as these reports are commonly in PDF format.


What is it?

A REST Application Programming Interface (API) to programmatically access EITI data.

Where to get it?

You can access the API and its documentation at

Tips and advice about the resource

  • Most of the data needed for the scenario should be available from the Summary Data but you may opt to use the API if you think you need to programmatically access information or are looking for specific data point.

Submit your proposal for this scenario

The EITI Datathon 2022 is brought to you by: