Implementation of Big Data Information System Using Open-Source Metabase for Civil Registration and Vital Statistics Data Visualization in Surabaya

Rizqi Putri Nourma Budiarti - Universitas Nahdlatul Ulama Surabaya, Surabaya, 60237, Indonesia
Sritrusta Sukaridhoto - Politeknik Elektronika Negeri Surabaya, Surabaya, 60111, Indonesia
Ubaidillah Zuhdi - Universitas Nahdlatul Ulama Surabaya, Surabaya, 60237, Indonesia
Alfandino Rasyid - Politeknik Elektronika Negeri Surabaya, Surabaya, 60111, Indonesia
Agus Imam Sonhaji - Institut Teknologi Sepuluh Nopember, Surabaya, 60111, Indonesia

Citation Format:



Civil registration involves the mandatory and continuous documentation of important life events of a country's population under local legal requirements. In many countries, these documents are required to access government services such as education, healthcare, social services, formal employment, insurance benefits, and inheritance rights. Indonesia should prioritize building a comprehensive Civil Registration and Vital Statistics (CRVS) using a big data information system to ensure every individual has a legal identity, can access government services, and collect accurate and reliable statistics on vital events through geospatial maps. Surabaya, a city in Indonesia, still needs a comprehensive Civil Registration and Vital Statistics (CRVS) system. We produce many informative visualizations from the query and modeling processes in Metabase. Based on the PIECES framework, this application's importance level is 4.56 or 91.25%, meaning the application is important, and the satisfaction level is 4.29 or 85.76%, meaning the application is satisfied for the respondents. This research provides a brief overview of how Metabase works and how it can be used to generate visualizations of job-type data. It demonstrates the ease with which visualizations can be changed and customized. It had a good affordability point, making its implementation easier and more beneficial. It also emphasizes the importance of having a powerful tool like Metabase for data analysis and decision-making, especially for the dispendukcapil as a civil registration agency.


CRVS; metabase; geospatial maps; dispendukcapil; big data information system

Full Text:



S. Mills, J. K. Lee, and B. M. Rassekh, "An introduction to the civil registration and vital statistics systems with applications in low- and middle-income countries," J Health Popul Nutr, vol. 38, no. S1, p. 23, Oct. 2019, doi: 10.1186/s41043-019-0177-1.

M. Mena, A. Corral, L. Iribarne, and J. Criado, "A Progressive Web Application Based on Microservices Combining Geospatial Data and the Internet of Things," IEEE Access, vol. 7, pp. 104577–104590, 2019, doi: 10.1109/ACCESS.2019.2932196.

R. Rizki, "Multidimensional Poverty Index (MPI) in Agricultural Household in Indonesia," no. 95114, 2019.

S. L. Lai and N. P. Tey, "Deficiency in civil registration and vital statistics reporting in remote areas: the case of Sabah, Malaysia," Genus, vol. 77, no. 1, p. 22, Dec. 2021, doi: 10.1186/s41118-021-00132-8.

H. C. Castanheira and J. H. C. Monteiro da Silva, "Examining sex differences in the completeness of Peruvian CRVS data and adult mortality estimates," Genus, vol. 78, no. 1, p. 3, Dec. 2022, doi: 10.1186/s41118-021-00151-5.

R. Silva, "Population perspectives and demographic methods to strengthen CRVS systems: introduction," Genus, vol. 78, no. 1, p. 8, Dec. 2022, doi: 10.1186/s41118-022-00156-8.

J. Espey and H. Dahmm, "Innovations in Disease Surveillance and Monitoring," in Handbook of Global Health, Cham: Springer International Publishing, 2021, pp. 1–21. doi: 10.1007/978-3-030-05325-3_16-1.

A. Fall, B. Masquelier, K. Niang, S. Ndiaye, and A. Ndonky, "Motivations and barriers to death registration in Dakar, Senegal," Genus, vol. 77, no. 1, p. 21, Dec. 2021, doi: 10.1186/s41118-021-00133-7.

A. Chiemezie et al., "Challenges to vital registration in Nigeria," International Journal of Sociology and Anthropology, vol. 13, no. 1, pp. 1–8, 2021, doi: 10.5897/ijsa2020.0846.

A. S. da Silva, M. T. S. Barbosa, L. de Souza Velasque, D. da Silveira Barroso Alves, and M. N. Magalhães, "The COVID-19 epidemic in Brazil: how statistics education may contribute to unravel the reality behind the charts," Educational Studies in Mathematics, vol. 108, no. 1–2, pp. 269–289, 2021, doi: 10.1007/s10649-021-10112-6.

U. Kitur, T. Adair, and A. D. Lopez, "Estimating Adult Mortality in Papua New Guinea, 2011," Popul Health Metr, vol. 17, no. 1, pp. 1–14, 2019, doi: 10.1186/s12963-019-0184-x.

H. Bixby et al., "Quantifying within-city inequalities in child mortality across neighbourhoods in Accra, Ghana: a Bayesian spatial analysis," BMJ Open, vol. 12, no. 1, p. e054030, Jan. 2022, doi: 10.1136/bmjopen-2021-054030.

N. Noori et al., "Patterns of child mortality in rural area of Burkina Faso: evidence from the Nanoro health and demographic surveillance system (HDSS)," BMC Public Health, vol. 21, no. 1, p. 1425, Dec. 2021, doi: 10.1186/s12889-021-11483-4.

R. Kashyap, "Has demography witnessed a data revolution? Promises and pitfalls of a changing data ecosystem," Popul Stud (NY), vol. 75, no. S1, pp. 47–75, 2021, doi: 10.1080/00324728.2021.1969031.

C. E. Brolan, "Human Rights Practitioners Cannot Be Left Behind: Engaging in Civil Registration and Vital Statistics (CRVS) Systems Thinking for Country Implementation of the Sustainable Development Goal Agenda," J Hum Rights Pract, vol. 11, no. 1, pp. 22–51, Feb. 2019, doi: 10.1093/jhuman/huz009.

A. Onagoruwa and Q. Wodon, "Correlates of birth registrations in East and Southern Africa and implications for civil registration and vital statistics systems," Public Health, vol. 195, pp. 70–75, Jun. 2021, doi: 10.1016/j.puhe.2020.02.016.

A. Bhatia, R. Kim, and S. V. Subramanian, "Birth registration in India: Are wealth inequities decreasing?," SSM Popul Health, vol. 13, p. 100728, Mar. 2021, doi: 10.1016/j.ssmph.2021.100728.

V. Ramachandran, T. Shoberg, S. Long, S. Corns, and H. Carlo, "Identifying Geographical Interdependency in Critical Infrastructure Systems Using Open Source Geospatial Data in Order to Model Restoration Strategies in the Aftermath of a Large-Scale Disaster," 2015.

N. I. Maduekwe, O. O. Banjo, and M. O. Sangodapo, "Data for the Sustainable Development Goals: Metrics for Evaluating Civil Registration and Vital Statistics Systems Data Relevance and Production Capacity, Illustrations with Nigeria," Soc Indic Res, vol. 140, no. 1, pp. 101–124, 2018, doi: 10.1007/s11205-017-1760-8.

L. N. U. Arif, A. R. Barakbah, A. Sudarsono, and R. Edelani, “Big Data Environment for Realtime Earthquake Data Acquisition and Visualization,” JOIV : International Journal on Informatics Visualization, vol. 3, no. 4, Nov. 2019, doi: 10.30630/joiv.3.4.320.

Y.-W. Zhou, Z.-Z. Hu, J.-R. Lin, and J.-P. Zhang, "A Review on 3D Spatial Data Analytics for Building Information Models," Archives of Computational Methods in Engineering, vol. 27, no. 5, pp. 1449–1463, Nov. 2020, doi: 10.1007/s11831-019-09356-6.

E. A. Baptista and B. L. Queiroz, "Spatial analysis of cardiovascular mortality and associated factors around the world," BMC Public Health, vol. 22, no. 1, p. 1556, Aug. 2022, doi: 10.1186/s12889-022-13955-7.

L. Sempé, P. Lloyd-Sherlock, R. Martínez, S. Ebrahim, M. McKee, and E. Acosta, "Estimation of all-cause excess mortality by age-specific mortality patterns for countries with incomplete vital statistics: a population-based study of the case of Peru during the first wave of the COVID-19 pandemic," The Lancet Regional Health - Americas, vol. 2, p. 100039, Oct. 2021, doi: 10.1016/j.lana.2021.100039.

B. Huang and J. Wang, "Big spatial data for urban and environmental sustainability," Geo-Spatial Information Science, vol. 23, no. 2, pp. 125–140, 2020, doi: 10.1080/10095020.2020.1754138.

Y. Yokobori et al., "Rapid assessment of the civil registration and vital statistics performance of health facilities in the five districts of Zambia: A cross-sectional study," Heliyon, vol. 7, no. 11, p. e08367, Nov. 2021, doi: 10.1016/j.heliyon.2021.e08367.

B. Huang and J. Wang, "Big spatial data for urban and environmental sustainability," Geo-spatial Information Science, vol. 23, no. 2, pp. 125–140, Apr. 2020, doi: 10.1080/10095020.2020.1754138.

C. AbouZahr, G. Mathenge, T. Brøndsted Sejersen, and S. B. Macfarlane, "Civil Registration and Vital Statistics: A Unique Source of Data for Policy," in The Palgrave Handbook of Global Health Data Methods for Policy and Practice, London: Palgrave Macmillan UK, 2019, pp. 125–144. doi: 10.1057/978-1-137-54984-6_7.

A. B. Suthar et al., "Evaluation of approaches to strengthen civil registration and vital statistics systems: A systematic review and synthesis of policies in 25 countries," PLoS Med, vol. 16, no. 9, p. e1002929, Sep. 2019, doi: 10.1371/journal.pmed.1002929.

T. M. Rane, T. G. Mahanta, S. Islam, P. P. Gogoi, and B. Gogoi, "Civil registration system (CRS) for birth and death registration in Assam – A rapid assessment," Clin Epidemiol Glob Health, vol. 8, no. 1, pp. 117–122, Mar. 2020, doi: 10.1016/j.cegh.2019.05.006.

S. A. Ajagbe, M. A. Oladipupo, and B. Emmanuel, "International Journal of Information Security , Privacy and Digital Forensics CRIME BELT MONITORING VIA DATA VISUALIZATION : A CASE STUDY OF FOLIUM," vol. 4, no. May 2022, pp. 35–45, 2020.

Atta-Ur-Rahman et al., “Geo-Spatial Disease Clustering for Public Health Decision Making,” Informatica (Slovenia), vol. 46, no. 6, pp. 21–31, 2022, doi: 10.31449/inf.v46i6.3827.

D. Petrova-Antonova, S. Baychev, I. Pavlova, and G. Pavlov, "Air Quality Visual Analytics with Kibana," 2020 5th International Conference on Smart and Sustainable Technologies, SpliTech 2020, no. 2, pp. 3–8, 2020, doi: 10.23919/SpliTech49282.2020.9243708.