← Back to All Articles

Mapping Primary Healthcare in Padang: Building an Open Dataset BPJS on Kaggle

📅 Nov 13, 2026  |  ✍️ icaluwu
Mapping Primary Healthcare in Padang: Building an Open Dataset BPJS on Kaggle
Access to reliable healthcare data is essential for public health research, geospatial mapping, and civic technology applications. To support researchers and developers working on Indonesian healthcare accessibility, I compiled and published an open-source Dataset BPJS on Kaggle titled Klinik dan Bidan BPJS Kesehatan Kota Padang.This dataset provides a structured, cross-validated directory of First-Level Health Facilities (Fasilitas Kesehatan Tingkat Pertama or FKTP) partnered with BPJS Kesehatan across Padang City, West Sumatra. Rather than relying on fragmented directories, the repository consolidates primary clinics, community health centers (Puskesmas), and institutional insights into how network midwives (bidan jejaring) operate under Indonesia's national health insurance (JKN-KIS) framework.

Why Build a Structured Dataset BPJS for Padang City?

Padang City covers a land area of 694.96 km² across 11 sub-districts (kecamatan) and 104 urban villages (kelurahan). As of December 2024, more than 736,835 residents in the city were registered as active JKN participants. Consequently, analyzing how primary care facilities are distributed across sub-districts—from Koto Tangah and Kuranji to Bungus Teluk Kabung—is critical for evaluating service equity.While developing health-focused digital solutions showcased in my software engineering portfolio, I noticed that clean, machine-readable CSV datasets mapping local FKTP locations by sub-district were rarely available in one place. Creating this Dataset BPJS bridges that gap for data analysts, urban planners, and civic-tech builders.

Inside the Dataset BPJS: File Structure & Schema

Released under the permissive CC0: Public Domain license, the dataset is organized into three relational CSV files captured as a verified snapshot as of July 2025:
  • klinik_bpjs_padang.csv: Contains 37 verified BPJS-partnered clinics in Padang City, covering Klinik Pratama, Klinik TNI (military), and Klinik POLRI (police). Key columns include nama_faskes, jenis_faskes, alamat, kecamatan, kelurahan, and status_bpjs.
  • puskesmas_bpjs_padang.csv: Maps all 24 public Puskesmas distributed across Padang's 11 sub-districts (Bungus Teluk Kabung, Koto Tangah, Kuranji, Lubuk Begalung, Lubuk Kilangan, Nanggalo, Padang Barat, Padang Selatan, Padang Timur, Padang Utara, and Pauh).
  • ringkasan_faskes_bpjs_padang.csv: Aggregates statistical counts and percentages for all 290 FKTP units operating under the BPJS Kesehatan Padang Branch Office service area.

Statistical Breakdown of 290 Partnered FKTP Units

To give researchers immediate quantitative context, the summary table in the Dataset BPJS categorizes all 290 partnered primary care units across the Padang Branch Office jurisdiction:
Facility Type (Jenis Faskes)Unit CountPercentage
Puskesmas (Community Health Centers)12543.1%
Klinik Pratama (Primary Clinics)7024.1%
Dokter Praktik Perorangan (General Practitioners)3813.1%
Praktik Dokter Gigi (Dental Practices)258.6%
RS Kelas D Pratama (Class D Primary Hospitals)144.8%
Klinik TNI (Military Clinics)103.4%
Klinik POLRI (Police Clinics)82.8%
Total Partnered FKTP290100.0%

Understanding the "Bidan Jejaring" System

A common misconception when querying Indonesian healthcare directories is expecting independent midwives to appear as standalone FKTP entities. In practice, most midwives in Padang City partner with BPJS Kesehatan as bidan jejaring (network midwives) affiliated with a parent FKTP—typically a local Puskesmas or Klinik Pratama.
Data Availability Note: Individual network midwife rosters are not publicly exposed in open government portals. JKN participants looking for an affiliated midwife under their registered clinic can verify active networks through the Mobile JKN app, by calling the BPJS Kesehatan Care Center at 165, or by inquiring directly at their primary clinic.

Data Collection Methodology & Cross-Validation

As part of my broader work in web engineering and automated data extraction, I built this dataset through a multi-stage scraping and manual verification pipeline. Records were gathered and cross-checked against official public health registries, including: Furthermore, every record underwent cross-source validation to minimize duplicate entries and standardize sub-district naming conventions.

Limitations & Potential Use Cases

When utilizing this Dataset BPJS for academic research or software development, keep a few practical boundaries in mind. First, the dataset represents a July 2025 snapshot, meaning newly signed or terminated clinic contracts may require re-verification via Mobile JKN. Second, while the clinic and Puskesmas CSV files focus strictly on Padang City's 11 sub-districts, the 290-unit summary table reflects the broader operational jurisdiction of the BPJS Kesehatan Padang Branch Office.Despite these constraints, the dataset is ready for immediate use in spatial accessibility modeling, healthcare facility recommender systems, and public health dashboards. You can download the full CSV files, inspect the column metadata, or contribute updates directly on the official Kaggle dataset page.