Projects
These are the projects I have created or taken part in, on my own or with Pythonic Café: platforms that make public data accessible and tools for journalists, journalistic investigations in which I handled the data work, and the free software I develop and maintain. Each one shows when I worked on it and links to the project, the code and, when there are any, the news stories.
Platforms
VacinaBR
Built with Instituto Questão de Ciência. Launched in December 2023 and updated ever since.LupaScan
Tool by Agência Lupa, a Google News Initiative winner, that monitors content published by elected officials. I was the technical lead of its development in two phases: from February to November 2023 and from July to December 2024.DisinformationData journalismArtificial intelligence Project site
Monitor da Fiscalização do Desmatamento
A MapBiomas initiative built by the teams of Instituto Centro de Vida and Brasil.IO: it gathers public data on deforestation permits, fines and embargoes and matches it against MapBiomas deforestation alerts. The data stopped being updated in January 2026.Graúna
Web archiving project with Nupef. With it, I was a fellow of the Media Democracy Fund's Tech Exchange program, from March 2022 to March 2023.CruzaGrafos
Graph platform for journalists, built with Abraji and winner of the 2019 Google News Initiative Challenge. It crosses Brasil.IO data to browse the relationships between people, companies and candidates, find paths between them and export the data. I led its development.Brasil.IO
Platform that frees public data and makes it accessible: it gathers, cleans and publishes datasets such as Brazil's federal company and partner registry, elections and judges' salaries. During the pandemic, it organized with dozens of volunteers the open dataset of COVID-19 cases and deaths by municipality.
Journalistic investigations
Médicos negacionistas
Investigation led by Fabiana Cambricoli (Estadão), with the Ciência Suja team, supported by ICFJ's Disarming Disinformation, with Instituto Serrapilheira. I handled the data work, with Pythonic Café: collecting and transcribing videos, AI summaries and search, techniques I show in the Abraji workshop. Stories (in Portuguese):
Venda de curas milagrosas pela Internet
Investigation led by Jaqueline Sordi (Instituto Questão de Ciência), with Veja Saúde and Fronteira, supported by ICFJ's Disarming Disinformation, with Instituto Serrapilheira. I handled the data work, with Pythonic Café, using the techniques I show in the Abraji workshop. Stories:
- Jolivi: o lucrativo e obscuro mercado das falsas curas (Revista Questão de Ciência, in Portuguese)
- Empresas lucram vendendo falsas curas naturais na internet (Veja, in Portuguese)
- Mercadores da cura (Veja Saúde, in Portuguese)
- Jolivi: The shady and highly profitable online market for false cures in Brazil (The Skeptic)
Agronegócio e a negação do aquecimento global
Investigation led by Giovana Girardi (Agência Pública), with Climainfo and netlab/UFRJ, supported by ICFJ's Disarming Disinformation, with Instituto Serrapilheira. I handled the data work, with Pythonic Café, using the techniques I show in the Abraji workshop. Stories:
- Agronegócio e extrema direita impulsionam máquina de fake news sobre aquecimento global (Agência Pública, in Portuguese)
- Máquina da desinformação climática é patrocinada pelo agronegócio e a extrema-direita (Climainfo, in Portuguese)
- In Brazil, Agribusiness Lobby and Far-Right Politicians Sow Climate Disinformation (NACLA), Covering Climate Now award winner
Nome aos Bois
Project by Repórter Brasil, with data analysis by Pythonic Café, winner of the 2023 Gabo Award.
Free software
rows
Library that makes it easy to access, convert and clean tabular data in many formats.socios-brasil
Open data on companies, establishments and partners from Brazil's Federal Revenue Service.eleicoes-brasil
Data on candidacies, declared assets, donations and campaign spending for many elections.transparencia-gov-br
All datasets available on the Brazilian Federal Government's Transparency Portal.youtool
Python library for easy access to YouTube data, including metadata and content download.tchan
Python library and CLI to extract posts from public Telegram channels.digue
Local voice dictation and transcription using whisper.cpp (GNU/Linux only).
Support
Support Brasil.IO
Brasil.IO publishes clean, accessible Brazilian public data for free. Donations keep the servers running and the data collection going.
APOIA.seSponsor my free software
Direct support for maintaining the free software libraries and tools I develop.
GitHub SponsorsÁlvaro Justen (@turicas) repositories
turicas/brasil.io
Backend do Brasil.IO (para código dos scripts de coleta de dados, veja o link na página de cada dataset)
turicas/rows
A common, beautiful interface to tabular data, no matter the format
turicas/socios-brasil
Captura os dados de sócios das empresas brasileiras na Receita Federal e exporta para um formato legível por humanos
turicas/covid19-br
Dados diários mais recentes do coronavírus por município brasileiro
turicas/salarios-magistrados
Baixa as planilhas de salários de magistrados, extrai os contracheques, limpa e exporta pra CSV
turicas/eleicoes-brasil
Scripts para capturar dados do Repositório de Dados Eleitorais do TSE, limpá-los, normalizá-los e agrupá-los
turicas/sbc
SBC - Use SSH Like a Boss!
turicas/Ethernet_ENC28J60
[NOT MAINTAINED, NOT COMPLETED] Implementation of an Arduino-compatible socket layer library that uses Microchip ENC28J60 Ethernet controller.
turicas/crau
Easy-to-use Web archiver
turicas/transparencia-gov-br
Scraper do Portal da Transparência do Governo Federal, em Python 3
turicas/nubank-to-csv
Script para converter a fatura do NuBank (em PDF) para um CSV lindão
turicas/genero-nomes
Classifica nomes por gênero de acordo com API do IBGE
turicas/braindump
braindump: low-tech dump of my neurons
turicas/capturando-dados-sem-dor-de-cabeca
Material do tutorial "Capturando dados sem dor de cabeça"
turicas/mongodict
MongoDB-backed Python dict-like interface
turicas/cursos-prouni
Baixa dados relativos aos cursos que possuem bolsas integrais e parciais no PROUNI
turicas/gastos-deputados
Script que baixa, extrai e limpa dados de gastos da cota parlamentar
turicas/templater
Extract, parse and populate templates from strings
turicas/censo-ibge
Scripts de captura para dados do Censo IBGE
turicas/mandados-de-prisao
NÃO FUNCIONA MAIS POR CONTA DA NOVA VERSÃO DO BNMP. Scripts que coletam mandados da Base Nacional de Mandados de Prisão
turicas/pastebin-cli
Command-line interface to paste code/text to pastebin.com
turicas/processos-stf
Script que baixa todos os processos do STF baseado na listagem disponível nas atas de distribuição
turicas/droiduino
Control your house via Internet using your Android phone with Python and Arduino!
turicas/brasil
Python library to access Brazilian data through Brasil.IO API
turicas/plotter
Plot data from CSV using Python, matplotlib and outputty
turicas/pybitcask
A pure-Python implementation of Basho's bitcask key-value store.
turicas/DS1307
Arduino library for reading and setting date and time for the DS1307 Real-Time Clock IC
turicas/shapefiles-brasil
Coleta shapefiles do IBGE, converte para GeoJSON e gera versões simplificadas
turicas/autuacoes-ambientais-ibama
Extrator de PDFs de Autuações Ambientais do IBAMA
turicas/luminaria-rgb
Luminária RGB controlada por Arduino e Android, via Ethernet
turicas/no-silence
Automatically detect and delete silince parts in videos
turicas/slides
Slides of my talks
turicas/pycopy
API wrapper to Copy.com compatible with Dropbox API
turicas/dados-parana
Scrapers que capturam dados sobre o estado do Paraná e seus municípios
turicas/data-worker
Conjunto de scripts que roda scripts de coleta, extração e limpeza de dados do Brasil.IO
turicas/festival-de-curitiba
Scraper que baixa os eventos que acontecerão no Festival de Curitiba (2019)
turicas/learning-sockets
turicas/vortaroj
A Python dict that speaks many languages
turicas/dotfiles
Some of my dotfiles
turicas/simulado-detran-rj
Crawler das questões do simulado do DETRAN-RJ
turicas/tweetlamp
Activate/deactivate any AC device by tweets using Arduino
turicas/easygpg
Easy-to-use command-line interface to GnuPG
turicas/tabula-docker
Script to build docker images for Tabula releases using Eclipse Temurin
turicas/turicas.github.io
Personal web page
turicas/curriculum-vitae
My curriculum, in LaTex :)
turicas/curso-python-verao-2012
Resposta de alguns exercícios do curso de Python (EMAp/FGV, verão 2012)
turicas/lista-anistiados
Script que extrai a lista de anistiados em PDF (2015 e 2018) e gera CSV
turicas/SNES
Arduino library to get state of the buttons of a SNES controller.
turicas/tomada-bluetooth
Tomada controlada por Bluetooth pelo Android
turicas/async_process_executor
Python class to asynchronously execute tasks in processes
turicas/carmomaq
Utilities to collect data and control Carmomaq coffee roasters
turicas/countdown-traffic-light
Python+Arduino-based countdown for 5min lightning talks that acts as a traffic-light
turicas/ddwrtdb
Simple CLI to search on DD-WRT router database and retrieve router information
turicas/docker-python-old
Docker images for old Python versions based on newer Debian (bookworm)
turicas/fabric-recipes
Some useful fabric recipes
turicas/nlplaying
My playings in Natural Language Processing, in Python.
turicas/websitetopdf
Simple app to demonstrate the usage of simplefractal/heroku-buildpack-wkhtmltopdf
turicas/agensgraph-docker
Agensgraph Docker image based on official PostgreSQL image
turicas/cursodearduino.com.br
Site do Curso de Arduino
turicas/pytches
Play old-style musics using Python and beep (Unix)
turicas/row
Reference implementation of a new tabular data format created by dataprotocols
turicas/strobo
turicas/docker-ollama
My Ollama configuration using Docker Compose, runs on Radeon 780M iGPU
turicas/Genuino
Jogo da memória para Arduino
turicas/git_inspect
Tools to inspect git repositories
turicas/google-developer-day-2011
Minha implementação para resolver a provinha para entrar no Google Developer Day 2011 Brasil/São Paulo - e eu passei! \o/
turicas/hrv
A Python module for Heart Rate Variability Analysis
turicas/jsock
Key-value-based, HMAC-signed, non-blocking sockets for Python
turicas/old-pypelinin-text
Pipelines to process text in Python
turicas/ptwp_tagger
Tagging Portuguese Wikipedia with PyPLN and Palavras
turicas/site-render
turicas/site-teste
turicas/slides-ssh-avancado-e-sbc
Slides of my talks
turicas/dominios.br
Código Python para encontrar domínios .br em textos
turicas/mail_reply_cleaner
Clean reply lines on mail (text) messages, using Python
turicas/mapa-empoderamiento
Mapa con las instituciones de empoderamiento en Ecuador
turicas/test_rows
Tests of the rows library (https://github.com/turicas/rows) for parsing biodiversity data
turicas/vcard-qrcode
Store vCard on QRcodes
Pythonic Café repositories
PythonicCafe/mercados
Biblioteca Python com scrapers para acessar dados do mercado financeiro brasileiro (fundos imobiliários, CRAs, CRIs, debêntures, negociação bolsa e balcão etc.)
PythonicCafe/youtool
Python library + CLI to easily access YouTube Data API in batches + scraping
PythonicCafe/blog.brasil.io
Blog do Brasil.IO
PythonicCafe/tchan
Scrape Telegram public channels (Python library + CLI)
PythonicCafe/contributor-network
Code Contributor Network Graph
PythonicCafe/outgram
Python client library and CLI to Threads and Instagram public GraphQL APIs
PythonicCafe/pydokku
Python library to interface with Dokku
PythonicCafe/cookiecutter-dokku-django
Cookiecutter template for creating a Django app deployed by Dokku
PythonicCafe/divida-ativa
Baixa e limpa lista de devedores da Dívida Ativa da União (PGFN)
PythonicCafe/digue
Local speech-to-text dictation and transcription using whisper.cpp (GNU/Linux only)
PythonicCafe/dados-aviacao
Conjunto de scripts para tratar dados sobre a aviação brasileira
PythonicCafe/dokku-metabase
Deploy Metabase on a Dokku host
PythonicCafe/table-actions
Simple & customizable table with sort and checkbox functions in vanilla JS
PythonicCafe/djpg-example
Sample Django project for talk "PostgreSQL Beyond Django: Strategies to Get Max Performance"
PythonicCafe/docker-tinyproxy
Simple Dockerfile and Makefile to run tinyproxy quickly.
PythonicCafe/dokku-apache2-webdav
Web app with Dokku-based deployment to expose a server directory through WebDAV
PythonicCafe/dokku-auto-deploy
Automatically deploy a Dokku app based on Github merges without adding credentials to Github
PythonicCafe/dokku-flask-sample
Sample Flask app with postgres and a persistent volume to be deployed on Dokku
PythonicCafe/map-chart-table
PythonicCafe/modal-actions
Simple & customizable modals with actions and navigation, forms and more
PythonicCafe/PythonicCafe.github.io
Site Pythonic Café
PythonicCafe/select-actions
Multiselect interface drowpdown with selects
PythonicCafe/table-actions-extra
Table Actions with extra dependecies and functionalities
PythonicCafe/toast-actions
Simple & customizable toast alerts
PythonicCafe/transcricoes.brasil.io
Transcrições pesquisáveis das sessões públicas do Legislativo brasileiro
PythonicCafe/urlid
A universal identifier system for data reconciliation