Total Fertility Rate

Eurostat code: enps_demo_frate1 · (2005 - 2023)

@eurostat.enps_demo_frate1

Table List

2 tables(19.28 KB)

Total Fertility Rate - Unpivoted

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

4.26 KB
106 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Rate	Algeria	2005	2.6
Annual	Rate	Egypt	2005	3.1
Annual	Rate	Israel	2005	2.8
Annual	Rate	Jordan	2005	3.7
Annual	Rate	Morocco	2005	2.4
Annual	Rate	Tunisia	2005	2
Annual	Rate	Algeria	2006	2.3
Annual	Rate	Israel	2006	2.9
Annual	Rate	Jordan	2006	3.7
Annual	Rate	Libya	2006	2.7


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

Share link

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