About this Dataset

Alternative Fuel Locations

List of locations in NE Illinois, NW Indiana, and SE Wisconsin where alternative vehicle fuels are available. For a Chicago-only filtered view, see https://data.cityofchicago.org/d/fi3z-jc3f. For more detailed descriptions of fields, see http://developer.nrel.gov/docs/transportation/alt-fuel-stations-v1.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:52.576037
Tags: sustainability, transportation

Tables

Table 1

@usgov.city_of_chicago_alternative_fuel_locations.table_1

205.46 KB
1836 rows
38 columns


CREATE TABLE table_1 (
  "id" BIGINT,
  "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,
  "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,
  "location" VARCHAR
);