173 million 2013 NYC taxi rides shared on BigQuery

2015-08-03 UPDATE: Fresh data now officially shared by the NYC TLC.

Find the new tables on BigQuery, and see the [new r/bigquery post](/r/bigquery/comments/3fo9ao/nyc_taxi_trips_now_officially_shared_by_the_nyc/).

UPDATE: Watch the NYC taxi dataset hackathon video.

UPDATE: The project has been renamed. Instead of the numerical id '833682135931', now you should use it's new name 'imjasonh-storage'. Hence the table can be found at https://bigquery.cloud.google.com/table/imjasonh-storage:nyctaxi.trip_fare.

Queries will continue working regardless.

SELECT COUNT(*) trips FROM [833682135931:nyctaxi.trip_data] 
173,179,759


SELECT AVG(trip_distance) avg_distance, AVG(trip_time_in_secs) avg_time, COUNT(*) trips
FROM [833682135931:nyctaxi.trip_data] 

avg_distance avg_time   trips
8.30	     811.99     173,179,759

Original post - Chris Whong gets the data under The Freedom of Information Law:

• http://chriswhong.com/open-data/foil_nyc_taxi/

Find the table ready to be queried at:

• https://bigquery.cloud.google.com/table/imjasonh-storage:nyctaxi.trip_data

(thanks Jason Hall for BigQuery'ing it)