Slide 1
Slide 1 text
Python,
Government,
and Contracts
Slide 2
Slide 2 text
A tool to
investigate
corruption
Slide 3
Slide 3 text
Hurricane
María
Slide 4
Slide 4 text
No content
Slide 5
Slide 5 text
September 26, 2017
Slide 6
Slide 6 text
95% of the island
had no cell
phone service.
Hector Retamal / AFP / Getty Images
Slide 7
Slide 7 text
Less than half of
the population
had tap water.
El Vocero
Slide 8
Slide 8 text
95% of the island
was without
power.
Joe Raedle/Getty Images
Slide 9
Slide 9 text
October 26, 2017
Slide 10
Slide 10 text
58% still
had no cell
phone service.
Hector Retamal / AFP / Getty Images
Slide 11
Slide 11 text
44% still
had no
water service.
Ricardo Arduengo / AFP / Getty Images
Slide 12
Slide 12 text
89% still
had no
power.
AP Images
Slide 13
Slide 13 text
Three months later...
Slide 14
Slide 14 text
6.5% still
had no cell
phone service.
El Nuevo Día
Slide 15
Slide 15 text
14% still
had no
water service.
HECTOR RETAMAL (AFP)
Slide 16
Slide 16 text
45% still
had no
power...
US Government
Slide 17
Slide 17 text
...that's over
1.5 million
people.
Angelina Ruiz-Lambides
Slide 18
Slide 18 text
José Padilla
jpadilla_
Slide 19
Slide 19 text
Work
Open source
Community
Slide 20
Slide 20 text
Work
Open source
Community
jpadilla
Slide 21
Slide 21 text
Work
Open source
Community
Slide 22
Slide 22 text
Froilán Irizarry
skfroi
Slide 23
Slide 23 text
Work
Open source
Community
Slide 24
Slide 24 text
Work
Open source
Community
froi
Slide 25
Slide 25 text
Work
Open source
Community
Slide 26
Slide 26 text
The Maria
Tech Brigade
Slide 27
Slide 27 text
No content
Slide 28
Slide 28 text
statuspr.jpadilla.com
Slide 29
Slide 29 text
Why are we
talking about
what happened
two years ago?
Slide 30
Slide 30 text
Suspicious
contracts
Slide 31
Slide 31 text
The Puerto Rico
Power Authority
awarded a...
Slide 32
Slide 32 text
...$300M
contract to
Whitefish Energy
Holdings.
Slide 33
Slide 33 text
It was a
no-bid
contract.
Suspicious
Should we add more context as to
why this is suspicious.
Slide 34
Slide 34 text
It stipulated
that FEMA had
approved it...
Suspicious
Slide 35
Slide 35 text
FEMA
denied any
involvement.
Suspicious
Slide 36
Slide 36 text
Puerto Rico
could not audit
the contract.
Suspicious
Slide 37
Slide 37 text
No content
Slide 38
Slide 38 text
The Puerto Rico
Power Authority
then awarded a...
Slide 39
Slide 39 text
...$200M
contract to Cobra
Acquisitions...
Slide 40
Slide 40 text
...followed by
another $900M
contract.
Slide 41
Slide 41 text
The company was
founded during
Q2 of 2017…
Suspicious
Slide 42
Slide 42 text
...making it
younger than
Whitefish.
Suspicious
Slide 43
Slide 43 text
They had no other
storm-related
contracts.
Suspicious
Slide 44
Slide 44 text
The deal had
heavy input from
FEMA.
Suspicious
Slide 45
Slide 45 text
Cobra had no
prior dealings
with PREPA
Suspicious
Slide 46
Slide 46 text
Suspicious
Slide 47
Slide 47 text
Office of the
Comptroller of
Puerto Rico
Slide 48
Slide 48 text
No content
Slide 49
Slide 49 text
API
Slide 50
Slide 50 text
No content
Slide 51
Slide 51 text
ContratosPR.com
Slide 52
Slide 52 text
No content
Slide 53
Slide 53 text
No content
Slide 54
Slide 54 text
No content
Slide 55
Slide 55 text
Why
Python +
Django?
Slide 56
Slide 56 text
Batteries included
Slide 57
Slide 57 text
No content
Slide 58
Slide 58 text
No content
Slide 59
Slide 59 text
Ecosystem
Slide 60
Slide 60 text
No content
Slide 61
Slide 61 text
No content
Slide 62
Slide 62 text
All things data
Slide 63
Slide 63 text
No content
Slide 64
Slide 64 text
No content
Slide 65
Slide 65 text
Community
♥
Slide 66
Slide 66 text
No content
Slide 67
Slide 67 text
Why have
two projects?
Slide 68
Slide 68 text
contratospr-api
Slide 69
Slide 69 text
No content
Slide 70
Slide 70 text
contratospr
Slide 71
Slide 71 text
No content
Slide 72
Slide 72 text
Data Collection
Slide 73
Slide 73 text
Scraping HTML
$
Slide 74
Slide 74 text
No content
Slide 75
Slide 75 text
Slow and steady
Slide 76
Slide 76 text
Celery for fun
and profit
Slide 77
Slide 77 text
Collecting
Slide 78
Slide 78 text
Normalizing
Slide 79
Slide 79 text
Storing
Slide 80
Slide 80 text
Downloading
Slide 81
Slide 81 text
No content
Slide 82
Slide 82 text
Extracting
Slide 83
Slide 83 text
Open source and
community
efforts
Slide 84
Slide 84 text
Community
Slide 85
Slide 85 text
Contributor
Experience
Slide 86
Slide 86 text
Transparency
Slide 87
Slide 87 text
Financial
sustainability
Slide 88
Slide 88 text
What's next?
Slide 89
Slide 89 text
Download
all contract
documents.
Slide 90
Slide 90 text
Create more
insights and
visualizations.
Slide 91
Slide 91 text
Registry of
Corporations
and Entities
Slide 92
Slide 92 text
Interviews
Slide 93
Slide 93 text
Engage with
all of you.
Slide 94
Slide 94 text
AP / iCARLOS GIUSTI
Slide 95
Slide 95 text
¡Gracias!
José Padilla
jpadilla_
Froilán Irizarry
skfroi
contratospr.com/about