福岡県内各市の人口をRのestatapiで、e-Statから入手する。
```{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()
)
```
| 固定リンク
「分析メモ」カテゴリの記事
- 高市内閣の支持・不支持の理由の推移:NHK世論調査(2026.10.05)
- 「左右対立(という戦略)」の失敗だけで説明できるのか――2026年衆議院議員選挙について(2026.06.24)
- 「リベラル」、「伝統保守」というクラスターに注目して、そのネーミングの問題点、実体化して捉えることの妥当性について検討する(2026.06.19)
- 自民党支持者の多数派は「新自由主義右翼」(橋本健二氏)か?(2026.06.15)
- 格差に対する意識と流動性に対する意識が政党支持とどのように関係しているか(2026.06.14)