Skip to content

Instantly share code, notes, and snippets.

View turicas's full-sized avatar

Álvaro Justen turicas

2.3k followers · 277 following
View GitHub Profile
@turicas
turicas / keybase.md
Created September 29, 2017 07:49

Keybase proof

I hereby claim:

  • I am turicas on github.
  • I am turicas (https://keybase.io/turicas) on keybase.
  • I have a public key whose fingerprint is A746 4A98 1CBE E320 834B 225A 8B56 B483 DE72 0B37

To claim this, I am signing this object:

@turicas
turicas / all-games.csv
Created June 23, 2017 14:09
We can't make this file beautiful and searchable because it's too large.
year,country_code,country_name,athlete,gender,age,sport,gold,silver,bronze,total
1896,AUS,Australia,Teddy Flack,Male,22,"Athletics, Tennis",2,,1,3
1896,AUT,Austria,Adolf Schmal,Male,23,"Cycling, Fencing",1,,2,3
1896,AUT,Austria,Paul Neumann,Male,20,Swimming,1,,,1
1896,AUT,Austria,Otto Herschmann,Male,19,Swimming,,1,,1
1896,DEN,Denmark,Viggo Jensen,Male,21,"Athletics, Gymnastics, Shooting, Weightlifting",1,1,1,3
1896,DEN,Denmark,Holger Nielsen,Male,29,"Athletics, Fencing, Shooting",,1,2,3
1896,DEN,Denmark,Eugen Schmidt,Male,34,"Athletics, Shooting",,,,
1896,FRA,France,Paul Masson,Male,19,Cycling,3,,,3
1896,FRA,France,Léon Flameng,Male,18,Cycling,1,1,1,3
@turicas
turicas / brazilian-cities.csv
Created May 26, 2017 01:02
rows CSV lazy import and export
state city inhabitants area
AC Acrelândia 12538 1807.92
AC Assis Brasil 6072 4974.18
AC Brasiléia 21398 3916.5
AC Bujari 8471 3034.87
AC Capixaba 8798 1702.58
AC Cruzeiro do Sul 78507 8779.39
AC Epitaciolândia 15100 1654.77
AC Feijó 32412 27974.89
AC Jordão 6577 5357.28
@turicas
turicas / brasil.sql
Created November 26, 2016 16:28
CREATE TABLE brasil (state TEXT, city TEXT, inhabitants INTEGER, area REAL);
INSERT INTO brasil (state, city, inhabitants, area) VALUES
('AC','Rio Branco',336038,8835.54),
('AL','Maceió',932748,503.07),
('AP','Macapá',398204,6408.55),
('AM','Manaus',1802014,11401.09),
('BA','Feira de Santana',556642,1337.99),
('BA','Salvador',2675656,693.28),
('BA','Vitória da Conquista',306866,3356.89),
('CE','Caucaia',325441,1228.51),
@turicas
turicas / sample.csv
Created September 2, 2016 02:05
ano descricao_cargo descricao_ue sexo_feminino sexo_feminino_eleito sexo_masculino sexo_masculino_eleito sexo_nulo sexo_nulo_eleito sigla_uf
1994 DEPUTADO ESTADUAL ACRE 13 0 155 24 0 0 AC
1994 DEPUTADO FEDERAL ACRE 5 2 34 6 0 0 AC
1994 GOVERNADOR ACRE 0 0 4 1 0 0 AC
1994 SENADOR ACRE 1 1 6 1 0 0 AC
1994 DEPUTADO ESTADUAL ALAGOAS 7 2 108 25 0 0 AL
1994 DEPUTADO FEDERAL ALAGOAS 1 1 40 8 0 0 AL
1994 GOVERNADOR ALAGOAS 1 0 3 1 0 0 AL
1994 SENADOR ALAGOAS 1 0 6 2 0 0 AL
1994 DEPUTADO ESTADUAL AMAZONAS 10 1 224 23 0 0 AM
@turicas
turicas / programming-languages.csv
Created August 10, 2016 02:16
Download list of programming languages from Wikipedia
name wikipedia_url
A# .NET https://en.wikipedia.org/wiki/A_Sharp_(.NET)
A# (Axiom) https://en.wikipedia.org/wiki/A_Sharp_(Axiom)
A-0 System https://en.wikipedia.org/wiki/A-0_System
A+ https://en.wikipedia.org/wiki/A%2B_(programming_language)
A++ https://en.wikipedia.org/wiki/A%2B%2B
ABAP https://en.wikipedia.org/wiki/ABAP
ABC https://en.wikipedia.org/wiki/ABC_(programming_language)
ABC ALGOL https://en.wikipedia.org/wiki/ABC_ALGOL
ABSET https://en.wikipedia.org/wiki/ABSET
@turicas
turicas / free-software-licenses.csv
Created August 10, 2016 01:31
Download list of free software licenses from GNU page
name short_name url
GNU General Public License (GPL) version 3 GNUGPLv3 https://www.gnu.org/licenses/gpl.html
GNU General Public License (GPL) version 2 GPLv2 https://www.gnu.org/licenses/old-licenses/gpl-2.0.html
GNU Lesser General Public License (LGPL) version 3 LGPLv3 https://www.gnu.org/licenses/lgpl.html
GNU Lesser General Public License (LGPL) version 2.1 LGPLv2.1 https://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
GNU Affero General Public License (AGPL) version 3 AGPLv3.0 https://www.gnu.org/licenses/agpl.html
GNU All-Permissive License GNUAllPermissive https://www.gnu.org/prep/maintain/html_node/License-Notices-for-Other-Files.html
Apache License, Version 2.0 apache2 http://directory.fsf.org/wiki/License:Apache2.0
Artistic License 2.0 ArtisticLicense2 http://directory.fsf.org/wiki/License:ArtisticLicense2.0
Clarified Artistic License ClarifiedArtisticLicense http://gianluca.dellavedova.org/2011/01/03/clarified-artistic-license/
@turicas
turicas / countries-gealc.csv
Last active August 10, 2016 03:07
Download country names (in Spanish) and flags from Wikipedia
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
name
Antigua y Barbuda
Argentina
Bahamas
Barbados
Belice
Bolivia
Brasil
Canadá
Chile
@turicas
turicas / folhasp.py
Created July 20, 2016 01:34
import sys
import requests
from lxml.html import document_fromstring
url = sys.argv[1]
response = requests.get(url)
html = response.content
tree = document_fromstring(html)
@turicas
turicas / scifi.py
Last active July 13, 2016 20:17
Parse wireless router station dumps and calculate a new metric
#!/usr/bin/env python2
# coding: utf-8
# Author: Álvaro Justen <https://github.com/turicas/rows.git>
# yum install python-pip git
# pip install git+https://github.com/turicas/rows.git requests
from __future__ import unicode_literals
import argparse