/
人口動態統計の死亡数を、全国・都道府県・市区町村ごとに年齢別・男女別で2015年から持つテーブルです。
SELECT
year,
area_code,
area_name,
area_kind,
prefecture_code,
age_code,
age_class,
CAST(NULLIF(REGEXP_EXTRACT(age_class, '^(\d+)', 1), '') AS INTEGER) AS age_from,
CAST(NULLIF(REGEXP_EXTRACT(age_class, '~(\d+)歳', 1), '') AS INTEGER) AS age_to,
deaths,
deaths_male,
deaths_female
FROM "e_stat"."vital_statistics"."stg_vital_statistics_deaths_age"
WHERE age_code <> '00100'
AND age_meta_level = '2'