Skip to content

Instantly share code, notes, and snippets.

Vitor Baptista vitorbaptista

Block or report user

Report or block vitorbaptista

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View mobility_reports.csv
We can't make this file beautiful and searchable because it's too large.
vitorbaptista / Makefile
Created Nov 8, 2019
Members list with geolocalized IPs of Iron March neo-fascist website data dump
View Makefile
csvcut -c6 core_members.csv | \
grep -v ip_address | \
xargs -L 1 ip2geotools -d dbipcity -f csv-tab
vitorbaptista / domains-4-letter-words.csv
Created Aug 12, 2018
List of Handshake domain auction dates for every <= 4 letter word in English wordlist
View domains-4-letter-words.csv
status reserved error block start name
Available False None 138816 04/25/2019 a
Reserved True None 13824 09/20/2018 aa
Reserved True None 183168 07/11/2019 aaa
Available False None 17856 09/27/2018 aah
Available False None 114624 03/14/2019 aahs
Available False None 130752 04/11/2019 aal
Available False None 21888 10/04/2018 aals
Available False None 203328 08/15/2019 aam
Available False None 38016 11/01/2018 aani
vitorbaptista / .gitignore
Last active Mar 11, 2018
OpenBelgium 2018 presentation on using Frictionless Data tools to package and validate data
View .gitignore
# Created by
### Python ###
# Byte-compiled / optimized / DLL files
# C extensions
vitorbaptista /
Created Oct 24, 2017
Remuneração dos servidores e comissionados da Câmara de SP (Referente a 09/2017)
vitorbaptista / Makefile
Last active Jun 15, 2017
Extract reimbursements from Serenata de Amor's Jarbas API
View Makefile
.PHONY: clean
all: reimbursements.csv
rm -f reimbursements.csv reimbursements.json
reimbursements.csv: reimbursements.json
@echo 'issue_date,term_id,term,applicant_id,congressperson_id,congressperson_name,congressperson_document,party,state,subquota_id,subquota_description,subquota_group_id,subquota_group_description,supplier,cnpj_cpf,passenger,leg_of_the_trip,document_type,document_number,installment,batch_number,document_id,document_value,remark_value,total_net_value,total_reimbursement_value,probability,receipt.url,receipt.fetched,last_update,available_in_latest_dataset,suspicions.irregular_companies_classifier,suspicions.meal_price_outlier,suspicions.election_expenses,suspicions.invalid_cnpj_cpf,suspicions.over_monthly_subquota_limit,suspicions.suspicious_traveled_speed_day,suspicions.meal_price_outlier,suspicions.irregular_companies_classifier' > $@
jq -r '.results[] | [.issue_date, .term_id, .term, .applicant_id, .congressperson_id, .congressperson_name, .congressperson_document, .party, .s
vitorbaptista /
Created Apr 25, 2017
Simplest DAG for OpenTrials's Airflow
from datetime import datetime
import airflow.models
from airflow.operators.latest_only_operator import LatestOnlyOperator
import utils.helpers as helpers
args = {
'owner': 'airflow',
'depends_on_past': False,
'start_date': datetime(2017, 4, 1),
'retries': 1,
vitorbaptista /
Created Oct 8, 2016
Verifyng myself on

Keybase proof

I hereby claim:

  • I am vitorbaptista on github.
  • I am vitorbaptista ( on keybase.
  • I have a public key ASCzHuiG5mXAuFZmosmpdpi4kLA8YpficoW3o3cmzrpYiAo

To claim this, I am signing this object:

vitorbaptista / newschallenge-2015-teams-countries.csv
Last active Oct 2, 2015
The NewsChallenge 2015 teams' countries
View newschallenge-2015-teams-countries.csv
url country Canada USA USA UK USA USA USA USA Congo
vitorbaptista /
Last active Aug 29, 2015
Generates CSV with name, id, email and image of the politicians on
echo "name,id,email,image"
for file in `find . -name ep-popolo-v1.0.json`
cat $file | jq -r ".persons[] | [\"$file\", .id, .email, .image] | @csv"
You can’t perform that action at this time.