Assumptions For Fertility Rates By Age, Type Of Projection And NUTS 3 Region by Eurostat | Demographics and Population Studies

About this Dataset

Assumptions For Fertility Rates By Age, Type Of Projection And NUTS 3 Region

This Eurostat dataset contains data on assumptions for fertility rates by age, type of projection and nuts 3 region, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2020-11-16T23:00:00+0100

Tables

Assumptions For Fertility Rates By Age, Type Of Projection And NUTS 3 Region - Raw

@eurostat.proj_19raasfr3.raw

14.37 MB
46208 rows
87 columns


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

Assumptions For Fertility Rates By Age, Type Of Projection And NUTS 3 Region - Unpivoted

@eurostat.proj_19raasfr3.tidy

12.07 MB
3789056 rows
7 columns


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