Median Age Of Residents By Sex And Country Of Birth

Eurostat code: demo_popmdctb · (2021 - 2024)

@eurostat.demo_popmdctb

Table List

2 tables(19.77 KB)

Median Age Of Residents By Sex And Country Of Birth - Raw

Median Age Of Residents By Sex And Country Of Birth - Unpivoted

Median Age Of Residents By Sex And Country Of Birth - Unpivoted

@eurostat.demo_popmdctb.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

8.7 KB
1296 rows
7 columns

freq Freq	c_birth C Birth	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	European Free Trade Association except reporting country	Year	Females	France	2021	45.1
Annual	European Free Trade Association except reporting country	Year	Males	France	2021	41.3
Annual	European Free Trade Association except reporting country	Year	Total	France	2021	43.4
Annual	EU27 countries (from 2020) except reporting country	Year	Females	France	2021	55.7
Annual	EU27 countries (from 2020) except reporting country	Year	Males	France	2021	53.7
Annual	EU27 countries (from 2020) except reporting country	Year	Total	France	2021	54.8
Annual	Foreign country	Year	Females	France	2021	48.1
Annual	Foreign country	Year	Males	France	2021	47.9
Annual	Foreign country	Year	Total	France	2021	48
Annual	Reporting country	Year	Females	France	2021	42.6


CREATE TABLE tidy (
  "freq" VARCHAR,
  "c_birth" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.