Since I’ve left New York City, I noticed that New York is becoming a lot more like Norway — with a more environmentally-friendly trash organization system and publicly available city biking to boot. I decided to leverage some publicly available data from Citibike, in order to gain some insights into Citibike’s popular commuter routes. This exercise was largely a tool to teach myself SQL. I’ve always had an interest in marketing and wanted to give myself a challenge outside my everyday work within public health.
Tools used: Google’s Big Query, SQL
Results:
![](https://images.addihetja.com/Screenshot-2022-05-19-at-11.44.28.png)
![](https://images.addihetja.com/Screenshot-2022-04-29-at-17.21.56.png)
![](https://images.addihetja.com/Screenshot-2022-04-29-at-17.53.01.png)
Insights:
•Men are much more likely to be Citibike subscribers than women.
•The majority of Citibike users are in the 30s-40s age demographic.
•Women avoid the crowded Midtown area. They bike in areas that are more bike-path dense.
•A larger number of vehicle-related cyclist fatalities occurred in Lower West Manhattan, where women also tend to cycle more