India's Power Capacity
India's Power Capacity and Transmission (2019-2022)
@kaggle.ramjasmaurya_indias_power_capacity
India's Power Capacity and Transmission (2019-2022)
@kaggle.ramjasmaurya_indias_power_capacity
CREATE TABLE all_india_installed_capacity_res (
"id" BIGINT,
"month" VARCHAR,
"small_hydro_power" DOUBLE,
"wind_power" DOUBLE,
"bmpower_congen" DOUBLE,
"wastetoenergy" DOUBLE,
"solar_power" DOUBLE
);
CREATE TABLE all_india_installed_capacity (
"id" BIGINT,
"month" VARCHAR,
"coal" DOUBLE,
"gas" DOUBLE,
"diesel" DOUBLE,
"thermal_total" DOUBLE,
"nuclear" BIGINT,
"hydro" DOUBLE,
"res" DOUBLE,
"grand_total" DOUBLE
);
CREATE TABLE installed_capacity_region_wise (
"id" BIGINT,
"month" VARCHAR,
"region" VARCHAR,
"coal" DOUBLE,
"gas" DOUBLE,
"diesel" DOUBLE,
"thermal_total" DOUBLE,
"nuclear" DOUBLE,
"hydro" DOUBLE,
"res" DOUBLE,
"total" DOUBLE
);
CREATE TABLE installed_capacity_state_wise (
"id" BIGINT,
"month" VARCHAR,
"region" VARCHAR,
"state" VARCHAR,
"coal" DOUBLE,
"gas" DOUBLE,
"diesel" DOUBLE,
"thermal_total" DOUBLE,
"nuclear" DOUBLE,
"hydro" DOUBLE,
"res" DOUBLE,
"grand_total" DOUBLE
);
CREATE TABLE installed_capacity_sectorwise (
"month_and_year" VARCHAR,
"central_sector" DOUBLE,
"private_sector" DOUBLE,
"state_sector" DOUBLE,
"total_installed_capacity" DOUBLE
);
CREATE TABLE monthly_gas_supplied_rep (
"category" VARCHAR,
"domestic_gas_supplied_2018_2019" DOUBLE,
"rlng_imported_gas_supplied_2018_2019" DOUBLE,
"total_gas_supplied_2018_2019" DOUBLE,
"domestic_gas_supplied_2019_2020" DOUBLE,
"rlng_imported_gas_supplied_2019_2020" DOUBLE,
"total_gas_supplied_2019_2020" DOUBLE
);
CREATE TABLE planwise_growth_installed_capacity (
"id" BIGINT,
"as_on" VARCHAR,
"coal" DOUBLE,
"gas" DOUBLE,
"diesel" DOUBLE,
"thermal_total" DOUBLE,
"nuclear" BIGINT,
"hydro" DOUBLE,
"res" DOUBLE,
"grand_total" DOUBLE
);
CREATE TABLE planwise_growth (
"id" BIGINT,
"as_on" VARCHAR,
"installed_capacity" DOUBLE,
"number_of_villages_electrified" DOUBLE,
"length_t_and_d_lines" DOUBLE,
"per_capita_consumption" DOUBLE,
"sixty_six_kv_and_above" DOUBLE,
"below_sixty_six_kv" DOUBLE
);
CREATE TABLE power_supply_position_energy (
"id" BIGINT,
"month" VARCHAR,
"state" VARCHAR,
"energy_requirement" DOUBLE,
"energy_availability" DOUBLE
);
CREATE TABLE power_supply_position_peak (
"id" BIGINT,
"month" VARCHAR,
"state" VARCHAR,
"peak_demand" DOUBLE,
"peak_met" DOUBLE
);
CREATE TABLE transformation_capacity (
"id" BIGINT,
"month" VARCHAR,
"voltage_ratio" VARCHAR,
"station_name" VARCHAR,
"capacity" BIGINT,
"executing_agency" VARCHAR,
"sector" VARCHAR
);
CREATE TABLE transformation_lines (
"id" BIGINT,
"month" VARCHAR,
"voltage_level" BIGINT,
"transmission_line" VARCHAR,
"circuit_type" VARCHAR,
"executing_agency" VARCHAR,
"line_length" BIGINT,
"sector" VARCHAR
);
Anyone who has the link will be able to view this.