The EITI regularly monitors and reviews its procedures and results. This dataset was used to inform the EITI Board in its review of Validation, the EITI's quality assurance mechanism. For a brief analysis of this data, read our blog on what can be learned from three years of Validation results.
How to update the dataset
This file is connected to various parts of the EITI's API. To obtain the latest available data:
Open the Excel file attached below
Go to the tab "Data"
Click "Refresh all"
Allow the queries to work for about one minute, then click "Refresh all" again
The data should then load within a couple of seconds. This dataset was latest updated on 24 July 2019.
File contents
Spreadsheet name | Description |
EITI Countries | This table presents an overview of EITI countries' membership, including current status, Validation dates, and dates of membership. Countries listed as 'Others' are not considered current EITI countries. |
Global comparison table | This figure presents and overivew of the results from each EITI Validation, and the EITI Board's decision on each individual requirement per Validation. A legend explaining the differences between colour-codes is included in the sheet. |
First Validation tables | Contains three figures that presents various results from all first Validations of EITI countries (42 as of 24 July 2019). Figure 1 presents results of overall assessments, as well as results for each individual requirement. Figure 2 presents the full proportion of results, per requirement. |
Applicability | This spreadsheet includes two figures, presenting how many EITI Requirements are applicable in 1) each EITI country, and 2) by each requirement. In order to focus on specific countries or requirements, users can choose/filter among the countries and Requirements listed in the two 'slicers'. To select multiple countries or requirements, click while pressing the Ctrl or Shift buttons. |
Second Validation tables | Contains three figures that presents various results from all second Validations of EITI countries (10 as of 24 July 2019). Figure 5 presents results of overall assessments, as well as results for each individual requirement. Lastly, it presents progress on corrective actions from first Validations to subsequent ones. |
Raw Validation database | This spreadsheet includes the raw data table, pulled directly from https://eiti.org/api/v1.0/score_data. It has been included for the benefit of data users to make pivot tables and other custom analyses. |
First vs Second / Last | This spreadsheet includes a modified table which presents, per country, Validation results from first and last Validations. Here we monitor changes in progress on individual requirements, otherwise know as corrective actions. One Board-approved corrective action is developed for each requirement where countries have not made Satisfactory progress. The table enables comparison of changes in assessments by the EITI Board on these corrective actions. |
