Weekly On-Highway Diesel Fuel Prices
Weekly on-highway diesel prices (dollars per gallon) from the Department of Energy's Energy Information Administration. This data includes the average diesel fuel price for the U.S. and five Petroleum Administration for Defense Districts (PADDs) (including PADD subcomponents). There are ten variables in total: "U.S."; "East Coast" (PADD1), broken out further by "New England" (PADD1A), "Central Atlantic" (PADD1B), and "Lower Atlantic" (PADD1C); "Midwest" (PADD2); "Gulf Coast" (PADD3); "Rocky Mountain" (PADD4); and "West Coast" (PADD5), broken out further by "West Coast excluding California" and "California." See link below for the states included in each region.
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 \"internal-agtransport-usda-gov/weekly-onhighway-diesel-fuel-prices-x88w-atzp\".\"weekly_onhighway_diesel_fuel_prices\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.