AMPATH launched AMRS to make patients records easier to find. They used the Elastic Stack to develop visualisations for their users.

The <a href="https://www.ampathkenya.org/">Academic Model Providing Access to Healthcare</a> (AMPATH) was founded in 2001 to combat one of the world’s worst epidemics: HIV. AMPATH is a partnership between the Kenyan Ministry of Health, Moi University in Eldoret, Kenya, and a consortium of American universities.
<h2>The challenge: Paper charts and paper records
</h2>In most parts of the world, reliable patient records are hard to find. Access to patient data in clinics is a critical part of healthcare. However, paper records are hard to read, get lost or damaged, and are inefficient to store and retrieve. Imagine having to pull hundreds of charts daily from this stack of records:
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blte22b81766ce71874/5d5da3dcd47d0742ac772761/ampath-medical-records-blog.jpg" data-sys-asset-uid="blte22b81766ce71874" alt="Manual paper filing of records " style="display: block; margin: auto;">
Another problem with paper records is that they make reporting difficult. Separate books, called registers, are used to track patient data for aggregate government reporting. Sometimes several registers must be filled out to collect the information from a single visit.
A register is essentially a spreadsheet. Rows and columns track patient metrics. The results from each page are tallied and transferred to other registers. This is a slow, error-prone, time-consuming, unreliable process that leads to delayed reports.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt91fccdf3de93a257/5d5da2ddef04464325fb845c/ampath-registers-blog.jpg" data-sys-asset-uid="blt91fccdf3de93a257" alt="Logging records in manual registers" style="display: block; margin: auto;">
<h2>Making the move to digital
</h2>To manage the huge volumes of charts and develop better reports on patient care, AMPATH helped develop an open-source electronic medical record called OpenMRS. Launched in 2006, <a href="https://en.wikipedia.org/wiki/OpenMRS">OpenMRS</a> is currently used in over 60 countries around the world.
By 2015, widespread affordable cellular networks and affordably priced tablets allowed AMPATH to deploy an implementation of OpenMRS designed to run on tablets, called the <a href="http://www.gregoryschmidt.ca/writing/history-of-ampath-medical-record-system">AMPATH Medical Record System</a> (AMRS), which was designed for use during clinical appointments.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/bltdd370567952f5040/5d5da51b5b220072e8aa2b37/ampath-amrs-blog.jpg" data-sys-asset-uid="bltdd370567952f5040" alt="AMPATH Medical Records System" style="display: block; margin: auto;">
<h3>Moving to the Elastic Stack
</h3>Every day hundreds of providers across Western Kenya use AMRS. This results in a huge amount of data that needs to be managed and made available to key decision makers such as clinicians, clinic administrators, and the Ministry of Health.
Initially, AMPATH <a href="http://www.gregoryschmidt.ca/writing/ampath-ehr-current-data-capabilities">wrote custom code for each new visualization</a> and each new dashboard. The trouble is this took a lot of developer time, the visualizations created were slow to load, and they were hard to debug.
Stakeholders often requested new data visualizations, and it was hard to keep up with the demand using custom code. There was also interest in finding a tool to allow everyone to design their own visualizations, which would help them to better leverage their data and would free up developers’ time.
AMPATH required a solution that could handle a lot of data. The database has almost 8 million visit encounters, with 250 million clinical questions asked.
The Elastic Stack stood out as the right tool. It can handle large data sets and has an easy-to-use interface, a wide feature set, a great community with good documentation, and pricing aligned with AMPATH’s needs.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt92c9d5808c9d1497/5d5da561999e83431b7656d8/ampath-stats-blog.jpg" data-sys-asset-uid="blt92c9d5808c9d1497" alt="AMPATH data and statistics" style="display: block; margin: auto;">
<h2>AMPATH’s ETL process
</h2>In 2017 AMPATH started development on an extract, transform, load (ETL) process to move data from the electronic medical record MySQL database, through Logstash, into Elasticsearch. Kibana is then used to generate dashboards.
Let's look at the process in the real world.
<h3>Data collection
</h3>Clinicians use AMPATH’s application on their tablet’s web browser during the clinical visit. The application is built in Angular and stores data in a MySQL database exposed via a REST API in OpenMRS.
<h3>Data storage and ETL
</h3>To make reporting easier, the relational tables are flattened using the ETL process. <a href="https://github.com/AMPATH/etl">SQL scripts</a> extract the desired data by performing joins on several tables. The data is then transformed into a form that answers the questions asked (e.g., is this patient currently on antiretroviral drugs?). A SQL scripts then loads the transformed data into a MySQL table. This is now a flattened table.
Each flattened table represents a report. These reports are distributed to different decision makers and users.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt70e6f994770a02a8/5d5daad765c1577f11a494ba/ampath-diagram-blog.jpg" data-sys-asset-uid="blt70e6f994770a02a8" alt="AMPATH data pipeline" style="display: block; margin: auto;">
<h3>Ingestion into Elasticsearch
</h3>After the flattened data is stored in MySQL tables, it is ready to be consumed by Elasticsearch. This is done with Logstash. One of the benefits of Logstash is its ability to consume data from a variety of data sources.
Logstash consumes the MySQL data and pumps it into Elasticsearch in real time using the <a href="https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html">JDBC input plugin</a>. This plugin supports scheduling and selective data as input by using SQL queries. Each row in the MySQL table is considered a single event, and the columns in each row (event) are considered fields in the event.
<a href="https://medium.com/@fatmali/https-medium-com-fatmali-how-to-setup-a-docker-elk-elastic-logstash-kibana-stack-in-a-jiffy-ab56e2660416">AMPATH’s Elastic Stack is set up on a separate server from MySQL</a> using <a href="https://www.docker.com/">Docker</a>. AMPATH’s <a href="https://gist.github.com/Fatmali/c860f6046f821208a9af55bec49928c9">Logstash</a> config file is used to query the MySQL tables. Check out <a href="https://qbox.io/blog/migrating-mysql-data-into-elasticsearch-using-logstash">this blog post</a> for more details on AMPATH’s Logstash process.
<h2>Kibana visualizations
</h2>AMPATH started building Kibana visualizations in 2018 with a dedicated team, expanding the visualization component library, building new dashboards, and training new users on how to use Kibana.
These visualizations will be used by clinicians, clinic administrators, and key decision makers in AMPATH and the Ministry of Health.
Below are some examples of system monitoring Kibana dashboards currently in use.
90-90-90 Trend Analysis Dashboard
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt01b888705a604cf5/5d5da6abac511e7362584693/ampath-trend-analysis-blog.jpg" data-sys-asset-uid="blt01b888705a604cf5" alt="ampath-trend-analysis-blog.jpg">
 
Overview of trends of HIV viral suppression in a clinic
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt8d1ab99f9386299e/5d5daa482372b57f91ccc125/ampath-vl-analysis-blog.jpg" data-sys-asset-uid="blt8d1ab99f9386299e" alt="Dashboard showing HIV viral load suppression" style="display: block; margin: auto;">
 
Using these charts to view the trends, the clinicians and the management of a clinic can check if a patient's HIV treatment is meeting international targets. This is a critical indicators for clinics.
Control of HIV viral load suppression (an indicator of HIV treatment control), compared across multiple counties
	
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blte4e5bb799f042884/5d5da81465c1577f11a49498/ampath-vl-to-target-blog.jpg" data-sys-asset-uid="blte4e5bb799f042884" alt="HIV viral load suppression compared to target rates" style="display: block; margin: auto;">
 
Comparison of HIV viral load suppression with target rates
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt1db0b2340648f3ba/5d5da8ca3f108672e37b00aa/ampath-vl-suppression-blog.jpg" data-sys-asset-uid="blt1db0b2340648f3ba" alt="HIV viral load suppression compared to target rates." style="display: block; margin: auto;">
 

	Utilizing anomaly detection in server response times with machine learning
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt8394c9a1ad7d6d27/5d5da8f7c0e6e77f8baf24f7/ampath-uptime-blog.jpg" data-sys-asset-uid="blt8394c9a1ad7d6d27" alt="AMPATH uptime monitoring" style="display: block; margin: auto;">
 

	While AMPATH’s primary use case is monitoring and visualizing HIV-related health data, it also use the Elastic Stack for a variety of other uses, including uptime monitoring and log analytics.

	Generating dashboards on the fly is a request AMPATH devs face on a daily basis. Before Kibana, this process was long and tedious, taking several weeks to code and produce visualizations that were often slow as they involved fetching data from a relational database. With Kibana, the AMPATH visualization team is able to create visualizations on the fly and embed them to the EMR. Users can then view and query the visualizations efficiently and quickly.
HIV Daily Clinic Overview Dashboard - overview of the HIV care system
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt051542fb3689a6f6/5d5da92f3f108672e37b00b8/ampath-clinic-overview-blog.jpg" data-sys-asset-uid="blt051542fb3689a6f6" alt="AMPATH clinic overview" style="display: block; margin: auto;">
 
The following dashboard is helpful for administration to know which locations may have long waits.
HIV Daily Clinic Overview Dashboard - comparing the average wait time to see clinicians
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt56be5a2789fd8944/5d5da959999e83431b76570c/ampath-clinic-encounters-blog.jpg" data-sys-asset-uid="blt56be5a2789fd8944" alt="AMPATH clinic encounters dashboard" style="display: block; margin: auto;">
 
<h2>Next steps
</h2>This coming year AMPATH would like to expand its dashboards to cover new disease verticals, and train users to be able to build their own Kibana visualizations. We also hope to expand the use of Elastic’s machine learning features for monitoring system performance.
<hr>Elastic has been an indispensable part of AMPATH’s mission to provide healthcare in low-resource settings. As AMPATH continues to expand its care system, there is no doubt that the success in patient care is linked to timely accessible to data. This is made possible with the Elastic Stack.
Authors’ Bios
	
Fatma Ali is a full stack developer in Eldoret, Kenya and is AMPATH’s ETL lead (<a href="https://medium.com/@fatmali">https://medium.com/@fatmali</a>)
Susan Mastamet is AMPATH’s visualization lead in Eldoret, Kenya.
Gregory Schmidt, MD designs medical record systems with AMPATH. (<a href="http://www.gregoryschmidt.ca">www.gregoryschmidt.ca</a> @_GregSchmidt)
Jonathan Dick, MD is the Chief Medical Information Officer at AMPATH.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/bltfd2924fb5224b866/5d5da97e999e83431b765712/ampath-team-photo-blog.jpg" data-sys-asset-uid="bltfd2924fb5224b866" alt="AMRS team photo" style="display: block; margin: auto;">
<figcaption>
AMRS Team
</figcaption>

Ampath-Banner.jpg

Ampath-thumbnail.jpg

AMPATH: Providing healthcare in rural Kenya using the Elastic Stack

Start free trial

Blog Footer CTA

Sign up for Elastic Cloud free trial

AMPATH medical record team

By submitting you acknowledge that you've read and agree to our <a href="/legal/elastic-cloud-account-terms" target="_self">Terms of Service</a>, and you agree to receive the <a href="/legal/privacy-statement#how-we-use-the-information" target="_self">selected communications</a> at the contact details you provided above. See <a href="/legal/privacy-statement/" target="_self">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Communication Preferences - ONLY for /communication-preferences

提交即表示您确认您已阅读并同意我们的<a href="/cn/legal/elastic-cloud-account-terms" target="_self">服务条款</a>，并且您同意通过您提供的上述联系方式接收<a href="/cn/legal/privacy-statement#how-we-use-the-information" target="_self">所选的通信</a>。如需了解更多信息，或想随时取消订阅，请参阅 <a href="/cn/legal/privacy-statement/" target="_self">Elastic 的隐私声明</a>。

By submitting you acknowledge that you've read and agree to our <a href="/legal/serverless-preview-terms" target="_blank">Terms of Service</a>, and that Elastic may <a href="/legal/privacy-statement#how-we-use-the-information" target="_blank">contact you</a> about our related products and services, using the details you provide above. See <a href="/legal/privacy-statement/" target="_blank">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Serverless GDPR Text

提交即表示您确认您已阅读并同意我们的<a href="/cn/legal/serverless-preview-terms" target="_self">服务条款</a>，并且 Elastic 可以使用您提供的上述详细信息与您联系，以向您介绍我们相关的<a href="/cn/legal/privacy-statement#how-we-use-the-information" target="_self">产品和服务</a>。如需了解更多信息，或想随时取消订阅，请参阅 <a href="/cn/legal/privacy-statement/" target="_self">Elastic 的隐私声明</a>。

By submitting you agree to <a href="/agreements/global/cloud-services-monthly" rel="nofollow">Elastic Cloud Terms of Service</a>. Your personal data will be processed in accordance with <a href="/legal/privacy-statement">Elastic's Privacy Statement</a>.

Cloud Trial GDPR Text

提交即表示您同意 <a href="/cn/agreements/global/cloud-services-monthly" rel="nofollow">Elastic Cloud 服务条款</a>。我们将会按照 <a href="/cn/legal/privacy-statement">Elastic 的隐私声明</a>处理您的个人数据。

By submitting you acknowledge that you've read and agree to our <a href="/legal/terms-of-use" target="_blank">Terms of Service</a>, and that Elastic may <a href="/legal/privacy-statement#how-we-use-the-information" target="_blank">contact you</a> about our related products and services, using the details you provide above. See <a href="/legal/privacy-statement/" target="_blank">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Newsletter GDPR Text

提交即表示您确认您已阅读并同意我们的<a href="/cn/legal/terms-of-use" target="_self">服务条款</a>，并且 Elastic 可以使用您提供的上述详细信息与您联系，以向您介绍我们相关的<a href="/cn/legal/privacy-statement#how-we-use-the-information" target="_self">产品和服务</a>。如需了解更多信息，或想随时取消订阅，请参阅 <a href="/cn/legal/privacy-statement/" target="_self">Elastic 的隐私声明</a>。

Explore similar demos

Overview

Speakers

Close

See more insights

The content on this page is not available in the selected language. As Elastic grows globally, we continue to support content in multiple languages.

The content on this page is not available in the selected language.

本页内容尚不支持所选语言。Elastic 正在不断努力，以实现对多种语言内容的支持。感谢您在此期间给予的耐心与陪伴！

Author

Articles by

Learn more

Watch now (no PT)

Watch now

See all top stories

All (no PT translation)

Contact information

Press Release

Share on Reddit

Share this story

Share by Email

Thank you for your interest!

Contact Info

Follow us on Youtube

Load More

Share on LinkedIn

Follow us on LinkedIn

Search Integrations

All Solutions

Video for

Follow us on Twitter

See when this webinar starts in my time zone

查看本次网络研讨会在我的时区的开始时间

Register to Watch

Register now

See All Posts

Can't make it? Register and we'll send you the recording. You'll also receive an email with related content

无法实时参加？注册后我们会给您发送录像。您还将收到相关内容的电子邮件。

Author

Articles by AMPATH medical record team

AMPATH: Providing healthcare in rural Kenya using the Elastic Stack

Sign up for Elastic Cloud free trial