About this Dataset

Alternative Fueling Station Locations

Alternative fueling stations are located throughout the United States and Canada, and their availability continues to grow. The Alternative Fuels Data Center (AFDC) maintains a website where you can find alternative fueling stations near you or on a route, obtain counts of alternative fueling stations by state, view maps, and more.

The most recent dataset available for download here provides a "snapshot" of the alternative fueling station information for compressed natural gas (CNG), ethanol (E85), propane/liquefied petroleum gas (LPG), biodiesel (B20 and above), electric vehicle charging, hydrogen, and liquefied natural gas (LNG), as of July 29, 2021.
Organization: Department of Energy
Last updated: 2021-07-31T08:40:22.509139
Tags: alt-fuel, alternative-fuels, alternative-fuels-stations, b20, biodiesel, charging-stations, cng, compressed-natural-gas, e85, electric-vehicles, electricity, energy, ethanol, ev, fuel, fuel-stations, hydrogen, liquefied-natural-gas, liquefied-natural-gas-lng, liquefied-petroleum-gas, lng, lpg, propane, station-locations, transportation, vehicles

Tables

Alternative Fuel Stations 2012

@usgov.doe_gov_alternative_fueling_station_locations_422f2.alternative_fuel_stations_2012

907.27 kB
10,458 rows
28 columns

CREATE TABLE alternative_fuel_stations_2012 (
  "fuel_type_code" VARCHAR,
  "station_name" VARCHAR,
  "street_address" VARCHAR,
  "intersection_directions" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "plus4" DOUBLE,
  "station_phone" VARCHAR,
  "status_code" VARCHAR,
  "expected_date" TIMESTAMP,
  "groups_with_access_code" VARCHAR,
  "access_days_time" VARCHAR,
  "cards_accepted" VARCHAR,
  "bd_blends" VARCHAR,
  "ng_fill_type_code" VARCHAR,
  "ng_psi" VARCHAR,
  "ev_level1_evse_num" DOUBLE,
  "ev_level2_evse_num" DOUBLE,
  "ev_dc_fast_count" DOUBLE,
  "ev_other_info" VARCHAR,
  "ev_network" VARCHAR,
  "ev_network_web" VARCHAR,
  "geocode_status" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_last_confirmed" TIMESTAMP,
  "id" BIGINT
);

Alternative Fuel Stations 2021

@usgov.doe_gov_alternative_fueling_station_locations_422f2.alternative_fuel_stations_2021

4.14 MB
56,800 rows
65 columns

CREATE TABLE alternative_fuel_stations_2021 (
  "fuel_type_code" VARCHAR,
  "station_name" VARCHAR,
  "street_address" VARCHAR,
  "intersection_directions" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "plus4" VARCHAR,
  "station_phone" VARCHAR,
  "status_code" VARCHAR,
  "expected_date" VARCHAR,
  "groups_with_access_code" VARCHAR,
  "access_days_time" VARCHAR,
  "cards_accepted" VARCHAR,
  "bd_blends" VARCHAR,
  "ng_fill_type_code" VARCHAR,
  "ng_psi" VARCHAR,
  "ev_level1_evse_num" DOUBLE,
  "ev_level2_evse_num" DOUBLE,
  "ev_dc_fast_count" DOUBLE,
  "ev_other_info" VARCHAR,
  "ev_network" VARCHAR,
  "ev_network_web" VARCHAR,
  "geocode_status" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_last_confirmed" TIMESTAMP,
  "id" BIGINT,
  "updated_at" VARCHAR,
  "owner_type_code" VARCHAR,
  "federal_agency_id" DOUBLE,
  "federal_agency_name" VARCHAR,
  "open_date" TIMESTAMP,
  "hydrogen_status_link" VARCHAR,
  "ng_vehicle_class" VARCHAR,
  "lpg_primary" VARCHAR,
  "e85_blender_pump" VARCHAR,
  "ev_connector_types" VARCHAR,
  "country" VARCHAR,
  "intersection_directions_french" VARCHAR  -- Intersection Directions (French),
  "access_days_time_french" VARCHAR  -- Access Days Time (French),
  "bd_blends_french" VARCHAR  -- BD Blends (French),
  "groups_with_access_code_french" VARCHAR  -- Groups With Access Code (French),
  "hydrogen_is_retail" VARCHAR,
  "access_code" VARCHAR,
  "access_detail_code" VARCHAR,
  "federal_agency_code" VARCHAR,
  "facility_type" VARCHAR,
  "cng_dispenser_num" DOUBLE,
  "cng_on_site_renewable_source" VARCHAR,
  "cng_total_compression_capacity" DOUBLE,
  "cng_storage_capacity" DOUBLE,
  "lng_on_site_renewable_source" VARCHAR,
  "e85_other_ethanol_blends" VARCHAR,
  "ev_pricing" VARCHAR,
  "ev_pricing_french" VARCHAR  -- EV Pricing (French),
  "lpg_nozzle_types" VARCHAR,
  "hydrogen_pressures" VARCHAR,
  "hydrogen_standards" VARCHAR,
  "cng_fill_type_code" VARCHAR,
  "cng_psi" VARCHAR,
  "cng_vehicle_class" VARCHAR,
  "lng_vehicle_class" VARCHAR,
  "ev_on_site_renewable_source" VARCHAR,
  "restricted_access" VARCHAR
);