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.<p><pre><code>   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
</code></pre>
Here's the quick-and-dirty output: <a href="https://docs.google.com/spreadsheets/d/1NVcScdHtcWvF9oSZGE3_9Nr-XHAuL5sAldtrV-PNh2A/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1NVcScdHtcWvF9oSZGE3_...</a><p>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.