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