Population Structure Indicators At National Level

Eurostat code: demo_pjanind · (1960 - 2024)

@eurostat.demo_pjanind

Table List

2 tables(553.18 KB)

Population Structure Indicators At National Level - Raw

Population Structure Indicators At National Level - Unpivoted

Population Structure Indicators At National Level - Unpivoted

@eurostat.demo_pjanind.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.

192.07 KB
118984 rows
5 columns

freq Freq	indic_de Indic De	geo Geo	time_period Time Period	value Value
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Austria	1960	51.4
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Belgium	1960	54.7
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Bulgaria	1960	50.6
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Switzerland	1960	52.3
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Czechia	1960	54.1
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Germany	1960	46.8
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Germany including former GDR	1960	48.1
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Denmark	1960	56.2
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	European Free Trade Association	1960	55.1
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Spain	1960	55.4


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_de" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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