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

Eurostat code: urt_proj_19rp · (2019 - 2100)

@eurostat.urt_proj_19rp

Table List

2 tables(1019.02 KB)

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

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

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

@eurostat.urt_proj_19rp.raw

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

517.4 KB
1053 rows
89 columns

freq Freq	terrtypo Terrtypo	projection Projection	age Age	sex Sex	unit Unit	geo Geo	n_2019 2019	n_2020 2020	n_2021 2021	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	Border regions	Baseline projections	Total	Females	Person	Austria	4038525	4061914	4074399	4087462	4101099	4115208	4129760	4143359	4156340	4168670	4180298	4191223	4201424	4210948	4219834	4228125	4235897	4243201	4250137	4256727	4263007	4268957	4274566	4279861	4284761	4289241	4293213	4296638	4299489	4301719	4303303	4304247	4304500	4304090	4303023	4301348	4299119	4296398	4293284	4289860	4286234	4282496	4278748	4275074	4271566	4268304	4265336	4262708	4260421	4258459	4256781	4255378	4254232	4253257	4252419	4251621	4250822	4249981	4249075	4248104	4247021	4245858	4244616	4243338	4242067	4240836	4239653	4238551	4237555	4236715	4236048	4235564	4235320	4235292	4235525	4236019	4236738	4237667	4238769	4240028	4241410	4242877
Annual	Border regions	Baseline projections	Total	Females	Person	Belgium	4262842	4275003	4283550	4291244	4298053	4303946	4308877	4313467	4317989	4322450	4326840	4331162	4335427	4339578	4343672	4347665	4351532	4355273	4358833	4362125	4365141	4367793	4370052	4371879	4373166	4373910	4374097	4373769	4372902	4371518	4369665	4367324	4364576	4361451	4358025	4354367	4350503	4346535	4342496	4338546	4334671	4330973	4327509	4324322	4321421	4318844	4316613	4314718	4313152	4311876	4310866	4310095	4309514	4309078	4308770	4308516	4308242	4307955	4307622	4307203	4306719	4306160	4305556	4304940	4304259	4303556	4302849	4302169	4301518	4300954	4300501	4300147	4299946	4299886	4300016	4300273	4300636	4301094	4301628	4302195	4302777	4303338
Annual	Border regions	Baseline projections	Total	Females	Person	Bulgaria	1799911	1781093	1761496	1742233	1723234	1704568	1686292	1668508	1650792	1633233	1615820	1598561	1581525	1564742	1548193	1531846	1515713	1499787	1484125	1468729	1453581	1438689	1424051	1409676	1395552	1381696	1368105	1354806	1341740	1328916	1316282	1303872	1291709	1279747	1267981	1256421	1245058	1233891	1222938	1212169	1201624	1191256	1181073	1171122	1161390	1151862	1142559	1133523	1124762	1116245	1108013	1100070	1092444	1085091	1078058	1071351	1064919	1058806	1053008	1047516	1042342	1037500	1032971	1028816	1024986	1021478	1018307	1015465	1012972	1010804	1008943	1007418	1006188	1005235	1004487	1003955	1003577	1003322	1003148	1003022	1002986	1002991
Annual	Border regions	Baseline projections	Total	Females	Person	Switzerland	3921943	3938885	3956333	3975772	3997149	4020481	4045739	4070808	4095630	4120151	4144331	4168218	4191756	4214938	4237818	4260372	4282609	4304576	4326278	4347770	4369063	4390203	4411176	4432029	4452763	4473374	4493863	4514197	4534392	4554363	4574086	4593528	4612648	4631435	4649851	4667939	4685719	4703175	4720415	4737473	4754419	4771329	4788287	4805359	4822581	4840024	4857754	4875776	4894118	4912778	4931725	4950955	4970424	4990087	5009921	5029876	5049933	5070035	5090210	5110448	5130745	5151101	5171525	5192071	5212745	5233574	5254563	5275752	5297141	5318755	5340594	5362686	5385036	5407640	5430505	5453634	5476985	5500550	5524318	5548282	5572418	5596747
Annual	Border regions	Baseline projections	Total	Females	Person	Cyprus
Annual	Border regions	Baseline projections	Total	Females	Person	Czechia	4734983	4742704	4747919	4751081	4752021	4750601	4746815	4742103	4736363	4729652	4722004	4713533	4704327	4694489	4684150	4673456	4662545	4651542	4640581	4629756	4619114	4608690	4598499	4588567	4578964	4569667	4560708	4552136	4543932	4536043	4528452	4521053	4513770	4506533	4499237	4491794	4484111	4476091	4467693	4458856	4449556	4439762	4429488	4418765	4407637	4396180	4384490	4372684	4360850	4349118	4337587	4326383	4315611	4305391	4295827	4287015	4278993	4271850	4265600	4260219	4255641	4251849	4248791	4246404	4244626	4243448	4242824	4242789	4243335	4244454	4246147	4248411	4251211	4254496	4258246	4262346	4266755	4271342	4276007	4280617	4285133	4289481
Annual	Border regions	Baseline projections	Total	Females	Person	Germany	10100633	10105440	10109499	10111661	10111581	10109270	10104650	10098926	10092638	10085795	10078481	10070944	10063313	10055673	10048103	10040754	10033795	10027019	10020532	10014220	10007953	10001387	9994493	9987071	9978901	9969895	9959931	9948987	9937094	9924292	9910523	9895796	9880239	9864020	9847242	9830079	9812760	9795456	9778518	9762186	9746723	9732419	9719608	9708430	9699008	9691605	9686234	9682841	9681309	9681516	9683281	9686444	9690619	9695597	9701156	9707029	9713122	9719225	9725420	9731676	9737940	9744243	9750621	9757165	9763916	9770924	9778234	9785916	9793987	9802420	9811308	9820621	9830440	9840700	9851328	9862254	9873456	9884934	9896573	9908398	9920432	9932612
Annual	Border regions	Baseline projections	Total	Females	Person	Denmark	361417	360653	360174	359833	359589	359468	359461	359484	359506	359525	359505	359463	359407	359373	359351	359328	359293	359248	359154	359053	358927	358795	358643	358487	358329	358187	358042	357899	357776	357669	357573	357487	357402	357324	357263	357201	357147	357113	357094	357077	357098	357137	357198	357303	357437	357599	357818	358081	358376	358723	359121	359556	360007	360501	361032	361594	362188	362798	363423	364062	364712	365351	366003	366654	367278	367904	368505	369090	369673	370244	370807	371372	371949	372520	373108	373706	374314	374930	375555	376202	376845	377495
Annual	Border regions	Baseline projections	Total	Females	Person	Estonia	315577	313583	310676	307777	304866	301964	299061	296185	293315	290438	287576	284738	281936	279169	276436	273743	271092	268469	265889	263346	260826	258366	255937	253539	251173	248830	246507	244217	241935	239673	237429	235209	233031	230881	228751	226654	224596	222573	220581	218633	216733	214875	213063	211295	209570	207889	206270	204693	203165	201690	200263	198885	197554	196270	195044	193868	192732	191641	190580	189581	188601	187659	186754	185882	185049	184241	183491	182779	182121	181507	180945	180448	180005	179601	179249	178939	178663	178414	178188	177981	177795	177609
Annual	Border regions	Baseline projections	Total	Females	Person	Greece	674679	671517	668261	664932	661503	657969	654390	651108	647874	644703	641676	638755	635980	633257	630601	628035	625563	623114	620679	618275	615871	613470	611046	608580	606084	603534	600937	598301	595644	592962	590238	587485	584723	581945	579174	576338	573509	570680	567884	565111	562363	559684	557034	554452	551932	549495	547149	544889	542727	540661	538689	536835	535095	533444	531909	530497	529202	528035	526975	526051	525231	524514	523887	523368	522953	522621	522340	522136	521987	521908	521854	521862	521882	521935	522022	522135	522293	522503	522717	522959	523242	523551


CREATE TABLE raw (
  "freq" VARCHAR,
  "terrtypo" VARCHAR,
  "projection" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "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
);