About this Dataset

Human Fertility Database

The HFD is entirely based on one and the same type of initial data - officially registered birth counts by calendar year, mother's age (and/or cohort) and (whenever possible) biological birth order. These data, together with total female population exposure from the Human Mortality Database (www.mortality.org) and parity-specific female population exposure from selected population censuses, population registers, or large-scale surveys, are further processed using a uniform set of methods. The major HFD output includes detailed data on births, unconditional and conditional fertility rates, cohort and period fertility tables as well as selected aggregate indicators such as total fertility rates, mean ages at childbearing, and parity progression ratios.

For each country, there are four blocks of data provided:

Summary Indicators
Age-Specific Data
Fertility Tables
Input Data

More details at https://www.humanfertility.org/Data/ExplanatoryNotes, and https://www.humanfertility.org/File/GetDocumentFree/Docs/methods.pdf.

Tables

Human Fertility Database

@owid.hfd.owid_cohort_1

99.28 kB
8,212 rows
12 columns

CREATE TABLE owid_cohort_1 (
  "country" VARCHAR,
  "cohort" INTEGER,
  "birth_order" VARCHAR,
  "cmab" FLOAT,
  "cmab40" FLOAT,
  "ppr" FLOAT,
  "sdcmab" FLOAT,
  "sdcmab40" FLOAT,
  "ccf" FLOAT,
  "ccf40" FLOAT,
  "ccf_plus15y" FLOAT,
  "ccf_plus30y" FLOAT
);

Human Fertility Database

@owid.hfd.owid_cohort_2

100.42 kB
8,525 rows
12 columns

CREATE TABLE owid_cohort_2 (
  "country" VARCHAR,
  "cohort" INTEGER,
  "birth_order" VARCHAR,
  "cmab" FLOAT,
  "cmab40" FLOAT,
  "ppr" FLOAT,
  "sdcmab" FLOAT,
  "sdcmab40" FLOAT,
  "ccf" FLOAT,
  "ccf40" FLOAT,
  "ccf_plus15y" FLOAT,
  "ccf_plus30y" FLOAT
);

Human Fertility Database

@owid.hfd.owid_cohort_ages_1

185.36 kB
64,480 rows
6 columns

CREATE TABLE owid_cohort_ages_1 (
  "country" VARCHAR,
  "cohort" INTEGER,
  "age" VARCHAR,
  "birth_order" VARCHAR,
  "asfr_cohort" FLOAT,
  "ccfr_cohort" FLOAT
);

Human Fertility Database

@owid.hfd.owid_cohort_ages_2

190.17 kB
66,704 rows
6 columns

CREATE TABLE owid_cohort_ages_2 (
  "country" VARCHAR,
  "cohort" INTEGER,
  "age" VARCHAR,
  "birth_order" VARCHAR,
  "asfr_cohort" FLOAT,
  "ccfr_cohort" FLOAT
);

Human Fertility Database

@owid.hfd.owid_cohort_ages_years_1

124.24 kB
22,765 rows
5 columns

CREATE TABLE owid_cohort_ages_years_1 (
  "country" VARCHAR,
  "age" INTEGER,
  "cohort" INTEGER,
  "asfr_cohort" FLOAT,
  "ccfr_cohort" FLOAT
);

Human Fertility Database

@owid.hfd.owid_cohort_ages_years_2

126.75 kB
23,308 rows
5 columns

CREATE TABLE owid_cohort_ages_years_2 (
  "country" VARCHAR,
  "age" INTEGER,
  "cohort" INTEGER,
  "asfr_cohort" FLOAT,
  "ccfr_cohort" FLOAT
);

Human Fertility Database

@owid.hfd.owid_cohort_share_women_1

18.55 kB
2,745 rows
4 columns

CREATE TABLE owid_cohort_share_women_1 (
  "country" VARCHAR,
  "num_births" INTEGER,
  "cohort" INTEGER,
  "share_women" FLOAT
);

Human Fertility Database

@owid.hfd.owid_cohort_share_women_2

19.25 kB
2,890 rows
4 columns

CREATE TABLE owid_cohort_share_women_2 (
  "country" VARCHAR,
  "num_births" INTEGER,
  "cohort" INTEGER,
  "share_women" FLOAT
);

Human Fertility Database

@owid.hfd.owid_period_1

270.44 kB
10,930 rows
14 columns

CREATE TABLE owid_period_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "birth_order" VARCHAR,
  "adjtfr" FLOAT,
  "cbr" FLOAT,
  "mab" FLOAT,
  "mab40" FLOAT,
  "patfr" FLOAT,
  "tmab" FLOAT,
  "sdmab" FLOAT,
  "sdmab40" FLOAT,
  "tfr" FLOAT,
  "tfr40" FLOAT,
  "b" FLOAT
);

Human Fertility Database

@owid.hfd.owid_period_2

278.12 kB
11,297 rows
14 columns

CREATE TABLE owid_period_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "birth_order" VARCHAR,
  "adjtfr" FLOAT,
  "cbr" FLOAT,
  "mab" FLOAT,
  "mab40" FLOAT,
  "patfr" FLOAT,
  "tmab" FLOAT,
  "sdmab" FLOAT,
  "sdmab40" FLOAT,
  "tfr" FLOAT,
  "tfr40" FLOAT,
  "b" FLOAT
);

Human Fertility Database

@owid.hfd.owid_period_ages_1

121.98 kB
65,580 rows
5 columns

CREATE TABLE owid_period_ages_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "age" VARCHAR,
  "birth_order" VARCHAR,
  "asfr_period" FLOAT
);

Human Fertility Database

@owid.hfd.owid_period_ages_2

124.97 kB
67,782 rows
5 columns

CREATE TABLE owid_period_ages_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "age" VARCHAR,
  "birth_order" VARCHAR,
  "asfr_period" FLOAT
);

Human Fertility Database

@owid.hfd.owid_period_ages_years_1

84.68 kB
23,012 rows
4 columns

CREATE TABLE owid_period_ages_years_1 (
  "country" VARCHAR,
  "age" INTEGER,
  "year_as_dimension" INTEGER,
  "asfr_period" FLOAT
);

Human Fertility Database

@owid.hfd.owid_period_ages_years_2

85.26 kB
23,320 rows
4 columns

CREATE TABLE owid_period_ages_years_2 (
  "country" VARCHAR,
  "age" INTEGER,
  "year_as_dimension" INTEGER,
  "asfr_period" FLOAT
);