Dataset: Human Fertility Database

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

96.95 KB
8212 rows
12 columns


CREATE TABLE owid_cohort (
  "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

181.02 KB
64480 rows
6 columns


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

Human Fertility Database

@owid.hfd.owid_cohort_ages_years

121.33 KB
22765 rows
5 columns


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

Human Fertility Database

@owid.hfd.owid_cohort_share_women

18.11 KB
2745 rows
4 columns


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

Human Fertility Database

@owid.hfd.owid_period

264.1 KB
10930 rows
14 columns


CREATE TABLE owid_period (
  "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

119.12 KB
65580 rows
5 columns


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

Human Fertility Database

@owid.hfd.owid_period_ages_years

82.7 KB
23012 rows
4 columns


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