電力調査統計の、電気事業者の発電所の都道府県別・月次の発電所数と最大出力(kW)です。
CREATE TABLE electric_power.power_plants_by_prefecture ( fiscal_year INTEGER, year INTEGER, month INTEGER, year_month VARCHAR, pref_code VARCHAR, pref_name VARCHAR, hydro_plants INTEGER, hydro_capacity_kw DOUBLE, thermal_plants INTEGER, thermal_capacity_kw DOUBLE, nuclear_plants INTEGER, nuclear_capacity_kw DOUBLE, wind_plants INTEGER, wind_capacity_kw DOUBLE, solar_plants INTEGER, solar_capacity_kw DOUBLE, geothermal_plants INTEGER, geothermal_capacity_kw DOUBLE, biomass_plants INTEGER, biomass_capacity_kw DOUBLE, waste_plants INTEGER, waste_capacity_kw DOUBLE, storage_battery_plants INTEGER, storage_battery_capacity_kw DOUBLE, new_energy_plants INTEGER, new_energy_capacity_kw DOUBLE, other_plants INTEGER, other_capacity_kw DOUBLE, total_plants INTEGER, total_capacity_kw DOUBLE, published_as_of DATE );