市区町村ごとのよく使う指標を 1 行に並べた表です。1 行が令和7年国勢調査の市区町村 1 つです。
area_level が ward の行は親の市の内訳なので、市と一緒に合計すると二重に数えますCREATE TABLE profile.city ( city_code VARCHAR, lg_code VARCHAR, prefecture_code VARCHAR, city_name VARCHAR, area_level VARCHAR, parent_city_code VARCHAR, area_km2 DOUBLE, population BIGINT, households BIGINT, population_density DOUBLE, population_2020 BIGINT, population_change_rate_5y DOUBLE, population_under_15 BIGINT, population_15_64 BIGINT, population_65_over BIGINT, population_75_over BIGINT, aged_65_over_rate DOUBLE, daytime_population BIGINT, daytime_population_ratio DOUBLE, projected_population_2050 BIGINT, projected_change_rate_2050 DOUBLE, net_migration BIGINT, net_migration_year INTEGER, births BIGINT, deaths BIGINT, vital_statistics_year INTEGER, fiscal_capacity_index DECIMAL(5,2), fiscal_year INTEGER, establishments BIGINT, employees BIGINT, hospitals BIGINT, hospital_beds BIGINT, general_clinics BIGINT, dental_clinics BIGINT, medical_facility_year INTEGER, facility_count BIGINT, food_count BIGINT, grocery_count BIGINT, shopping_count BIGINT, medical_count BIGINT, education_count BIGINT );