府県予報区ごとの短期予報の降水確率です。一次細分区域ごと・6 時間ごとの値を持ちます。
SELECT office_code, CAST(report_datetime AS "TIMESTAMP WITH TIME ZONE") AS report_datetime, area_code, area_name, CAST(forecast_datetime AS "TIMESTAMP WITH TIME ZONE") AS forecast_datetime, TRY_CAST("nullif"(pop, '') AS INTEGER) AS pop_pct FROM {DUCKLAKE_CATALOG}.main.raw_jma_forecast_pops