How much the Indonesian Citizens Actually Earned each Year?

Due to the pandemic that has occurred recently, I found a lot of news highlighted its impact on economic sector. Some people’s incomes have decreased. Some people even lose their jobs so they don’t get any income at all. From this occurrence, I became curious about how much the Indonesian population actually earned before this pandemic. I found some interesting publication from Badan Pusat Statistic (BPS) here and Bank Indonesia Metadata here about Gross Regional Domestic Product of Regencies/Municipalities in Indonesia 2014–2018.

Image for post
Image for post
Mapping Distribution Per Capita GRDP Regencies/Municipalities in Indonesia

At first, I want to say sorry because this paragraph will probably be an awkward-stiff-confusing explanation. (I will try to not do the same in another paragraph 😮). From Bank Indonesia Metadata, Gross Regional Domestic Product (GRDP) is an important indicator for knowing the economic development in an area in a certain period, either at current prices or at constant prices. GRDP at Current Prices describe added value of goods and services that calculated using prices in the current period. While GRDP at Constant Prices describe the same variables but calculated using the prevailing prices in a certain year as the base year. If you are interested to know the more detail, you can read on BI metadata directly or in Subdit Rujukan Statistik of Badan Pusat Statistic here.

GRDP at Current Prices is used for knowing the distribution economy of an area. I will use this data, since it’s represent the total income of each region from its population. This BPS publication makes analysis easier cause it provides Per Capita GRDP at Current Prices too. This per capita data indicates the value of GRDP per head or per one resident. Unfortunately, I only found data for 2014–2018, and only 2014–2016 has fix value. So, to avoid bias I will use 2014–2016 data only. I don’t really have deep understanding, but I think it will be better if we use Regional Income directly to represent income per head of population. The things is I can’t find it anywhere. Okay let’s back then.

In this article I want to find out about a few things and discuss its results to get some insights:

  • Trend of Per Capita GRDP (at Current Prices) in each Regency/Municipality

Note: I was doing this project with Tableau Public. Since it haven’t support to share Tableau dashboard to medium, so I will give the full Tableau Public dashboard in the end of this post and give a little snippet on each analysis.

1. Data Cleaning

The dataset used in this project is consist of two files:

  • Per Capita GRDP of Regencies/Municipality in Indonesia.
    As I mentioned before, this data is taken from BPS publication. Since it was in pdf format, I transform it to xls form at first.

Both of them will be combined to build map visualization. The same feature of these two files are Regency/Municipality name. It makes me should make sure they both have the same format, to simplify the combining process. In the GADM file, Regency/Municipality name is separated from its type, so I did the same to GRDP file from BPS since it will be more complicated in the next step if we do otherwise.

Example of region with same Regency and Municipality name
Example of region with same Regency and Municipality name
Example of region with same Regency and Municipality name

After that, I do some sorting to detect all region with same Regency and Municipality name like Tangerang. And then, I added “Kota” word in every region city with the same regency name.

Finally, I joined these two files with Tableau Public since it’s support shapefile format and can be used for doing some visualization including mapping distribution.

2. Analysis

2.1 Trend of Per Capita GRDP (at Current Prices) in each Regency/Municipality

Note: Since the available latest data is 2016 data, so I only include 2014–2016 data in calculating average growth and show the 2016 data as the latest data.

Here some interesting information I get:

  • Average growth of Per Capita GRDP (at Current Prices) of all Regency/Municipality in Indonesia is about 8,28% (positive).

2.2 Regencies/Municipalities segmentation based on its latest GRDP (2016)

Next, I segmented these Regencies/Municipalities based on Average Growth Rate and Total of Per Capita GRDP (at Current Prices). After several manual trial process, I decide to divide them into 6 sections:

  • Low Income but High Growth Rate
    This segment has Latest Per Capita GRDP (at Current Prices) IDR 29,458,000 with 9.16% average growth rate.
Mapping Distribution of each Segment
List Region of each Segment

Evidently, region with Per Capita GRDP (at Current Prices) above the average tend to have low average growth. (Of course, it’s excluding Mining Area and Central Jakarta!) It may be because the basis value in calculating growth is using previous year as a comparison, which value is quite high.

[Updated]: I have added Province multiple drop down filter in this Segment Explanation Dashboard too.

3. Summary

As a summary, I will answer the question in the title section. How much the Indonesian Citizens Actually Earned each Year? It can be represented by Per Capita Growth Regional Domestic Product (at Current Price) data. In general, each individual of Regency/Municipality in Indonesia earn IDR 45,792,000 per year with 8.28 % average growth rate. But, with segmentation process it can be answered more specific where each segment have different average income and average growth. This can be useful for doing policy analysis, market analysis, etc either for individual, government or business party where each segment might need different treatment.

Note:
The full dashboard can be accessed here.

Reference:
[1] Sub-Direktorat Konsolidasi Neraca Produksi Regional. 2019. Produk Domestik Regional Bruto Kabupaten/Kota di Indonesia 2014–2018. Jakarta: Badan Pusat Statistik, 147–180.
[2] Bank Indonesia. Metadata Sekda: Produk Domestik Regional Bruto. Accessed October 11, 2020.
[3] Subdit Rujukan Statistik, Badan Pusat Statistik. Metadata Indikator: PDB/PDRB per Kapita. Accessed October 11, 2020.
[4] Subdit Rujukan Statistik, Badan Pusat Statistik. Produk Domestik Regional Bruto (Lapangan Usaha). Accessed October 11, 2020.
[5] Seksi Neraca Wilayah dan Analisis Statistik. 2017. Produk Domestik Regional Bruto Menurut Lapangan Usaha Kabupaten Sumbawa Barat 2012–2016. BPS Kabupaten Sumbawa Barat, 61–67.
[6] Badan Pusat Statistik Kabupaten Banggai. PDRB Menurut Lapangan Usaha (Juta Rupiah), 2015–2019. Accessed October 11, 2020.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store