TFR and ASFR by State
Data as of 2023Total fertility rate (TFR) and age-specific fertility rates (ASFR) by state.
0 views·0 downloads
How is this data produced?
An age-specific fertility rate (ASFR) is the average number of births per 1,000 women in a specific age group. The ASFRs shown in this dataset are computed from administrative records of births registered with JPN (which record the age of the mother), as well as population data from DOSM as the denominator.
The total fertility rate (TFR) is the average number of children born to a woman who goes through her child-bearing years experiencing the ASFR of each age group. It is computed by:
- Summing the ASFRs of all age groups, then
- Multiplying the number by 5 to account for the size of each age group, and finally
- Dividing by 1000 (to convert the figure from per 1000 women to per woman.
What caveats I should bear in mind when using this data?
ASFR values are based on the actual number of live births per 1000 women in each 5-year age group. However, when interpreting TFR values, it is important to note that the TFR is based on a hypothetical woman who goes through her child-bearing years experiencing the ASFR of each age group. This is not equivalent to the actual average number of children born to currently-living female citizens aged 15-49, as this number would be a reflection of past rather than current ASFR values.
Publication(s) using this data
OpenDOSM features a dashboard on Population & Vital Statistics where you can explore this data in a more interactive manner!
Metadata
Dataset description
Total fertility rate (TFR) and age-specific fertility rates (ASFR) by state.
Variable definitions
- State
- Date
- Age Group
- Fertility Rate
Name in Dataset | Variable | Definition |
|---|---|---|
state (Categorical) | State | One of 16 states |
date (Date) | Date | The year of the recorded fertility rate in YYYY-MM-DD format, with MM-DD set to 01-01 as the data is at annual frequency. |
age_group (Categorical) | Age Group | 5-year age group for fertility rates (15-19, 20-24,...,45-49), or the Total Fertility Rate ('tfr'). |
fertility_rate (Float) | Fertility Rate | Fertility rate for the specific age group (ASFRs) or the total fertility rate (TFR). ASFR values are the number of live births per 1000 women in the age group, whereas TFR values are the average number of children born to a woman who goes through her child-bearing years experiencing the ASFR of each age group. |
Last updated:
17 Oct 2024, 12:00
Next update:
01 Nov 2025, 12:00
Data source(s)
- Department of Statistics Malaysia
URLs to dataset
License
This data is made open under the Creative Commons Attribution 4.0 International License (CC BY 4.0). A copy of the license is available Here.
Download
Data
Full Dataset (CSV)
Recommended for individuals seeking an Excel-friendly format.
0
Full Dataset (Parquet)
Recommended for data scientists seeking to work with data via code.
0
Code
Connect directly to the data with Python.
# If not already installed, do: pip install pandas fastparquet
import pandas as pd
URL_DATA = 'https://storage.dosm.gov.my/demography/fertility_state.parquet'
df = pd.read_parquet(URL_DATA)
if 'date' in df.columns: df['date'] = pd.to_datetime(df['date'])
print(df)Sample OpenAPI query
The following code is an example of how to make an API query to retrieve the data catalogue mentioned above. You can use different programming languages by switching the code accordingly. For a complete guide on possible query parameters and syntax, please refer to the official Open API Documentation.
import requests
import pprint
url = "https://api.data.gov.my/data-catalogue?id=fertility_state&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data