Bigquery

In this series of posts, I collect and analyze NYPD motor vehicle collisions along with NOAA weather data. If you missed part one, head over there to find how the data was collected. You can also find the relevant Python…

On any given day, there are 200 to 400 motor vehicle collisions reported to the NYPD in New York City. This collision data has been made available through the NYC Open Data project and can also be found through Google’s…

I came across an interesting dataset on Google’s BigQuery containing the play-by-play data for 2016 MLB games. The data has been denormalized and can be a little tricky to work with at first. I suggest looking over the examples provided…

BigQuery Table (Tweets): twitter.2016_first_pres_debate (Requires GCloud Account)

BigQuery Table (Transcript): twitter.debate_transcript