Report not found

There was a problem finding this report.
NYC Taxis - Time until next pickup
June 26, 2014 · Refreshed over 4 years ago
Description
Shows dropoff timestamp, and timestamp of next pickup. Note that there are trips that begin before the previous trip ended.

Collaborators

Run History
SELECT *, next_pickup - dropoff_datetime AS time_until_next_fare FROM ( SELECT hack_license, dropoff_datetime, LEAD(pickup_datetime,1) OVER (PARTITION BY hack_license ORDER BY pickup_datetime) AS next_pickup FROM benn.nyc_taxi_data_june_week WHERE dropoff_datetime IS NOT NULL ) a ORDER BY 4 LIMIT 100
SELECT *, next_pickup - dropoff_datetime AS time_until_next_fare FROM ( SELECT hack_license, dropoff_datetime, LEAD(pickup_datetime,1) OVER (PARTITION BY hack_license ORDER BY pickup_datetime) AS next_pickup FROM benn.nyc_taxi_data_june_week WHERE dropoff_datetime IS NOT NULL ) a ORDER BY 4
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="container mode-grid"> <div class="row"> <div class="col-md-12"> <mode-table id="table_081da15be80d" dataset="dataset" options="table_options"></mode-table> </div> </div> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled