This dataset is collected by the NYC Taxi and Limousine Commission (TLC) and includes trip records from all trips completed in Yellow and Green taxis in NYC, and all trips in for-hire vehicles (FHV) in the last 5 years. Records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts. For detailed information about this dataset, go to
TOC Trip Record Data
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.
How many trips did Yellow taxis take each month in 2015?
This query returns monthly trip totals for all Yellow taxis in 2015. Run this query.
What was the average speed of Yellow taxi trips in 2015?
This query returns the average speed during each hour of the day for Yellow taxi
trips in 2015.
Run this query.
What was the average speed of Yellow taxi trips in 2015 by day of week?
This query shows the average speed by the day of the week, for all Yellow taxi trips in 2015.
Run this query.
For more examples using NYC data in BigQuery see this tutorial
This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - https://data.cityofnewyork.us/
Die Google Cloud Console konnte keine JavaScript-Quellen von www.gstatic.com laden.
Mögliche Gründe: