MyNixOS website logo
Description

Fetch Data from Plataforma +Brasil (SICONV).

Fetch data on targeted public investments from Plataforma +Brasil (SICONV) <http://plataformamaisbrasil.gov.br/>, the responsible system for requests, execution, and monitoring of federal discretionary transfers in Brazil.

siconvr

CRANstatus R-CMD-check Codecov testcoverage Travis buildstatus

siconvr is an R package designed to fetch and clean data on federal targeted transfers in Brazil from Plataforma +Brasil (previously SICONV). With siconvr, obtaining data on available policy programs maintained by the Brazilian Federal Government, proposals submitted by local governments, and NGOs to apply for such funds, among many others, takes a few seconds.

Installing

Install the package from CRAN using:

install.packages("siconvr")

To install the package’s development version, use:

if(!require(remotes)) install.packages("remotes")
remotes::install_github("meirelesff/siconvr")

Then load it with:

library(siconvr)

How to use

Using siconvr to fetch data from Plataforma +Brasil is easy: pass the type of data you want to the get_siconv function and you are ready to go. Here’s an example:

progs <- get_siconv("programas")

Available datasets

Here a list of available datasets one can fetch using siconvr:

OptionData
programasdata on available programs maintained by the Federal Government
programas_propostaskeys to match programs and proposals submitted to the Federal Government
propostasdata on proposals submitted to the Federal Government
conveniosdata on proposals effectively accepted situation and amount transferred by the Federal Government
emendasdata on federal budget amendments made by Brazilian Federal Deputies and Senators, amount transferred and the transference recipient;
planosdata on application plans submitted to the Federal Government. This document includes all goods, services and works required by the covenant to accomplish the project
empenhosdata on transfers which the Federal Government has reserved its budget to pay the covenant when the project ends
desembolsosdata on transfers disbursements by the Federal Government
obtvdata on payments made to local suppliers and contractors hired to execute funded projects
historicoproposals’ track record
ingresso_contrapartidarecord of counterpart payments
aditivosdata on contracts’ budget addendums
crono_metasproject’s goals timeline
cronogramasproject’s execution timeline
consorciosdata on proposals where multiple local governments or private entities cooperate to request federal resources
empenhos_desembolsoskeys to match appropriations and disbursements by Federal Government
proponentesdata on proposals’ proponents
cronograma_desembolsosproject’s transfers disbursements timeline
justificativasproposals’ justifications

Schema

It also possible to check Plataforma +Brasil’s database official documentation – which includes the database diagram and schema, additional information on tables and variables, primary keys, among others – by using this:

show_schema()

show_schema will extract, read, and open in a web browser the database’s docs. Files are saved in the working directory, so one doesn’t need to download them again (to just download the docs, set the argument browser to FALSE).

Options

By default, get_siconv tries to read fetched data using UTF-8 encoding. In case this does not work for you, use the argument encoding to change that:

emp <- get_siconv("empenhos", encoding = "latin-1")

To save Plataforma +Brasil server resources, get_siconv stores a cache of fetched data in a folder in working directory named cache – so you don’t need to download the same data again. To avoid cacheing date, set cache to FALSE:

obtv <- get_siconv("obtv", cache = FALSE)

Finally, one might also want to avoid get_siconv’s messages when fetching data. This can be done with:

historico <- get_siconv("historico", verbose = FALSE)

Contributing

We welcome any help to improve siconvr. In case you wish to contribute with code, use GitHub Pull Requests – we will be more than happy to acknowledge any assistance by updating our authors’ list. Bug reports and suggestions can be done via GitHub issues.

Disclaimer

siconvr does not maintain or update Plataforma +Brasil’s database, nor does it change or alter fetched data. Therefore, the authors hold no responsability for its uses or results.

In case you want to dive deeper into Plataforma +Brasil’s sources and update policy, please check the following official sources:

Authors

Fernando Meireles e Marcus Vinícius de Sá Torres.

Metadata

Version

0.0.1

License

Unknown

Platforms (75)

    Darwin
    FreeBSD
    Genode
    GHCJS
    Linux
    MMIXware
    NetBSD
    none
    OpenBSD
    Redox
    Solaris
    WASI
    Windows
Show all
  • aarch64-darwin
  • aarch64-genode
  • aarch64-linux
  • aarch64-netbsd
  • aarch64-none
  • aarch64_be-none
  • arm-none
  • armv5tel-linux
  • armv6l-linux
  • armv6l-netbsd
  • armv6l-none
  • armv7a-darwin
  • armv7a-linux
  • armv7a-netbsd
  • armv7l-linux
  • armv7l-netbsd
  • avr-none
  • i686-cygwin
  • i686-darwin
  • i686-freebsd
  • i686-genode
  • i686-linux
  • i686-netbsd
  • i686-none
  • i686-openbsd
  • i686-windows
  • javascript-ghcjs
  • loongarch64-linux
  • m68k-linux
  • m68k-netbsd
  • m68k-none
  • microblaze-linux
  • microblaze-none
  • microblazeel-linux
  • microblazeel-none
  • mips-linux
  • mips-none
  • mips64-linux
  • mips64-none
  • mips64el-linux
  • mipsel-linux
  • mipsel-netbsd
  • mmix-mmixware
  • msp430-none
  • or1k-none
  • powerpc-netbsd
  • powerpc-none
  • powerpc64-linux
  • powerpc64le-linux
  • powerpcle-none
  • riscv32-linux
  • riscv32-netbsd
  • riscv32-none
  • riscv64-linux
  • riscv64-netbsd
  • riscv64-none
  • rx-none
  • s390-linux
  • s390-none
  • s390x-linux
  • s390x-none
  • vc4-none
  • wasm32-wasi
  • wasm64-wasi
  • x86_64-cygwin
  • x86_64-darwin
  • x86_64-freebsd
  • x86_64-genode
  • x86_64-linux
  • x86_64-netbsd
  • x86_64-none
  • x86_64-openbsd
  • x86_64-redox
  • x86_64-solaris
  • x86_64-windows