Assumptions For Fertility Rates By Age And Type Of Projection

Eurostat code: proj_19naasfr · (2019 - 2100)

@eurostat.proj_19naasfr

Table List

2 tables(2 MB)

Assumptions For Fertility Rates By Age And Type Of Projection - Raw

Assumptions For Fertility Rates By Age And Type Of Projection - Unpivoted

Assumptions For Fertility Rates By Age And Type Of Projection - Raw

@eurostat.proj_19naasfr.raw

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

1.45 MB
2356 rows
87 columns

freq Freq	projection Projection	unit Unit	age Age	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	Baseline projections	Number	Total	Austria	1.44928	1.45013	1.45393	1.45768	1.46136	1.46499	1.46857	1.4721	1.47557	1.479	1.48237	1.48571	1.489	1.49224	1.49545	1.49862	1.50174	1.50484	1.5079	1.51092	1.51391	1.51688	1.51981	1.52272	1.5256	1.52845	1.53129	1.5341	1.53689	1.53966	1.54241	1.54515	1.54786	1.55057	1.55326	1.55594	1.55861	1.56127	1.56392	1.56657	1.5692	1.57184	1.57446	1.57709	1.57971	1.58234	1.58496	1.58758	1.59021	1.59284	1.59547	1.59811	1.60076	1.60341	1.60607	1.60874	1.61142	1.61411	1.61681	1.61953	1.62226	1.625	1.62776	1.63053	1.63332	1.63613	1.63895	1.6418	1.64466	1.64755	1.65046	1.65339	1.65634	1.65932	1.66232	1.66535	1.6684	1.67148	1.67458	1.67772	1.68088	1.68407
Annual	Baseline projections	Number	Total	Belgium	1.57673	1.559	1.56238	1.56569	1.56894	1.57213	1.57526	1.57832	1.58133	1.58429	1.58718	1.59003	1.59282	1.59557	1.59826	1.60091	1.60352	1.60608	1.6086	1.61108	1.61351	1.61591	1.61828	1.62061	1.6229	1.62516	1.6274	1.6296	1.63177	1.63391	1.63603	1.63812	1.64019	1.64224	1.64427	1.64627	1.64826	1.65022	1.65217	1.65411	1.65602	1.65793	1.65982	1.6617	1.66357	1.66543	1.66727	1.66912	1.67095	1.67278	1.6746	1.67642	1.67823	1.68004	1.68185	1.68366	1.68546	1.68727	1.68908	1.69089	1.69271	1.69452	1.69635	1.69817	1.70001	1.70185	1.70369	1.70555	1.70741	1.70928	1.71117	1.71306	1.71496	1.71688	1.71881	1.72075	1.72271	1.72468	1.72666	1.72866	1.73068	1.73271
Annual	Baseline projections	Number	Total	Bulgaria	1.58	1.59237	1.59936	1.60601	1.61232	1.61832	1.62401	1.62942	1.63455	1.63941	1.64402	1.64839	1.65252	1.65644	1.66015	1.66365	1.66696	1.67009	1.67305	1.67584	1.67847	1.68096	1.6833	1.68551	1.68758	1.68954	1.69139	1.69312	1.69475	1.69629	1.69773	1.69909	1.70037	1.70157	1.7027	1.70377	1.70477	1.70572	1.70661	1.70746	1.70825	1.70901	1.70973	1.71041	1.71106	1.71168	1.71228	1.71285	1.71341	1.71394	1.71447	1.71498	1.71548	1.71597	1.71646	1.71695	1.71743	1.71792	1.71841	1.7189	1.7194	1.71991	1.72043	1.72096	1.72151	1.72207	1.72264	1.72323	1.72384	1.72447	1.72512	1.7258	1.72649	1.72721	1.72796	1.72873	1.72953	1.73036	1.73121	1.7321	1.73301	1.73396
Annual	Baseline projections	Number	Total	Switzerland	1.48	1.46427	1.46813	1.47194	1.47568	1.47937	1.48301	1.48659	1.49012	1.4936	1.49703	1.50041	1.50375	1.50704	1.5103	1.51351	1.51668	1.51981	1.52291	1.52597	1.529	1.532	1.53496	1.5379	1.54081	1.54369	1.54654	1.54937	1.55218	1.55496	1.55773	1.56047	1.5632	1.56591	1.56861	1.57128	1.57395	1.5766	1.57925	1.58188	1.5845	1.58712	1.58972	1.59233	1.59492	1.59751	1.6001	1.60269	1.60528	1.60787	1.61045	1.61304	1.61564	1.61823	1.62083	1.62344	1.62605	1.62867	1.6313	1.63394	1.63658	1.63924	1.64191	1.64459	1.64729	1.64999	1.65272	1.65545	1.65821	1.66098	1.66377	1.66657	1.6694	1.67224	1.67511	1.678	1.6809	1.68383	1.68679	1.68977	1.69277	1.69579
Annual	Baseline projections	Number	Total	Cyprus	1.3331	1.33757	1.34246	1.34728	1.35202	1.35669	1.36129	1.36582	1.37029	1.3747	1.37904	1.38333	1.38756	1.39174	1.39586	1.39994	1.40396	1.40794	1.41188	1.41577	1.41963	1.42344	1.42722	1.43096	1.43467	1.43835	1.44199	1.44561	1.44921	1.45278	1.45632	1.45985	1.46335	1.46684	1.47031	1.47377	1.47721	1.48064	1.48406	1.48747	1.49088	1.49427	1.49767	1.50106	1.50445	1.50783	1.51122	1.51462	1.51801	1.52141	1.52482	1.52823	1.53165	1.53508	1.53853	1.54198	1.54545	1.54893	1.55243	1.55595	1.55948	1.56304	1.56661	1.57021	1.57382	1.57747	1.58113	1.58482	1.58854	1.59229	1.59606	1.59986	1.6037	1.60756	1.61146	1.61539	1.61936	1.62336	1.62739	1.63146	1.63557	1.63972
Annual	Baseline projections	Number	Total	Czechia	1.709	1.70983	1.71551	1.72079	1.72571	1.73028	1.73453	1.73847	1.74213	1.74552	1.74866	1.75157	1.75425	1.75672	1.759	1.7611	1.76302	1.76479	1.76641	1.76789	1.76923	1.77046	1.77157	1.77258	1.77349	1.77431	1.77505	1.77571	1.77629	1.77681	1.77727	1.77767	1.77802	1.77832	1.77858	1.7788	1.77899	1.77914	1.77926	1.77936	1.77943	1.77948	1.77952	1.77954	1.77955	1.77954	1.77953	1.77951	1.77949	1.77946	1.77943	1.7794	1.77937	1.77934	1.77932	1.7793	1.77929	1.77929	1.77929	1.7793	1.77933	1.77936	1.77941	1.77946	1.77953	1.77962	1.77971	1.77983	1.77996	1.7801	1.78026	1.78044	1.78063	1.78084	1.78107	1.78132	1.78158	1.78187	1.78217	1.78249	1.78284	1.7832
Annual	Baseline projections	Number	Total	Germany	1.53443	1.52164	1.52682	1.53184	1.53672	1.54145	1.54605	1.55052	1.55486	1.55908	1.56317	1.56715	1.57102	1.57478	1.57843	1.58198	1.58543	1.58878	1.59204	1.59522	1.59831	1.60131	1.60424	1.60708	1.60986	1.61256	1.6152	1.61777	1.62027	1.62272	1.62511	1.62744	1.62972	1.63195	1.63414	1.63627	1.63837	1.64042	1.64243	1.64441	1.64635	1.64826	1.65014	1.65199	1.65381	1.65561	1.65738	1.65913	1.66086	1.66258	1.66428	1.66596	1.66763	1.66929	1.67094	1.67258	1.67421	1.67584	1.67747	1.67909	1.68071	1.68233	1.68395	1.68558	1.6872	1.68884	1.69048	1.69212	1.69378	1.69545	1.69712	1.69881	1.70051	1.70223	1.70396	1.7057	1.70747	1.70925	1.71105	1.71287	1.71471	1.71657
Annual	Baseline projections	Number	Total	Denmark	1.71942	1.71833	1.72082	1.72322	1.72552	1.72773	1.72986	1.7319	1.73387	1.73575	1.73756	1.73931	1.74098	1.74258	1.74412	1.7456	1.74702	1.74839	1.74969	1.75095	1.75216	1.75331	1.75443	1.75549	1.75652	1.7575	1.75845	1.75936	1.76023	1.76107	1.76188	1.76266	1.7634	1.76413	1.76482	1.76549	1.76614	1.76676	1.76737	1.76795	1.76852	1.76907	1.7696	1.77012	1.77062	1.77111	1.77159	1.77206	1.77252	1.77298	1.77342	1.77386	1.77429	1.77471	1.77513	1.77555	1.77596	1.77637	1.77678	1.77719	1.7776	1.77801	1.77842	1.77883	1.77925	1.77966	1.78009	1.78051	1.78094	1.78138	1.78182	1.78226	1.78272	1.78318	1.78365	1.78412	1.78461	1.7851	1.78561	1.78612	1.78664	1.78717
Annual	Baseline projections	Number	Total	Estonia	1.51143	1.45993	1.47774	1.49438	1.50993	1.52444	1.53797	1.5506	1.56235	1.5733	1.58348	1.59294	1.60173	1.60988	1.61744	1.62444	1.63091	1.63689	1.64241	1.6475	1.65219	1.65649	1.66044	1.66406	1.66738	1.6704	1.67316	1.67567	1.67795	1.68001	1.68187	1.68355	1.68506	1.68641	1.68762	1.68869	1.68964	1.69048	1.69122	1.69187	1.69244	1.69293	1.69335	1.69372	1.69403	1.6943	1.69453	1.69472	1.69489	1.69503	1.69516	1.69528	1.69538	1.69548	1.69559	1.69569	1.6958	1.69592	1.69606	1.69621	1.69638	1.69657	1.69679	1.69703	1.6973	1.6976	1.69793	1.6983	1.6987	1.69914	1.69962	1.70013	1.70069	1.7013	1.70194	1.70264	1.70338	1.70416	1.70499	1.70588	1.70681	1.70779
Annual	Baseline projections	Number	Total	Greece	1.33622	1.3386	1.34399	1.34928	1.35448	1.35958	1.36459	1.36952	1.37436	1.37911	1.38379	1.38839	1.39292	1.39738	1.40176	1.40608	1.41034	1.41453	1.41866	1.42274	1.42676	1.43073	1.43464	1.43851	1.44233	1.44611	1.44985	1.45354	1.4572	1.46082	1.46441	1.46797	1.47149	1.47499	1.47846	1.48191	1.48533	1.48873	1.49212	1.49548	1.49883	1.50217	1.50549	1.50881	1.51211	1.51541	1.5187	1.52199	1.52527	1.52855	1.53183	1.53512	1.53841	1.5417	1.545	1.5483	1.55162	1.55494	1.55828	1.56162	1.56499	1.56836	1.57176	1.57517	1.5786	1.58205	1.58552	1.58902	1.59253	1.59608	1.59965	1.60324	1.60687	1.61052	1.6142	1.61792	1.62166	1.62544	1.62926	1.63311	1.63699	1.64091


CREATE TABLE raw (
  "freq" VARCHAR,
  "projection" VARCHAR,
  "unit" VARCHAR,
  "age" 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
);