Python, Government, and Contracts

Slide 1

Slide 1 text

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 froidotdev

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 Whiteﬁsh Energy Holdings.

Slide 33

Slide 33 text

It was a no-bid contract. 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 Whiteﬁsh. 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

Ofﬁce 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-web

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 proﬁt

Slide 77

Slide 77 text

Collecting 976,833 contracts + 270,156 amendments

Slide 78

Slide 78 text

Normalizing

Slide 79

Slide 79 text

Storing

Slide 80

Slide 80 text

Downloading 201,003 PDFs

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

code4puertorico/contratospr code4puertorico/contratospr-web code4puertorico/contratospr-api

Slide 86

Slide 86 text

Transparency

Slide 87

Slide 87 text

http://bit.ly/ contratospr-ﬁnancials

Slide 88

Slide 88 text

Nov. 2018 - Jan. 2020 Grand Total $489.24 $254.67 $743.91

Slide 89

Slide 89 text

Date Description Amount Balance January 2020 Balance EOY 2019 -$10.50 January 2020 Froi (Venmo) -$183.58 -$194.08 January 2020 José reimbursement $183.58 -$10.50 January 2020 Heroku hosting $21.64 $11.14 January 2020 Compose database hosting $74.11 $85.25 January 2020 José payment -$42.62 $42.63 January 2020 Froi payment -$42.63 $0.00 Total $0.00

Slide 90

Slide 90 text

Financial sustainability

Slide 91

Slide 91 text

What's next?

Slide 92

Slide 92 text

Download all contract documents.

Slide 93

Slide 93 text

Create more insights and visualizations.

Slide 94

Slide 94 text

No content

Slide 95

Slide 95 text

Registry of Corporations and Entities

Slide 96

Slide 96 text

Interviews

Slide 97

Slide 97 text

Engage with all of you.

Slide 98

Slide 98 text

AP / iCARLOS GIUSTI Ricardo Arduengo/AFP/Getty Images Jose Jimenez / Getty Images Ricardo Arduengo/AFP/Getty Images Jose Jimenez/Getty Images Alejandro Granadillo/Anadolu Agency/Getty Images

Slide 99

Slide 99 text

¡Gracias! José Padilla jpadilla_ Froilán Irizarry froidotdev contratospr.com/about