Who funds New York governor's race?

[adrianblanco]

Pitch

New Yorkers will head to the polls on November to choose a new Governor. Gov. Current Governor Andrew M. Cuomo is being challenged by Cynthia Nixon and Marc Molinaro. They will vote for a candidate and its ideas, but what are the interests behind each candidate?

For example, Andrew Cuomo raised at least 1.24 million of that came from NYC area real estate interests.

Taking into account all of the above, I would like to find which companies are funding Cuomo and other candidates campaigns and see how many buildings own in NYC.

Summary

This project comes from an idea I started working on during Data and Databases class with John Thirkield. As I would like to get the project done soon as possible and I have been working on it during the last two weeks, I thought it was a good time to pitch it!

The objective is to join NYC Housing data with followthemoney data to obtain which Real State companies are funding the campaigns of the different candidates and how many buildings do they own in New York.

Details

Possible headline(s): Real state [Company #1] [Company #2] who funded Cuomo's campaign own XXX buildings in NYC These are the building owned by Real State companies who funded Cuomo's campaign

Data set(s): nyc-db, followthemoney, Census data to visualize NYC blocks

Code repository: https://github.com/adrianblanco/data-studio/blob/master/code/03-nycdb/nyc-db.ipynb

Possible problems/fears/questions:

Work so far

I am analyzing data from nyc-db, followthemoney.org and Census data.

I have done most of the data analysis and put everything together in a notebook. Next steps are cleaning names of campaign funders and merge all the data probably in QGIS. I think from this week we are supposed to finally publish maps so the final output will be visualized over a map.

This is a prototype I have drawn by hand:

And this is how I plan to join/merge the three databases:

Checklist

This checklist must be completed before you submit your draft.

• [x] I have already spent time with my data set, opening it, exploring it, etc
• [ ] I have created a "DIARY.md" file to save links and list all of the terrible, no good problems I come across
• [x] My issue links to my data set(s)
• [x] My issue links to my code repository
• [x] My issue explains what I'd like to explore in the data set
• [x] My issue includes images - either inspiration or what I've done so far

[julialedur]

Fascinating idea and the timing to pitch it is definitely perfect! I'm looking forward to seeing a draft of your map!

[kellykiki]

Hi, Andrian! Great job, you did a lot to get data and combine them! The idea and the story to be produced rocks. Looking forward to see your draft map.

Just a thought/ idea for the fuuuuture probably: could you potentially have these buildings colored with a scale depicting how much they worth?

[sarahslo]

the question you are asking here is an interesting one given what is going on in the US right now with real estate moguls.

it's tricky simply counting buildings. they have different values and they hold different numbers of people.

one thought is if you had census data for income in the neighborhoods you could map them by income and divide them by low, medium and high. then, if you simply count the buildings, you'd be able to say how many buildings each company owns in those income bracketed neighborhoods and it would be more meaningful.