jsoma / data-studio-projects

12 stars 18 forks source link

Puerto Rico’s biggest challenge #272

Open ella24 opened 6 years ago

ella24 commented 6 years ago

Pitch Summary The aftermath of Hurricanes Irma and Maria are just the top of the iceberg. Puerto Rico’s demographic challenge started years before due to a $74 billion debt crisis which has devastated state institutions and created high unemployment levels.

Data points out that the problem is not just birth depletion, but also unstoppable emigration. The decrease of population extends through several municipalities.

However, there is also data that points out that most people that abandoned the island for hurricane reasons, is already back.

The questions I intend to answer are:

-What Puerto Rican areas are most affected by population decline? -In what period people emigrated the most? -Are they already back? -What is the income situation?

Details Possible headline(s): Puerto Rico’s biggest challenge Data set(s): https://indicadores.pr/dataset/vuelos-pasajeros-aereos-y-carga-puerto-rico https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?src=CF Code repository: https://github.com/ella24/data_studio/blob/master/code/Migration%20wave%20Puerto%20Rico/Puerto%20Rico's%20Demographics%20.ipynb Possible problems/fears/questions: Data from Puerto Rico’s government needs a lot of cleaning. I also had to make data request to the Institute of Statistics of Puerto Rico and they took over a week to send me the information. Work so far testpopulation

Checklist This checklist must be completed before you submit your draft.

malbasi commented 6 years ago

This is a great, unexplored angle for this story. Thinking of the hurricane's effect in isolation, like many publication have, doesn't tell the whole story. If you're able to find the data, I'd like to know where the people fleeing PR ended up as well as the numbers that returned. Maybe that could be shown with on a map with lines of different widths showing the number of people, instead of a line chart. Can't wait to see what you do with this!

sarahslo commented 6 years ago

-i like this angle as well. wish you had had a chance to put some labels on that chart you started. will stand by for the next draft!