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 - Raw

@eurostat.demo_pjanind.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

361.12 KB
3072 rows
68 columns

freq Freq	indic_de Indic De	geo Geo	n_1960 1960	n_1961 1961	n_1962 1962	n_1963 1963	n_1964 1964	n_1965 1965	n_1966 1966	n_1967 1967	n_1968 1968	n_1969 1969	n_1970 1970	n_1971 1971	n_1972 1972	n_1973 1973	n_1974 1974	n_1975 1975	n_1976 1976	n_1977 1977	n_1978 1978	n_1979 1979	n_1980 1980	n_1981 1981	n_1982 1982	n_1983 1983	n_1984 1984	n_1985 1985	n_1986 1986	n_1987 1987	n_1988 1988	n_1989 1989	n_1990 1990	n_1991 1991	n_1992 1992	n_1993 1993	n_1994 1994	n_1995 1995	n_1996 1996	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023	n_2024 2024
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Andorra																											38.9	38.8	38.7	38	38.6	37.3	35.3	35.2	34.8	35.1	36	36.4	36.7	36.9	37.8	38.6	39.2	39.7	38	36.6	36.7	36.3	36.2	36.5	37.6	39.1	39.1	39.1						37.8
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Albania																																											58.4	57.3	56.4	55.3	54.1	52.6	51.7	50.9	49.8	48.3	47.1	46.4	46.1	45.9	45.5	45.5	45.4	45.6	46.2	46.6	47.2	48.2
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Armenia																																															45.8	44	42.4	40.9	39.7					43	44.1	45.3	46.5	47.4	48.3	48.8			55.7
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Austria	51.4	52.8	54.1	54.9	55.8	57	58.1	59.3	60.4	61.5	62.2	62.6	62.7	62.5	62	61.8	61.3	60.2	59.1	57.9	56.6	55	53.1	51.2	49.4	48.3	47.9	47.7	47.8	48	48	48.1	48.3	48.5	48.8	49	49.2	49.1	48.9	48.7	48.3	47.9	47.5	47	46.7	47.2	47.8	48.2	48.2	48.2	48.3	47.9	47.8	48.1	48.4	48.7	48.8	49.1	49.5	49.9	50.2	50.6	51.1	51.5	52
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Azerbaijan																																															46.2	44.7	43.2	41.6	39.9	39.1	38.8	39	39.3	39.6	40.2	40.8	41.1	41.3	42	42.5	42.9	43.6	43.6
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Belgium	54.7	55.4	56.4	56.7	56.8	57.2	57.7	58.3	58.6	58.6	58.7	58.7	58.5	58.2	57.8	57	56.2	55.3	54.4	53.7	52.9	51.8	51.4	50.2	49.1	48.4	48.3	48.3	48.4	48.7	49.1	49.6	50.1	50.5	50.8	51	51.4	51.7	52	52.2	52.4	52.5	52.6	52.5	52.5	52.5	52.2	51.7	51.4	51.4	51.7	51.7	52.3	52.8	53.4	54	54.4	54.9	55.4	55.8	56.2	56.4	56.6	56.7	56.8
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Bulgaria	50.6	50.5	50.1	49.7	49.2	48.5	48.1	47.9	47.6	47.7	47.9	48	48.2	48.3	48.6	49.2	49.9	50.2	50.8	50.5	51.3	51.7	51.2	50.3	49.3	49.2	49.3	49.6	50.1	50.2	50.4	50.4	50.2	49.9	49.7	49.2	48.9	48.3	47.9	47.4	47.2	46.8	46.8	46.3	45.7	45.1	44.8	44.6	44.8	45.1	45.6	46.4	47.5	49.8	51.1	52.4	53.8	55	56.2	57.4	58.5	59.1	60.2	60.4	61
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Belarus																																															42.3	41.8	41.1	40.4		40.2	40.5	41.3	42.1	43.4	44.4	45.6	46.5	47.3
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Switzerland	52.3	52	52.4	52.4	52.4	52.7	53.2	53.7	53.8	53.8	53.8	54.5	54.7	54.4	54.2	54	53.8	53.3	52.8	52	51.1	50	49	48	47.2	46.6	46.3	46.1	46	46.1	46.2	46.2	46.6	47.1	47.5	47.8	48	48.3	48.4	48.5	48.6	48.6	48.1	47.8	47.5	47.3	47	47	46.8	46.8	47	47.1	47.4	47.8	48.1	48.5	48.8	49.2	49.8	50.3	50.8	51.2	51.8	52.1	52.2
Annual	Age dependency ratio, 1st variant (population 0 to 14 years and 65 years or over to population 15 to 64 years)	Cyprus																	55.1						55.7	55.7	56.4	56.9	57.6	58.1	58.5	58.8	58.4	58	57.7	57.3	56.8	56.4	55.5	54.7	53.8	52.6	51.5	50.6	49.6	48.7	47.7	47	46.1	45.4	44.1	43.1	42.3	41.9	41.5	42	43.1	45	46.1	46.8	47.3	47.6	47.8	48.1	48.3	48.7	49.3


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_de" VARCHAR,
  "geo" VARCHAR,
  "n_1960" DOUBLE,
  "n_1961" DOUBLE,
  "n_1962" DOUBLE,
  "n_1963" DOUBLE,
  "n_1964" DOUBLE,
  "n_1965" DOUBLE,
  "n_1966" DOUBLE,
  "n_1967" DOUBLE,
  "n_1968" DOUBLE,
  "n_1969" DOUBLE,
  "n_1970" DOUBLE,
  "n_1971" DOUBLE,
  "n_1972" DOUBLE,
  "n_1973" DOUBLE,
  "n_1974" DOUBLE,
  "n_1975" DOUBLE,
  "n_1976" DOUBLE,
  "n_1977" DOUBLE,
  "n_1978" DOUBLE,
  "n_1979" DOUBLE,
  "n_1980" DOUBLE,
  "n_1981" DOUBLE,
  "n_1982" DOUBLE,
  "n_1983" DOUBLE,
  "n_1984" DOUBLE,
  "n_1985" DOUBLE,
  "n_1986" DOUBLE,
  "n_1987" DOUBLE,
  "n_1988" DOUBLE,
  "n_1989" DOUBLE,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);