Uber leaked select city-by-city revenue data last week. The numbers were impressive: $26MM in top line revenue in NYC alone for December 2013.

But just how big is Uber relative to the NYC taxi market? Chris Wong FOILed all of NYC’s taxi trip data for 2013 which is now in Google Big Query for easy SQL querying to compare Uber’s usage relative to NYC taxis.

1. Uber NYC earned 18% as much as NYC taxis on Dec 31, 2013

  • Uber 2013: $1,118,271
  • Uber 2012: $182,819
  • Taxis: $6,272,548

2. Uber NYC earned 12% as much as NYC taxis in December 2013

  • Uber: ~$26MM
  • Taxis: $211,328,661.33

3. Uber NYC had 7% as many rides as NYC taxis on Dec 31, 2013

  • Uber 2013: 32,547
  • Uber 2012: 4,785
  • Taxis: 467,587

4. Uber NYC’s average ride was 256% the average NYC taxi fare on Dec 31, 2013

  • Uber NYE 2013: $34.36
  • Taxis NYE 2013: $13.41

NYC Taxi Data Queries In Google BigQuery

  1. December 2013 Total Revenue

    SELECT SUM(FLOAT(total_amount)) FROM [833682135931:nyctaxi.trip_fare] WHERE INTEGER(YEAR(TIMESTAMP(pickup_datetime))) = 2013 AND INTEGER(MONTH(TIMESTAMP(pickup_datetime))) = 12

  2. December 31, 2013 Total Revenue

    Same as above except add AND INTEGER(DAY(TIMESTAMP(pickup_datetime))) = 31

  3. December 31, 2013 Total Trips

    SELECT COUNT(*) then same as 2 above

Sources

Uber NYC Earned Almost 1/5th As Much As NYC Taxis was published on (revised: ) Miles Grimshaw

A Personal Map of NYC

Our digital activities create a personal data exhaust that traces a unique map of the world.Here's my personal trace of NYC based on [GPS...… Continue reading

MindBody's Market Penetration

Published on March 17, 2015

Replacing Email With Slack

Published on March 08, 2015