cityofnewyork-us/2020-yellow-taxi-trip-data-kxp8-n2sj
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 4 months ago
Indexed 1 month ago

2020 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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/2020-yellow-taxi-trip-data-kxp8-n2sj\".\"2020_yellow_taxi_trip_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 2020_yellow_taxi_trip_data
     
     
     
     
     
Upstream Metadata