Comparing Single and Shared Trips and A Mini Network Analysis

In the 2019 report titled Transportation Network Providers and Congestion In The City Of Chicago, Transportation Network Providers (TNPs), i.e. Uber, Lyft and Via, are attributed as the major cause of congestion in Chicago’s downtown area.

In response to the issue, in January 2020 the mayor’s office put forward a congestion pricing policy that targets TNP trips. The policy includes a penalty on single TNP trips, i.e. trips with only one passenger, and a surcharge fee on trips starting or ending in a “Downtown Zone” on weekdays between 6AM and 10PM. According to City of Chicago website,

Effective January 6…


Unsurprisingly, the rich ride more often.

Nicknamed “Windy City”, Chicago undoubtedly has an impression of gusty weather with freezing temperature. On average, the temperature in Chicago dropped most significantly in the month of October. On Halloween 2019, “the snowiest Halloween” according to Chicago Tribune, the temperature was particularly low and reached 24 degrees.

Other than the distinctive weather, Chicago is also known for a segregated city with some “stark dividing lines between rich and poor” (Chicago Business). According to the same article, the middle class in the city is shrinking, with “4 in 5 of those ex-middle-class adults moved down to a lower income tier here.”

Photo by Justin Eisner on Unsplash


Photo by Ethan Bykerk on Unsplash

In this post I will use Python to explore the NYC 311 datasets. The dataset is available from NYC OpenData website, which contains all 311 requests from January 1, 2020 until present. Given the interest of this post I will look into all requests made before October 1, 2020. All datasets are fetched through API queries.

In the course of the exploration, I will ask a number of questions:

  1. What is the annual and monthly trends in the total number of claims in New York City?
  2. What are the significant types of claims?
  3. Are different types of claims correlated? Before…

Shen Xin

M.S. Candidate in Urban Planning, Columbia Graduate School of Architecture, Planning and Preservation

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store