Uber Is Serving New York’s Outer Boroughs More Than Taxis Are
I took a look at the monthly revenues of Yellow Taxis and the # of total fares with the NYC TLC data set that was released last week.   SELECT LEFT(DATE(pickup_datetime),7) as month,
   SUM(fare_amount) as total_revenue,
   COUNT(*) as num_fares
   FROM [nyc-tlc:yellow.trips_2014], [nyc-tlc:yellow.trips_2015]
   GROUP BY month ORDER BY month

Here's the quick-and-dirty output: https://docs.google.com/spreadsheets/d/1NVcScdHtcWvF9oSZGE3_...If Uber is eating the TLC's lunch, why isn't there a dramatic shift in revenue loss? (trendline has only a slight decline) However, it does appear the # fares are on a downward trend.