Reproducible Research Repository
Reproducible Research Repository
  • Home
  • Repository
  • Collections
  • About
    Home / Repository / PRWP / RR_BRA_2023_19-V01
PRWP

Reproducibility package for MiDES: New Data and Facts from Local Procurement and Budget Execution in Brazil

2023
Get Reproducibility Package
Reference ID
RR_BRA_2023_19-v01
DOI
https://doi.org/10.60572/hmam-p072
Author(s)
Ricardo Dahis, Bernardo Ricca, Thiago Scot, Nathalia Sales, Lucas Nascimento
Collections
World Bank Policy Research Working Papers
Metadata
JSON
Created on
Nov 06, 2023
Last modified
Feb 07, 2024
  • Project Description
  • Downloads
  • Overview
  • Reproducibility Package
  • Description
  • Scope and coverage
  • Disclaimer
  • Access and rights
  • Contacts
  • Information on metadata
  • Citation
  • Overview

    Abstract

    This paper introduces a newdisaggregated and harmonized dataset on public procurement and budget execution by Brazilian subnational entities, which currently covers half of Brazilian municipalities and spans the years 2003-2021. It then uses these data to provide new stylized facts about local public finance. First, it shows that about one-quarter of government purchases are from suppliers in the same municipality and discusses its possible implications for efficiency in public purchases. Second, it creates a measure of payment delay to suppliers: close to 15% of total payments are delayed by more than 30 days and payment timeliness is systematically correlated with local income.

    Reproducibility Package

    Scripts
    Readme Get Reproducibility Package
    Link: https://reproducibility.worldbank.org/index.php/catalog/72/download/176/README.pdf
    Reproducibility package for MiDES: New Data and Facts from Local Procurement and Budget Execution in Brazil
    Title
    Reproducibility package for MiDES: New Data and Facts from Local Procurement and Budget Execution in Brazil
    Date
    2023-10
    Software
    Python, R
    Dependencies
    - Python: pandas, numpy, os, glob, zipfile, datetime, tabulate, matplotlib, seaborn, geopandas, basedosdados, getpass - R: data.table, ggplot2, ggpubr, modelsummary, tinytex, DescTools, binsreg, basedosdados, ggtext, dplyr
    Notes
    Computational reproducibility verified by Development Impact (DIME) Analytics team, World Bank.
    Source code repository
    Repository name URI
    Reproducible Research Repository (World Bank) https://reproducibility.worldbank.org
    Software
    Python
    Name
    Python
    Version
    3.10.9
    R
    Name
    R
    Version
    4.3

    Reproducibility

    Technology environment

    Paper exhibits were reproduced in two computers with the following specifications:
    Computer 1 (Python code):

    • OS: macOS Ventura
    • Processor: Apple M1
    • Memory available: 8 GB
    • Software: Python 3.11.4
      Computer 2 (Python + R code):
    • OS: Windows 11 Enterprise
    • Processor: Intel(R) Core(TM) i5-1145G7 CPU @ 2.60GHz
    • Memory available: 15.7 GB
    • Software: Python 3.11.4, R 4.3
    Technology requirements

    10 minutes runtime

    Reproduction instructions

    Follow instructions in the README to recreate the environments and reproduce the results.

    Data

    Datasets
    MiDES: dissagregated and harmonized dataset on public procurement and budget execution by Brazilian municipalities
    Name
    MiDES: dissagregated and harmonized dataset on public procurement and budget execution by Brazilian municipalities
    Access policy
    Data is public and included in the reproducibility package.
    Data URL
    https://basedosdados.org/dataset/d3874769-bcbd-4ece-a38a-157ba1021514?table=14c5d05b-9830-4710-b7ac-7e0ca1bf9d8b
    Data statement

    All data is public and contained in the reproducibility package.

    Description

    Output
    MiDES: New Data and Facts from Local Procurement and Budget Execution in Brazil
    Type
    Working paper
    Title
    MiDES: New Data and Facts from Local Procurement and Budget Execution in Brazil
    Authors
    Ricardo Dahis, Bernardo Ricca, Thiago Scot, Nathalia Sales, Lucas Nascimento
    Description
    Policy Research Working Paper (PRWP) 10598
    URL
    http://documents.worldbank.org/curated/en/099456511072320917/IDU0577a4ea10ff8504db6089400548fa91b30a3
    DOI
    https://doi.org/10.1596/1813-9450-10598
    Authors
    Author Affiliation Email
    Ricardo Dahis Monash University, Data Basis ricardo.dahis@worldbank.org
    Bernardo Ricca Insper bernardoogr@insper.edu.br
    Thiago Scot World Bank tscot@worldbank.org
    Nathalia Sales PUC-Rio nathalia.msales@gmail.com
    Lucas Nascimento World Bank, Data Basis lnascimentomorei@worldbank.org
    Date of production

    2023-10

    Scope and coverage

    Geographic locations
    Location Code
    Brazil BRA

    Disclaimer

    Disclaimer

    The materials in the reproducibility packages are distributed as they were prepared by the staff of the International Bank for Reconstruction and Development/The World Bank. The findings, interpretations, and conclusions expressed in this event do not necessarily reflect the views of the World Bank, the Executive Directors of the World Bank, or the governments they represent. The World Bank does not guarantee the accuracy of the materials included in the reproducibility package.

    Access and rights

    License
    Name URI
    Modified BSD3 https://opensource.org/license/bsd-3-clause/

    Contacts

    Contacts
    Name Affiliation Email
    Thiago Scot World Bank tscot@worldbank.org
    Reproducibility WBG World Bank reproducibility@worldbank.org

    Information on metadata

    Producers
    Name Abbreviation Affiliation Role
    San Martin LESM World Bank Junior data scientist
    Date of Production

    2023-10-26

    Document version

    1

    Citation

    Citation
    loading, please wait...
    Citation format
    Export citation: RIS | BibTeX | Plain text
    Back to Catalog
    The World Bank Working for a World Free of Poverty
    • IBRD IDA IFC MIGA ICSID

    © The World Bank Group, All Rights Reserved.