digital solutions to improve democracy
Budeshi (which is Hausa for "Open it") is a dedicated site that links budget and procurement data to various public services. It is accessible to the public to interact with and make their own comparisons.
In a bid to make information around public contracts and the procurement process more coherent, Budeshi is an attempt to demonstrate the Open Contracting Data Standards (OCDS) across the public procurement value chain.
Where can I find, explore and visualise information about Peru’s procurement?
Pro-veedor is a tool developed by Open Data Peru that gives oversight of public procurement in Peru. The team are looking into adopting OCDS and we hope to see that in action soon.
OpenProcurement is an open source e-procurement toolkit.
OpenProcurement's goal is to provide the tools to design and build a procurement process that is transparent and competative. The toolkit builds accessible processes that leverage auctions to drive savings and are backed by strong data collection and reporting. It is designed to be automated and scalable. Accessibility, transparency of tendering process, electronic documents, detailed reporting - these are only a few benefits of using this e-Procurement software.
OpenProcurement’s initial application was with ProZorro, a procurement system implemented to support multiple national government agencies in Ukraine. OpenProcurement is flexible enough to handle all shapes and sizes of government and private sector procurements.
The basic toolkit, which covers storing data and reverse auctions, is free. The toolkit's Data Standard was developed on the basis of Open Contracting 1.0RC. These data standards were extended to ensure practical implementation of the procurement process in the Prozorro system.
ProZorro Explorer is designed to perform a 360-degree analysis of procurement in a chosen area: goods, categories, tenders, lots, tenderers and complaints in Ukraine procurement.
The Governement of Moldova’s beta portal was developed by the Public Procurement Agency under the Ministry of Finance. This interactive tools allows anyone to explore, visualize and download key contracting data stored using the Open Contracting Data Standard.
The real-time visualizations include tenders, awards, agencies and a section dedicated to goods, services and public works.
How can I get some or all records published to the Open Contracting Data Standard from ProZorro’s Open Procurement tenders API?
For Joomy Korkut, this meant writing a script to support downloading and generating CSV files from the Open Procurement tenders API. This is an invaluable tool for analysts and is available on github under an MIT license.
How can I extract a list of suppliers to Montreal City so I can combine it with other city data?
Pascal Robichaud posed this question on the Civic Access forum which led to Glen Newton producing this one-off example using GO.
For developers, it provides an adaptable component to speed up development of a python-based tool that extracts similar information. For Pascal, it provided fast and useful insight into Montreal’s public procurement.
Where can I find contracting opportunities from over 60 countries around the world from 240 publishers in OCDS format in one place?
Open Opps provides enriched, third-party information on public procurement aimed at business. Each opportunity is available to download in the OCDS JSON format. Find the out more on the Open Opps website.
How can I get public procurement information for the city of Montreal published to the OCDS format?
Ville de Montréal is the city of Montreal’s platform for citizens and businesses. The Vue sur les contrats section provides insight and visualization into public procurement within the city. While the platform does not yet support the Open Contracting Data Standard internally, it does provide a means to export the information to OCDS JSON.
This means developers and users of city of Montreal procurement information can combine and re-use this information to better understand the landscape of public procurement in the city (for example Open Contracting Montreal: Supplier List)
Find out more about the Ville de Montréal vue sur les contrats platform or review the OpenNorth OCDS API code on github.
How do I combine multiple OCDS records for the same contracting process?
Providing transactional information throughout the lifetime of a contracting process is a key goal for many governments disclosing their public procurement information. These transactions or releases tell a detailed procurement story through key moments in the contracting process, giving the public both an overview and a history of the process. This allows for better understanding, improved monitoring and sufficient detail for accountability.
So how can we put these releases back together into a single record of the contracting process? Answering this question led the OCDS helpdesk to develop OCDS Merge, a tool aimed at developers. Our official tool takes the merging logic described by the standard and implements it as a Python module.
How do I make OCDS even more useful?
The Open Contracting Data Standard (OCDS) is extensible - this means that publishers can provide additional information that reflect how procurement works in their country, their organisation or their sector. We encourage publishers to be open about creating extensions as they may find some extensions apply to others in their community using the same language, on the same continent or in other geo-economic groups.
While publishers can provide ad-hoc extensions, creating a formal extension means they can define rules around what the each field in the extension is and how it is used. To make this process easier, faster and more adaptable, the OCDS helpdesk team created the OCDS Extension Creator, a tool for implementing re-usable OCDS extensions.
How do I convert OCDS data from JSON to Spreadsheets and back again?
When converting files from Open Contracting Data Standard (OCDS) JSON to spreadsheets or vice versa, we usually recommend using the data standard validator tool. What if your file is too large or you’d rather do that conversion yourself?
Our Flatten Tool is part of the underlying code used by the data standard validator tool. It is a general purpose tool with the goal of allowing a dataset to be round-tripped between structured JSON and tabular data packages or spreadsheets: providing a bridge between richly structured datasets and accessible flat formats.Like all our tools, it is completely free and available on github.
How do I check OCDS data is valid?
The Open Contracting Data Standard (OCDS) exists to formalise how contracting data and documents can be published in an accessible, structured and repeatable way. This means anyone using the standard, either publishing to the standard or using information publishing to the standard, should be able to check the information is technically valid. You may also want the data in a different form, perhaps a spreadsheet.
The data standard validator tool helps anyone using or publishing OCDS data to:
1. Check that OCDS data complies with the schema.
2. Inspect key contents of the data to check data quality.
3. Access the data in different formats (spreadsheet and JSON) to support further data validation and analysis.
How can I work with Open Contracting records in my favourite database?
The OCDS helpdesk faced this challenge when we began to deep dive into OCDS publications to provide richer insight and support to publishers.
For many analysts, tools supporting JSON may not be a familiar as databases. We use a mixture of SQLite and PostgresSQL for analysis, while our publishers and partners may also favour MySQL or Microsoft SQL Server. With this in mind, the OCDS helpdesk developed an unofficial tool – OCDS Tabulate. With this tool, analysts can convert valid OCDS JSON to relational database of their choice. It handles the core OCDS schema including extra fields added by publishers to provide richer context.
Imagine if you could find contracting information as easily as a web search?
This is one of the drivers behind Colin Maudry’s project to produce a linked data schema for OCDS. The project is still in it’s infancy, so if you have an interest in Linked Open Data, RDF or JSON-LD, contributing to this project will make Open Contract Data Standard - Linked Data Edition a reality.
How can I easily explore an OCDS record?
The Open Contracting Data Standard (OCDS) is modular. This means it is made up of building blocks that describe certain concepts like dates and organisations, including the information we expect those concepts to contain. For example, an organisation could have a name they trade with and a legal name which they are known as to the organisation that registers and regulates them. These building blocks are re-used in sections and structures that describe procurement, from buyers to suppliers, tender to awards, contracts and implementation.
Feedback from users of OCDS showed that visualising their contract information to surface the information in each building block, section or stage is invaluable. OCDS Show helps publishers validate the information by checking that it appears as it should. For developers, it is a reusable component to speed up development of procurement exploration tools and for anyone digging into a JSON file in the OCDS format, it provides fast, visual insight.
Gobierno Facil is a civil society organisation that is experimenting with easier ways for citizens to explore and understand Mexican federal procurement data. By scraping the data which is in OCDS format and building digital tools, they hope to simplify the format and extend the use of procurement information. At present, there are a limited number of large value contracts listed while the tool is developed.
The M&E dashboard was designed to help procurement officials and citizens to gain insight on the efficiency and competitiveness of procurement practices, and value attained across public procurement. This flexible tool employs a variety of interactive charts, graphs, and web GIS to enable user-friendly exploration of the data. A small selection of questions this tool can help answer include:
- Which procuring entities are receiving the highest average number of bidders per competitive bid process?
- Are some procurement methods better at achieving value for money than others?
- Which are the largest tenders and largest awards in rural areas?
- Which regions are receiving the greatest portions of procurements?
- Are procurement processes more efficient for certain procurement types?
- Are large procurements more or less efficiently carried out than smaller procurements?
- Which bid selection methods are most frequently cancelled?
This tool is currently available for deployment with customizations based on data availability and quality.
Contrataciones Abiertas de la CDMX helps citizens of Mexico City explore their city’s public procurement along every stage of the procurement process.
The exploration tool gets its information in OCDS format from an api. This api makes public procurement information from CDMX available to anyone to use as open data.
The public portal of the national directorate of public procurement in Paraguay features multiple contract visualizations. These work in tandem to help citizens understand activity around public procurement.
This tool is based on OCDS data and includes:
Quantity and Amount Visualization
Public procurement can be complex with a single contract involving a number of stakeholders. Contracts can also range in quantity and amount which is where this visualization helps. Volume of contracts can be viewed by quantity and by the contract amount.
Stages of each contracting process including dates
This tools helps interested parties track the progress of individual tenders in a clear visualisation.
Citizens can get insight into contract delivery schedules using this heatmap that tracks planned supply deliverables by year, month and day.
Developed by Procurement Analytics, this dashboard provides insights into Mexico's procurement performance. It allows anyone using the dashboard to explore Mexican public procurement as a summary, by timeliness, by cost efficiency or by fairness. Further filtering is possible. Apart from the information available, you can filter by the supplier, type of contract or contract procedure.
There are several handy hints provided to explain the filters available.
Contracts Finder lets you search for information about contracts worth over £10,000 with the government and its agencies.
You can use Contracts Finder to:
search for contract opportunities in different sectors
find out what’s coming up in the future
look up details of previous tenders and contracts
Contracts Finder outputs contracts as OCDS via it's API
In lieu of a physical investigation, it can be difficult to attribute certainty to any data-based approach to corruption identification. Consequently, our approach, outlined in a freshly published report co-authored with OCP, aims to identify the risk of corruption by triangulating indicators that point to the possibility of specific corruption types:
Fraud: when a bidder falsifies information submitted to the procuring entity;
Collusion: when bidders work among themselves to try to obtain particular outcomes;
Process rigging: when government officials distort the procurement process, whether in collusion with suppliers or in demand of a kickback, to seek a certain outcome.
This approach, and the more than 60 indicators we’ve developed, builds off the work of the likes of the International Anti-Corruption Resource Center, DigiWhist, and the Government Transparency Institute (Budapest). It also benefits from our experience building procurement analytics tools in Vietnam and Nepal, and conducting open contracting scoping studies in five West African nations and countries throughout Asia.
- See more at: http://www.developmentgateway.org/2016/12/01/corruption-risk/#sthash.HyO69I3m.dpuf