Dataset: ⛽Gas Prices

About this Dataset

⛽Gas Prices

Ontario fuel prices dataset contains weekly retail prices of three grades of gasoline, diesel, auto propane and compressed natural gas in 10 Ontario markets. Prices are in cents per litre (with compressed natural gas prices in cents per gasoline-equivalent litres).

Fuel prices_cities_canada dataset provides monthly, quarterly and annual average regular or premium unleaded gasoline pump prices, taxes and ex-tax pump prices in Toronto, Ottawa, Thunder Bay, St. John's, Halifax, Saint John, Montreal, Winnipeg, Regina, Calgary, and Vancouver.

Tables

Fuel Prices Cities Canada

@kaggle.syedabdulshameer_fuel_prices_in_ontario_1990_2023_eda.fuel_prices_cities_canada

24.5 KB
219 rows
15 columns


CREATE TABLE fuel_prices_cities_canada (
  "date" TIMESTAMP,
  "toronto" DOUBLE,
  "ottawa" DOUBLE,
  "thunder_bay" DOUBLE,
  "st_john_s_newfoundland" DOUBLE,
  "charlottetown" DOUBLE,
  "halifax" DOUBLE,
  "saint_john_new_brunswick" DOUBLE,
  "montreal" DOUBLE,
  "winnipeg" DOUBLE,
  "regina" DOUBLE,
  "calgary" DOUBLE,
  "vancouver" DOUBLE,
  "tax_status" VARCHAR,
  "situation_fiscale" VARCHAR
);

Ontario Fuel Prices 1990–2023

@kaggle.syedabdulshameer_fuel_prices_in_ontario_1990_2023_eda.ontario_fuel_prices_1990_2023

325.66 KB
10556 rows
21 columns


CREATE TABLE ontario_fuel_prices_1990_2023 (
  "n__id" BIGINT,
  "date" TIMESTAMP,
  "ottawa" DOUBLE,
  "toronto_west_ouest" DOUBLE,
  "toronto_east_est" DOUBLE,
  "windsor" DOUBLE,
  "london" DOUBLE,
  "peterborough" DOUBLE,
  "st_catharine_s" DOUBLE,
  "sudbury" DOUBLE,
  "sault_saint_marie" DOUBLE,
  "thunder_bay" DOUBLE,
  "north_bay" DOUBLE,
  "timmins" DOUBLE,
  "kenora" DOUBLE,
  "parry_sound" DOUBLE,
  "ontario_average_moyenne_provinciale" DOUBLE,
  "southern_average_moyenne_du_sud_de_l_ontario" DOUBLE,
  "northern_average_moyenne_du_nord_de_l_ontario" DOUBLE,
  "fuel_type" VARCHAR,
  "type_de_carburant" VARCHAR
);