Population On 1st January By Age, Sex And Type Of Projection

Eurostat code: proj_23np · (2022 - 2100)

@eurostat.proj_23np

Table List

2 tables(58.03 MB)

Population On 1st January By Age, Sex And Type Of Projection - Raw

Population On 1st January By Age, Sex And Type Of Projection - Unpivoted

Population On 1st January By Age, Sex And Type Of Projection - Raw

@eurostat.proj_23np.raw

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

29.24 MB
63360 rows
85 columns

freq Freq	projection Projection	sex Sex	age Age	unit Unit	geo Geo	n_2022 2022	n_2023 2023	n_2024 2024	n_2025 2025	n_2026 2026	n_2027 2027	n_2028 2028	n_2029 2029	n_2030 2030	n_2031 2031	n_2032 2032	n_2033 2033	n_2034 2034	n_2035 2035	n_2036 2036	n_2037 2037	n_2038 2038	n_2039 2039	n_2040 2040	n_2041 2041	n_2042 2042	n_2043 2043	n_2044 2044	n_2045 2045	n_2046 2046	n_2047 2047	n_2048 2048	n_2049 2049	n_2050 2050	n_2051 2051	n_2052 2052	n_2053 2053	n_2054 2054	n_2055 2055	n_2056 2056	n_2057 2057	n_2058 2058	n_2059 2059	n_2060 2060	n_2061 2061	n_2062 2062	n_2063 2063	n_2064 2064	n_2065 2065	n_2066 2066	n_2067 2067	n_2068 2068	n_2069 2069	n_2070 2070	n_2071 2071	n_2072 2072	n_2073 2073	n_2074 2074	n_2075 2075	n_2076 2076	n_2077 2077	n_2078 2078	n_2079 2079	n_2080 2080	n_2081 2081	n_2082 2082	n_2083 2083	n_2084 2084	n_2085 2085	n_2086 2086	n_2087 2087	n_2088 2088	n_2089 2089	n_2090 2090	n_2091 2091	n_2092 2092	n_2093 2093	n_2094 2094	n_2095 2095	n_2096 2096	n_2097 2097	n_2098 2098	n_2099 2099	n_2100 2100
Annual	Baseline projections	Females	Total	Person	Austria	4553444	4619179	4637385	4642165	4648688	4657079	4667048	4677085	4686892	4696402	4705539	4714512	4723399	4734368	4744662	4754422	4763718	4772370	4780656	4788460	4795704	4802486	4808756	4814560	4820073	4825141	4829577	4833134	4836014	4838075	4839456	4840126	4840239	4839779	4838813	4837480	4835736	4833724	4831502	4829145	4826921	4824713	4822594	4820665	4819112	4817751	4816851	4816195	4815896	4815772	4815738	4815659	4815596	4815440	4815284	4814941	4814482	4813870	4813204	4812436	4811726	4810903	4810022	4809095	4808139	4807294	4806510	4805846	4805327	4804945	4804724	4804660	4804758	4805013	4805384	4805863	4806421	4807030	4807661
Annual	Baseline projections	Females	Total	Person	Belgium	5883978	5947528	5977636	5995842	6013603	6030894	6047664	6064693	6081967	6099192	6116316	6133406	6150433	6168969	6187341	6205126	6222536	6239295	6255391	6270767	6285308	6298954	6311717	6323558	6334629	6344553	6353456	6361226	6368077	6373982	6379165	6383603	6387547	6390878	6393872	6396512	6398840	6400849	6402529	6404227	6406047	6407998	6409998	6412147	6414535	6416959	6419374	6421872	6424453	6427035	6429659	6432083	6434310	6436156	6437648	6438548	6438882	6438521	6437604	6436012	6433852	6431059	6427739	6423909	6419475	6414825	6409611	6404089	6398339	6392395	6386284	6380040	6373662	6367153	6360479	6353616	6346550	6339287	6331785
Annual	Baseline projections	Females	Total	Person	Bulgaria	3527626	3605059	3597211	3564456	3532162	3500007	3467805	3436663	3406408	3377075	3348576	3321123	3295249	3274235	3253623	3233345	3213452	3194476	3176232	3158299	3140827	3123699	3106804	3090248	3073769	3057514	3041444	3025657	3010025	2994550	2979323	2964119	2949106	2934073	2918902	2903458	2887789	2872005	2856099	2839985	2823974	2807793	2791913	2776604	2761504	2746523	2731854	2717612	2703893	2690667	2677977	2665824	2654298	2643481	2633027	2623083	2613659	2604750	2596548	2588858	2581800	2575319	2569409	2564156	2559473	2555455	2552069	2549235	2547017	2545336	2544139	2543348	2542905	2542735	2542769	2542919	2543158	2543414	2543673
Annual	Baseline projections	Females	Total	Person	Switzerland	4400588	4456498	4484245	4501984	4520843	4540931	4562122	4583004	4603352	4622950	4641822	4660040	4677623	4696172	4714014	4731202	4748015	4764112	4779734	4794917	4809697	4824054	4837994	4851539	4864825	4877653	4890033	4901712	4912805	4923237	4932952	4941841	4950151	4957625	4964453	4970548	4976016	4980752	4984953	4988732	4992243	4995440	4998414	5001241	5004050	5006843	5009648	5012431	5015196	5017925	5020567	5023184	5025743	5028190	5030574	5032693	5034652	5036427	5038142	5039737	5041308	5042748	5044173	5045527	5046854	5048430	5049677	5051412	5053335	5055454	5057765	5060276	5062974	5065836	5068808	5071876	5074990	5078125	5081250
Annual	Baseline projections	Females	Total	Person	Cyprus	463622	476907	482423	485033	487136	488769	489890	490963	491975	492911	493751	494537	495231	496168	496996	497693	498307	498853	499321	499722	500157	500521	500899	501263	501631	501972	502285	502639	502996	503359	503728	504062	504431	504756	505101	505406	505764	506079	506359	506600	506815	506975	507051	507065	507003	506886	506680	506429	506121	505758	505344	504896	504440	503961	503479	502964	502463	501939	501426	500923	500474	500044	499679	499383	499154	499029	498985	499023	499159	499376	499676	500057	500520	501066	501680	502366	503110	503922	504781
Annual	Baseline projections	Females	Total	Person	Czechia	5332932	5608669	5655656	5629506	5603734	5578506	5553266	5529833	5507439	5485704	5464548	5444257	5424967	5417794	5411068	5404506	5399280	5394868	5391426	5388433	5385788	5383443	5381443	5379604	5377444	5375263	5373331	5371409	5369528	5367591	5365354	5362745	5360216	5356823	5352974	5348452	5342976	5336825	5329414	5321241	5312450	5303092	5293281	5283127	5272752	5262297	5251896	5241676	5231790	5222456	5213913	5206539	5200232	5194698	5190051	5185961	5182740	5180241	5178625	5177691	5177473	5177806	5178634	5179776	5181272	5183473	5185503	5188196	5191304	5194695	5198325	5202239	5206338	5210557	5214774	5218892	5222796	5226421	5229720
Annual	Baseline projections	Females	Total	Person	Germany	42170339	42921064	43149647	43189130	43203849	43194667	43158017	43125529	43094741	43064825	43036077	43008949	42983259	42982205	42977607	42969986	42959587	42945479	42929736	42911958	42891768	42869439	42845193	42819094	42792954	42763920	42732480	42697501	42659904	42620354	42580151	42538839	42497542	42454085	42410853	42363875	42316506	42270283	42225384	42183399	42146342	42114179	42085331	42060310	42040001	42021993	42006755	41993885	41983156	41973775	41964941	41955957	41946688	41935713	41924037	41910305	41896216	41881413	41867384	41853454	41840966	41828441	41816303	41804389	41793128	41783719	41773176	41765235	41758848	41753695	41749825	41747005	41744964	41743566	41742641	41742045	41741776	41741843	41742168
Annual	Baseline projections	Females	Total	Person	Denmark	2950505	2981828	2997305	3006258	3014571	3022220	3029030	3035816	3042237	3048243	3053721	3058369	3062225	3066229	3069672	3072575	3075300	3077112	3078468	3079477	3079838	3079874	3079681	3079321	3078838	3078275	3077665	3077024	3076367	3075758	3075233	3074795	3074576	3074542	3074655	3074837	3075159	3075485	3075968	3076415	3076773	3077112	3077377	3077601	3077825	3077812	3077658	3077530	3077396	3077223	3077010	3076726	3076433	3075990	3075518	3074795	3073907	3072881	3071686	3070316	3068917	3067323	3065527	3063545	3061411	3059236	3056733	3054421	3052125	3049884	3047729	3045682	3043786	3042035	3040464	3039074	3037871	3036829	3035959
Annual	Baseline projections	Females	Total	Person	Euro area – 20 countries (from 2023)	177096882	178934451	179602684	179844449	180017347	180125871	180161115	180211699	180268417	180324789	180381784	180440079	180498497	180609153	180707532	180791425	180858687	180905015	180932025	180934776	180912339	180864203	180789308	180686886	180560824	180403764	180218373	179999995	179754775	179483348	179188233	178870367	178535862	178180508	177811347	177425168	177029110	176623653	176213622	175804416	175401766	175007412	174621590	174247196	173889298	173541102	173205575	172883726	172575757	172280101	171997082	171724265	171463770	171209880	170964509	170722578	170486308	170252890	170026832	169803866	169586109	169369427	169154185	168940443	168727304	168519593	168312409	168108782	167908505	167710671	167515222	167321595	167129383	166938086	166747201	166556433	166365786	166175638	165986249
Annual	Baseline projections	Females	Total	Person	Estonia	698381	722603	725970	722505	718940	715299	711505	707850	704375	701036	697878	694920	692137	690582	689179	687872	686701	685524	684421	683344	682318	681302	680282	679261	678251	677221	676193	675164	674129	673053	671960	670877	669831	668729	667574	666324	665047	663679	662299	660907	659543	658189	656857	655547	654266	653012	651787	650591	649463	648383	647367	646428	645530	644662	643816	642952	642086	641236	640414	639633	638884	638169	637555	637001	636488	636076	635706	635458	635312	635258	635285	635383	635540	635735	635940	636149	636339	636505	636634


CREATE TABLE raw (
  "freq" VARCHAR,
  "projection" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE,
  "n_2025" DOUBLE,
  "n_2026" DOUBLE,
  "n_2027" DOUBLE,
  "n_2028" DOUBLE,
  "n_2029" DOUBLE,
  "n_2030" DOUBLE,
  "n_2031" DOUBLE,
  "n_2032" DOUBLE,
  "n_2033" DOUBLE,
  "n_2034" DOUBLE,
  "n_2035" DOUBLE,
  "n_2036" DOUBLE,
  "n_2037" DOUBLE,
  "n_2038" DOUBLE,
  "n_2039" DOUBLE,
  "n_2040" DOUBLE,
  "n_2041" DOUBLE,
  "n_2042" DOUBLE,
  "n_2043" DOUBLE,
  "n_2044" DOUBLE,
  "n_2045" DOUBLE,
  "n_2046" DOUBLE,
  "n_2047" DOUBLE,
  "n_2048" DOUBLE,
  "n_2049" DOUBLE,
  "n_2050" DOUBLE,
  "n_2051" DOUBLE,
  "n_2052" DOUBLE,
  "n_2053" DOUBLE,
  "n_2054" DOUBLE,
  "n_2055" DOUBLE,
  "n_2056" DOUBLE,
  "n_2057" DOUBLE,
  "n_2058" DOUBLE,
  "n_2059" DOUBLE,
  "n_2060" DOUBLE,
  "n_2061" DOUBLE,
  "n_2062" DOUBLE,
  "n_2063" DOUBLE,
  "n_2064" DOUBLE,
  "n_2065" DOUBLE,
  "n_2066" DOUBLE,
  "n_2067" DOUBLE,
  "n_2068" DOUBLE,
  "n_2069" DOUBLE,
  "n_2070" DOUBLE,
  "n_2071" DOUBLE,
  "n_2072" DOUBLE,
  "n_2073" DOUBLE,
  "n_2074" DOUBLE,
  "n_2075" DOUBLE,
  "n_2076" DOUBLE,
  "n_2077" DOUBLE,
  "n_2078" DOUBLE,
  "n_2079" DOUBLE,
  "n_2080" DOUBLE,
  "n_2081" DOUBLE,
  "n_2082" DOUBLE,
  "n_2083" DOUBLE,
  "n_2084" DOUBLE,
  "n_2085" DOUBLE,
  "n_2086" DOUBLE,
  "n_2087" DOUBLE,
  "n_2088" DOUBLE,
  "n_2089" DOUBLE,
  "n_2090" DOUBLE,
  "n_2091" DOUBLE,
  "n_2092" DOUBLE,
  "n_2093" DOUBLE,
  "n_2094" DOUBLE,
  "n_2095" DOUBLE,
  "n_2096" DOUBLE,
  "n_2097" DOUBLE,
  "n_2098" DOUBLE,
  "n_2099" DOUBLE,
  "n_2100" DOUBLE
);