LogoLogo
Procurement Data Crash Course
An IntroduIf it worked for Ection to Data LiteracyThe Fundamentals of Data-driven StorytellingProcurement Data Crash Course
Procurement Data Crash Course
An IntroduIf it worked for Ection to Data LiteracyThe Fundamentals of Data-driven StorytellingProcurement Data Crash Course
  • About this course
    • Course introduction
  • Module 1: How the public procurement process works
    • 1.1 Understanding the public procurement process
      • ❓Why the public procurement process exists
      • ⚖️What rules govern the public procurement process?
      • ⚙️RFQ or RFP? An introduction to the different types of tender
      • 📋The key stages of the procurement process
        • 📑Stage 1: Planning
        • 🚴‍♂️Stage 2: Initiation
        • ✔️Stage 3: Selection & award
        • 🤝Stage 4: Contract
        • 🏗️Stage 5: Implementation
      • 🛡️Why monitoring the procurement process is important
      • Test yourself: Understanding the public procurement process
    • 1.2 What does procurement data look like?
      • 💰Budgets & IRPs
      • 📃RFPs & RFQs
      • 🏆Awards
      • 📖Annual Reports
      • 🏛️The Auditor General's report
    • 1.3 Where is public procurement data published?
      • 🔍Where to find procurement data
      • 📚Maintaining your own library of procurement data
    • 1.4 Procurement oversight and monitoring for NPOs and media
      • ✋Procurement oversight guide for CSOs
      • 📺Procurement oversight guide for media
  • Module 2: Working with procurement data
    • 2.1 Whey we need machine readable data
      • Important data formats: CSVs, Excel and Google Sheets
    • 2.2 Turning websites and PDFs into machine readable data
      • Scraping data with Tabula
      • Simple web scraping with Google Sheets
      • Web scraping by inspecting network traffic
  • Useful resources and libraries
    • 3.1 Procurement data online resources
      • Importance reference resources
      • Online data repositories
  • Course testing & feedback
    • 🎓Extended course exam
    • 📝Surveys & feedback
    • ⏱️Quick course exam
  • MODULE4: Explore the OCPO procurement dashboard
    • 4.1 A walk through the OCPO COVID-19 reporting dashboard
      • Summary and Supplier page of the dashboard
      • Find supplier information from external sources
      • Navigating COVID19 Item Spend Page
      • Navigating the Transactions List Page
    • 4.2 Keep the Receipts Tool
      • Background and Introduction
      • Download data from Keep the Receipts
    • 4.3 Using KeeptheReceipts and Google Sheet for Procurement Data Analysis
      • Infrastructure Order Analysis
      • Mask Price Analysis
Powered by GitBook
On this page
  • How we developed the Keep the Receipts
  • How we update Keep the Receipt
  1. MODULE4: Explore the OCPO procurement dashboard
  2. 4.2 Keep the Receipts Tool

Background and Introduction

Previous4.2 Keep the Receipts ToolNextDownload data from Keep the Receipts

Last updated 2 years ago

How we developed the Keep the Receipts

The Keepthereceipts tool was developed mid 2020 in response to COVID19 procurement.

The aim is to catalogue South African provincial and national government spending related to COVID-19 into a machine-readable, searchable format.

The first round of data was collected by OpenUp volunteers in collaboration with Public Service Accountability Monitor (PSAM).

The data was scraped from on the OCPO website. Here is the link to the PDFs. OCPO later hid this link and it’s no longer available from the front page of the website.

Another data source was provided by M&G (Mail and Guardian) tracker.

Towards Sep 2020, we from OpenUp scraped the last page — The transaction list of the COVID-19 dashboard from OCPO.

Earlier this year, when OCPO released the Diaster Response Dashboard, OpenUp also scarped this dashboard. This is the source of disaster response dataset on this KeeptheReceipts.

All these data is uploaded on the KeeptheReceipts tool.

How we update Keep the Receipt

The dashboard updates every one to two months. We scrap the dashboard at about the same frequency. The most recent scrap is from August 16.

There are currently over 49000 procurement records from the COVID19 dashboard, and about 550 records about disaster response dashaboard.

PDFs published by each department