IRO Journals
Journal of Electronics and Informatics

A Web-Based Electronic Health Record Framework for ASHA Workers Using Python Flask and MySQL

Open Access
Published: 03 November, 2026
Pages: 404-421
  • Vaishnavi Kashinath Bharamshetti , Vaishnavi Kashinath Bharamshetti
    Professor, Department of Computer Applications, SVERI’s College of Engineering, Pandharpur, India
    Professor, Department of Computer Applications, SVERI’s College of Engineering, Pandharpur, India
  • Kajal Balaso Chorkar Kajal Balaso Chorkar
    Assistant Professor, Department of Computer Applications, SVERI’s College of Engineering, Pandharpur, India
    Assistant Professor, Department of Computer Applications, SVERI’s College of Engineering, Pandharpur, India
view PDF
view PDF

How to Cite

Bharamshetti, Vaishnavi Kashinath, and Kajal Balaso Chorkar. 2026. “A Web-Based Electronic Health Record Framework for ASHA Workers Using Python Flask and MySQL”. Journal of Electronics and Informatics 8 (4): 404-21. https://doi.org/10.36548/jei.2026.4.007.
ACM ACS APA ABNT Chicago Harvard IEEE MLA Turabian Vancouver AMA

Download Citation

Endnote/Zotero/Mendeley (RIS) BibTeX

Keywords

Electronic Health Record
ASHA Workers
Python Flask
MySQL
Healthcare Information Management
Role-Based Access Control
Digital Health

Abstract

Delivery of healthcare services in rural areas depends on frontline health workers who maintain, update and communicate patient records. Manual health record maintenance limit the efficient retrieval, updating and monitoring of patient related information from the healthcare perspective. This research work proposes a web based Electronic Health Record (EHR) framework that can aid Accredited Social Health Activist (ASHA) workers in managing community healthcare information. The framework utilizes Python Flask as the application layer and MySQL as the relational database. A patient centric approach is adopted in the framework wherein patient record is the primary record including the healthcare visit record, vaccine record, health status record and medical report are recorded as events. Role-based access control is used for patient, ASHA worker, supervisor, zonal officer, district officer and administrator. The implementation was evaluated using operational parameters such as record entry time, entry error rate, report generation time, data completeness, report-access time, data retrieval time, system availability, and record access accuracy. The reported outcomes reveal record entry time as 2 minutes per record, entry error rate at 0.5%, report generation time as up to 5 seconds, data completeness of 99%, and system availability of 99.8%.

References

  1. Ganesh, S. S. (2026). Supermarket Management System Using Python Flask and MySQL. International Journal for Research in Applied Science and Engineering Technology, 14(3), 1547–1551. https://doi.org/10.22214/ijraset.2026.78214
  2. Revathy, S. P., Srimathi, R., & Yuvapriya, H. (2024). Document Similarity Analysis and Template Matching in Health Insurance Using Python Flask. Journal of Information Technology and Digital World, 6(2), 179–190. https://doi.org/10.36548/jitdw.2024.2.006
  3. Sreehari, M. “Exploring the Awareness Level of ASHA Workers regarding Infant Feeding Practices.” The Indian Journal of Social Work 81, no. 1 (2020): 109-118.
  4. Shashank, K. J. “A Study to Evaluate the Knowledge of ASHA Workers on Antenatal and Postnatal Care in Bijapur District.” (2015).
  5. Aakash, B., and A. Srilakshmi. “MAGE: An Efficient Deployment of Python Flask Web Application to App Engine Flexible Using Google Cloud Platform.” In Inventive Communication and Computational Technologies: Proceedings of ICICCT 2020, Singapore: Springer Singapore, 2020, 59-68.
  6. Eppakayala, Sathvik, and Shiva Kumar Goud Ankula. “Automated Email Spam Classifier Application Using Python Flask, Machine Learning and Selenium Tool.” (2025).
  7. Hariprasad, Roopa, Manikandan Srinivasan, Priyanka Ravi, Harki Tamang, Arpana Sharma, Sangeeta Pradhan, and Kavitha Dhanasekaran. “A Qualitative Study on ASHA Workers’ Perspective on HPV Self-Sampling in Sikkim India.” Scientific Reports 15, no. 1 (2025): 15985.
  8. Bansal, Stuti, Krishnamachari Srinivasan, and Maria Ekstrand. “Perceptions of ASHA Workers in the HOPE Collaborative Care Mental Health Intervention in Rural South India: A Qualitative Analysis.” BMJ open 11, no. 11 (2021): e047365.
  9. Pai, Manohara MM, Raghavendra Ganiga, Radhika M. Pai, and Rajesh Kumar Sinha. “Standard Electronic Health Record (EHR) Framework for Indian Healthcare System.” Health Services and Outcomes Research Methodology 21, no. 3 (2021): 339-362.
  10. State/UT-wise Details of Budget Approved and Expenditure for Accredited Social Health Activist (ASHA) Worker Remuneration under National Health Mission from 2018-19 to 2024-25. [Available]: https://www.data.gov.in/resource/stateut-wise-details-budget-approved-and-expenditure-accredited-social-health-activist.