Median Age Of Residents By Sex And Citizenship

Eurostat code: demo_popmdctz · (2021 - 2024)

@eurostat.demo_popmdctz

Table List

2 tables(19.18 KB)

Median Age Of Residents By Sex And Citizenship - Raw

Median Age Of Residents By Sex And Citizenship - Unpivoted

Median Age Of Residents By Sex And Citizenship - Unpivoted

@eurostat.demo_popmdctz.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.41 KB
1296 rows
7 columns

freq Freq	citizen Citizen	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.8
Annual	European Free Trade Association except reporting country	Year	Males	France	2021	46.9
Annual	European Free Trade Association except reporting country	Year	Total	France	2021	46.3
Annual	EU27 countries (from 2020) except reporting country	Year	Females	France	2021	44.4
Annual	EU27 countries (from 2020) except reporting country	Year	Males	France	2021	46.3
Annual	EU27 countries (from 2020) except reporting country	Year	Total	France	2021	45.4
Annual	Foreign country and stateless	Year	Females	France	2021	37.5
Annual	Foreign country and stateless	Year	Males	France	2021	37.9
Annual	Foreign country and stateless	Year	Total	France	2021	37.7
Annual	Reporting country	Year	Females	France	2021	44.4


CREATE TABLE tidy (
  "freq" VARCHAR,
  "citizen" 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.