Dataset: Alternative Fueling Station Locations

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.509128
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 2014

@usgov.doe_gov_alternative_fueling_station_locations_422f2.alternative_fuel_stations_2014

1.74 MB
20329 rows
38 columns


CREATE TABLE alternative_fuel_stations_2014 (
  "fuel_type_code" VARCHAR,
  "station_name" VARCHAR,
  "street_address" VARCHAR,
  "intersection_directions" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "plus4" VARCHAR,
  "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,
  "updated_at" VARCHAR,
  "owner_type_code" VARCHAR,
  "federal_agency_id" DOUBLE,
  "federal_agency_name" VARCHAR,
  "open_date" VARCHAR,
  "hydrogen_status_link" VARCHAR,
  "ng_vehicle_class" VARCHAR,
  "lpg_primary" VARCHAR,
  "e85_blender_pump" VARCHAR,
  "ev_connector_types" VARCHAR
);

Alternative Fuel Stations 2012

@usgov.doe_gov_alternative_fueling_station_locations_422f2.alternative_fuel_stations_2012

886 KB
10458 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

3.95 MB
56800 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,
  "access_days_time_french" VARCHAR,
  "bd_blends_french" VARCHAR,
  "groups_with_access_code_french" VARCHAR,
  "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,
  "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
);