« 各政党の地域浸透度(人口規模と各党の得票数、2026年衆議院議員選挙福岡11区) | トップページ | 福岡県の市区町村別世帯数及び人口(2025年9月1日現在) »

2026年3月16日 (月)

福岡県内各市の人口をRのestatapiで、e-Statから入手する。

Screenshot-20260316-at-103720 Screenshot-20260316-at-111239

```{r,out.width="100%"}
library(estatapi)
library(dplyr)
library(ggplot2)
library(scales)

# --- AONF設定 ---
AONF_CAPTION <- "Archives from 2026 Onward and Notes for the Future\n2026年以降の記録 | https://ab.cocolog-nifty.com/note/"
appId <- "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"

# 1. 福岡県内 全29市の自治体コードを設定
# 北九州市(40100), 福岡市(40130), 大牟田市(40202), 久留米市(40203)...
city_codes <- paste(c(
  "40100", "40130", "40202", "40203", "40204", "40205", "40206", "40207", 
  "40210", "40211", "40212", "40213", "40214", "40215", "40216", "40217", 
  "40218", "40219", "40220", "40221", "40223", "40224", "40225", "40226", 
  "40227", "40228", "40229", "40230", "40231"
), collapse = ",")

# 2. e-Stat APIからデータを取得(2020年国勢調査・総人口)
fukuoka_cities_data <- estat_getStatsData(
  appId = appId,
  statsDataId = "0000020201",
  cdArea = city_codes,
  cdCat01 = "A1101",
  cdTime = "2020100000"
)

# 3. データの整形
fukuoka_cities_clean <- fukuoka_cities_data %>%
  mutate(
    value = as.numeric(value),
    city_name = gsub("福岡県 ", "", 地域)
  ) %>%
  select(city_name, value) %>%
  arrange(value)

# 4. グラフ作成(AONF形式)
ggplot(fukuoka_cities_clean, aes(x = reorder(city_name, value), y = value)) +
  geom_bar(stat = "identity", fill = "darkblue") +
  # 棒の横に人口を表示(カンマ区切り)
  geom_text(aes(label = scales::comma(value)), hjust = -0.1, size = 2.5) +
  coord_flip() +
  scale_y_continuous(labels = scales::comma, expand = expansion(mult = c(0, 0.2))) +
  labs(
    title = "福岡県内 29市の人口規模(2020年)",
    subtitle = "出典:e-Stat(政府統計の総合窓口)",
    x = "市名",
    y = "総人口(人)",
    caption = AONF_CAPTION
  ) +
  theme_minimal(base_family = "HiraKakuProN-W3") +
  theme(
    axis.text.y = element_text(size = 8),
    plot.caption = element_text(size = 8, hjust = 1, color = "grey30"),
    panel.grid.minor = element_blank()
  )

# 結果をCSV保存する場合
# write.csv(fukuoka_cities_clean, "fukuoka_all_cities_population_2020.csv", row.names = FALSE, fileEncoding = "CP932")
```



```{r,out.width="100%"}
library(estatapi)
library(dplyr)
library(ggplot2)
library(tidyr)
library(scales)

# --- AONF標準設定 ---
AONF_CAPTION <- "Archives from 2026 Onward and Notes for the Future\n2026年以降の記録 | https://ab.cocolog-nifty.com/note/"
appId <- "xxxxxxxxxxxxxxxxxxxxxxxxxxxx"

# 1. 自治体コード(県内29市)
city_codes <- paste(c(
  "40100", "40130", "40202", "40203", "40204", "40205", "40206", "40207", 
  "40210", "40211", "40212", "40213", "40214", "40215", "40216", "40217", 
  "40218", "40219", "40220", "40221", "40223", "40224", "40225", "40226", 
  "40227", "40228", "40229", "40230", "40231"
), collapse = ",")

# 2. e-Stat APIからデータを取得(年齢3区分の正しいコードを指定)
# A1301: 年少人口, A1302: 生産年齢人口, A1303: 老年人口
age_data_raw <- estat_getStatsData(
  appId = appId,
  statsDataId = "0000020201",
  cdArea = city_codes,
  cdCat01 = "A1301,A1302,A1303", 
  cdTime = "2020100000"
)

# 3. データの整形(cat01_code を使って確実に判定)
age_analysis <- age_data_raw %>%
  mutate(
    value = as.numeric(value),
    city_name = gsub("福岡県 ", "", 地域),
    category = case_when(
      cat01_code == "A1301" ~ "年少人口",
      cat01_code == "A1302" ~ "生産年齢人口",
      cat01_code == "A1303" ~ "老年人口",
      TRUE ~ "その他"
    )
  ) %>%
  filter(category != "その他") %>%
  select(city_name, category, value)

# 4. 構成比(%)の算出
age_pct <- age_analysis %>%
  group_by(city_name) %>%
  mutate(pct = value / sum(value) * 100) %>%
  ungroup()

# グラフの重なり順を固定
age_pct$category <- factor(age_pct$category, levels = c("老年人口", "生産年齢人口", "年少人口"))

# 高齢化率(老年人口の割合)が低い順に自治体を並べ替え
order_cities <- age_pct %>%
  filter(category == "老年人口") %>%
  arrange(pct) %>%
  pull(city_name)
age_pct$city_name <- factor(age_pct$city_name, levels = order_cities)

# 5. 可視化(AONF形式)
ggplot(age_pct, aes(x = city_name, y = pct, fill = category)) +
  geom_bar(stat = "identity", position = "stack") +
  coord_flip() +
  scale_fill_manual(values = c("老年人口" = "#8B0000", "生産年齢人口" = "#4682B4", "年少人口" = "#3CB371")) +
  labs(
    title = "福岡県内 29市の年齢3区分構成比(2020年)",
    subtitle = "出典:e-Stat(自治体は高齢化率が低い順に配置)",
    x = "市名",
    y = "構成比 (%)",
    fill = "年齢区分",
    caption = AONF_CAPTION
  ) +
  theme_minimal(base_family = "HiraKakuProN-W3") +
  theme(
    legend.position = "bottom",
    axis.text.y = element_text(size = 8),
    plot.caption = element_text(size = 8, hjust = 1, color = "grey30"),
    panel.grid.minor = element_blank()
  )
```

|

« 各政党の地域浸透度(人口規模と各党の得票数、2026年衆議院議員選挙福岡11区) | トップページ | 福岡県の市区町村別世帯数及び人口(2025年9月1日現在) »

「分析メモ」カテゴリの記事