Water and Sanitation Sector Integrity Risk Index (WIRI)
Authors: Alfredo Hernandez Sanchez, Mihaly Fazekas, Eszter Katona
Abstract: This app allows users to measure integrity in the water and sanitation sector using data on public procurement as well as surveys. It calculates a complex indicator which allows users to measure corruption in the sector over time and at the city level. Users can upload their own data sets or use one of the data sets provided as an example. After uploading the files correctly in the control panel (first tab), users can see the results as tables and graphs in the dashboard (second tab). We provide a video tutorial and an extensive manual (third tab) to help guide users in uploading the example data sets and creating their own from publicly available sources. We hope that this tool will help different actors better monitor and combat corruption in a crucial sector for human well-being.
Full Description: ## 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.
How to use this tool?
To use this tool, you will need to upload some data sets: procurement, survey and keywords. These data sets must be constructed in the format detailed in the WIRI tool manual. 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:
- Select no survey OR upload survey data (CSV) when available
- Upload procurement data (CSV)
- Select keywords language (Spanish, English) OR upload your own custom keywords (CSV)
- Click submit
- The section diagnostics will inform you if the calculations were successfull
- Go to the dashboard tab and view the results
- In the dashboard, you can explore the composite WIRI score and its sub-components.
Shiny app: <p>Water and Sanitation Sector Integrity Risk Index (WIRI)</p>
Repo: GitHub - GovTransparencyInstitue/wiri_tool: This is the repository for the WIRI tool app.
Thumbnail:
Full image:
