/
都内の区市町村が公開する「地域・年齢別人口」(自治体標準オープンデータセット)を統合したものです。1 行が 1 地域・調査年月日で、男女別の人口・5 歳階級の人口・世帯数を持ちます。
ods.source_files にありますods.population_by_age にありますCREATE TABLE ods.population ( municipality_code VARCHAR, area_code VARCHAR, organization_name VARCHAR, prefecture VARCHAR, city VARCHAR, survey_date DATE, area_name VARCHAR, total_population BIGINT, male BIGINT, female BIGINT, age_0_4_male BIGINT, age_0_4_female BIGINT, age_5_9_male BIGINT, age_5_9_female BIGINT, age_10_14_male BIGINT, age_10_14_female BIGINT, age_15_19_male BIGINT, age_15_19_female BIGINT, age_20_24_male BIGINT, age_20_24_female BIGINT, age_25_29_male BIGINT, age_25_29_female BIGINT, age_30_34_male BIGINT, age_30_34_female BIGINT, age_35_39_male BIGINT, age_35_39_female BIGINT, age_40_44_male BIGINT, age_40_44_female BIGINT, age_45_49_male BIGINT, age_45_49_female BIGINT, age_50_54_male BIGINT, age_50_54_female BIGINT, age_55_59_male BIGINT, age_55_59_female BIGINT, age_60_64_male BIGINT, age_60_64_female BIGINT, age_65_69_male BIGINT, age_65_69_female BIGINT, age_70_74_male BIGINT, age_70_74_female BIGINT, age_75_79_male BIGINT, age_75_79_female BIGINT, age_80_84_male BIGINT, age_80_84_female BIGINT, age_85over_male BIGINT, age_85over_female BIGINT, households BIGINT, notes VARCHAR, extras JSON, org_code VARCHAR, org_title VARCHAR, package_id VARCHAR, source_url VARCHAR );