Population structure indicators at national level

Data - Eurostat

Author

François Geerolf

Info

source dataset .html .RData
eurostat demo_pjanind 2024-11-01 2024-11-05

Last

Code 
demo_pjanind %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  head(3) %>%
  print_table_conditional()
time Nobs
2023 2410
2022 2292
2021 2397

Example

Code 
include_graphics("https://ec.europa.eu/eurostat/statistics-explained/images/3/39/Population_age_structure_indicators%2C_1_January_2023_%28%25%29_V1.png")

indic_de

Code 
demo_pjanind %>%
  left_join(indic_de, by = "indic_de") %>%
  group_by(indic_de, Indic_de) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
indic_de Indic_de Nobs
PC_FM Women per 100 men 2717
DEPRATIO3 Age dependency ratio, 3rd variant (population 0 to 19 years and 65 years or over to population 20 to 64 years) 2524
OLDDEP3 Old-age dependency ratio 3rd variant (population 65 years or over to population 20 to 64 years) 2524
YOUNGDEP3 Young-age dependency ratio 3rd variant (population 0 to 19 years to population 20 to 64 years) 2524
MEDAGEPOP Median age of population 2519
PC_Y0_14 Proportion of population aged 0-14 years 2512
PC_Y0_19 Proportion of population aged 0-19 years 2512
PC_Y0_4 Proportion of population aged 0-4 years 2512
PC_Y10_14 Proportion of population aged 10-14 years 2512
PC_Y15_19 Proportion of population aged 15-19 years 2512
PC_Y15_24 Proportion of population aged 15-24 years 2512
PC_Y20_24 Proportion of population aged 20-24 years 2512
PC_Y20_39 Proportion of population aged 20-39 years 2512
PC_Y25_29 Proportion of population aged 25-29 years 2512
PC_Y25_44 Proportion of population aged 25-44 years 2512
PC_Y25_49 Proportion of population aged 25-49 years 2512
PC_Y30_34 Proportion of population aged 30-34 years 2512
PC_Y35_39 Proportion of population aged 35-39 years 2512
PC_Y40_44 Proportion of population aged 40-44 years 2512
PC_Y40_59 Proportion of population aged 40-59 years 2512
PC_Y45_49 Proportion of population aged 45-49 years 2512
PC_Y45_64 Proportion of population aged 45-64 years 2512
PC_Y50_54 Proportion of population aged 50-54 years 2512
PC_Y50_64 Proportion of population aged 50-64 years 2512
PC_Y55_59 Proportion of population aged 55-59 years 2512
PC_Y5_9 Proportion of population aged 5-9 years 2512
PC_Y60_64 Proportion of population aged 60-64 years 2512
PC_Y60_MAX Proportion of population aged 60 years and more 2512
PC_Y65_69 Proportion of population aged 65-69 years 2512
PC_Y65_MAX Proportion of population aged 65 years and more 2512
YOUNGDEP1 Young-age dependency ratio 1st variant (population 0 to 14 years to population 15 to 64 years) 2512
YOUNGDEP2 Young-age dependency ratio 2nd variant (population 0 to 19 years to population 20 to 59 years) 2512
DEPRATIO1 Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years) 2510
DEPRATIO2 Age dependency ratio, 2nd variant (population 0 to 19 years and 60 years or over to population 20 to 59 years) 2510
OLDDEP1 Old-age dependency ratio 1st variant (population 65 years or over to population 15 to 64 years) 2510
OLDDEP2 Old-age dependency ratio 2nd variant (population 60 years or over to population 20 to 59 years) 2510
PC_Y70_74 Proportion of population aged 70-74 years 2510
FMEDAGEPOP Median age of population - females 2501
MMEDAGEPOP Median age of population - males 2499
PC_Y60_79 Proportion of population aged 60-79 years 2492
PC_Y65_79 Proportion of population aged 65-79 years 2492
PC_Y75_79 Proportion of population aged 75-79 years 2492
PC_Y80_MAX Proportion of population aged 80 years and more 2481
PC_Y80_84 Proportion of population aged 80-84 years 2443
PC_Y85_MAX Proportion of population aged 85 years and more 2432
PC_Y0_17 Proportion of population aged 0-17 years 2400
DEPRATIO4 Age dependency ratio, 4th variant (population 0 to 24 years and 65 years or over to population 25 to 64 years) 408
OLDDEP4 Old-age dependency ratio 4th variant (population 65 years or over to population 25 to 64 years) 408
YOUNGDEP4 Young-age dependency ratio 4th variant (population 0 to 24 years to population 25 to 64 years) 408
PC_Y15_29 Proportion of population aged 15-29 years 212
PC_Y75_MAX Proportion of population aged 75 years and more 209
PC_Y100_MAX Proportion of population aged 100 years and more 189
PC_Y15_74 Proportion of population aged 15-74 years 168
PC_Y20_64 Proportion of population aged 20-64 years 168
PC_Y0_18 Proportion of population aged 0-18 years 162

geo

Code 
demo_pjanind %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

time

Code 
demo_pjanind %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

Table 2023

Code 
demo_pjanind %>%
  filter(time == "2023",
         indic_de %in% c("YOUNGDEP1", "OLDDEP1", "DEPRATIO1")) %>%
  spread(indic_de, values) %>%
  left_join(geo, by = "geo") %>%
  arrange(-DEPRATIO1) %>%
  select_if(~ n_distinct(.) > 1) %>%
  select(geo, Geo, everything()) %>%
  print_table_conditional