This dataset includes taxi trips from 2013 to the present, reported to the City
of Chicago in its role as a regulatory agency. To protect privacy but allow for aggregate analyses, the Taxi ID is consistent for any given taxi medallion number but does not show the number, Census Tracts are suppressed in some cases, and times are rounded to the nearest 15 minutes. Due to the data reporting process, not all trips are reported but the City believes that most are. For more information about this dataset and how it was created, see this post
This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets.
What is BigQuery
Try the sample queries below in the BigQuery UI.
What are the maximum, minimum and average fares for rides lasting 10 minutes or more?
This query retrieves the maximum, minimum, and average fare for rides lasting
10 minutes or longer. The results are grouped by week day. In addition, the query
calculates the standard deviation of fares and the total number of rides given
on each day. Run this query.
Which drop-off areas have the highest average tip?
This query retrieves the highest average tip and the maximum tip given to taxi drivers grouped by drop-off community areas
How does trip duration affect fare rates for trips lasting less than 90 minutes?
This query converts trip durations to minutes, buckets them into deciles,
and calculates the total number of trips and the average fare across each
duration range. Run this query.
This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - https://data.cityofchicago.org
Google Cloud Console has failed to load JavaScript sources from www.gstatic.com.
Possible reasons are: