Icon for Socrata external plugin
Open repository in Console
Updated 1 year ago
Indexed 5 hours ago

Real-World Fuel Efficiency

This is a report of city vehicles and actual MPG compared to EPA estimated MPG. Each line of data is a combination of all the active vehicles on the city’s telematics system broken down into year/make/model/standard type with fueling and usage data. The intent is for each line to represent the sticker MPG and the real-world MPG and how these compare to each other. The report can be found at

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/realworld-fuel-efficiency-mn2p-34if\".\"realworld_fuel_efficiency\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • realworld_fuel_efficiency
Upstream Metadata