電力調査統計の、電気事業者の発電所の都道府県別・月次の発電電力量(MWh)です。
CREATE TABLE electric_power.power_generation_by_prefecture ( fiscal_year INTEGER, year INTEGER, month INTEGER, year_month VARCHAR, pref_code VARCHAR, pref_name VARCHAR, hydro_mwh DOUBLE, thermal_mwh DOUBLE, nuclear_mwh DOUBLE, wind_mwh DOUBLE, solar_mwh DOUBLE, geothermal_mwh DOUBLE, biomass_mwh DOUBLE, waste_mwh DOUBLE, storage_battery_mwh DOUBLE, new_energy_mwh DOUBLE, other_mwh DOUBLE, total_mwh DOUBLE, published_as_of DATE );