Icon for Socrata external plugin
Open repository in Console
Updated 6 months ago
Indexed 11 minutes ago

2018 Yellow Taxi Trip Data

These records are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow taxi. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off taxi zone locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/2018-yellow-taxi-trip-data-t29m-gskq\".\"2018_yellow_taxi_trip_data\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • 2018_yellow_taxi_trip_data
Upstream Metadata