Water and Sanitation Sector Integrity Risk Index (WIRI)

Survey Data



What is WIRI?

The Water Integrity Risk Index (WIRI) is a tool for measuring integrity in the water and sanitation sector at the city level. It allows you to assess smaller changes in integrity across cities within a country and over time.

WIRI produces a score between 0 and 100. Cities with scores closer to 100 have lower risks of corruption.

WIRI is not based on perceptions, but on both Big Data on procurement and (if available) surveys. To use this tool, you need data: 1) on public procurement contracts related to water and sanitation, and 2) (optionally) survey data on direct experiences with corruption (i.e. bribery) in the sector.

Once your data set(s) are in the the necessary format, you can upload it/them to the control panel (on the left). The manual will guide you in creating new water and sanitation procurement data sets from publically available information, as well as the necessary format for uploading survey data. You may find the manual in WIRI manual tab (above), or in this link.

Here you can find the the example data sets on procurement and survey data for Peru (Spanish). Here you can find a public the repository of procurement and survey data sets created by other users as well as the team behind WIRI. You may contribute to this repository by uploading your own data sets and notifying us using this submission form.

Once all data sets are formatted correctly, they should be uploaded to the tool and it will calculate the WIRI score for each city/year. You will see the results summary in the dashboard panel (above).

How to use this tool?

To use this tool, you will need to upload some data sets: procurement (mandatory), survey (optional) and keywords (optional). These data sets must be constructed in the format detailed in the WIRI tool manual (see tab above). We provide some example data sets based on procurement and survey data for Peru.

Once you have the required data set(s), please follow these steps:

  1. Select no survey OR upload survey data (CSV) when available
  2. Upload procurement data (CSV)
  3. Select keywords language (Spanish, English) OR upload your own custom keywords (CSV)
  4. Click submit
  5. The section diagnostics will inform you if the calculations were successfull
  6. Go to the dashboard tab and view the results
  7. In the dashboard, you can explore the composite WIRI score and its sub-components.

WIRI Data Repository

You may also consult (and contribute to) the repository of WIRI data sets here. If you wish to share your data sets with other users, please fill out the data sharing form before you upload them to the shared repository. Keep in mind that data sets uploaded to the tool are not automatically shared in the repository.

Water Integrity Risk Indicator Results

The table shows the average WIRI score (with each of its three pillars) for all cities in the data set. You may download the full city/year (time-series) data by clicking the button below.
The bars show the average score for the WIRI indicator or one of its pillars. The vertical dashed line shows the country indicator average. Cities below the country average are shown in gray.
The points represent the number of procurement contracts found in the cities with most data available. This is available for the WIRI indicator or any one of its three pillars (Investments, Operations, Interactions).
The line represents the score for the composite WIRI indicator (or one of its pillars) over time for the top 5 cities with most observations. The horizontal line is the country indicator average.


            

How to contruct data sets for WIRI



Data Sharing Form




For any issues or questions regarding this online tool, please email the developer: Alfredo Hernandez Sanchez

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License .