Development of a Harmonized Community-Based NCD Surveillance Dataset for Public Health Research
##plugins.themes.academic_pro.article.main##
Abstract
Community-based noncommunicable disease (NCD) surveillance data are increasingly utilized as secondary sources in public health research. Variations in dataset structure, variable nomenclature, data types, and coding systems across surveillance periods frequently impede data integration and subsequent analyses. This study developed a harmonized community-based NCD surveillance dataset using secondary data collected at UPTD Puskesmas Johar Baru, Jakarta, Indonesia, from 2019 to 2021. The methodology included dataset inventory, variable mapping, standardization of variable names, data types, and coding systems, data cleaning, derivation of analytical variables, and dataset integration using Python with the Pandas and NumPy libraries. Three surveillance datasets, comprising 196,949 observations, were successfully integrated. The harmonization process identified 158 unique variables, which were standardized into 17 analytical variables while preserving all observations. The resulting dataset offers a consistent and interoperable structure suitable for epidemiological studies, health program evaluation, and other public health research. Furthermore, the harmonization framework established in this study may serve as a practical reference for standardizing multi-period health surveillance datasets and promoting the broader use of secondary health data in future public health research
##plugins.themes.academic_pro.article.details##
References
- Abbasizanjani, H., Torabi, F., Bedston, S., Bolton, T., Davies, G., Denaxas, S., Griffiths, R., Herbert, L., Hollings, S., Keene, S., Khunti, K., Lowthian, E., Lyons, J., Mizani, M. A., Nolan, J., Sudlow, C., Walker, V., Whiteley, W., Wood, A., … Consortium, C. C. (2023). Harmonising electronic health records for reproducible research : challenges , solutions and recommendations from a UK ‑ wide COVID ‑ 19 research collaboration. BMC Medical Informatics and Decision Making, 0, 1–15. https://doi.org/10.1186/s12911-022-02093-0
- Akselrod, S. (2023). Engaging with the Private Sector for Noncommunicable Disease Prevention and Control : Is it Possible to Create “ Shared Value ?” Annals of Global Health, 89(1), 1–13. https://doi.org/10.5334/aogh.4136
- Deflaux N, Selvaraj, M. S., Condon, H. R., Mayo, K., Haidermota, S., Basford, M. A., Lunt, C., Philippakis, A. A., Roden, D. M., Denny, J. C., Musick, A., Collins, R., Allen, N., & Ef, M. (2023). Demonstrating paths for unlocking the value of cloud genomics through cross cohort analysis. Nature Communications, 1–10. https://doi.org/10.1038/s41467-023-41185-x
- Djalalinia, S., Moghaddam, S. S., Sheidaei, A., & Rezaei, N. (2020). Patterns of Obesity and Overweight in the Iranian Population : Findings of STEPs 2016. Front. Endocrinol, 11(February). https://doi.org/10.3389/fendo.2020.00042
- Evyana, D., Novianto, E., Budianti, W. K., Krisanti, R. I. A., Wisnu, W., Wibawanti, R., Nilasari, H., Legiawati, L., Hapsari, S. A. R., & Mutmainnah, E. (2024). Association between the severity of hard-to-treat psoriasis and the prevalence of metabolic syndrome: A hospital-based cross-sectional study in Jakarta, Indonesia. PLOS ONE, 19(4), e0302391. https://doi.org/10.1371/journal.pone.0302391
- Hosseinzadeh, E., Afkanpour, M., & Momeni, M. (2025). Data quality assessment in healthcare , dimensions , methods and tools : a systematic review. BMC Medical Informatics and Decision Making.
- Kahn, M. G., Callahan, T. J., Barnard, J., Bauck, A. E., & Northwest, K. P. (2016). A Harmonized Data Quality Assessment Terminology and Framework for the Secondary Use of Electronic Health Record Data A Harmonized Data Quality Assessment Terminology and Framework for. EDM Forum Community EGEMs, 4, 9–11.
- Näher, A., Vorisek, C. N., Klopfenstein, S. A. I., Lehne, M., Thun, S., Alsalamah, S., Pujari, S., Heider, D., Ahrens, W., Pigeot, I., Marckmann, G., Jenny, M. A., Renard, B. Y., Kleist, M. Von, Wieler, L. H., & Balzer, F. (2023). Health Policy Secondary data for global health digitalisation. The Lancet Digital Health, 5(2), e93–e101. https://doi.org/10.1016/S2589-7500(22)00195-9
- Riley, L., Guthold, R., Cowan, M., Savin, S., Bhatti, L., Armstrong, T., & Bonita, R. (2016). The World Health Organization STEPwise Approach to Noncommunicable Disease Risk-Factor Surveillance : Methods , Challenges , and Opportunities. AJPH METHODS, 106(1), 74–78. https://doi.org/10.2105/AJPH.2015.302962
- WHO. (2025). Noncommunicable diseases (World Health Organization; (ed.)). World Health Organization;
- Williams, E., Kienast, M., Medawar, E., Reinelt, J., Merola, A., Balzer, F., Beimes, J., B, P. Von, Chromik, J., & Arnrich, B. (2023). A Standardized Clinical Data Harmonization Pipeline for Scalable AI Application Deployment ( FHIR-DHP ): Validation and Usability Study Corresponding Author : JMIR MEDICAL INFORMATICS, 11, 1–11. https://doi.org/10.2196/43847
- Xiong, S., Cai, C., Jiang, W., Ye, P., Ma, Y., Liu, H., Li, B., Zhang, X., & Wei, T. (2023). Review Primary health care system responses to non- communicable disease prevention and control : a scoping review of national policies in Mainland China since the 2009 health reform. The Lancet Regional Health - Western Pacific, 31, 100390. https://doi.org/10.1016/j.lanwpc.2022.100390
- Yang, N., Del, J., Walsh, S., Sch, C., Selby, I., Howard, K., Owen, J., Neville, J., Guiot, J., Ernst, B., Pastor, A., Alberich-bayarri, A., Menzel, M. I., Walsh, S., Vos, W., Flerin, N., Charbonnier, J., Rikxoort, E. Van, Chatterjee, A., … Uk, N. I. (2022). Data harmonisation for information fusion in digital healthcare : A state-of-the-art systematic review , meta-analysis and future research directions. Information Fusion, 82(December 2021), 99–122. https://doi.org/10.1016/j.inffus.2022.01.001