Power Sector Data
Electricity Sector in India
@kaggle.ajithdari_power_sector_data
Electricity Sector in India
@kaggle.ajithdari_power_sector_data
CREATE TABLE consumer (
"tata_hydro" DOUBLE,
"adani_hydro" DOUBLE,
"powerg_hydro" DOUBLE,
"tata_solar" DOUBLE,
"adani_solar" DOUBLE,
"powerg_solar" DOUBLE,
"tata_wind" DOUBLE,
"adani_wind" DOUBLE,
"powerg_wind" DOUBLE,
"tata_hydro_price" DOUBLE,
"adani_hydro_price" DOUBLE,
"powerg_hydro_price" DOUBLE,
"tata_solar_price" DOUBLE,
"adani_solar_price" DOUBLE,
"powerg_solar_price" DOUBLE,
"tata_wind_price" DOUBLE,
"adani_wind_price" DOUBLE,
"powerg_wind_price" DOUBLE
);
CREATE TABLE energy (
"datetime" TIMESTAMP,
"solar_energy_generation" DOUBLE,
"wind_energy_generation" DOUBLE,
"hydro_energy_generation" DOUBLE,
"solar_energy_consumption" DOUBLE,
"wind_energy_consumption" DOUBLE,
"hydro_energy_consumption" DOUBLE,
"solar_energy_price_elasticity_coefficient_gamma" DOUBLE,
"wind_energy_price_elasticity_coefficient_gamma" DOUBLE,
"hydro_energy_price_elasticity_coefficient_gamma" DOUBLE,
"solar_energy_loss" DOUBLE,
"wind_energy_loss" DOUBLE,
"hydro_energy_energy_loss" DOUBLE,
"nat_demand" DOUBLE,
"holiday" BIGINT,
"school" BIGINT
);
Anyone who has the link will be able to view this.